[Home] [Help]
296: IS
297:
298: CURSOR get_trx_gl_date_cur IS
299: SELECT rda.gl_date
300: FROM ra_cust_trx_line_gl_dist_all rda,
301: --ra_customer_trx_lines_all rla
302: jai_ar_trx_tax_lines rla--Modified by Xiao for bug#12631135.
303: WHERE rda.account_class = 'REV'
304: AND rda.customer_trx_line_id = rla.link_to_cust_trx_line_id
807: JAI_AR_TRX_LINES jtrxl ,
808: JAI_AR_TRX_TAX_LINES jtrxtl ,
809: ra_customer_trx_lines_all rctla , /*14121914*/
810: JAI_CMN_TAXES_ALL jtc ,
811: ra_cust_trx_line_gl_dist_all gd--Added by Qiong for bug13540741
812: WHERE
813: trx.org_id = nvl(p_org_id,trx.org_id) AND
814: trx.complete_flag ='Y' AND
815: trx.customer_trx_id = jtrx.customer_trx_id AND
3447: , ra_customer_trx_lines_all trxl
3448: , ra_customer_trx_all trx
3449: , ra_cust_trx_types_all trx_types
3450: , jai_ar_trxs jtrx
3451: , ra_cust_trx_line_gl_dist_all gd --Added by Qiong for bug13540741
3452: WHERE jattl.link_to_cust_trx_line_id = trxl.customer_trx_line_id
3453: AND trxl.customer_trx_id = trx.customer_trx_id
3454: /*14121914 - Start*/
3455: AND (
3588: AND jrtr.source_trx_type = 'CLAIM_ACCOUNTING'
3589: AND jrtr.source = 'AR_CLAIM'
3590: AND jrtr.source_document_id = araa.receivable_application_id)
3591: AND EXISTS (SELECT 1
3592: FROM ra_cust_trx_line_gl_dist_all rg
3593: WHERE rg.customer_trx_id = pn_invoice_id
3594: AND rg.customer_trx_line_id = pn_line_number
3595: AND rg.account_class = 'REV'
3596: AND jai_st_reversal_extract_pkg.is_paid_after_reversal(araa.apply_date,
4572: AND jrtr.source_trx_type = 'CLAIM_ACCOUNTING'
4573: AND jrtr.source = 'AR_CLAIM'
4574: AND jrtr.source_document_id = araa.receivable_application_id)
4575: AND EXISTS (SELECT 1
4576: FROM ra_cust_trx_line_gl_dist_all rg
4577: WHERE rg.customer_trx_id = pn_invoice_id
4578: AND rg.customer_trx_line_id = pn_line_number
4579: AND rg.account_class = 'REV'
4580: AND jai_st_reversal_extract_pkg.is_paid_after_reversal(araa.apply_date,