395: ,'rollup_id = ' || P_ROLLUP_ID)*/NULL;
396: L_STMT_NUM := 170;
397: IF (LP_RANGE_TYPE = 2 AND P_ITEM_ID IS NOT NULL) THEN
398: L_STMT_NUM := 110;
399: INSERT INTO CST_SC_LISTS
400: (ROLLUP_ID
401: ,INVENTORY_ITEM_ID
402: ,ORGANIZATION_ID
403: ,LAST_UPDATE_DATE
459: AND nvl(MSI.INVENTORY_ITEM_STATUS_CODE,
460: 'NOT_' || BP.bom_delete_status_code (+)) <> BP.bom_delete_status_code (+);
461: ELSIF (LP_RANGE_TYPE = 5) THEN
462: L_STMT_NUM := 180;
463: INSERT INTO CST_SC_LISTS
464: (ROLLUP_ID
465: ,INVENTORY_ITEM_ID
466: ,ORGANIZATION_ID
467: ,LAST_UPDATE_DATE
596: AND nvl(MSI.INVENTORY_ITEM_STATUS_CODE,
597: 'NOT_' || BP.bom_delete_status_code (+)) <> BP.bom_delete_status_code (+);
598: ELSE
599: L_STMT_NUM := 190;
600: INSERT INTO CST_SC_LISTS
601: (ROLLUP_ID
602: ,INVENTORY_ITEM_ID
603: ,ORGANIZATION_ID
604: ,LAST_UPDATE_DATE