eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AR_UPGRADE_CASH_ACCRUAL dependencies on RA_CUSTOMER_TRX_LINES

Line 457: ra_customer_trx_lines ctl,

453: --}
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

Line 460: from ra_customer_trx_lines ctl_tax

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
463: and line_type = 'TAX'
464: ) taxx

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 669: from ra_customer_trx_lines ctl_tax

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'
672: ) taxx
673: WHERE evt.event_type_code IN ('RECP_CREATE' ,'RECP_UPDATE' ,

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 1337: from ra_customer_trx_lines

1333: , decode(adj.type, 'TAX', nvl(ard.location_segment_id, taxx.location_segment_id), taxx.location_segment_id)
1334: FROM ar_adjustments adj,
1335: ar_distributions ard,
1336: ( select customer_trx_id, vat_tax_id, location_segment_id
1337: from ra_customer_trx_lines
1338: where customer_trx_id = p_trx_id
1339: and line_type = 'LINE'
1340: and rownum = 1
1341: ) taxx,

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'