DBA Data[Home] [Help]

APPS.PO_COPYDOC_SUB dependencies on MTL_ITEM_SUB_INVENTORIES

Line 2139: from mtl_item_sub_inventories mis

2135: and msi.inventory_item_id = x_item_id
2136: and (msi.restrict_subinventories_code = 2
2137: or (msi.restrict_subinventories_code = 1
2138: and exists (select null
2139: from mtl_item_sub_inventories mis
2140: where mis.organization_id = nvl(x_ship_to_organization_id , mis.organization_id)
2141: and mis.inventory_item_id = msi.inventory_item_id
2142: and mis.secondary_inventory = msub.secondary_inventory_name))))))
2143: and msub.secondary_inventory_name = x_destination_subinventory;