DBA Data[Home] [Help]

APPS.INV_RCV_INTEGRATION_PVT dependencies on RCV_TRANSACTIONS_INTERFACE_S

Line 2883: --UPDATE rcv_transactions_interface SET lpn_group_id = group_id

2879: END LOOP;
2880:
2881: -- Following will be removed after po gives us the patch for corrections/returns.
2882: /************************************************************************/
2883: --UPDATE rcv_transactions_interface SET lpn_group_id = group_id
2884: --WHERE lpn_group_id IS NULL
2885: --AND (lpn_id IS NOT NULL
2886: -- OR license_plate_number IS NOT NULL
2887: -- OR transfer_lpn_id IS NOT NULL

Line 10513: SELECT rcv_transactions_interface_s.NEXTVAL

10509: END IF;
10510:
10511: l_progress := 'WMSINB-15850';
10512:
10513: SELECT rcv_transactions_interface_s.NEXTVAL
10514: INTO l_interface_transaction_id
10515: FROM DUAL;
10516:
10517: l_progress := 'WMSINB-15856';