[Home] [Help]
444: , NULL -- tax_link_id
445: , NULL -- tax_inc_flag
446: --}
447: FROM ra_customer_trx trx,
448: ra_customer_trx_lines ctl,
449: ra_cust_trx_line_gl_dist ctlgd
450: WHERE trx.customer_trx_id = p_trx_id
451: AND ctl.customer_trx_id = trx.customer_trx_id
452: AND ctl.customer_trx_line_id = ctlgd.customer_trx_line_id
642: FROM xla_events_gt evt,
643: ar_receivable_applications_all app,
644: ar_system_parameters_all ars,
645: ra_customer_trx_all trx,
646: ra_customer_trx_lines_all ctl,
647: ra_cust_trx_line_gl_dist_all ctlgd
648: WHERE evt.event_type_code IN ('RECP_CREATE' ,'RECP_UPDATE' ,
649: 'RECP_RATE_ADJUST' ,'RECP_REVERSE' ,
650: 'CM_CREATE' ,'CM_UPDATE' )
705: AND ars.accounting_method = 'CASH'
706: AND NOT EXISTS ( SELECT '1'
707: FROM psa_trx_types_all psa
708: WHERE inv.cust_trx_type_id = psa.psa_trx_type_id)) trx,
709: ra_customer_trx_lines_all ctl,
710: ra_cust_trx_line_gl_dist_all ctlgd
711: WHERE trx.customer_trx_id = ctl.customer_trx_id
712: AND ctl.customer_trx_line_id = ctlgd.customer_trx_line_id
713: AND ctl.line_type IN ('LINE','TAX','FREIGHT','CHARGES','CB')
941: AND evt.event_id = app.event_id
942: AND app.customer_trx_id = inv.customer_trx_id
943: AND inv.cust_trx_type_id = psa.psa_trx_type_id
944: AND app.upgrade_method IS NULL) trx,
945: ra_customer_trx_lines_all ctl,
946: ra_cust_trx_line_gl_dist_all ctlgd
947: WHERE trx.customer_trx_id = ctl.customer_trx_id
948: AND ctl.customer_trx_line_id = ctlgd.customer_trx_line_id
949: AND ctl.line_type IN ('LINE','TAX','FREIGHT','CHARGES','CB')
1744: (SELECT MAX(ref_customer_trx_id) ref_customer_trx_id,
1745: MAX(to_currency) invoice_currency_code
1746: FROM ra_ar_gt
1747: GROUP BY ref_customer_trx_id, to_currency) trx,
1748: ra_customer_trx_lines_all ctl,
1749: ra_cust_trx_line_gl_dist_all ctlgd
1750: WHERE adj.customer_trx_id = trx.ref_customer_trx_id
1751: AND adj.status = 'A'
1752: AND adj.postable = 'Y'