APPS.ENG_VALIDATE_REF_DESIGNATOR dependencies on BOM_INVENTORY_COMPONENTS

Line 42: bom_inventory_components bic

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

Line 52: bom_inventory_components bic

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

Line 105: FROM bom_inventory_components bic

101: l_Err_text VARCHAR2(2000);
102:
103: CURSOR c_acdtype IS
104: SELECT acd_type, old_component_sequence_id
105: FROM bom_inventory_components bic
106: WHERE bic.component_sequence_id =
107: p_Ref_Desg_Unexp_Rec.component_sequence_id;
108:
109: CURSOR c_QuantityRelated IS

Line 111: FROM bom_inventory_components

107: p_Ref_Desg_Unexp_Rec.component_sequence_id;
108:
109: CURSOR c_QuantityRelated IS
110: SELECT component_quantity
111: FROM bom_inventory_components
112: WHERE component_sequence_id =
113: p_Ref_Desg_Unexp_rec.component_sequence_id
114: AND quantity_related = 1;
115: BEGIN

Line 160: FROM bom_inventory_components

156: IF p_ref_designator_rec.acd_type = 3 THEN
157: BEGIN
158: SELECT 1
159: INTO l_dummy
160: FROM bom_inventory_components
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

Line 242: FROM bom_inventory_Components bic

238:
239: BEGIN
240: SELECT 'Non-Standard Comp'
241: INTO l_dummy
242: FROM bom_inventory_Components bic
243: WHERE bic.component_sequence_id =
244: p_Ref_Desg_Unexp_Rec.component_sequence_id
245: AND bic.bom_item_type in (1, 2, 3); /*MODEL,OPTION CLASS,PLANNING*/
246:

Line 291: bom_inventory_components bic

287: FROM sys.dual
288: WHERE EXISTS (SELECT 'Planning Item'
289: FROM bom_bill_of_materials bom,
290: mtl_system_items msi,
291: bom_inventory_components bic
292: WHERE msi.bom_item_type = 3 /* PLANNING */
293: AND msi.inventory_item_id = bom.assembly_item_id
294: AND msi.organization_id = bom.organization_id
295: AND bom.bill_sequence_id = bic.bill_sequence_id

Line 547: FROM bom_inventory_components

543: -- going to make the number or designators <> Component Quantity.
544: ************************************************************************/
545: SELECT 'Related'
546: INTO l_dummy
547: FROM bom_inventory_components
548: WHERE quantity_related = 1
549: AND component_sequence_id =
550: p_ref_desg_Unexp_rec.component_sequence_id;
551:

Line 671: FROM bom_inventory_components

667: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
668:
669: CURSOR c_GetComponent IS
670: SELECT revised_item_sequence_id
671: FROM bom_inventory_components
672: WHERE component_item_id= p_ref_desg_unexp_rec.component_item_id
673: AND operation_seq_num=p_ref_designator_rec.operation_sequence_number
674: AND effectivity_date = p_ref_designator_rec.start_effective_date
675: AND bill_sequence_id = p_ref_desg_unexp_rec.bill_sequence_id;

Line 733: FROM bom_inventory_components bic

729: ************************************************************************/
730: BEGIN
731: SELECT 'parent not disabled'
732: INTO l_dummy
733: FROM bom_inventory_components bic
734: WHERE bic.component_sequence_id =
735: p_Ref_Desg_Unexp_Rec.component_sequence_id
736: AND NVL(bic.acd_type, 0) <> 3;
737: EXCEPTION