711: FROM
712: AP_INVOICES_ALL API,
713: AP_INVOICE_DISTRIBUTIONS_ALL AID,
714: PO_VENDORS POV,
715: RCV_TRANSACTIONS RT,
716: RCV_SHIPMENT_HEADERS RSH,
717: PO_LINES_ALL POL,
718: PO_LINE_LOCATIONS_ALL POLL,
719: PO_HEADERS_ALL POH,
1036: PO_HEADERS_ALL POH,
1037: PO_LINES_ALL POL,
1038: PO_LINE_LOCATIONS_ALL POLL,
1039: PO_DISTRIBUTIONS_ALL POD,
1040: RCV_TRANSACTIONS RCT,
1041: CST_AE_HEADERS CAH,
1042: CST_AE_LINES CAL,
1043: CST_PAC_ACCRUAL_ACCOUNTS_TEMP CAA
1044: WHERE CAL.CODE_COMBINATION_ID = CAA.ACCRUAL_ACCOUNT_ID
1176: PO_HEADERS_ALL POH,
1177: PO_LINES_ALL POL,
1178: PO_LINE_LOCATIONS_ALL POLL,
1179: PO_DISTRIBUTIONS_ALL POD,
1180: RCV_TRANSACTIONS RCT,
1181: CST_AE_HEADERS CAH,
1182: CST_AE_LINES CAL,
1183: CST_PAC_ACCRUAL_ACCOUNTS_TEMP CAA,
1184: RCV_ACCOUNTING_EVENTS RAE
2253: PO_VENDORS POV,
2254: PO_LINES_ALL POL,
2255: PO_HEADERS_ALL POH,
2256: RCV_SHIPMENT_HEADERS RSH,
2257: RCV_TRANSACTIONS RCT,
2258: MTL_MATERIAL_TRANSACTIONS MMT,
2259: CST_AE_HEADERS CAH,
2260: CST_AE_LINES CAL,
2261: CST_PAC_ACCRUAL_ACCOUNTS_TEMP CAA
2404: PO_HEADERS_ALL POH,
2405: PO_LINES_ALL POL,
2406: PO_VENDORS POV,
2407: PO_LOOKUP_CODES PLC,
2408: RCV_TRANSACTIONS RCT,
2409: RCV_SHIPMENT_HEADERS RSH,
2410: CST_AE_HEADERS CAH,
2411: CST_AE_LINES CAL,
2412: WIP_TRANSACTIONS WTS,
2459: DISTINCT
2460: POH.ORG_ID
2461: FROM
2462: CST_COST_GROUP_ASSIGNMENTS CCGA,
2463: RCV_TRANSACTIONS RT,
2464: PO_HEADERS_ALL POH
2465: WHERE POH.PO_HEADER_ID = RT.PO_HEADER_ID
2466: AND CCGA.ORGANIZATION_ID = RT.ORGANIZATION_ID
2467: AND CCGA.COST_GROUP_ID = P_COST_GROUP;