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_LINE_ACS

Line 528: l_analytical_criterion_code xla_ae_line_acs.analytical_criterion_code%type;

524: l_detailed_cfs_item ja_cn_cfs_activities_all.detailed_cfs_item%type;
525: l_event_class_code ja_cn_cfs_item_mapping_hdrs.event_class_code%TYPE;
526:
527: --the analytical criterion variables
528: l_analytical_criterion_code xla_ae_line_acs.analytical_criterion_code%type;
529: l_ac_type_code xla_ae_line_acs.analytical_criterion_type_code%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:

Line 529: l_ac_type_code xla_ae_line_acs.analytical_criterion_type_code%type;

525: l_event_class_code ja_cn_cfs_item_mapping_hdrs.event_class_code%TYPE;
526:
527: --the analytical criterion variables
528: l_analytical_criterion_code xla_ae_line_acs.analytical_criterion_code%type;
529: l_ac_type_code xla_ae_line_acs.analytical_criterion_type_code%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

Line 530: l_amb_context_code xla_ae_line_acs.amb_context_code%type;

526:
527: --the analytical criterion variables
528: l_analytical_criterion_code xla_ae_line_acs.analytical_criterion_code%type;
529: l_ac_type_code xla_ae_line_acs.analytical_criterion_type_code%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;

Line 531: l_ac_value xla_ae_line_acs.ac1%type;

527: --the analytical criterion variables
528: l_analytical_criterion_code xla_ae_line_acs.analytical_criterion_code%type;
529: l_ac_type_code xla_ae_line_acs.analytical_criterion_type_code%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;

Line 546: l_transaction_num xla_ae_line_acs.ac1%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
549:
550: -- Cash lines variables

Line 594: ,xla_ae_line_acs ala

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
597: ,ja_cn_ledger_le_bsv_gt glsv
598: WHERE ah.gl_transfer_status_code = ''Y''

Line 602: FROM xla_ae_line_acs

598: WHERE ah.gl_transfer_status_code = ''Y''
599: AND al.ae_header_id = ah.ae_header_id
600: --AND al.analytical_balance_flag IS NOT NULL
601: AND ala.ae_header_id IN (SELECT ae_header_id
602: FROM xla_ae_line_acs
603: WHERE analytical_criterion_code = ''CHECK_ID''
604: AND amb_context_code = ''DEFAULT''
605: AND analytical_criterion_type_code = ''S''
606: AND ac1= :l_transaction_num)

Line 646: ,xla_ae_line_acs ala

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
649: ,gl_code_combinations gcc
650: ,gl_code_combinations gcc1