DBA Data[Home] [Help]

APPS.WIP_FLOW_VALIDATION dependencies on MTL_ITEM_LOCATIONS

Line 641: from mtl_item_locations mil

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

Line 666: mtl_item_locations mil

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