APPS.BOM_CSTRSCCR_XMLP_PKG dependencies on CST_SC_LISTS

Line 391: INSERT INTO CST_SC_LISTS

387: ,'rollup_id = ' || P_ROLLUP_ID)*/NULL;
388: L_STMT_NUM := 170;
389: IF (LP_RANGE_TYPE = 2 AND P_ITEM_ID IS NOT NULL) THEN
390: L_STMT_NUM := 110;
391: INSERT INTO CST_SC_LISTS
392: (ROLLUP_ID
393: ,INVENTORY_ITEM_ID
394: ,ORGANIZATION_ID
395: ,LAST_UPDATE_DATE

Line 455: INSERT INTO CST_SC_LISTS

451: AND nvl(MSI.INVENTORY_ITEM_STATUS_CODE,
452: 'NOT_' || BP.bom_delete_status_code (+)) <> BP.bom_delete_status_code (+);
453: ELSIF (LP_RANGE_TYPE = 5) THEN
454: L_STMT_NUM := 180;
455: INSERT INTO CST_SC_LISTS
456: (ROLLUP_ID
457: ,INVENTORY_ITEM_ID
458: ,ORGANIZATION_ID
459: ,LAST_UPDATE_DATE

Line 592: INSERT INTO CST_SC_LISTS

588: AND nvl(MSI.INVENTORY_ITEM_STATUS_CODE,
589: 'NOT_' || BP.bom_delete_status_code (+)) <> BP.bom_delete_status_code (+);
590: ELSE
591: L_STMT_NUM := 190;
592: INSERT INTO CST_SC_LISTS
593: (ROLLUP_ID
594: ,INVENTORY_ITEM_ID
595: ,ORGANIZATION_ID
596: ,LAST_UPDATE_DATE