Regarding the join conditions for the tables
Posted: 13 November 2008 02:26 PM   [ Ignore ]
Newbie
Rank
Total Posts:  1
Joined  2008-11-13

Hi All,
I’m new for Oracle Apps.
I need to develop a report using the following tables and its columns(mentioned in brackets):

HR_OPERATING_UNITS (NAME)
AP_INVOICES(INVOICE_NUM)
PO_VENDORS(VENDOR_ID)
PER_ALL_PEOPLE_F(FULL_NAME)
FND_USER(USER_NAME)
RCV_SHIPMENT_HEADERS(RECEIPT_NUM)
PO_DISTRIBUTIONS(REQ_HEADER_REFERENCE_NUM)
RCV_SHIPMENT_LINES(PACKING_SLIP)
PO_HEADERS(SEGMENT1)

Can u plz help me regarding the join conditions for these tables

Profile