DBA Data[Home] [Help]

APPS.DPP_CUSTOMERCLAIMS_PVT dependencies on RA_CUSTOMER_TRX_ALL

Line 84: ra_customer_trx_all rct,

80: unit_selling_price last_price,
81: rct.invoice_currency_code
82: FROM
83: ra_customer_trx_lines_all rctl,
84: ra_customer_trx_all rct,
85: ra_cust_trx_types_all rctt
86: WHERE
87: line_type = 'LINE' AND
88: inventory_item_id = p_inventory_item_id AND

Line 103: ra_customer_trx_all rct1,

99: SELECT
100: MAX(rctl1.customer_trx_line_id)
101: FROM
102: ra_customer_trx_lines_all rctl1,
103: ra_customer_trx_all rct1,
104: ra_cust_trx_types_all rctt1
105: WHERE
106: line_type = 'LINE' AND
107: inventory_item_id = p_inventory_item_id AND