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 397: l_analytical_criterion_code xla_ae_line_acs.analytical_criterion_code%type;

393: l_detailed_cfs_item ja_cn_cfs_activities_all.detailed_cfs_item%type;
394: l_event_class_code ja_cn_cfs_item_mapping_hdrs.event_class_code%TYPE;
395:
396: --the analytical criterion variables
397: l_analytical_criterion_code xla_ae_line_acs.analytical_criterion_code%type;
398: l_ac_type_code xla_ae_line_acs.analytical_criterion_type_code%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:

Line 398: l_ac_type_code xla_ae_line_acs.analytical_criterion_type_code%type;

394: l_event_class_code ja_cn_cfs_item_mapping_hdrs.event_class_code%TYPE;
395:
396: --the analytical criterion variables
397: l_analytical_criterion_code xla_ae_line_acs.analytical_criterion_code%type;
398: l_ac_type_code xla_ae_line_acs.analytical_criterion_type_code%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

Line 399: l_amb_context_code xla_ae_line_acs.amb_context_code%type;

395:
396: --the analytical criterion variables
397: l_analytical_criterion_code xla_ae_line_acs.analytical_criterion_code%type;
398: l_ac_type_code xla_ae_line_acs.analytical_criterion_type_code%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;

Line 400: l_ac_value xla_ae_line_acs.ac1%type;

396: --the analytical criterion variables
397: l_analytical_criterion_code xla_ae_line_acs.analytical_criterion_code%type;
398: l_ac_type_code xla_ae_line_acs.analytical_criterion_type_code%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;

Line 414: l_transaction_num xla_ae_line_acs.ac1%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:
418: -- Cash lines variables

Line 455: ,xla_ae_line_acs ala

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

Line 464: FROM xla_ae_line_acs

460: AND ah.event_type_code NOT IN (''PAYMENT CANCELLED'',''RECP_REVERSE'')
461: AND al.ae_header_id = ah.ae_header_id
462: --AND al.analytical_balance_flag IS NOT NULL
463: AND ala.ae_header_id IN (SELECT ae_header_id
464: FROM xla_ae_line_acs
465: WHERE analytical_criterion_code = ''CHECK_ID''
466: AND amb_context_code = ''DEFAULT''
467: AND analytical_criterion_type_code = ''S''
468: AND ac1= :l_transaction_num)

Line 503: ,xla_ae_line_acs ala

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
506: ,gl_code_combinations gcc
507: ,gl_code_combinations gcc1