APPS.ENG_CHANGE_IMPORT_UTIL dependencies on BOM_STRUCTURES_B

Line 4253: FROM BOM_STRUCTURES_B

4249: THEN
4250: l_bill_sequence_id := p_bill_sequence_id;
4251: SELECT effectivity_control
4252: INTO l_effectivity_control
4253: FROM BOM_STRUCTURES_B
4254: WHERE bill_sequence_id = p_bill_sequence_id;
4255: ELSE
4256: SELECT bill_sequence_id, effectivity_control
4257: INTO l_bill_sequence_id, l_effectivity_control

Line 4258: FROM BOM_STRUCTURES_B

4254: WHERE bill_sequence_id = p_bill_sequence_id;
4255: ELSE
4256: SELECT bill_sequence_id, effectivity_control
4257: INTO l_bill_sequence_id, l_effectivity_control
4258: FROM BOM_STRUCTURES_B
4259: WHERE assembly_item_id = p_assembly_item_id
4260: AND organization_id = p_organization_id
4261: AND ((alternate_bom_designator IS NULL AND
4262: p_alternate_bom_designator IS NULL) OR

Line 4537: FROM BOM_STRUCTURES_B

4533: THEN
4534: l_bill_sequence_id := p_bill_sequence_id;
4535: SELECT effectivity_control, alternate_bom_Designator
4536: INTO l_effectivity_control, l_alt_bom_designator
4537: FROM BOM_STRUCTURES_B
4538: WHERE bill_sequence_id = p_bill_sequence_id;
4539: ELSE
4540: SELECT bill_sequence_id, effectivity_control
4541: INTO l_bill_sequence_id, l_effectivity_control

Line 4542: FROM BOM_STRUCTURES_B

4538: WHERE bill_sequence_id = p_bill_sequence_id;
4539: ELSE
4540: SELECT bill_sequence_id, effectivity_control
4541: INTO l_bill_sequence_id, l_effectivity_control
4542: FROM BOM_STRUCTURES_B
4543: WHERE assembly_item_id = p_assembly_item_id
4544: AND organization_id = p_organization_id
4545: AND ((alternate_bom_designator IS NULL AND
4546: p_alternate_bom_designator IS NULL) OR