APPS.CST_ACCOUNTINGPERIOD_PUB dependencies on CST_INV_QTY_TEMP

Line 1812: FROM cst_inv_qty_temp CIQT,

1808: 6,NVL(CIQT.rollback_qty,0),
1809: 7,NVL(CIQT.rollback_qty,0),
1810: 8,NVL(CIQT.rollback_qty,0),
1811: 0))*NVL(CICT.item_cost,0) rollback_intransit_value
1812: FROM cst_inv_qty_temp CIQT,
1813: cst_inv_cost_temp CICT
1814: WHERE CIQT.organization_id = p_org_id
1815: AND CIQT.organization_id = CICT.organization_id
1816: AND NVL(CIQT.cost_group_id,-1) =

Line 1846: DELETE CST_INV_QTY_TEMP;

1842: l_stmt_num := 56;
1843: DELETE CST_ITEM_LIST_TEMP;
1844: DELETE CST_CG_LIST_TEMP;
1845: DELETE CST_SUB_LIST_TEMP;
1846: DELETE CST_INV_QTY_TEMP;
1847: DELETE CST_INV_COST_TEMP;
1848:
1849: l_stmt_num := 57;
1850: INSERT

Line 1851: INTO cst_inv_qty_temp(

1847: DELETE CST_INV_COST_TEMP;
1848:
1849: l_stmt_num := 57;
1850: INSERT
1851: INTO cst_inv_qty_temp(
1852: qty_source,
1853: organization_id,
1854: cost_group_id,
1855: subinventory_code,

Line 1928: INTO cst_inv_qty_temp(

1924: --we did not already insert baseline from
1925: --CPCST initialization, so insert from CPCS
1926: /* Bug 14036099
1927: INSERT
1928: INTO cst_inv_qty_temp(
1929: qty_source,
1930: organization_id,
1931: cost_group_id,
1932: subinventory_code,

Line 1991: INTO cst_inv_qty_temp (

1987: AND CPCS.acct_period_id = NVL(l_prior_period_id,-1); */
1988:
1989: /* Bug 14036099 */
1990: INSERT ALL
1991: INTO cst_inv_qty_temp (
1992: qty_source,
1993: organization_id,
1994: cost_group_id,
1995: subinventory_code,

Line 2004: INTO cst_inv_qty_temp (

2000: cost_group_id,
2001: subinventory_code,
2002: inventory_item_id,
2003: rollback_onhand_value)
2004: INTO cst_inv_qty_temp (
2005: qty_source,
2006: organization_id,
2007: cost_group_id,
2008: subinventory_code,

Line 2017: INTO cst_inv_qty_temp (

2013: cost_group_id,
2014: subinventory_code,
2015: inventory_item_id,
2016: rollback_intransit_value)
2017: INTO cst_inv_qty_temp (
2018: qty_source,
2019: organization_id,
2020: cost_group_id,
2021: subinventory_code,

Line 2030: INTO cst_inv_qty_temp (

2026: cost_group_id,
2027: subinventory_code,
2028: inventory_item_id,
2029: cumulative_onhand_mta)
2030: INTO cst_inv_qty_temp (
2031: qty_source,
2032: organization_id,
2033: cost_group_id,
2034: subinventory_code,

Line 2084: INTO cst_inv_qty_temp(

2080: l_stmt_num := 70;
2081: --summarize accounted value from MTA where
2082: --the primary quantity is the same in MTA and MMT
2083: INSERT
2084: INTO cst_inv_qty_temp(
2085: qty_source,
2086: organization_id,
2087: cost_group_id,
2088: subinventory_code,

Line 2180: INTO cst_inv_qty_temp(

2176: l_stmt_num := 80;
2177: --summarize accounted value from MTA where
2178: --the primary quantity is different in MTA and MMT (using transfer sub, org, etc)
2179: INSERT
2180: INTO cst_inv_qty_temp(
2181: qty_source,
2182: organization_id,
2183: cost_group_id,
2184: subinventory_code,

Line 2227: INTO cst_inv_qty_temp(

2223:
2224: l_stmt_num := 85;
2225: --summarize intransit value from MTA
2226: INSERT
2227: INTO cst_inv_qty_temp(
2228: qty_source,
2229: organization_id,
2230: cost_group_id,
2231: subinventory_code,

Line 2331: FROM cst_inv_qty_temp CIQT,

2327: 22,0,
2328: NVL(CIQT.accounted_value,0))) accounted_value,
2329: SUM(NVL(CIQT.rollback_qty,0))*NVL(CICT.item_cost,0) rollback_value,
2330: SUM(NVL(CIQT.rollback_qty,0))
2331: FROM cst_inv_qty_temp CIQT,
2332: cst_inv_cost_temp CICT
2333: WHERE CIQT.organization_id = p_org_id
2334: AND CIQT.organization_id = CICT.organization_id(+)
2335: AND NVL(CIQT.cost_group_id,-1) =

Line 2449: FROM cst_inv_qty_temp CIQT,

2445: SYSDATE,
2446: 1,
2447: SYSDATE,
2448: 1
2449: FROM cst_inv_qty_temp CIQT,
2450: cst_inv_cost_temp CICT
2451: WHERE CIQT.organization_id = p_org_id
2452: AND CIQT.organization_id = CICT.organization_id(+)
2453: AND NVL(CIQT.cost_group_id,-1) =