APPS.ENG_CHANGE_IMPORT_UTIL dependencies on BOM_COMPONENTS_B

Line 4182: FROM bom_components_b

4178: THEN
4179: l_component_seq_id := p_component_seq_id;
4180: SELECT component_item_id, operation_seq_num, effectivity_date, from_end_item_unit_number, from_end_item_rev_id
4181: INTO l_component_item_id, l_op_seq_number, l_effectivity_date, l_from_end_item_unit_number, l_from_end_item_rev_id
4182: FROM bom_components_b
4183: WHERE component_sequence_id = p_component_seq_id;
4184: ELSE
4185: IF l_effectivity_control = 2 -- Unit Effective
4186: THEN

Line 4189: FROM bom_components_b bcb

4185: IF l_effectivity_control = 2 -- Unit Effective
4186: THEN
4187: SELECT component_sequence_id
4188: INTO l_component_seq_id
4189: FROM bom_components_b bcb
4190: WHERE bcb.bill_sequence_id = l_bill_sequence_id
4191: AND bcb.operation_seq_num = p_op_seq_number
4192: AND bcb.component_item_id = p_component_item_id
4193: AND bcb.from_end_item_unit_number = p_from_end_item_unit_number

Line 4200: FROM bom_components_b bcb

4196: ELSIF l_effectivity_control = 4 -- Rev Effective
4197: THEN
4198: SELECT component_sequence_id
4199: INTO l_component_seq_id
4200: FROM bom_components_b bcb
4201: WHERE bcb.bill_sequence_id = l_bill_sequence_id
4202: AND bcb.operation_seq_num = p_op_seq_number
4203: AND bcb.component_item_id = p_component_item_id
4204: AND bcb.from_end_item_rev_id = p_from_end_item_rev_id

Line 4210: FROM bom_components_b bcb

4206:
4207: ELSE
4208: SELECT component_sequence_id
4209: INTO l_component_seq_id
4210: FROM bom_components_b bcb
4211: WHERE bcb.bill_sequence_id = l_bill_sequence_id
4212: AND bcb.operation_seq_num = p_op_seq_number
4213: AND bcb.component_item_id = p_component_item_id
4214: AND bcb.effectivity_date = p_effectivity_date