ENGINATICSSYSTEM_ADMINISTRATORSYSADMINE811F942597A2075E0530100007FF4F2Blitz Upload ModeYselect 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 dual
US8E2FF36EDEB879D2E0530100007F1FF2GL LedgerYselect
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.nameARدفاتر الأستاذ المقيدة بمجموعة الوصول ، المحددة بواسطة قيمة الملف الشخصي "مجموعة الوصول إلى بيانات GL" لمسؤولية تسجيل الدخول الحاليةDLedger, die durch das Zugriffsset eingeschränkt sind, definiert durch den Profilwert 'GL Data Access Set' der aktuellen AnmeldeverantwortungELibros restringidos por el conjunto de acceso, definido por el valor del perfil "Conjunto de acceso a datos GL" de la responsabilidad de inicio de sesión actualFGrands livres limités par un ensemble d'accès, défini par la valeur du profil "GL Data Access Set" de la responsabilité de connexion actuelleILibri mastri limitati dal set di accesso, definito dal valore del profilo 'GL Data Access Set' della responsabilità di login correnteJA現在のログイン責任者のプロファイル値'GL Data Access Set'によって定義されたアクセスセットによって制限された元帳KO현재 로그인 권한의 프로파일 값 'GL 데이터 액세스 세트'로 정의 된 액세스 세트로 제한되는 원장PTBLedgers restritos pelo conjunto de acesso, definido pelo valor do perfil 'GL Data Access Set' da atual responsabilidade de loginRUЛеджеры, ограниченные набором доступа, определяемые значением профиля "GL Data Access Set" текущей ответственности за вход в системуSLedgers begränsade av åtkomstuppsättning, definierade av profilvärde 'GL Data Access Set' för det aktuella inloggningsansvaretTRMevcut oturum açma sorumluluğunun profil değeri 'GL Veri Erişim Kümesi' ile tanımlanan erişim kümesiyle kısıtlanmış defterlerUSLedgers restricted by access set, defined by profile value 'GL Data Access Set' of the current login responsibilityZHS由访问集限制的分类账，由当前登录责任的配置文件值 "GL数据访问集 "定义。8E2FF36EDECC79D2E0530100007F1FF2GL Segment1Yselect
ffvv.flex_value value,
ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description
from
fnd_id_flex_segments_vl fifsgv,
fnd_flex_values_vl ffvv
where
gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and
fifsgv.application_id=101 and
fifsgv.id_flex_code='GL#' and
fifsgv.enabled_flag='Y' and
fifsgv.application_column_name='SEGMENT1' and
fifsgv.flex_value_set_id=ffvv.flex_value_set_id and
fifsgv.id_flex_num in (
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
fifsgv.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(+))
)
)
)
)
order by
ffvv.flex_valueConcatenate (inactive) to the description of inactive segment valuesUSB3D07BBAC1A645D7E0530100007FB1B8GL Segment10Yselect
ffvv.flex_value value,
ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description
from
fnd_id_flex_segments_vl fifsgv,
fnd_flex_values_vl ffvv
where
gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and
fifsgv.application_id=101 and
fifsgv.id_flex_code='GL#' and
fifsgv.enabled_flag='Y' and
fifsgv.application_column_name='SEGMENT10' and
fifsgv.flex_value_set_id=ffvv.flex_value_set_id and
fifsgv.id_flex_num in (
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
fifsgv.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(+))
)
)
)
)
order by
ffvv.flex_valueConcatenate (inactive) to the description of inactive segment valuesUS3CF0AFFEDB407EB4E0630100007F9A70GL Segment11Yselect
ffvv.flex_value value,
ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description
from
fnd_id_flex_segments_vl fifsgv,
fnd_flex_values_vl ffvv
where
gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and
fifsgv.application_id=101 and
fifsgv.id_flex_code='GL#' and
fifsgv.enabled_flag='Y' and
fifsgv.application_column_name='SEGMENT11' and
fifsgv.flex_value_set_id=ffvv.flex_value_set_id and
fifsgv.id_flex_num in (
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
fifsgv.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(+))
)
)
)
)
order by
ffvv.flex_valueUS3CF0AFFEDB417EB4E0630100007F9A70GL Segment12Yselect
ffvv.flex_value value,
ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description
from
fnd_id_flex_segments_vl fifsgv,
fnd_flex_values_vl ffvv
where
gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and
fifsgv.application_id=101 and
fifsgv.id_flex_code='GL#' and
fifsgv.enabled_flag='Y' and
fifsgv.application_column_name='SEGMENT12' and
fifsgv.flex_value_set_id=ffvv.flex_value_set_id and
fifsgv.id_flex_num in (
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
fifsgv.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(+))
)
)
)
)
order by
ffvv.flex_valueUS8E2FF36EDECD79D2E0530100007F1FF2GL Segment2Yselect
ffvv.flex_value value,
ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description
from
fnd_id_flex_segments_vl fifsgv,
fnd_flex_values_vl ffvv
where
gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and
fifsgv.application_id=101 and
fifsgv.id_flex_code='GL#' and
fifsgv.enabled_flag='Y' and
fifsgv.application_column_name='SEGMENT2' and
fifsgv.flex_value_set_id=ffvv.flex_value_set_id and
fifsgv.id_flex_num in (
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
fifsgv.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(+))
)
)
)
)
order by
ffvv.flex_valueConcatenate (inactive) to the description of inactive segment valuesUS8E2FF36EDECE79D2E0530100007F1FF2GL Segment3Yselect
ffvv.flex_value value,
ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description
from
fnd_id_flex_segments_vl fifsgv,
fnd_flex_values_vl ffvv
where
gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and
fifsgv.application_id=101 and
fifsgv.id_flex_code='GL#' and
fifsgv.enabled_flag='Y' and
fifsgv.application_column_name='SEGMENT3' and
fifsgv.flex_value_set_id=ffvv.flex_value_set_id and
fifsgv.id_flex_num in (
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
fifsgv.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(+))
)
)
)
)
order by
ffvv.flex_valueConcatenate (inactive) to the description of inactive segment valuesUS8E2FF36EDECF79D2E0530100007F1FF2GL Segment4Yselect
ffvv.flex_value value,
ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description
from
fnd_id_flex_segments_vl fifsgv,
fnd_flex_values_vl ffvv
where
gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and
fifsgv.application_id=101 and
fifsgv.id_flex_code='GL#' and
fifsgv.enabled_flag='Y' and
fifsgv.application_column_name='SEGMENT4' and
fifsgv.flex_value_set_id=ffvv.flex_value_set_id and
fifsgv.id_flex_num in (
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
fifsgv.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(+))
)
)
)
)
order by
ffvv.flex_valueConcatenate (inactive) to the description of inactive segment valuesUS8E2FF36EDED079D2E0530100007F1FF2GL Segment5Yselect
ffvv.flex_value value,
ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description
from
fnd_id_flex_segments_vl fifsgv,
fnd_flex_values_vl ffvv
where
gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and
fifsgv.application_id=101 and
fifsgv.id_flex_code='GL#' and
fifsgv.enabled_flag='Y' and
fifsgv.application_column_name='SEGMENT5' and
fifsgv.flex_value_set_id=ffvv.flex_value_set_id and
fifsgv.id_flex_num in (
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
fifsgv.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(+))
)
)
)
)
order by
ffvv.flex_valueConcatenate (inactive) to the description of inactive segment valuesUS8E2FF36EDED179D2E0530100007F1FF2GL Segment6Yselect
ffvv.flex_value value,
ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description
from
fnd_id_flex_segments_vl fifsgv,
fnd_flex_values_vl ffvv
where
gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and
fifsgv.application_id=101 and
fifsgv.id_flex_code='GL#' and
fifsgv.enabled_flag='Y' and
fifsgv.application_column_name='SEGMENT6' and
fifsgv.flex_value_set_id=ffvv.flex_value_set_id and
fifsgv.id_flex_num in (
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
fifsgv.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(+))
)
)
)
)
order by
ffvv.flex_valueConcatenate (inactive) to the description of inactive segment valuesUS8E2FF36EDED279D2E0530100007F1FF2GL Segment7Yselect
ffvv.flex_value value,
ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description
from
fnd_id_flex_segments_vl fifsgv,
fnd_flex_values_vl ffvv
where
gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and
fifsgv.application_id=101 and
fifsgv.id_flex_code='GL#' and
fifsgv.enabled_flag='Y' and
fifsgv.application_column_name='SEGMENT7' and
fifsgv.flex_value_set_id=ffvv.flex_value_set_id and
fifsgv.id_flex_num in (
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
fifsgv.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(+))
)
)
)
)
order by
ffvv.flex_valueConcatenate (inactive) to the description of inactive segment valuesUSB3D07BBAC1A245D7E0530100007FB1B8GL Segment8Yselect
ffvv.flex_value value,
ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description
from
fnd_id_flex_segments_vl fifsgv,
fnd_flex_values_vl ffvv
where
gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and
fifsgv.application_id=101 and
fifsgv.id_flex_code='GL#' and
fifsgv.enabled_flag='Y' and
fifsgv.application_column_name='SEGMENT8' and
fifsgv.flex_value_set_id=ffvv.flex_value_set_id and
fifsgv.id_flex_num in (
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
fifsgv.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(+))
)
)
)
)
order by
ffvv.flex_valueConcatenate (inactive) to the description of inactive segment valuesUSB3D07BBAC1A545D7E0530100007FB1B8GL Segment9Yselect
ffvv.flex_value value,
ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description
from
fnd_id_flex_segments_vl fifsgv,
fnd_flex_values_vl ffvv
where
gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and
fifsgv.application_id=101 and
fifsgv.id_flex_code='GL#' and
fifsgv.enabled_flag='Y' and
fifsgv.application_column_name='SEGMENT9' and
fifsgv.flex_value_set_id=ffvv.flex_value_set_id and
fifsgv.id_flex_num in (
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
fifsgv.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(+))
)
)
)
)
order by
ffvv.flex_valueConcatenate (inactive) to the description of inactive segment valuesUS8E2FF36EDEA679D2E0530100007F1FF2YesYselect 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dualUSF8F4DCB21E2E3403E0530100007FE628select
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,
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'YUAxxen_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.EnginaticsR12 onlyUpload1=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 dual
YUSUpload 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
ffvv.flex_value value,
ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description
from
fnd_id_flex_segments_vl fifsgv,
fnd_flex_values_vl ffvv
where
gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and
fifsgv.application_id=101 and
fifsgv.id_flex_code='GL#' and
fifsgv.enabled_flag='Y' and
fifsgv.application_column_name='SEGMENT1' and
fifsgv.flex_value_set_id=ffvv.flex_value_set_id and
fifsgv.id_flex_num in (
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
fifsgv.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(+))
)
)
)
)
order by
ffvv.flex_valueUSGL_SEGMENT16401=1gcck.segment1>=:segment1_fromLOVGL Segment18E2FF36EDECC79D2E0530100007F1FF2Yselect
ffvv.flex_value value,
ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description
from
fnd_id_flex_segments_vl fifsgv,
fnd_flex_values_vl ffvv
where
gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and
fifsgv.application_id=101 and
fifsgv.id_flex_code='GL#' and
fifsgv.enabled_flag='Y' and
fifsgv.application_column_name='SEGMENT1' and
fifsgv.flex_value_set_id=ffvv.flex_value_set_id and
fifsgv.id_flex_num in (
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
fifsgv.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(+))
)
)
)
)
order by
ffvv.flex_valueUSGL_SEGMENT1 From7501=1gcck.segment1<=:segment1_toLOVGL Segment18E2FF36EDECC79D2E0530100007F1FF2Yselect
ffvv.flex_value value,
ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description
from
fnd_id_flex_segments_vl fifsgv,
fnd_flex_values_vl ffvv
where
gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and
fifsgv.application_id=101 and
fifsgv.id_flex_code='GL#' and
fifsgv.enabled_flag='Y' and
fifsgv.application_column_name='SEGMENT1' and
fifsgv.flex_value_set_id=ffvv.flex_value_set_id and
fifsgv.id_flex_num in (
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
fifsgv.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(+))
)
)
)
)
order by
ffvv.flex_value:$flex$.gl_segment1_fromUSGL_SEGMENT1 To8601=1gcck.segment2=:segment2LOVGL Segment28E2FF36EDECD79D2E0530100007F1FF2Yselect
ffvv.flex_value value,
ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description
from
fnd_id_flex_segments_vl fifsgv,
fnd_flex_values_vl ffvv
where
gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and
fifsgv.application_id=101 and
fifsgv.id_flex_code='GL#' and
fifsgv.enabled_flag='Y' and
fifsgv.application_column_name='SEGMENT2' and
fifsgv.flex_value_set_id=ffvv.flex_value_set_id and
fifsgv.id_flex_num in (
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
fifsgv.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(+))
)
)
)
)
order by
ffvv.flex_valueUSGL_SEGMENT29701=1gcck.segment2>=:segment2_fromLOVGL Segment28E2FF36EDECD79D2E0530100007F1FF2Yselect
ffvv.flex_value value,
ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description
from
fnd_id_flex_segments_vl fifsgv,
fnd_flex_values_vl ffvv
where
gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and
fifsgv.application_id=101 and
fifsgv.id_flex_code='GL#' and
fifsgv.enabled_flag='Y' and
fifsgv.application_column_name='SEGMENT2' and
fifsgv.flex_value_set_id=ffvv.flex_value_set_id and
fifsgv.id_flex_num in (
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
fifsgv.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(+))
)
)
)
)
order by
ffvv.flex_valueUSGL_SEGMENT2 From10801=1gcck.segment2<=:segment2_toLOVGL Segment28E2FF36EDECD79D2E0530100007F1FF2Yselect
ffvv.flex_value value,
ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description
from
fnd_id_flex_segments_vl fifsgv,
fnd_flex_values_vl ffvv
where
gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and
fifsgv.application_id=101 and
fifsgv.id_flex_code='GL#' and
fifsgv.enabled_flag='Y' and
fifsgv.application_column_name='SEGMENT2' and
fifsgv.flex_value_set_id=ffvv.flex_value_set_id and
fifsgv.id_flex_num in (
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
fifsgv.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(+))
)
)
)
)
order by
ffvv.flex_value:$flex$.gl_segment2_fromUSGL_SEGMENT2 To11901=1gcck.segment3=:segment3LOVGL Segment38E2FF36EDECE79D2E0530100007F1FF2Yselect
ffvv.flex_value value,
ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description
from
fnd_id_flex_segments_vl fifsgv,
fnd_flex_values_vl ffvv
where
gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and
fifsgv.application_id=101 and
fifsgv.id_flex_code='GL#' and
fifsgv.enabled_flag='Y' and
fifsgv.application_column_name='SEGMENT3' and
fifsgv.flex_value_set_id=ffvv.flex_value_set_id and
fifsgv.id_flex_num in (
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
fifsgv.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(+))
)
)
)
)
order by
ffvv.flex_valueUSGL_SEGMENT3121001=1gcck.segment3>=:segment3_fromLOVGL Segment38E2FF36EDECE79D2E0530100007F1FF2Yselect
ffvv.flex_value value,
ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description
from
fnd_id_flex_segments_vl fifsgv,
fnd_flex_values_vl ffvv
where
gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and
fifsgv.application_id=101 and
fifsgv.id_flex_code='GL#' and
fifsgv.enabled_flag='Y' and
fifsgv.application_column_name='SEGMENT3' and
fifsgv.flex_value_set_id=ffvv.flex_value_set_id and
fifsgv.id_flex_num in (
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
fifsgv.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(+))
)
)
)
)
order by
ffvv.flex_valueUSGL_SEGMENT3 From131101=1gcck.segment3<=:segment3_toLOVGL Segment38E2FF36EDECE79D2E0530100007F1FF2Yselect
ffvv.flex_value value,
ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description
from
fnd_id_flex_segments_vl fifsgv,
fnd_flex_values_vl ffvv
where
gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and
fifsgv.application_id=101 and
fifsgv.id_flex_code='GL#' and
fifsgv.enabled_flag='Y' and
fifsgv.application_column_name='SEGMENT3' and
fifsgv.flex_value_set_id=ffvv.flex_value_set_id and
fifsgv.id_flex_num in (
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
fifsgv.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(+))
)
)
)
)
order by
ffvv.flex_value:$flex$.gl_segment3_fromUSGL_SEGMENT3 To141201=1gcck.segment4=:segment4LOVGL Segment48E2FF36EDECF79D2E0530100007F1FF2Yselect
ffvv.flex_value value,
ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description
from
fnd_id_flex_segments_vl fifsgv,
fnd_flex_values_vl ffvv
where
gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and
fifsgv.application_id=101 and
fifsgv.id_flex_code='GL#' and
fifsgv.enabled_flag='Y' and
fifsgv.application_column_name='SEGMENT4' and
fifsgv.flex_value_set_id=ffvv.flex_value_set_id and
fifsgv.id_flex_num in (
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
fifsgv.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(+))
)
)
)
)
order by
ffvv.flex_valueUSGL_SEGMENT4151301=1gcck.segment4>=:segment4_fromLOVGL Segment48E2FF36EDECF79D2E0530100007F1FF2Yselect
ffvv.flex_value value,
ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description
from
fnd_id_flex_segments_vl fifsgv,
fnd_flex_values_vl ffvv
where
gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and
fifsgv.application_id=101 and
fifsgv.id_flex_code='GL#' and
fifsgv.enabled_flag='Y' and
fifsgv.application_column_name='SEGMENT4' and
fifsgv.flex_value_set_id=ffvv.flex_value_set_id and
fifsgv.id_flex_num in (
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
fifsgv.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(+))
)
)
)
)
order by
ffvv.flex_valueUSGL_SEGMENT4 From161401=1gcck.segment4<=:segment4_toLOVGL Segment48E2FF36EDECF79D2E0530100007F1FF2Yselect
ffvv.flex_value value,
ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description
from
fnd_id_flex_segments_vl fifsgv,
fnd_flex_values_vl ffvv
where
gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and
fifsgv.application_id=101 and
fifsgv.id_flex_code='GL#' and
fifsgv.enabled_flag='Y' and
fifsgv.application_column_name='SEGMENT4' and
fifsgv.flex_value_set_id=ffvv.flex_value_set_id and
fifsgv.id_flex_num in (
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
fifsgv.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(+))
)
)
)
)
order by
ffvv.flex_value:$flex$.gl_segment4_fromUSGL_SEGMENT4 To171501=1gcck.segment5=:segment5LOVGL Segment58E2FF36EDED079D2E0530100007F1FF2Yselect
ffvv.flex_value value,
ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description
from
fnd_id_flex_segments_vl fifsgv,
fnd_flex_values_vl ffvv
where
gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and
fifsgv.application_id=101 and
fifsgv.id_flex_code='GL#' and
fifsgv.enabled_flag='Y' and
fifsgv.application_column_name='SEGMENT5' and
fifsgv.flex_value_set_id=ffvv.flex_value_set_id and
fifsgv.id_flex_num in (
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
fifsgv.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(+))
)
)
)
)
order by
ffvv.flex_valueUSGL_SEGMENT5181601=1gcck.segment5>=:segment5_fromLOVGL Segment58E2FF36EDED079D2E0530100007F1FF2Yselect
ffvv.flex_value value,
ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description
from
fnd_id_flex_segments_vl fifsgv,
fnd_flex_values_vl ffvv
where
gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and
fifsgv.application_id=101 and
fifsgv.id_flex_code='GL#' and
fifsgv.enabled_flag='Y' and
fifsgv.application_column_name='SEGMENT5' and
fifsgv.flex_value_set_id=ffvv.flex_value_set_id and
fifsgv.id_flex_num in (
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
fifsgv.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(+))
)
)
)
)
order by
ffvv.flex_valueUSGL_SEGMENT5 From191701=1gcck.segment5<=:segment5_toLOVGL Segment58E2FF36EDED079D2E0530100007F1FF2Yselect
ffvv.flex_value value,
ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description
from
fnd_id_flex_segments_vl fifsgv,
fnd_flex_values_vl ffvv
where
gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and
fifsgv.application_id=101 and
fifsgv.id_flex_code='GL#' and
fifsgv.enabled_flag='Y' and
fifsgv.application_column_name='SEGMENT5' and
fifsgv.flex_value_set_id=ffvv.flex_value_set_id and
fifsgv.id_flex_num in (
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
fifsgv.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(+))
)
)
)
)
order by
ffvv.flex_value:$flex$.gl_segment5_fromUSGL_SEGMENT5 To201801=1gcck.segment6=:segment6LOVGL Segment68E2FF36EDED179D2E0530100007F1FF2Yselect
ffvv.flex_value value,
ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description
from
fnd_id_flex_segments_vl fifsgv,
fnd_flex_values_vl ffvv
where
gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and
fifsgv.application_id=101 and
fifsgv.id_flex_code='GL#' and
fifsgv.enabled_flag='Y' and
fifsgv.application_column_name='SEGMENT6' and
fifsgv.flex_value_set_id=ffvv.flex_value_set_id and
fifsgv.id_flex_num in (
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
fifsgv.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(+))
)
)
)
)
order by
ffvv.flex_valueUSGL_SEGMENT6211901=1gcck.segment6>=:segment6_fromLOVGL Segment68E2FF36EDED179D2E0530100007F1FF2Yselect
ffvv.flex_value value,
ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description
from
fnd_id_flex_segments_vl fifsgv,
fnd_flex_values_vl ffvv
where
gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and
fifsgv.application_id=101 and
fifsgv.id_flex_code='GL#' and
fifsgv.enabled_flag='Y' and
fifsgv.application_column_name='SEGMENT6' and
fifsgv.flex_value_set_id=ffvv.flex_value_set_id and
fifsgv.id_flex_num in (
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
fifsgv.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(+))
)
)
)
)
order by
ffvv.flex_valueUSGL_SEGMENT6 From222001=1gcck.segment6<=:segment6_toLOVGL Segment68E2FF36EDED179D2E0530100007F1FF2Yselect
ffvv.flex_value value,
ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description
from
fnd_id_flex_segments_vl fifsgv,
fnd_flex_values_vl ffvv
where
gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and
fifsgv.application_id=101 and
fifsgv.id_flex_code='GL#' and
fifsgv.enabled_flag='Y' and
fifsgv.application_column_name='SEGMENT6' and
fifsgv.flex_value_set_id=ffvv.flex_value_set_id and
fifsgv.id_flex_num in (
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
fifsgv.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(+))
)
)
)
)
order by
ffvv.flex_value:$flex$.gl_segment6_fromUSGL_SEGMENT6 To232101=1gcck.segment7>=:segment7LOVGL Segment78E2FF36EDED279D2E0530100007F1FF2Yselect
ffvv.flex_value value,
ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description
from
fnd_id_flex_segments_vl fifsgv,
fnd_flex_values_vl ffvv
where
gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and
fifsgv.application_id=101 and
fifsgv.id_flex_code='GL#' and
fifsgv.enabled_flag='Y' and
fifsgv.application_column_name='SEGMENT7' and
fifsgv.flex_value_set_id=ffvv.flex_value_set_id and
fifsgv.id_flex_num in (
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
fifsgv.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(+))
)
)
)
)
order by
ffvv.flex_valueUSGL_SEGMENT7242201=1gcck.segment7>=:segment7_fromLOVGL Segment78E2FF36EDED279D2E0530100007F1FF2Yselect
ffvv.flex_value value,
ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description
from
fnd_id_flex_segments_vl fifsgv,
fnd_flex_values_vl ffvv
where
gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and
fifsgv.application_id=101 and
fifsgv.id_flex_code='GL#' and
fifsgv.enabled_flag='Y' and
fifsgv.application_column_name='SEGMENT7' and
fifsgv.flex_value_set_id=ffvv.flex_value_set_id and
fifsgv.id_flex_num in (
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
fifsgv.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(+))
)
)
)
)
order by
ffvv.flex_valueUSGL_SEGMENT7 From252301=1gcck.segment7<=:segment7_toLOVGL Segment78E2FF36EDED279D2E0530100007F1FF2Yselect
ffvv.flex_value value,
ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description
from
fnd_id_flex_segments_vl fifsgv,
fnd_flex_values_vl ffvv
where
gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and
fifsgv.application_id=101 and
fifsgv.id_flex_code='GL#' and
fifsgv.enabled_flag='Y' and
fifsgv.application_column_name='SEGMENT7' and
fifsgv.flex_value_set_id=ffvv.flex_value_set_id and
fifsgv.id_flex_num in (
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
fifsgv.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(+))
)
)
)
)
order by
ffvv.flex_value:$flex$.gl_segment7_fromUSGL_SEGMENT7 To262401=1gcck.segment8=:segment8LOVGL Segment8B3D07BBAC1A245D7E0530100007FB1B8Yselect
ffvv.flex_value value,
ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description
from
fnd_id_flex_segments_vl fifsgv,
fnd_flex_values_vl ffvv
where
gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and
fifsgv.application_id=101 and
fifsgv.id_flex_code='GL#' and
fifsgv.enabled_flag='Y' and
fifsgv.application_column_name='SEGMENT8' and
fifsgv.flex_value_set_id=ffvv.flex_value_set_id and
fifsgv.id_flex_num in (
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
fifsgv.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(+))
)
)
)
)
order by
ffvv.flex_valueUSGL_SEGMENT8272501=1gcck.segment8>=:segment8_fromLOVGL Segment8B3D07BBAC1A245D7E0530100007FB1B8Yselect
ffvv.flex_value value,
ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description
from
fnd_id_flex_segments_vl fifsgv,
fnd_flex_values_vl ffvv
where
gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and
fifsgv.application_id=101 and
fifsgv.id_flex_code='GL#' and
fifsgv.enabled_flag='Y' and
fifsgv.application_column_name='SEGMENT8' and
fifsgv.flex_value_set_id=ffvv.flex_value_set_id and
fifsgv.id_flex_num in (
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
fifsgv.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(+))
)
)
)
)
order by
ffvv.flex_valueUSGL_SEGMENT8 From282601=1gcck.segment8<=:segment8_toLOVGL Segment8B3D07BBAC1A245D7E0530100007FB1B8Yselect
ffvv.flex_value value,
ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description
from
fnd_id_flex_segments_vl fifsgv,
fnd_flex_values_vl ffvv
where
gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and
fifsgv.application_id=101 and
fifsgv.id_flex_code='GL#' and
fifsgv.enabled_flag='Y' and
fifsgv.application_column_name='SEGMENT8' and
fifsgv.flex_value_set_id=ffvv.flex_value_set_id and
fifsgv.id_flex_num in (
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
fifsgv.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(+))
)
)
)
)
order by
ffvv.flex_value:$flex$.gl_segment8_fromUSGL_SEGMENT8 To292701=1gcck.segment9=:segment9LOVGL Segment9B3D07BBAC1A545D7E0530100007FB1B8Yselect
ffvv.flex_value value,
ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description
from
fnd_id_flex_segments_vl fifsgv,
fnd_flex_values_vl ffvv
where
gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and
fifsgv.application_id=101 and
fifsgv.id_flex_code='GL#' and
fifsgv.enabled_flag='Y' and
fifsgv.application_column_name='SEGMENT9' and
fifsgv.flex_value_set_id=ffvv.flex_value_set_id and
fifsgv.id_flex_num in (
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
fifsgv.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(+))
)
)
)
)
order by
ffvv.flex_valueUSGL_SEGMENT9302801=1gcck.segment9>=:segment9_fromLOVGL Segment9B3D07BBAC1A545D7E0530100007FB1B8Yselect
ffvv.flex_value value,
ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description
from
fnd_id_flex_segments_vl fifsgv,
fnd_flex_values_vl ffvv
where
gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and
fifsgv.application_id=101 and
fifsgv.id_flex_code='GL#' and
fifsgv.enabled_flag='Y' and
fifsgv.application_column_name='SEGMENT9' and
fifsgv.flex_value_set_id=ffvv.flex_value_set_id and
fifsgv.id_flex_num in (
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
fifsgv.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(+))
)
)
)
)
order by
ffvv.flex_valueUSGL_SEGMENT9 From312901=1gcck.segment9<=:segment9_toLOVGL Segment9B3D07BBAC1A545D7E0530100007FB1B8Yselect
ffvv.flex_value value,
ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description
from
fnd_id_flex_segments_vl fifsgv,
fnd_flex_values_vl ffvv
where
gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and
fifsgv.application_id=101 and
fifsgv.id_flex_code='GL#' and
fifsgv.enabled_flag='Y' and
fifsgv.application_column_name='SEGMENT9' and
fifsgv.flex_value_set_id=ffvv.flex_value_set_id and
fifsgv.id_flex_num in (
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
fifsgv.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(+))
)
)
)
)
order by
ffvv.flex_value:$flex$.gl_segment9_fromUSGL_SEGMENT9 To323001=1gcck.segment10=:segment10LOVGL Segment10B3D07BBAC1A645D7E0530100007FB1B8Yselect
ffvv.flex_value value,
ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description
from
fnd_id_flex_segments_vl fifsgv,
fnd_flex_values_vl ffvv
where
gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and
fifsgv.application_id=101 and
fifsgv.id_flex_code='GL#' and
fifsgv.enabled_flag='Y' and
fifsgv.application_column_name='SEGMENT10' and
fifsgv.flex_value_set_id=ffvv.flex_value_set_id and
fifsgv.id_flex_num in (
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
fifsgv.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(+))
)
)
)
)
order by
ffvv.flex_valueUSGL_SEGMENT10333101=1gcck.segment10>=:segment10_fromLOVGL Segment10B3D07BBAC1A645D7E0530100007FB1B8Yselect
ffvv.flex_value value,
ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description
from
fnd_id_flex_segments_vl fifsgv,
fnd_flex_values_vl ffvv
where
gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and
fifsgv.application_id=101 and
fifsgv.id_flex_code='GL#' and
fifsgv.enabled_flag='Y' and
fifsgv.application_column_name='SEGMENT10' and
fifsgv.flex_value_set_id=ffvv.flex_value_set_id and
fifsgv.id_flex_num in (
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
fifsgv.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(+))
)
)
)
)
order by
ffvv.flex_valueUSGL_SEGMENT10 From343201=1gcck.segment10<=:segment10_toLOVGL Segment10B3D07BBAC1A645D7E0530100007FB1B8Yselect
ffvv.flex_value value,
ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description
from
fnd_id_flex_segments_vl fifsgv,
fnd_flex_values_vl ffvv
where
gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and
fifsgv.application_id=101 and
fifsgv.id_flex_code='GL#' and
fifsgv.enabled_flag='Y' and
fifsgv.application_column_name='SEGMENT10' and
fifsgv.flex_value_set_id=ffvv.flex_value_set_id and
fifsgv.id_flex_num in (
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
fifsgv.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(+))
)
)
)
)
order by
ffvv.flex_value:$flex$.gl_segment10_fromUSGL_SEGMENT10 To353301=1gcck.segment11>=:segment11_fromLOVGL Segment113CF0AFFEDB407EB4E0630100007F9A70Yselect
ffvv.flex_value value,
ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description
from
fnd_id_flex_segments_vl fifsgv,
fnd_flex_values_vl ffvv
where
gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and
fifsgv.application_id=101 and
fifsgv.id_flex_code='GL#' and
fifsgv.enabled_flag='Y' and
fifsgv.application_column_name='SEGMENT11' and
fifsgv.flex_value_set_id=ffvv.flex_value_set_id and
fifsgv.id_flex_num in (
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
fifsgv.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(+))
)
)
)
)
order by
ffvv.flex_valueUSGL_SEGMENT11 From363401=1gcck.segment11<=:segment11_toLOVGL Segment113CF0AFFEDB407EB4E0630100007F9A70Yselect
ffvv.flex_value value,
ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description
from
fnd_id_flex_segments_vl fifsgv,
fnd_flex_values_vl ffvv
where
gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and
fifsgv.application_id=101 and
fifsgv.id_flex_code='GL#' and
fifsgv.enabled_flag='Y' and
fifsgv.application_column_name='SEGMENT11' and
fifsgv.flex_value_set_id=ffvv.flex_value_set_id and
fifsgv.id_flex_num in (
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
fifsgv.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(+))
)
)
)
)
order by
ffvv.flex_value:$flex$.gl_segment11_fromUSGL_SEGMENT11 To373501=1gcck.segment12>=:segment12_fromLOVGL Segment123CF0AFFEDB417EB4E0630100007F9A70Yselect
ffvv.flex_value value,
ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description
from
fnd_id_flex_segments_vl fifsgv,
fnd_flex_values_vl ffvv
where
gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and
fifsgv.application_id=101 and
fifsgv.id_flex_code='GL#' and
fifsgv.enabled_flag='Y' and
fifsgv.application_column_name='SEGMENT12' and
fifsgv.flex_value_set_id=ffvv.flex_value_set_id and
fifsgv.id_flex_num in (
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
fifsgv.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(+))
)
)
)
)
order by
ffvv.flex_valueUSGL_SEGMENT12 From383601=1gcck.segment12<=:segment12_toLOVGL Segment123CF0AFFEDB417EB4E0630100007F9A70Yselect
ffvv.flex_value value,
ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description
from
fnd_id_flex_segments_vl fifsgv,
fnd_flex_values_vl ffvv
where
gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and
fifsgv.application_id=101 and
fifsgv.id_flex_code='GL#' and
fifsgv.enabled_flag='Y' and
fifsgv.application_column_name='SEGMENT12' and
fifsgv.flex_value_set_id=ffvv.flex_value_set_id and
fifsgv.id_flex_num in (
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
fifsgv.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(+))
)
)
)
)
order by
ffvv.flex_value:$flex$.gl_segment12_fromUSGL_SEGMENT12 To:$flex$.gl_segment10_fromGL_SEGMENT10 FromGL_SEGMENT10 To:$flex$.gl_segment11_fromGL_SEGMENT11 FromGL_SEGMENT11 To:$flex$.gl_segment12_fromGL_SEGMENT12 FromGL_SEGMENT12 To:$flex$.gl_segment1_fromGL_SEGMENT1 FromGL_SEGMENT1 To:$flex$.gl_segment2_fromGL_SEGMENT2 FromGL_SEGMENT2 To:$flex$.gl_segment3_fromGL_SEGMENT3 FromGL_SEGMENT3 To:$flex$.gl_segment4_fromGL_SEGMENT4 FromGL_SEGMENT4 To:$flex$.gl_segment5_fromGL_SEGMENT5 FromGL_SEGMENT5 To:$flex$.gl_segment6_fromGL_SEGMENT6 FromGL_SEGMENT6 To:$flex$.gl_segment7_fromGL_SEGMENT7 FromGL_SEGMENT7 To:$flex$.gl_segment8_fromGL_SEGMENT8 FromGL_SEGMENT8 To:$flex$.gl_segment9_fromGL_SEGMENT9 FromGL_SEGMENT9 To:$flex$.ledgerLedgerGL_SEGMENT1:$flex$.ledgerLedgerGL_SEGMENT1 From:$flex$.ledgerLedgerGL_SEGMENT1 To:$flex$.ledgerLedgerGL_SEGMENT10:$flex$.ledgerLedgerGL_SEGMENT10 From:$flex$.ledgerLedgerGL_SEGMENT10 To:$flex$.ledgerLedgerGL_SEGMENT11 From:$flex$.ledgerLedgerGL_SEGMENT11 To:$flex$.ledgerLedgerGL_SEGMENT12 From:$flex$.ledgerLedgerGL_SEGMENT12 To:$flex$.ledgerLedgerGL_SEGMENT2:$flex$.ledgerLedgerGL_SEGMENT2 From:$flex$.ledgerLedgerGL_SEGMENT2 To:$flex$.ledgerLedgerGL_SEGMENT3:$flex$.ledgerLedgerGL_SEGMENT3 From:$flex$.ledgerLedgerGL_SEGMENT3 To:$flex$.ledgerLedgerGL_SEGMENT4:$flex$.ledgerLedgerGL_SEGMENT4 From:$flex$.ledgerLedgerGL_SEGMENT4 To:$flex$.ledgerLedgerGL_SEGMENT5:$flex$.ledgerLedgerGL_SEGMENT5 From:$flex$.ledgerLedgerGL_SEGMENT5 To:$flex$.ledgerLedgerGL_SEGMENT6:$flex$.ledgerLedgerGL_SEGMENT6 From:$flex$.ledgerLedgerGL_SEGMENT6 To:$flex$.ledgerLedgerGL_SEGMENT7:$flex$.ledgerLedgerGL_SEGMENT7 From:$flex$.ledgerLedgerGL_SEGMENT7 To:$flex$.ledgerLedgerGL_SEGMENT8:$flex$.ledgerLedgerGL_SEGMENT8 From:$flex$.ledgerLedgerGL_SEGMENT8 To:$flex$.ledgerLedgerGL_SEGMENT9:$flex$.ledgerLedgerGL_SEGMENT9 From:$flex$.ledgerLedgerGL_SEGMENT9 To:$flex$.ledgerLedgerSegment Delimiter1ACTION_Charvarchar22STATUS_Charvarchar23MESSAGE_Charvarchar24MODIFIED_COLUMNS_Charvarchar2Y5LEDGERCharvarchar2:$flex$.ledgerY6CONCATENATED_SEGMENTSCharvarchar2Enter 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_TYPECharvarchar2Derived during account creation, non-updateable9GL_SEGMENT1LOV customvarchar2Yselect distinct
ffvv.flex_value value,
ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description
from
fnd_id_flex_segments_vl fifsgv,
fnd_flex_values_vl ffvv
where
gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and
fifsgv.application_id=101 and
fifsgv.id_flex_code='GL#' and
fifsgv.enabled_flag='Y' and
fifsgv.application_column_name='SEGMENT1' 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 in (
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
fifsgv.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(+))
)
)
)
)
order by
ffvv.flex_valuexxen_util.instring(:$column$.concatenated_segments,:$flex$.segment_delimiter,1)Y10GL_SEGMENT2LOV customvarchar2Yselect distinct
ffvv.flex_value value,
ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description
from
fnd_id_flex_segments_vl fifsgv,
fnd_flex_values_vl ffvv
where
gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and
fifsgv.application_id=101 and
fifsgv.id_flex_code='GL#' and
fifsgv.enabled_flag='Y' and
fifsgv.application_column_name='SEGMENT2' 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 in (
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
fifsgv.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(+))
)
)
)
)
order by
ffvv.flex_valuexxen_util.instring(:$column$.concatenated_segments,:$flex$.segment_delimiter,2)Y11GL_SEGMENT3LOV customvarchar2Yselect distinct
ffvv.flex_value value,
ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description
from
fnd_id_flex_segments_vl fifsgv,
fnd_flex_values_vl ffvv
where
gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and
fifsgv.application_id=101 and
fifsgv.id_flex_code='GL#' and
fifsgv.enabled_flag='Y' and
fifsgv.application_column_name='SEGMENT3' 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 in (
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
fifsgv.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(+))
)
)
)
)
order by
ffvv.flex_valuexxen_util.instring(:$column$.concatenated_segments,:$flex$.segment_delimiter,3)Y12GL_SEGMENT4LOV customvarchar2Yselect distinct
ffvv.flex_value value,
ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description
from
fnd_id_flex_segments_vl fifsgv,
fnd_flex_values_vl ffvv
where
gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and
fifsgv.application_id=101 and
fifsgv.id_flex_code='GL#' and
fifsgv.enabled_flag='Y' and
fifsgv.application_column_name='SEGMENT4' 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 in (
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
fifsgv.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(+))
)
)
)
)
order by
ffvv.flex_valuexxen_util.instring(:$column$.concatenated_segments,:$flex$.segment_delimiter,4)Y13GL_SEGMENT5LOV customvarchar2Yselect distinct
ffvv.flex_value value,
ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description
from
fnd_id_flex_segments_vl fifsgv,
fnd_flex_values_vl ffvv
where
gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and
fifsgv.application_id=101 and
fifsgv.id_flex_code='GL#' and
fifsgv.enabled_flag='Y' and
fifsgv.application_column_name='SEGMENT5' 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 in (
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
fifsgv.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(+))
)
)
)
)
order by
ffvv.flex_valuexxen_util.instring(:$column$.concatenated_segments,:$flex$.segment_delimiter,5)Y14GL_SEGMENT6LOV customvarchar2Yselect distinct
ffvv.flex_value value,
ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description
from
fnd_id_flex_segments_vl fifsgv,
fnd_flex_values_vl ffvv
where
gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and
fifsgv.application_id=101 and
fifsgv.id_flex_code='GL#' and
fifsgv.enabled_flag='Y' and
fifsgv.application_column_name='SEGMENT6' and
ffvv.enabled_flag='Y' and
sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) and
fifsgv.flex_value_set_id=ffvv.flex_value_set_id and
fifsgv.id_flex_num in (
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
fifsgv.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(+))
)
)
)
)
order by
ffvv.flex_valuexxen_util.instring(:$column$.concatenated_segments,:$flex$.segment_delimiter,6)Y15GL_SEGMENT7LOV customvarchar2Yselect distinct
ffvv.flex_value value,
ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description
from
fnd_id_flex_segments_vl fifsgv,
fnd_flex_values_vl ffvv
where
gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and
fifsgv.application_id=101 and
fifsgv.id_flex_code='GL#' and
fifsgv.enabled_flag='Y' and
fifsgv.application_column_name='SEGMENT7' 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 in (
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
fifsgv.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(+))
)
)
)
)
order by
ffvv.flex_valuexxen_util.instring(:$column$.concatenated_segments,:$flex$.segment_delimiter,7)Y16GL_SEGMENT8LOV customvarchar2Yselect distinct
ffvv.flex_value value,
ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description
from
fnd_id_flex_segments_vl fifsgv,
fnd_flex_values_vl ffvv
where
gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and
fifsgv.application_id=101 and
fifsgv.id_flex_code='GL#' and
fifsgv.enabled_flag='Y' and
fifsgv.application_column_name='SEGMENT8' 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 in (
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
fifsgv.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(+))
)
)
)
)
order by
ffvv.flex_valuexxen_util.instring(:$column$.concatenated_segments,:$flex$.segment_delimiter,8)Y17GL_SEGMENT9LOV customvarchar2Yselect distinct
ffvv.flex_value value,
ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description
from
fnd_id_flex_segments_vl fifsgv,
fnd_flex_values_vl ffvv
where
gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and
fifsgv.application_id=101 and
fifsgv.id_flex_code='GL#' and
fifsgv.enabled_flag='Y' and
fifsgv.application_column_name='SEGMENT9' 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 in (
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
fifsgv.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(+))
)
)
)
)
order by
ffvv.flex_valuexxen_util.instring(:$column$.concatenated_segments,:$flex$.segment_delimiter,9)Y18GL_SEGMENT10LOV customvarchar2Yselect distinct
ffvv.flex_value value,
ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description
from
fnd_id_flex_segments_vl fifsgv,
fnd_flex_values_vl ffvv
where
gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and
fifsgv.application_id=101 and
fifsgv.id_flex_code='GL#' and
fifsgv.enabled_flag='Y' and
fifsgv.application_column_name='SEGMENT10' 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 in (
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
fifsgv.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(+))
)
)
)
)
order by
ffvv.flex_valuexxen_util.instring(:$column$.concatenated_segments,:$flex$.segment_delimiter,10)Y19GL_SEGMENT11LOV customvarchar2Yselect distinct
ffvv.flex_value value,
ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description
from
fnd_id_flex_segments_vl fifsgv,
fnd_flex_values_vl ffvv
where
gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and
fifsgv.application_id=101 and
fifsgv.id_flex_code='GL#' and
fifsgv.enabled_flag='Y' and
fifsgv.application_column_name='SEGMENT11' 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 in (
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
fifsgv.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(+))
)
)
)
)
order by
ffvv.flex_valuexxen_util.instring(:$column$.concatenated_segments,:$flex$.segment_delimiter,11)Y20GL_SEGMENT12LOV customvarchar2Yselect distinct
ffvv.flex_value value,
ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description
from
fnd_id_flex_segments_vl fifsgv,
fnd_flex_values_vl ffvv
where
gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and
fifsgv.application_id=101 and
fifsgv.id_flex_code='GL#' and
fifsgv.enabled_flag='Y' and
fifsgv.application_column_name='SEGMENT12' 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 in (
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
fifsgv.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(+))
)
)
)
)
order by
ffvv.flex_valuexxen_util.instring(:$column$.concatenated_segments,:$flex$.segment_delimiter,12)Y21GL_SEGMENT13LOV customvarchar2Yselect distinct
ffvv.flex_value value,
ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description
from
fnd_id_flex_segments_vl fifsgv,
fnd_flex_values_vl ffvv
where
gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and
fifsgv.application_id=101 and
fifsgv.id_flex_code='GL#' and
fifsgv.enabled_flag='Y' and
fifsgv.application_column_name='SEGMENT13' 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 in (
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
fifsgv.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(+))
)
)
)
)
order by
ffvv.flex_valuexxen_util.instring(:$column$.concatenated_segments,:$flex$.segment_delimiter,13)Y22GL_SEGMENT14LOV customvarchar2Yselect distinct
ffvv.flex_value value,
ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description
from
fnd_id_flex_segments_vl fifsgv,
fnd_flex_values_vl ffvv
where
gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and
fifsgv.application_id=101 and
fifsgv.id_flex_code='GL#' and
fifsgv.enabled_flag='Y' and
fifsgv.application_column_name='SEGMENT14' 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 in (
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
fifsgv.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(+))
)
)
)
)
order by
ffvv.flex_valuexxen_util.instring(:$column$.concatenated_segments,:$flex$.segment_delimiter,14)Y23GL_SEGMENT15LOV customvarchar2Yselect distinct
ffvv.flex_value value,
ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description
from
fnd_id_flex_segments_vl fifsgv,
fnd_flex_values_vl ffvv
where
gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and
fifsgv.application_id=101 and
fifsgv.id_flex_code='GL#' and
fifsgv.enabled_flag='Y' and
fifsgv.application_column_name='SEGMENT15' 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 in (
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
fifsgv.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(+))
)
)
)
)
order by
ffvv.flex_valuexxen_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 updated30CODE_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_ALLOWEDU9p_alternate_account_ccidinCharU10p_balanced_budget_flaginCharU11p_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_segment30inCharU42status_outCharSTATUS_CODE_U43message_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(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(+)Default value:$column$.concatenated_segmentsCONCATENATED_SEGMENTSDESCRIPTIONDefault value:$flex$.ledgerLedger|1=1|DESCRIPTIONDefault value:$flex$.segment_delimiterSegment Delimiter|1=1|DESCRIPTIONDefault value:$column$.concatenated_segmentsCONCATENATED_SEGMENTSGL_SEGMENT1LOV query:$flex$.ledgerLedger|1=1|GL_SEGMENT1Default value:$flex$.segment_delimiterSegment Delimiter|1=1|GL_SEGMENT1Default value:$column$.concatenated_segmentsCONCATENATED_SEGMENTSGL_SEGMENT10LOV query:$flex$.ledgerLedger|1=1|GL_SEGMENT10Default value:$flex$.segment_delimiterSegment Delimiter|1=1|GL_SEGMENT10Default value:$column$.concatenated_segmentsCONCATENATED_SEGMENTSGL_SEGMENT11LOV query:$flex$.ledgerLedger|1=1|GL_SEGMENT11Default value:$flex$.segment_delimiterSegment Delimiter|1=1|GL_SEGMENT11Default value:$column$.concatenated_segmentsCONCATENATED_SEGMENTSGL_SEGMENT12LOV query:$flex$.ledgerLedger|1=1|GL_SEGMENT12Default value:$flex$.segment_delimiterSegment Delimiter|1=1|GL_SEGMENT12Default value:$column$.concatenated_segmentsCONCATENATED_SEGMENTSGL_SEGMENT13LOV query:$flex$.ledgerLedger|1=1|GL_SEGMENT13Default value:$flex$.segment_delimiterSegment Delimiter|1=1|GL_SEGMENT13Default value:$column$.concatenated_segmentsCONCATENATED_SEGMENTSGL_SEGMENT14LOV query:$flex$.ledgerLedger|1=1|GL_SEGMENT14Default value:$flex$.segment_delimiterSegment Delimiter|1=1|GL_SEGMENT14Default value:$column$.concatenated_segmentsCONCATENATED_SEGMENTSGL_SEGMENT15LOV query:$flex$.ledgerLedger|1=1|GL_SEGMENT15Default value:$flex$.segment_delimiterSegment Delimiter|1=1|GL_SEGMENT15Default value:$column$.concatenated_segmentsCONCATENATED_SEGMENTSGL_SEGMENT2LOV query:$flex$.ledgerLedger|1=1|GL_SEGMENT2Default value:$flex$.segment_delimiterSegment Delimiter|1=1|GL_SEGMENT2Default value:$column$.concatenated_segmentsCONCATENATED_SEGMENTSGL_SEGMENT3LOV query:$flex$.ledgerLedger|1=1|GL_SEGMENT3Default value:$flex$.segment_delimiterSegment Delimiter|1=1|GL_SEGMENT3Default value:$column$.concatenated_segmentsCONCATENATED_SEGMENTSGL_SEGMENT4LOV query:$flex$.ledgerLedger|1=1|GL_SEGMENT4Default value:$flex$.segment_delimiterSegment Delimiter|1=1|GL_SEGMENT4Default value:$column$.concatenated_segmentsCONCATENATED_SEGMENTSGL_SEGMENT5LOV query:$flex$.ledgerLedger|1=1|GL_SEGMENT5Default value:$flex$.segment_delimiterSegment Delimiter|1=1|GL_SEGMENT5Default value:$column$.concatenated_segmentsCONCATENATED_SEGMENTSGL_SEGMENT6LOV query:$flex$.ledgerLedger|1=1|GL_SEGMENT6Default value:$flex$.segment_delimiterSegment Delimiter|1=1|GL_SEGMENT6Default value:$column$.concatenated_segmentsCONCATENATED_SEGMENTSGL_SEGMENT7LOV query:$flex$.ledgerLedger|1=1|GL_SEGMENT7Default value:$flex$.segment_delimiterSegment Delimiter|1=1|GL_SEGMENT7Default value:$column$.concatenated_segmentsCONCATENATED_SEGMENTSGL_SEGMENT8LOV query:$flex$.ledgerLedger|1=1|GL_SEGMENT8Default value:$flex$.segment_delimiterSegment Delimiter|1=1|GL_SEGMENT8Default value:$column$.concatenated_segmentsCONCATENATED_SEGMENTSGL_SEGMENT9LOV query:$flex$.ledgerLedger|1=1|GL_SEGMENT9Default value:$flex$.segment_delimiterSegment Delimiter|1=1|GL_SEGMENT9Default value:$flex$.ledgerLedger|1=1|LEDGERExcel validation:$column$.action_ACTION_Excel validation:$column$.gl_segment1GL_SEGMENT1Excel validation:$column$.gl_segment10GL_SEGMENT10Excel validation:$column$.gl_segment11GL_SEGMENT11Excel validation:$column$.gl_segment12GL_SEGMENT12Excel validation:$column$.gl_segment13GL_SEGMENT13Excel validation:$column$.gl_segment14GL_SEGMENT14Excel validation:$column$.gl_segment15GL_SEGMENT15Excel validation:$column$.gl_segment2GL_SEGMENT2Excel validation:$column$.gl_segment3GL_SEGMENT3Excel validation:$column$.gl_segment4GL_SEGMENT4Excel validation:$column$.gl_segment5GL_SEGMENT5Excel validation:$column$.gl_segment6GL_SEGMENT6Excel validation:$column$.gl_segment7GL_SEGMENT7Excel validation:$column$.gl_segment8GL_SEGMENT8Excel validation:$column$.gl_segment9GL_SEGMENT9Excel validation:$column$.ledgerLEDGER