DBA Data[Home] [Help]

APPS.PO_VAL_DISTRIBUTIONS2 dependencies on MTL_ITEM_SUB_INVENTORIES

Line 741: FROM mtl_item_sub_inventories mis

737: AND ( msi.restrict_subinventories_code = 2
738: OR ( msi.restrict_subinventories_code = 1
739: AND EXISTS(
740: SELECT NULL
741: FROM mtl_item_sub_inventories mis
742: WHERE mis.organization_id =
743: NVL(p_ship_to_org_id_tbl(i), mis.organization_id)
744: AND mis.inventory_item_id = msi.inventory_item_id
745: AND mis.secondary_inventory = msub.secondary_inventory_name))))))