ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDE8479D2E0530100007F1FF2 FND User Name Y Y select fu.user_name value, trim(coalesce( trim(papf.first_name||' '||papf.last_name), fu.description, fu.email_address, papf.email_address )||fu.inactive) description from (select case when sysdate between fu.start_date and nvl(fu.end_date,sysdate) then null else ' (inactive)' end inactive, fu.* from fnd_user fu) fu, (select papf.* from per_all_people_f papf where sysdate between papf.effective_start_date and papf.effective_end_date) papf, ( select distinct furg.user_id, count(*) over (partition by furg.user_id) resp_count, max(fr.responsibility_key) over (partition by furg.user_id) max_responsibility_key from fnd_responsibility fr, fnd_user_resp_groups_direct furg where fr.responsibility_id=furg.responsibility_id and fr.application_id=furg.responsibility_application_id ) furg where fu.employee_id=papf.person_id(+) and fu.user_id=furg.user_id(+) and not (furg.resp_count=1 and furg.max_responsibility_key='IRC_EXT_CANDIDATE') order by fu.inactive desc, fu.user_name US FND user names, excluding iRecruitment candidates. 8E2FF36EDEB879D2E0530100007F1FF2 GL Ledger Y select 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.name AR دفاتر الأستاذ المقيدة بمجموعة الوصول ، المحددة بواسطة قيمة الملف الشخصي "مجموعة الوصول إلى بيانات GL" لمسؤولية تسجيل الدخول الحالية D Ledger, die durch das Zugriffsset eingeschränkt sind, definiert durch den Profilwert 'GL Data Access Set' der aktuellen Anmeldeverantwortung E Libros 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 actual F Grands 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 actuelle I Libri mastri limitati dal set di accesso, definito dal valore del profilo 'GL Data Access Set' della responsabilità di login corrente JA 現在のログイン責任者のプロファイル値'GL Data Access Set'によって定義されたアクセスセットによって制限された元帳 KO 현재 로그인 권한의 프로파일 값 'GL 데이터 액세스 세트'로 정의 된 액세스 세트로 제한되는 원장 PTB Ledgers restritos pelo conjunto de acesso, definido pelo valor do perfil 'GL Data Access Set' da atual responsabilidade de login RU Леджеры, ограниченные набором доступа, определяемые значением профиля "GL Data Access Set" текущей ответственности за вход в систему S Ledgers begränsade av åtkomstuppsättning, definierade av profilvärde 'GL Data Access Set' för det aktuella inloggningsansvaret TR Mevcut oturum açma sorumluluğunun profil değeri 'GL Veri Erişim Kümesi' ile tanımlanan erişim kümesiyle kısıtlanmış defterler US Ledgers restricted by access set, defined by profile value 'GL Data Access Set' of the current login responsibility ZHS 由访问集限制的分类账，由当前登录责任的配置文件值 "GL数据访问集 "定义。 0092EAD2F4F36C61E0630100007FAB89 HR Employee Y Y select he.full_name value, he.employee_num description from hr_employees he order by he.full_name US 0087D0A1D042F831E0630100007F0109 HR Location Y select hl.location_code value, hl.description||' ('||hl.address_line_1||', '||hl.town_or_city||', '||ftv.territory_short_name||')' description from hr_locations hl, fnd_territories_vl ftv where hl.country=ftv.territory_code(+) order by hl.location_code US 8E2FF36EDEB979D2E0530100007F1FF2 HR Operating Unit Y select hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and hou.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) order by hou.name Fixed where clause duplication AR وحدة التشغيل مقيدة بالتحكم في الوصول متعدد المنظمات (MOAC) D Bedieneinheit eingeschränkt durch Multi Org Access Control (MOAC) E Unidad operativa restringida por el control de acceso multiorgánico (MOAC) F Unité opérationnelle restreinte par un contrôle d'accès multi-organismes (MOAC) I Unità operativa limitata dal controllo di accesso multiorgano (MOAC) JA 多機関アクセス制御(MOAC)で制限された操作ユニット KO 다중 조직 액세스 제어 (MOAC)에 의해 제한되는 운영 단위 PTB Unidade operacional restrita por controle de acesso multi org (MOAC) RU Операционное устройство, ограниченное мультиорганизованным контролем доступа (MOAC) S Styrenhet begränsad av multi-org access control (MOAC) TR Çoklu kuruluş erişim kontrolü (MOAC) tarafından kısıtlanan işletim birimi US Operating unit restricted by multi org access control (MOAC) ZHS 受多机构访问控制（MOAC）限制的操作单元。 8E2FF36EDECA79D2E0530100007F1FF2 INV Category Set Y select distinct mcsv.category_set_name value, mcsv.description from mtl_category_sets_vl mcsv where :$flex$.organization_code is null or mcsv.category_set_id in (select mic.category_set_id from mtl_parameters mp, mtl_item_categories mic where xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y' and mp.organization_id=mic.organization_id) order by mcsv.category_set_name US 8E2FF36EDEB279D2E0530100007F1FF2 INV Organization Code Y select ood.organization_code value, ood.organization_name||' ('||ftv.territory_short_name||', '||hla.town_or_city||decode(mp.organization_id,mp.master_organization_id,null,', '||mp0.organization_code)||')' description from org_organization_definitions ood, mtl_parameters mp, mtl_parameters mp0, hr_all_organization_units haou, hr_locations_all hla, fnd_territories_vl ftv where ood.organization_id=mp.organization_id and mp.organization_id<>mp.master_organization_id and ( ood.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) or not exists (select null from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) and ood.operating_unit in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) ) and (:$flex$.operating_unit is null or ood.operating_unit in (select haouv.organization_id from hr_all_organization_units_vl haouv where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y')) and (:$flex$.ledger is null or ood.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and nvl(ood.disable_date,sysdate)>=sysdate and mp.master_organization_id=mp0.organization_id and ood.organization_id=haou.organization_id(+) and haou.location_id=hla.location_id(+) and hla.country=ftv.territory_code(+) order by ood.organization_code AR جميع أكواد تنظيم المخزون النشط باستثناء المؤسسات الرئيسية ، مقيدة بعرض الوصول إلى مؤسسة المستخدم الحالي D Alle aktiven Inventar-Organisationscodes mit Ausnahme von Master-Organisationen, beschränkt auf die Org-Zugriffsansicht des aktuellen Benutzers E Todos los códigos de organización de inventario activos, excluyendo las organizaciones maestras, restringidos a la vista de acceso a la organización del usuario actual F Tous les codes d'organisation de l'inventaire actif, à l'exclusion des organisations maîtresses, limités à la vue d'accès à l'organisation de l'utilisateur actuel I Tutti i codici di organizzazione dell'inventario attivi, escluse le organizzazioni master, limitati alla vista di accesso all'org dell'utente corrente JA すべてのアクティブなインベントリの組織コードは、マスター組織を除いて、現在のユーザーの組織のアクセスビューに制限されます。 KO 현재 사용자의 조직 액세스보기로 제한되는 마스터 조직을 제외한 모든 활성 재고 조직 코드 PTB Todos os códigos ativos de organização de inventário, excluindo organizações mestre, restritos à visão de acesso org do usuário atual RU Все активные инвентаризационные организационные коды, исключая основные организации, ограниченные текущим представлением доступа пользователя к оргструктуре. S Alla aktiva lagerorganisationskoder exklusive huvudorganisationer, begränsade till den aktuella användarens organisationsåtkomstvy TR Ana organizasyonlar hariç tüm aktif envanter organizasyon kodları, mevcut kullanıcının organizasyon erişim görünümü ile sınırlıdır US All active inventory organization codes excluding master organizations, restricted to the current user's org access view ZHS 所有活动的清单组织代码，不包括主组织，仅限于当前用户的组织访问视图。 0087D0A1D043F831E0630100007F0109 PO Requisition Number Y Y select prha.segment1 value, prha.description from hr_all_organization_units_vl haouv, po_requisition_headers_all prha, po_system_parameters_all pspa where prha.org_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) and (:$flex$.operating_unit is null or xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y') and haouv.organization_id=prha.org_id and prha.org_id=pspa.org_id and nvl(prha.authorization_status,'INCOMPLETE')<>'SYSTEM_SAVED' order by haouv.name, decode(pspa.manual_req_num_type,'NUMERIC',to_number(prha.segment1)), prha.segment1 Fixed bug in operating unit access restriction when the default operating unit is set to something else US 8E2FF36EDEA679D2E0530100007F1FF2 Yes Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US C033C2D455F00791E0530100007FC526 with req as ( select /*+ push_pred(x) */ haouv.name operating_unit, xxen_util.meaning(prha.type_lookup_code,'REQUISITION TYPE',201) requisition_type, prha.segment1 requisition_number, trunc(prha.creation_date) creation_date, xxen_util.user_name(prha.created_by) created_by_user, ppx.full_name preparer_name, prha.description description, nvl(xxen_util.meaning(prha.authorization_status,'AUTHORIZATION STATUS',201) ,prha.authorization_status) req_auth_status, prha.note_to_authorizer, prha.agent_return_flag agent_return_flag, xxen_util.meaning(prha.closed_code,'DOCUMENT STATE',201) req_closure_status, prla.line_num line_number, trunc(prla.creation_date) line_creation_date, xxen_util.meaning(prla.source_type_code,'REQUISITION SOURCE TYPE',201) line_source_type, xxen_util.meaning(prla.purchase_basis,'PURCHASE BASIS',201) line_type, xxen_util.meaning(prla.order_type_lookup_code,'ORDER TYPE',201) line_order_type, msiv.concatenated_segments item, prla.item_revision item_revision, (select mck.concatenated_segments from mtl_categories_kfv mck where prla.category_id=mck.category_id) category, nvl(prla.item_description ,msiv.description) line_description, xxen_util.meaning(msiv.item_type,'ITEM_TYPE',3) user_item_type, (select misv.inventory_item_status_code_tl from mtl_item_status_vl misv where msiv.inventory_item_status_code=misv.inventory_item_status_code) item_status, xxen_util.meaning(msiv.inventory_item_flag,'YES_NO',0) inventory_item_flag, xxen_util.meaning(msiv.stock_enabled_flag,'YES_NO',0) stock_enabled_flag, xxen_util.meaning(msiv.inventory_asset_flag,'YES_NO',0) inventory_asset_flag, xxen_util.concatenated_segments(msiv.expense_account) item_expense_account, prla.unit_meas_lookup_code uom, prla.quantity, prla.quantity_cancelled, prla.quantity_received, prla.quantity_delivered, prla.unit_price unit_price, nvl(decode(prla.order_type_lookup_code,'RATE', prla.amount,'FIXED PRICE', prla.amount, prla.quantity * prla.unit_price),0) amount, prla.need_by_date need_by_date, ppx2.full_name requestor_name, (select mp.organization_code from mtl_parameters mp where prla.destination_organization_id=mp.organization_id) destination_organization, nvl(hrl.location_code,(substrb(rtrim(hzl.address1)||'-'||rtrim(hzl.city),1,60))) deliver_to_location, (select mp.organization_code from mtl_parameters mp where prla.source_organization_id=mp.organization_id) source_organization, prla.source_subinventory, prla.suggested_vendor_name suggested_supplier, prla.suggested_vendor_location suggested_supplier_site, prla.suggested_vendor_contact suggested_supplier_contact, prla.suggested_vendor_product_code supplier_item, prla.note_to_agent note_to_agent, xxen_util.meaning(nvl(prla.on_rfq_flag,'N'),'YES/NO',201) on_rfq, prla2.line_num parent_req_line_number, xxen_util.yes(prla.cancel_flag) cancelled_flag, trunc(nvl(prla.cancel_date ,pah.cancelled_date)) cancelled_date, nvl(prla.cancel_reason,pah.cancelled_note) cancelled_reason, pah.cancelled_by, &req_dist_columns &req_dff_cols &item_dff_cols prla.requisition_header_id, prla.requisition_line_id, prla.line_location_id, prha.attribute_category req_hdr_dff_cat, prha.rowid req_hdr_rowid, prla.attribute_category req_line_dff_cat, prla.rowid req_line_rowid, msiv.attribute_category item_dff_category, msiv.inventory_item_id, nvl(prla.destination_organization_id,msiv.organization_id) organization_id, msiv.rowid item_rowid from po_requisition_headers_all prha, po_requisition_lines_all prla, po_requisition_lines_all prla2, &req_dist_tables financials_system_params_all fspa, gl_ledgers gl, hr_all_organization_units_vl haouv, per_people_x ppx, per_people_x ppx2, hr_locations hrl, hz_locations hzl, mtl_system_items_vl msiv, ( select ppx.full_name cancelled_by, pah.action_date cancelled_date, pah.note cancelled_note, pah.object_id requisition_header_id from po_action_history pah, per_people_x ppx where pah.employee_ID=ppx.person_id(+) and pah.object_type_code='REQUISITION' and pah.action_code='CANCEL' ) pah where 1=1 and prha.type_lookup_code='PURCHASE' and nvl(prha.contractor_requisition_flag,'N')<>'Y' and prha.authorization_status<>'INCOMPLETE' and prha.requisition_header_id=prla.requisition_header_id and &req_dist_joins fspa.org_id=prha.org_id and gl.ledger_id=fspa.set_of_books_id and prha.org_id=haouv.organization_id and prha.preparer_id=ppx.person_id and prla.to_person_id=ppx2.person_id and prla.deliver_to_location_id=hrl.location_id(+) and prla.deliver_to_location_id=hzl.location_id(+) and prla.parent_req_line_id=prla2.requisition_line_id(+) and prla.item_id=msiv.inventory_item_id(+) and nvl(prla.destination_organization_id,fspa.inventory_organization_id)=nvl(msiv.organization_id,fspa.inventory_organization_id) and prha.requisition_header_id=pah.requisition_header_id(+) ), po as ( select /*+ push_pred(x) */ haouv.name po_operating_unit, asu.vendor_name po_vendor_name, asu.segment1 po_vendor_number, assa.vendor_site_code po_vendor_site, pha.segment1 po_number, pra.release_num po_release_num, xxen_util.meaning(pha.authorization_status , 'DOCUMENT STATE', 201) po_auth_status, xxen_util.meaning(pra.authorization_status , 'DOCUMENT STATE', 201) po_release_auth_status, xxen_util.meaning(pha.closed_code,'DOCUMENT STATE',201) po_header_closure_status, xxen_util.meaning(pla.closed_code,'DOCUMENT STATE',201) po_line_closure_status, xxen_util.meaning(plla.closed_code,'DOCUMENT STATE',201) po_shipment_closure_status, trunc(pha.creation_date) po_creation_date, trunc(pra.release_date) po_release_date, pha.currency_code po_currency, pla.line_num po_line_number, pltv.line_type po_line_type, (select mck.concatenated_segments from mtl_categories_kfv mck where pla.category_id=mck.category_id) po_line_category, msiv.item po_line_item, nvl(pla.item_description,msiv.description) po_line_description, plla.shipment_num po_shipment_number, plla.need_by_date po_shipment_need_by_date, plla.promised_date po_shipment_promised_date, plla.firm_date po_shipment_firm_date, plla.unit_meas_lookup_code po_uom, plla.quantity - nvl(plla.quantity_cancelled,0) po_quantity_ordered, plla.quantity_accepted po_quantity_accepted, plla.quantity_rejected po_quantity_rejected, plla.quantity_received po_quantity_received, plla.quantity_billed po_quantity_billed, nvl(plla.price_override,pla.unit_price) po_unit_price, decode(plla.quantity, null, (plla.amount - nvl(plla.amount_cancelled,0)),(plla.quantity - nvl(plla.quantity_cancelled,0))*nvl2(plla.price_override,plla.price_override,nvl(pla.unit_price,0)))po_amount_ordered, decode(plla.quantity_accepted,null,plla.amount_accepted,plla.quantity_accepted*nvl(plla.price_override,pla.unit_price))po_amount_accepted, decode(plla.quantity_rejected,null,plla.amount_rejected,plla.quantity_rejected*nvl(plla.price_override,pla.unit_price))po_amount_rejected, decode(plla.quantity_received,null,plla.amount_received,plla.quantity_received*nvl(plla.price_override,pla.unit_price))po_amount_received, plla.amount_billed po_amount_billed, trunc(plla.creation_date) po_shipment_creation_date, decode(plla.cancel_flag,'Y','Y',null) po_shipment_cancelled_flag, trunc(plla.cancel_date) po_shipment_cancelled_date, plla.cancel_reason po_shipment_cancelled_reason, xxen_util.user_name(plla.cancelled_by) po_shipment_cancelled_by, mp1.organization_code po_ship_to_organization, hl1.location_code po_ship_to_location, ( select listagg(x.receipt_num,', ') within group(order by x.receipt_num) receipt_number from (select distinct rt.po_line_location_id, rsh.receipt_num from rcv_transactions rt, rcv_shipment_headers rsh where rt.shipment_header_id=rsh.shipment_header_id and rt.transaction_type in ('RECEIVE','DELIVER')) x where x.po_line_location_id=plla.line_location_id ) receipt_number, &po_dist_columns &po_dff_cols plla.po_header_id, plla.po_line_id, plla.line_location_id, pha.attribute_category po_hdr_dff_cat, pha.rowid po_hdr_rowid, pla.attribute_category po_line_dff_cat, pla.rowid po_line_rowid from po_headers_all pha, po_lines_all pla, po_line_locations_all plla, &po_dist_tables po_releases_all pra, po_line_types_v pltv, ap_suppliers asu, ap_supplier_sites_all assa, financials_system_params_all fspa, gl_ledgers gl, hr_all_organization_units_vl haouv, hr_locations hl1, mtl_parameters mp1, ( select fspa.org_id, msiv.inventory_item_id, msiv.concatenated_segments item, xxen_util.meaning(msiv.item_type,'ITEM_TYPE',3) item_type, msiv.description from financials_system_params_all fspa, mtl_system_items_vl msiv where msiv.organization_id=fspa.inventory_organization_id ) msiv where 2=2 and pha.po_header_id=pla.po_header_id and pla.po_header_id=plla.po_header_id and pla.po_line_id=plla.po_line_id and &po_dist_joins plla.po_release_id=pra.po_release_id(+) and pha.vendor_id=asu.vendor_id and pha.vendor_site_id=assa.vendor_site_id and pha.org_id=fspa.org_id and gl.ledger_id=fspa.set_of_books_id and haouv.organization_id=pha.org_id and pla.line_type_id=pltv.line_type_id and pla.item_id=msiv.inventory_item_id(+) and pla.org_id=msiv.org_id(+) and plla.ship_to_organization_id=mp1.organization_id(+) and plla.ship_to_location_id=hl1.location_id(+) ) select req.operating_unit, req.requisition_type, req.requisition_number, req.creation_date, req.created_by_user, req.preparer_name, req.description, req.req_auth_status, req.req_closure_status, req.cancelled_flag, req.cancelled_date, req.cancelled_reason, req.cancelled_by, req.note_to_authorizer, req.agent_return_flag, req.line_number, req.line_source_type, req.line_type, req.line_order_type, req.line_creation_date, req.item, req.item_revision, req.user_item_type, req.item_status, req.inventory_item_flag, req.stock_enabled_flag, req.inventory_asset_flag, req.item_expense_account, &category_columns req.category, req.line_description, req.need_by_date, req.unit_price, req.requestor_name, req.destination_organization, req.deliver_to_location, req.source_organization, req.source_subinventory, req.suggested_supplier, req.suggested_supplier_site, req.suggested_supplier_contact, req.supplier_item, &req_line_columns_disp &req_dist_columns_disp req.note_to_agent, req.on_rfq, req.parent_req_line_number, &req_dff_cols_disp &item_dff_cols_disp po.po_vendor_name, po.po_vendor_number, po.po_vendor_site, po.po_number, po.po_release_num, po.po_auth_status, po.po_release_auth_status, po.po_header_closure_status, po.po_line_closure_status, po.po_shipment_closure_status, po.po_creation_date, po.po_release_date, po.po_currency, po.po_line_number, po.po_line_type, po.po_line_category, po.po_line_item, po.po_line_description, po.po_shipment_number, po.po_shipment_need_by_date, po.po_shipment_promised_date, po.po_shipment_firm_date, po.receipt_number, po.po_ship_to_organization, po.po_ship_to_location, po.po_unit_price, po.po_uom, &po_line_columns_disp &po_dist_columns_disp &po_dff_cols_disp po.po_shipment_creation_date, po.po_shipment_cancelled_flag, po.po_shipment_cancelled_date, po.po_shipment_cancelled_reason, po.po_shipment_cancelled_by from req, po where 3=3 and &req_to_po_dist_joins req.line_location_id=po.line_location_id(+) order by req.operating_unit, req.creation_date, req.requisition_number, req.line_number Y JL (:Ledger is not null or :Operating_Unit is not null) and ( (:Creation_Date_From is null and :Creation_Date_To is null) or (:Creation_Date_From is not null and :Creation_Date_To is not null) ) and ( (:Converted_To_PO_Date_From is null and :Converted_To_PO_Date_To is null) or (:Converted_To_PO_Date_From is not null and :Converted_To_PO_Date_To is not null) ) US PO Purchase Requisitions with PO Details Purchase Requisitions Status with PO Details Report Please enter a Ledger or Operating Unit, and if entering a date range, enter both the From and To Date Range Parameters Enginatics Nidec changes &category_columns &item_dff_cols &item_dff_cols_disp &po_dff_cols &po_dff_cols_disp &po_dist_columns &po_dist_columns_disp &po_dist_joins &po_dist_tables &po_line_columns_disp &req_dff_cols &req_dff_cols_disp &req_dist_columns &req_dist_columns_disp &req_dist_joins &req_dist_tables &req_line_columns_disp &req_to_po_dist_joins 1=1 2=2 3=3 1 10 &req_dist_columns prda.distribution_num distribution_number, prda.req_line_quantity distribution_quantity, nvl(decode(prla.order_type_lookup_code,'RATE', prda.req_line_amount ,'FIXED PRICE', prda.req_line_amount,prda.req_line_quantity * prla.unit_price),0)distribution_amount, gcck.concatenated_segments distribution_account, prda.allocation_type, prda.allocation_value, prda.distribution_id, LOV custom Y select 'Line' value, 'Requisition Line Level' description from dual union all select 'Distribution', 'Requisition Distribution Level' from dual union all select 'Distribution with SLA', 'Requisition Distribution Level with Subledger Accounting' from dual Distribution Line F Niveau du rapport US Report Level 2 &req_dist_columns prda.distribution_num distribution_number, prda.req_line_quantity distribution_quantity, nvl(decode(prla.order_type_lookup_code,'RATE', prda.req_line_amount ,'FIXED PRICE', prda.req_line_amount,prda.req_line_quantity * prla.unit_price),0)distribution_amount, xxen_util.meaning(x.gl_transfer_status_code,'XLA_ACCT_TRANSFER',602) sla_gl_tfr_status, x.accounting_line_code, nvl2(x.gl_transfer_status_code,x.entered_amount,null) sla_entered_amount, nvl2(x.gl_transfer_status_code,x.accounted_amount,null) sla_accounted_amount, gcck.concatenated_segments distribution_account, prda.allocation_type, prda.allocation_value, prda.distribution_id, Distribution with SLA US Report Level 3 &po_dist_columns pda.distribution_num po_dist_number, pda.quantity_ordered-nvl(pda.quantity_cancelled,0) po_dist_quantity_ordered, pda.quantity_delivered po_dist_quantity_delivered, pda.quantity_billed po_dist_quantity_billed, decode(pda.quantity_ordered,null,pda.amount_ordered-nvl(pda.amount_cancelled,0),(pda.quantity_ordered-nvl(pda.quantity_cancelled,0))*nvl(plla.price_override,pla.unit_price)) po_dist_amount_ordered, decode(pda.quantity_delivered,null,pda.amount_delivered,pda.quantity_delivered*nvl(plla.price_override,pla.unit_price)) po_dist_amount_delivered, decode(pda.quantity_billed,null,pda.amount_billed,pda.quantity_billed*nvl(plla.price_override,pla.unit_price)) po_dist_amount_billed, gcck.concatenated_segments po_dist_account, mp2.organization_code po_deliver_to_organization, hl2.location_code po_deliver_to_location, ppx.full_name po_deliver_to_person, pda.po_distribution_id, nvl(pda.req_distribution_id,-1) req_distribution_id, Distribution F Niveau du rapport US Report Level 4 &po_dist_columns pda.distribution_num po_dist_number, pda.quantity_ordered-nvl(pda.quantity_cancelled,0) po_dist_quantity_ordered, pda.quantity_delivered po_dist_quantity_delivered, pda.quantity_billed po_dist_quantity_billed, decode(pda.quantity_ordered,null,pda.amount_ordered-nvl(pda.amount_cancelled,0),(pda.quantity_ordered-nvl(pda.quantity_cancelled,0))*nvl(plla.price_override,pla.unit_price)) po_dist_amount_ordered, decode(pda.quantity_delivered,null,pda.amount_delivered,pda.quantity_delivered*nvl(plla.price_override,pla.unit_price)) po_dist_amount_delivered, decode(pda.quantity_billed,null,pda.amount_billed,pda.quantity_billed*nvl(plla.price_override,pla.unit_price)) po_dist_amount_billed, xxen_util.meaning(x.gl_transfer_status_code,'XLA_ACCT_TRANSFER',602) po_sla_gl_tfr_status, x.accounting_line_code po_accounting_line_code, nvl2(x.gl_transfer_status_code,x.entered_amount,null) po_sla_entered_amount, nvl2(x.gl_transfer_status_code,x.accounted_amount,null) po_sla_accounted_amount, gcck.concatenated_segments po_dist_account, mp2.organization_code po_deliver_to_organization, hl2.location_code po_deliver_to_location, ppx.full_name po_deliver_to_person, pda.po_distribution_id, nvl(pda.req_distribution_id,-1) req_distribution_id, Distribution with SLA US Report Level 5 &po_dist_columns_disp po.po_dist_number, po.po_dist_quantity_ordered, po.po_dist_quantity_delivered, po.po_dist_quantity_billed, po.po_dist_amount_ordered, po.po_dist_amount_delivered, po.po_dist_amount_billed, po.po_dist_account, po.po_deliver_to_organization, po.po_deliver_to_location, po.po_deliver_to_person, Distribution F Niveau du rapport US Report Level 6 &po_dist_columns_disp po.po_dist_number, po.po_dist_quantity_ordered, po.po_dist_quantity_delivered, po.po_dist_quantity_billed, po.po_dist_amount_ordered, po.po_dist_amount_delivered, po.po_dist_amount_billed, po.po_sla_gl_tfr_status, po.po_accounting_line_code, po.po_sla_entered_amount, po.po_sla_accounted_amount, po.po_dist_account, po.po_deliver_to_organization, po.po_deliver_to_location, po.po_deliver_to_person, Distribution with SLA US Report Level 7 &po_dist_joins plla.line_location_id=pda.line_location_id and pda.destination_organization_id=mp2.organization_id(+) and pda.deliver_to_location_id=hl2.location_id(+) and pda.deliver_to_person_id=ppx.person_id(+) and pda.code_combination_id=gcck.code_combination_id(+) and Distribution F Niveau du rapport US Report Level 8 &po_dist_joins plla.line_location_id=pda.line_location_id and fspa.set_of_books_id=x.ledger_id(+) and pda.po_distribution_id=x.source_distribution_id_num_1(+) and pda.destination_organization_id=mp2.organization_id(+) and pda.deliver_to_location_id=hl2.location_id(+) and pda.deliver_to_person_id=ppx.person_id(+) and nvl(x.code_combination_id,pda.code_combination_id)=gcck.code_combination_id(+) and Distribution with SLA US Report Level 9 &po_dist_tables po_distributions_all pda, mtl_parameters mp2, hr_locations hl2, per_people_x ppx, gl_code_combinations_kfv gcck, Distribution F Niveau du rapport US Report Level 10 &po_dist_tables po_distributions_all pda, ( select distinct xah.ledger_id, xah.gl_transfer_status_code, xdl.source_distribution_id_num_1, xdl.accounting_line_code, xal.code_combination_id, sum(nvl(xal.entered_dr,0)-nvl(xal.entered_cr,0)) over (partition by xah.ledger_id, xah.gl_transfer_status_code, xdl.source_distribution_id_num_1, xdl.accounting_line_code, xal.code_combination_id) entered_amount, sum(nvl(xal.accounted_dr,0)-nvl(xal.accounted_cr,0)) over (partition by xah.ledger_id, xah.gl_transfer_status_code, xdl.source_distribution_id_num_1, xdl.accounting_line_code, xal.code_combination_id) accounted_amount from xla_distribution_links xdl, xla_ae_headers xah, xla_ae_lines xal where xdl.application_id=201 and xdl.source_distribution_type='PO_DISTRIBUTIONS_ALL' and xdl.application_id=xah.application_id(+) and xdl.ae_header_id=xah.ae_header_id(+) and xdl.application_id=xal.application_id(+) and xdl.ae_header_id=xal.ae_header_id(+) and xdl.ae_line_num=xal.ae_line_num(+) ) x, mtl_parameters mp2, hr_locations hl2, per_people_x ppx, gl_code_combinations_kfv gcck, Distribution with SLA US Report Level 11 &po_line_columns_disp po.po_quantity_ordered, po.po_quantity_accepted, po.po_quantity_rejected, po.po_quantity_received, po.po_quantity_billed, po.po_amount_ordered, po.po_amount_accepted, po.po_amount_rejected, po.po_amount_received, po.po_amount_billed, Line F Niveau du rapport US Report Level 12 &req_dist_columns_disp req.distribution_number, req.distribution_quantity, req.distribution_amount, req.distribution_account, Distribution F Niveau du rapport US Report Level 13 &req_dist_columns_disp req.distribution_number, req.distribution_quantity, req.distribution_amount, req.sla_gl_tfr_status, req.accounting_line_code, req.sla_entered_amount, req.sla_accounted_amount, req.distribution_account, Distribution with SLA US Report Level 14 &req_dist_joins prla.requisition_line_id=prda.requisition_line_id and prda.code_combination_id=gcck.code_combination_id and Distribution F Niveau du rapport US Report Level 15 &req_dist_joins prla.requisition_line_id=prda.requisition_line_id and fspa.set_of_books_id=x.ledger_id(+) and prda.distribution_id=x.source_distribution_id_num_1(+) and nvl(x.code_combination_id,prda.code_combination_id)=gcck.code_combination_id and Distribution with SLA US Report Level 16 &req_dist_tables po_req_distributions_all prda, gl_code_combinations_kfv gcck, Distribution F Niveau du rapport US Report Level 17 &req_dist_tables po_req_distributions_all prda, ( select distinct xah.ledger_id, xah.gl_transfer_status_code, xdl.source_distribution_id_num_1, xdl.accounting_line_code, xal.code_combination_id, sum(nvl(xal.entered_dr,0)-nvl(xal.entered_cr,0)) over (partition by xah.ledger_id, xah.gl_transfer_status_code, xdl.source_distribution_id_num_1, xdl.accounting_line_code, xal.code_combination_id) entered_amount, sum(nvl(xal.accounted_dr,0)-nvl(xal.accounted_cr,0)) over (partition by xah.ledger_id, xah.gl_transfer_status_code, xdl.source_distribution_id_num_1, xdl.accounting_line_code, xal.code_combination_id) accounted_amount from xla_distribution_links xdl, xla_ae_headers xah, xla_ae_lines xal where xdl.application_id=201 and xdl.source_distribution_type='PO_REQ_DISTRIBUTIONS_ALL' and xdl.application_id=xah.application_id(+) and xdl.ae_header_id=xah.ae_header_id(+) and xdl.application_id=xal.application_id(+) and xdl.ae_header_id=xal.ae_header_id(+) and xdl.ae_line_num=xal.ae_line_num(+) ) x, gl_code_combinations_kfv gcck, Distribution with SLA US Report Level 18 &req_line_columns_disp req.quantity, req.quantity_cancelled, req.quantity_received, req.quantity_delivered, req.amount, Line F Niveau du rapport US Report Level 19 &req_to_po_dist_joins req.distribution_id=po.req_distribution_id(+) and Distribution F Niveau du rapport US Report Level 20 20 1=1 gl.name=:ledger and haouv.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) LOV GL Ledger 8E2FF36EDEB879D2E0530100007F1FF2 Y select 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.name coalesce(xxen_util.previous_parameter_value(:parameter_id),xxen_util.default_ledger) F Grand livre US Ledger 21 2=2 gl.name=:ledger and haouv.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) US Ledger 22 30 1=1 haouv.name=:operating_unit LOV HR Operating Unit 8E2FF36EDEB979D2E0530100007F1FF2 Y select hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and hou.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) order by hou.name coalesce(xxen_util.default_operating_unit,xxen_util.previous_parameter_value(:parameter_id)) F Unité d'exploitation US Operating Unit 23 2=2 haouv.name=:operating_unit US Operating Unit 24 40 1=1 prha.segment1=:req_number LOV PO Requisition Number 0087D0A1D043F831E0630100007F0109 Y Y select prha.segment1 value, prha.description from hr_all_organization_units_vl haouv, po_requisition_headers_all prha, po_system_parameters_all pspa where prha.org_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) and (:$flex$.operating_unit is null or xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y') and haouv.organization_id=prha.org_id and prha.org_id=pspa.org_id and nvl(prha.authorization_status,'INCOMPLETE')<>'SYSTEM_SAVED' order by haouv.name, decode(pspa.manual_req_num_type,'NUMERIC',to_number(prha.segment1)), prha.segment1 F Numéro de demande d'emploi De US Requisition Number 25 50 1=1 prha.creation_date>=:creation_date_from Date F Date de création du US Creation Date From 26 60 1=1 prha.creation_date < :creation_date_to + 1 Date last_day(:$flex$.creation_date_from) F Date de création au US Creation Date To 27 70 1=1 prla.need_by_date >= :p_need_by_date_from Date F Besoin par Date du US Need By Date From 28 80 1=1 prla.need_by_date < :p_need_by_date_to+1 Date last_day(:$flex$.need_by_date_from) F Besoin par Date à US Need By Date To 29 90 :plla_creation_date_from Date F Converti en PO Date du US Converted To PO Date From 30 100 :plla_creation_date_to Date last_day(:$flex$.converted_to_po_date_from) F Converti en Date de la commande en US Converted To PO Date To 31 1=1 prla.line_location_id in (select plla.line_location_id from po_line_locations_all plla where plla.creation_date>=:plla_creation_date_from and plla.creation_date<:plla_creation_date_to+1) F Converti en Date de la commande en US Converted To PO Date To 32 110 1=1 prla.destination_organization_id in (select mp.organization_id from mtl_parameters mp where mp.organization_code=:ship_from_warehouse) LOV INV Organization Code 8E2FF36EDEB279D2E0530100007F1FF2 Y select ood.organization_code value, ood.organization_name||' ('||ftv.territory_short_name||', '||hla.town_or_city||decode(mp.organization_id,mp.master_organization_id,null,', '||mp0.organization_code)||')' description from org_organization_definitions ood, mtl_parameters mp, mtl_parameters mp0, hr_all_organization_units haou, hr_locations_all hla, fnd_territories_vl ftv where ood.organization_id=mp.organization_id and mp.organization_id<>mp.master_organization_id and ( ood.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) or not exists (select null from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) and ood.operating_unit in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) ) and (:$flex$.operating_unit is null or ood.operating_unit in (select haouv.organization_id from hr_all_organization_units_vl haouv where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y')) and (:$flex$.ledger is null or ood.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and nvl(ood.disable_date,sysdate)>=sysdate and mp.master_organization_id=mp0.organization_id and ood.organization_id=haou.organization_id(+) and haou.location_id=hla.location_id(+) and hla.country=ftv.territory_code(+) order by ood.organization_code US Destination Organization 33 120 1=1 hrl.location_code=:location_code LOV HR Location 0087D0A1D042F831E0630100007F0109 Y select hl.location_code value, hl.description||' ('||hl.address_line_1||', '||hl.town_or_city||', '||ftv.territory_short_name||')' description from hr_locations hl, fnd_territories_vl ftv where hl.country=ftv.territory_code(+) order by hl.location_code F Livraison sur site US Deliver To Location 34 130 1=1 ppx2.full_name=:requestor_name LOV HR Employee 0092EAD2F4F36C61E0630100007FAB89 Y Y select he.full_name value, he.employee_num description from hr_employees he order by he.full_name F Nom du demandeur US Requestor Name 35 140 1=1 ppx.full_name=:preparer_name Char F Nom du préparateur US Preparer Name 36 150 1=1 prha.created_by in (select fu.user_id from fnd_user fu where fu.user_name=:created_by) LOV FND User Name 8E2FF36EDE8479D2E0530100007F1FF2 Y Y select fu.user_name value, trim(coalesce( trim(papf.first_name||' '||papf.last_name), fu.description, fu.email_address, papf.email_address )||fu.inactive) description from (select case when sysdate between fu.start_date and nvl(fu.end_date,sysdate) then null else ' (inactive)' end inactive, fu.* from fnd_user fu) fu, (select papf.* from per_all_people_f papf where sysdate between papf.effective_start_date and papf.effective_end_date) papf, ( select distinct furg.user_id, count(*) over (partition by furg.user_id) resp_count, max(fr.responsibility_key) over (partition by furg.user_id) max_responsibility_key from fnd_responsibility fr, fnd_user_resp_groups_direct furg where fr.responsibility_id=furg.responsibility_id and fr.application_id=furg.responsibility_application_id ) furg where fu.employee_id=papf.person_id(+) and fu.user_id=furg.user_id(+) and not (furg.resp_count=1 and furg.max_responsibility_key='IRC_EXT_CANDIDATE') order by fu.inactive desc, fu.user_name F Créé par US Created By 37 160 1=1 nvl(prla.quantity_delivered,0) < nvl(prla.quantity,0) LOV Oracle Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description Y N Y F Exclure les produits entièrement livrés US Exclude Fully Delivered 38 170 1=1 1=1 LOV Oracle Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description Y N Y F Le spectacle est annulé US Show Cancelled 39 1=1 nvl(prla.cancel_flag,'N') = 'N' N F Le spectacle est annulé US Show Cancelled 40 180 &category_columns select xxen_util.item_category_columns(p_category_set_name=>'<parameter_value>', p_table_alias=>'req') sql_text from dual LOV INV Category Set 8E2FF36EDECA79D2E0530100007F1FF2 Y select distinct mcsv.category_set_name value, mcsv.description from mtl_category_sets_vl mcsv where :$flex$.organization_code is null or mcsv.category_set_id in (select mic.category_set_id from mtl_parameters mp, mtl_item_categories mic where xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y' and mp.organization_id=mic.organization_id) order by mcsv.category_set_name coalesce(xxen_util.previous_parameter_value(:parameter_id),(select mdsv.category_set_name from mtl_default_sets_view mdsv where mdsv.functional_area_id=1)) US Category Set 1 41 190 &category_columns select xxen_util.item_category_columns(p_category_set_name=>'<parameter_value>', p_table_alias=>'req') sql_text from dual LOV INV Category Set 8E2FF36EDECA79D2E0530100007F1FF2 Y select distinct mcsv.category_set_name value, mcsv.description from mtl_category_sets_vl mcsv where :$flex$.organization_code is null or mcsv.category_set_id in (select mic.category_set_id from mtl_parameters mp, mtl_item_categories mic where xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y' and mp.organization_id=mic.organization_id) order by mcsv.category_set_name coalesce(xxen_util.previous_parameter_value(:parameter_id),(select mdsv.category_set_name from mtl_default_sets_view mdsv where mdsv.functional_area_id=2)) US Category Set 2 42 200 &category_columns select xxen_util.item_category_columns(p_category_set_name=>'<parameter_value>', p_table_alias=>'req') sql_text from dual LOV INV Category Set 8E2FF36EDECA79D2E0530100007F1FF2 Y select distinct mcsv.category_set_name value, mcsv.description from mtl_category_sets_vl mcsv where :$flex$.organization_code is null or mcsv.category_set_id in (select mic.category_set_id from mtl_parameters mp, mtl_item_categories mic where xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y' and mp.organization_id=mic.organization_id) order by mcsv.category_set_name xxen_util.previous_parameter_value(:parameter_id) US Category Set 3 43 210 &item_dff_cols select xxen_util.dff_columns(p_table_name=>'MTL_SYSTEM_ITEMS_B',p_table_alias=>'msiv',p_row_id=>'rowid',p_column_name_prefix=>'Item: ') dff_column from dual LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual Y Y US Show Item DFF Attributes 44 &item_dff_cols_disp select xxen_util.dff_columns(p_table_name=>'MTL_SYSTEM_ITEMS_B', p_prefix=>'req.',p_column_name_prefix=>'Item: ') from dual Y US Show Item DFF Attributes 45 220 &req_dff_cols select xxen_util.dff_columns(p_table_name=>'PO_REQUISITION_HEADERS_ALL',p_table_alias=>'prha',p_row_id=>'rowid',p_column_name_prefix=>'Req Hdr: ') dff_column from dual union all select xxen_util.dff_columns(p_table_name=>'PO_REQUISITION_LINES_ALL',p_table_alias=>'prla',p_row_id=>'rowid',p_column_name_prefix=>'Req Ln: ') dff_column from dual LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual Y Y US Show Requisition DFF Attributes 46 &req_dff_cols_disp select xxen_util.dff_columns(p_table_name=>'PO_REQUISITION_HEADERS_ALL', p_prefix=>'req.',p_column_name_prefix=>'Req Hdr: ') dff_columns from dual union all select xxen_util.dff_columns(p_table_name=>'PO_REQUISITION_LINES_ALL', p_prefix=>'req.',p_column_name_prefix=>'Req Ln: ') dff_columns from dual Y US Show Requisition DFF Attributes 47 230 &po_dff_cols select xxen_util.dff_columns(p_table_name=>'PO_HEADERS_ALL',p_table_alias=>'pha',p_row_id=>'rowid',p_column_name_prefix=>'PO Hdr: ') dff_columns from dual union all select xxen_util.dff_columns(p_table_name=>'PO_LINES_ALL',p_table_alias=>'pla',p_row_id=>'rowid',p_column_name_prefix=>'PO Ln: ') dff_columns from dual LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual Y Y US Show PO DFF Attributes 48 &po_dff_cols_disp select xxen_util.dff_columns(p_table_name=>'PO_HEADERS_ALL', p_prefix=>'po.',p_column_name_prefix=>'PO Hdr: ') dff_columns from dual union all select xxen_util.dff_columns(p_table_name=>'PO_LINES_ALL', p_prefix=>'po.',p_column_name_prefix=>'PO Ln: ') dff_columns from dual Y US Show PO DFF Attributes 49 240 1=1 gcck.segment1=:segment1 LOV custom Y select 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(+)) ) ) ) ) and :$flex$.report_level in('Distribution','Distribution with SLA') order by ffvv.flex_value US GL_SEGMENT1 50 2=2 gcck.segment1=:segment1 US GL_SEGMENT1 51 250 1=1 gcck.segment1>=:segment1_from LOV custom Y select 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(+)) ) ) ) ) and :$flex$.report_level in('Distribution','Distribution with SLA') order by ffvv.flex_value US GL_SEGMENT1 From 52 2=2 gcck.segment1>=:segment1_from US GL_SEGMENT1 From 53 260 1=1 gcck.segment1<=:segment1_to LOV custom Y select 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(+)) ) ) ) ) and :$flex$.report_level in('Distribution','Distribution with SLA') order by ffvv.flex_value $flex$.gl_segment1_from US GL_SEGMENT1 To 54 2=2 gcck.segment1<=:segment1_to US GL_SEGMENT1 To 55 270 1=1 gcck.segment2=:segment2 LOV custom Y select 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(+)) ) ) ) ) and :$flex$.report_level in('Distribution','Distribution with SLA') order by ffvv.flex_value US GL_SEGMENT2 56 2=2 gcck.segment2=:segment2 US GL_SEGMENT2 57 280 1=1 gcck.segment2>=:segment2_from LOV custom Y select 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(+)) ) ) ) ) and :$flex$.report_level in('Distribution','Distribution with SLA') order by ffvv.flex_value US GL_SEGMENT2 From 58 2=2 gcck.segment2>=:segment2_from US GL_SEGMENT2 From 59 290 1=1 gcck.segment2<=:segment2_to LOV custom Y select 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(+)) ) ) ) ) and :$flex$.report_level in('Distribution','Distribution with SLA') order by ffvv.flex_value $flex$.gl_segment2_from US GL_SEGMENT2 To 60 2=2 gcck.segment2<=:segment2_to US GL_SEGMENT2 To 61 300 1=1 gcck.segment3=:segment3 LOV custom Y select 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(+)) ) ) ) ) and :$flex$.report_level in('Distribution','Distribution with SLA') order by ffvv.flex_value US GL_SEGMENT3 62 2=2 gcck.segment3=:segment3 US GL_SEGMENT3 63 310 1=1 gcck.segment3>=:segment3_from LOV custom Y select 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(+)) ) ) ) ) and :$flex$.report_level in('Distribution','Distribution with SLA') order by ffvv.flex_value US GL_SEGMENT3 From 64 2=2 gcck.segment3>=:segment3_from US GL_SEGMENT3 From 65 320 1=1 gcck.segment3<=:segment3_to LOV custom Y select 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(+)) ) ) ) ) and :$flex$.report_level in('Distribution','Distribution with SLA') order by ffvv.flex_value $flex$.gl_segment3_from US GL_SEGMENT3 To 66 2=2 gcck.segment3<=:segment3_to US GL_SEGMENT3 To 67 330 1=1 gcck.segment4=:segment4 LOV custom Y select 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(+)) ) ) ) ) and :$flex$.report_level in('Distribution','Distribution with SLA') order by ffvv.flex_value US GL_SEGMENT4 68 2=2 gcck.segment4=:segment4 US GL_SEGMENT4 69 340 1=1 gcck.segment4>=:segment4_from LOV custom Y select 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(+)) ) ) ) ) and :$flex$.report_level in('Distribution','Distribution with SLA') order by ffvv.flex_value US GL_SEGMENT4 From 70 2=2 gcck.segment4>=:segment4_from US GL_SEGMENT4 From 71 350 1=1 gcck.segment4<=:segment4_to LOV custom Y select 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(+)) ) ) ) ) and :$flex$.report_level in('Distribution','Distribution with SLA') order by ffvv.flex_value $flex$.gl_segment4_from US GL_SEGMENT4 To 72 2=2 gcck.segment4<=:segment4_to US GL_SEGMENT4 To 73 360 1=1 gcck.segment5=:segment5 LOV custom Y select 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(+)) ) ) ) ) and :$flex$.report_level in('Distribution','Distribution with SLA') order by ffvv.flex_value US GL_SEGMENT5 74 2=2 gcck.segment5=:segment5 US GL_SEGMENT5 75 370 1=1 gcck.segment5>=:segment5_from LOV custom Y select 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(+)) ) ) ) ) and :$flex$.report_level in('Distribution','Distribution with SLA') order by ffvv.flex_value US GL_SEGMENT5 From 76 2=2 gcck.segment5>=:segment5_from US GL_SEGMENT5 From 77 380 1=1 gcck.segment5<=:segment5_to LOV custom Y select 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(+)) ) ) ) ) and :$flex$.report_level in('Distribution','Distribution with SLA') order by ffvv.flex_value $flex$.gl_segment5_from US GL_SEGMENT5 To 78 2=2 gcck.segment5<=:segment5_to US GL_SEGMENT5 To 79 390 1=1 gcck.segment6=:segment6 LOV custom Y select 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(+)) ) ) ) ) and :$flex$.report_level in('Distribution','Distribution with SLA') order by ffvv.flex_value US GL_SEGMENT6 80 2=2 gcck.segment6=:segment6 US GL_SEGMENT6 81 400 1=1 gcck.segment6>=:segment6_from LOV custom Y select 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(+)) ) ) ) ) and :$flex$.report_level in('Distribution','Distribution with SLA') order by ffvv.flex_value US GL_SEGMENT6 From 82 2=2 gcck.segment6>=:segment6_from US GL_SEGMENT6 From 83 410 1=1 gcck.segment6<=:segment6_to LOV custom Y select 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(+)) ) ) ) ) and :$flex$.report_level in('Distribution','Distribution with SLA') order by ffvv.flex_value $flex$.gl_segment6 US GL_SEGMENT6 To 84 2=2 gcck.segment6<=:segment6_to US GL_SEGMENT6 To 85 420 1=1 gcck.segment7=:segment7 LOV custom Y select 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(+)) ) ) ) ) and :$flex$.report_level in('Distribution','Distribution with SLA') order by ffvv.flex_value US GL_SEGMENT7 86 2=2 gcck.segment7=:segment7 US GL_SEGMENT7 87 430 1=1 gcck.segment7>=:segment7_from LOV custom Y select 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(+)) ) ) ) ) and :$flex$.report_level in('Distribution','Distribution with SLA') order by ffvv.flex_value US GL_SEGMENT7 From 88 2=2 gcck.segment7>=:segment7_from US GL_SEGMENT7 From 89 440 1=1 gcck.segment7<=:segment7_to LOV custom Y select 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(+)) ) ) ) ) and :$flex$.report_level in('Distribution','Distribution with SLA') order by ffvv.flex_value $flex$.gl_segment7_from US GL_SEGMENT7 To 90 2=2 gcck.segment7<=:segment7_to US GL_SEGMENT7 To 91 450 1=1 gcck.segment8=:segment8 LOV custom Y select 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(+)) ) ) ) ) and :$flex$.report_level in('Distribution','Distribution with SLA') order by ffvv.flex_value US GL_SEGMENT8 92 2=2 gcck.segment8=:segment8 US GL_SEGMENT8 93 460 1=1 gcck.segment8>=:segment8_from LOV custom Y select 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(+)) ) ) ) ) and :$flex$.report_level in('Distribution','Distribution with SLA') order by ffvv.flex_value US GL_SEGMENT8 From 94 2=2 gcck.segment8>=:segment8_from US GL_SEGMENT8 From 95 470 1=1 gcck.segment8<=:segment8_to LOV custom Y select 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(+)) ) ) ) ) and :$flex$.report_level in('Distribution','Distribution with SLA') order by ffvv.flex_value $flex$.gl_segment8_from US GL_SEGMENT8 To 96 2=2 gcck.segment8<=:segment8_to US GL_SEGMENT8 To 97 480 1=1 gcck.segment9=:segment9 LOV custom Y select 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(+)) ) ) ) ) and :$flex$.report_level in('Distribution','Distribution with SLA') order by ffvv.flex_value US GL_SEGMENT9 98 2=2 gcck.segment9=:segment9 US GL_SEGMENT9 99 490 1=1 gcck.segment9>=:segment9_from LOV custom Y select 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(+)) ) ) ) ) and :$flex$.report_level in('Distribution','Distribution with SLA') order by ffvv.flex_value US GL_SEGMENT9 From 100 2=2 gcck.segment9>=:segment9_from US GL_SEGMENT9 From 101 500 1=1 gcck.segment9<=:segment9_to LOV custom Y select 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(+)) ) ) ) ) and :$flex$.report_level in('Distribution','Distribution with SLA') order by ffvv.flex_value $flex$.gl_segment9_from US GL_SEGMENT9 To 102 2=2 gcck.segment9<=:segment9_to US GL_SEGMENT9 To 103 510 1=1 gcck.segment10=:segment10 LOV custom Y select 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(+)) ) ) ) ) and :$flex$.report_level in('Distribution','Distribution with SLA') order by ffvv.flex_value US GL_SEGMENT10 104 2=2 gcck.segment10=:segment10 US GL_SEGMENT10 105 520 1=1 gcck.segment10>=:segment10_from LOV custom Y select 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(+)) ) ) ) ) and :$flex$.report_level in('Distribution','Distribution with SLA') order by ffvv.flex_value US GL_SEGMENT10 From 106 2=2 gcck.segment10>=:segment10_from US GL_SEGMENT10 From 107 530 1=1 gcck.segment10<=:segment10_to LOV custom Y select 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(+)) ) ) ) ) and :$flex$.report_level in('Distribution','Distribution with SLA') order by ffvv.flex_value $flex$.gl_segment_10_from US GL_SEGMENT10 To 108 2=2 gcck.segment10<=:segment10_to US GL_SEGMENT10 To :$flex$.converted_to_po_date_from Converted To PO Date From Y Converted To PO Date To :$flex$.creation_date_from Creation Date From Y Creation Date To :$flex$.ledger Ledger Destination Organization :$flex$.ledger Ledger GL_SEGMENT1 :$flex$.ledger Ledger GL_SEGMENT1 From :$flex$.ledger Ledger GL_SEGMENT1 To :$flex$.ledger Ledger GL_SEGMENT10 :$flex$.ledger Ledger GL_SEGMENT10 From :$flex$.ledger Ledger GL_SEGMENT10 To :$flex$.ledger Ledger GL_SEGMENT2 :$flex$.ledger Ledger GL_SEGMENT2 From :$flex$.ledger Ledger GL_SEGMENT2 To :$flex$.ledger Ledger GL_SEGMENT3 :$flex$.ledger Ledger GL_SEGMENT3 From :$flex$.ledger Ledger GL_SEGMENT3 To :$flex$.ledger Ledger GL_SEGMENT4 :$flex$.ledger Ledger GL_SEGMENT4 From :$flex$.ledger Ledger GL_SEGMENT4 To :$flex$.ledger Ledger GL_SEGMENT5 :$flex$.ledger Ledger GL_SEGMENT5 From :$flex$.ledger Ledger GL_SEGMENT5 To :$flex$.ledger Ledger GL_SEGMENT6 :$flex$.ledger Ledger GL_SEGMENT6 From :$flex$.ledger Ledger GL_SEGMENT6 To :$flex$.ledger Ledger GL_SEGMENT7 :$flex$.ledger Ledger GL_SEGMENT7 From :$flex$.ledger Ledger GL_SEGMENT7 To :$flex$.ledger Ledger GL_SEGMENT8 :$flex$.ledger Ledger GL_SEGMENT8 From :$flex$.ledger Ledger GL_SEGMENT8 To :$flex$.ledger Ledger GL_SEGMENT9 :$flex$.ledger Ledger GL_SEGMENT9 From :$flex$.ledger Ledger GL_SEGMENT9 To :$flex$.ledger Ledger Operating Unit :$flex$.need_by_date_from Need By Date From Y Need By Date To :$flex$.operating_unit Operating Unit Destination Organization :$flex$.operating_unit Operating Unit Requisition Number :$flex$.report_level Report Level GL_SEGMENT1 :$flex$.report_level Report Level GL_SEGMENT1 From :$flex$.report_level Report Level GL_SEGMENT1 To :$flex$.report_level Report Level GL_SEGMENT10 :$flex$.report_level Report Level GL_SEGMENT10 From :$flex$.report_level Report Level GL_SEGMENT10 To :$flex$.report_level Report Level GL_SEGMENT2 :$flex$.report_level Report Level GL_SEGMENT2 From :$flex$.report_level Report Level GL_SEGMENT2 To :$flex$.report_level Report Level GL_SEGMENT3 :$flex$.report_level Report Level GL_SEGMENT3 From :$flex$.report_level Report Level GL_SEGMENT3 To :$flex$.report_level Report Level GL_SEGMENT4 :$flex$.report_level Report Level GL_SEGMENT4 From :$flex$.report_level Report Level GL_SEGMENT4 To :$flex$.report_level Report Level GL_SEGMENT5 :$flex$.report_level Report Level GL_SEGMENT5 From :$flex$.report_level Report Level GL_SEGMENT5 To :$flex$.report_level Report Level GL_SEGMENT6 :$flex$.report_level Report Level GL_SEGMENT6 From :$flex$.report_level Report Level GL_SEGMENT6 To :$flex$.report_level Report Level GL_SEGMENT7 :$flex$.report_level Report Level GL_SEGMENT7 From :$flex$.report_level Report Level GL_SEGMENT7 To :$flex$.report_level Report Level GL_SEGMENT8 :$flex$.report_level Report Level GL_SEGMENT8 From :$flex$.report_level Report Level GL_SEGMENT8 To :$flex$.report_level Report Level GL_SEGMENT9 :$flex$.report_level Report Level GL_SEGMENT9 From :$flex$.report_level Report Level GL_SEGMENT9 To