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');