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

Line 156: FROM GL_CODE_COMBINATIONS gcc

152: 'SEGMENT22',GCC.SEGMENT22, 'SEGMENT23',GCC.SEGMENT23, 'SEGMENT24',GCC.SEGMENT24,
153: 'SEGMENT25',GCC.SEGMENT25, 'SEGMENT26',GCC.SEGMENT26, 'SEGMENT27',GCC.SEGMENT27,
154: 'SEGMENT28',GCC.SEGMENT28, 'SEGMENT29',GCC.SEGMENT29, 'SEGMENT30',GCC.SEGMENT30)
155: seg_fsav_gcc
156: FROM GL_CODE_COMBINATIONS gcc
157: ,GL_LEDGERS ledger
158: ,FND_ID_FLEX_SEGMENTS FIFS
159: ,FND_SEGMENT_ATTRIBUTE_VALUES FSAV
160: ,FND_FLEX_VALUE_SETS FFVS

Line 418: FROM GL_CODE_COMBINATIONS gcc

414: BEGIN
415: --Get delimiter label
416: SELECT FIFStr.Concatenated_Segment_Delimiter
417: INTO l_delimiter_label
418: FROM GL_CODE_COMBINATIONS gcc
419: ,FND_ID_FLEX_STRUCTURES FIFStr
420: WHERE gcc.code_combination_id = l_cc_id --using variable l_cc_id
421: AND FIFStr.APPLICATION_ID=101
422: AND FIFStr.ID_FLEX_CODE='GL#'

Line 433: FROM GL_CODE_COMBINATIONS gcc

429: ,FIFS.Segment_Name
430: ,FIFS.APPLICATION_COLUMN_NAME
431: ,FIFS.FLEX_VALUE_SET_ID
432: BULK COLLECT INTO l_all_segemnts
433: FROM GL_CODE_COMBINATIONS gcc
434: ,FND_ID_FLEX_SEGMENTS FIFS
435: WHERE gcc.code_combination_id = l_cc_id --using variable l_cc_id
436: AND FIFS.APPLICATION_ID=101
437: AND FIFS.ID_FLEX_CODE='GL#' -- using standard flex code, without it the output will be reduplicate

Line 455: ||' FROM GL_CODE_COMBINATIONS gcc'

451: ||' ,FIFS.SEGMENT_NAME seg_name'
452: ||' ,FFV.Flex_Value flex_value'
453: ||' ,FFVT.Description flex_desc'
454: ||' BULK COLLECT INTO :1'
455: ||' FROM GL_CODE_COMBINATIONS gcc'
456: ||' ,GL_SETS_OF_BOOKS sob'
457: ||' ,FND_ID_FLEX_SEGMENTS FIFS'
458: ||' ,FND_SEGMENT_ATTRIBUTE_VALUES FSAV'
459: ||' ,FND_FLEX_VALUE_SETS FFVS'

Line 489: FROM GL_CODE_COMBINATIONS gcc

485: ,FIFS.SEGMENT_NAME seg_name
486: ,FFV.Flex_Value flex_value
487: ,FFVT.Description flex_desc
488: BULK COLLECT INTO l_all_acc_seg
489: FROM GL_CODE_COMBINATIONS gcc
490: ,GL_LEDGERS ledger
491: ,FND_ID_FLEX_SEGMENTS FIFS
492: ,FND_SEGMENT_ATTRIBUTE_VALUES FSAV
493: ,FND_FLEX_VALUE_SETS FFVS

Line 656: l_ccid GL_CODE_COMBINATIONS.Code_Combination_Id%TYPE;

652: --l_source_meaning varchar2(150); --meaning of GL journal OR InterCom Transaction
653: l_period_name gl_periods.period_name%TYPE;
654: l_period_year gl_periods.period_year%TYPE;
655: l_period_num gl_periods.period_num%TYPE;
656: l_ccid GL_CODE_COMBINATIONS.Code_Combination_Id%TYPE;
657: l_account VARCHAR2(2000); --account's flexfield
658: l_account_desc VARCHAR2(4000);--account's description
659: l_cash_related_item varchar2(150); --cash related item of a line
660: l_csi_check varchar2(2); --blank or not of cash related item

Line 785: ,GL_CODE_COMBINATIONS codecmb --Added for CNAO Enhancement

781: 'ATTRIBUTE15',jel.attribute15)
782: ) cash_related_item
783: FROM GL_JE_LINES jel
784: ,ja_cn_dff_assignments dffa
785: ,GL_CODE_COMBINATIONS codecmb --Added for CNAO Enhancement
786: ,FND_SEGMENT_ATTRIBUTE_VALUES fsav
787: WHERE jel.je_header_id = l_je_header_id --using variable l_je_header_id
788: -- to locate cash flow item in dff_assignment
789: AND dffa.Application_Id = 101

Line 1309: l_ccid GL_CODE_COMBINATIONS.Code_Combination_Id%TYPE;

1305: --l_source_meaning varchar2(150); --meaning of GL journal OR InterCom Transaction
1306: l_period_name gl_periods.period_name%TYPE;
1307: l_period_year gl_periods.period_year%TYPE;
1308: l_period_num gl_periods.period_num%TYPE;
1309: l_ccid GL_CODE_COMBINATIONS.Code_Combination_Id%TYPE;
1310: l_account VARCHAR2(2000); --account's flexfield
1311: l_account_desc VARCHAR2(4000); --account's description
1312: l_cash_related_item varchar2(150); --cash related item of a line
1313: l_csi_check varchar2(2); --blank or not of cash related item

Line 1343: l_codecmb_coa_id gl_code_combinations.chart_of_accounts_id%TYPE;

1339: l_distl_party_id fun_dist_lines.party_id%Type;
1340: l_distl_party_type_flg fun_dist_lines.party_type_flag%TYPE;
1341: l_distl_dist_type_flg fun_dist_lines.dist_type_flag%TYPE;
1342: l_distl_ccid fun_dist_lines.ccid%TYPE;
1343: l_codecmb_coa_id gl_code_combinations.chart_of_accounts_id%TYPE;
1344: l_codecmb_com_seg gl_code_combinations.segment1%TYPE;
1345:
1346: --trx date
1347: l_period_start_date date;

Line 1344: l_codecmb_com_seg gl_code_combinations.segment1%TYPE;

1340: l_distl_party_type_flg fun_dist_lines.party_type_flag%TYPE;
1341: l_distl_dist_type_flg fun_dist_lines.dist_type_flag%TYPE;
1342: l_distl_ccid fun_dist_lines.ccid%TYPE;
1343: l_codecmb_coa_id gl_code_combinations.chart_of_accounts_id%TYPE;
1344: l_codecmb_com_seg gl_code_combinations.segment1%TYPE;
1345:
1346: --trx date
1347: l_period_start_date date;
1348: l_perioD_end_date date;

Line 1486: ,GL_CODE_COMBINATIONS codecmb

1482: 'ATTRIBUTE15',trldist.attribute15)
1483: , '') trxh_cash_related_item
1484: FROM FUN_TRX_LINES trl
1485: ,FUN_DIST_LINES trldist
1486: ,GL_CODE_COMBINATIONS codecmb
1487: ,FND_SEGMENT_ATTRIBUTE_VALUES fsav
1488: ,JA_CN_DFF_ASSIGNMENTS dff
1489: WHERE trl.line_id=trldist.line_id
1490: AND trl.trx_id=trldist.trx_id