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 FND_ID_FLEX_SEGMENTS

Line 158: ,FND_ID_FLEX_SEGMENTS FIFS

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
161: ,FND_FLEX_VALUES FFV
162: WHERE gcc.code_combination_id = l_cc_id --using variable l_cc_id

Line 393: TYPE t_segemnt_type IS RECORD ( seg_num FND_ID_FLEX_SEGMENTS.SEGMENT_NUM%TYPE

389: l_cc_id number := P_CCID;
390:
391: l_delimiter_label FND_ID_FLEX_STRUCTURES.Concatenated_Segment_Delimiter%TYPE;
392:
393: TYPE t_segemnt_type IS RECORD ( seg_num FND_ID_FLEX_SEGMENTS.SEGMENT_NUM%TYPE
394: ,seg_name FND_ID_FLEX_SEGMENTS.Segment_Name%TYPE
395: ,column_name FND_ID_FLEX_SEGMENTS.APPLICATION_COLUMN_NAME%TYPE
396: ,value_set_id FND_ID_FLEX_SEGMENTS.FLEX_VALUE_SET_ID%TYPE
397: );

Line 394: ,seg_name FND_ID_FLEX_SEGMENTS.Segment_Name%TYPE

390:
391: l_delimiter_label FND_ID_FLEX_STRUCTURES.Concatenated_Segment_Delimiter%TYPE;
392:
393: TYPE t_segemnt_type IS RECORD ( seg_num FND_ID_FLEX_SEGMENTS.SEGMENT_NUM%TYPE
394: ,seg_name FND_ID_FLEX_SEGMENTS.Segment_Name%TYPE
395: ,column_name FND_ID_FLEX_SEGMENTS.APPLICATION_COLUMN_NAME%TYPE
396: ,value_set_id FND_ID_FLEX_SEGMENTS.FLEX_VALUE_SET_ID%TYPE
397: );
398: TYPE t_segemnt_array IS TABLE OF t_segemnt_type;

Line 395: ,column_name FND_ID_FLEX_SEGMENTS.APPLICATION_COLUMN_NAME%TYPE

391: l_delimiter_label FND_ID_FLEX_STRUCTURES.Concatenated_Segment_Delimiter%TYPE;
392:
393: TYPE t_segemnt_type IS RECORD ( seg_num FND_ID_FLEX_SEGMENTS.SEGMENT_NUM%TYPE
394: ,seg_name FND_ID_FLEX_SEGMENTS.Segment_Name%TYPE
395: ,column_name FND_ID_FLEX_SEGMENTS.APPLICATION_COLUMN_NAME%TYPE
396: ,value_set_id FND_ID_FLEX_SEGMENTS.FLEX_VALUE_SET_ID%TYPE
397: );
398: TYPE t_segemnt_array IS TABLE OF t_segemnt_type;
399: l_all_segemnts t_segemnt_array;

Line 396: ,value_set_id FND_ID_FLEX_SEGMENTS.FLEX_VALUE_SET_ID%TYPE

392:
393: TYPE t_segemnt_type IS RECORD ( seg_num FND_ID_FLEX_SEGMENTS.SEGMENT_NUM%TYPE
394: ,seg_name FND_ID_FLEX_SEGMENTS.Segment_Name%TYPE
395: ,column_name FND_ID_FLEX_SEGMENTS.APPLICATION_COLUMN_NAME%TYPE
396: ,value_set_id FND_ID_FLEX_SEGMENTS.FLEX_VALUE_SET_ID%TYPE
397: );
398: TYPE t_segemnt_array IS TABLE OF t_segemnt_type;
399: l_all_segemnts t_segemnt_array;
400: l_segemnt t_segemnt_type;

Line 402: TYPE t_acc_seg_type IS RECORD ( seg_num FND_ID_FLEX_SEGMENTS.SEGMENT_NUM%TYPE

398: TYPE t_segemnt_array IS TABLE OF t_segemnt_type;
399: l_all_segemnts t_segemnt_array;
400: l_segemnt t_segemnt_type;
401:
402: TYPE t_acc_seg_type IS RECORD ( seg_num FND_ID_FLEX_SEGMENTS.SEGMENT_NUM%TYPE
403: ,seg_name FND_ID_FLEX_SEGMENTS.SEGMENT_NAME%TYPE
404: ,flex_val FND_FLEX_VALUES.Flex_Value%TYPE
405: ,flex_desc FND_FLEX_VALUES_TL.Description%TYPE
406: );

Line 403: ,seg_name FND_ID_FLEX_SEGMENTS.SEGMENT_NAME%TYPE

399: l_all_segemnts t_segemnt_array;
400: l_segemnt t_segemnt_type;
401:
402: TYPE t_acc_seg_type IS RECORD ( seg_num FND_ID_FLEX_SEGMENTS.SEGMENT_NUM%TYPE
403: ,seg_name FND_ID_FLEX_SEGMENTS.SEGMENT_NAME%TYPE
404: ,flex_val FND_FLEX_VALUES.Flex_Value%TYPE
405: ,flex_desc FND_FLEX_VALUES_TL.Description%TYPE
406: );
407: TYPE t_acc_segt_array IS TABLE OF t_acc_seg_type;

Line 434: ,FND_ID_FLEX_SEGMENTS FIFS

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
438: AND FIFS.ID_FLEX_NUM = gcc.chart_of_accounts_id

Line 457: ||' ,FND_ID_FLEX_SEGMENTS FIFS'

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'
460: ||' ,FND_FLEX_VALUES FFV'
461: ||' ,FND_FLEX_VALUES_TL FFVT'

Line 491: ,FND_ID_FLEX_SEGMENTS FIFS

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
494: ,FND_FLEX_VALUES FFV
495: ,FND_FLEX_VALUES_TL FFVT