DBA Data[Home] [Help]

APPS.JMF_PROCESS_SHIKYU_RCV_TRX_PVT dependencies on RCV_TRANSACTIONS_INTERFACE

Line 1160: -- B. Enter records into rcv_transactions_interface

1156: --Follwing is logic:
1157: --1. Find all records eligible for SHIKYU RTV at MP site
1158: ---2. Perform SHIKYU RTV at MP site
1159: -- A. Enter records into rcv_headers_interface
1160: -- B. Enter records into rcv_transactions_interface
1161: -- C. Submit RVCTP ( Receiving Transaction Processor)
1162: -- D. Wait till concurrent request completes
1163: -- E. Confirm that RTV happened succefully. Received quantity against
1164: -- replenishment PO should be reduced by RTV quantity.

Line 1329: FROM RCV_TRANSACTIONS_INTERFACE RTI

1325: AND RS.TO_ORG_PRIMARY_QUANTITY >
1326: (
1327: SELECT
1328: NVL(SUM(RTI.PRIMARY_QUANTITY),0)
1329: FROM RCV_TRANSACTIONS_INTERFACE RTI
1330: WHERE RTI.PARENT_TRANSACTION_ID = RT.TRANSACTION_ID
1331: AND RTI.TRANSACTION_STATUS_CODE = 'PENDING'
1332: AND RTI.PROCESSING_STATUS_CODE = 'PENDING'
1333: )