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 164: FROM GL_CODE_COMBINATIONS gcc

160: 'SEGMENT22',GCC.SEGMENT22, 'SEGMENT23',GCC.SEGMENT23, 'SEGMENT24',GCC.SEGMENT24,
161: 'SEGMENT25',GCC.SEGMENT25, 'SEGMENT26',GCC.SEGMENT26, 'SEGMENT27',GCC.SEGMENT27,
162: 'SEGMENT28',GCC.SEGMENT28, 'SEGMENT29',GCC.SEGMENT29, 'SEGMENT30',GCC.SEGMENT30)
163: seg_fsav_gcc
164: FROM GL_CODE_COMBINATIONS gcc
165: ,GL_LEDGERS ledger
166: ,FND_ID_FLEX_SEGMENTS FIFS
167: ,FND_SEGMENT_ATTRIBUTE_VALUES FSAV
168: ,FND_FLEX_VALUE_SETS FFVS

Line 678: l_ccid GL_CODE_COMBINATIONS.Code_Combination_Id%TYPE;

674: l_je_line_desc GL_JE_LINES.description%TYPE;
675: l_je_line_amount NUMBER;
676: l_je_line_func_amount NUMBER;
677: -- GL: Gl_JE_LINES
678: l_ccid GL_CODE_COMBINATIONS.Code_Combination_Id%TYPE;
679: l_cash_related_item varchar2(150); --cash related item of a line
680: l_cash_related_item_1 varchar2(150); --copy of cash related item of a line
681: l_csi_check varchar2(2); --blank or not of cash related item
682: l_line_check varchar2(16); --result of a line's validation

Line 716: l_codecmb_coa_id gl_code_combinations.chart_of_accounts_id%TYPE;

712: l_distl_amount_cr fun_dist_lines.amount_cr%TYPE;
713: l_distl_amount_dr fun_dist_lines.amount_dr%TYPE;
714: l_distl_number fun_dist_lines.dist_number%TYPE;
715: l_distl_ccid fun_dist_lines.ccid%TYPE;
716: l_codecmb_coa_id gl_code_combinations.chart_of_accounts_id%TYPE;
717: l_codecmb_com_seg gl_code_combinations.segment1%TYPE;
718: l_distl_id NUMBER;
719:
720: -- AGIS: CURRENCY RATE

Line 717: l_codecmb_com_seg gl_code_combinations.segment1%TYPE;

713: l_distl_amount_dr fun_dist_lines.amount_dr%TYPE;
714: l_distl_number fun_dist_lines.dist_number%TYPE;
715: l_distl_ccid fun_dist_lines.ccid%TYPE;
716: l_codecmb_coa_id gl_code_combinations.chart_of_accounts_id%TYPE;
717: l_codecmb_com_seg gl_code_combinations.segment1%TYPE;
718: l_distl_id NUMBER;
719:
720: -- AGIS: CURRENCY RATE
721: l_trxh_curr_cov_rate GL_DAILY_RATES.CONVERSION_RATE%TYPE := 1;

Line 909: ,GL_CODE_COMBINATIONS codecmb

905: 'ATTRIBUTE15',trldist.attribute15)
906: , '') distl_cash_related_item
907: FROM FUN_TRX_LINES trl
908: ,FUN_DIST_LINES trldist
909: ,GL_CODE_COMBINATIONS codecmb
910: ,FND_SEGMENT_ATTRIBUTE_VALUES fsav
911: --,JA_CN_LEDGER_LE_BSV_GT tmpbsv
912: ,JA_CN_DFF_ASSIGNMENTS dff
913: WHERE trl.line_id=trldist.line_id

Line 1482: L_BALANCING_SEGMENT GL_CODE_COMBINATIONS.SEGMENT1%TYPE;

1478: ( P_CC_ID IN NUMBER
1479: )
1480: RETURN VARCHAR2
1481: IS
1482: L_BALANCING_SEGMENT GL_CODE_COMBINATIONS.SEGMENT1%TYPE;
1483: BEGIN
1484: SELECT
1485: DECODE(FSAV.APPLICATION_COLUMN_NAME, --segment FSAV.APPLICATION_COLUMN_NAME of gcc
1486: 'SEGMENT1',GCC.SEGMENT1, 'SEGMENT2',GCC.SEGMENT2, 'SEGMENT3',GCC.SEGMENT3,

Line 1497: FROM GL_CODE_COMBINATIONS GCC,

1493: 'SEGMENT22',GCC.SEGMENT22, 'SEGMENT23',GCC.SEGMENT23, 'SEGMENT24',GCC.SEGMENT24,
1494: 'SEGMENT25',GCC.SEGMENT25, 'SEGMENT26',GCC.SEGMENT26, 'SEGMENT27',GCC.SEGMENT27,
1495: 'SEGMENT28',GCC.SEGMENT28, 'SEGMENT29',GCC.SEGMENT29, 'SEGMENT30',GCC.SEGMENT30)
1496: INTO L_BALANCING_SEGMENT
1497: FROM GL_CODE_COMBINATIONS GCC,
1498: FND_SEGMENT_ATTRIBUTE_VALUES FSAV
1499: WHERE GCC.CODE_COMBINATION_ID = P_CC_ID
1500: AND FSAV.ATTRIBUTE_VALUE = 'Y'
1501: AND FSAV.APPLICATION_ID = 101