APPS.CST_ACCOUNTINGPERIOD_PUB dependencies on CST_INV_COST_TEMP

Line 1813: cst_inv_cost_temp CICT

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) =
1817: NVL(CICT.cost_group_id,NVL(CIQT.cost_group_id,-1))

Line 1847: DELETE CST_INV_COST_TEMP;

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
1851: INTO cst_inv_qty_temp(

Line 2332: cst_inv_cost_temp CICT

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) =
2336: NVL(CICT.cost_group_id,NVL(CIQT.cost_group_id,-1))

Line 2450: cst_inv_cost_temp CICT

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) =
2454: NVL(CICT.cost_group_id,NVL(CIQT.cost_group_id,-1))