APPS.BOM_VALIDATE_REF_DESIGNATOR dependencies on BOM_REFERENCE_DESIGNATORS

Line 57: From bom_reference_designators brd

53: l_dummy varchar2(80);
54:
55: Cursor GetTotalQty is
56: Select brd.component_reference_designator
57: From bom_reference_designators brd
58: Where brd.component_sequence_id = p_old_component_sequence_id
59: And nvl(brd.acd_type, X_Add) = X_Add
60: Union
61: Select brd.component_reference_designator

Line 62: From bom_reference_designators brd,

58: Where brd.component_sequence_id = p_old_component_sequence_id
59: And nvl(brd.acd_type, X_Add) = X_Add
60: Union
61: Select brd.component_reference_designator
62: From bom_reference_designators brd,
63: bom_inventory_components bic
64: Where /* Bug 9346685 : Replaced decode with conditions
65: DECODE(bic.old_component_sequence_id, NULL,
66: bic.component_sequence_id,

Line 77: From bom_reference_designators brd,

73: And bic.implementation_date is null
74: And brd.acd_type = X_Add
75: Minus
76: Select brd.component_reference_designator
77: From bom_reference_designators brd,
78: bom_inventory_components bic
79: Where /* Bug 9346685 : Replaced decode with conditions
80: DECODE(bic.old_component_sequence_id, NULL,
81: bic.component_sequence_id,

Line 96: From bom_reference_designators brd ,

92: IF (Bom_Globals.Get_Bo_Identifier = Bom_Globals.G_BOM_BO) THEN
93: BEGIN
94: Select count(*)
95: Into X_TotalQuantity
96: From bom_reference_designators brd ,
97: bom_inventory_components bic
98: Where brd.component_sequence_id = p_old_component_sequence_id
99: And bic.component_sequence_id = brd.component_sequence_id
100: And bic.implementation_date is NOT NULL

Line 436: FROM bom_reference_designators brd,

432: BEGIN
433:
434: SELECT component_reference_designator
435: INTO l_dummy
436: FROM bom_reference_designators brd,
437: bom_inventory_components bic
438: WHERE bic.component_sequence_id =
439: p_ref_desg_unexp_rec.component_sequence_id
440: AND brd.component_sequence_id = bic.old_component_sequence_id

Line 713: FROM BOM_REFERENCE_DESIGNATORS

709: and p_ref_designator_rec.new_reference_designator <> FND_API.G_MISS_CHAR
710: and p_ref_designator_rec.transaction_type = Bom_Globals.G_OPR_UPDATE) THEN
711:
712: select count(*) into l_temp_var
713: FROM BOM_REFERENCE_DESIGNATORS
714: WHERE COMPONENT_REFERENCE_DESIGNATOR = p_ref_designator_rec.new_reference_designator
715: AND COMPONENT_SEQUENCE_ID = p_Ref_Desg_Unexp_Rec.component_sequence_id
716: AND NVL(DECODE(ACD_TYPE, FND_API.G_MISS_NUM, null, acd_type), 0) =
717: NVL(DECODE(p_ref_designator_rec.acd_type, FND_API.G_MISS_NUM, null, p_ref_designator_rec.acd_type), 0) ;