DBA Data[Home] [Help]

APPS.PO_VAL_DISTRIBUTIONS2 dependencies on MTL_ITEM_SUB_INVENTORIES

Line 729: FROM mtl_item_sub_inventories mis

725: AND ( msi.restrict_subinventories_code = 2
726: OR ( msi.restrict_subinventories_code = 1
727: AND EXISTS(
728: SELECT NULL
729: FROM mtl_item_sub_inventories mis
730: WHERE mis.organization_id =
731: NVL(p_ship_to_org_id_tbl(i), mis.organization_id)
732: AND mis.inventory_item_id = msi.inventory_item_id
733: AND mis.secondary_inventory = msub.secondary_inventory_name))))))