APPS.CST_ACCOUNTINGPERIOD_PUB dependencies on CST_INV_COST_TEMP

Line 1770: cst_inv_cost_temp CICT

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

Line 1799: DELETE CST_INV_COST_TEMP;

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

Line 2195: cst_inv_cost_temp CICT

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

Line 2305: cst_inv_cost_temp CICT

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