DBA Data[Home] [Help]

APPS.PO_PDOI_DISTRIBUTIONS_SV3 dependencies on MTL_SYSTEM_ITEMS

Line 946: from mtl_system_items msi

942: and (x_item_id is null
943: or
944: (x_item_id is not null
945: and exists (select null
946: from mtl_system_items msi
947: where msi.organization_id = nvl(x_ship_to_organization_id, msi.organization_id)
948: and msi.inventory_item_id = x_item_id
949: and (msi.restrict_subinventories_code = 2
950: or (msi.restrict_subinventories_code = 1