ENGINATICSSYSTEM_ADMINISTRATORSYSADMINF8F4DCB21E2E3403E0530100007FE628Yselect
to_char(null) action_,
to_char(null) status_,
to_char(null) message_,
null modified_columns_,
gl.name ledger,
gcck.concatenated_segments,
gl_flexfields_pkg.get_concat_description(gl.chart_of_accounts_id,gcck.code_combination_id) description,
ffvv.description account_type,
gcck.segment1 gl_segment1,
gcck.segment2 gl_segment2,
gcck.segment3 gl_segment3,
gcck.segment4 gl_segment4,
gcck.segment5 gl_segment5,
gcck.segment6 gl_segment6,
gcck.segment7 gl_segment7,
gcck.segment8 gl_segment8,
gcck.segment9 gl_segment9,
gcck.segment10 gl_segment10,
gcck.segment11 gl_segment11,
gcck.segment12 gl_segment12,
gcck.segment13 gl_segment13,
gcck.segment14 gl_segment14,
gcck.segment15 gl_segment15,
xxen_util.meaning(gcck.summary_flag,'YES_NO',0) summary,
xxen_util.meaning(gcck.enabled_flag,'YES_NO',0) enabled,
gcck.start_date_active,
gcck.end_date_active,
xxen_util.meaning(gcck.detail_budgeting_allowed,'YES_NO',0) detail_budgeting_allowed,
xxen_util.meaning(gcck.detail_posting_allowed,'YES_NO',0) detail_posting_allowed,
xxen_util.display_flexfield_context(101,'GL_CODE_COMBINATIONS',gcck.context) attribute_context,
xxen_util.display_flexfield_value(101,'GL_CODE_COMBINATIONS',gcck.context,'ATTRIBUTE1',gcck.rowid,gcck.attribute1) gl_account_attribute1,
xxen_util.display_flexfield_value(101,'GL_CODE_COMBINATIONS',gcck.context,'ATTRIBUTE2',gcck.rowid,gcck.attribute2) gl_account_attribute2,
xxen_util.display_flexfield_value(101,'GL_CODE_COMBINATIONS',gcck.context,'ATTRIBUTE3',gcck.rowid,gcck.attribute3) gl_account_attribute3,
xxen_util.display_flexfield_value(101,'GL_CODE_COMBINATIONS',gcck.context,'ATTRIBUTE4',gcck.rowid,gcck.attribute4) gl_account_attribute4,
xxen_util.display_flexfield_value(101,'GL_CODE_COMBINATIONS',gcck.context,'ATTRIBUTE5',gcck.rowid,gcck.attribute5) gl_account_attribute5,
xxen_util.display_flexfield_value(101,'GL_CODE_COMBINATIONS',gcck.context,'ATTRIBUTE6',gcck.rowid,gcck.attribute6) gl_account_attribute6,
xxen_util.display_flexfield_value(101,'GL_CODE_COMBINATIONS',gcck.context,'ATTRIBUTE7',gcck.rowid,gcck.attribute7) gl_account_attribute7,
xxen_util.display_flexfield_value(101,'GL_CODE_COMBINATIONS',gcck.context,'ATTRIBUTE8',gcck.rowid,gcck.attribute8) gl_account_attribute8,
xxen_util.display_flexfield_value(101,'GL_CODE_COMBINATIONS',gcck.context,'ATTRIBUTE9',gcck.rowid,gcck.attribute9) gl_account_attribute9,
xxen_util.display_flexfield_value(101,'GL_CODE_COMBINATIONS',gcck.context,'ATTRIBUTE10',gcck.rowid,gcck.attribute10) gl_account_attribute10,
gcck.code_combination_id
from
gl_code_combinations_kfv gcck,
gl_code_combinations_kfv gccka,
fnd_flex_values_vl ffvv,
fnd_flex_value_sets ffvs,
fnd_id_flex_structures_tl fifs,
gl_ledgers gl
where
1=1 and
gl.chart_of_accounts_id=gcck.chart_of_accounts_id and
gcck.gl_account_type=ffvv.flex_value and
ffvv.flex_value_set_id=ffvs.flex_value_set_id and
ffvs.flex_value_set_name='GL_SRS_ACCOUNT_TYPE' and
gcck.alternate_code_combination_id=gccka.code_combination_id(+) and
fifs.id_flex_num=gcck.chart_of_accounts_id and
fifs.application_id=101 and
fifs.id_flex_code='GL#' and
fifs.language=userenv ('lang') and
nvl(gcck.summary_flag,'N')<>'Y'Added the GL Accounts descriptive flexfield (Attribute Context and Attributes 1 to 10) so that code combination attributes can be downloaded, created and updated through the upload.UAxxen_gl_upload.create_update_gl_accountxxen_gl_upload.validate_account_segments(
p_action=>:$column$.action_,
p_ledger=>:$column$.ledger,
gl_segment1=>:$column$.gl_segment1,
gl_segment2=>:$column$.gl_segment2,
gl_segment3=>:$column$.gl_segment3,
gl_segment4=>:$column$.gl_segment4,
gl_segment5=>:$column$.gl_segment5,
gl_segment6=>:$column$.gl_segment6,
gl_segment7=>:$column$.gl_segment7,
gl_segment8=>:$column$.gl_segment8,
gl_segment9=>:$column$.gl_segment9,
gl_segment10=>:$column$.gl_segment10,
gl_segment11=>:$column$.gl_segment11,
gl_segment12=>:$column$.gl_segment12,
gl_segment13=>:$column$.gl_segment13,
gl_segment14=>:$column$.gl_segment14,
gl_segment15=>:$column$.gl_segment15
)USGL Account UploadThis upload allows creation of new GL code combinations and update of existing ones. For creation of new code combinations, the upload requires the setup to allow dynamic inserts for code combinations.EnginaticsUpload1=11-301=1:segment_delimiter=:segment_delimiterCharselect
fifsv.concatenated_segment_delimiter
from
gl_ledgers gl,
fnd_id_flex_structures_vl fifsv
where
gl.name=:$flex$.ledger and
fifsv.id_flex_num=gl.chart_of_accounts_id and
fifsv.application_id=101 and
fifsv.id_flex_code='GL#'USSegment Delimiter2101=1:ledger=gl.nameLOVGL Ledger8E2FF36EDEB879D2E0530100007F1FF2Yselect
gl.name value,
fifsv.id_flex_structure_name||': '||decode(gl.ledger_category_code,'NONE',xxen_util.meaning(gl.object_type_code,'LEDGERS',101),xxen_util.meaning(gl.ledger_category_code,'GL_ASF_LEDGER_CATEGORY',101))||': '||gl.description description
from
gl_ledgers gl,
fnd_id_flex_structures_vl fifsv
where
(:$flex$.ledger_category is null or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y')) and
(:$flex$.chart_of_accounts is null or xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y') and
gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+)) and
gl.chart_of_accounts_id=fifsv.id_flex_num and
fifsv.id_flex_code='GL#' and
fifsv.application_id=101
order by
fifsv.id_flex_structure_name,
decode(gl.ledger_category_code,'PRIMARY',1,'SECONDARY',2,'ALC',3,'NONE',4),
gl.nameYUSLedger3201=1:upload_mode like '%' || xxen_upload.action_updateLOVBlitz Upload ModeE811F942597A2075E0530100007FF4F2Yselect xxen_upload.action_create id, xxen_upload.action_meaning(xxen_upload.action_create) value, null description from dual union all
select xxen_upload.action_create||','||xxen_upload.action_update id, xxen_upload.action_meaning(xxen_upload.action_create)||', '||xxen_upload.action_meaning(xxen_upload.action_update) value, null description from dualYUSUpload Mode4251=1gcck.enabled_flag='Y' and
trunc(sysdate) between nvl(gcck.start_date_active,trunc(sysdate)) and nvl(gcck.end_date_active,trunc(sysdate))LOVYes8E2FF36EDEA679D2E0530100007F1FF2Yselect 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dualUSActive Accounts Only5301=1gcck.segment1=:segment1LOVGL Segment18E2FF36EDECC79D2E0530100007F1FF2Yselect distinct
substrb(l.column_value,instrb(l.column_value,'~',1,1)+1,instrb(l.column_value,'~',1,2)-instrb(l.column_value,'~',1,1)-1) value,
substrb(l.column_value,instrb(l.column_value,'~',1,2)+1) description
from
(
select /*+ no_unnest*/ fifsv.id_flex_num
from fnd_id_flex_structures_vl fifsv
where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and
(
xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or
fifsv.id_flex_num in
(
select gl.chart_of_accounts_id from gl_ledgers gl where
(xxen_util.contains(:$flex$.ledger,gl.name)='Y' or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') and
gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+))
)
)
)
) s,
table(xxen_util.kff_segment_lov(
p_application_id=>101,
p_id_flex_code=>'GL#',
p_id_flex_num=>s.id_flex_num,
p_application_column_name=>'SEGMENT1',
p_enabled_only=>'N'
)) l
order by
1USGL_SEGMENT16401=1gcck.segment1>=:segment1_fromLOVGL Segment18E2FF36EDECC79D2E0530100007F1FF2Yselect distinct
substrb(l.column_value,instrb(l.column_value,'~',1,1)+1,instrb(l.column_value,'~',1,2)-instrb(l.column_value,'~',1,1)-1) value,
substrb(l.column_value,instrb(l.column_value,'~',1,2)+1) description
from
(
select /*+ no_unnest*/ fifsv.id_flex_num
from fnd_id_flex_structures_vl fifsv
where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and
(
xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or
fifsv.id_flex_num in
(
select gl.chart_of_accounts_id from gl_ledgers gl where
(xxen_util.contains(:$flex$.ledger,gl.name)='Y' or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') and
gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+))
)
)
)
) s,
table(xxen_util.kff_segment_lov(
p_application_id=>101,
p_id_flex_code=>'GL#',
p_id_flex_num=>s.id_flex_num,
p_application_column_name=>'SEGMENT1',
p_enabled_only=>'N'
)) l
order by
1USGL_SEGMENT1 From7501=1gcck.segment1<=:segment1_toLOVGL Segment18E2FF36EDECC79D2E0530100007F1FF2Yselect distinct
substrb(l.column_value,instrb(l.column_value,'~',1,1)+1,instrb(l.column_value,'~',1,2)-instrb(l.column_value,'~',1,1)-1) value,
substrb(l.column_value,instrb(l.column_value,'~',1,2)+1) description
from
(
select /*+ no_unnest*/ fifsv.id_flex_num
from fnd_id_flex_structures_vl fifsv
where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and
(
xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or
fifsv.id_flex_num in
(
select gl.chart_of_accounts_id from gl_ledgers gl where
(xxen_util.contains(:$flex$.ledger,gl.name)='Y' or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') and
gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+))
)
)
)
) s,
table(xxen_util.kff_segment_lov(
p_application_id=>101,
p_id_flex_code=>'GL#',
p_id_flex_num=>s.id_flex_num,
p_application_column_name=>'SEGMENT1',
p_enabled_only=>'N'
)) l
order by
1:$flex$.gl_segment1_fromUSGL_SEGMENT1 To8601=1gcck.segment2=:segment2LOVGL Segment28E2FF36EDECD79D2E0530100007F1FF2Yselect distinct
substrb(l.column_value,instrb(l.column_value,'~',1,1)+1,instrb(l.column_value,'~',1,2)-instrb(l.column_value,'~',1,1)-1) value,
substrb(l.column_value,instrb(l.column_value,'~',1,2)+1) description
from
(
select /*+ no_unnest*/ fifsv.id_flex_num
from fnd_id_flex_structures_vl fifsv
where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and
(
xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or
fifsv.id_flex_num in
(
select gl.chart_of_accounts_id from gl_ledgers gl where
(xxen_util.contains(:$flex$.ledger,gl.name)='Y' or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') and
gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+))
)
)
)
) s,
table(xxen_util.kff_segment_lov(
p_application_id=>101,
p_id_flex_code=>'GL#',
p_id_flex_num=>s.id_flex_num,
p_application_column_name=>'SEGMENT2',
p_enabled_only=>'N'
)) l
order by
1USGL_SEGMENT29701=1gcck.segment2>=:segment2_fromLOVGL Segment28E2FF36EDECD79D2E0530100007F1FF2Yselect distinct
substrb(l.column_value,instrb(l.column_value,'~',1,1)+1,instrb(l.column_value,'~',1,2)-instrb(l.column_value,'~',1,1)-1) value,
substrb(l.column_value,instrb(l.column_value,'~',1,2)+1) description
from
(
select /*+ no_unnest*/ fifsv.id_flex_num
from fnd_id_flex_structures_vl fifsv
where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and
(
xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or
fifsv.id_flex_num in
(
select gl.chart_of_accounts_id from gl_ledgers gl where
(xxen_util.contains(:$flex$.ledger,gl.name)='Y' or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') and
gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+))
)
)
)
) s,
table(xxen_util.kff_segment_lov(
p_application_id=>101,
p_id_flex_code=>'GL#',
p_id_flex_num=>s.id_flex_num,
p_application_column_name=>'SEGMENT2',
p_enabled_only=>'N'
)) l
order by
1USGL_SEGMENT2 From10801=1gcck.segment2<=:segment2_toLOVGL Segment28E2FF36EDECD79D2E0530100007F1FF2Yselect distinct
substrb(l.column_value,instrb(l.column_value,'~',1,1)+1,instrb(l.column_value,'~',1,2)-instrb(l.column_value,'~',1,1)-1) value,
substrb(l.column_value,instrb(l.column_value,'~',1,2)+1) description
from
(
select /*+ no_unnest*/ fifsv.id_flex_num
from fnd_id_flex_structures_vl fifsv
where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and
(
xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or
fifsv.id_flex_num in
(
select gl.chart_of_accounts_id from gl_ledgers gl where
(xxen_util.contains(:$flex$.ledger,gl.name)='Y' or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') and
gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+))
)
)
)
) s,
table(xxen_util.kff_segment_lov(
p_application_id=>101,
p_id_flex_code=>'GL#',
p_id_flex_num=>s.id_flex_num,
p_application_column_name=>'SEGMENT2',
p_enabled_only=>'N'
)) l
order by
1:$flex$.gl_segment2_fromUSGL_SEGMENT2 To11901=1gcck.segment3=:segment3LOVGL Segment38E2FF36EDECE79D2E0530100007F1FF2Yselect distinct
substrb(l.column_value,instrb(l.column_value,'~',1,1)+1,instrb(l.column_value,'~',1,2)-instrb(l.column_value,'~',1,1)-1) value,
substrb(l.column_value,instrb(l.column_value,'~',1,2)+1) description
from
(
select /*+ no_unnest*/ fifsv.id_flex_num
from fnd_id_flex_structures_vl fifsv
where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and
(
xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or
fifsv.id_flex_num in
(
select gl.chart_of_accounts_id from gl_ledgers gl where
(xxen_util.contains(:$flex$.ledger,gl.name)='Y' or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') and
gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+))
)
)
)
) s,
table(xxen_util.kff_segment_lov(
p_application_id=>101,
p_id_flex_code=>'GL#',
p_id_flex_num=>s.id_flex_num,
p_application_column_name=>'SEGMENT3',
p_enabled_only=>'N'
)) l
order by
1USGL_SEGMENT3121001=1gcck.segment3>=:segment3_fromLOVGL Segment38E2FF36EDECE79D2E0530100007F1FF2Yselect distinct
substrb(l.column_value,instrb(l.column_value,'~',1,1)+1,instrb(l.column_value,'~',1,2)-instrb(l.column_value,'~',1,1)-1) value,
substrb(l.column_value,instrb(l.column_value,'~',1,2)+1) description
from
(
select /*+ no_unnest*/ fifsv.id_flex_num
from fnd_id_flex_structures_vl fifsv
where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and
(
xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or
fifsv.id_flex_num in
(
select gl.chart_of_accounts_id from gl_ledgers gl where
(xxen_util.contains(:$flex$.ledger,gl.name)='Y' or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') and
gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+))
)
)
)
) s,
table(xxen_util.kff_segment_lov(
p_application_id=>101,
p_id_flex_code=>'GL#',
p_id_flex_num=>s.id_flex_num,
p_application_column_name=>'SEGMENT3',
p_enabled_only=>'N'
)) l
order by
1USGL_SEGMENT3 From131101=1gcck.segment3<=:segment3_toLOVGL Segment38E2FF36EDECE79D2E0530100007F1FF2Yselect distinct
substrb(l.column_value,instrb(l.column_value,'~',1,1)+1,instrb(l.column_value,'~',1,2)-instrb(l.column_value,'~',1,1)-1) value,
substrb(l.column_value,instrb(l.column_value,'~',1,2)+1) description
from
(
select /*+ no_unnest*/ fifsv.id_flex_num
from fnd_id_flex_structures_vl fifsv
where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and
(
xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or
fifsv.id_flex_num in
(
select gl.chart_of_accounts_id from gl_ledgers gl where
(xxen_util.contains(:$flex$.ledger,gl.name)='Y' or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') and
gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+))
)
)
)
) s,
table(xxen_util.kff_segment_lov(
p_application_id=>101,
p_id_flex_code=>'GL#',
p_id_flex_num=>s.id_flex_num,
p_application_column_name=>'SEGMENT3',
p_enabled_only=>'N'
)) l
order by
1:$flex$.gl_segment3_fromUSGL_SEGMENT3 To141201=1gcck.segment4=:segment4LOVGL Segment48E2FF36EDECF79D2E0530100007F1FF2Yselect distinct
substrb(l.column_value,instrb(l.column_value,'~',1,1)+1,instrb(l.column_value,'~',1,2)-instrb(l.column_value,'~',1,1)-1) value,
substrb(l.column_value,instrb(l.column_value,'~',1,2)+1) description
from
(
select /*+ no_unnest*/ fifsv.id_flex_num
from fnd_id_flex_structures_vl fifsv
where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and
(
xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or
fifsv.id_flex_num in
(
select gl.chart_of_accounts_id from gl_ledgers gl where
(xxen_util.contains(:$flex$.ledger,gl.name)='Y' or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') and
gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+))
)
)
)
) s,
table(xxen_util.kff_segment_lov(
p_application_id=>101,
p_id_flex_code=>'GL#',
p_id_flex_num=>s.id_flex_num,
p_application_column_name=>'SEGMENT4',
p_enabled_only=>'N'
)) l
order by
1USGL_SEGMENT4151301=1gcck.segment4>=:segment4_fromLOVGL Segment48E2FF36EDECF79D2E0530100007F1FF2Yselect distinct
substrb(l.column_value,instrb(l.column_value,'~',1,1)+1,instrb(l.column_value,'~',1,2)-instrb(l.column_value,'~',1,1)-1) value,
substrb(l.column_value,instrb(l.column_value,'~',1,2)+1) description
from
(
select /*+ no_unnest*/ fifsv.id_flex_num
from fnd_id_flex_structures_vl fifsv
where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and
(
xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or
fifsv.id_flex_num in
(
select gl.chart_of_accounts_id from gl_ledgers gl where
(xxen_util.contains(:$flex$.ledger,gl.name)='Y' or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') and
gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+))
)
)
)
) s,
table(xxen_util.kff_segment_lov(
p_application_id=>101,
p_id_flex_code=>'GL#',
p_id_flex_num=>s.id_flex_num,
p_application_column_name=>'SEGMENT4',
p_enabled_only=>'N'
)) l
order by
1USGL_SEGMENT4 From161401=1gcck.segment4<=:segment4_toLOVGL Segment48E2FF36EDECF79D2E0530100007F1FF2Yselect distinct
substrb(l.column_value,instrb(l.column_value,'~',1,1)+1,instrb(l.column_value,'~',1,2)-instrb(l.column_value,'~',1,1)-1) value,
substrb(l.column_value,instrb(l.column_value,'~',1,2)+1) description
from
(
select /*+ no_unnest*/ fifsv.id_flex_num
from fnd_id_flex_structures_vl fifsv
where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and
(
xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or
fifsv.id_flex_num in
(
select gl.chart_of_accounts_id from gl_ledgers gl where
(xxen_util.contains(:$flex$.ledger,gl.name)='Y' or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') and
gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+))
)
)
)
) s,
table(xxen_util.kff_segment_lov(
p_application_id=>101,
p_id_flex_code=>'GL#',
p_id_flex_num=>s.id_flex_num,
p_application_column_name=>'SEGMENT4',
p_enabled_only=>'N'
)) l
order by
1:$flex$.gl_segment4_fromUSGL_SEGMENT4 To171501=1gcck.segment5=:segment5LOVGL Segment58E2FF36EDED079D2E0530100007F1FF2Yselect distinct
substrb(l.column_value,instrb(l.column_value,'~',1,1)+1,instrb(l.column_value,'~',1,2)-instrb(l.column_value,'~',1,1)-1) value,
substrb(l.column_value,instrb(l.column_value,'~',1,2)+1) description
from
(
select /*+ no_unnest*/ fifsv.id_flex_num
from fnd_id_flex_structures_vl fifsv
where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and
(
xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or
fifsv.id_flex_num in
(
select gl.chart_of_accounts_id from gl_ledgers gl where
(xxen_util.contains(:$flex$.ledger,gl.name)='Y' or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') and
gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+))
)
)
)
) s,
table(xxen_util.kff_segment_lov(
p_application_id=>101,
p_id_flex_code=>'GL#',
p_id_flex_num=>s.id_flex_num,
p_application_column_name=>'SEGMENT5',
p_enabled_only=>'N'
)) l
order by
1USGL_SEGMENT5181601=1gcck.segment5>=:segment5_fromLOVGL Segment58E2FF36EDED079D2E0530100007F1FF2Yselect distinct
substrb(l.column_value,instrb(l.column_value,'~',1,1)+1,instrb(l.column_value,'~',1,2)-instrb(l.column_value,'~',1,1)-1) value,
substrb(l.column_value,instrb(l.column_value,'~',1,2)+1) description
from
(
select /*+ no_unnest*/ fifsv.id_flex_num
from fnd_id_flex_structures_vl fifsv
where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and
(
xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or
fifsv.id_flex_num in
(
select gl.chart_of_accounts_id from gl_ledgers gl where
(xxen_util.contains(:$flex$.ledger,gl.name)='Y' or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') and
gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+))
)
)
)
) s,
table(xxen_util.kff_segment_lov(
p_application_id=>101,
p_id_flex_code=>'GL#',
p_id_flex_num=>s.id_flex_num,
p_application_column_name=>'SEGMENT5',
p_enabled_only=>'N'
)) l
order by
1USGL_SEGMENT5 From191701=1gcck.segment5<=:segment5_toLOVGL Segment58E2FF36EDED079D2E0530100007F1FF2Yselect distinct
substrb(l.column_value,instrb(l.column_value,'~',1,1)+1,instrb(l.column_value,'~',1,2)-instrb(l.column_value,'~',1,1)-1) value,
substrb(l.column_value,instrb(l.column_value,'~',1,2)+1) description
from
(
select /*+ no_unnest*/ fifsv.id_flex_num
from fnd_id_flex_structures_vl fifsv
where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and
(
xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or
fifsv.id_flex_num in
(
select gl.chart_of_accounts_id from gl_ledgers gl where
(xxen_util.contains(:$flex$.ledger,gl.name)='Y' or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') and
gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+))
)
)
)
) s,
table(xxen_util.kff_segment_lov(
p_application_id=>101,
p_id_flex_code=>'GL#',
p_id_flex_num=>s.id_flex_num,
p_application_column_name=>'SEGMENT5',
p_enabled_only=>'N'
)) l
order by
1:$flex$.gl_segment5_fromUSGL_SEGMENT5 To201801=1gcck.segment6=:segment6LOVGL Segment68E2FF36EDED179D2E0530100007F1FF2Yselect distinct
substrb(l.column_value,instrb(l.column_value,'~',1,1)+1,instrb(l.column_value,'~',1,2)-instrb(l.column_value,'~',1,1)-1) value,
substrb(l.column_value,instrb(l.column_value,'~',1,2)+1) description
from
(
select /*+ no_unnest*/ fifsv.id_flex_num
from fnd_id_flex_structures_vl fifsv
where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and
(
xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or
fifsv.id_flex_num in
(
select gl.chart_of_accounts_id from gl_ledgers gl where
(xxen_util.contains(:$flex$.ledger,gl.name)='Y' or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') and
gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+))
)
)
)
) s,
table(xxen_util.kff_segment_lov(
p_application_id=>101,
p_id_flex_code=>'GL#',
p_id_flex_num=>s.id_flex_num,
p_application_column_name=>'SEGMENT6',
p_enabled_only=>'N'
)) l
order by
1USGL_SEGMENT6211901=1gcck.segment6>=:segment6_fromLOVGL Segment68E2FF36EDED179D2E0530100007F1FF2Yselect distinct
substrb(l.column_value,instrb(l.column_value,'~',1,1)+1,instrb(l.column_value,'~',1,2)-instrb(l.column_value,'~',1,1)-1) value,
substrb(l.column_value,instrb(l.column_value,'~',1,2)+1) description
from
(
select /*+ no_unnest*/ fifsv.id_flex_num
from fnd_id_flex_structures_vl fifsv
where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and
(
xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or
fifsv.id_flex_num in
(
select gl.chart_of_accounts_id from gl_ledgers gl where
(xxen_util.contains(:$flex$.ledger,gl.name)='Y' or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') and
gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+))
)
)
)
) s,
table(xxen_util.kff_segment_lov(
p_application_id=>101,
p_id_flex_code=>'GL#',
p_id_flex_num=>s.id_flex_num,
p_application_column_name=>'SEGMENT6',
p_enabled_only=>'N'
)) l
order by
1USGL_SEGMENT6 From222001=1gcck.segment6<=:segment6_toLOVGL Segment68E2FF36EDED179D2E0530100007F1FF2Yselect distinct
substrb(l.column_value,instrb(l.column_value,'~',1,1)+1,instrb(l.column_value,'~',1,2)-instrb(l.column_value,'~',1,1)-1) value,
substrb(l.column_value,instrb(l.column_value,'~',1,2)+1) description
from
(
select /*+ no_unnest*/ fifsv.id_flex_num
from fnd_id_flex_structures_vl fifsv
where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and
(
xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or
fifsv.id_flex_num in
(
select gl.chart_of_accounts_id from gl_ledgers gl where
(xxen_util.contains(:$flex$.ledger,gl.name)='Y' or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') and
gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+))
)
)
)
) s,
table(xxen_util.kff_segment_lov(
p_application_id=>101,
p_id_flex_code=>'GL#',
p_id_flex_num=>s.id_flex_num,
p_application_column_name=>'SEGMENT6',
p_enabled_only=>'N'
)) l
order by
1:$flex$.gl_segment6_fromUSGL_SEGMENT6 To232101=1gcck.segment7>=:segment7LOVGL Segment78E2FF36EDED279D2E0530100007F1FF2Yselect distinct
substrb(l.column_value,instrb(l.column_value,'~',1,1)+1,instrb(l.column_value,'~',1,2)-instrb(l.column_value,'~',1,1)-1) value,
substrb(l.column_value,instrb(l.column_value,'~',1,2)+1) description
from
(
select /*+ no_unnest*/ fifsv.id_flex_num
from fnd_id_flex_structures_vl fifsv
where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and
(
xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or
fifsv.id_flex_num in
(
select gl.chart_of_accounts_id from gl_ledgers gl where
(xxen_util.contains(:$flex$.ledger,gl.name)='Y' or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') and
gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+))
)
)
)
) s,
table(xxen_util.kff_segment_lov(
p_application_id=>101,
p_id_flex_code=>'GL#',
p_id_flex_num=>s.id_flex_num,
p_application_column_name=>'SEGMENT7',
p_enabled_only=>'N'
)) l
order by
1USGL_SEGMENT7242201=1gcck.segment7>=:segment7_fromLOVGL Segment78E2FF36EDED279D2E0530100007F1FF2Yselect distinct
substrb(l.column_value,instrb(l.column_value,'~',1,1)+1,instrb(l.column_value,'~',1,2)-instrb(l.column_value,'~',1,1)-1) value,
substrb(l.column_value,instrb(l.column_value,'~',1,2)+1) description
from
(
select /*+ no_unnest*/ fifsv.id_flex_num
from fnd_id_flex_structures_vl fifsv
where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and
(
xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or
fifsv.id_flex_num in
(
select gl.chart_of_accounts_id from gl_ledgers gl where
(xxen_util.contains(:$flex$.ledger,gl.name)='Y' or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') and
gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+))
)
)
)
) s,
table(xxen_util.kff_segment_lov(
p_application_id=>101,
p_id_flex_code=>'GL#',
p_id_flex_num=>s.id_flex_num,
p_application_column_name=>'SEGMENT7',
p_enabled_only=>'N'
)) l
order by
1USGL_SEGMENT7 From252301=1gcck.segment7<=:segment7_toLOVGL Segment78E2FF36EDED279D2E0530100007F1FF2Yselect distinct
substrb(l.column_value,instrb(l.column_value,'~',1,1)+1,instrb(l.column_value,'~',1,2)-instrb(l.column_value,'~',1,1)-1) value,
substrb(l.column_value,instrb(l.column_value,'~',1,2)+1) description
from
(
select /*+ no_unnest*/ fifsv.id_flex_num
from fnd_id_flex_structures_vl fifsv
where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and
(
xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or
fifsv.id_flex_num in
(
select gl.chart_of_accounts_id from gl_ledgers gl where
(xxen_util.contains(:$flex$.ledger,gl.name)='Y' or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') and
gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+))
)
)
)
) s,
table(xxen_util.kff_segment_lov(
p_application_id=>101,
p_id_flex_code=>'GL#',
p_id_flex_num=>s.id_flex_num,
p_application_column_name=>'SEGMENT7',
p_enabled_only=>'N'
)) l
order by
1:$flex$.gl_segment7_fromUSGL_SEGMENT7 To262401=1gcck.segment8=:segment8LOVGL Segment8B3D07BBAC1A245D7E0530100007FB1B8Yselect distinct
substrb(l.column_value,instrb(l.column_value,'~',1,1)+1,instrb(l.column_value,'~',1,2)-instrb(l.column_value,'~',1,1)-1) value,
substrb(l.column_value,instrb(l.column_value,'~',1,2)+1) description
from
(
select /*+ no_unnest*/ fifsv.id_flex_num
from fnd_id_flex_structures_vl fifsv
where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and
(
xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or
fifsv.id_flex_num in
(
select gl.chart_of_accounts_id from gl_ledgers gl where
(xxen_util.contains(:$flex$.ledger,gl.name)='Y' or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') and
gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+))
)
)
)
) s,
table(xxen_util.kff_segment_lov(
p_application_id=>101,
p_id_flex_code=>'GL#',
p_id_flex_num=>s.id_flex_num,
p_application_column_name=>'SEGMENT8',
p_enabled_only=>'N'
)) l
order by
1USGL_SEGMENT8272501=1gcck.segment8>=:segment8_fromLOVGL Segment8B3D07BBAC1A245D7E0530100007FB1B8Yselect distinct
substrb(l.column_value,instrb(l.column_value,'~',1,1)+1,instrb(l.column_value,'~',1,2)-instrb(l.column_value,'~',1,1)-1) value,
substrb(l.column_value,instrb(l.column_value,'~',1,2)+1) description
from
(
select /*+ no_unnest*/ fifsv.id_flex_num
from fnd_id_flex_structures_vl fifsv
where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and
(
xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or
fifsv.id_flex_num in
(
select gl.chart_of_accounts_id from gl_ledgers gl where
(xxen_util.contains(:$flex$.ledger,gl.name)='Y' or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') and
gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+))
)
)
)
) s,
table(xxen_util.kff_segment_lov(
p_application_id=>101,
p_id_flex_code=>'GL#',
p_id_flex_num=>s.id_flex_num,
p_application_column_name=>'SEGMENT8',
p_enabled_only=>'N'
)) l
order by
1USGL_SEGMENT8 From282601=1gcck.segment8<=:segment8_toLOVGL Segment8B3D07BBAC1A245D7E0530100007FB1B8Yselect distinct
substrb(l.column_value,instrb(l.column_value,'~',1,1)+1,instrb(l.column_value,'~',1,2)-instrb(l.column_value,'~',1,1)-1) value,
substrb(l.column_value,instrb(l.column_value,'~',1,2)+1) description
from
(
select /*+ no_unnest*/ fifsv.id_flex_num
from fnd_id_flex_structures_vl fifsv
where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and
(
xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or
fifsv.id_flex_num in
(
select gl.chart_of_accounts_id from gl_ledgers gl where
(xxen_util.contains(:$flex$.ledger,gl.name)='Y' or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') and
gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+))
)
)
)
) s,
table(xxen_util.kff_segment_lov(
p_application_id=>101,
p_id_flex_code=>'GL#',
p_id_flex_num=>s.id_flex_num,
p_application_column_name=>'SEGMENT8',
p_enabled_only=>'N'
)) l
order by
1:$flex$.gl_segment8_fromUSGL_SEGMENT8 To292701=1gcck.segment9=:segment9LOVGL Segment9B3D07BBAC1A545D7E0530100007FB1B8Yselect distinct
substrb(l.column_value,instrb(l.column_value,'~',1,1)+1,instrb(l.column_value,'~',1,2)-instrb(l.column_value,'~',1,1)-1) value,
substrb(l.column_value,instrb(l.column_value,'~',1,2)+1) description
from
(
select /*+ no_unnest*/ fifsv.id_flex_num
from fnd_id_flex_structures_vl fifsv
where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and
(
xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or
fifsv.id_flex_num in
(
select gl.chart_of_accounts_id from gl_ledgers gl where
(xxen_util.contains(:$flex$.ledger,gl.name)='Y' or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') and
gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+))
)
)
)
) s,
table(xxen_util.kff_segment_lov(
p_application_id=>101,
p_id_flex_code=>'GL#',
p_id_flex_num=>s.id_flex_num,
p_application_column_name=>'SEGMENT9',
p_enabled_only=>'N'
)) l
order by
1USGL_SEGMENT9302801=1gcck.segment9>=:segment9_fromLOVGL Segment9B3D07BBAC1A545D7E0530100007FB1B8Yselect distinct
substrb(l.column_value,instrb(l.column_value,'~',1,1)+1,instrb(l.column_value,'~',1,2)-instrb(l.column_value,'~',1,1)-1) value,
substrb(l.column_value,instrb(l.column_value,'~',1,2)+1) description
from
(
select /*+ no_unnest*/ fifsv.id_flex_num
from fnd_id_flex_structures_vl fifsv
where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and
(
xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or
fifsv.id_flex_num in
(
select gl.chart_of_accounts_id from gl_ledgers gl where
(xxen_util.contains(:$flex$.ledger,gl.name)='Y' or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') and
gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+))
)
)
)
) s,
table(xxen_util.kff_segment_lov(
p_application_id=>101,
p_id_flex_code=>'GL#',
p_id_flex_num=>s.id_flex_num,
p_application_column_name=>'SEGMENT9',
p_enabled_only=>'N'
)) l
order by
1USGL_SEGMENT9 From312901=1gcck.segment9<=:segment9_toLOVGL Segment9B3D07BBAC1A545D7E0530100007FB1B8Yselect distinct
substrb(l.column_value,instrb(l.column_value,'~',1,1)+1,instrb(l.column_value,'~',1,2)-instrb(l.column_value,'~',1,1)-1) value,
substrb(l.column_value,instrb(l.column_value,'~',1,2)+1) description
from
(
select /*+ no_unnest*/ fifsv.id_flex_num
from fnd_id_flex_structures_vl fifsv
where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and
(
xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or
fifsv.id_flex_num in
(
select gl.chart_of_accounts_id from gl_ledgers gl where
(xxen_util.contains(:$flex$.ledger,gl.name)='Y' or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') and
gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+))
)
)
)
) s,
table(xxen_util.kff_segment_lov(
p_application_id=>101,
p_id_flex_code=>'GL#',
p_id_flex_num=>s.id_flex_num,
p_application_column_name=>'SEGMENT9',
p_enabled_only=>'N'
)) l
order by
1:$flex$.gl_segment9_fromUSGL_SEGMENT9 To323001=1gcck.segment10=:segment10LOVGL Segment10B3D07BBAC1A645D7E0530100007FB1B8Yselect distinct
substrb(l.column_value,instrb(l.column_value,'~',1,1)+1,instrb(l.column_value,'~',1,2)-instrb(l.column_value,'~',1,1)-1) value,
substrb(l.column_value,instrb(l.column_value,'~',1,2)+1) description
from
(
select /*+ no_unnest*/ fifsv.id_flex_num
from fnd_id_flex_structures_vl fifsv
where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and
(
xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or
fifsv.id_flex_num in
(
select gl.chart_of_accounts_id from gl_ledgers gl where
(xxen_util.contains(:$flex$.ledger,gl.name)='Y' or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') and
gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+))
)
)
)
) s,
table(xxen_util.kff_segment_lov(
p_application_id=>101,
p_id_flex_code=>'GL#',
p_id_flex_num=>s.id_flex_num,
p_application_column_name=>'SEGMENT10',
p_enabled_only=>'N'
)) l
order by
1USGL_SEGMENT10333101=1gcck.segment10>=:segment10_fromLOVGL Segment10B3D07BBAC1A645D7E0530100007FB1B8Yselect distinct
substrb(l.column_value,instrb(l.column_value,'~',1,1)+1,instrb(l.column_value,'~',1,2)-instrb(l.column_value,'~',1,1)-1) value,
substrb(l.column_value,instrb(l.column_value,'~',1,2)+1) description
from
(
select /*+ no_unnest*/ fifsv.id_flex_num
from fnd_id_flex_structures_vl fifsv
where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and
(
xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or
fifsv.id_flex_num in
(
select gl.chart_of_accounts_id from gl_ledgers gl where
(xxen_util.contains(:$flex$.ledger,gl.name)='Y' or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') and
gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+))
)
)
)
) s,
table(xxen_util.kff_segment_lov(
p_application_id=>101,
p_id_flex_code=>'GL#',
p_id_flex_num=>s.id_flex_num,
p_application_column_name=>'SEGMENT10',
p_enabled_only=>'N'
)) l
order by
1USGL_SEGMENT10 From343201=1gcck.segment10<=:segment10_toLOVGL Segment10B3D07BBAC1A645D7E0530100007FB1B8Yselect distinct
substrb(l.column_value,instrb(l.column_value,'~',1,1)+1,instrb(l.column_value,'~',1,2)-instrb(l.column_value,'~',1,1)-1) value,
substrb(l.column_value,instrb(l.column_value,'~',1,2)+1) description
from
(
select /*+ no_unnest*/ fifsv.id_flex_num
from fnd_id_flex_structures_vl fifsv
where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and
(
xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or
fifsv.id_flex_num in
(
select gl.chart_of_accounts_id from gl_ledgers gl where
(xxen_util.contains(:$flex$.ledger,gl.name)='Y' or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') and
gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+))
)
)
)
) s,
table(xxen_util.kff_segment_lov(
p_application_id=>101,
p_id_flex_code=>'GL#',
p_id_flex_num=>s.id_flex_num,
p_application_column_name=>'SEGMENT10',
p_enabled_only=>'N'
)) l
order by
1:$flex$.gl_segment10_fromUSGL_SEGMENT10 To353301=1gcck.segment11>=:segment11_fromLOVGL Segment113CF0AFFEDB407EB4E0630100007F9A70Yselect distinct
substrb(l.column_value,instrb(l.column_value,'~',1,1)+1,instrb(l.column_value,'~',1,2)-instrb(l.column_value,'~',1,1)-1) value,
substrb(l.column_value,instrb(l.column_value,'~',1,2)+1) description
from
(
select /*+ no_unnest*/ fifsv.id_flex_num
from fnd_id_flex_structures_vl fifsv
where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and
(
xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or
fifsv.id_flex_num in
(
select gl.chart_of_accounts_id from gl_ledgers gl where
(xxen_util.contains(:$flex$.ledger,gl.name)='Y' or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') and
gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+))
)
)
)
) s,
table(xxen_util.kff_segment_lov(
p_application_id=>101,
p_id_flex_code=>'GL#',
p_id_flex_num=>s.id_flex_num,
p_application_column_name=>'SEGMENT11',
p_enabled_only=>'N'
)) l
order by
1USGL_SEGMENT11 From363401=1gcck.segment11<=:segment11_toLOVGL Segment113CF0AFFEDB407EB4E0630100007F9A70Yselect distinct
substrb(l.column_value,instrb(l.column_value,'~',1,1)+1,instrb(l.column_value,'~',1,2)-instrb(l.column_value,'~',1,1)-1) value,
substrb(l.column_value,instrb(l.column_value,'~',1,2)+1) description
from
(
select /*+ no_unnest*/ fifsv.id_flex_num
from fnd_id_flex_structures_vl fifsv
where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and
(
xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or
fifsv.id_flex_num in
(
select gl.chart_of_accounts_id from gl_ledgers gl where
(xxen_util.contains(:$flex$.ledger,gl.name)='Y' or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') and
gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+))
)
)
)
) s,
table(xxen_util.kff_segment_lov(
p_application_id=>101,
p_id_flex_code=>'GL#',
p_id_flex_num=>s.id_flex_num,
p_application_column_name=>'SEGMENT11',
p_enabled_only=>'N'
)) l
order by
1:$flex$.gl_segment11_fromUSGL_SEGMENT11 To373501=1gcck.segment12>=:segment12_fromLOVGL Segment123CF0AFFEDB417EB4E0630100007F9A70Yselect distinct
substrb(l.column_value,instrb(l.column_value,'~',1,1)+1,instrb(l.column_value,'~',1,2)-instrb(l.column_value,'~',1,1)-1) value,
substrb(l.column_value,instrb(l.column_value,'~',1,2)+1) description
from
(
select /*+ no_unnest*/ fifsv.id_flex_num
from fnd_id_flex_structures_vl fifsv
where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and
(
xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or
fifsv.id_flex_num in
(
select gl.chart_of_accounts_id from gl_ledgers gl where
(xxen_util.contains(:$flex$.ledger,gl.name)='Y' or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') and
gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+))
)
)
)
) s,
table(xxen_util.kff_segment_lov(
p_application_id=>101,
p_id_flex_code=>'GL#',
p_id_flex_num=>s.id_flex_num,
p_application_column_name=>'SEGMENT12',
p_enabled_only=>'N'
)) l
order by
1USGL_SEGMENT12 From383601=1gcck.segment12<=:segment12_toLOVGL Segment123CF0AFFEDB417EB4E0630100007F9A70Yselect distinct
substrb(l.column_value,instrb(l.column_value,'~',1,1)+1,instrb(l.column_value,'~',1,2)-instrb(l.column_value,'~',1,1)-1) value,
substrb(l.column_value,instrb(l.column_value,'~',1,2)+1) description
from
(
select /*+ no_unnest*/ fifsv.id_flex_num
from fnd_id_flex_structures_vl fifsv
where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and
(
xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or
fifsv.id_flex_num in
(
select gl.chart_of_accounts_id from gl_ledgers gl where
(xxen_util.contains(:$flex$.ledger,gl.name)='Y' or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') and
gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+))
)
)
)
) s,
table(xxen_util.kff_segment_lov(
p_application_id=>101,
p_id_flex_code=>'GL#',
p_id_flex_num=>s.id_flex_num,
p_application_column_name=>'SEGMENT12',
p_enabled_only=>'N'
)) l
order by
1:$flex$.gl_segment12_fromUSGL_SEGMENT12 To1ACTION_Charvarchar22STATUS_Charvarchar23MESSAGE_Charvarchar24MODIFIED_COLUMNS_Charvarchar2Y5LEDGERCharvarchar230:$flex$.ledgerY6CONCATENATED_SEGMENTSCharvarchar2311Enter the concatenated segments delimited by segments delimiter which will be auto populated into the individual segments7DESCRIPTIONCharvarchar2with flex_values as
(
select distinct
ffvv.flex_value,
ffvv.description,
fifsgv.application_column_name
from
fnd_id_flex_segments_vl fifsgv,
fnd_flex_values_vl ffvv,
gl_ledgers gl
where
fifsgv.application_id=101 and
gl.name=:$flex$.ledger and
fifsgv.id_flex_code='GL#' and
fifsgv.enabled_flag='Y' and
fifsgv.flex_value_set_id=ffvv.flex_value_set_id and
ffvv.enabled_flag='Y' and
sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) and
fifsgv.id_flex_num=gl.chart_of_accounts_id
)
select
trim(trailing :$flex$.segment_delimiter from trim( leading :$flex$.segment_delimiter from
(select case when fv.flex_value is not null then fv.description||:$flex$.segment_delimiter end from flex_values fv where fv.application_column_name='SEGMENT1' and fv.flex_value=xxen_util.instring(:$column$.concatenated_segments,:$flex$.segment_delimiter,1))||
(select case when fv.flex_value is not null then fv.description||:$flex$.segment_delimiter end from flex_values fv where fv.application_column_name='SEGMENT2' and fv.flex_value=xxen_util.instring(:$column$.concatenated_segments,:$flex$.segment_delimiter,2))||
(select case when fv.flex_value is not null then fv.description||:$flex$.segment_delimiter end from flex_values fv where fv.application_column_name='SEGMENT3' and fv.flex_value=xxen_util.instring(:$column$.concatenated_segments,:$flex$.segment_delimiter,3))||
(select case when fv.flex_value is not null then fv.description||:$flex$.segment_delimiter end from flex_values fv where fv.application_column_name='SEGMENT4' and fv.flex_value=xxen_util.instring(:$column$.concatenated_segments,:$flex$.segment_delimiter,4))||
(select case when fv.flex_value is not null then fv.description||:$flex$.segment_delimiter end from flex_values fv where fv.application_column_name='SEGMENT5' and fv.flex_value=xxen_util.instring(:$column$.concatenated_segments,:$flex$.segment_delimiter,5))||
(select case when fv.flex_value is not null then fv.description||:$flex$.segment_delimiter end from flex_values fv where fv.application_column_name='SEGMENT6' and fv.flex_value=xxen_util.instring(:$column$.concatenated_segments,:$flex$.segment_delimiter,6))||
(select case when fv.flex_value is not null then fv.description||:$flex$.segment_delimiter end from flex_values fv where fv.application_column_name='SEGMENT7' and fv.flex_value=xxen_util.instring(:$column$.concatenated_segments,:$flex$.segment_delimiter,7))||
(select case when fv.flex_value is not null then fv.description||:$flex$.segment_delimiter end from flex_values fv where fv.application_column_name='SEGMENT8' and fv.flex_value=xxen_util.instring(:$column$.concatenated_segments,:$flex$.segment_delimiter,8))||
(select case when fv.flex_value is not null then fv.description||:$flex$.segment_delimiter end from flex_values fv where fv.application_column_name='SEGMENT9' and fv.flex_value=xxen_util.instring(:$column$.concatenated_segments,:$flex$.segment_delimiter,9))||
(select case when fv.flex_value is not null then fv.description||:$flex$.segment_delimiter end from flex_values fv where fv.application_column_name='SEGMENT10' and fv.flex_value=xxen_util.instring(:$column$.concatenated_segments,:$flex$.segment_delimiter,10))))
from dualAuto populated on entering the Concatenated Segments8ACCOUNT_TYPECharvarchar2240Derived during account creation, non-updateable9GL_SEGMENT1LOV customvarchar225Yselect distinct
substrb(l.column_value,instrb(l.column_value,'~',1,1)+1,instrb(l.column_value,'~',1,2)-instrb(l.column_value,'~',1,1)-1) value,
substrb(l.column_value,instrb(l.column_value,'~',1,2)+1) description
from
(
select fifsv.id_flex_num from fnd_id_flex_structures_vl fifsv
where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and
(
xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or
fifsv.id_flex_num in
(
select gl.chart_of_accounts_id from gl_ledgers gl where
(xxen_util.contains(:$flex$.ledger,gl.name)='Y' or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') and
gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+))
)
)
)
) s,
table(xxen_util.kff_segment_lov(
p_application_id=>101,
p_id_flex_code=>'GL#',
p_id_flex_num=>s.id_flex_num,
p_application_column_name=>'SEGMENT1',
p_segment1=>:$column$.gl_segment1,
p_segment2=>:$column$.gl_segment2,
p_segment3=>:$column$.gl_segment3,
p_segment4=>:$column$.gl_segment4,
p_segment5=>:$column$.gl_segment5,
p_segment6=>:$column$.gl_segment6,
p_segment7=>:$column$.gl_segment7,
p_segment8=>:$column$.gl_segment8,
p_segment9=>:$column$.gl_segment9,
p_segment10=>:$column$.gl_segment10,
p_segment11=>:$column$.gl_segment11,
p_segment12=>:$column$.gl_segment12,
p_segment13=>:$column$.gl_segment13,
p_segment14=>:$column$.gl_segment14,
p_segment15=>:$column$.gl_segment15
)) l
order by
1xxen_util.instring(:$column$.concatenated_segments,:$flex$.segment_delimiter,1)Y10GL_SEGMENT2LOV customvarchar225Yselect distinct
substrb(l.column_value,instrb(l.column_value,'~',1,1)+1,instrb(l.column_value,'~',1,2)-instrb(l.column_value,'~',1,1)-1) value,
substrb(l.column_value,instrb(l.column_value,'~',1,2)+1) description
from
(
select fifsv.id_flex_num from fnd_id_flex_structures_vl fifsv
where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and
(
xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or
fifsv.id_flex_num in
(
select gl.chart_of_accounts_id from gl_ledgers gl where
(xxen_util.contains(:$flex$.ledger,gl.name)='Y' or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') and
gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+))
)
)
)
) s,
table(xxen_util.kff_segment_lov(
p_application_id=>101,
p_id_flex_code=>'GL#',
p_id_flex_num=>s.id_flex_num,
p_application_column_name=>'SEGMENT2',
p_segment1=>:$column$.gl_segment1,
p_segment2=>:$column$.gl_segment2,
p_segment3=>:$column$.gl_segment3,
p_segment4=>:$column$.gl_segment4,
p_segment5=>:$column$.gl_segment5,
p_segment6=>:$column$.gl_segment6,
p_segment7=>:$column$.gl_segment7,
p_segment8=>:$column$.gl_segment8,
p_segment9=>:$column$.gl_segment9,
p_segment10=>:$column$.gl_segment10,
p_segment11=>:$column$.gl_segment11,
p_segment12=>:$column$.gl_segment12,
p_segment13=>:$column$.gl_segment13,
p_segment14=>:$column$.gl_segment14,
p_segment15=>:$column$.gl_segment15
)) l
order by
1xxen_util.instring(:$column$.concatenated_segments,:$flex$.segment_delimiter,2)Y11GL_SEGMENT3LOV customvarchar225Yselect distinct
substrb(l.column_value,instrb(l.column_value,'~',1,1)+1,instrb(l.column_value,'~',1,2)-instrb(l.column_value,'~',1,1)-1) value,
substrb(l.column_value,instrb(l.column_value,'~',1,2)+1) description
from
(
select fifsv.id_flex_num from fnd_id_flex_structures_vl fifsv
where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and
(
xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or
fifsv.id_flex_num in
(
select gl.chart_of_accounts_id from gl_ledgers gl where
(xxen_util.contains(:$flex$.ledger,gl.name)='Y' or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') and
gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+))
)
)
)
) s,
table(xxen_util.kff_segment_lov(
p_application_id=>101,
p_id_flex_code=>'GL#',
p_id_flex_num=>s.id_flex_num,
p_application_column_name=>'SEGMENT3',
p_segment1=>:$column$.gl_segment1,
p_segment2=>:$column$.gl_segment2,
p_segment3=>:$column$.gl_segment3,
p_segment4=>:$column$.gl_segment4,
p_segment5=>:$column$.gl_segment5,
p_segment6=>:$column$.gl_segment6,
p_segment7=>:$column$.gl_segment7,
p_segment8=>:$column$.gl_segment8,
p_segment9=>:$column$.gl_segment9,
p_segment10=>:$column$.gl_segment10,
p_segment11=>:$column$.gl_segment11,
p_segment12=>:$column$.gl_segment12,
p_segment13=>:$column$.gl_segment13,
p_segment14=>:$column$.gl_segment14,
p_segment15=>:$column$.gl_segment15
)) l
order by
1xxen_util.instring(:$column$.concatenated_segments,:$flex$.segment_delimiter,3)Y12GL_SEGMENT4LOV customvarchar225Yselect distinct
substrb(l.column_value,instrb(l.column_value,'~',1,1)+1,instrb(l.column_value,'~',1,2)-instrb(l.column_value,'~',1,1)-1) value,
substrb(l.column_value,instrb(l.column_value,'~',1,2)+1) description
from
(
select fifsv.id_flex_num from fnd_id_flex_structures_vl fifsv
where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and
(
xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or
fifsv.id_flex_num in
(
select gl.chart_of_accounts_id from gl_ledgers gl where
(xxen_util.contains(:$flex$.ledger,gl.name)='Y' or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') and
gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+))
)
)
)
) s,
table(xxen_util.kff_segment_lov(
p_application_id=>101,
p_id_flex_code=>'GL#',
p_id_flex_num=>s.id_flex_num,
p_application_column_name=>'SEGMENT4',
p_segment1=>:$column$.gl_segment1,
p_segment2=>:$column$.gl_segment2,
p_segment3=>:$column$.gl_segment3,
p_segment4=>:$column$.gl_segment4,
p_segment5=>:$column$.gl_segment5,
p_segment6=>:$column$.gl_segment6,
p_segment7=>:$column$.gl_segment7,
p_segment8=>:$column$.gl_segment8,
p_segment9=>:$column$.gl_segment9,
p_segment10=>:$column$.gl_segment10,
p_segment11=>:$column$.gl_segment11,
p_segment12=>:$column$.gl_segment12,
p_segment13=>:$column$.gl_segment13,
p_segment14=>:$column$.gl_segment14,
p_segment15=>:$column$.gl_segment15
)) l
order by
1xxen_util.instring(:$column$.concatenated_segments,:$flex$.segment_delimiter,4)Y13GL_SEGMENT5LOV customvarchar225Yselect distinct
substrb(l.column_value,instrb(l.column_value,'~',1,1)+1,instrb(l.column_value,'~',1,2)-instrb(l.column_value,'~',1,1)-1) value,
substrb(l.column_value,instrb(l.column_value,'~',1,2)+1) description
from
(
select fifsv.id_flex_num from fnd_id_flex_structures_vl fifsv
where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and
(
xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or
fifsv.id_flex_num in
(
select gl.chart_of_accounts_id from gl_ledgers gl where
(xxen_util.contains(:$flex$.ledger,gl.name)='Y' or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') and
gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+))
)
)
)
) s,
table(xxen_util.kff_segment_lov(
p_application_id=>101,
p_id_flex_code=>'GL#',
p_id_flex_num=>s.id_flex_num,
p_application_column_name=>'SEGMENT5',
p_segment1=>:$column$.gl_segment1,
p_segment2=>:$column$.gl_segment2,
p_segment3=>:$column$.gl_segment3,
p_segment4=>:$column$.gl_segment4,
p_segment5=>:$column$.gl_segment5,
p_segment6=>:$column$.gl_segment6,
p_segment7=>:$column$.gl_segment7,
p_segment8=>:$column$.gl_segment8,
p_segment9=>:$column$.gl_segment9,
p_segment10=>:$column$.gl_segment10,
p_segment11=>:$column$.gl_segment11,
p_segment12=>:$column$.gl_segment12,
p_segment13=>:$column$.gl_segment13,
p_segment14=>:$column$.gl_segment14,
p_segment15=>:$column$.gl_segment15
)) l
order by
1xxen_util.instring(:$column$.concatenated_segments,:$flex$.segment_delimiter,5)Y14GL_SEGMENT6LOV customvarchar225Yselect distinct
substrb(l.column_value,instrb(l.column_value,'~',1,1)+1,instrb(l.column_value,'~',1,2)-instrb(l.column_value,'~',1,1)-1) value,
substrb(l.column_value,instrb(l.column_value,'~',1,2)+1) description
from
(
select fifsv.id_flex_num from fnd_id_flex_structures_vl fifsv
where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and
(
xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or
fifsv.id_flex_num in
(
select gl.chart_of_accounts_id from gl_ledgers gl where
(xxen_util.contains(:$flex$.ledger,gl.name)='Y' or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') and
gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+))
)
)
)
) s,
table(xxen_util.kff_segment_lov(
p_application_id=>101,
p_id_flex_code=>'GL#',
p_id_flex_num=>s.id_flex_num,
p_application_column_name=>'SEGMENT6',
p_segment1=>:$column$.gl_segment1,
p_segment2=>:$column$.gl_segment2,
p_segment3=>:$column$.gl_segment3,
p_segment4=>:$column$.gl_segment4,
p_segment5=>:$column$.gl_segment5,
p_segment6=>:$column$.gl_segment6,
p_segment7=>:$column$.gl_segment7,
p_segment8=>:$column$.gl_segment8,
p_segment9=>:$column$.gl_segment9,
p_segment10=>:$column$.gl_segment10,
p_segment11=>:$column$.gl_segment11,
p_segment12=>:$column$.gl_segment12,
p_segment13=>:$column$.gl_segment13,
p_segment14=>:$column$.gl_segment14,
p_segment15=>:$column$.gl_segment15
)) l
order by
1xxen_util.instring(:$column$.concatenated_segments,:$flex$.segment_delimiter,6)Y15GL_SEGMENT7LOV customvarchar225Yselect distinct
substrb(l.column_value,instrb(l.column_value,'~',1,1)+1,instrb(l.column_value,'~',1,2)-instrb(l.column_value,'~',1,1)-1) value,
substrb(l.column_value,instrb(l.column_value,'~',1,2)+1) description
from
(
select fifsv.id_flex_num from fnd_id_flex_structures_vl fifsv
where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and
(
xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or
fifsv.id_flex_num in
(
select gl.chart_of_accounts_id from gl_ledgers gl where
(xxen_util.contains(:$flex$.ledger,gl.name)='Y' or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') and
gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+))
)
)
)
) s,
table(xxen_util.kff_segment_lov(
p_application_id=>101,
p_id_flex_code=>'GL#',
p_id_flex_num=>s.id_flex_num,
p_application_column_name=>'SEGMENT7',
p_segment1=>:$column$.gl_segment1,
p_segment2=>:$column$.gl_segment2,
p_segment3=>:$column$.gl_segment3,
p_segment4=>:$column$.gl_segment4,
p_segment5=>:$column$.gl_segment5,
p_segment6=>:$column$.gl_segment6,
p_segment7=>:$column$.gl_segment7,
p_segment8=>:$column$.gl_segment8,
p_segment9=>:$column$.gl_segment9,
p_segment10=>:$column$.gl_segment10,
p_segment11=>:$column$.gl_segment11,
p_segment12=>:$column$.gl_segment12,
p_segment13=>:$column$.gl_segment13,
p_segment14=>:$column$.gl_segment14,
p_segment15=>:$column$.gl_segment15
)) l
order by
1xxen_util.instring(:$column$.concatenated_segments,:$flex$.segment_delimiter,7)Y16GL_SEGMENT8LOV customvarchar225Yselect distinct
substrb(l.column_value,instrb(l.column_value,'~',1,1)+1,instrb(l.column_value,'~',1,2)-instrb(l.column_value,'~',1,1)-1) value,
substrb(l.column_value,instrb(l.column_value,'~',1,2)+1) description
from
(
select fifsv.id_flex_num from fnd_id_flex_structures_vl fifsv
where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and
(
xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or
fifsv.id_flex_num in
(
select gl.chart_of_accounts_id from gl_ledgers gl where
(xxen_util.contains(:$flex$.ledger,gl.name)='Y' or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') and
gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+))
)
)
)
) s,
table(xxen_util.kff_segment_lov(
p_application_id=>101,
p_id_flex_code=>'GL#',
p_id_flex_num=>s.id_flex_num,
p_application_column_name=>'SEGMENT8',
p_segment1=>:$column$.gl_segment1,
p_segment2=>:$column$.gl_segment2,
p_segment3=>:$column$.gl_segment3,
p_segment4=>:$column$.gl_segment4,
p_segment5=>:$column$.gl_segment5,
p_segment6=>:$column$.gl_segment6,
p_segment7=>:$column$.gl_segment7,
p_segment8=>:$column$.gl_segment8,
p_segment9=>:$column$.gl_segment9,
p_segment10=>:$column$.gl_segment10,
p_segment11=>:$column$.gl_segment11,
p_segment12=>:$column$.gl_segment12,
p_segment13=>:$column$.gl_segment13,
p_segment14=>:$column$.gl_segment14,
p_segment15=>:$column$.gl_segment15
)) l
order by
1xxen_util.instring(:$column$.concatenated_segments,:$flex$.segment_delimiter,8)Y17GL_SEGMENT9LOV customvarchar225Yselect distinct
substrb(l.column_value,instrb(l.column_value,'~',1,1)+1,instrb(l.column_value,'~',1,2)-instrb(l.column_value,'~',1,1)-1) value,
substrb(l.column_value,instrb(l.column_value,'~',1,2)+1) description
from
(
select fifsv.id_flex_num from fnd_id_flex_structures_vl fifsv
where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and
(
xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or
fifsv.id_flex_num in
(
select gl.chart_of_accounts_id from gl_ledgers gl where
(xxen_util.contains(:$flex$.ledger,gl.name)='Y' or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') and
gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+))
)
)
)
) s,
table(xxen_util.kff_segment_lov(
p_application_id=>101,
p_id_flex_code=>'GL#',
p_id_flex_num=>s.id_flex_num,
p_application_column_name=>'SEGMENT9',
p_segment1=>:$column$.gl_segment1,
p_segment2=>:$column$.gl_segment2,
p_segment3=>:$column$.gl_segment3,
p_segment4=>:$column$.gl_segment4,
p_segment5=>:$column$.gl_segment5,
p_segment6=>:$column$.gl_segment6,
p_segment7=>:$column$.gl_segment7,
p_segment8=>:$column$.gl_segment8,
p_segment9=>:$column$.gl_segment9,
p_segment10=>:$column$.gl_segment10,
p_segment11=>:$column$.gl_segment11,
p_segment12=>:$column$.gl_segment12,
p_segment13=>:$column$.gl_segment13,
p_segment14=>:$column$.gl_segment14,
p_segment15=>:$column$.gl_segment15
)) l
order by
1xxen_util.instring(:$column$.concatenated_segments,:$flex$.segment_delimiter,9)Y18GL_SEGMENT10LOV customvarchar225Yselect distinct
substrb(l.column_value,instrb(l.column_value,'~',1,1)+1,instrb(l.column_value,'~',1,2)-instrb(l.column_value,'~',1,1)-1) value,
substrb(l.column_value,instrb(l.column_value,'~',1,2)+1) description
from
(
select fifsv.id_flex_num from fnd_id_flex_structures_vl fifsv
where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and
(
xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or
fifsv.id_flex_num in
(
select gl.chart_of_accounts_id from gl_ledgers gl where
(xxen_util.contains(:$flex$.ledger,gl.name)='Y' or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') and
gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+))
)
)
)
) s,
table(xxen_util.kff_segment_lov(
p_application_id=>101,
p_id_flex_code=>'GL#',
p_id_flex_num=>s.id_flex_num,
p_application_column_name=>'SEGMENT10',
p_segment1=>:$column$.gl_segment1,
p_segment2=>:$column$.gl_segment2,
p_segment3=>:$column$.gl_segment3,
p_segment4=>:$column$.gl_segment4,
p_segment5=>:$column$.gl_segment5,
p_segment6=>:$column$.gl_segment6,
p_segment7=>:$column$.gl_segment7,
p_segment8=>:$column$.gl_segment8,
p_segment9=>:$column$.gl_segment9,
p_segment10=>:$column$.gl_segment10,
p_segment11=>:$column$.gl_segment11,
p_segment12=>:$column$.gl_segment12,
p_segment13=>:$column$.gl_segment13,
p_segment14=>:$column$.gl_segment14,
p_segment15=>:$column$.gl_segment15
)) l
order by
1xxen_util.instring(:$column$.concatenated_segments,:$flex$.segment_delimiter,10)Y19GL_SEGMENT11LOV customvarchar225Yselect distinct
substrb(l.column_value,instrb(l.column_value,'~',1,1)+1,instrb(l.column_value,'~',1,2)-instrb(l.column_value,'~',1,1)-1) value,
substrb(l.column_value,instrb(l.column_value,'~',1,2)+1) description
from
(
select fifsv.id_flex_num from fnd_id_flex_structures_vl fifsv
where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and
(
xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or
fifsv.id_flex_num in
(
select gl.chart_of_accounts_id from gl_ledgers gl where
(xxen_util.contains(:$flex$.ledger,gl.name)='Y' or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') and
gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+))
)
)
)
) s,
table(xxen_util.kff_segment_lov(
p_application_id=>101,
p_id_flex_code=>'GL#',
p_id_flex_num=>s.id_flex_num,
p_application_column_name=>'SEGMENT11',
p_segment1=>:$column$.gl_segment1,
p_segment2=>:$column$.gl_segment2,
p_segment3=>:$column$.gl_segment3,
p_segment4=>:$column$.gl_segment4,
p_segment5=>:$column$.gl_segment5,
p_segment6=>:$column$.gl_segment6,
p_segment7=>:$column$.gl_segment7,
p_segment8=>:$column$.gl_segment8,
p_segment9=>:$column$.gl_segment9,
p_segment10=>:$column$.gl_segment10,
p_segment11=>:$column$.gl_segment11,
p_segment12=>:$column$.gl_segment12,
p_segment13=>:$column$.gl_segment13,
p_segment14=>:$column$.gl_segment14,
p_segment15=>:$column$.gl_segment15
)) l
order by
1xxen_util.instring(:$column$.concatenated_segments,:$flex$.segment_delimiter,11)Y20GL_SEGMENT12LOV customvarchar225Yselect distinct
substrb(l.column_value,instrb(l.column_value,'~',1,1)+1,instrb(l.column_value,'~',1,2)-instrb(l.column_value,'~',1,1)-1) value,
substrb(l.column_value,instrb(l.column_value,'~',1,2)+1) description
from
(
select fifsv.id_flex_num from fnd_id_flex_structures_vl fifsv
where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and
(
xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or
fifsv.id_flex_num in
(
select gl.chart_of_accounts_id from gl_ledgers gl where
(xxen_util.contains(:$flex$.ledger,gl.name)='Y' or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') and
gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+))
)
)
)
) s,
table(xxen_util.kff_segment_lov(
p_application_id=>101,
p_id_flex_code=>'GL#',
p_id_flex_num=>s.id_flex_num,
p_application_column_name=>'SEGMENT12',
p_segment1=>:$column$.gl_segment1,
p_segment2=>:$column$.gl_segment2,
p_segment3=>:$column$.gl_segment3,
p_segment4=>:$column$.gl_segment4,
p_segment5=>:$column$.gl_segment5,
p_segment6=>:$column$.gl_segment6,
p_segment7=>:$column$.gl_segment7,
p_segment8=>:$column$.gl_segment8,
p_segment9=>:$column$.gl_segment9,
p_segment10=>:$column$.gl_segment10,
p_segment11=>:$column$.gl_segment11,
p_segment12=>:$column$.gl_segment12,
p_segment13=>:$column$.gl_segment13,
p_segment14=>:$column$.gl_segment14,
p_segment15=>:$column$.gl_segment15
)) l
order by
1xxen_util.instring(:$column$.concatenated_segments,:$flex$.segment_delimiter,12)Y21GL_SEGMENT13LOV customvarchar225Yselect distinct
substrb(l.column_value,instrb(l.column_value,'~',1,1)+1,instrb(l.column_value,'~',1,2)-instrb(l.column_value,'~',1,1)-1) value,
substrb(l.column_value,instrb(l.column_value,'~',1,2)+1) description
from
(
select fifsv.id_flex_num from fnd_id_flex_structures_vl fifsv
where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and
(
xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or
fifsv.id_flex_num in
(
select gl.chart_of_accounts_id from gl_ledgers gl where
(xxen_util.contains(:$flex$.ledger,gl.name)='Y' or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') and
gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+))
)
)
)
) s,
table(xxen_util.kff_segment_lov(
p_application_id=>101,
p_id_flex_code=>'GL#',
p_id_flex_num=>s.id_flex_num,
p_application_column_name=>'SEGMENT13',
p_segment1=>:$column$.gl_segment1,
p_segment2=>:$column$.gl_segment2,
p_segment3=>:$column$.gl_segment3,
p_segment4=>:$column$.gl_segment4,
p_segment5=>:$column$.gl_segment5,
p_segment6=>:$column$.gl_segment6,
p_segment7=>:$column$.gl_segment7,
p_segment8=>:$column$.gl_segment8,
p_segment9=>:$column$.gl_segment9,
p_segment10=>:$column$.gl_segment10,
p_segment11=>:$column$.gl_segment11,
p_segment12=>:$column$.gl_segment12,
p_segment13=>:$column$.gl_segment13,
p_segment14=>:$column$.gl_segment14,
p_segment15=>:$column$.gl_segment15
)) l
order by
1xxen_util.instring(:$column$.concatenated_segments,:$flex$.segment_delimiter,13)Y22GL_SEGMENT14LOV customvarchar225Yselect distinct
substrb(l.column_value,instrb(l.column_value,'~',1,1)+1,instrb(l.column_value,'~',1,2)-instrb(l.column_value,'~',1,1)-1) value,
substrb(l.column_value,instrb(l.column_value,'~',1,2)+1) description
from
(
select fifsv.id_flex_num from fnd_id_flex_structures_vl fifsv
where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and
(
xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or
fifsv.id_flex_num in
(
select gl.chart_of_accounts_id from gl_ledgers gl where
(xxen_util.contains(:$flex$.ledger,gl.name)='Y' or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') and
gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+))
)
)
)
) s,
table(xxen_util.kff_segment_lov(
p_application_id=>101,
p_id_flex_code=>'GL#',
p_id_flex_num=>s.id_flex_num,
p_application_column_name=>'SEGMENT14',
p_segment1=>:$column$.gl_segment1,
p_segment2=>:$column$.gl_segment2,
p_segment3=>:$column$.gl_segment3,
p_segment4=>:$column$.gl_segment4,
p_segment5=>:$column$.gl_segment5,
p_segment6=>:$column$.gl_segment6,
p_segment7=>:$column$.gl_segment7,
p_segment8=>:$column$.gl_segment8,
p_segment9=>:$column$.gl_segment9,
p_segment10=>:$column$.gl_segment10,
p_segment11=>:$column$.gl_segment11,
p_segment12=>:$column$.gl_segment12,
p_segment13=>:$column$.gl_segment13,
p_segment14=>:$column$.gl_segment14,
p_segment15=>:$column$.gl_segment15
)) l
order by
1xxen_util.instring(:$column$.concatenated_segments,:$flex$.segment_delimiter,14)Y23GL_SEGMENT15LOV customvarchar225Yselect distinct
substrb(l.column_value,instrb(l.column_value,'~',1,1)+1,instrb(l.column_value,'~',1,2)-instrb(l.column_value,'~',1,1)-1) value,
substrb(l.column_value,instrb(l.column_value,'~',1,2)+1) description
from
(
select fifsv.id_flex_num from fnd_id_flex_structures_vl fifsv
where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and
(
xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or
fifsv.id_flex_num in
(
select gl.chart_of_accounts_id from gl_ledgers gl where
(xxen_util.contains(:$flex$.ledger,gl.name)='Y' or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') and
gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+))
)
)
)
) s,
table(xxen_util.kff_segment_lov(
p_application_id=>101,
p_id_flex_code=>'GL#',
p_id_flex_num=>s.id_flex_num,
p_application_column_name=>'SEGMENT15',
p_segment1=>:$column$.gl_segment1,
p_segment2=>:$column$.gl_segment2,
p_segment3=>:$column$.gl_segment3,
p_segment4=>:$column$.gl_segment4,
p_segment5=>:$column$.gl_segment5,
p_segment6=>:$column$.gl_segment6,
p_segment7=>:$column$.gl_segment7,
p_segment8=>:$column$.gl_segment8,
p_segment9=>:$column$.gl_segment9,
p_segment10=>:$column$.gl_segment10,
p_segment11=>:$column$.gl_segment11,
p_segment12=>:$column$.gl_segment12,
p_segment13=>:$column$.gl_segment13,
p_segment14=>:$column$.gl_segment14,
p_segment15=>:$column$.gl_segment15
)) l
order by
1xxen_util.instring(:$column$.concatenated_segments,:$flex$.segment_delimiter,15)Y24SUMMARYLOV Oraclevarchar2Yes_NoYselect
lookup_code id,
meaning value,
null description
from
fnd_lookups
where fnd_lookups.lookup_type='YES_NO'
order by value,descriptionDerived during account creation, non-updateableY25ENABLEDLOV Oraclevarchar2Yes_NoYselect
lookup_code id,
meaning value,
null description
from
fnd_lookups
where fnd_lookups.lookup_type='YES_NO'
order by value,descriptionDerived during account creation, can only be updated26START_DATE_ACTIVEDatedateDerived during account creation, can only be updated27END_DATE_ACTIVEDatedateDerived during account creation, can only be updated28DETAIL_BUDGETING_ALLOWEDLOV Oraclevarchar2Yes_NoYselect
lookup_code id,
meaning value,
null description
from
fnd_lookups
where fnd_lookups.lookup_type='YES_NO'
order by value,descriptionDerived during account creation, can only be updated29DETAIL_POSTING_ALLOWEDLOV Oraclevarchar2Yes_NoYselect
lookup_code id,
meaning value,
null description
from
fnd_lookups
where fnd_lookups.lookup_type='YES_NO'
order by value,descriptionDerived during account creation, can only be updated30ATTRIBUTE_CONTEXTLOV customvarchar2Yselect distinct
fdfcv.descriptive_flex_context_name value,
fdfcv.description
from
fnd_descriptive_flexs_vl fdfv,
fnd_descr_flex_contexts_vl fdfcv
where
fdfcv.application_id=fdfv.application_id and
fdfcv.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and
fdfcv.enabled_flag='Y' and
fdfv.application_id=101 and
fdfv.descriptive_flexfield_name='GL_CODE_COMBINATIONS' and
fdfcv.descriptive_flex_context_code<>'Global Data Elements'
order by
fdfcv.descriptive_flex_context_name31GL_ACCOUNT_ATTRIBUTE1LOV customvarchar2Yselect
substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value,
substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description
from
table(
xxen_util.dff_attribute_lov
(p_application_id => 101,
p_descriptive_flexfield_name => 'GL_CODE_COMBINATIONS',
p_context_name => :$column$.attribute_context,
p_column_name => 'ATTRIBUTE1',
p_attribute1 => :$column$.gl_account_attribute1,
p_attribute2 => :$column$.gl_account_attribute2,
p_attribute3 => :$column$.gl_account_attribute3,
p_attribute4 => :$column$.gl_account_attribute4,
p_attribute5 => :$column$.gl_account_attribute5,
p_attribute6 => :$column$.gl_account_attribute6,
p_attribute7 => :$column$.gl_account_attribute7,
p_attribute8 => :$column$.gl_account_attribute8,
p_attribute9 => :$column$.gl_account_attribute9,
p_attribute10 => :$column$.gl_account_attribute10
)
) lov
order by
valueselect distinct
'(Context) ' || initcap(fdfcuv.application_column_name) || ': ' ||
listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name)
from
fnd_descriptive_flexs_vl fdfv,
fnd_descr_flex_contexts fdfc,
fnd_descr_flex_col_usage_vl fdfcuv
where
fdfc.application_id=fdfv.application_id and
fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and
fdfc.enabled_flag='Y' and
fdfcuv.application_id=fdfc.application_id and
fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and
fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and
fdfcuv.enabled_flag='Y' and
fdfv.application_id=101 and
fdfv.descriptive_flexfield_name='GL_CODE_COMBINATIONS' and
fdfcuv.application_column_name='ATTRIBUTE1'32GL_ACCOUNT_ATTRIBUTE2LOV customvarchar2Yselect
substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value,
substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description
from
table(
xxen_util.dff_attribute_lov
(p_application_id => 101,
p_descriptive_flexfield_name => 'GL_CODE_COMBINATIONS',
p_context_name => :$column$.attribute_context,
p_column_name => 'ATTRIBUTE2',
p_attribute1 => :$column$.gl_account_attribute1,
p_attribute2 => :$column$.gl_account_attribute2,
p_attribute3 => :$column$.gl_account_attribute3,
p_attribute4 => :$column$.gl_account_attribute4,
p_attribute5 => :$column$.gl_account_attribute5,
p_attribute6 => :$column$.gl_account_attribute6,
p_attribute7 => :$column$.gl_account_attribute7,
p_attribute8 => :$column$.gl_account_attribute8,
p_attribute9 => :$column$.gl_account_attribute9,
p_attribute10 => :$column$.gl_account_attribute10
)
) lov
order by
valueselect distinct
'(Context) ' || initcap(fdfcuv.application_column_name) || ': ' ||
listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name)
from
fnd_descriptive_flexs_vl fdfv,
fnd_descr_flex_contexts fdfc,
fnd_descr_flex_col_usage_vl fdfcuv
where
fdfc.application_id=fdfv.application_id and
fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and
fdfc.enabled_flag='Y' and
fdfcuv.application_id=fdfc.application_id and
fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and
fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and
fdfcuv.enabled_flag='Y' and
fdfv.application_id=101 and
fdfv.descriptive_flexfield_name='GL_CODE_COMBINATIONS' and
fdfcuv.application_column_name='ATTRIBUTE2'33GL_ACCOUNT_ATTRIBUTE3LOV customvarchar2Yselect
substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value,
substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description
from
table(
xxen_util.dff_attribute_lov
(p_application_id => 101,
p_descriptive_flexfield_name => 'GL_CODE_COMBINATIONS',
p_context_name => :$column$.attribute_context,
p_column_name => 'ATTRIBUTE3',
p_attribute1 => :$column$.gl_account_attribute1,
p_attribute2 => :$column$.gl_account_attribute2,
p_attribute3 => :$column$.gl_account_attribute3,
p_attribute4 => :$column$.gl_account_attribute4,
p_attribute5 => :$column$.gl_account_attribute5,
p_attribute6 => :$column$.gl_account_attribute6,
p_attribute7 => :$column$.gl_account_attribute7,
p_attribute8 => :$column$.gl_account_attribute8,
p_attribute9 => :$column$.gl_account_attribute9,
p_attribute10 => :$column$.gl_account_attribute10
)
) lov
order by
valueselect distinct
'(Context) ' || initcap(fdfcuv.application_column_name) || ': ' ||
listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name)
from
fnd_descriptive_flexs_vl fdfv,
fnd_descr_flex_contexts fdfc,
fnd_descr_flex_col_usage_vl fdfcuv
where
fdfc.application_id=fdfv.application_id and
fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and
fdfc.enabled_flag='Y' and
fdfcuv.application_id=fdfc.application_id and
fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and
fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and
fdfcuv.enabled_flag='Y' and
fdfv.application_id=101 and
fdfv.descriptive_flexfield_name='GL_CODE_COMBINATIONS' and
fdfcuv.application_column_name='ATTRIBUTE3'34GL_ACCOUNT_ATTRIBUTE4LOV customvarchar2Yselect
substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value,
substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description
from
table(
xxen_util.dff_attribute_lov
(p_application_id => 101,
p_descriptive_flexfield_name => 'GL_CODE_COMBINATIONS',
p_context_name => :$column$.attribute_context,
p_column_name => 'ATTRIBUTE4',
p_attribute1 => :$column$.gl_account_attribute1,
p_attribute2 => :$column$.gl_account_attribute2,
p_attribute3 => :$column$.gl_account_attribute3,
p_attribute4 => :$column$.gl_account_attribute4,
p_attribute5 => :$column$.gl_account_attribute5,
p_attribute6 => :$column$.gl_account_attribute6,
p_attribute7 => :$column$.gl_account_attribute7,
p_attribute8 => :$column$.gl_account_attribute8,
p_attribute9 => :$column$.gl_account_attribute9,
p_attribute10 => :$column$.gl_account_attribute10
)
) lov
order by
valueselect distinct
'(Context) ' || initcap(fdfcuv.application_column_name) || ': ' ||
listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name)
from
fnd_descriptive_flexs_vl fdfv,
fnd_descr_flex_contexts fdfc,
fnd_descr_flex_col_usage_vl fdfcuv
where
fdfc.application_id=fdfv.application_id and
fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and
fdfc.enabled_flag='Y' and
fdfcuv.application_id=fdfc.application_id and
fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and
fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and
fdfcuv.enabled_flag='Y' and
fdfv.application_id=101 and
fdfv.descriptive_flexfield_name='GL_CODE_COMBINATIONS' and
fdfcuv.application_column_name='ATTRIBUTE4'35GL_ACCOUNT_ATTRIBUTE5LOV customvarchar2Yselect
substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value,
substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description
from
table(
xxen_util.dff_attribute_lov
(p_application_id => 101,
p_descriptive_flexfield_name => 'GL_CODE_COMBINATIONS',
p_context_name => :$column$.attribute_context,
p_column_name => 'ATTRIBUTE5',
p_attribute1 => :$column$.gl_account_attribute1,
p_attribute2 => :$column$.gl_account_attribute2,
p_attribute3 => :$column$.gl_account_attribute3,
p_attribute4 => :$column$.gl_account_attribute4,
p_attribute5 => :$column$.gl_account_attribute5,
p_attribute6 => :$column$.gl_account_attribute6,
p_attribute7 => :$column$.gl_account_attribute7,
p_attribute8 => :$column$.gl_account_attribute8,
p_attribute9 => :$column$.gl_account_attribute9,
p_attribute10 => :$column$.gl_account_attribute10
)
) lov
order by
valueselect distinct
'(Context) ' || initcap(fdfcuv.application_column_name) || ': ' ||
listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name)
from
fnd_descriptive_flexs_vl fdfv,
fnd_descr_flex_contexts fdfc,
fnd_descr_flex_col_usage_vl fdfcuv
where
fdfc.application_id=fdfv.application_id and
fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and
fdfc.enabled_flag='Y' and
fdfcuv.application_id=fdfc.application_id and
fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and
fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and
fdfcuv.enabled_flag='Y' and
fdfv.application_id=101 and
fdfv.descriptive_flexfield_name='GL_CODE_COMBINATIONS' and
fdfcuv.application_column_name='ATTRIBUTE5'36GL_ACCOUNT_ATTRIBUTE6LOV customvarchar2Yselect
substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value,
substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description
from
table(
xxen_util.dff_attribute_lov
(p_application_id => 101,
p_descriptive_flexfield_name => 'GL_CODE_COMBINATIONS',
p_context_name => :$column$.attribute_context,
p_column_name => 'ATTRIBUTE6',
p_attribute1 => :$column$.gl_account_attribute1,
p_attribute2 => :$column$.gl_account_attribute2,
p_attribute3 => :$column$.gl_account_attribute3,
p_attribute4 => :$column$.gl_account_attribute4,
p_attribute5 => :$column$.gl_account_attribute5,
p_attribute6 => :$column$.gl_account_attribute6,
p_attribute7 => :$column$.gl_account_attribute7,
p_attribute8 => :$column$.gl_account_attribute8,
p_attribute9 => :$column$.gl_account_attribute9,
p_attribute10 => :$column$.gl_account_attribute10
)
) lov
order by
valueselect distinct
'(Context) ' || initcap(fdfcuv.application_column_name) || ': ' ||
listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name)
from
fnd_descriptive_flexs_vl fdfv,
fnd_descr_flex_contexts fdfc,
fnd_descr_flex_col_usage_vl fdfcuv
where
fdfc.application_id=fdfv.application_id and
fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and
fdfc.enabled_flag='Y' and
fdfcuv.application_id=fdfc.application_id and
fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and
fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and
fdfcuv.enabled_flag='Y' and
fdfv.application_id=101 and
fdfv.descriptive_flexfield_name='GL_CODE_COMBINATIONS' and
fdfcuv.application_column_name='ATTRIBUTE6'37GL_ACCOUNT_ATTRIBUTE7LOV customvarchar2Yselect
substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value,
substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description
from
table(
xxen_util.dff_attribute_lov
(p_application_id => 101,
p_descriptive_flexfield_name => 'GL_CODE_COMBINATIONS',
p_context_name => :$column$.attribute_context,
p_column_name => 'ATTRIBUTE7',
p_attribute1 => :$column$.gl_account_attribute1,
p_attribute2 => :$column$.gl_account_attribute2,
p_attribute3 => :$column$.gl_account_attribute3,
p_attribute4 => :$column$.gl_account_attribute4,
p_attribute5 => :$column$.gl_account_attribute5,
p_attribute6 => :$column$.gl_account_attribute6,
p_attribute7 => :$column$.gl_account_attribute7,
p_attribute8 => :$column$.gl_account_attribute8,
p_attribute9 => :$column$.gl_account_attribute9,
p_attribute10 => :$column$.gl_account_attribute10
)
) lov
order by
valueselect distinct
'(Context) ' || initcap(fdfcuv.application_column_name) || ': ' ||
listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name)
from
fnd_descriptive_flexs_vl fdfv,
fnd_descr_flex_contexts fdfc,
fnd_descr_flex_col_usage_vl fdfcuv
where
fdfc.application_id=fdfv.application_id and
fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and
fdfc.enabled_flag='Y' and
fdfcuv.application_id=fdfc.application_id and
fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and
fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and
fdfcuv.enabled_flag='Y' and
fdfv.application_id=101 and
fdfv.descriptive_flexfield_name='GL_CODE_COMBINATIONS' and
fdfcuv.application_column_name='ATTRIBUTE7'38GL_ACCOUNT_ATTRIBUTE8LOV customvarchar2Yselect
substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value,
substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description
from
table(
xxen_util.dff_attribute_lov
(p_application_id => 101,
p_descriptive_flexfield_name => 'GL_CODE_COMBINATIONS',
p_context_name => :$column$.attribute_context,
p_column_name => 'ATTRIBUTE8',
p_attribute1 => :$column$.gl_account_attribute1,
p_attribute2 => :$column$.gl_account_attribute2,
p_attribute3 => :$column$.gl_account_attribute3,
p_attribute4 => :$column$.gl_account_attribute4,
p_attribute5 => :$column$.gl_account_attribute5,
p_attribute6 => :$column$.gl_account_attribute6,
p_attribute7 => :$column$.gl_account_attribute7,
p_attribute8 => :$column$.gl_account_attribute8,
p_attribute9 => :$column$.gl_account_attribute9,
p_attribute10 => :$column$.gl_account_attribute10
)
) lov
order by
valueselect distinct
'(Context) ' || initcap(fdfcuv.application_column_name) || ': ' ||
listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name)
from
fnd_descriptive_flexs_vl fdfv,
fnd_descr_flex_contexts fdfc,
fnd_descr_flex_col_usage_vl fdfcuv
where
fdfc.application_id=fdfv.application_id and
fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and
fdfc.enabled_flag='Y' and
fdfcuv.application_id=fdfc.application_id and
fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and
fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and
fdfcuv.enabled_flag='Y' and
fdfv.application_id=101 and
fdfv.descriptive_flexfield_name='GL_CODE_COMBINATIONS' and
fdfcuv.application_column_name='ATTRIBUTE8'39GL_ACCOUNT_ATTRIBUTE9LOV customvarchar2Yselect
substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value,
substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description
from
table(
xxen_util.dff_attribute_lov
(p_application_id => 101,
p_descriptive_flexfield_name => 'GL_CODE_COMBINATIONS',
p_context_name => :$column$.attribute_context,
p_column_name => 'ATTRIBUTE9',
p_attribute1 => :$column$.gl_account_attribute1,
p_attribute2 => :$column$.gl_account_attribute2,
p_attribute3 => :$column$.gl_account_attribute3,
p_attribute4 => :$column$.gl_account_attribute4,
p_attribute5 => :$column$.gl_account_attribute5,
p_attribute6 => :$column$.gl_account_attribute6,
p_attribute7 => :$column$.gl_account_attribute7,
p_attribute8 => :$column$.gl_account_attribute8,
p_attribute9 => :$column$.gl_account_attribute9,
p_attribute10 => :$column$.gl_account_attribute10
)
) lov
order by
valueselect distinct
'(Context) ' || initcap(fdfcuv.application_column_name) || ': ' ||
listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name)
from
fnd_descriptive_flexs_vl fdfv,
fnd_descr_flex_contexts fdfc,
fnd_descr_flex_col_usage_vl fdfcuv
where
fdfc.application_id=fdfv.application_id and
fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and
fdfc.enabled_flag='Y' and
fdfcuv.application_id=fdfc.application_id and
fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and
fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and
fdfcuv.enabled_flag='Y' and
fdfv.application_id=101 and
fdfv.descriptive_flexfield_name='GL_CODE_COMBINATIONS' and
fdfcuv.application_column_name='ATTRIBUTE9'40GL_ACCOUNT_ATTRIBUTE10LOV customvarchar2Yselect
substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value,
substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description
from
table(
xxen_util.dff_attribute_lov
(p_application_id => 101,
p_descriptive_flexfield_name => 'GL_CODE_COMBINATIONS',
p_context_name => :$column$.attribute_context,
p_column_name => 'ATTRIBUTE10',
p_attribute1 => :$column$.gl_account_attribute1,
p_attribute2 => :$column$.gl_account_attribute2,
p_attribute3 => :$column$.gl_account_attribute3,
p_attribute4 => :$column$.gl_account_attribute4,
p_attribute5 => :$column$.gl_account_attribute5,
p_attribute6 => :$column$.gl_account_attribute6,
p_attribute7 => :$column$.gl_account_attribute7,
p_attribute8 => :$column$.gl_account_attribute8,
p_attribute9 => :$column$.gl_account_attribute9,
p_attribute10 => :$column$.gl_account_attribute10
)
) lov
order by
valueselect distinct
'(Context) ' || initcap(fdfcuv.application_column_name) || ': ' ||
listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name)
from
fnd_descriptive_flexs_vl fdfv,
fnd_descr_flex_contexts fdfc,
fnd_descr_flex_col_usage_vl fdfcuv
where
fdfc.application_id=fdfv.application_id and
fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and
fdfc.enabled_flag='Y' and
fdfcuv.application_id=fdfc.application_id and
fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and
fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and
fdfcuv.enabled_flag='Y' and
fdfv.application_id=101 and
fdfv.descriptive_flexfield_name='GL_CODE_COMBINATIONS' and
fdfcuv.application_column_name='ATTRIBUTE10'41CODE_COMBINATION_IDNumbernumberYU1p_ledgerinCharLEDGERU2p_account_ccidin/outNumberCODE_COMBINATION_IDU3p_enabled_flaginCharENABLEDU4p_start_date_activeinDateSTART_DATE_ACTIVEU5p_end_date_activeinDateEND_DATE_ACTIVEU6p_summary_flaginCharSUMMARYU7p_detail_budgeting_allowedinCharDETAIL_BUDGETING_ALLOWEDU8p_detail_posting_allowedinCharDETAIL_POSTING_ALLOWEDU11p_segment1inCharGL_SEGMENT1U12p_segment2inCharGL_SEGMENT2U13p_segment3inCharGL_SEGMENT3U14p_segment4inCharGL_SEGMENT4U15p_segment5inCharGL_SEGMENT5U16p_segment6inCharGL_SEGMENT6U17p_segment7inCharGL_SEGMENT7U18p_segment8inCharGL_SEGMENT8U19p_segment9inCharGL_SEGMENT9U20p_segment10inCharGL_SEGMENT10U21p_segment11inCharGL_SEGMENT11U22p_segment12inCharGL_SEGMENT12U23p_segment13inCharGL_SEGMENT13U24p_segment14inCharGL_SEGMENT14U25p_segment15inCharGL_SEGMENT15U26p_segment16inCharU27p_segment17inCharU28p_segment18inCharU29p_segment19inCharU30p_segment20inCharU31p_segment21inCharU32p_segment22inCharU33p_segment23inCharU34p_segment24inCharU35p_segment25inCharU36p_segment26inCharU37p_segment27inCharU38p_segment28inCharU39p_segment29inCharU40p_segment30inCharU41p_attribute_contextinCharATTRIBUTE_CONTEXTU42p_attribute1inCharGL_ACCOUNT_ATTRIBUTE1U43p_attribute2inCharGL_ACCOUNT_ATTRIBUTE2U44p_attribute3inCharGL_ACCOUNT_ATTRIBUTE3U45p_attribute4inCharGL_ACCOUNT_ATTRIBUTE4U46p_attribute5inCharGL_ACCOUNT_ATTRIBUTE5U47p_attribute6inCharGL_ACCOUNT_ATTRIBUTE6U48p_attribute7inCharGL_ACCOUNT_ATTRIBUTE7U49p_attribute8inCharGL_ACCOUNT_ATTRIBUTE8U50p_attribute9inCharGL_ACCOUNT_ATTRIBUTE9U51p_attribute10inCharGL_ACCOUNT_ATTRIBUTE10U52status_outCharSTATUS_CODE_U53message_outCharMESSAGE_Success SQLselect
xu.action_,
xu.status_,
xu.message_,
xu.modified_columns_,
xu.ledger,
nvl(gcck.concatenated_segments,xu.concatenated_segments) concatenated_segments,
xu.description,
nvl(ffvv.description,xu.account_type) account_type,
nvl(gcck.segment1,xu.gl_segment1) gl_segment1,
nvl(gcck.segment2,xu.gl_segment2) gl_segment2,
nvl(gcck.segment3,xu.gl_segment3) gl_segment3,
nvl(gcck.segment4,xu.gl_segment4) gl_segment4,
nvl(gcck.segment5,xu.gl_segment5) gl_segment5,
nvl(gcck.segment6,xu.gl_segment6) gl_segment6,
nvl(gcck.segment7,xu.gl_segment7) gl_segment7,
nvl(gcck.segment8,xu.gl_segment8) gl_segment8,
nvl(gcck.segment9,xu.gl_segment9) gl_segment9,
nvl(gcck.segment10,xu.gl_segment10) gl_segment10,
nvl(gcck.segment11,xu.gl_segment11) gl_segment11,
nvl(gcck.segment12,xu.gl_segment12) gl_segment12,
nvl(gcck.segment13,xu.gl_segment13) gl_segment13,
nvl(gcck.segment14,xu.gl_segment14) gl_segment14,
nvl(gcck.segment15,xu.gl_segment15) gl_segment15,
nvl(xxen_util.meaning(gcck.summary_flag,'YES_NO',0),xu.summary) summary,
nvl(xxen_util.meaning(gcck.enabled_flag,'YES_NO',0),xu.enabled) enabled,
nvl(gcck.start_date_active,xu.start_date_active) start_date_active,
nvl(gcck.end_date_active,xu.end_date_active) end_date_active,
nvl(xxen_util.meaning(gcck.detail_budgeting_allowed,'YES_NO',0),xu.detail_budgeting_allowed) detail_budgeting_allowed,
nvl(xxen_util.meaning(gcck.detail_posting_allowed,'YES_NO',0),xu.detail_posting_allowed) detail_posting_allowed,
nvl(xxen_util.display_flexfield_context(101,'GL_CODE_COMBINATIONS',gcck.context),xu.attribute_context) attribute_context,
nvl(xxen_util.display_flexfield_value(101,'GL_CODE_COMBINATIONS',gcck.context,'ATTRIBUTE1',gcck.rowid,gcck.attribute1),xu.gl_account_attribute1) gl_account_attribute1,
nvl(xxen_util.display_flexfield_value(101,'GL_CODE_COMBINATIONS',gcck.context,'ATTRIBUTE2',gcck.rowid,gcck.attribute2),xu.gl_account_attribute2) gl_account_attribute2,
nvl(xxen_util.display_flexfield_value(101,'GL_CODE_COMBINATIONS',gcck.context,'ATTRIBUTE3',gcck.rowid,gcck.attribute3),xu.gl_account_attribute3) gl_account_attribute3,
nvl(xxen_util.display_flexfield_value(101,'GL_CODE_COMBINATIONS',gcck.context,'ATTRIBUTE4',gcck.rowid,gcck.attribute4),xu.gl_account_attribute4) gl_account_attribute4,
nvl(xxen_util.display_flexfield_value(101,'GL_CODE_COMBINATIONS',gcck.context,'ATTRIBUTE5',gcck.rowid,gcck.attribute5),xu.gl_account_attribute5) gl_account_attribute5,
nvl(xxen_util.display_flexfield_value(101,'GL_CODE_COMBINATIONS',gcck.context,'ATTRIBUTE6',gcck.rowid,gcck.attribute6),xu.gl_account_attribute6) gl_account_attribute6,
nvl(xxen_util.display_flexfield_value(101,'GL_CODE_COMBINATIONS',gcck.context,'ATTRIBUTE7',gcck.rowid,gcck.attribute7),xu.gl_account_attribute7) gl_account_attribute7,
nvl(xxen_util.display_flexfield_value(101,'GL_CODE_COMBINATIONS',gcck.context,'ATTRIBUTE8',gcck.rowid,gcck.attribute8),xu.gl_account_attribute8) gl_account_attribute8,
nvl(xxen_util.display_flexfield_value(101,'GL_CODE_COMBINATIONS',gcck.context,'ATTRIBUTE9',gcck.rowid,gcck.attribute9),xu.gl_account_attribute9) gl_account_attribute9,
nvl(xxen_util.display_flexfield_value(101,'GL_CODE_COMBINATIONS',gcck.context,'ATTRIBUTE10',gcck.rowid,gcck.attribute10),xu.gl_account_attribute10) gl_account_attribute10,
nvl(gcck.code_combination_id,xu.code_combination_id) code_combination_id
from
gl_code_combinations_kfv gcck,
gl_code_combinations_kfv gccka,
(select
ffvv.flex_value,
ffvv.description
from
fnd_flex_values_vl ffvv,
fnd_flex_value_sets ffvs
where
ffvv.flex_value_set_id=ffvs.flex_value_set_id and
ffvs.flex_value_set_name='GL_SRS_ACCOUNT_TYPE'
) ffvv,
(
select fifs.id_flex_num
from
fnd_id_flex_structures_tl fifs
where
fifs.application_id=101 and
fifs.id_flex_code='GL#' and
fifs.language=userenv ('LANG')
)fifs,
xxen_gl_account_upload_7410_u xu
where
xu.code_combination_id=gcck.code_combination_id(+) and
gcck.gl_account_type=ffvv.flex_value(+) and
gcck.alternate_code_combination_id=gccka.code_combination_id(+) and
gcck.chart_of_accounts_id=fifs.id_flex_num(+)