APPS.BOM_VALIDATE_REF_DESIGNATOR dependencies on BOM_INVENTORY_COMPONENTS

Line 63: bom_inventory_components bic

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
67: And bic.component_sequence_id = brd.component_sequence_id

Line 73: bom_inventory_components bic

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
77: And bic.component_sequence_id = brd.component_sequence_id

Line 87: bom_inventory_components bic

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
91: And nvl(brd.acd_type, 1) = 1 ;

Line 139: FROM bom_inventory_components

135: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
136:
137: CURSOR c_QuantityRelated IS
138: SELECT component_quantity
139: FROM bom_inventory_components
140: WHERE component_sequence_id = p_component_sequence_id
141: AND quantity_related = 1;
142:
143: CURSOR c_acdtype IS

Line 145: FROM bom_inventory_components bic

141: AND quantity_related = 1;
142:
143: CURSOR c_acdtype IS
144: SELECT acd_type, old_component_sequence_id
145: FROM bom_inventory_components bic
146: WHERE bic.component_sequence_id = p_component_sequence_id;
147: BEGIN
148: /*****************************************************************
149: --

Line 233: FROM bom_inventory_components bic

229: l_assy_bom_enabled VARCHAR2(1);
230:
231: CURSOR c_acdtype IS
232: SELECT acd_type, old_component_sequence_id
233: FROM bom_inventory_components bic
234: WHERE bic.component_sequence_id =
235: p_Ref_Desg_Unexp_Rec.component_sequence_id;
236:
237: CURSOR c_QuantityRelated IS

Line 239: FROM bom_inventory_components

235: p_Ref_Desg_Unexp_Rec.component_sequence_id;
236:
237: CURSOR c_QuantityRelated IS
238: SELECT component_quantity
239: FROM bom_inventory_components
240: WHERE component_sequence_id =
241: p_Ref_Desg_Unexp_rec.component_sequence_id
242: AND quantity_related = 1;
243: BEGIN

Line 352: bom_inventory_components bic

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
356: AND brd.component_reference_designator =

Line 432: FROM bom_inventory_Components bic

428:
429: BEGIN
430: SELECT 'Non-Standard Comp'
431: INTO l_dummy
432: FROM bom_inventory_Components bic
433: WHERE bic.component_sequence_id =
434: p_Ref_Desg_Unexp_Rec.component_sequence_id
435: AND bic.bom_item_type in (1, 2, 3); /*MODEL,OPTION CLASS,PLANNING*/
436:

Line 481: bom_inventory_components bic

477: FROM sys.dual
478: WHERE EXISTS (SELECT 'Planning Item'
479: FROM bom_bill_of_materials bom,
480: mtl_system_items msi,
481: bom_inventory_components bic
482: WHERE msi.bom_item_type = 3 /* PLANNING */
483: AND msi.inventory_item_id = bom.assembly_item_id
484: AND msi.organization_id = bom.organization_id
485: AND bom.bill_sequence_id = bic.bill_sequence_id

Line 785: FROM bom_inventory_components

781: ************************************************************************/
782: BEGIN
783: SELECT 'Related'
784: INTO l_dummy
785: FROM bom_inventory_components
786: WHERE quantity_related = 1
787: AND component_sequence_id =
788: p_ref_desg_Unexp_rec.component_sequence_id;
789:

Line 934: FROM bom_inventory_components

930: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
931:
932: CURSOR c_GetComponent IS
933: SELECT revised_item_sequence_id
934: FROM bom_inventory_components
935: WHERE component_item_id= p_ref_desg_unexp_rec.component_item_id
936: AND operation_seq_num=p_ref_designator_rec.operation_sequence_number
937: AND effectivity_date = p_ref_designator_rec.start_effective_date
938: AND bill_sequence_id = p_ref_desg_unexp_rec.bill_sequence_id;

Line 996: FROM bom_inventory_components bic

992: ************************************************************************/
993: BEGIN
994: SELECT 'parent not disabled'
995: INTO l_dummy
996: FROM bom_inventory_components bic
997: WHERE bic.component_sequence_id =
998: p_Ref_Desg_Unexp_Rec.component_sequence_id
999: AND NVL(bic.acd_type, 0) <> 3;
1000: EXCEPTION