DBA Data[Home] [Help]

APPS.ENG_VALIDATE_REF_DESIGNATOR dependencies on BOM_REFERENCE_DESIGNATORS

Line 36: From bom_reference_designators brd

32: l_dummy varchar2(80);
33:
34: Cursor GetTotalQty is
35: Select brd.component_reference_designator
36: From bom_reference_designators brd
37: Where brd.component_sequence_id = p_old_component_sequence_id
38: And nvl(brd.acd_type, X_Add) = X_Add
39: Union
40: Select brd.component_reference_designator

Line 41: From bom_reference_designators brd,

37: Where brd.component_sequence_id = p_old_component_sequence_id
38: And nvl(brd.acd_type, X_Add) = X_Add
39: Union
40: Select brd.component_reference_designator
41: From bom_reference_designators brd,
42: bom_inventory_components bic
43: Where DECODE(bic.old_component_sequence_id, NULL,
44: bic.component_sequence_id,
45: bic.old_component_sequence_id) = p_old_component_sequence_id

Line 51: From bom_reference_designators brd,

47: And bic.implementation_date is null
48: And brd.acd_type = X_Add
49: Minus
50: Select brd.component_reference_designator
51: From bom_reference_designators brd,
52: bom_inventory_components bic
53: Where DECODE(bic.old_component_sequence_id, NULL,
54: bic.component_sequence_id,
55: bic.old_component_sequence_id) = p_old_component_sequence_id

Line 165: FROM bom_reference_designators

161: WHERE component_sequence_id =
162: p_ref_desg_unexp_rec.component_sequence_id
163: AND implementation_date IS NOT NULL
164: AND exists ( SELECT 1
165: FROM bom_reference_designators
166: WHERE component_sequence_id =
167: p_ref_desg_unexp_rec.component_sequence_id
168: AND component_reference_designator =
169: p_ref_designator_rec.reference_designator_name