DBA Data[Home] [Help]

APPS.DPP_CUSTOMERCLAIMS_PVT dependencies on RA_CUSTOMER_TRX_ALL

Line 85: ra_customer_trx_all rct,

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

Line 104: ra_customer_trx_all rct1,

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