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 DECODE(bic.old_component_sequence_id, NULL,
65: bic.component_sequence_id,
66: bic.old_component_sequence_id) = p_old_component_sequence_id

Line 72: From bom_reference_designators brd,

68: And bic.implementation_date is null
69: And brd.acd_type = X_Add
70: Minus
71: Select brd.component_reference_designator
72: From bom_reference_designators brd,
73: bom_inventory_components bic
74: Where DECODE(bic.old_component_sequence_id, NULL,
75: bic.component_sequence_id,
76: bic.old_component_sequence_id) = p_old_component_sequence_id

Line 86: From bom_reference_designators brd ,

82: IF (Bom_Globals.Get_Bo_Identifier = Bom_Globals.G_BOM_BO) THEN
83: BEGIN
84: Select count(*)
85: Into X_TotalQuantity
86: From bom_reference_designators brd ,
87: bom_inventory_components bic
88: Where brd.component_sequence_id = p_old_component_sequence_id
89: And bic.component_sequence_id = brd.component_sequence_id
90: And bic.implementation_date is NOT NULL

Line 351: FROM bom_reference_designators brd,

347: BEGIN
348:
349: SELECT component_reference_designator
350: INTO l_dummy
351: FROM bom_reference_designators brd,
352: bom_inventory_components bic
353: WHERE bic.component_sequence_id =
354: p_ref_desg_unexp_rec.component_sequence_id
355: AND brd.component_sequence_id = bic.old_component_sequence_id

Line 625: FROM BOM_REFERENCE_DESIGNATORS

621: and p_ref_designator_rec.new_reference_designator <> FND_API.G_MISS_CHAR
622: and p_ref_designator_rec.transaction_type = Bom_Globals.G_OPR_UPDATE) THEN
623:
624: select count(*) into l_temp_var
625: FROM BOM_REFERENCE_DESIGNATORS
626: WHERE COMPONENT_REFERENCE_DESIGNATOR = p_ref_designator_rec.new_reference_designator
627: AND COMPONENT_SEQUENCE_ID = p_Ref_Desg_Unexp_Rec.component_sequence_id
628: AND NVL(DECODE(ACD_TYPE, FND_API.G_MISS_NUM, null, acd_type), 0) =
629: NVL(DECODE(p_ref_designator_rec.acd_type, FND_API.G_MISS_NUM, null, p_ref_designator_rec.acd_type), 0) ;