DBA Data[Home] [Help]

APPS.WIP_FLOW_VALIDATION dependencies on MTL_ITEM_LOCATIONS

Line 642: from mtl_item_locations mil

638: and ( ( mti.locator_id is not null
639: and exists
640: (
641: select 1
642: from mtl_item_locations mil
643: where mil.inventory_location_id =
644: mti.locator_id
645: and mil.subinventory_code =
646: mti.subinventory_code

Line 667: mtl_item_locations mil

663: if (x_proj_ref_exists = 1 ) then
664:
665: select 1 into x_success
666: from mtl_transactions_interface mti,
667: mtl_item_locations mil
668: where mti.rowid = p_rowid
669: and ( ( mti.locator_id is not null
670: and mil.inventory_location_id = mti.locator_id
671: and mil.organization_id = mti.organization_id