DBA Data[Home] [Help]

APPS.JE_REVERSE_SALES_LIST_PKG dependencies on RA_CUSTOMER_TRX_LINES_ALL

Line 117: ra_customer_trx_lines_all trx_lines,

113: BEGIN
114: SELECT ROUND(NVL(SUM(trx_lines.extended_amount),0))
115: INTO ln_sales_amount
116: FROM ra_customer_trx_all trx,
117: ra_customer_trx_lines_all trx_lines,
118: zx_lines lines,
119: ra_customer_trx_lines_all trx_tax_lines,
120: zx_report_codes_assoc zrc,
121: zx_reporting_types_vl zrt

Line 119: ra_customer_trx_lines_all trx_tax_lines,

115: INTO ln_sales_amount
116: FROM ra_customer_trx_all trx,
117: ra_customer_trx_lines_all trx_lines,
118: zx_lines lines,
119: ra_customer_trx_lines_all trx_tax_lines,
120: zx_report_codes_assoc zrc,
121: zx_reporting_types_vl zrt
122: WHERE trx_lines.line_type ='LINE'
123: AND trx_lines.customer_trx_id = trx.customer_trx_id