DBA Data[Home] [Help]

APPS.INVUPD2B dependencies on BOM_COMPONENTS_B

Line 4693: FROM bom_components_b bic, bom_structures_b bbom

4689: if (msii_temp.pick_components_flag = 'Y'
4690: OR msii_temp.pick_components_flag = 'y') then
4691: begin
4692: SELECT 1 INTO l_item_has_lot_comp
4693: FROM bom_components_b bic, bom_structures_b bbom
4694: WHERE bic.basis_type =2
4695: and bic.bill_sequence_id=bbom.common_bill_sequence_id
4696: and bbom.assembly_item_id=msii_temp.inventory_item_id
4697: and bbom.organization_id =msii_temp.organization_id