DBA Data[Home] [Help]

APPS.JMF_PROCESS_SHIKYU_RCV_TRX_PVT dependencies on RCV_SUPPLY

Line 1328: 'POSTIVE RCV SUPPLY'

1324: RT.TRANSACTION_TYPE IN ('RECEIVE', 'TRANSFER', 'ACCEPT' , 'REJECT', 'MATCH')
1325: AND EXISTS
1326: (
1327: SELECT
1328: 'POSTIVE RCV SUPPLY'
1329: FROM RCV_SUPPLY RS
1330: WHERE RS.RCV_TRANSACTION_ID = RT.TRANSACTION_ID
1331: AND RS.TO_ORG_PRIMARY_QUANTITY >
1332: (

Line 1329: FROM RCV_SUPPLY RS

1325: AND EXISTS
1326: (
1327: SELECT
1328: 'POSTIVE RCV SUPPLY'
1329: FROM RCV_SUPPLY RS
1330: WHERE RS.RCV_TRANSACTION_ID = RT.TRANSACTION_ID
1331: AND RS.TO_ORG_PRIMARY_QUANTITY >
1332: (
1333: SELECT