[Home] [Help]
59: | gl_je_batches table |
60: | 17-Apr-2008 rajose bug#6978940 changed the where clause for |
61: | p_include_zero_amount_flag from >0 to <> 0 |
62: | 16-Feb-2009 nksurana Instead of function calling new procedure |
63: | xla_report_utility_pkg.get_transaction_id |
64: | 12-Mar-2009 nksurana Added p_period_type to filter based on |
65: | whether period is Adjustment/Normal. |
66: | 11-Mar-2009 rajose bug#7834671 Journal Entries report showing |
67: | no data. |
856: ,xlk5.meaning ACCOUNTING_CLASS_NAME
857: ,ael.description LINE_DESCRIPTION
858: ,ael.code_combination_id CODE_COMBINATION_ID
859: ,gcck.concatenated_segments ACCOUNTING_CODE_COMBINATION
860: ,xla_report_utility_pkg.get_ccid_desc(glg.chart_of_accounts_id
861: , ael.code_combination_id)
862: CODE_COMBINATION_DESCRIPTION
863: ,gcck.gl_control_account CONTROL_ACCOUNT_FLAG
864: ,ael.currency_code ENTERED_CURRENCY
1006: g_je_source_application_id IS NOT NULL
1007: THEN
1008: /*
1009: p_trx_identifiers :=
1010: xla_report_utility_pkg.get_transaction_id
1011: (g_je_source_application_id
1012: ,p_ledger_id)||' USERIDS ';*/
1013: --Removed for bug 7580995
1014:
1011: (g_je_source_application_id
1012: ,p_ledger_id)||' USERIDS ';*/
1013: --Removed for bug 7580995
1014:
1015: xla_report_utility_pkg.get_transaction_id
1016: (p_resp_application_id => g_je_source_application_id
1017: ,p_ledger_id => p_ledger_id
1018: ,p_trx_identifiers_1 => p_trx_identifiers_1
1019: ,p_trx_identifiers_2 => p_trx_identifiers_2
1933: ,NULL ACCOUNTING_CLASS_NAME
1934: ,gll.description LINE_DESCRIPTION
1935: ,gll.code_combination_id CODE_COMBINATION_ID
1936: ,gcck.concatenated_segments ACCOUNTING_CODE_COMBINATION
1937: ,xla_report_utility_pkg.get_ccid_desc(glg.chart_of_accounts_id
1938: , gll.code_combination_id)
1939: CODE_COMBINATION_DESCRIPTION
1940: ,gcck.gl_control_account CONTROL_ACCOUNT_FLAG
1941: ,glh.currency_code ENTERED_CURRENCY
2631:
2632: ----------------------------------------------------------------------------
2633: -- get qualifier segments for the COA
2634: ----------------------------------------------------------------------------
2635: xla_report_utility_pkg.get_acct_qualifier_segs
2636: (p_coa_id => l_coa_id
2637: ,p_balance_segment => l_balancing_segment
2638: ,p_account_segment => l_account_segment
2639: ,p_cost_center_segment => l_costcenter_segment
2696: ,'$alias_intercompany_segment$'
2697: ,l_alias_intercompany_segment);
2698:
2699:
2700: xla_report_utility_pkg.get_segment_info
2701: (p_coa_id => l_coa_id
2702: ,p_balancing_segment => l_balancing_segment
2703: ,p_account_segment => l_account_segment
2704: ,p_costcenter_segment => l_costcenter_segment