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_AB_EXP_PKG dependencies on FND_CURRENCIES_VL

Line 77: l_functional_currency fnd_currencies_vl.NAME%TYPE;

73: l_number_a NUMBER;
74: l_number_b NUMBER;
75:
76: -- l_set_of_books_id ja_cn_system_parameters_all.legal_entity_id%TYPE;
77: l_functional_currency fnd_currencies_vl.NAME%TYPE;
78: l_functional_currency_code fnd_currencies_vl.CURRENCY_CODE%TYPE;
79: --l_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%TYPE;
80: l_flex_value_set_id fnd_id_flex_segments.flex_value_set_id%TYPE;
81: l_ja_cn_dff_assignments_row ja_cn_dff_assignments%ROWTYPE;

Line 78: l_functional_currency_code fnd_currencies_vl.CURRENCY_CODE%TYPE;

74: l_number_b NUMBER;
75:
76: -- l_set_of_books_id ja_cn_system_parameters_all.legal_entity_id%TYPE;
77: l_functional_currency fnd_currencies_vl.NAME%TYPE;
78: l_functional_currency_code fnd_currencies_vl.CURRENCY_CODE%TYPE;
79: --l_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%TYPE;
80: l_flex_value_set_id fnd_id_flex_segments.flex_value_set_id%TYPE;
81: l_ja_cn_dff_assignments_row ja_cn_dff_assignments%ROWTYPE;
82: l_context_code ja_cn_dff_assignments.context_code%TYPE;

Line 179: '.account_segment =s.account_segment_value left join fnd_currencies_vl ' ||

175: GROUP BY account_segment,@CURRENCY_CLAUSE2 period_mon,account_type,PERIOD_NAME @COLUMN_CLAUSE) ' ||
176: prefix_a ||
177: ' LEFT JOIN ja_cn_subsidiary_gt s ON ' ||
178: prefix_a ||
179: '.account_segment =s.account_segment_value left join fnd_currencies_vl ' ||
180: prefix_b || ' ON ' || prefix_a ||
181: '.currency_code=' || prefix_b ||
182: '.currency_code)';
183:

Line 527: SELECT fnd_currencies_vl.NAME

523: END IF; --c_in_ja_cn_account_balances%ROWCOUNT = 0
524: CLOSE c_in_ja_cn_account_balances;
525:
526: --fetch functional currency name
527: SELECT fnd_currencies_vl.NAME
528: INTO l_functional_currency
529: FROM fnd_currencies_vl
530: WHERE currency_code =
531: (SELECT currency_code

Line 529: FROM fnd_currencies_vl

525:
526: --fetch functional currency name
527: SELECT fnd_currencies_vl.NAME
528: INTO l_functional_currency
529: FROM fnd_currencies_vl
530: WHERE currency_code =
531: (SELECT currency_code
532: FROM gl_ledgers--gl_sets_of_books
533: WHERE ledger_id = p_ledger_id);--set_of_books_id = l_set_of_books_id);

Line 684: (SELECT fnd_currencies_vl.NAME

680: nvl(l_account_balances_gbl_tmp_row.PERSONNEL_NUMBER, 'NULL')
681: AND nvl(PROJECT_NUMBER, 'NULL') =
682: nvl(l_account_balances_gbl_tmp_row.PROJECT_NUMBER, 'NULL')
683: AND currency_code <>
684: (SELECT fnd_currencies_vl.NAME
685: FROM fnd_currencies_vl
686: WHERE currency_code = l_account_balances_gbl_tmp_row.is_foreign)
687: AND FUNC_BEGIN_BALANCE <> 0
688: AND FUNC_END_BALANCE <> 0;

Line 685: FROM fnd_currencies_vl

681: AND nvl(PROJECT_NUMBER, 'NULL') =
682: nvl(l_account_balances_gbl_tmp_row.PROJECT_NUMBER, 'NULL')
683: AND currency_code <>
684: (SELECT fnd_currencies_vl.NAME
685: FROM fnd_currencies_vl
686: WHERE currency_code = l_account_balances_gbl_tmp_row.is_foreign)
687: AND FUNC_BEGIN_BALANCE <> 0
688: AND FUNC_END_BALANCE <> 0;
689: --fnd_file.PUT_LINE(fnd_file.LOG,l_number_a);

Line 758: (SELECT fnd_currencies_vl.NAME

754: nvl(l_account_balances_gbl_tmp_row.PERSONNEL_NUMBER, 'NULL')
755: AND nvl(PROJECT_NUMBER, 'NULL') =
756: nvl(l_account_balances_gbl_tmp_row.PROJECT_NUMBER, 'NULL')
757: AND currency_code <>
758: (SELECT fnd_currencies_vl.NAME
759: FROM fnd_currencies_vl
760: WHERE currency_code =
761: l_account_balances_gbl_tmp_row.is_foreign)
762: AND FUNC_BEGIN_BALANCE <> 0

Line 759: FROM fnd_currencies_vl

755: AND nvl(PROJECT_NUMBER, 'NULL') =
756: nvl(l_account_balances_gbl_tmp_row.PROJECT_NUMBER, 'NULL')
757: AND currency_code <>
758: (SELECT fnd_currencies_vl.NAME
759: FROM fnd_currencies_vl
760: WHERE currency_code =
761: l_account_balances_gbl_tmp_row.is_foreign)
762: AND FUNC_BEGIN_BALANCE <> 0
763: AND FUNC_END_BALANCE <> 0;

Line 837: (SELECT fnd_currencies_vl.NAME

833: FROM ja_cn_account_balances_gt
834: WHERE account_segment =
835: l_ja_cn_subsidiary_gbl_tmp_row.account_segment_value
836: AND currency_code <>
837: (SELECT fnd_currencies_vl.NAME
838: FROM fnd_currencies_vl
839: WHERE currency_code =
840: l_ja_cn_subsidiary_gbl_tmp_row.is_foreign)
841: AND FUNC_BEGIN_BALANCE <> 0

Line 838: FROM fnd_currencies_vl

834: WHERE account_segment =
835: l_ja_cn_subsidiary_gbl_tmp_row.account_segment_value
836: AND currency_code <>
837: (SELECT fnd_currencies_vl.NAME
838: FROM fnd_currencies_vl
839: WHERE currency_code =
840: l_ja_cn_subsidiary_gbl_tmp_row.is_foreign)
841: AND FUNC_BEGIN_BALANCE <> 0
842: AND FUNC_END_BALANCE <> 0;