[Home] [Help]
454: , DECODE(ctl.line_type,'LINE',taxx.vat_tax_id,ctl.vat_tax_id) vat_tax_id
455: , DECODE(ctl.line_type,'LINE',taxx.location_segment_id,ctl.location_segment_id)
456: FROM ra_customer_trx trx,
457: ra_customer_trx_lines ctl,
458: ra_cust_trx_line_gl_dist ctlgd,
459: ( select ctl_tax.*
460: from ra_customer_trx_lines ctl_tax
461: where customer_trx_id = p_trx_id
462: and nvl(ctl_tax.line_number,1) = 1
663: ar_receivable_applications_all app,
664: ar_system_parameters_all ars,
665: ra_customer_trx_all trx,
666: ra_customer_trx_lines_all ctl,
667: ra_cust_trx_line_gl_dist_all ctlgd,
668: ( select ctl_tax.*
669: from ra_customer_trx_lines ctl_tax
670: where nvl(ctl_tax.line_number,1) = 1
671: and line_type = 'TAX'
732: AND NOT EXISTS ( SELECT '1'
733: FROM psa_trx_types_all psa
734: WHERE inv.cust_trx_type_id = psa.psa_trx_type_id)) trx,
735: ra_customer_trx_lines_all ctl,
736: ra_cust_trx_line_gl_dist_all ctlgd
737: WHERE trx.customer_trx_id = ctl.customer_trx_id
738: AND ctl.customer_trx_line_id = ctlgd.customer_trx_line_id
739: AND ctl.line_type IN ('LINE','TAX','FREIGHT','CHARGES','CB')
740: AND ctlgd.account_class IN ('REV','SUSPENSE','UNBILL','UNEARN','FREIGHT','TAX')
968: AND app.customer_trx_id = inv.customer_trx_id
969: AND inv.cust_trx_type_id = psa.psa_trx_type_id
970: AND app.upgrade_method IS NULL) trx,
971: ra_customer_trx_lines_all ctl,
972: ra_cust_trx_line_gl_dist_all ctlgd
973: WHERE trx.customer_trx_id = ctl.customer_trx_id
974: AND ctl.customer_trx_line_id = ctlgd.customer_trx_line_id
975: AND ctl.line_type IN ('LINE','TAX','FREIGHT','CHARGES','CB')
976: AND ctlgd.account_class IN ('REV','SUSPENSE','UNBILL','UNEARN','FREIGHT','TAX')
1943: MAX(to_currency) invoice_currency_code
1944: FROM ra_ar_gt
1945: GROUP BY ref_customer_trx_id, to_currency) trx,
1946: ra_customer_trx_lines_all ctl,
1947: ra_cust_trx_line_gl_dist_all ctlgd
1948: WHERE adj.customer_trx_id = trx.ref_customer_trx_id
1949: AND adj.status = 'A'
1950: AND adj.postable = 'Y'
1951: AND adj.upgrade_method = '11IMFAR'