DBA Data[Home] [Help]

APPS.CSTPSCCR dependencies on BOM_SUBSTITUTE_COMPONENTS

Line 3200: DELETE BOM_SUBSTITUTE_COMPONENTS bsc

3196: FROM BOM_INVENTORY_COMPONENTS bic
3197: WHERE bic.COMPONENT_SEQUENCE_ID = brd.COMPONENT_SEQUENCE_ID);
3198:
3199: sql_stmt_num := 20;
3200: DELETE BOM_SUBSTITUTE_COMPONENTS bsc
3201: WHERE NOT EXISTS
3202: (SELECT 'Component Header exists'
3203: FROM BOM_INVENTORY_COMPONENTS bic
3204: WHERE bic.COMPONENT_SEQUENCE_ID = bsc.COMPONENT_SEQUENCE_ID);