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.

[Home] [Help]

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 1381: --Cursor to get basic info for suppliers included in table JA_CN_ACCOUNT_BALANCES

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

Line 1394: FROM JA_CN_ACCOUNT_BALANCES BAL

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

Line 1425: FROM JA_CN_ACCOUNT_BALANCES BAL

1421: ,nvl(CUST_PARTY.PARTY_NUMBER,'') cust_number --Updated by Chaoqun for fixing bug#8420682 on 19-May-2009
1422: ,nvl(CUST_PARTY.PARTY_NAME, '') cust_name
1423: /*,nvl(L_CLASS.MEANING, '') cust_class --CUSTOMER_CLASS_MEANING*/
1424: ,nvl(CP.CREDIT_RATING, '') cust_credit
1425: FROM JA_CN_ACCOUNT_BALANCES BAL
1426: ,HZ_CUST_ACCOUNTS CUST
1427: ,HZ_PARTIES CUST_PARTY
1428: /*,AR_LOOKUPS L_CLASS*/
1429: ,HZ_CUSTOMER_PROFILES CP

Line 1805: l_cc_number JA_CN_ACCOUNT_BALANCES.cost_center%TYPE;

1801: l_coa_id NUMBER := P_COA_ID;
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.

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

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
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.

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

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
1814: SELECT *
1815: FROM (

Line 1819: FROM JA_CN_ACCOUNT_BALANCES BAL

1815: FROM (
1816: SELECT DISTINCT
1817: FFV.FLEX_VALUE cc_number
1818: ,nvl(FFVT.description, '') cc_name
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

Line 1941: l_person_number JA_CN_ACCOUNT_BALANCES.personnel_number%TYPE;

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

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

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

Line 1952: FROM JA_CN_ACCOUNT_BALANCES BAL

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