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_DATA_CLT_PKG dependencies on GL_JE_HEADERS

Line 681: l_je_header_id GL_JE_HEADERS.JE_HEADER_ID%TYPE;

677: l_period_name_to gl_periods.period_name%TYPE:=P_GL_PERIOD_TO; --period name of th
678:
679: -- GL: GL_JE_HEADER
680: l_je_func_curr_code gl_sets_of_books.currency_code%TYPE;
681: l_je_header_id GL_JE_HEADERS.JE_HEADER_ID%TYPE;
682: l_je_catg GL_JE_HEADERS.je_category%TYPE;
683: l_je_jnl_name GL_JE_HEADERS.name%TYPE;
684: l_je_jnl_doc_seq_num GL_JE_HEADERS.Doc_Sequence_Value%TYPE;
685: l_je_curr_code GL_JE_HEADERS.currency_code%TYPE;

Line 682: l_je_catg GL_JE_HEADERS.je_category%TYPE;

678:
679: -- GL: GL_JE_HEADER
680: l_je_func_curr_code gl_sets_of_books.currency_code%TYPE;
681: l_je_header_id GL_JE_HEADERS.JE_HEADER_ID%TYPE;
682: l_je_catg GL_JE_HEADERS.je_category%TYPE;
683: l_je_jnl_name GL_JE_HEADERS.name%TYPE;
684: l_je_jnl_doc_seq_num GL_JE_HEADERS.Doc_Sequence_Value%TYPE;
685: l_je_curr_code GL_JE_HEADERS.currency_code%TYPE;
686: l_je_curr_cov_rate GL_JE_HEADERS.currency_conversion_rate%TYPE;

Line 683: l_je_jnl_name GL_JE_HEADERS.name%TYPE;

679: -- GL: GL_JE_HEADER
680: l_je_func_curr_code gl_sets_of_books.currency_code%TYPE;
681: l_je_header_id GL_JE_HEADERS.JE_HEADER_ID%TYPE;
682: l_je_catg GL_JE_HEADERS.je_category%TYPE;
683: l_je_jnl_name GL_JE_HEADERS.name%TYPE;
684: l_je_jnl_doc_seq_num GL_JE_HEADERS.Doc_Sequence_Value%TYPE;
685: l_je_curr_code GL_JE_HEADERS.currency_code%TYPE;
686: l_je_curr_cov_rate GL_JE_HEADERS.currency_conversion_rate%TYPE;
687: l_je_curr_cov_type GL_JE_HEADERS.currency_conversion_type%TYPE;

Line 684: l_je_jnl_doc_seq_num GL_JE_HEADERS.Doc_Sequence_Value%TYPE;

680: l_je_func_curr_code gl_sets_of_books.currency_code%TYPE;
681: l_je_header_id GL_JE_HEADERS.JE_HEADER_ID%TYPE;
682: l_je_catg GL_JE_HEADERS.je_category%TYPE;
683: l_je_jnl_name GL_JE_HEADERS.name%TYPE;
684: l_je_jnl_doc_seq_num GL_JE_HEADERS.Doc_Sequence_Value%TYPE;
685: l_je_curr_code GL_JE_HEADERS.currency_code%TYPE;
686: l_je_curr_cov_rate GL_JE_HEADERS.currency_conversion_rate%TYPE;
687: l_je_curr_cov_type GL_JE_HEADERS.currency_conversion_type%TYPE;
688: l_je_curr_cov_date GL_JE_HEADERS.currency_conversion_date%TYPE;

Line 685: l_je_curr_code GL_JE_HEADERS.currency_code%TYPE;

681: l_je_header_id GL_JE_HEADERS.JE_HEADER_ID%TYPE;
682: l_je_catg GL_JE_HEADERS.je_category%TYPE;
683: l_je_jnl_name GL_JE_HEADERS.name%TYPE;
684: l_je_jnl_doc_seq_num GL_JE_HEADERS.Doc_Sequence_Value%TYPE;
685: l_je_curr_code GL_JE_HEADERS.currency_code%TYPE;
686: l_je_curr_cov_rate GL_JE_HEADERS.currency_conversion_rate%TYPE;
687: l_je_curr_cov_type GL_JE_HEADERS.currency_conversion_type%TYPE;
688: l_je_curr_cov_date GL_JE_HEADERS.currency_conversion_date%TYPE;
689: l_je_inter_flag GL_JE_HEADERS.global_attribute1%TYPE;

Line 686: l_je_curr_cov_rate GL_JE_HEADERS.currency_conversion_rate%TYPE;

682: l_je_catg GL_JE_HEADERS.je_category%TYPE;
683: l_je_jnl_name GL_JE_HEADERS.name%TYPE;
684: l_je_jnl_doc_seq_num GL_JE_HEADERS.Doc_Sequence_Value%TYPE;
685: l_je_curr_code GL_JE_HEADERS.currency_code%TYPE;
686: l_je_curr_cov_rate GL_JE_HEADERS.currency_conversion_rate%TYPE;
687: l_je_curr_cov_type GL_JE_HEADERS.currency_conversion_type%TYPE;
688: l_je_curr_cov_date GL_JE_HEADERS.currency_conversion_date%TYPE;
689: l_je_inter_flag GL_JE_HEADERS.global_attribute1%TYPE;
690: l_je_effective_date GL_JE_HEADERS.DEFAULT_EFFECTIVE_DATE%TYPE;

Line 687: l_je_curr_cov_type GL_JE_HEADERS.currency_conversion_type%TYPE;

683: l_je_jnl_name GL_JE_HEADERS.name%TYPE;
684: l_je_jnl_doc_seq_num GL_JE_HEADERS.Doc_Sequence_Value%TYPE;
685: l_je_curr_code GL_JE_HEADERS.currency_code%TYPE;
686: l_je_curr_cov_rate GL_JE_HEADERS.currency_conversion_rate%TYPE;
687: l_je_curr_cov_type GL_JE_HEADERS.currency_conversion_type%TYPE;
688: l_je_curr_cov_date GL_JE_HEADERS.currency_conversion_date%TYPE;
689: l_je_inter_flag GL_JE_HEADERS.global_attribute1%TYPE;
690: l_je_effective_date GL_JE_HEADERS.DEFAULT_EFFECTIVE_DATE%TYPE;
691: l_je_line_num GL_JE_LINES.je_line_num%TYPE;

Line 688: l_je_curr_cov_date GL_JE_HEADERS.currency_conversion_date%TYPE;

684: l_je_jnl_doc_seq_num GL_JE_HEADERS.Doc_Sequence_Value%TYPE;
685: l_je_curr_code GL_JE_HEADERS.currency_code%TYPE;
686: l_je_curr_cov_rate GL_JE_HEADERS.currency_conversion_rate%TYPE;
687: l_je_curr_cov_type GL_JE_HEADERS.currency_conversion_type%TYPE;
688: l_je_curr_cov_date GL_JE_HEADERS.currency_conversion_date%TYPE;
689: l_je_inter_flag GL_JE_HEADERS.global_attribute1%TYPE;
690: l_je_effective_date GL_JE_HEADERS.DEFAULT_EFFECTIVE_DATE%TYPE;
691: l_je_line_num GL_JE_LINES.je_line_num%TYPE;
692: l_je_line_desc GL_JE_LINES.description%TYPE;

Line 689: l_je_inter_flag GL_JE_HEADERS.global_attribute1%TYPE;

685: l_je_curr_code GL_JE_HEADERS.currency_code%TYPE;
686: l_je_curr_cov_rate GL_JE_HEADERS.currency_conversion_rate%TYPE;
687: l_je_curr_cov_type GL_JE_HEADERS.currency_conversion_type%TYPE;
688: l_je_curr_cov_date GL_JE_HEADERS.currency_conversion_date%TYPE;
689: l_je_inter_flag GL_JE_HEADERS.global_attribute1%TYPE;
690: l_je_effective_date GL_JE_HEADERS.DEFAULT_EFFECTIVE_DATE%TYPE;
691: l_je_line_num GL_JE_LINES.je_line_num%TYPE;
692: l_je_line_desc GL_JE_LINES.description%TYPE;
693: l_je_line_amount NUMBER;

Line 690: l_je_effective_date GL_JE_HEADERS.DEFAULT_EFFECTIVE_DATE%TYPE;

686: l_je_curr_cov_rate GL_JE_HEADERS.currency_conversion_rate%TYPE;
687: l_je_curr_cov_type GL_JE_HEADERS.currency_conversion_type%TYPE;
688: l_je_curr_cov_date GL_JE_HEADERS.currency_conversion_date%TYPE;
689: l_je_inter_flag GL_JE_HEADERS.global_attribute1%TYPE;
690: l_je_effective_date GL_JE_HEADERS.DEFAULT_EFFECTIVE_DATE%TYPE;
691: l_je_line_num GL_JE_LINES.je_line_num%TYPE;
692: l_je_line_desc GL_JE_LINES.description%TYPE;
693: l_je_line_amount NUMBER;
694: l_je_line_func_amount NUMBER;

Line 791: FROM GL_JE_HEADERS jeh

787: ,decode(jeh.global_attribute_category, 'JE.CN.GLXJEENT.HEADER',
788: nvl(jeh.global_attribute1, 'N'), 'N'
789: ) inter_flag
790: ,jeh.DEFAULT_EFFECTIVE_DATE effective_date
791: FROM GL_JE_HEADERS jeh
792: ,gl_je_categories_tl jec
793: ,JA_CN_DFF_ASSIGNMENTS DFF
794: WHERE jeh.ledger_id = l_ledger_id --using variable P_LEDGER_ID
795: AND jeh.period_name = l_period_name --using variable l_period_name

Line 841: ,GL_JE_HEADERS jeh

837: nvl(jel.ENTERED_CR, 0) je_entered_amount
838: ,nvl(jel.ACCOUNTED_DR, 0) -
839: nvl(jel.ACCOUNTED_CR, 0) je_accounted_amount
840: FROM GL_JE_LINES jel
841: ,GL_JE_HEADERS jeh
842: --,ja_cn_dff_assignments dffa
843: WHERE jel.je_header_id = l_je_header_id --using variable l_je_header_id
844: AND jeh.je_header_id = jel.je_header_id;
845: -- to locate cash flow item in dff_assignment

Line 1309: ,GL_JE_HEADERS GH

1305: BEGIN
1306: Select gl.je_header_id, gl.je_line_num
1307: into l_je_header_id, l_je_line_num
1308: from GL_JE_LINES GL
1309: ,GL_JE_HEADERS GH
1310: where GL.REFERENCE_2 = l_trxb_batch_id
1311: and GL.REFERENCE_4 = l_trxl_id
1312: and GL.REFERENCE_5 = l_distl_id
1313: and GL.REFERENCE_1 = 'Intercompany Transaction'