APPS.BOMPECOD dependencies on BOM_INVENTORY_COMPONENTS

Line 22: FROM BOM_INVENTORY_COMPONENTS C,

18:
19: DELETE FROM BOM_REFERENCE_DESIGNATORS R
20: WHERE R.COMPONENT_SEQUENCE_ID IN
21: (SELECT C.COMPONENT_SEQUENCE_ID
22: FROM BOM_INVENTORY_COMPONENTS C,
23: ENG_REVISED_ITEMS RI
24: WHERE RI.REVISED_ITEM_SEQUENCE_ID = C.REVISED_ITEM_SEQUENCE_ID
25: AND RI.ORGANIZATION_ID = P_ORGANIZATION_ID
26: AND RI.CHANGE_NOTICE = P_CHANGE_NOTICE

Line 32: FROM BOM_INVENTORY_COMPONENTS C,

28:
29: DELETE FROM BOM_SUBSTITUTE_COMPONENTS S
30: WHERE S.COMPONENT_SEQUENCE_ID IN
31: (SELECT C.COMPONENT_SEQUENCE_ID
32: FROM BOM_INVENTORY_COMPONENTS C,
33: ENG_REVISED_ITEMS RI
34: WHERE RI.REVISED_ITEM_SEQUENCE_ID = C.REVISED_ITEM_SEQUENCE_ID
35: AND RI.ORGANIZATION_ID = P_ORGANIZATION_ID
36: AND RI.CHANGE_NOTICE = P_CHANGE_NOTICE

Line 40: DELETE FROM BOM_INVENTORY_COMPONENTS C

36: AND RI.CHANGE_NOTICE = P_CHANGE_NOTICE
37: AND C.IMPLEMENTATION_DATE IS NULL);
38:
39:
40: DELETE FROM BOM_INVENTORY_COMPONENTS C
41: WHERE C.IMPLEMENTATION_DATE IS NULL
42: AND C.REVISED_ITEM_SEQUENCE_ID IN
43: (SELECT R.REVISED_ITEM_SEQUENCE_ID
44: FROM ENG_REVISED_ITEMS R

Line 48: UPDATE BOM_INVENTORY_COMPONENTS C

44: FROM ENG_REVISED_ITEMS R
45: WHERE R.ORGANIZATION_ID = P_ORGANIZATION_ID
46: AND R.CHANGE_NOTICE = P_CHANGE_NOTICE);
47:
48: UPDATE BOM_INVENTORY_COMPONENTS C
49: SET C.REVISED_ITEM_SEQUENCE_ID = NULL
50: -- C.CHANGE_NOTICE = NULL -- Bug2627917
51: WHERE C.IMPLEMENTATION_DATE IS NOT NULL
52: AND C.REVISED_ITEM_SEQUENCE_ID IN

Line 98: FROM BOM_INVENTORY_COMPONENTS C

94: DELETE FROM BOM_BILL_OF_MATERIALS B
95: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
96: AND PENDING_FROM_ECN = P_CHANGE_NOTICE
97: AND NOT EXISTS (SELECT NULL
98: FROM BOM_INVENTORY_COMPONENTS C
99: WHERE C.BILL_SEQUENCE_ID = B.BILL_SEQUENCE_ID)
100: AND NOT EXISTS (SELECT NULL
101: FROM ENG_REVISED_ITEMS R
102: WHERE R.BILL_SEQUENCE_ID = B.BILL_SEQUENCE_ID);