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_COA_EXP_PKG dependencies on FND_FLEX_VALUES_TL

Line 474: l_na_name FND_FLEX_VALUES_TL.description%TYPE;

470: TYPE t_level_seg_lens IS TABLE OF NUMBER;
471: l_acc_seg_lens t_level_seg_lens;
472:
473: l_na_number FND_FLEX_VALUES.FLEX_VALUE%TYPE;
474: l_na_name FND_FLEX_VALUES_TL.description%TYPE;
475: l_na_parent VARCHAR2(1);
476: l_na_level VARCHAR2(100);
477: l_na_sub_flag VARCHAR2(1);
478: l_na_sub_item VARCHAR2(100);

Line 566: ,FND_FLEX_VALUES_TL FFVT

562: ,FND_ID_FLEX_SEGMENTS FIFS
563: ,FND_SEGMENT_ATTRIBUTE_VALUES FSAV
564: ,FND_FLEX_VALUE_SETS FFVS
565: ,FND_FLEX_VALUES FFV
566: ,FND_FLEX_VALUES_TL FFVT
567: ,GL_LEDGERS ledger
568: WHERE --Get all correct row of FFV
569: ledger.ledger_id = l_ledger_id --using variable l_sob_id
570: AND ledger.chart_of_accounts_id = FIFS.id_flex_num

Line 1141: -- PA_PROJECTS_ALL or FND_FLEX_VALUES_TL.

1137: WHERE set_of_books_id = l_sob_id
1138: AND global_attribute_category = 'JA.CN.GLXSTBKS.BOOKS';*/
1139:
1140: --Cursor to get project_number from table JA_CN_ACCOUNT_BALANCES, and name from table
1141: -- PA_PROJECTS_ALL or FND_FLEX_VALUES_TL.
1142: --If two projects from PA and COA are with a same number and same name then
1143: -- only show them one time.
1144: CURSOR c_pj IS
1145: SELECT *

Line 1172: ,FND_FLEX_VALUES_TL FFVT

1168: ,Ja_Cn_Sub_Acc_Sources_All SUBAS
1169: ,FND_ID_FLEX_SEGMENTS FIFS
1170: ,FND_SEGMENT_ATTRIBUTE_VALUES FSAV
1171: ,FND_FLEX_VALUE_SETS FFVS
1172: ,FND_FLEX_VALUES_TL FFVT
1173: ,FND_FLEX_VALUES FFV
1174: WHERE BAL.Ledger_Id= l_ledger_id --using variable l_sob_id
1175: AND BAL.account_segment IS NOT NULL
1176: AND nvl(BAL.project_source, 'N') = 'COA'

Line 1806: l_cc_name FND_FLEX_VALUES_TL.description%TYPE;

1802: l_seperator varchar2(1) := FND_GLOBAL.Local_Chr(9); --' ';
1803:
1804: l_row_count NUMBER; --count of rows
1805: l_cc_number JA_CN_ACCOUNT_BALANCES.cost_center%TYPE;
1806: l_cc_name FND_FLEX_VALUES_TL.description%TYPE;
1807:
1808: --Cursor to get cost_center from table JA_CN_ACCOUNT_BALANCES and description from table
1809: -- FND_FLEX_VALUES_TL, as Department number and name.
1810: --Because the value set of cost center can be changed manually as natural account, it is

Line 1809: -- FND_FLEX_VALUES_TL, as Department number and name.

1805: l_cc_number JA_CN_ACCOUNT_BALANCES.cost_center%TYPE;
1806: l_cc_name FND_FLEX_VALUES_TL.description%TYPE;
1807:
1808: --Cursor to get cost_center from table JA_CN_ACCOUNT_BALANCES and description from table
1809: -- FND_FLEX_VALUES_TL, as Department number and name.
1810: --Because the value set of cost center can be changed manually as natural account, it is
1811: -- no sense to store cost center id in table JA_CN_ACCOUNT_BALANCES. Thus the name should
1812: -- be gotten with the full flow.
1813: CURSOR c_cc IS

Line 1823: ,FND_FLEX_VALUES_TL FFVT

1819: FROM JA_CN_ACCOUNT_BALANCES BAL
1820: ,FND_ID_FLEX_SEGMENTS FIFS
1821: ,FND_SEGMENT_ATTRIBUTE_VALUES FSAV
1822: ,FND_FLEX_VALUE_SETS FFVS
1823: ,FND_FLEX_VALUES_TL FFVT
1824: ,FND_FLEX_VALUES FFV
1825: ,GL_LEDGERS LEDGER
1826: WHERE BAL.Ledger_Id = l_ledger_id --using variable l_sob_id
1827: AND BAL.account_segment IS NOT NULL