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 278: INSERT INTO CST_PAC_ACCRUAL_RECONCILE_TEMP

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

Line 447: INSERT INTO CST_PAC_ACCRUAL_RECONCILE_TEMP

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

Line 600: INSERT INTO CST_PAC_ACCRUAL_RECONCILE_TEMP

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

Line 771: INSERT INTO CST_PAC_ACCRUAL_RECONCILE_TEMP

767: END INSERT_AP_DATA;
768:
769: PROCEDURE INSERT_AP_MISC IS
770: BEGIN
771: INSERT INTO CST_PAC_ACCRUAL_RECONCILE_TEMP
772: (REQUEST_ID
773: ,PROGRAM_APPLICATION_ID
774: ,PROGRAM_ID
775: ,PROGRAM_UPDATE_DATE

Line 925: INSERT INTO CST_PAC_ACCRUAL_RECONCILE_TEMP

921: END INSERT_AP_MISC;
922:
923: PROCEDURE INSERT_PO_DATA IS
924: BEGIN
925: INSERT INTO CST_PAC_ACCRUAL_RECONCILE_TEMP
926: (REQUEST_ID
927: ,PROGRAM_APPLICATION_ID
928: ,PROGRAM_ID
929: ,PROGRAM_UPDATE_DATE

Line 1075: INSERT INTO CST_PAC_ACCRUAL_RECONCILE_TEMP

1071: ,POV.VENDOR_NAME)
1072: AND CAH.SET_OF_BOOKS_ID = P_SET_OF_BOOKS_ID
1073: /*Support for LCM*/
1074: AND nvl(cal.ae_line_type_code,'16') <> '38';
1075: INSERT INTO CST_PAC_ACCRUAL_RECONCILE_TEMP
1076: (REQUEST_ID
1077: ,PROGRAM_APPLICATION_ID
1078: ,PROGRAM_ID
1079: ,PROGRAM_UPDATE_DATE

Line 1232: CST_PAC_ACCRUAL_RECONCILE_TEMP p1

1228:
1229: PROCEDURE MATCH_INV_HEADER IS
1230: BEGIN
1231: UPDATE
1232: CST_PAC_ACCRUAL_RECONCILE_TEMP p1
1233: SET
1234: ACCRUAL_CODE = (SELECT
1235: DISPLAYED_FIELD
1236: FROM

Line 1248: CST_PAC_ACCRUAL_RECONCILE_TEMP P2

1244: AND EXISTS (
1245: SELECT
1246: null
1247: FROM
1248: CST_PAC_ACCRUAL_RECONCILE_TEMP P2
1249: WHERE P2.INVOICE_ID is null
1250: AND ( P2.INVENTORY_ITEM_ID = P1.INVENTORY_ITEM_ID
1251: OR ( P2.INVENTORY_ITEM_ID is NULL
1252: AND P2.DESTINATION_TYPE_CODE = 'EXPENSE' ) )

Line 1275: CST_PAC_ACCRUAL_RECONCILE_TEMP p1

1271:
1272: PROCEDURE MATCH_INV_ITEM IS
1273: BEGIN
1274: UPDATE
1275: CST_PAC_ACCRUAL_RECONCILE_TEMP p1
1276: SET
1277: ACCRUAL_CODE = (SELECT
1278: DISPLAYED_FIELD
1279: FROM

Line 1291: CST_PAC_ACCRUAL_RECONCILE_TEMP P2

1287: AND EXISTS (
1288: SELECT
1289: null
1290: FROM
1291: CST_PAC_ACCRUAL_RECONCILE_TEMP P2
1292: WHERE P2.INVOICE_ID is null
1293: AND P2.INVENTORY_ITEM_ID = P1.INVENTORY_ITEM_ID
1294: AND P2.ACCRUAL_ACCOUNT_ID = P1.ACCRUAL_ACCOUNT_ID
1295: AND P2.DESTINATION_TYPE_CODE = P1.DESTINATION_TYPE_CODE

Line 1315: CST_PAC_ACCRUAL_RECONCILE_TEMP p1

1311:
1312: PROCEDURE MATCH_INV_LINE IS
1313: BEGIN
1314: UPDATE
1315: CST_PAC_ACCRUAL_RECONCILE_TEMP p1
1316: SET
1317: ACCRUAL_CODE = (SELECT
1318: DISPLAYED_FIELD
1319: FROM

Line 1332: CST_PAC_ACCRUAL_RECONCILE_TEMP P2

1328: AND EXISTS (
1329: SELECT
1330: NULL
1331: FROM
1332: CST_PAC_ACCRUAL_RECONCILE_TEMP P2
1333: WHERE P2.INVOICE_ID is null
1334: AND ( P2.INVENTORY_ITEM_ID = P1.INVENTORY_ITEM_ID
1335: OR ( P1.INVENTORY_ITEM_ID IS NULL
1336: AND P1.DESTINATION_TYPE_CODE = 'EXPENSE' ) )

Line 1360: CST_PAC_ACCRUAL_RECONCILE_TEMP p1

1356:
1357: PROCEDURE MATCH_ITEM IS
1358: BEGIN
1359: UPDATE
1360: CST_PAC_ACCRUAL_RECONCILE_TEMP p1
1361: SET
1362: ACCRUAL_CODE = (SELECT
1363: DISPLAYED_FIELD
1364: FROM

Line 1390: CST_PAC_ACCRUAL_RECONCILE_TEMP p1

1386:
1387: PROCEDURE MATCH_NO_ITEM IS
1388: BEGIN
1389: UPDATE
1390: CST_PAC_ACCRUAL_RECONCILE_TEMP p1
1391: SET
1392: ACCRUAL_CODE = (SELECT
1393: DISPLAYED_FIELD
1394: FROM

Line 1428: CST_PAC_ACCRUAL_RECONCILE_TEMP

1424:
1425: PROCEDURE MATCH_NO_PO IS
1426: BEGIN
1427: UPDATE
1428: CST_PAC_ACCRUAL_RECONCILE_TEMP
1429: SET
1430: ACCRUAL_CODE = (SELECT
1431: DISPLAYED_FIELD
1432: FROM

Line 1496: CST_PAC_ACCRUAL_RECONCILE_TEMP P1

1492: ACCRUAL_ACCOUNT_ID,
1493: SUM((-1) * TRANSACTION_QUANTITY),
1494: SUM((-1) * TRANSACTION_AMOUNT)
1495: FROM
1496: CST_PAC_ACCRUAL_RECONCILE_TEMP P1
1497: WHERE INVOICE_ID is null
1498: AND P1.LEGAL_ENTITY_ID = P_LEGAL_ENTITY
1499: AND P1.COST_TYPE_ID = P_COST_TYPE
1500: AND P1.COST_GROUP_ID = P_COST_GROUP

Line 1507: CST_PAC_ACCRUAL_RECONCILE_TEMP P2

1503: AND exists (
1504: SELECT
1505: null
1506: FROM
1507: CST_PAC_ACCRUAL_RECONCILE_TEMP P2
1508: WHERE P2.PO_LINE_ID = P1.PO_LINE_ID
1509: AND P2.LINE_LOCATION_ID = P1.LINE_LOCATION_ID
1510: AND P2.ACCRUAL_ACCOUNT_ID = P1.ACCRUAL_ACCOUNT_ID
1511: AND P2.INVOICE_ID is not null

Line 1532: CST_PAC_ACCRUAL_RECONCILE_TEMP

1528: ,0
1529: ,1
1530: ,TRANSACTION_QUANTITY)
1531: FROM
1532: CST_PAC_ACCRUAL_RECONCILE_TEMP
1533: WHERE PO_LINE_ID = L_LINE_ID
1534: AND ACCRUAL_ACCOUNT_ID = L_ACCOUNT
1535: AND INVOICE_ID is not null
1536: AND TRANSACTION_QUANTITY <> 0

Line 1562: CST_PAC_ACCRUAL_RECONCILE_TEMP p

1558: IF (TXN_NUM = 0 OR TXN_NUM IS NULL) THEN
1559: RETURN;
1560: END IF;
1561: UPDATE
1562: CST_PAC_ACCRUAL_RECONCILE_TEMP p
1563: SET
1564: INVOICE_PRICE_VARIANCE = (-1) * TRANSACTION_AMOUNT
1565: WHERE PO_LINE_ID is not null
1566: AND P.LEGAL_ENTITY_ID = P_LEGAL_ENTITY

Line 1573: CST_PAC_ACCRUAL_RECONCILE_TEMP P1

1569: AND exists (
1570: SELECT
1571: NULL
1572: FROM
1573: CST_PAC_ACCRUAL_RECONCILE_TEMP P1
1574: WHERE P1.PO_LINE_ID = P.PO_LINE_ID
1575: AND P1.INVOICE_ID is null
1576: AND P1.ACCRUAL_ACCOUNT_ID = P.ACCRUAL_ACCOUNT_ID
1577: AND P1.LEGAL_ENTITY_ID = P_LEGAL_ENTITY

Line 1587: CST_PAC_ACCRUAL_RECONCILE_TEMP P1

1583: AND not exists (
1584: SELECT
1585: NULL
1586: FROM
1587: CST_PAC_ACCRUAL_RECONCILE_TEMP P1
1588: WHERE P1.ACCRUAL_ACCOUNT_ID = P.ACCRUAL_ACCOUNT_ID
1589: AND P1.PO_LINE_ID = P.PO_LINE_ID
1590: AND P1.INVOICE_ID is not null
1591: AND P1.LEGAL_ENTITY_ID = P_LEGAL_ENTITY

Line 1595: CST_PAC_ACCRUAL_RECONCILE_TEMP p

1591: AND P1.LEGAL_ENTITY_ID = P_LEGAL_ENTITY
1592: AND P1.COST_TYPE_ID = P_COST_TYPE
1593: AND P1.COST_GROUP_ID = P_COST_GROUP );
1594: UPDATE
1595: CST_PAC_ACCRUAL_RECONCILE_TEMP p
1596: SET
1597: INVOICE_PRICE_VARIANCE = (-1) * TRANSACTION_AMOUNT
1598: WHERE INVOICE_ID is not null
1599: AND NVL(TRANSACTION_QUANTITY

Line 1626: CST_PAC_ACCRUAL_RECONCILE_TEMP

1622: END IF;
1623: L_IPV := ROUND(L_APL_QTY * (L_POL_AVG - L_APL_AVG) / ROUND_UNIT) * ROUND_UNIT;
1624: IF L_IPV <> 0 THEN
1625: UPDATE
1626: CST_PAC_ACCRUAL_RECONCILE_TEMP
1627: SET
1628: INVOICE_PRICE_VARIANCE = L_IPV
1629: WHERE INVOICE_ID = L_INV_ID
1630: AND INVOICE_LINE_NUM = L_IVL_ID

Line 1751: CST_PAC_ACCRUAL_RECONCILE_TEMP part

1747:
1748: PROCEDURE UPDATE_WRITEOFF IS
1749: BEGIN
1750: UPDATE
1751: CST_PAC_ACCRUAL_RECONCILE_TEMP part
1752: SET
1753: (WRITE_OFF_ID,WRITE_OFF_FLAG) = (SELECT
1754: MAX(WRITE_OFF_ID),
1755: DECODE(SIGN(SUM(DECODE(WRITE_OFF_CODE

Line 1777: CST_PAC_ACCRUAL_RECONCILE_TEMP PART1,

1773: AND PART.ROWID in (
1774: SELECT
1775: PART1.ROWID
1776: FROM
1777: CST_PAC_ACCRUAL_RECONCILE_TEMP PART1,
1778: CST_PAC_ACCRUAL_WRITE_OFFS PAWO
1779: WHERE PAWO.INV_TRANSACTION_ID = PART1.INV_TRANSACTION_ID
1780: AND PART1.COST_TYPE_ID = P_COST_TYPE
1781: AND PART1.COST_GROUP_ID = P_COST_GROUP

Line 1790: CST_PAC_ACCRUAL_RECONCILE_TEMP part

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

Line 1816: CST_PAC_ACCRUAL_RECONCILE_TEMP PART1,

1812: AND PART.ROWID in (
1813: SELECT
1814: PART1.ROWID
1815: FROM
1816: CST_PAC_ACCRUAL_RECONCILE_TEMP PART1,
1817: CST_PAC_ACCRUAL_WRITE_OFFS PAWO
1818: WHERE PAWO.WIP_TRANSACTION_ID = PART1.WIP_TRANSACTION_ID
1819: AND PART1.COST_TYPE_ID = P_COST_TYPE
1820: AND PART1.COST_GROUP_ID = P_COST_GROUP

Line 1829: CST_PAC_ACCRUAL_RECONCILE_TEMP part

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

Line 1855: CST_PAC_ACCRUAL_RECONCILE_TEMP PART1,

1851: AND PART.ROWID in (
1852: SELECT
1853: PART1.ROWID
1854: FROM
1855: CST_PAC_ACCRUAL_RECONCILE_TEMP PART1,
1856: CST_PAC_ACCRUAL_WRITE_OFFS PAWO
1857: WHERE PAWO.PO_TRANSACTION_ID = PART1.PO_TRANSACTION_ID
1858: AND PART1.COST_TYPE_ID = P_COST_TYPE
1859: AND PART1.COST_GROUP_ID = P_COST_GROUP

Line 1868: CST_PAC_ACCRUAL_RECONCILE_TEMP part

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

Line 1896: CST_PAC_ACCRUAL_RECONCILE_TEMP PART1,

1892: AND PART.ROWID in (
1893: SELECT
1894: PART1.ROWID
1895: FROM
1896: CST_PAC_ACCRUAL_RECONCILE_TEMP PART1,
1897: CST_PAC_ACCRUAL_WRITE_OFFS PAWO
1898: WHERE PAWO.INVOICE_ID = PART1.INVOICE_ID
1899: AND PAWO.INVOICE_LINE_NUM = PART1.INVOICE_LINE_NUM
1900: AND PART1.COST_TYPE_ID = P_COST_TYPE

Line 1922: CST_PAC_ACCRUAL_RECONCILE_TEMP part

1918:
1919: PROCEDURE CALC_BUCKET IS
1920: BEGIN
1921: UPDATE
1922: CST_PAC_ACCRUAL_RECONCILE_TEMP part
1923: SET
1924: (AGING_DATE,AVG_RECEIPT_PRICE) = (SELECT
1925: MIN(PART1.TRANSACTION_DATE),
1926: DECODE(SUM(DECODE(INVOICE_ID

Line 1940: CST_PAC_ACCRUAL_RECONCILE_TEMP PART1

1936: ,NULL
1937: ,PART1.TRANSACTION_QUANTITY
1938: ,0)))
1939: FROM
1940: CST_PAC_ACCRUAL_RECONCILE_TEMP PART1
1941: WHERE PART1.PO_LINE_ID = PART.PO_LINE_ID
1942: AND PART1.LINE_LOCATION_ID = PART.LINE_LOCATION_ID
1943: AND PART1.ACCRUAL_ACCOUNT_ID = PART.ACCRUAL_ACCOUNT_ID
1944: AND PART1.WRITE_OFF_FLAG = 'N'

Line 1958: CST_PAC_ACCRUAL_RECONCILE_TEMP part

1954: AND PART.LEGAL_ENTITY_ID = P_LEGAL_ENTITY
1955: AND PART.COST_TYPE_ID = P_COST_TYPE
1956: AND PART.COST_GROUP_ID = P_COST_GROUP;
1957: UPDATE
1958: CST_PAC_ACCRUAL_RECONCILE_TEMP part
1959: SET
1960: (NET_PO_LINE_QUANTITY,NET_PO_LINE_AMOUNT) = (SELECT
1961: SUM(PART1.TRANSACTION_QUANTITY),
1962: SUM(PART1.TRANSACTION_AMOUNT)

Line 1964: CST_PAC_ACCRUAL_RECONCILE_TEMP PART1

1960: (NET_PO_LINE_QUANTITY,NET_PO_LINE_AMOUNT) = (SELECT
1961: SUM(PART1.TRANSACTION_QUANTITY),
1962: SUM(PART1.TRANSACTION_AMOUNT)
1963: FROM
1964: CST_PAC_ACCRUAL_RECONCILE_TEMP PART1
1965: WHERE PART1.PO_LINE_ID = PART.PO_LINE_ID
1966: AND PART1.ACCRUAL_ACCOUNT_ID = PART.ACCRUAL_ACCOUNT_ID
1967: AND PART1.WRITE_OFF_FLAG = 'N'
1968: AND PART1.TRANSACTION_DATE between NVL(P_GL_DATE_FROM

Line 1981: CST_PAC_ACCRUAL_RECONCILE_TEMP part

1977: AND PART.LEGAL_ENTITY_ID = P_LEGAL_ENTITY
1978: AND PART.COST_TYPE_ID = P_COST_TYPE
1979: AND PART.COST_GROUP_ID = P_COST_GROUP;
1980: UPDATE
1981: CST_PAC_ACCRUAL_RECONCILE_TEMP part
1982: SET
1983: (AGING_DATE,AVG_RECEIPT_PRICE,NET_PO_LINE_QUANTITY,NET_PO_LINE_AMOUNT) = (SELECT
1984: PART1.TRANSACTION_DATE,
1985: DECODE(SUM(DECODE(INVOICE_ID

Line 2001: CST_PAC_ACCRUAL_RECONCILE_TEMP PART1

1997: ,0))),
1998: PART1.TRANSACTION_QUANTITY,
1999: PART1.TRANSACTION_AMOUNT
2000: FROM
2001: CST_PAC_ACCRUAL_RECONCILE_TEMP PART1
2002: WHERE PART1.ROWID = PART.ROWID
2003: AND PART1.TRANSACTION_DATE between NVL(P_GL_DATE_FROM
2004: ,PART1.TRANSACTION_DATE - 1)
2005: AND NVL(P_GL_DATE_TO

Line 2020: CST_PAC_ACCRUAL_RECONCILE_TEMP part

2016: AND PART.LEGAL_ENTITY_ID = P_LEGAL_ENTITY
2017: AND PART.COST_TYPE_ID = P_COST_TYPE
2018: AND PART.COST_GROUP_ID = P_COST_GROUP;
2019: UPDATE
2020: CST_PAC_ACCRUAL_RECONCILE_TEMP part
2021: SET
2022: (AGING_DATE,AVG_RECEIPT_PRICE) = (SELECT
2023: MIN(PART1.TRANSACTION_DATE),
2024: DECODE(SUM(DECODE(INVOICE_ID

Line 2038: CST_PAC_ACCRUAL_RECONCILE_TEMP PART1

2034: ,NULL
2035: ,PART1.TRANSACTION_QUANTITY
2036: ,0)))
2037: FROM
2038: CST_PAC_ACCRUAL_RECONCILE_TEMP PART1
2039: WHERE PART1.PO_LINE_ID = PART.PO_LINE_ID
2040: AND PART1.LINE_LOCATION_ID = PART.LINE_LOCATION_ID
2041: AND PART1.ACCRUAL_ACCOUNT_ID = PART.ACCRUAL_ACCOUNT_ID
2042: AND PART1.WRITE_OFF_FLAG = 'Y'

Line 2056: CST_PAC_ACCRUAL_RECONCILE_TEMP part

2052: AND PART.LEGAL_ENTITY_ID = P_LEGAL_ENTITY
2053: AND PART.COST_TYPE_ID = P_COST_TYPE
2054: AND PART.COST_GROUP_ID = P_COST_GROUP;
2055: UPDATE
2056: CST_PAC_ACCRUAL_RECONCILE_TEMP part
2057: SET
2058: (NET_PO_LINE_QUANTITY,NET_PO_LINE_AMOUNT) = (SELECT
2059: SUM(PART1.TRANSACTION_QUANTITY),
2060: 0

Line 2062: CST_PAC_ACCRUAL_RECONCILE_TEMP PART1

2058: (NET_PO_LINE_QUANTITY,NET_PO_LINE_AMOUNT) = (SELECT
2059: SUM(PART1.TRANSACTION_QUANTITY),
2060: 0
2061: FROM
2062: CST_PAC_ACCRUAL_RECONCILE_TEMP PART1
2063: WHERE PART1.PO_LINE_ID = PART.PO_LINE_ID
2064: AND PART1.ACCRUAL_ACCOUNT_ID = PART.ACCRUAL_ACCOUNT_ID
2065: AND PART1.WRITE_OFF_FLAG = 'Y'
2066: AND PART1.TRANSACTION_DATE between NVL(P_GL_DATE_FROM

Line 2079: CST_PAC_ACCRUAL_RECONCILE_TEMP part

2075: AND PART.LEGAL_ENTITY_ID = P_LEGAL_ENTITY
2076: AND PART.COST_TYPE_ID = P_COST_TYPE
2077: AND PART.COST_GROUP_ID = P_COST_GROUP;
2078: UPDATE
2079: CST_PAC_ACCRUAL_RECONCILE_TEMP part
2080: SET
2081: (AGING_DATE,AVG_RECEIPT_PRICE,NET_PO_LINE_QUANTITY,NET_PO_LINE_AMOUNT) = (SELECT
2082: PART1.TRANSACTION_DATE,
2083: DECODE(SUM(DECODE(INVOICE_ID

Line 2099: CST_PAC_ACCRUAL_RECONCILE_TEMP PART1

2095: ,0))),
2096: PART1.TRANSACTION_QUANTITY,
2097: 0
2098: FROM
2099: CST_PAC_ACCRUAL_RECONCILE_TEMP PART1
2100: WHERE PART1.ROWID = PART.ROWID
2101: AND PART1.TRANSACTION_DATE between NVL(P_GL_DATE_FROM
2102: ,PART1.TRANSACTION_DATE - 1)
2103: AND NVL(P_GL_DATE_TO

Line 2146: INSERT INTO CST_PAC_ACCRUAL_RECONCILE_TEMP

2142: ,INDUSTRY);
2143: IF NOT INV_IS_INSTALLED = 'I' THEN
2144: NULL;
2145: END IF;
2146: INSERT INTO CST_PAC_ACCRUAL_RECONCILE_TEMP
2147: (REQUEST_ID
2148: ,PROGRAM_APPLICATION_ID
2149: ,PROGRAM_ID
2150: ,PROGRAM_UPDATE_DATE

Line 2298: INSERT INTO CST_PAC_ACCRUAL_RECONCILE_TEMP

2294: );
2295: /*SRW.MESSAGE(111
2296: ,'insert_inv_data() >> ' || TO_CHAR(SYSDATE
2297: ,'Dy Mon FmDD HH24:MI:SS YYYY'))*/NULL;
2298: INSERT INTO CST_PAC_ACCRUAL_RECONCILE_TEMP
2299: (REQUEST_ID
2300: ,PROGRAM_APPLICATION_ID
2301: ,PROGRAM_ID
2302: ,PROGRAM_UPDATE_DATE

Line 2737: CST_PAC_ACCRUAL_RECONCILE_TEMP

2733:
2734: PROCEDURE MATCH_RECEIPT IS
2735: BEGIN
2736: UPDATE
2737: CST_PAC_ACCRUAL_RECONCILE_TEMP
2738: SET
2739: ACCRUAL_CODE = (SELECT
2740: DISPLAYED_FIELD
2741: FROM

Line 2803: INSERT INTO CST_PAC_ACCRUAL_RECONCILE_TEMP

2799: ,INDUSTRY);
2800: IF NOT INV_IS_INSTALLED = 'I' THEN
2801: NULL;
2802: END IF;
2803: INSERT INTO CST_PAC_ACCRUAL_RECONCILE_TEMP
2804: (REQUEST_ID
2805: ,PROGRAM_APPLICATION_ID
2806: ,PROGRAM_ID
2807: ,PROGRAM_UPDATE_DATE

Line 2937: INSERT INTO CST_PAC_ACCRUAL_RECONCILE_TEMP

2933: );
2934: /*SRW.MESSAGE(112
2935: ,'insert_inv_misc() >> ' || TO_CHAR(SYSDATE
2936: ,'Dy Mon FmDD HH24:MI:SS YYYY'))*/NULL;
2937: INSERT INTO CST_PAC_ACCRUAL_RECONCILE_TEMP
2938: (REQUEST_ID
2939: ,PROGRAM_APPLICATION_ID
2940: ,PROGRAM_ID
2941: ,PROGRAM_UPDATE_DATE