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_POST_UTILITY_PKG dependencies on JA_CN_CODE_COMBINATION_V

Line 218: FROM ja_cn_code_combination_v jcc

214: , jcc.cost_segment
215: , jcc.project_number
216: , jcc.project_id
217: , substr(ffv.COMPILED_VALUE_ATTRIBUTES,5,1) account_type
218: FROM ja_cn_code_combination_v jcc
219: , FND_FLEX_VALUES ffv
220: WHERE jcc.ledger_id = p_ledger_id
221: AND ffv.PARENT_FLEX_VALUE_LOW IS NULL
222: AND ffv.FLEX_VALUE_SET_ID = pc_flex_value_set_id

Line 228: FROM ja_cn_code_combination_v jcc1

224: AND (jcc.company_segment, jcc.account_segment, jcc.cost_segment) IN
225: (SELECT jcc1.company_segment
226: , jcc1.account_segment
227: , jcc1.cost_segment
228: FROM ja_cn_code_combination_v jcc1
229: WHERE jcc1.CODE_COMBINATION_ID = pc_RET_EARN_CODE_COMBIN_ID
230: AND jcc1.ledger_id = p_ledger_id);
231:
232: --get retained earning account segements: company, account, cost center

Line 241: FROM ja_cn_code_combination_v jcc

237: , jcc.cost_segment
238: , jcc.project_number
239: , jcc.project_id
240: , substr(ffv.COMPILED_VALUE_ATTRIBUTES,5,1) account_type
241: FROM ja_cn_code_combination_v jcc
242: , FND_FLEX_VALUES ffv
243: WHERE jcc.ledger_id = p_ledger_id
244: AND ffv.PARENT_FLEX_VALUE_LOW IS NULL
245: AND ffv.FLEX_VALUE_SET_ID = pc_flex_value_set_id

Line 250: FROM ja_cn_code_combination_v jcc1

246: AND ffv.flex_value = jcc.account_segment
247: AND (jcc.company_segment, jcc.account_segment) IN
248: (SELECT jcc1.company_segment
249: , jcc1.account_segment
250: FROM ja_cn_code_combination_v jcc1
251: WHERE jcc1.CODE_COMBINATION_ID = pc_RET_EARN_CODE_COMBIN_ID
252: AND jcc1.ledger_id = p_ledger_id);*/
253:
254: BEGIN

Line 567: FROM ja_cn_code_combination_v jcc

563: , l_ret_cost_center_seg
564: , l_ret_project_number
565: , l_ret_project_id
566: , l_ret_account_type
567: FROM ja_cn_code_combination_v jcc
568: , FND_FLEX_VALUES ffv
569: WHERE jcc.CODE_COMBINATION_ID = l_RET_EARN_CODE_COMBINATION_ID
570: AND jcc.ledger_id = p_ledger_id
571: AND ffv.PARENT_FLEX_VALUE_LOW IS NULL

Line 615: FROM ja_cn_code_combination_v jcc

611: , l_ret_cost_center_seg
612: , l_ret_project_number
613: , l_ret_project_id
614: , l_ret_account_type
615: FROM ja_cn_code_combination_v jcc
616: , FND_FLEX_VALUES ffv
617: WHERE jcc.CODE_COMBINATION_ID = l_RET_EARN_CODE_COMBINATION_ID
618: AND jcc.ledger_id = p_ledger_id
619: AND ffv.PARENT_FLEX_VALUE_LOW IS NULL

Line 1336: lv_account_number JA_CN_CODE_COMBINATION_V.ACCOUNT_SEGMENT%TYPE; --Added for bug 9582957

1332: l_flex_value_set_id FND_FLEX_VALUE_SETS.Flex_Value_Set_Id%TYPE;
1333: i NUMBER;
1334:
1335: l_number NUMBER;
1336: lv_account_number JA_CN_CODE_COMBINATION_V.ACCOUNT_SEGMENT%TYPE; --Added for bug 9582957
1337:
1338: BEGIN
1339: IF( G_PROC_LEVEL >= g_debug_devel )
1340: THEN

Line 1358: FROM ja_cn_code_combination_v Jcc

1354:
1355: --Get retained account, added for bug 9582957
1356: SELECT DISTINCT Account_Segment
1357: INTO lv_account_number
1358: FROM ja_cn_code_combination_v Jcc
1359: WHERE Jcc.Code_Combination_ID = l_RET_EARN_CODE_COMBINATION_ID;
1360:
1361: SELECT COUNT(*)
1362: INTO l_row_count

Line 1533: FROM ja_cn_code_combination_v jcc

1529: , jcc.SEGMENT27
1530: , jcc.SEGMENT28
1531: , jcc.SEGMENT29
1532: , jcc.SEGMENT30
1533: FROM ja_cn_code_combination_v jcc
1534: , FND_FLEX_VALUES ffv
1535: , ja_cn_periods jcp
1536: , gl_balances gb
1537: , ja_cn_code_combination_v jcc1

Line 1537: , ja_cn_code_combination_v jcc1

1533: FROM ja_cn_code_combination_v jcc
1534: , FND_FLEX_VALUES ffv
1535: , ja_cn_periods jcp
1536: , gl_balances gb
1537: , ja_cn_code_combination_v jcc1
1538: WHERE jcc.ledger_id = p_ledger_id --parameter: p_ledger_id
1539: AND ffv.PARENT_FLEX_VALUE_LOW IS NULL
1540: AND ffv.FLEX_VALUE_SET_ID = l_flex_value_set_id --variable: l_flex_value_set_id
1541: AND ffv.flex_value = jcc.account_segment

Line 1760: FROM ja_cn_code_combination_v jcc

1756: , jcc.SEGMENT27
1757: , jcc.SEGMENT28
1758: , jcc.SEGMENT29
1759: , jcc.SEGMENT30
1760: FROM ja_cn_code_combination_v jcc
1761: , FND_FLEX_VALUES ffv
1762: , ja_cn_periods jcp
1763: WHERE jcc.ledger_id = p_ledger_id
1764: AND ffv.PARENT_FLEX_VALUE_LOW IS NULL

Line 1770: FROM ja_cn_code_combination_v jcc1

1766: AND ffv.flex_value = jcc.account_segment
1767: AND jcp.ledger_id = p_ledger_id
1768: AND jcp.period_num BETWEEN l_period_num AND l_last_period_num*/
1769: /*AND EXISTS((SELECT *
1770: FROM ja_cn_code_combination_v jcc1
1771: WHERE jcc1.CODE_COMBINATION_ID = l_RET_EARN_CODE_COMBINATION_ID
1772: AND jcc1.ledger_id = p_ledger_id
1773: AND jcc1.account_segment=jcc.account_segment
1774: AND nvl(jcc1.project_id,'0') =nvl(jcc.project_id ,'0')

Line 1900: FROM ja_cn_code_combination_v jcc

1896: , jcc.SEGMENT27
1897: , jcc.SEGMENT28
1898: , jcc.SEGMENT29
1899: , jcc.SEGMENT30
1900: FROM ja_cn_code_combination_v jcc
1901: , FND_FLEX_VALUES ffv
1902: , ja_cn_periods jcp
1903: WHERE jcc.ledger_id = p_ledger_id
1904: AND ffv.PARENT_FLEX_VALUE_LOW IS NULL

Line 1910: FROM ja_cn_code_combination_v jcc1

1906: AND ffv.flex_value = jcc.account_segment
1907: AND jcp.ledger_id=p_ledger_id
1908: AND jcp.period_num BETWEEN l_period_num AND l_last_period_num
1909: \* AND EXISTS((SELECT *
1910: FROM ja_cn_code_combination_v jcc1
1911: WHERE jcc1.CODE_COMBINATION_ID = l_RET_EARN_CODE_COMBINATION_ID
1912: AND jcc1.ledger_id = p_ledger_id
1913: AND jcc1.account_segment=jcc.account_segment
1914: AND jcc1.cost_segment =jcc.cost_segment

Line 1994: , ja_cn_code_combination_v jcc

1990: , sum(nvl(gb.begin_balance_cr_beq,gb.begin_balance_cr))
1991: , sum(gb.begin_balance_dr)
1992: , sum(gb.begin_balance_cr)
1993: FROM gl_balances gb
1994: , ja_cn_code_combination_v jcc
1995: , ja_cn_code_combination_v jcc1
1996: WHERE gb.ledger_id = p_ledger_id
1997: AND jcc.ledger_id = p_ledger_id
1998: AND gb.code_combination_id = jcc.CODE_COMBINATION_ID

Line 1995: , ja_cn_code_combination_v jcc1

1991: , sum(gb.begin_balance_dr)
1992: , sum(gb.begin_balance_cr)
1993: FROM gl_balances gb
1994: , ja_cn_code_combination_v jcc
1995: , ja_cn_code_combination_v jcc1
1996: WHERE gb.ledger_id = p_ledger_id
1997: AND jcc.ledger_id = p_ledger_id
1998: AND gb.code_combination_id = jcc.CODE_COMBINATION_ID
1999: AND jcc.company_segment = u.company_segment

Line 2025: , ja_cn_code_combination_v jcc

2021: , sum(nvl(gb.begin_balance_cr_beq,gb.begin_balance_cr))
2022: , sum(gb.begin_balance_dr)
2023: , sum(gb.begin_balance_cr)
2024: FROM gl_balances gb
2025: , ja_cn_code_combination_v jcc
2026: , ja_cn_code_combination_v jcc1
2027: WHERE gb.ledger_id = p_ledger_id
2028: AND jcc.ledger_id = p_ledger_id
2029: AND gb.code_combination_id = jcc.CODE_COMBINATION_ID

Line 2026: , ja_cn_code_combination_v jcc1

2022: , sum(gb.begin_balance_dr)
2023: , sum(gb.begin_balance_cr)
2024: FROM gl_balances gb
2025: , ja_cn_code_combination_v jcc
2026: , ja_cn_code_combination_v jcc1
2027: WHERE gb.ledger_id = p_ledger_id
2028: AND jcc.ledger_id = p_ledger_id
2029: AND gb.code_combination_id = jcc.CODE_COMBINATION_ID
2030: AND jcc.company_segment = u.company_segment

Line 2377: , ja_cn_code_combination_v jcc

2373: , fnd_global.USER_ID
2374: , SYSDATE
2375: , fnd_global.LOGIN_ID
2376: FROM gl_balances gb
2377: , ja_cn_code_combination_v jcc
2378: , fnd_flex_values ffv
2379: WHERE gb.ledger_id = p_ledger_id
2380: AND jcc.ledger_id = p_ledger_id
2381: AND gb.code_combination_id = jcc.CODE_COMBINATION_ID