DBA Data[Home] [Help]

APPS.INV_DETAIL_UTIL_PVT dependencies on MTL_STATUS_TRANSACTION_CONTROL

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

3913: AND moqd.inventory_item_id = p_inventory_item_id
3914: AND moqd.subinventory_code = p_subinventory_code
3915: AND nvl(moqd.locator_id,-999) = nvl(p_locator_id,-999)
3916: AND nvl(moqd.lot_number,-999) = nvl(p_lot_number, -999)
3917: AND NOT EXISTS(SELECT 1 from mtl_status_transaction_control mtc
3918: WHERE mtc.status_id = moqd.status_id
3919: AND mtc.transaction_type_id = p_transaction_type_id
3920: AND mtc.is_allowed = 2 ));
3921: EXCEPTION