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.JA_CN_CFS_CLT_SLA_PKG dependencies on XLA_AE_LINES

Line 403: l_ae_header_id xla_ae_lines.ae_header_id%TYPE;

399: l_amb_context_code xla_ae_line_acs.amb_context_code%type;
400: l_ac_value xla_ae_line_acs.ac1%type;
401:
402: --sla lines variables
403: l_ae_header_id xla_ae_lines.ae_header_id%TYPE;
404: l_ae_line_num xla_ae_lines.ae_line_num%TYPE;
405: l_transaction_date xla_ae_lines.accounting_date%TYPE;
406: l_accounted_dr xla_ae_lines.accounted_dr%TYPE;
407: l_accounted_cr xla_ae_lines.accounted_cr%TYPE;

Line 404: l_ae_line_num xla_ae_lines.ae_line_num%TYPE;

400: l_ac_value xla_ae_line_acs.ac1%type;
401:
402: --sla lines variables
403: l_ae_header_id xla_ae_lines.ae_header_id%TYPE;
404: l_ae_line_num xla_ae_lines.ae_line_num%TYPE;
405: l_transaction_date xla_ae_lines.accounting_date%TYPE;
406: l_accounted_dr xla_ae_lines.accounted_dr%TYPE;
407: l_accounted_cr xla_ae_lines.accounted_cr%TYPE;
408: l_entered_dr xla_ae_lines.entered_dr%TYPE;

Line 405: l_transaction_date xla_ae_lines.accounting_date%TYPE;

401:
402: --sla lines variables
403: l_ae_header_id xla_ae_lines.ae_header_id%TYPE;
404: l_ae_line_num xla_ae_lines.ae_line_num%TYPE;
405: l_transaction_date xla_ae_lines.accounting_date%TYPE;
406: l_accounted_dr xla_ae_lines.accounted_dr%TYPE;
407: l_accounted_cr xla_ae_lines.accounted_cr%TYPE;
408: l_entered_dr xla_ae_lines.entered_dr%TYPE;
409: l_entered_cr xla_ae_lines.entered_cr%TYPE;

Line 406: l_accounted_dr xla_ae_lines.accounted_dr%TYPE;

402: --sla lines variables
403: l_ae_header_id xla_ae_lines.ae_header_id%TYPE;
404: l_ae_line_num xla_ae_lines.ae_line_num%TYPE;
405: l_transaction_date xla_ae_lines.accounting_date%TYPE;
406: l_accounted_dr xla_ae_lines.accounted_dr%TYPE;
407: l_accounted_cr xla_ae_lines.accounted_cr%TYPE;
408: l_entered_dr xla_ae_lines.entered_dr%TYPE;
409: l_entered_cr xla_ae_lines.entered_cr%TYPE;
410: l_currency_code xla_ae_lines.currency_code%TYPE;

Line 407: l_accounted_cr xla_ae_lines.accounted_cr%TYPE;

403: l_ae_header_id xla_ae_lines.ae_header_id%TYPE;
404: l_ae_line_num xla_ae_lines.ae_line_num%TYPE;
405: l_transaction_date xla_ae_lines.accounting_date%TYPE;
406: l_accounted_dr xla_ae_lines.accounted_dr%TYPE;
407: l_accounted_cr xla_ae_lines.accounted_cr%TYPE;
408: l_entered_dr xla_ae_lines.entered_dr%TYPE;
409: l_entered_cr xla_ae_lines.entered_cr%TYPE;
410: l_currency_code xla_ae_lines.currency_code%TYPE;
411: l_currency_conversion_rate xla_ae_lines.currency_conversion_rate%TYPE;

Line 408: l_entered_dr xla_ae_lines.entered_dr%TYPE;

404: l_ae_line_num xla_ae_lines.ae_line_num%TYPE;
405: l_transaction_date xla_ae_lines.accounting_date%TYPE;
406: l_accounted_dr xla_ae_lines.accounted_dr%TYPE;
407: l_accounted_cr xla_ae_lines.accounted_cr%TYPE;
408: l_entered_dr xla_ae_lines.entered_dr%TYPE;
409: l_entered_cr xla_ae_lines.entered_cr%TYPE;
410: l_currency_code xla_ae_lines.currency_code%TYPE;
411: l_currency_conversion_rate xla_ae_lines.currency_conversion_rate%TYPE;
412: l_currency_conversion_type xla_ae_lines.currency_conversion_type%TYPE;

Line 409: l_entered_cr xla_ae_lines.entered_cr%TYPE;

405: l_transaction_date xla_ae_lines.accounting_date%TYPE;
406: l_accounted_dr xla_ae_lines.accounted_dr%TYPE;
407: l_accounted_cr xla_ae_lines.accounted_cr%TYPE;
408: l_entered_dr xla_ae_lines.entered_dr%TYPE;
409: l_entered_cr xla_ae_lines.entered_cr%TYPE;
410: l_currency_code xla_ae_lines.currency_code%TYPE;
411: l_currency_conversion_rate xla_ae_lines.currency_conversion_rate%TYPE;
412: l_currency_conversion_type xla_ae_lines.currency_conversion_type%TYPE;
413: l_currency_conversion_date xla_ae_lines.currency_conversion_date%TYPE;

Line 410: l_currency_code xla_ae_lines.currency_code%TYPE;

406: l_accounted_dr xla_ae_lines.accounted_dr%TYPE;
407: l_accounted_cr xla_ae_lines.accounted_cr%TYPE;
408: l_entered_dr xla_ae_lines.entered_dr%TYPE;
409: l_entered_cr xla_ae_lines.entered_cr%TYPE;
410: l_currency_code xla_ae_lines.currency_code%TYPE;
411: l_currency_conversion_rate xla_ae_lines.currency_conversion_rate%TYPE;
412: l_currency_conversion_type xla_ae_lines.currency_conversion_type%TYPE;
413: l_currency_conversion_date xla_ae_lines.currency_conversion_date%TYPE;
414: l_transaction_num xla_ae_line_acs.ac1%TYPE;

Line 411: l_currency_conversion_rate xla_ae_lines.currency_conversion_rate%TYPE;

407: l_accounted_cr xla_ae_lines.accounted_cr%TYPE;
408: l_entered_dr xla_ae_lines.entered_dr%TYPE;
409: l_entered_cr xla_ae_lines.entered_cr%TYPE;
410: l_currency_code xla_ae_lines.currency_code%TYPE;
411: l_currency_conversion_rate xla_ae_lines.currency_conversion_rate%TYPE;
412: l_currency_conversion_type xla_ae_lines.currency_conversion_type%TYPE;
413: l_currency_conversion_date xla_ae_lines.currency_conversion_date%TYPE;
414: l_transaction_num xla_ae_line_acs.ac1%TYPE;
415: l_application_id xla_ae_lines.application_id%TYPE;

Line 412: l_currency_conversion_type xla_ae_lines.currency_conversion_type%TYPE;

408: l_entered_dr xla_ae_lines.entered_dr%TYPE;
409: l_entered_cr xla_ae_lines.entered_cr%TYPE;
410: l_currency_code xla_ae_lines.currency_code%TYPE;
411: l_currency_conversion_rate xla_ae_lines.currency_conversion_rate%TYPE;
412: l_currency_conversion_type xla_ae_lines.currency_conversion_type%TYPE;
413: l_currency_conversion_date xla_ae_lines.currency_conversion_date%TYPE;
414: l_transaction_num xla_ae_line_acs.ac1%TYPE;
415: l_application_id xla_ae_lines.application_id%TYPE;
416: l_ccid xla_ae_lines.code_combination_id%TYPE;--Fix bug#7334017 add

Line 413: l_currency_conversion_date xla_ae_lines.currency_conversion_date%TYPE;

409: l_entered_cr xla_ae_lines.entered_cr%TYPE;
410: l_currency_code xla_ae_lines.currency_code%TYPE;
411: l_currency_conversion_rate xla_ae_lines.currency_conversion_rate%TYPE;
412: l_currency_conversion_type xla_ae_lines.currency_conversion_type%TYPE;
413: l_currency_conversion_date xla_ae_lines.currency_conversion_date%TYPE;
414: l_transaction_num xla_ae_line_acs.ac1%TYPE;
415: l_application_id xla_ae_lines.application_id%TYPE;
416: l_ccid xla_ae_lines.code_combination_id%TYPE;--Fix bug#7334017 add
417:

Line 415: l_application_id xla_ae_lines.application_id%TYPE;

411: l_currency_conversion_rate xla_ae_lines.currency_conversion_rate%TYPE;
412: l_currency_conversion_type xla_ae_lines.currency_conversion_type%TYPE;
413: l_currency_conversion_date xla_ae_lines.currency_conversion_date%TYPE;
414: l_transaction_num xla_ae_line_acs.ac1%TYPE;
415: l_application_id xla_ae_lines.application_id%TYPE;
416: l_ccid xla_ae_lines.code_combination_id%TYPE;--Fix bug#7334017 add
417:
418: -- Cash lines variables
419: l_cash_date xla_ae_lines.accounting_date%TYPE;

Line 416: l_ccid xla_ae_lines.code_combination_id%TYPE;--Fix bug#7334017 add

412: l_currency_conversion_type xla_ae_lines.currency_conversion_type%TYPE;
413: l_currency_conversion_date xla_ae_lines.currency_conversion_date%TYPE;
414: l_transaction_num xla_ae_line_acs.ac1%TYPE;
415: l_application_id xla_ae_lines.application_id%TYPE;
416: l_ccid xla_ae_lines.code_combination_id%TYPE;--Fix bug#7334017 add
417:
418: -- Cash lines variables
419: l_cash_date xla_ae_lines.accounting_date%TYPE;
420: l_accounting_class xla_ae_lines.accounting_class_code%TYPE;

Line 419: l_cash_date xla_ae_lines.accounting_date%TYPE;

415: l_application_id xla_ae_lines.application_id%TYPE;
416: l_ccid xla_ae_lines.code_combination_id%TYPE;--Fix bug#7334017 add
417:
418: -- Cash lines variables
419: l_cash_date xla_ae_lines.accounting_date%TYPE;
420: l_accounting_class xla_ae_lines.accounting_class_code%TYPE;
421: l_cash_amount_cr xla_ae_lines.accounted_cr%TYPE;
422: l_cash_amount_dr xla_ae_lines.accounted_dr%TYPE;
423:

Line 420: l_accounting_class xla_ae_lines.accounting_class_code%TYPE;

416: l_ccid xla_ae_lines.code_combination_id%TYPE;--Fix bug#7334017 add
417:
418: -- Cash lines variables
419: l_cash_date xla_ae_lines.accounting_date%TYPE;
420: l_accounting_class xla_ae_lines.accounting_class_code%TYPE;
421: l_cash_amount_cr xla_ae_lines.accounted_cr%TYPE;
422: l_cash_amount_dr xla_ae_lines.accounted_dr%TYPE;
423:
424: -- dynatical cursor

Line 421: l_cash_amount_cr xla_ae_lines.accounted_cr%TYPE;

417:
418: -- Cash lines variables
419: l_cash_date xla_ae_lines.accounting_date%TYPE;
420: l_accounting_class xla_ae_lines.accounting_class_code%TYPE;
421: l_cash_amount_cr xla_ae_lines.accounted_cr%TYPE;
422: l_cash_amount_dr xla_ae_lines.accounted_dr%TYPE;
423:
424: -- dynatical cursor
425: TYPE SLACurTyp IS REF CURSOR;

Line 422: l_cash_amount_dr xla_ae_lines.accounted_dr%TYPE;

418: -- Cash lines variables
419: l_cash_date xla_ae_lines.accounting_date%TYPE;
420: l_accounting_class xla_ae_lines.accounting_class_code%TYPE;
421: l_cash_amount_cr xla_ae_lines.accounted_cr%TYPE;
422: l_cash_amount_dr xla_ae_lines.accounted_dr%TYPE;
423:
424: -- dynatical cursor
425: TYPE SLACurTyp IS REF CURSOR;
426: c_sla_lines SLACurTyp;

Line 453: FROM xla_ae_lines al

449: ala.analytical_criterion_type_code,
450: ala.amb_context_code,
451: ala.ac1,
452: al.code_combination_id
453: FROM xla_ae_lines al
454: ,xla_ae_headers ah
455: ,xla_ae_line_acs ala
456: ,fnd_segment_attribute_values fsav
457: ,gl_code_combinations gcc

Line 501: FROM xla_ae_lines al

497: ,al.accounting_class_code
498: ,al.accounted_cr
499: ,al.accounted_dr
500: ,ala.ac1
501: FROM xla_ae_lines al
502: ,xla_ae_headers ah
503: ,xla_ae_line_acs ala
504: ,fnd_segment_attribute_values fsav
505: ,fnd_segment_attribute_values fsav1