DBA Data[Home] [Help]

APPS.AR_UPGRADE_CASH_ACCRUAL dependencies on RA_CUSTOMER_TRX_LINES_ALL

Line 666: ra_customer_trx_lines_all ctl,

662: FROM xla_events_gt evt,
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

Line 735: ra_customer_trx_lines_all ctl,

731: AND ars.accounting_method = 'CASH'
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')

Line 971: ra_customer_trx_lines_all ctl,

967: AND evt.event_id = app.event_id
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')

Line 1946: ra_customer_trx_lines_all ctl,

1942: (SELECT MAX(ref_customer_trx_id) ref_customer_trx_id,
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'