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_CFS_DATA_CLT_PKG dependencies on GL_CODE_COMBINATIONS

Line 173: FROM GL_CODE_COMBINATIONS gcc

169: 'SEGMENT22',GCC.SEGMENT22, 'SEGMENT23',GCC.SEGMENT23, 'SEGMENT24',GCC.SEGMENT24,
170: 'SEGMENT25',GCC.SEGMENT25, 'SEGMENT26',GCC.SEGMENT26, 'SEGMENT27',GCC.SEGMENT27,
171: 'SEGMENT28',GCC.SEGMENT28, 'SEGMENT29',GCC.SEGMENT29, 'SEGMENT30',GCC.SEGMENT30)
172: seg_fsav_gcc
173: FROM GL_CODE_COMBINATIONS gcc
174: ,GL_LEDGERS ledger
175: ,FND_ID_FLEX_SEGMENTS FIFS
176: ,FND_SEGMENT_ATTRIBUTE_VALUES FSAV
177: ,FND_FLEX_VALUE_SETS FFVS

Line 696: l_ccid GL_CODE_COMBINATIONS.Code_Combination_Id%TYPE;

692: l_je_line_desc GL_JE_LINES.description%TYPE;
693: l_je_line_amount NUMBER;
694: l_je_line_func_amount NUMBER;
695: -- GL: Gl_JE_LINES
696: l_ccid GL_CODE_COMBINATIONS.Code_Combination_Id%TYPE;
697: l_cash_related_item varchar2(150); --cash related item of a line
698: l_cash_related_item_1 varchar2(150); --copy of cash related item of a line
699: l_csi_check varchar2(2); --blank or not of cash related item
700: l_line_check varchar2(16); --result of a line's validation

Line 734: l_codecmb_coa_id gl_code_combinations.chart_of_accounts_id%TYPE;

730: l_distl_amount_cr fun_dist_lines.amount_cr%TYPE;
731: l_distl_amount_dr fun_dist_lines.amount_dr%TYPE;
732: l_distl_number fun_dist_lines.dist_number%TYPE;
733: l_distl_ccid fun_dist_lines.ccid%TYPE;
734: l_codecmb_coa_id gl_code_combinations.chart_of_accounts_id%TYPE;
735: l_codecmb_com_seg gl_code_combinations.segment1%TYPE;
736: l_distl_id NUMBER;
737:
738: -- AGIS: CURRENCY RATE

Line 735: l_codecmb_com_seg gl_code_combinations.segment1%TYPE;

731: l_distl_amount_dr fun_dist_lines.amount_dr%TYPE;
732: l_distl_number fun_dist_lines.dist_number%TYPE;
733: l_distl_ccid fun_dist_lines.ccid%TYPE;
734: l_codecmb_coa_id gl_code_combinations.chart_of_accounts_id%TYPE;
735: l_codecmb_com_seg gl_code_combinations.segment1%TYPE;
736: l_distl_id NUMBER;
737:
738: -- AGIS: CURRENCY RATE
739: l_trxh_curr_cov_rate GL_DAILY_RATES.CONVERSION_RATE%TYPE := 1;

Line 929: ,GL_CODE_COMBINATIONS codecmb

925: 'ATTRIBUTE15',trldist.attribute15)
926: , '') distl_cash_related_item
927: FROM FUN_TRX_LINES trl
928: ,FUN_DIST_LINES trldist
929: ,GL_CODE_COMBINATIONS codecmb
930: ,FND_SEGMENT_ATTRIBUTE_VALUES fsav
931: --,JA_CN_LEDGER_LE_BSV_GT tmpbsv
932: ,JA_CN_DFF_ASSIGNMENTS dff
933: ,xle_entity_profiles xep -- Added for fixing bug# 8744259 by Chaoqun on 30-Jul-2009

Line 1533: L_BALANCING_SEGMENT GL_CODE_COMBINATIONS.SEGMENT1%TYPE;

1529: ( P_CC_ID IN NUMBER
1530: )
1531: RETURN VARCHAR2
1532: IS
1533: L_BALANCING_SEGMENT GL_CODE_COMBINATIONS.SEGMENT1%TYPE;
1534: BEGIN
1535: SELECT
1536: DECODE(FSAV.APPLICATION_COLUMN_NAME, --segment FSAV.APPLICATION_COLUMN_NAME of gcc
1537: 'SEGMENT1',GCC.SEGMENT1, 'SEGMENT2',GCC.SEGMENT2, 'SEGMENT3',GCC.SEGMENT3,

Line 1548: FROM GL_CODE_COMBINATIONS GCC,

1544: 'SEGMENT22',GCC.SEGMENT22, 'SEGMENT23',GCC.SEGMENT23, 'SEGMENT24',GCC.SEGMENT24,
1545: 'SEGMENT25',GCC.SEGMENT25, 'SEGMENT26',GCC.SEGMENT26, 'SEGMENT27',GCC.SEGMENT27,
1546: 'SEGMENT28',GCC.SEGMENT28, 'SEGMENT29',GCC.SEGMENT29, 'SEGMENT30',GCC.SEGMENT30)
1547: INTO L_BALANCING_SEGMENT
1548: FROM GL_CODE_COMBINATIONS GCC,
1549: FND_SEGMENT_ATTRIBUTE_VALUES FSAV
1550: WHERE GCC.CODE_COMBINATION_ID = P_CC_ID
1551: AND FSAV.ATTRIBUTE_VALUE = 'Y'
1552: AND FSAV.APPLICATION_ID = 101