DBA Data[Home] [Help]

APPS.INVUPD2B dependencies on BOM_STRUCTURES_B

Line 4548: FROM bom_components_b bic, bom_structures_b bbom

4544: if (msii_temp.pick_components_flag = 'Y'
4545: OR msii_temp.pick_components_flag = 'y') then
4546: begin
4547: SELECT 1 INTO l_item_has_lot_comp
4548: FROM bom_components_b bic, bom_structures_b bbom
4549: WHERE bic.basis_type =2
4550: and bic.bill_sequence_id=bbom.common_bill_sequence_id
4551: and bbom.assembly_item_id=msii_temp.inventory_item_id
4552: and bbom.organization_id =msii_temp.organization_id