DBA Data[Home] [Help]

APPS.INV_DETAIL_UTIL_PVT dependencies on MTL_STATUS_TRANSACTION_CONTROL

Line 4336: AND NOT EXISTS(SELECT 1 from mtl_status_transaction_control mtc

4332: AND moqd.inventory_item_id = p_inventory_item_id
4333: AND moqd.subinventory_code = p_subinventory_code
4334: AND nvl(moqd.locator_id,-999) = nvl(p_locator_id,-999)
4335: AND nvl(moqd.lot_number,-999) = nvl(p_lot_number, -999)
4336: AND NOT EXISTS(SELECT 1 from mtl_status_transaction_control mtc
4337: WHERE mtc.status_id = moqd.status_id
4338: AND mtc.transaction_type_id = p_transaction_type_id
4339: AND mtc.is_allowed = 2 ));
4340: EXCEPTION