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 1335: FROM RCV_TRANSACTIONS_INTERFACE RTI

1331: AND RS.TO_ORG_PRIMARY_QUANTITY >
1332: (
1333: SELECT
1334: NVL(SUM(RTI.PRIMARY_QUANTITY),0)
1335: FROM RCV_TRANSACTIONS_INTERFACE RTI
1336: WHERE RTI.PARENT_TRANSACTION_ID = RT.TRANSACTION_ID
1337: AND RTI.TRANSACTION_STATUS_CODE = 'PENDING'
1338: AND RTI.PROCESSING_STATUS_CODE = 'PENDING'
1339: )