DBA Data[Home] [Help]

APPS.CSTPSCCR dependencies on CST_SC_LISTS

Line 392: FROM cst_sc_lists CSL

388: WHERE CIC.cost_type_id = p_dest_cost_type_id
389: AND CIC.based_on_rollup_flag = 1
390: AND (CIC.inventory_item_id, CIC.organization_id) IN
391: (SELECT CSL.inventory_item_id, CSL.organization_id
392: FROM cst_sc_lists CSL
393: WHERE CSL.rollup_id = p_rollup_id);
394:
395: l_stmt_num := 70;
396: UPDATE cst_item_cost_details CICD

Line 409: FROM cst_sc_lists CSL

405: AND CICD.basis_type = 2
406: AND CICD.level_type = 1
407: AND (CICD.inventory_item_id, CICD.organization_id) IN
408: (SELECT CSL.inventory_item_id, CSL.organization_id
409: FROM cst_sc_lists CSL
410: WHERE CSL.rollup_id = p_rollup_id)
411: AND EXISTS
412: (SELECT 'x' FROM cst_item_costs CIC2
413: WHERE CIC2.inventory_item_id = CICD.inventory_item_id