DBA Data[Home] [Help]

APPS.CSD_MIGRATE_FROM_115X_PKG3 dependencies on RCV_SERIAL_TRANSACTIONS

Line 3604: -- to 11i, PO creates lines in rcv_Transactions and rcv_serial_transactions for those

3600: Begin
3601: -- To fix bug 3842957/4140451 saupadhy
3602: -- In pre 11i RMA returns were handled by inventory module not receiving module.
3603: -- In 11i this functionality is handled by PO module.During migration from pre 11i
3604: -- to 11i, PO creates lines in rcv_Transactions and rcv_serial_transactions for those
3605: -- records that exist in SO_RMA interface table. There is a possibility that customer
3606: -- might have deleted records from SO_RMA interface table after those records are
3607: -- successfully received in inventory. In such cases there will be no record created
3608: -- in rcv_transactions table.So Depot has changed the logic for finding

Line 3621: Rcv_Serial_Transactions rst

3617: Begin
3618: Select rcvt.quantity, rcvt.locator_id , rst.serial_num
3619: Into v_Quantity_Received(j), v_Locator_Id(j),v_Source_Serial_Number(j)
3620: From Rcv_Transactions Rcvt ,
3621: Rcv_Serial_Transactions rst
3622: Where rcvt.Transaction_Type = 'DELIVER'
3623: and rcvt.oe_order_header_id = v_order_header_id(j)
3624: and rcvt.oe_order_line_id = v_order_line_id(j)
3625: and rcvt.transaction_id = rst.transaction_id