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 JA_CN_ACCOUNT_BALANCES

Line 362: --||' ,JA_CN_ACCOUNT_BALANCES BAL '

358: ||' ,FND_FLEX_VALUE_SETS FFVS '
359: ||' ,FND_FLEX_VALUES FFV '
360: ||' ,GL_SETS_OF_BOOKS SOB '
361: --Balane table used here only for project from Project Module
362: --||' ,JA_CN_ACCOUNT_BALANCES BAL '
363: ||' ,(SELECT * FROM JA_CN_ACCOUNT_BALANCES WHERE '
364: ||' project_source = ''PA'' AND set_of_books_id = '
365: || l_sob_id || ') BAL '
366: ||' WHERE '

Line 363: ||' ,(SELECT * FROM JA_CN_ACCOUNT_BALANCES WHERE '

359: ||' ,FND_FLEX_VALUES FFV '
360: ||' ,GL_SETS_OF_BOOKS SOB '
361: --Balane table used here only for project from Project Module
362: --||' ,JA_CN_ACCOUNT_BALANCES BAL '
363: ||' ,(SELECT * FROM JA_CN_ACCOUNT_BALANCES WHERE '
364: ||' project_source = ''PA'' AND set_of_books_id = '
365: || l_sob_id || ') BAL '
366: ||' WHERE '
367: --Get all correct row of FFV

Line 1129: l_pj_number JA_CN_ACCOUNT_BALANCES.project_number%TYPE;

1125: l_row_count NUMBER; --count of rows
1126: --l_pj_source VARCHAR2(150);--VARCHAR2(3); --project data source set in GL GDF
1127: --l_pj_ps VARCHAR2(150);--VARCHAR2(2); --project segment in GL GDF set or not
1128:
1129: l_pj_number JA_CN_ACCOUNT_BALANCES.project_number%TYPE;
1130: l_pj_name VARCHAR2(240);
1131:
1132: /*--Cursor to get project data source, set in GDF, from table GL_SETS_OF_BOOKS
1133: CURSOR c_pj_setup IS

Line 1140: --Cursor to get project_number from table JA_CN_ACCOUNT_BALANCES, and name from table

1136: FROM GL_SETS_OF_BOOKS
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

Line 1151: FROM JA_CN_ACCOUNT_BALANCES BAL

1147: --Get name for projects from project module
1148: SELECT DISTINCT
1149: BAL.project_number pj_number
1150: ,nvl(PPA.name, '') pj_name --name for project from PA
1151: FROM JA_CN_ACCOUNT_BALANCES BAL
1152: ,PA_PROJECTS_ALL PPA
1153: WHERE BAL.Ledger_Id= l_ledger_id --using variable l_sob_id
1154: AND BAL.account_segment IS NOT NULL
1155: AND nvl(BAL.project_source, 'N') = 'PA'

Line 1166: FROM JA_CN_ACCOUNT_BALANCES BAL

1162: --Get name for projects from COA
1163: SELECT DISTINCT
1164: BAL.project_number pj_number
1165: ,nvl(FFVT.description, '') pj_name --name for project from COA
1166: FROM JA_CN_ACCOUNT_BALANCES BAL
1167: ,GL_LEDGERS LEDGER
1168: ,Ja_Cn_Sub_Acc_Sources_All SUBAS
1169: ,FND_ID_FLEX_SEGMENTS FIFS
1170: ,FND_SEGMENT_ATTRIBUTE_VALUES FSAV

Line 1380: --Cursor to get basic info for suppliers included in table JA_CN_ACCOUNT_BALANCES

1376: TYPE t_cust_phone_array IS TABLE OF t_cust_phone;
1377: l_all_cust_phone t_cust_phone_array;
1378: l_cust_phone t_cust_phone;
1379:
1380: --Cursor to get basic info for suppliers included in table JA_CN_ACCOUNT_BALANCES
1381: --Except Territory, Phone number, and Address
1382: CURSOR c_tp_sup IS
1383: SELECT *
1384: FROM (

Line 1393: FROM JA_CN_ACCOUNT_BALANCES BAL

1389: ,nvl(BAL.Third_Party_Number,'') sup_number -- temp solutin ????
1390: ,nvl(PV.VENDOR_NAME, '') sup_name
1391: /*,nvl(LC_TYPE.DISPLAYED_FIELD, '') sup_type --vendor_type_disp*/
1392: ,''
1393: FROM JA_CN_ACCOUNT_BALANCES BAL
1394: ,PO_VENDORS PV
1395: /*,PO_LOOKUP_CODES LC_TYPE*/
1396: WHERE BAL.Ledger_Id = l_ledger_id --using variable l_sob_id
1397: AND BAL.account_segment IS NOT NULL

Line 1423: FROM JA_CN_ACCOUNT_BALANCES BAL

1419: ,nvl(BAL.Third_Party_Number,'') cust_number -- temp solutin ????
1420: ,nvl(CUST_PARTY.PARTY_NAME, '') cust_name
1421: /*,nvl(L_CLASS.MEANING, '') cust_class --CUSTOMER_CLASS_MEANING*/
1422: ,nvl(CP.CREDIT_RATING, '') cust_credit
1423: FROM JA_CN_ACCOUNT_BALANCES BAL
1424: ,HZ_CUST_ACCOUNTS CUST
1425: ,HZ_PARTIES CUST_PARTY
1426: /*,AR_LOOKUPS L_CLASS*/
1427: ,HZ_CUSTOMER_PROFILES CP

Line 1803: l_cc_number JA_CN_ACCOUNT_BALANCES.cost_center%TYPE;

1799: l_coa_id NUMBER := P_COA_ID;
1800: l_seperator varchar2(1) := FND_GLOBAL.Local_Chr(9); --' ';
1801:
1802: l_row_count NUMBER; --count of rows
1803: l_cc_number JA_CN_ACCOUNT_BALANCES.cost_center%TYPE;
1804: l_cc_name FND_FLEX_VALUES_TL.description%TYPE;
1805:
1806: --Cursor to get cost_center from table JA_CN_ACCOUNT_BALANCES and description from table
1807: -- FND_FLEX_VALUES_TL, as Department number and name.

Line 1806: --Cursor to get cost_center from table JA_CN_ACCOUNT_BALANCES and description from table

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

Line 1809: -- no sense to store cost center id in table JA_CN_ACCOUNT_BALANCES. Thus the name should

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

Line 1817: FROM JA_CN_ACCOUNT_BALANCES BAL

1813: FROM (
1814: SELECT DISTINCT
1815: FFV.FLEX_VALUE cc_number
1816: ,nvl(FFVT.description, '') cc_name
1817: FROM JA_CN_ACCOUNT_BALANCES BAL
1818: ,FND_ID_FLEX_SEGMENTS FIFS
1819: ,FND_SEGMENT_ATTRIBUTE_VALUES FSAV
1820: ,FND_FLEX_VALUE_SETS FFVS
1821: ,FND_FLEX_VALUES_TL FFVT

Line 1939: l_person_number JA_CN_ACCOUNT_BALANCES.personnel_number%TYPE;

1935: l_coa_id NUMBER := P_COA_ID;
1936: l_seperator varchar2(1) := FND_GLOBAL.Local_Chr(9); --' ';
1937:
1938: l_row_count NUMBER; --count of rows
1939: l_person_number JA_CN_ACCOUNT_BALANCES.personnel_number%TYPE;
1940: l_person_name VARCHAR2(50);
1941:
1942: --Cursor to get personnel_number from table JA_CN_ACCOUNT_BALANCES,
1943: -- and personnel name from table PER_ALL_PEOPLE_F

Line 1942: --Cursor to get personnel_number from table JA_CN_ACCOUNT_BALANCES,

1938: l_row_count NUMBER; --count of rows
1939: l_person_number JA_CN_ACCOUNT_BALANCES.personnel_number%TYPE;
1940: l_person_name VARCHAR2(50);
1941:
1942: --Cursor to get personnel_number from table JA_CN_ACCOUNT_BALANCES,
1943: -- and personnel name from table PER_ALL_PEOPLE_F
1944: CURSOR c_person IS
1945: SELECT *
1946: FROM (

Line 1950: FROM JA_CN_ACCOUNT_BALANCES BAL

1946: FROM (
1947: SELECT DISTINCT
1948: BAL.personnel_number person_number
1949: ,nvl(PER.last_name||PER.first_name, '') person_name
1950: FROM JA_CN_ACCOUNT_BALANCES BAL
1951: ,PER_ALL_PEOPLE_F PER
1952: WHERE BAL.Ledger_Id = l_ledger_id --using variable l_ledger_id
1953: AND BAL.account_segment IS NOT NULL
1954: and BAL.personnel_id IS NOT NULL