DBA Data[Home] [Help]

APPS.JMF_PROCESS_SHIKYU_RCV_TRX_PVT dependencies on RCV_SUPPLY

Line 1322: 'POSTIVE RCV SUPPLY'

1318: RT.TRANSACTION_TYPE IN ('RECEIVE', 'TRANSFER', 'ACCEPT' , 'REJECT', 'MATCH')
1319: AND EXISTS
1320: (
1321: SELECT
1322: 'POSTIVE RCV SUPPLY'
1323: FROM RCV_SUPPLY RS
1324: WHERE RS.RCV_TRANSACTION_ID = RT.TRANSACTION_ID
1325: AND RS.TO_ORG_PRIMARY_QUANTITY >
1326: (

Line 1323: FROM RCV_SUPPLY RS

1319: AND EXISTS
1320: (
1321: SELECT
1322: 'POSTIVE RCV SUPPLY'
1323: FROM RCV_SUPPLY RS
1324: WHERE RS.RCV_TRANSACTION_ID = RT.TRANSACTION_ID
1325: AND RS.TO_ORG_PRIMARY_QUANTITY >
1326: (
1327: SELECT