DBA Data[Home] [Help]

APPS.DPP_CUSTOMERCLAIMS_PVT dependencies on RA_CUSTOMER_TRX_LINES_ALL

Line 84: ra_customer_trx_lines_all rctl,

80: rct.sold_to_customer_id cust_account_id,
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

Line 103: ra_customer_trx_lines_all rctl1,

99: rctl.customer_trx_line_id = (
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