APPS.ENG_CHANGE_IMPORT_UTIL dependencies on BOM_COMPONENTS_B

Line 4288: FROM bom_components_b

4284: THEN
4285: l_component_seq_id := p_component_seq_id;
4286: SELECT component_item_id, operation_seq_num, effectivity_date, from_end_item_unit_number, from_end_item_rev_id
4287: INTO l_component_item_id, l_op_seq_number, l_effectivity_date, l_from_end_item_unit_number, l_from_end_item_rev_id
4288: FROM bom_components_b
4289: WHERE component_sequence_id = p_component_seq_id;
4290: ELSE
4291: IF l_effectivity_control = 2 -- Unit Effective
4292: THEN

Line 4295: FROM bom_components_b bcb

4291: IF l_effectivity_control = 2 -- Unit Effective
4292: THEN
4293: SELECT component_sequence_id
4294: INTO l_component_seq_id
4295: FROM bom_components_b bcb
4296: WHERE bcb.bill_sequence_id = l_bill_sequence_id
4297: AND bcb.operation_seq_num = p_op_seq_number
4298: AND bcb.component_item_id = p_component_item_id
4299: AND bcb.from_end_item_unit_number = p_from_end_item_unit_number

Line 4306: FROM bom_components_b bcb

4302: ELSIF l_effectivity_control = 4 -- Rev Effective
4303: THEN
4304: SELECT component_sequence_id
4305: INTO l_component_seq_id
4306: FROM bom_components_b bcb
4307: WHERE bcb.bill_sequence_id = l_bill_sequence_id
4308: AND bcb.operation_seq_num = p_op_seq_number
4309: AND bcb.component_item_id = p_component_item_id
4310: AND bcb.from_end_item_rev_id = p_from_end_item_rev_id

Line 4316: FROM bom_components_b bcb

4312:
4313: ELSE
4314: SELECT component_sequence_id
4315: INTO l_component_seq_id
4316: FROM bom_components_b bcb
4317: WHERE bcb.bill_sequence_id = l_bill_sequence_id
4318: AND bcb.operation_seq_num = p_op_seq_number
4319: AND bcb.component_item_id = p_component_item_id
4320: AND bcb.effectivity_date = p_effectivity_date