DBA Data[Home] [Help]

APPS.INV_LOC_WMS_PUB dependencies on RCV_TRANSACTIONS_INTERFACE

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

2645: WHEN NO_DATA_FOUND THEN
2646: NULL;
2647: END;
2648:
2649: /* Check if the locator is existing in RCV_TRANSACTIONS_INTERFACE
2650: if the locator exists then error out*/
2651: BEGIN
2652: SELECT 1
2653: INTO l_chk_flag

Line 2656: FROM rcv_transactions_interface

2652: SELECT 1
2653: INTO l_chk_flag
2654: FROM DUAL
2655: WHERE EXISTS(SELECT 1
2656: FROM rcv_transactions_interface
2657: WHERE locator_id = l_inventory_location_id
2658: AND to_organization_id = l_organization_id);
2659:
2660: fnd_message.set_name('INV', 'INV_LOC_PENDTXN');