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 377: xla_ae_lines xl,

373: Begin
374: SELECT gl.je_header_id, gl.je_line_num
375: INTO l_je_header_id,l_je_line_num
376: FROM gl_import_references gl,
377: xla_ae_lines xl,
378: gl_je_headers jeh
379: WHERE xl.ae_header_id = p_ae_header_id
380: AND xl.ae_line_num = p_ae_line_num
381: AND xl.gl_sl_link_id = gl.gl_sl_link_id

Line 534: l_ae_header_id xla_ae_lines.ae_header_id%TYPE;

530: l_amb_context_code xla_ae_line_acs.amb_context_code%type;
531: l_ac_value xla_ae_line_acs.ac1%type;
532:
533: --sla lines variables
534: l_ae_header_id xla_ae_lines.ae_header_id%TYPE;
535: l_ae_line_num xla_ae_lines.ae_line_num%TYPE;
536: l_transaction_date xla_ae_lines.accounting_date%TYPE;
537: l_accounted_dr xla_ae_lines.accounted_dr%TYPE;
538: l_accounted_cr xla_ae_lines.accounted_cr%TYPE;

Line 535: l_ae_line_num xla_ae_lines.ae_line_num%TYPE;

531: l_ac_value xla_ae_line_acs.ac1%type;
532:
533: --sla lines variables
534: l_ae_header_id xla_ae_lines.ae_header_id%TYPE;
535: l_ae_line_num xla_ae_lines.ae_line_num%TYPE;
536: l_transaction_date xla_ae_lines.accounting_date%TYPE;
537: l_accounted_dr xla_ae_lines.accounted_dr%TYPE;
538: l_accounted_cr xla_ae_lines.accounted_cr%TYPE;
539: l_entered_dr xla_ae_lines.entered_dr%TYPE;

Line 536: l_transaction_date xla_ae_lines.accounting_date%TYPE;

532:
533: --sla lines variables
534: l_ae_header_id xla_ae_lines.ae_header_id%TYPE;
535: l_ae_line_num xla_ae_lines.ae_line_num%TYPE;
536: l_transaction_date xla_ae_lines.accounting_date%TYPE;
537: l_accounted_dr xla_ae_lines.accounted_dr%TYPE;
538: l_accounted_cr xla_ae_lines.accounted_cr%TYPE;
539: l_entered_dr xla_ae_lines.entered_dr%TYPE;
540: l_entered_cr xla_ae_lines.entered_cr%TYPE;

Line 537: l_accounted_dr xla_ae_lines.accounted_dr%TYPE;

533: --sla lines variables
534: l_ae_header_id xla_ae_lines.ae_header_id%TYPE;
535: l_ae_line_num xla_ae_lines.ae_line_num%TYPE;
536: l_transaction_date xla_ae_lines.accounting_date%TYPE;
537: l_accounted_dr xla_ae_lines.accounted_dr%TYPE;
538: l_accounted_cr xla_ae_lines.accounted_cr%TYPE;
539: l_entered_dr xla_ae_lines.entered_dr%TYPE;
540: l_entered_cr xla_ae_lines.entered_cr%TYPE;
541: l_currency_code xla_ae_lines.currency_code%TYPE;

Line 538: l_accounted_cr xla_ae_lines.accounted_cr%TYPE;

534: l_ae_header_id xla_ae_lines.ae_header_id%TYPE;
535: l_ae_line_num xla_ae_lines.ae_line_num%TYPE;
536: l_transaction_date xla_ae_lines.accounting_date%TYPE;
537: l_accounted_dr xla_ae_lines.accounted_dr%TYPE;
538: l_accounted_cr xla_ae_lines.accounted_cr%TYPE;
539: l_entered_dr xla_ae_lines.entered_dr%TYPE;
540: l_entered_cr xla_ae_lines.entered_cr%TYPE;
541: l_currency_code xla_ae_lines.currency_code%TYPE;
542: l_currency_conversion_rate xla_ae_lines.currency_conversion_rate%TYPE;

Line 539: l_entered_dr xla_ae_lines.entered_dr%TYPE;

535: l_ae_line_num xla_ae_lines.ae_line_num%TYPE;
536: l_transaction_date xla_ae_lines.accounting_date%TYPE;
537: l_accounted_dr xla_ae_lines.accounted_dr%TYPE;
538: l_accounted_cr xla_ae_lines.accounted_cr%TYPE;
539: l_entered_dr xla_ae_lines.entered_dr%TYPE;
540: l_entered_cr xla_ae_lines.entered_cr%TYPE;
541: l_currency_code xla_ae_lines.currency_code%TYPE;
542: l_currency_conversion_rate xla_ae_lines.currency_conversion_rate%TYPE;
543: l_currency_conversion_type xla_ae_lines.currency_conversion_type%TYPE;

Line 540: l_entered_cr xla_ae_lines.entered_cr%TYPE;

536: l_transaction_date xla_ae_lines.accounting_date%TYPE;
537: l_accounted_dr xla_ae_lines.accounted_dr%TYPE;
538: l_accounted_cr xla_ae_lines.accounted_cr%TYPE;
539: l_entered_dr xla_ae_lines.entered_dr%TYPE;
540: l_entered_cr xla_ae_lines.entered_cr%TYPE;
541: l_currency_code xla_ae_lines.currency_code%TYPE;
542: l_currency_conversion_rate xla_ae_lines.currency_conversion_rate%TYPE;
543: l_currency_conversion_type xla_ae_lines.currency_conversion_type%TYPE;
544: l_currency_conversion_date xla_ae_lines.currency_conversion_date%TYPE;

Line 541: l_currency_code xla_ae_lines.currency_code%TYPE;

537: l_accounted_dr xla_ae_lines.accounted_dr%TYPE;
538: l_accounted_cr xla_ae_lines.accounted_cr%TYPE;
539: l_entered_dr xla_ae_lines.entered_dr%TYPE;
540: l_entered_cr xla_ae_lines.entered_cr%TYPE;
541: l_currency_code xla_ae_lines.currency_code%TYPE;
542: l_currency_conversion_rate xla_ae_lines.currency_conversion_rate%TYPE;
543: l_currency_conversion_type xla_ae_lines.currency_conversion_type%TYPE;
544: l_currency_conversion_date xla_ae_lines.currency_conversion_date%TYPE;
545:

Line 542: l_currency_conversion_rate xla_ae_lines.currency_conversion_rate%TYPE;

538: l_accounted_cr xla_ae_lines.accounted_cr%TYPE;
539: l_entered_dr xla_ae_lines.entered_dr%TYPE;
540: l_entered_cr xla_ae_lines.entered_cr%TYPE;
541: l_currency_code xla_ae_lines.currency_code%TYPE;
542: l_currency_conversion_rate xla_ae_lines.currency_conversion_rate%TYPE;
543: l_currency_conversion_type xla_ae_lines.currency_conversion_type%TYPE;
544: l_currency_conversion_date xla_ae_lines.currency_conversion_date%TYPE;
545:
546: l_transaction_num xla_ae_line_acs.ac1%TYPE;

Line 543: l_currency_conversion_type xla_ae_lines.currency_conversion_type%TYPE;

539: l_entered_dr xla_ae_lines.entered_dr%TYPE;
540: l_entered_cr xla_ae_lines.entered_cr%TYPE;
541: l_currency_code xla_ae_lines.currency_code%TYPE;
542: l_currency_conversion_rate xla_ae_lines.currency_conversion_rate%TYPE;
543: l_currency_conversion_type xla_ae_lines.currency_conversion_type%TYPE;
544: l_currency_conversion_date xla_ae_lines.currency_conversion_date%TYPE;
545:
546: l_transaction_num xla_ae_line_acs.ac1%TYPE;
547: l_application_id xla_ae_lines.application_id%TYPE;

Line 544: l_currency_conversion_date xla_ae_lines.currency_conversion_date%TYPE;

540: l_entered_cr xla_ae_lines.entered_cr%TYPE;
541: l_currency_code xla_ae_lines.currency_code%TYPE;
542: l_currency_conversion_rate xla_ae_lines.currency_conversion_rate%TYPE;
543: l_currency_conversion_type xla_ae_lines.currency_conversion_type%TYPE;
544: l_currency_conversion_date xla_ae_lines.currency_conversion_date%TYPE;
545:
546: l_transaction_num xla_ae_line_acs.ac1%TYPE;
547: l_application_id xla_ae_lines.application_id%TYPE;
548: l_ccid xla_ae_lines.code_combination_id%TYPE;--Fix bug#7334017 add

Line 547: l_application_id xla_ae_lines.application_id%TYPE;

543: l_currency_conversion_type xla_ae_lines.currency_conversion_type%TYPE;
544: l_currency_conversion_date xla_ae_lines.currency_conversion_date%TYPE;
545:
546: l_transaction_num xla_ae_line_acs.ac1%TYPE;
547: l_application_id xla_ae_lines.application_id%TYPE;
548: l_ccid xla_ae_lines.code_combination_id%TYPE;--Fix bug#7334017 add
549:
550: -- Cash lines variables
551: l_cash_date xla_ae_lines.accounting_date%TYPE;

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

544: l_currency_conversion_date xla_ae_lines.currency_conversion_date%TYPE;
545:
546: l_transaction_num xla_ae_line_acs.ac1%TYPE;
547: l_application_id xla_ae_lines.application_id%TYPE;
548: l_ccid xla_ae_lines.code_combination_id%TYPE;--Fix bug#7334017 add
549:
550: -- Cash lines variables
551: l_cash_date xla_ae_lines.accounting_date%TYPE;
552: l_accounting_class xla_ae_lines.accounting_class_code%TYPE;

Line 551: l_cash_date xla_ae_lines.accounting_date%TYPE;

547: l_application_id xla_ae_lines.application_id%TYPE;
548: l_ccid xla_ae_lines.code_combination_id%TYPE;--Fix bug#7334017 add
549:
550: -- Cash lines variables
551: l_cash_date xla_ae_lines.accounting_date%TYPE;
552: l_accounting_class xla_ae_lines.accounting_class_code%TYPE;
553: l_cash_amount_cr xla_ae_lines.accounted_cr%TYPE;
554: l_cash_amount_dr xla_ae_lines.accounted_dr%TYPE;
555: l_cash_app_id xla_ae_lines.application_id%TYPE; -- Fix bug 12542469 Added by shujuan

Line 552: l_accounting_class xla_ae_lines.accounting_class_code%TYPE;

548: l_ccid xla_ae_lines.code_combination_id%TYPE;--Fix bug#7334017 add
549:
550: -- Cash lines variables
551: l_cash_date xla_ae_lines.accounting_date%TYPE;
552: l_accounting_class xla_ae_lines.accounting_class_code%TYPE;
553: l_cash_amount_cr xla_ae_lines.accounted_cr%TYPE;
554: l_cash_amount_dr xla_ae_lines.accounted_dr%TYPE;
555: l_cash_app_id xla_ae_lines.application_id%TYPE; -- Fix bug 12542469 Added by shujuan
556:

Line 553: l_cash_amount_cr xla_ae_lines.accounted_cr%TYPE;

549:
550: -- Cash lines variables
551: l_cash_date xla_ae_lines.accounting_date%TYPE;
552: l_accounting_class xla_ae_lines.accounting_class_code%TYPE;
553: l_cash_amount_cr xla_ae_lines.accounted_cr%TYPE;
554: l_cash_amount_dr xla_ae_lines.accounted_dr%TYPE;
555: l_cash_app_id xla_ae_lines.application_id%TYPE; -- Fix bug 12542469 Added by shujuan
556:
557: l_event_type_code xla_ae_headers.event_type_code%TYPE; -- Bug fixing Added by Shujan

Line 554: l_cash_amount_dr xla_ae_lines.accounted_dr%TYPE;

550: -- Cash lines variables
551: l_cash_date xla_ae_lines.accounting_date%TYPE;
552: l_accounting_class xla_ae_lines.accounting_class_code%TYPE;
553: l_cash_amount_cr xla_ae_lines.accounted_cr%TYPE;
554: l_cash_amount_dr xla_ae_lines.accounted_dr%TYPE;
555: l_cash_app_id xla_ae_lines.application_id%TYPE; -- Fix bug 12542469 Added by shujuan
556:
557: l_event_type_code xla_ae_headers.event_type_code%TYPE; -- Bug fixing Added by Shujan
558: l_cash_ae_header_id xla_ae_lines.ae_header_id%TYPE;

Line 555: l_cash_app_id xla_ae_lines.application_id%TYPE; -- Fix bug 12542469 Added by shujuan

551: l_cash_date xla_ae_lines.accounting_date%TYPE;
552: l_accounting_class xla_ae_lines.accounting_class_code%TYPE;
553: l_cash_amount_cr xla_ae_lines.accounted_cr%TYPE;
554: l_cash_amount_dr xla_ae_lines.accounted_dr%TYPE;
555: l_cash_app_id xla_ae_lines.application_id%TYPE; -- Fix bug 12542469 Added by shujuan
556:
557: l_event_type_code xla_ae_headers.event_type_code%TYPE; -- Bug fixing Added by Shujan
558: l_cash_ae_header_id xla_ae_lines.ae_header_id%TYPE;
559: l_cash_ae_line_num xla_ae_lines.ae_line_num%TYPE;

Line 558: l_cash_ae_header_id xla_ae_lines.ae_header_id%TYPE;

554: l_cash_amount_dr xla_ae_lines.accounted_dr%TYPE;
555: l_cash_app_id xla_ae_lines.application_id%TYPE; -- Fix bug 12542469 Added by shujuan
556:
557: l_event_type_code xla_ae_headers.event_type_code%TYPE; -- Bug fixing Added by Shujan
558: l_cash_ae_header_id xla_ae_lines.ae_header_id%TYPE;
559: l_cash_ae_line_num xla_ae_lines.ae_line_num%TYPE;
560: l_header_description xla_ae_headers.description%TYPE; --Added by Jar.Wang for Fixing bug 14664279
561: -- dynatical cursor
562: TYPE SLACurTyp IS REF CURSOR;

Line 559: l_cash_ae_line_num xla_ae_lines.ae_line_num%TYPE;

555: l_cash_app_id xla_ae_lines.application_id%TYPE; -- Fix bug 12542469 Added by shujuan
556:
557: l_event_type_code xla_ae_headers.event_type_code%TYPE; -- Bug fixing Added by Shujan
558: l_cash_ae_header_id xla_ae_lines.ae_header_id%TYPE;
559: l_cash_ae_line_num xla_ae_lines.ae_line_num%TYPE;
560: l_header_description xla_ae_headers.description%TYPE; --Added by Jar.Wang for Fixing bug 14664279
561: -- dynatical cursor
562: TYPE SLACurTyp IS REF CURSOR;
563: c_sla_lines SLACurTyp;

Line 592: FROM xla_ae_lines al

588: ala.analytical_criterion_type_code,
589: ala.amb_context_code,
590: ala.ac1,
591: al.code_combination_id
592: FROM xla_ae_lines al
593: ,xla_ae_headers ah
594: ,xla_ae_line_acs ala
595: ,fnd_segment_attribute_values fsav
596: ,gl_code_combinations gcc

Line 644: FROM xla_ae_lines al

640: ,ah.event_type_code
641: ,ah.ae_header_id
642: ,al.ae_line_num
643: ,al.application_id
644: FROM xla_ae_lines al
645: ,xla_ae_headers ah
646: ,xla_ae_line_acs ala
647: ,fnd_segment_attribute_values fsav
648: ,fnd_segment_attribute_values fsav1