APPS.BOM_UTIL dependencies on BOM_REFERENCE_DESIGNATORS

Line 186: FROM bom_reference_designators brd

182: l_dummy VARCHAR2(80);
183:
184: CURSOR GetTotalQty IS
185: SELECT brd.component_reference_designator
186: FROM bom_reference_designators brd
187: WHERE brd.component_sequence_id = p_old_component_sequence_id
188: AND NVL(brd.acd_type, X_Add) = X_Add
189: UNION
190: SELECT brd.component_reference_designator

Line 191: FROM bom_reference_designators brd,

187: WHERE brd.component_sequence_id = p_old_component_sequence_id
188: AND NVL(brd.acd_type, X_Add) = X_Add
189: UNION
190: SELECT brd.component_reference_designator
191: FROM bom_reference_designators brd,
192: bom_inventory_components bic
193: WHERE DECODE(bic.old_component_sequence_id, NULL,
194: bic.component_sequence_id,
195: bic.old_component_sequence_id) = p_old_component_sequence_id

Line 201: FROM bom_reference_designators brd,

197: AND bic.implementation_date IS NULL
198: AND brd.acd_type = X_Add
199: MINUS
200: SELECT brd.component_reference_designator
201: FROM bom_reference_designators brd,
202: bom_inventory_components bic
203: WHERE DECODE(bic.old_component_sequence_id, NULL,
204: bic.component_sequence_id,
205: bic.old_component_sequence_id) = p_old_component_sequence_id

Line 253: FROM bom_reference_designators brd,bom_inventory_components bic

249: IF p_acd_type = 3 THEN
250:
251: BEGIN
252: SELECT component_reference_designator INTO l_dummy
253: FROM bom_reference_designators brd,bom_inventory_components bic
254: WHERE bic.component_sequence_id = p_component_seq_id
255: AND brd.component_sequence_id = bic.old_component_sequence_id
256: AND brd.component_reference_designator = p_ref_desig_name;
257: