APPS.BOM_CSTRACCR_XMLP_PKG dependencies on PO_LOOKUP_CODES

Line 274: FROM PO_LOOKUP_CODES PLU

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

Line 442: FROM PO_LOOKUP_CODES PLU

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

Line 1038: PO_LOOKUP_CODES PLC,

1034: P_COST_GROUP,
1035: P_LEGAL_ENTITY,
1036: P_PERIOD
1037: FROM
1038: PO_LOOKUP_CODES PLC,
1039: RCV_SHIPMENT_HEADERS RSH,
1040: PO_VENDORS POV,
1041: PO_HEADERS_ALL POH,
1042: PO_LINES_ALL POL,

Line 1178: PO_LOOKUP_CODES PLC,

1174: P_COST_GROUP,
1175: P_LEGAL_ENTITY,
1176: P_PERIOD
1177: FROM
1178: PO_LOOKUP_CODES PLC,
1179: RCV_SHIPMENT_HEADERS RSH,
1180: PO_VENDORS POV,
1181: PO_HEADERS_ALL POH,
1182: PO_LINES_ALL POL,

Line 1237: PO_LOOKUP_CODES

1233: SET
1234: ACCRUAL_CODE = (SELECT
1235: DISPLAYED_FIELD
1236: FROM
1237: PO_LOOKUP_CODES
1238: WHERE LOOKUP_TYPE = 'ACCRUAL TYPE'
1239: AND LOOKUP_CODE = 'AP PO MATCH')
1240: WHERE ACCRUAL_CODE = 'AP: not yet processed'
1241: AND P1.LEGAL_ENTITY_ID = P_LEGAL_ENTITY

Line 1280: PO_LOOKUP_CODES

1276: SET
1277: ACCRUAL_CODE = (SELECT
1278: DISPLAYED_FIELD
1279: FROM
1280: PO_LOOKUP_CODES
1281: WHERE LOOKUP_TYPE = 'ACCRUAL TYPE'
1282: AND LOOKUP_CODE = 'AP ITEM MATCH')
1283: WHERE ACCRUAL_CODE = 'AP: not yet processed'
1284: AND P1.LEGAL_ENTITY_ID = P_LEGAL_ENTITY

Line 1320: PO_LOOKUP_CODES

1316: SET
1317: ACCRUAL_CODE = (SELECT
1318: DISPLAYED_FIELD
1319: FROM
1320: PO_LOOKUP_CODES
1321: WHERE LOOKUP_TYPE = 'ACCRUAL TYPE'
1322: AND LOOKUP_CODE = 'AP LINE MATCH')
1323: WHERE ACCRUAL_CODE = 'AP: not yet processed'
1324: AND DESTINATION_TYPE_CODE in ( 'SHOP FLOOR' , 'INVENTORY' , 'EXPENSE' )

Line 1365: PO_LOOKUP_CODES

1361: SET
1362: ACCRUAL_CODE = (SELECT
1363: DISPLAYED_FIELD
1364: FROM
1365: PO_LOOKUP_CODES
1366: WHERE LOOKUP_TYPE = 'ACCRUAL TYPE'
1367: AND LOOKUP_CODE = 'AP NO MATCH')
1368: WHERE ACCRUAL_CODE = 'AP: not yet processed'
1369: AND PO_HEADER_ID IS NOT NULL

Line 1395: PO_LOOKUP_CODES

1391: SET
1392: ACCRUAL_CODE = (SELECT
1393: DISPLAYED_FIELD
1394: FROM
1395: PO_LOOKUP_CODES
1396: WHERE LOOKUP_TYPE = 'ACCRUAL TYPE'
1397: AND LOOKUP_CODE = 'AP NO ITEM')
1398: ,INVOICE_PRICE_VARIANCE = (-1) * TRANSACTION_AMOUNT
1399: WHERE ACCRUAL_CODE = 'AP: not yet processed'

Line 1433: PO_LOOKUP_CODES

1429: SET
1430: ACCRUAL_CODE = (SELECT
1431: DISPLAYED_FIELD
1432: FROM
1433: PO_LOOKUP_CODES
1434: WHERE LOOKUP_TYPE = 'ACCRUAL TYPE'
1435: AND LOOKUP_CODE = 'AP NO PO')
1436: ,INVOICE_PRICE_VARIANCE = (-1) * TRANSACTION_AMOUNT
1437: WHERE ACCRUAL_CODE = 'AP: not yet processed'

Line 2257: PO_LOOKUP_CODES PLC,

2253: P_COST_GROUP,
2254: P_LEGAL_ENTITY,
2255: P_PERIOD
2256: FROM
2257: PO_LOOKUP_CODES PLC,
2258: PO_VENDORS POV,
2259: PO_LINES_ALL POL,
2260: PO_HEADERS_ALL POH,
2261: RCV_SHIPMENT_HEADERS RSH,

Line 2412: PO_LOOKUP_CODES PLC,

2408: FROM
2409: PO_HEADERS_ALL POH,
2410: PO_LINES_ALL POL,
2411: PO_VENDORS POV,
2412: PO_LOOKUP_CODES PLC,
2413: RCV_TRANSACTIONS RCT,
2414: RCV_SHIPMENT_HEADERS RSH,
2415: CST_AE_HEADERS CAH,
2416: CST_AE_LINES CAL,

Line 2519: PO_LOOKUP_CODES PLC1,

2515: INTO P_COMPANY,P_CURRENCY_CODE,LP_CHART_OF_ACCOUNTS_ID,ROUND_UNIT,P_EXT_PREC,P_SORT_BY,P_ITEM_VENDOR
2516: FROM
2517: GL_LEDGER_LE_V GLL,
2518: FND_CURRENCIES FC,
2519: PO_LOOKUP_CODES PLC1,
2520: PO_LOOKUP_CODES PLC2
2521: WHERE GLL.LEGAL_ENTITY_ID = P_LEGAL_ENTITY
2522: AND GLL.LEDGER_CATEGORY_CODE = 'PRIMARY'
2523: AND GLL.RELATIONSHIP_ENABLED_FLAG = 'Y'

Line 2520: PO_LOOKUP_CODES PLC2

2516: FROM
2517: GL_LEDGER_LE_V GLL,
2518: FND_CURRENCIES FC,
2519: PO_LOOKUP_CODES PLC1,
2520: PO_LOOKUP_CODES PLC2
2521: WHERE GLL.LEGAL_ENTITY_ID = P_LEGAL_ENTITY
2522: AND GLL.LEDGER_CATEGORY_CODE = 'PRIMARY'
2523: AND GLL.RELATIONSHIP_ENABLED_FLAG = 'Y'
2524: AND GLL.CURRENCY_CODE = FC.CURRENCY_CODE

Line 2742: PO_LOOKUP_CODES

2738: SET
2739: ACCRUAL_CODE = (SELECT
2740: DISPLAYED_FIELD
2741: FROM
2742: PO_LOOKUP_CODES
2743: WHERE LOOKUP_TYPE = 'ACCRUAL TYPE'
2744: AND LOOKUP_CODE = 'AP RECEIPT MATCH')
2745: WHERE ACCRUAL_CODE = 'AP: not yet processed'
2746: AND RECEIPT_NUM IS NOT NULL