DBA Data[Home] [Help]

APPS.INV_LOC_WMS_PUB dependencies on MTL_TRANSACTIONS_INTERFACE

Line 2505: /*Check if the locator is present in MTL_TRANSACTIONS_INTERFACE

2501: WHEN NO_DATA_FOUND THEN
2502: NULL;
2503: END;
2504:
2505: /*Check if the locator is present in MTL_TRANSACTIONS_INTERFACE
2506: If the locator_id exists then error out*/
2507: BEGIN
2508: SELECT 1
2509: INTO l_chk_flag

Line 2512: FROM mtl_transactions_interface

2508: SELECT 1
2509: INTO l_chk_flag
2510: FROM DUAL
2511: WHERE EXISTS(SELECT 1
2512: FROM mtl_transactions_interface
2513: WHERE locator_id = l_inventory_location_id
2514: AND organization_id = l_organization_id);
2515:
2516: fnd_message.set_name('INV', 'INV_LOC_PENDTXN');