eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BOM_CSTRACCR_XMLP_PKG dependencies on CST_PAC_ACCRUAL_RECONCILE_TEMP

Line 33: LOCK TABLE CST_PAC_ACCRUAL_RECONCILE_TEMP IN EXCLUSIVE MODE NOWAIT;

29: BEGIN
30: /*SRW.MESSAGE(101
31: ,'delete_table() << ' || TO_CHAR(SYSDATE
32: ,'Dy Mon FmDD HH24:MI:SS YYYY'))*/NULL;
33: LOCK TABLE CST_PAC_ACCRUAL_RECONCILE_TEMP IN EXCLUSIVE MODE NOWAIT;
34: DELETE FROM CST_PAC_ACCRUAL_RECONCILE_TEMP
35: WHERE LEGAL_ENTITY_ID = P_LEGAL_ENTITY
36: AND COST_TYPE_ID = P_COST_TYPE
37: AND COST_GROUP_ID = P_COST_GROUP;

Line 34: DELETE FROM CST_PAC_ACCRUAL_RECONCILE_TEMP

30: /*SRW.MESSAGE(101
31: ,'delete_table() << ' || TO_CHAR(SYSDATE
32: ,'Dy Mon FmDD HH24:MI:SS YYYY'))*/NULL;
33: LOCK TABLE CST_PAC_ACCRUAL_RECONCILE_TEMP IN EXCLUSIVE MODE NOWAIT;
34: DELETE FROM CST_PAC_ACCRUAL_RECONCILE_TEMP
35: WHERE LEGAL_ENTITY_ID = P_LEGAL_ENTITY
36: AND COST_TYPE_ID = P_COST_TYPE
37: AND COST_GROUP_ID = P_COST_GROUP;
38: DELETE FROM CST_PAC_ACCRUAL_ACCOUNTS_TEMP

Line 118: INSERT INTO CST_PAC_ACCRUAL_RECONCILE_TEMP

114:
115: PROCEDURE INSERT_AP_DATA IS
116: l_disp_field VARCHAR2(80);
117: BEGIN
118: INSERT INTO CST_PAC_ACCRUAL_RECONCILE_TEMP
119: (REQUEST_ID
120: ,PROGRAM_APPLICATION_ID
121: ,PROGRAM_ID
122: ,PROGRAM_UPDATE_DATE

Line 277: INSERT INTO CST_PAC_ACCRUAL_RECONCILE_TEMP

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
278: (REQUEST_ID
279: ,PROGRAM_APPLICATION_ID
280: ,PROGRAM_ID
281: ,PROGRAM_UPDATE_DATE

Line 445: INSERT INTO CST_PAC_ACCRUAL_RECONCILE_TEMP

441: WHERE LOOKUP_TYPE = 'ACCRUAL TYPE'
442: AND PLU.LOOKUP_CODE = 'AP EXCHANGE RATE VAR';
443:
444:
445: INSERT INTO CST_PAC_ACCRUAL_RECONCILE_TEMP
446: (REQUEST_ID
447: ,PROGRAM_APPLICATION_ID
448: ,PROGRAM_ID
449: ,PROGRAM_UPDATE_DATE

Line 597: INSERT INTO CST_PAC_ACCRUAL_RECONCILE_TEMP

593: OR AIDA.AMOUNT <> 0 ) )
594: AND XAH.LEDGER_ID = P_SET_OF_BOOKS_ID
595: /*Support for LCM*/
596: AND NVL(POLL.LCM_FLAG,'N') = 'N';
597: INSERT INTO CST_PAC_ACCRUAL_RECONCILE_TEMP
598: (REQUEST_ID
599: ,PROGRAM_APPLICATION_ID
600: ,PROGRAM_ID
601: ,PROGRAM_UPDATE_DATE

Line 767: INSERT INTO CST_PAC_ACCRUAL_RECONCILE_TEMP

763: END INSERT_AP_DATA;
764:
765: PROCEDURE INSERT_AP_MISC IS
766: BEGIN
767: INSERT INTO CST_PAC_ACCRUAL_RECONCILE_TEMP
768: (REQUEST_ID
769: ,PROGRAM_APPLICATION_ID
770: ,PROGRAM_ID
771: ,PROGRAM_UPDATE_DATE

Line 920: INSERT INTO CST_PAC_ACCRUAL_RECONCILE_TEMP

916: END INSERT_AP_MISC;
917:
918: PROCEDURE INSERT_PO_DATA IS
919: BEGIN
920: INSERT INTO CST_PAC_ACCRUAL_RECONCILE_TEMP
921: (REQUEST_ID
922: ,PROGRAM_APPLICATION_ID
923: ,PROGRAM_ID
924: ,PROGRAM_UPDATE_DATE

Line 1070: INSERT INTO CST_PAC_ACCRUAL_RECONCILE_TEMP

1066: ,POV.VENDOR_NAME)
1067: AND CAH.SET_OF_BOOKS_ID = P_SET_OF_BOOKS_ID
1068: /*Support for LCM*/
1069: AND nvl(cal.ae_line_type_code,'16') <> '38';
1070: INSERT INTO CST_PAC_ACCRUAL_RECONCILE_TEMP
1071: (REQUEST_ID
1072: ,PROGRAM_APPLICATION_ID
1073: ,PROGRAM_ID
1074: ,PROGRAM_UPDATE_DATE

Line 1227: CST_PAC_ACCRUAL_RECONCILE_TEMP p1

1223:
1224: PROCEDURE MATCH_INV_HEADER IS
1225: BEGIN
1226: UPDATE
1227: CST_PAC_ACCRUAL_RECONCILE_TEMP p1
1228: SET
1229: ACCRUAL_CODE = (SELECT
1230: DISPLAYED_FIELD
1231: FROM

Line 1243: CST_PAC_ACCRUAL_RECONCILE_TEMP P2

1239: AND EXISTS (
1240: SELECT
1241: null
1242: FROM
1243: CST_PAC_ACCRUAL_RECONCILE_TEMP P2
1244: WHERE P2.INVOICE_ID is null
1245: AND ( P2.INVENTORY_ITEM_ID = P1.INVENTORY_ITEM_ID
1246: OR ( P2.INVENTORY_ITEM_ID is NULL
1247: AND P2.DESTINATION_TYPE_CODE = 'EXPENSE' ) )

Line 1270: CST_PAC_ACCRUAL_RECONCILE_TEMP p1

1266:
1267: PROCEDURE MATCH_INV_ITEM IS
1268: BEGIN
1269: UPDATE
1270: CST_PAC_ACCRUAL_RECONCILE_TEMP p1
1271: SET
1272: ACCRUAL_CODE = (SELECT
1273: DISPLAYED_FIELD
1274: FROM

Line 1286: CST_PAC_ACCRUAL_RECONCILE_TEMP P2

1282: AND EXISTS (
1283: SELECT
1284: null
1285: FROM
1286: CST_PAC_ACCRUAL_RECONCILE_TEMP P2
1287: WHERE P2.INVOICE_ID is null
1288: AND P2.INVENTORY_ITEM_ID = P1.INVENTORY_ITEM_ID
1289: AND P2.ACCRUAL_ACCOUNT_ID = P1.ACCRUAL_ACCOUNT_ID
1290: AND P2.DESTINATION_TYPE_CODE = P1.DESTINATION_TYPE_CODE

Line 1310: CST_PAC_ACCRUAL_RECONCILE_TEMP p1

1306:
1307: PROCEDURE MATCH_INV_LINE IS
1308: BEGIN
1309: UPDATE
1310: CST_PAC_ACCRUAL_RECONCILE_TEMP p1
1311: SET
1312: ACCRUAL_CODE = (SELECT
1313: DISPLAYED_FIELD
1314: FROM

Line 1327: CST_PAC_ACCRUAL_RECONCILE_TEMP P2

1323: AND EXISTS (
1324: SELECT
1325: NULL
1326: FROM
1327: CST_PAC_ACCRUAL_RECONCILE_TEMP P2
1328: WHERE P2.INVOICE_ID is null
1329: AND ( P2.INVENTORY_ITEM_ID = P1.INVENTORY_ITEM_ID
1330: OR ( P1.INVENTORY_ITEM_ID IS NULL
1331: AND P1.DESTINATION_TYPE_CODE = 'EXPENSE' ) )

Line 1355: CST_PAC_ACCRUAL_RECONCILE_TEMP p1

1351:
1352: PROCEDURE MATCH_ITEM IS
1353: BEGIN
1354: UPDATE
1355: CST_PAC_ACCRUAL_RECONCILE_TEMP p1
1356: SET
1357: ACCRUAL_CODE = (SELECT
1358: DISPLAYED_FIELD
1359: FROM

Line 1385: CST_PAC_ACCRUAL_RECONCILE_TEMP p1

1381:
1382: PROCEDURE MATCH_NO_ITEM IS
1383: BEGIN
1384: UPDATE
1385: CST_PAC_ACCRUAL_RECONCILE_TEMP p1
1386: SET
1387: ACCRUAL_CODE = (SELECT
1388: DISPLAYED_FIELD
1389: FROM

Line 1423: CST_PAC_ACCRUAL_RECONCILE_TEMP

1419:
1420: PROCEDURE MATCH_NO_PO IS
1421: BEGIN
1422: UPDATE
1423: CST_PAC_ACCRUAL_RECONCILE_TEMP
1424: SET
1425: ACCRUAL_CODE = (SELECT
1426: DISPLAYED_FIELD
1427: FROM

Line 1491: CST_PAC_ACCRUAL_RECONCILE_TEMP P1

1487: ACCRUAL_ACCOUNT_ID,
1488: SUM((-1) * TRANSACTION_QUANTITY),
1489: SUM((-1) * TRANSACTION_AMOUNT)
1490: FROM
1491: CST_PAC_ACCRUAL_RECONCILE_TEMP P1
1492: WHERE INVOICE_ID is null
1493: AND P1.LEGAL_ENTITY_ID = P_LEGAL_ENTITY
1494: AND P1.COST_TYPE_ID = P_COST_TYPE
1495: AND P1.COST_GROUP_ID = P_COST_GROUP

Line 1502: CST_PAC_ACCRUAL_RECONCILE_TEMP P2

1498: AND exists (
1499: SELECT
1500: null
1501: FROM
1502: CST_PAC_ACCRUAL_RECONCILE_TEMP P2
1503: WHERE P2.PO_LINE_ID = P1.PO_LINE_ID
1504: AND P2.LINE_LOCATION_ID = P1.LINE_LOCATION_ID
1505: AND P2.ACCRUAL_ACCOUNT_ID = P1.ACCRUAL_ACCOUNT_ID
1506: AND P2.INVOICE_ID is not null

Line 1527: CST_PAC_ACCRUAL_RECONCILE_TEMP

1523: ,0
1524: ,1
1525: ,TRANSACTION_QUANTITY)
1526: FROM
1527: CST_PAC_ACCRUAL_RECONCILE_TEMP
1528: WHERE PO_LINE_ID = L_LINE_ID
1529: AND ACCRUAL_ACCOUNT_ID = L_ACCOUNT
1530: AND INVOICE_ID is not null
1531: AND TRANSACTION_QUANTITY <> 0

Line 1557: CST_PAC_ACCRUAL_RECONCILE_TEMP p

1553: IF (TXN_NUM = 0 OR TXN_NUM IS NULL) THEN
1554: RETURN;
1555: END IF;
1556: UPDATE
1557: CST_PAC_ACCRUAL_RECONCILE_TEMP p
1558: SET
1559: INVOICE_PRICE_VARIANCE = (-1) * TRANSACTION_AMOUNT
1560: WHERE PO_LINE_ID is not null
1561: AND P.LEGAL_ENTITY_ID = P_LEGAL_ENTITY

Line 1568: CST_PAC_ACCRUAL_RECONCILE_TEMP P1

1564: AND exists (
1565: SELECT
1566: NULL
1567: FROM
1568: CST_PAC_ACCRUAL_RECONCILE_TEMP P1
1569: WHERE P1.PO_LINE_ID = P.PO_LINE_ID
1570: AND P1.INVOICE_ID is null
1571: AND P1.ACCRUAL_ACCOUNT_ID = P.ACCRUAL_ACCOUNT_ID
1572: AND P1.LEGAL_ENTITY_ID = P_LEGAL_ENTITY

Line 1582: CST_PAC_ACCRUAL_RECONCILE_TEMP P1

1578: AND not exists (
1579: SELECT
1580: NULL
1581: FROM
1582: CST_PAC_ACCRUAL_RECONCILE_TEMP P1
1583: WHERE P1.ACCRUAL_ACCOUNT_ID = P.ACCRUAL_ACCOUNT_ID
1584: AND P1.PO_LINE_ID = P.PO_LINE_ID
1585: AND P1.INVOICE_ID is not null
1586: AND P1.LEGAL_ENTITY_ID = P_LEGAL_ENTITY

Line 1590: CST_PAC_ACCRUAL_RECONCILE_TEMP p

1586: AND P1.LEGAL_ENTITY_ID = P_LEGAL_ENTITY
1587: AND P1.COST_TYPE_ID = P_COST_TYPE
1588: AND P1.COST_GROUP_ID = P_COST_GROUP );
1589: UPDATE
1590: CST_PAC_ACCRUAL_RECONCILE_TEMP p
1591: SET
1592: INVOICE_PRICE_VARIANCE = (-1) * TRANSACTION_AMOUNT
1593: WHERE INVOICE_ID is not null
1594: AND NVL(TRANSACTION_QUANTITY

Line 1621: CST_PAC_ACCRUAL_RECONCILE_TEMP

1617: END IF;
1618: L_IPV := ROUND(L_APL_QTY * (L_POL_AVG - L_APL_AVG) / ROUND_UNIT) * ROUND_UNIT;
1619: IF L_IPV <> 0 THEN
1620: UPDATE
1621: CST_PAC_ACCRUAL_RECONCILE_TEMP
1622: SET
1623: INVOICE_PRICE_VARIANCE = L_IPV
1624: WHERE INVOICE_ID = L_INV_ID
1625: AND INVOICE_LINE_NUM = L_IVL_ID

Line 1746: CST_PAC_ACCRUAL_RECONCILE_TEMP part

1742:
1743: PROCEDURE UPDATE_WRITEOFF IS
1744: BEGIN
1745: UPDATE
1746: CST_PAC_ACCRUAL_RECONCILE_TEMP part
1747: SET
1748: (WRITE_OFF_ID,WRITE_OFF_FLAG) = (SELECT
1749: MAX(WRITE_OFF_ID),
1750: DECODE(SIGN(SUM(DECODE(WRITE_OFF_CODE

Line 1772: CST_PAC_ACCRUAL_RECONCILE_TEMP PART1,

1768: AND PART.ROWID in (
1769: SELECT
1770: PART1.ROWID
1771: FROM
1772: CST_PAC_ACCRUAL_RECONCILE_TEMP PART1,
1773: CST_PAC_ACCRUAL_WRITE_OFFS PAWO
1774: WHERE PAWO.INV_TRANSACTION_ID = PART1.INV_TRANSACTION_ID
1775: AND PART1.COST_TYPE_ID = P_COST_TYPE
1776: AND PART1.COST_GROUP_ID = P_COST_GROUP

Line 1785: CST_PAC_ACCRUAL_RECONCILE_TEMP part

1781: /*SRW.MESSAGE(300
1782: ,'update_inventory() >> ' || TO_CHAR(SYSDATE
1783: ,'Dy Mon FmDD HH24:MI:SS YYYY'))*/NULL;
1784: UPDATE
1785: CST_PAC_ACCRUAL_RECONCILE_TEMP part
1786: SET
1787: (WRITE_OFF_ID,WRITE_OFF_FLAG) = (SELECT
1788: MAX(WRITE_OFF_ID),
1789: DECODE(SIGN(SUM(DECODE(WRITE_OFF_CODE

Line 1811: CST_PAC_ACCRUAL_RECONCILE_TEMP PART1,

1807: AND PART.ROWID in (
1808: SELECT
1809: PART1.ROWID
1810: FROM
1811: CST_PAC_ACCRUAL_RECONCILE_TEMP PART1,
1812: CST_PAC_ACCRUAL_WRITE_OFFS PAWO
1813: WHERE PAWO.WIP_TRANSACTION_ID = PART1.WIP_TRANSACTION_ID
1814: AND PART1.COST_TYPE_ID = P_COST_TYPE
1815: AND PART1.COST_GROUP_ID = P_COST_GROUP

Line 1824: CST_PAC_ACCRUAL_RECONCILE_TEMP part

1820: /*SRW.MESSAGE(300
1821: ,'update_wip() >> ' || TO_CHAR(SYSDATE
1822: ,'Dy Mon FmDD HH24:MI:SS YYYY'))*/NULL;
1823: UPDATE
1824: CST_PAC_ACCRUAL_RECONCILE_TEMP part
1825: SET
1826: (WRITE_OFF_ID,WRITE_OFF_FLAG) = (SELECT
1827: MAX(WRITE_OFF_ID),
1828: DECODE(SIGN(SUM(DECODE(WRITE_OFF_CODE

Line 1850: CST_PAC_ACCRUAL_RECONCILE_TEMP PART1,

1846: AND PART.ROWID in (
1847: SELECT
1848: PART1.ROWID
1849: FROM
1850: CST_PAC_ACCRUAL_RECONCILE_TEMP PART1,
1851: CST_PAC_ACCRUAL_WRITE_OFFS PAWO
1852: WHERE PAWO.PO_TRANSACTION_ID = PART1.PO_TRANSACTION_ID
1853: AND PART1.COST_TYPE_ID = P_COST_TYPE
1854: AND PART1.COST_GROUP_ID = P_COST_GROUP

Line 1863: CST_PAC_ACCRUAL_RECONCILE_TEMP part

1859: /*SRW.MESSAGE(300
1860: ,'update_po() >> ' || TO_CHAR(SYSDATE
1861: ,'Dy Mon FmDD HH24:MI:SS YYYY'))*/NULL;
1862: UPDATE
1863: CST_PAC_ACCRUAL_RECONCILE_TEMP part
1864: SET
1865: (WRITE_OFF_ID,WRITE_OFF_FLAG) = (SELECT
1866: MAX(WRITE_OFF_ID),
1867: DECODE(SIGN(SUM(DECODE(WRITE_OFF_CODE

Line 1891: CST_PAC_ACCRUAL_RECONCILE_TEMP PART1,

1887: AND PART.ROWID in (
1888: SELECT
1889: PART1.ROWID
1890: FROM
1891: CST_PAC_ACCRUAL_RECONCILE_TEMP PART1,
1892: CST_PAC_ACCRUAL_WRITE_OFFS PAWO
1893: WHERE PAWO.INVOICE_ID = PART1.INVOICE_ID
1894: AND PAWO.INVOICE_LINE_NUM = PART1.INVOICE_LINE_NUM
1895: AND PART1.COST_TYPE_ID = P_COST_TYPE

Line 1917: CST_PAC_ACCRUAL_RECONCILE_TEMP part

1913:
1914: PROCEDURE CALC_BUCKET IS
1915: BEGIN
1916: UPDATE
1917: CST_PAC_ACCRUAL_RECONCILE_TEMP part
1918: SET
1919: (AGING_DATE,AVG_RECEIPT_PRICE) = (SELECT
1920: MIN(PART1.TRANSACTION_DATE),
1921: DECODE(SUM(DECODE(INVOICE_ID

Line 1935: CST_PAC_ACCRUAL_RECONCILE_TEMP PART1

1931: ,NULL
1932: ,PART1.TRANSACTION_QUANTITY
1933: ,0)))
1934: FROM
1935: CST_PAC_ACCRUAL_RECONCILE_TEMP PART1
1936: WHERE PART1.PO_LINE_ID = PART.PO_LINE_ID
1937: AND PART1.LINE_LOCATION_ID = PART.LINE_LOCATION_ID
1938: AND PART1.ACCRUAL_ACCOUNT_ID = PART.ACCRUAL_ACCOUNT_ID
1939: AND PART1.WRITE_OFF_FLAG = 'N'

Line 1953: CST_PAC_ACCRUAL_RECONCILE_TEMP part

1949: AND PART.LEGAL_ENTITY_ID = P_LEGAL_ENTITY
1950: AND PART.COST_TYPE_ID = P_COST_TYPE
1951: AND PART.COST_GROUP_ID = P_COST_GROUP;
1952: UPDATE
1953: CST_PAC_ACCRUAL_RECONCILE_TEMP part
1954: SET
1955: (NET_PO_LINE_QUANTITY,NET_PO_LINE_AMOUNT) = (SELECT
1956: SUM(PART1.TRANSACTION_QUANTITY),
1957: SUM(PART1.TRANSACTION_AMOUNT)

Line 1959: CST_PAC_ACCRUAL_RECONCILE_TEMP PART1

1955: (NET_PO_LINE_QUANTITY,NET_PO_LINE_AMOUNT) = (SELECT
1956: SUM(PART1.TRANSACTION_QUANTITY),
1957: SUM(PART1.TRANSACTION_AMOUNT)
1958: FROM
1959: CST_PAC_ACCRUAL_RECONCILE_TEMP PART1
1960: WHERE PART1.PO_LINE_ID = PART.PO_LINE_ID
1961: AND PART1.ACCRUAL_ACCOUNT_ID = PART.ACCRUAL_ACCOUNT_ID
1962: AND PART1.WRITE_OFF_FLAG = 'N'
1963: AND PART1.TRANSACTION_DATE between NVL(P_GL_DATE_FROM

Line 1976: CST_PAC_ACCRUAL_RECONCILE_TEMP part

1972: AND PART.LEGAL_ENTITY_ID = P_LEGAL_ENTITY
1973: AND PART.COST_TYPE_ID = P_COST_TYPE
1974: AND PART.COST_GROUP_ID = P_COST_GROUP;
1975: UPDATE
1976: CST_PAC_ACCRUAL_RECONCILE_TEMP part
1977: SET
1978: (AGING_DATE,AVG_RECEIPT_PRICE,NET_PO_LINE_QUANTITY,NET_PO_LINE_AMOUNT) = (SELECT
1979: PART1.TRANSACTION_DATE,
1980: DECODE(SUM(DECODE(INVOICE_ID

Line 1996: CST_PAC_ACCRUAL_RECONCILE_TEMP PART1

1992: ,0))),
1993: PART1.TRANSACTION_QUANTITY,
1994: PART1.TRANSACTION_AMOUNT
1995: FROM
1996: CST_PAC_ACCRUAL_RECONCILE_TEMP PART1
1997: WHERE PART1.ROWID = PART.ROWID
1998: AND PART1.TRANSACTION_DATE between NVL(P_GL_DATE_FROM
1999: ,PART1.TRANSACTION_DATE - 1)
2000: AND NVL(P_GL_DATE_TO

Line 2015: CST_PAC_ACCRUAL_RECONCILE_TEMP part

2011: AND PART.LEGAL_ENTITY_ID = P_LEGAL_ENTITY
2012: AND PART.COST_TYPE_ID = P_COST_TYPE
2013: AND PART.COST_GROUP_ID = P_COST_GROUP;
2014: UPDATE
2015: CST_PAC_ACCRUAL_RECONCILE_TEMP part
2016: SET
2017: (AGING_DATE,AVG_RECEIPT_PRICE) = (SELECT
2018: MIN(PART1.TRANSACTION_DATE),
2019: DECODE(SUM(DECODE(INVOICE_ID

Line 2033: CST_PAC_ACCRUAL_RECONCILE_TEMP PART1

2029: ,NULL
2030: ,PART1.TRANSACTION_QUANTITY
2031: ,0)))
2032: FROM
2033: CST_PAC_ACCRUAL_RECONCILE_TEMP PART1
2034: WHERE PART1.PO_LINE_ID = PART.PO_LINE_ID
2035: AND PART1.LINE_LOCATION_ID = PART.LINE_LOCATION_ID
2036: AND PART1.ACCRUAL_ACCOUNT_ID = PART.ACCRUAL_ACCOUNT_ID
2037: AND PART1.WRITE_OFF_FLAG = 'Y'

Line 2051: CST_PAC_ACCRUAL_RECONCILE_TEMP part

2047: AND PART.LEGAL_ENTITY_ID = P_LEGAL_ENTITY
2048: AND PART.COST_TYPE_ID = P_COST_TYPE
2049: AND PART.COST_GROUP_ID = P_COST_GROUP;
2050: UPDATE
2051: CST_PAC_ACCRUAL_RECONCILE_TEMP part
2052: SET
2053: (NET_PO_LINE_QUANTITY,NET_PO_LINE_AMOUNT) = (SELECT
2054: SUM(PART1.TRANSACTION_QUANTITY),
2055: 0

Line 2057: CST_PAC_ACCRUAL_RECONCILE_TEMP PART1

2053: (NET_PO_LINE_QUANTITY,NET_PO_LINE_AMOUNT) = (SELECT
2054: SUM(PART1.TRANSACTION_QUANTITY),
2055: 0
2056: FROM
2057: CST_PAC_ACCRUAL_RECONCILE_TEMP PART1
2058: WHERE PART1.PO_LINE_ID = PART.PO_LINE_ID
2059: AND PART1.ACCRUAL_ACCOUNT_ID = PART.ACCRUAL_ACCOUNT_ID
2060: AND PART1.WRITE_OFF_FLAG = 'Y'
2061: AND PART1.TRANSACTION_DATE between NVL(P_GL_DATE_FROM

Line 2074: CST_PAC_ACCRUAL_RECONCILE_TEMP part

2070: AND PART.LEGAL_ENTITY_ID = P_LEGAL_ENTITY
2071: AND PART.COST_TYPE_ID = P_COST_TYPE
2072: AND PART.COST_GROUP_ID = P_COST_GROUP;
2073: UPDATE
2074: CST_PAC_ACCRUAL_RECONCILE_TEMP part
2075: SET
2076: (AGING_DATE,AVG_RECEIPT_PRICE,NET_PO_LINE_QUANTITY,NET_PO_LINE_AMOUNT) = (SELECT
2077: PART1.TRANSACTION_DATE,
2078: DECODE(SUM(DECODE(INVOICE_ID

Line 2094: CST_PAC_ACCRUAL_RECONCILE_TEMP PART1

2090: ,0))),
2091: PART1.TRANSACTION_QUANTITY,
2092: 0
2093: FROM
2094: CST_PAC_ACCRUAL_RECONCILE_TEMP PART1
2095: WHERE PART1.ROWID = PART.ROWID
2096: AND PART1.TRANSACTION_DATE between NVL(P_GL_DATE_FROM
2097: ,PART1.TRANSACTION_DATE - 1)
2098: AND NVL(P_GL_DATE_TO

Line 2141: INSERT INTO CST_PAC_ACCRUAL_RECONCILE_TEMP

2137: ,INDUSTRY);
2138: IF NOT INV_IS_INSTALLED = 'I' THEN
2139: NULL;
2140: END IF;
2141: INSERT INTO CST_PAC_ACCRUAL_RECONCILE_TEMP
2142: (REQUEST_ID
2143: ,PROGRAM_APPLICATION_ID
2144: ,PROGRAM_ID
2145: ,PROGRAM_UPDATE_DATE

Line 2293: INSERT INTO CST_PAC_ACCRUAL_RECONCILE_TEMP

2289: );
2290: /*SRW.MESSAGE(111
2291: ,'insert_inv_data() >> ' || TO_CHAR(SYSDATE
2292: ,'Dy Mon FmDD HH24:MI:SS YYYY'))*/NULL;
2293: INSERT INTO CST_PAC_ACCRUAL_RECONCILE_TEMP
2294: (REQUEST_ID
2295: ,PROGRAM_APPLICATION_ID
2296: ,PROGRAM_ID
2297: ,PROGRAM_UPDATE_DATE

Line 2732: CST_PAC_ACCRUAL_RECONCILE_TEMP

2728:
2729: PROCEDURE MATCH_RECEIPT IS
2730: BEGIN
2731: UPDATE
2732: CST_PAC_ACCRUAL_RECONCILE_TEMP
2733: SET
2734: ACCRUAL_CODE = (SELECT
2735: DISPLAYED_FIELD
2736: FROM

Line 2798: INSERT INTO CST_PAC_ACCRUAL_RECONCILE_TEMP

2794: ,INDUSTRY);
2795: IF NOT INV_IS_INSTALLED = 'I' THEN
2796: NULL;
2797: END IF;
2798: INSERT INTO CST_PAC_ACCRUAL_RECONCILE_TEMP
2799: (REQUEST_ID
2800: ,PROGRAM_APPLICATION_ID
2801: ,PROGRAM_ID
2802: ,PROGRAM_UPDATE_DATE

Line 2932: INSERT INTO CST_PAC_ACCRUAL_RECONCILE_TEMP

2928: );
2929: /*SRW.MESSAGE(112
2930: ,'insert_inv_misc() >> ' || TO_CHAR(SYSDATE
2931: ,'Dy Mon FmDD HH24:MI:SS YYYY'))*/NULL;
2932: INSERT INTO CST_PAC_ACCRUAL_RECONCILE_TEMP
2933: (REQUEST_ID
2934: ,PROGRAM_APPLICATION_ID
2935: ,PROGRAM_ID
2936: ,PROGRAM_UPDATE_DATE