2457: AND RI.CHANGE_NOTICE = change_order
2458: AND IC.REVISED_ITEM_SEQUENCE_ID = RI.REVISED_ITEM_SEQUENCE_ID
2459: AND IC.IMPLEMENTATION_DATE IS NULL);
2460:
2461: -- Insert the cancelled rev components into eng_revised_components
2462:
2463: INSERT INTO ENG_REVISED_COMPONENTS (
2464: COMPONENT_SEQUENCE_ID,
2465: COMPONENT_ITEM_ID,
2459: AND IC.IMPLEMENTATION_DATE IS NULL);
2460:
2461: -- Insert the cancelled rev components into eng_revised_components
2462:
2463: INSERT INTO ENG_REVISED_COMPONENTS (
2464: COMPONENT_SEQUENCE_ID,
2465: COMPONENT_ITEM_ID,
2466: OPERATION_SEQUENCE_NUM,
2467: BILL_SEQUENCE_ID,