DBA Data[Home] [Help]

APPS.INV_RCV_INTEGRATION_PVT dependencies on RCV_TRANSACTIONS_INTERFACE_S

Line 2914: --UPDATE rcv_transactions_interface SET lpn_group_id = group_id

2910: END LOOP;
2911:
2912: -- Following will be removed after po gives us the patch for corrections/returns.
2913: /************************************************************************/
2914: --UPDATE rcv_transactions_interface SET lpn_group_id = group_id
2915: --WHERE lpn_group_id IS NULL
2916: --AND (lpn_id IS NOT NULL
2917: -- OR license_plate_number IS NOT NULL
2918: -- OR transfer_lpn_id IS NOT NULL

Line 10990: SELECT rcv_transactions_interface_s.NEXTVAL

10986: END IF;
10987:
10988: l_progress := 'WMSINB-15850';
10989:
10990: SELECT rcv_transactions_interface_s.NEXTVAL
10991: INTO l_interface_transaction_id
10992: FROM DUAL;
10993:
10994: l_progress := 'WMSINB-15856';