APPS.INV_LOC_WMS_PUB dependencies on RCV_TRANSACTIONS_INTERFACE

Line 2553: /* Check if the locator is existing in RCV_TRANSACTIONS_INTERFACE

2549: WHEN NO_DATA_FOUND THEN
2550: NULL;
2551: END;
2552:
2553: /* Check if the locator is existing in RCV_TRANSACTIONS_INTERFACE
2554: if the locator exists then error out*/
2555: BEGIN
2556: SELECT 1
2557: INTO l_chk_flag

Line 2560: FROM rcv_transactions_interface

2556: SELECT 1
2557: INTO l_chk_flag
2558: FROM DUAL
2559: WHERE EXISTS(SELECT 1
2560: FROM rcv_transactions_interface
2561: WHERE locator_id = l_inventory_location_id
2562: AND to_organization_id = l_organization_id);
2563:
2564: fnd_message.set_name('INV', 'INV_LOC_PENDTXN');