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