DBA Data[Home] [Help]

APPS.INV_LOC_WMS_PUB dependencies on MTL_TRANSACTIONS_INTERFACE

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

2597: WHEN NO_DATA_FOUND THEN
2598: NULL;
2599: END;
2600:
2601: /*Check if the locator is present in MTL_TRANSACTIONS_INTERFACE
2602: If the locator_id exists then error out*/
2603: BEGIN
2604: SELECT 1
2605: INTO l_chk_flag

Line 2608: FROM mtl_transactions_interface

2604: SELECT 1
2605: INTO l_chk_flag
2606: FROM DUAL
2607: WHERE EXISTS(SELECT 1
2608: FROM mtl_transactions_interface
2609: WHERE locator_id = l_inventory_location_id
2610: AND organization_id = l_organization_id);
2611:
2612: fnd_message.set_name('INV', 'INV_LOC_PENDTXN');