DBA Data[Home] [Help]

APPS.BOM_CSTRACCR_XMLP_PKG dependencies on PO_LOOKUP_CODES

Line 273: FROM PO_LOOKUP_CODES PLU

269:
270: /* Added for Perf Bug 7563374 rgangara */
271: SELECT displayed_field
272: INTO l_disp_field
273: FROM PO_LOOKUP_CODES PLU
274: WHERE LOOKUP_TYPE = 'ACCRUAL TYPE'
275: AND LOOKUP_CODE = 'AP INVOICE PRICE VAR';
276:
277: INSERT INTO CST_PAC_ACCRUAL_RECONCILE_TEMP

Line 440: FROM PO_LOOKUP_CODES PLU

436:
437: /* Added for Perf bug 7563374 rgangara */
438: SELECT displayed_field
439: INTO l_disp_field
440: FROM PO_LOOKUP_CODES PLU
441: WHERE LOOKUP_TYPE = 'ACCRUAL TYPE'
442: AND PLU.LOOKUP_CODE = 'AP EXCHANGE RATE VAR';
443:
444:

Line 1033: PO_LOOKUP_CODES PLC,

1029: P_COST_GROUP,
1030: P_LEGAL_ENTITY,
1031: P_PERIOD
1032: FROM
1033: PO_LOOKUP_CODES PLC,
1034: RCV_SHIPMENT_HEADERS RSH,
1035: PO_VENDORS POV,
1036: PO_HEADERS_ALL POH,
1037: PO_LINES_ALL POL,

Line 1173: PO_LOOKUP_CODES PLC,

1169: P_COST_GROUP,
1170: P_LEGAL_ENTITY,
1171: P_PERIOD
1172: FROM
1173: PO_LOOKUP_CODES PLC,
1174: RCV_SHIPMENT_HEADERS RSH,
1175: PO_VENDORS POV,
1176: PO_HEADERS_ALL POH,
1177: PO_LINES_ALL POL,

Line 1232: PO_LOOKUP_CODES

1228: SET
1229: ACCRUAL_CODE = (SELECT
1230: DISPLAYED_FIELD
1231: FROM
1232: PO_LOOKUP_CODES
1233: WHERE LOOKUP_TYPE = 'ACCRUAL TYPE'
1234: AND LOOKUP_CODE = 'AP PO MATCH')
1235: WHERE ACCRUAL_CODE = 'AP: not yet processed'
1236: AND P1.LEGAL_ENTITY_ID = P_LEGAL_ENTITY

Line 1275: PO_LOOKUP_CODES

1271: SET
1272: ACCRUAL_CODE = (SELECT
1273: DISPLAYED_FIELD
1274: FROM
1275: PO_LOOKUP_CODES
1276: WHERE LOOKUP_TYPE = 'ACCRUAL TYPE'
1277: AND LOOKUP_CODE = 'AP ITEM MATCH')
1278: WHERE ACCRUAL_CODE = 'AP: not yet processed'
1279: AND P1.LEGAL_ENTITY_ID = P_LEGAL_ENTITY

Line 1315: PO_LOOKUP_CODES

1311: SET
1312: ACCRUAL_CODE = (SELECT
1313: DISPLAYED_FIELD
1314: FROM
1315: PO_LOOKUP_CODES
1316: WHERE LOOKUP_TYPE = 'ACCRUAL TYPE'
1317: AND LOOKUP_CODE = 'AP LINE MATCH')
1318: WHERE ACCRUAL_CODE = 'AP: not yet processed'
1319: AND DESTINATION_TYPE_CODE in ( 'SHOP FLOOR' , 'INVENTORY' , 'EXPENSE' )

Line 1360: PO_LOOKUP_CODES

1356: SET
1357: ACCRUAL_CODE = (SELECT
1358: DISPLAYED_FIELD
1359: FROM
1360: PO_LOOKUP_CODES
1361: WHERE LOOKUP_TYPE = 'ACCRUAL TYPE'
1362: AND LOOKUP_CODE = 'AP NO MATCH')
1363: WHERE ACCRUAL_CODE = 'AP: not yet processed'
1364: AND PO_HEADER_ID IS NOT NULL

Line 1390: PO_LOOKUP_CODES

1386: SET
1387: ACCRUAL_CODE = (SELECT
1388: DISPLAYED_FIELD
1389: FROM
1390: PO_LOOKUP_CODES
1391: WHERE LOOKUP_TYPE = 'ACCRUAL TYPE'
1392: AND LOOKUP_CODE = 'AP NO ITEM')
1393: ,INVOICE_PRICE_VARIANCE = (-1) * TRANSACTION_AMOUNT
1394: WHERE ACCRUAL_CODE = 'AP: not yet processed'

Line 1428: PO_LOOKUP_CODES

1424: SET
1425: ACCRUAL_CODE = (SELECT
1426: DISPLAYED_FIELD
1427: FROM
1428: PO_LOOKUP_CODES
1429: WHERE LOOKUP_TYPE = 'ACCRUAL TYPE'
1430: AND LOOKUP_CODE = 'AP NO PO')
1431: ,INVOICE_PRICE_VARIANCE = (-1) * TRANSACTION_AMOUNT
1432: WHERE ACCRUAL_CODE = 'AP: not yet processed'

Line 2252: PO_LOOKUP_CODES PLC,

2248: P_COST_GROUP,
2249: P_LEGAL_ENTITY,
2250: P_PERIOD
2251: FROM
2252: PO_LOOKUP_CODES PLC,
2253: PO_VENDORS POV,
2254: PO_LINES_ALL POL,
2255: PO_HEADERS_ALL POH,
2256: RCV_SHIPMENT_HEADERS RSH,

Line 2407: PO_LOOKUP_CODES PLC,

2403: FROM
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,

Line 2514: PO_LOOKUP_CODES PLC1,

2510: INTO P_COMPANY,P_CURRENCY_CODE,LP_CHART_OF_ACCOUNTS_ID,ROUND_UNIT,P_EXT_PREC,P_SORT_BY,P_ITEM_VENDOR
2511: FROM
2512: GL_LEDGER_LE_V GLL,
2513: FND_CURRENCIES FC,
2514: PO_LOOKUP_CODES PLC1,
2515: PO_LOOKUP_CODES PLC2
2516: WHERE GLL.LEGAL_ENTITY_ID = P_LEGAL_ENTITY
2517: AND GLL.LEDGER_CATEGORY_CODE = 'PRIMARY'
2518: AND GLL.RELATIONSHIP_ENABLED_FLAG = 'Y'

Line 2515: PO_LOOKUP_CODES PLC2

2511: FROM
2512: GL_LEDGER_LE_V GLL,
2513: FND_CURRENCIES FC,
2514: PO_LOOKUP_CODES PLC1,
2515: PO_LOOKUP_CODES PLC2
2516: WHERE GLL.LEGAL_ENTITY_ID = P_LEGAL_ENTITY
2517: AND GLL.LEDGER_CATEGORY_CODE = 'PRIMARY'
2518: AND GLL.RELATIONSHIP_ENABLED_FLAG = 'Y'
2519: AND GLL.CURRENCY_CODE = FC.CURRENCY_CODE

Line 2737: PO_LOOKUP_CODES

2733: SET
2734: ACCRUAL_CODE = (SELECT
2735: DISPLAYED_FIELD
2736: FROM
2737: PO_LOOKUP_CODES
2738: WHERE LOOKUP_TYPE = 'ACCRUAL TYPE'
2739: AND LOOKUP_CODE = 'AP RECEIPT MATCH')
2740: WHERE ACCRUAL_CODE = 'AP: not yet processed'
2741: AND RECEIPT_NUM IS NOT NULL