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

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

Line 422: FROM GL_CODE_COMBINATIONS gcc

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

Line 437: FROM GL_CODE_COMBINATIONS gcc

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

Line 459: ||' FROM GL_CODE_COMBINATIONS gcc'

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

Line 493: FROM GL_CODE_COMBINATIONS gcc

489: ,FIFS.SEGMENT_NAME seg_name
490: ,FFV.Flex_Value flex_value
491: ,FFVT.Description flex_desc
492: BULK COLLECT INTO l_all_acc_seg
493: FROM GL_CODE_COMBINATIONS gcc
494: ,GL_LEDGERS ledger
495: ,FND_ID_FLEX_SEGMENTS FIFS
496: ,FND_SEGMENT_ATTRIBUTE_VALUES FSAV
497: ,FND_FLEX_VALUE_SETS FFVS

Line 661: l_ccid GL_CODE_COMBINATIONS.Code_Combination_Id%TYPE;

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

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

788: 'ATTRIBUTE15',jel.attribute15)
789: ) cash_related_item
790: FROM GL_JE_LINES jel
791: ,ja_cn_dff_assignments dffa
792: ,GL_CODE_COMBINATIONS codecmb --Added for CNAO Enhancement
793: ,FND_SEGMENT_ATTRIBUTE_VALUES fsav
794: WHERE jel.je_header_id = l_je_header_id --using variable l_je_header_id
795: -- to locate cash flow item in dff_assignment
796: AND dffa.Application_Id = 101

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

827: ,jel.description line_desc
828: ,jel.code_combination_id account_ccid
829: ,jel.global_attribute6 cash_related_item
830: FROM GL_JE_LINES jel
831: ,GL_CODE_COMBINATIONS codecmb --Added for CNAO Enhancement
832: ,FND_SEGMENT_ATTRIBUTE_VALUES fsav
833: WHERE jel.je_header_id = l_je_header_id --using variable l_je_header_id
834: AND codecmb.code_combination_id = jel.code_combination_id
835: AND fsav.application_id = 101

Line 1346: l_ccid GL_CODE_COMBINATIONS.Code_Combination_Id%TYPE;

1342: --l_source_meaning varchar2(150); --meaning of GL journal OR InterCom Transaction
1343: l_period_name gl_periods.period_name%TYPE;
1344: l_period_year gl_periods.period_year%TYPE;
1345: l_period_num gl_periods.period_num%TYPE;
1346: l_ccid GL_CODE_COMBINATIONS.Code_Combination_Id%TYPE;
1347: l_account VARCHAR2(2000); --account's flexfield
1348: l_account_desc VARCHAR2(4000); --account's description
1349: l_cash_related_item varchar2(150); --cash related item of a line
1350: l_csi_check varchar2(2); --blank or not of cash related item

Line 1380: l_codecmb_coa_id gl_code_combinations.chart_of_accounts_id%TYPE;

1376: l_distl_party_id fun_dist_lines.party_id%Type;
1377: l_distl_party_type_flg fun_dist_lines.party_type_flag%TYPE;
1378: l_distl_dist_type_flg fun_dist_lines.dist_type_flag%TYPE;
1379: l_distl_ccid fun_dist_lines.ccid%TYPE;
1380: l_codecmb_coa_id gl_code_combinations.chart_of_accounts_id%TYPE;
1381: l_codecmb_com_seg gl_code_combinations.segment1%TYPE;
1382:
1383: --trx date
1384: l_period_start_date date;

Line 1381: l_codecmb_com_seg gl_code_combinations.segment1%TYPE;

1377: l_distl_party_type_flg fun_dist_lines.party_type_flag%TYPE;
1378: l_distl_dist_type_flg fun_dist_lines.dist_type_flag%TYPE;
1379: l_distl_ccid fun_dist_lines.ccid%TYPE;
1380: l_codecmb_coa_id gl_code_combinations.chart_of_accounts_id%TYPE;
1381: l_codecmb_com_seg gl_code_combinations.segment1%TYPE;
1382:
1383: --trx date
1384: l_period_start_date date;
1385: l_perioD_end_date date;

Line 1523: ,GL_CODE_COMBINATIONS codecmb

1519: 'ATTRIBUTE15',trldist.attribute15)
1520: , '') trxh_cash_related_item
1521: FROM FUN_TRX_LINES trl
1522: ,FUN_DIST_LINES trldist
1523: ,GL_CODE_COMBINATIONS codecmb
1524: ,FND_SEGMENT_ATTRIBUTE_VALUES fsav
1525: ,JA_CN_DFF_ASSIGNMENTS dff
1526: WHERE trl.line_id=trldist.line_id
1527: AND trl.trx_id=trldist.trx_id