APPS.CSTPSCCM dependencies on CST_SC_BOM_EXPLOSION

Line 884: DELETE CST_SC_BOM_EXPLOSION CSBE

880: AND CSBS1.COMPONENT_ORGANIZATION_ID = CSLLC.ORGANIZATION_ID);
881:
882: l_stmt_num := 20;
883:
884: DELETE CST_SC_BOM_EXPLOSION CSBE
885: WHERE CSBE.ROLLUP_ID IN (
886: SELECT CSRH.ROLLUP_ID
887: FROM CST_SC_ROLLUP_HISTORY CSRH
888: WHERE CSRH.ROLLUP_ID <> p_rollup_id

Line 895: FROM CST_SC_BOM_EXPLOSION CSBE1,

891: CSBE.COMPONENT_ORGANIZATION_ID)
892: IN
893: (SELECT CSBE1.COMPONENT_ITEM_ID,
894: CSBE1.COMPONENT_ORGANIZATION_ID
895: FROM CST_SC_BOM_EXPLOSION CSBE1,
896: CST_SC_LOW_LEVEL_CODES CSLLC
897: WHERE CSBE1.ROLLUP_ID = p_rollup_id
898: AND CSBE1.ROLLUP_ID = CSLLC.ROLLUP_ID
899: AND CSBE1.COMPONENT_ITEM_ID = CSLLC.INVENTORY_ITEM_ID