DBA Data[Home] [Help]

APPS.RCV_ROI_RETURN dependencies on RCV_SUPPLY

Line 54: SELECT 'POSTIVE RCV SUPPLY'

50: AND rti.transaction_type = 'MATCH')
51: )
52: )
53: AND EXISTS (
54: SELECT 'POSTIVE RCV SUPPLY'
55: FROM rcv_supply rs
56: WHERE rs.rcv_transaction_id = rt.transaction_id
57: AND rs.to_org_primary_quantity >
58: (SELECT NVL (SUM (rti.primary_quantity),

Line 55: FROM rcv_supply rs

51: )
52: )
53: AND EXISTS (
54: SELECT 'POSTIVE RCV SUPPLY'
55: FROM rcv_supply rs
56: WHERE rs.rcv_transaction_id = rt.transaction_id
57: AND rs.to_org_primary_quantity >
58: (SELECT NVL (SUM (rti.primary_quantity),
59: 0