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 160: ,FND_ID_FLEX_SEGMENTS FIFS

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

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

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

Line 398: ,seg_name FND_ID_FLEX_SEGMENTS.Segment_Name%TYPE

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

Line 399: ,column_name FND_ID_FLEX_SEGMENTS.APPLICATION_COLUMN_NAME%TYPE

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

Line 400: ,value_set_id FND_ID_FLEX_SEGMENTS.FLEX_VALUE_SET_ID%TYPE

396:
397: TYPE t_segemnt_type IS RECORD ( seg_num FND_ID_FLEX_SEGMENTS.SEGMENT_NUM%TYPE
398: ,seg_name FND_ID_FLEX_SEGMENTS.Segment_Name%TYPE
399: ,column_name FND_ID_FLEX_SEGMENTS.APPLICATION_COLUMN_NAME%TYPE
400: ,value_set_id FND_ID_FLEX_SEGMENTS.FLEX_VALUE_SET_ID%TYPE
401: );
402: TYPE t_segemnt_array IS TABLE OF t_segemnt_type;
403: l_all_segemnts t_segemnt_array;
404: l_segemnt t_segemnt_type;

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

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

Line 407: ,seg_name FND_ID_FLEX_SEGMENTS.SEGMENT_NAME%TYPE

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

Line 438: ,FND_ID_FLEX_SEGMENTS FIFS

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

Line 461: ||' ,FND_ID_FLEX_SEGMENTS FIFS'

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'
464: ||' ,FND_FLEX_VALUES FFV'
465: ||' ,FND_FLEX_VALUES_TL FFVT'

Line 495: ,FND_ID_FLEX_SEGMENTS FIFS

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
498: ,FND_FLEX_VALUES FFV
499: ,FND_FLEX_VALUES_TL FFVT