[Home] [Help]
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
1045: AND CAL.AE_HEADER_ID = CAH.AE_HEADER_ID
1046: AND CAH.GL_TRANSFER_FLAG = 'Y'
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
1185: WHERE CAL.CODE_COMBINATION_ID = CAA.ACCRUAL_ACCOUNT_ID
1186: AND CAL.AE_HEADER_ID = CAH.AE_HEADER_ID
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
2262: WHERE CAA.REQUEST_ID = P_CONC_REQUEST_ID
2263: AND CAL.CODE_COMBINATION_ID = CAA.ACCRUAL_ACCOUNT_ID
2264: AND CAL.AE_HEADER_ID = CAH.AE_HEADER_ID
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,
2413: CST_PAC_ACCRUAL_ACCOUNTS_TEMP CAA
2414: WHERE CAA.REQUEST_ID = P_CONC_REQUEST_ID
2415: AND CAL.CODE_COMBINATION_ID = CAA.ACCRUAL_ACCOUNT_ID
2901: P_LEGAL_ENTITY,
2902: P_PERIOD
2903: FROM
2904: CST_AE_HEADERS CAH,
2905: CST_AE_LINES CAL,
2906: MTL_MATERIAL_TRANSACTIONS MMT,
2907: MTL_TRANSACTION_TYPES MTT,
2908: MTL_SYSTEM_ITEMS MSI,
2909: CST_PAC_ACCRUAL_ACCOUNTS_TEMP CAA
3035: P_LEGAL_ENTITY,
3036: P_PERIOD
3037: FROM
3038: CST_AE_HEADERS CAH,
3039: CST_AE_LINES CAL,
3040: WIP_TRANSACTIONS WTS,
3041: MFG_LOOKUPS MFL,
3042: CST_PAC_ACCRUAL_ACCOUNTS_TEMP CAA
3043: WHERE CAA.REQUEST_ID = P_CONC_REQUEST_ID