APPS.BOM_ALTERNATE_DESIGNATORS_PKG dependencies on BOM_OPERATIONAL_ROUTINGS

Line 92: FROM BOM_OPERATIONAL_ROUTINGS

88: WHERE BOM_BILL_OF_MATERIALS.Alternate_Bom_Designator =
89: X_Alt_Desig_Code
90: UNION
91: SELECT 1
92: FROM BOM_OPERATIONAL_ROUTINGS
93: WHERE BOM_OPERATIONAL_ROUTINGS.ALTERNATE_ROUTING_DESIGNATOR =
94: X_Alt_Desig_Code
95: UNION
96: SELECT 1

Line 93: WHERE BOM_OPERATIONAL_ROUTINGS.ALTERNATE_ROUTING_DESIGNATOR =

89: X_Alt_Desig_Code
90: UNION
91: SELECT 1
92: FROM BOM_OPERATIONAL_ROUTINGS
93: WHERE BOM_OPERATIONAL_ROUTINGS.ALTERNATE_ROUTING_DESIGNATOR =
94: X_Alt_Desig_Code
95: UNION
96: SELECT 1
97: FROM CST_COST_TYPES

Line 155: (SELECT 1 FROM BOM_OPERATIONAL_ROUTINGS

151: X_Alternate_Designator_Code
152: );
153:
154: SELECT 1 INTO DUMMY FROM DUAL WHERE NOT EXISTS
155: (SELECT 1 FROM BOM_OPERATIONAL_ROUTINGS
156: WHERE BOM_OPERATIONAL_ROUTINGS.Organization_Id = X_Organization_Id
157: AND BOM_OPERATIONAL_ROUTINGS.ALTERNATE_ROUTING_DESIGNATOR =
158: X_Alternate_Designator_Code
159: );

Line 156: WHERE BOM_OPERATIONAL_ROUTINGS.Organization_Id = X_Organization_Id

152: );
153:
154: SELECT 1 INTO DUMMY FROM DUAL WHERE NOT EXISTS
155: (SELECT 1 FROM BOM_OPERATIONAL_ROUTINGS
156: WHERE BOM_OPERATIONAL_ROUTINGS.Organization_Id = X_Organization_Id
157: AND BOM_OPERATIONAL_ROUTINGS.ALTERNATE_ROUTING_DESIGNATOR =
158: X_Alternate_Designator_Code
159: );
160:

Line 157: AND BOM_OPERATIONAL_ROUTINGS.ALTERNATE_ROUTING_DESIGNATOR =

153:
154: SELECT 1 INTO DUMMY FROM DUAL WHERE NOT EXISTS
155: (SELECT 1 FROM BOM_OPERATIONAL_ROUTINGS
156: WHERE BOM_OPERATIONAL_ROUTINGS.Organization_Id = X_Organization_Id
157: AND BOM_OPERATIONAL_ROUTINGS.ALTERNATE_ROUTING_DESIGNATOR =
158: X_Alternate_Designator_Code
159: );
160:
161: SELECT 1 INTO DUMMY FROM DUAL WHERE NOT EXISTS