APPS.CST_ACCOUNTINGPERIOD_PUB dependencies on CST_INV_QTY_TEMP

Line 1769: FROM cst_inv_qty_temp CIQT,

1765: 6,NVL(CIQT.rollback_qty,0),
1766: 7,NVL(CIQT.rollback_qty,0),
1767: 8,NVL(CIQT.rollback_qty,0),
1768: 0))*NVL(CICT.item_cost,0) rollback_intransit_value
1769: FROM cst_inv_qty_temp CIQT,
1770: cst_inv_cost_temp CICT
1771: WHERE CIQT.organization_id = p_org_id
1772: AND CIQT.organization_id = CICT.organization_id
1773: AND NVL(CIQT.cost_group_id,-1) =

Line 1798: DELETE CST_INV_QTY_TEMP;

1794: l_stmt_num := 56;
1795: DELETE CST_ITEM_LIST_TEMP;
1796: DELETE CST_CG_LIST_TEMP;
1797: DELETE CST_SUB_LIST_TEMP;
1798: DELETE CST_INV_QTY_TEMP;
1799: DELETE CST_INV_COST_TEMP;
1800:
1801: l_stmt_num := 57;
1802: INSERT

Line 1803: INTO cst_inv_qty_temp(

1799: DELETE CST_INV_COST_TEMP;
1800:
1801: l_stmt_num := 57;
1802: INSERT
1803: INTO cst_inv_qty_temp(
1804: qty_source,
1805: organization_id,
1806: cost_group_id,
1807: subinventory_code,

Line 1879: INTO cst_inv_qty_temp(

1875: l_stmt_num := 60;
1876: --we did not already insert baseline from
1877: --CPCST initialization, so insert from CPCS
1878: INSERT
1879: INTO cst_inv_qty_temp(
1880: qty_source,
1881: organization_id,
1882: cost_group_id,
1883: subinventory_code,

Line 1962: INTO cst_inv_qty_temp(

1958: l_stmt_num := 70;
1959: --summarize accounted value from MTA where
1960: --the primary quantity is the same in MTA and MMT
1961: INSERT
1962: INTO cst_inv_qty_temp(
1963: qty_source,
1964: organization_id,
1965: cost_group_id,
1966: subinventory_code,

Line 2055: INTO cst_inv_qty_temp(

2051: l_stmt_num := 80;
2052: --summarize accounted value from MTA where
2053: --the primary quantity is different in MTA and MMT (using transfer sub, org, etc)
2054: INSERT
2055: INTO cst_inv_qty_temp(
2056: qty_source,
2057: organization_id,
2058: cost_group_id,
2059: subinventory_code,

Line 2099: INTO cst_inv_qty_temp(

2095:
2096: l_stmt_num := 85;
2097: --summarize intransit value from MTA
2098: INSERT
2099: INTO cst_inv_qty_temp(
2100: qty_source,
2101: organization_id,
2102: cost_group_id,
2103: subinventory_code,

Line 2194: FROM cst_inv_qty_temp CIQT,

2190: 22,0,
2191: NVL(CIQT.accounted_value,0))) accounted_value,
2192: SUM(NVL(CIQT.rollback_qty,0))*NVL(CICT.item_cost,0) rollback_value,
2193: SUM(NVL(CIQT.rollback_qty,0))
2194: FROM cst_inv_qty_temp CIQT,
2195: cst_inv_cost_temp CICT
2196: WHERE CIQT.organization_id = p_org_id
2197: AND CIQT.organization_id = CICT.organization_id(+)
2198: AND NVL(CIQT.cost_group_id,-1) =

Line 2304: FROM cst_inv_qty_temp CIQT,

2300: SYSDATE,
2301: 1,
2302: SYSDATE,
2303: 1
2304: FROM cst_inv_qty_temp CIQT,
2305: cst_inv_cost_temp CICT
2306: WHERE CIQT.organization_id = p_org_id
2307: AND CIQT.organization_id = CICT.organization_id(+)
2308: AND NVL(CIQT.cost_group_id,-1) =