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. 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）限制的操作单元。 8E2FF36EDEE479D2E0530100007F1FF2 INV Cross Reference Type Y select mcrt.cross_reference_type value, mcrt.description from mtl_cross_reference_types mcrt where sysdate<nvl(mcrt.disable_date,sysdate+1) order by mcrt.cross_reference_type US 8E2FF36EDE9C79D2E0530100007F1FF2 INV Item Status Y select misv.inventory_item_status_code_tl value, misv.description from mtl_item_status_vl misv order by misv.inventory_item_status_code_tl US 8E2FF36EDE8579D2E0530100007F1FF2 INV Item Type Y select flvv.meaning value, flvv.lookup_code description from fnd_lookup_values_vl flvv where flvv.enabled_flag='Y' and flvv.lookup_type='ITEM_TYPE' and flvv.view_application_id=3 and flvv.security_group_id=0 order by flvv.lookup_code US 8E2FF36EDEFB79D2E0530100007F1FF2 INV Pegging Y select flvv.meaning value, null description from fnd_lookup_values_vl flvv where flvv.lookup_type='ASSEMBLY_PEGGING_CODE' and flvv.view_application_id=0 and flvv.security_group_id=0 order by decode(flvv.lookup_code,'A',1,'Y',2,'B',3,'I',4,'X',5,'N',6) US 8E2FF36EDF2F79D2E0530100007F1FF2 PO Buyer Y Y select ppx.full_name value, ppx.employee_number description from per_people_x ppx where ppx.current_employee_flag='Y' and ppx.person_id in (select pa.agent_id from po_agents pa where sysdate between nvl(pa.start_date_active,sysdate) and nvl(pa.end_date_active,sysdate)) and ppx.person_id in ( select paaf.person_id from per_all_assignments_f paaf where trunc(sysdate) between paaf.effective_start_date and paaf.effective_end_date and (:$flex$.organization_code is null or paaf.business_group_id in (select ood.business_group_id from org_organization_definitions ood where xxen_util.contains(:$flex$.organization_code,ood.organization_code)='Y') ) ) order by ppx.full_name Corrected restriction to show buyers of the inventory orgs business group US FA4C095F18CC772AE0530100007F3924 WIP Supply Type Y select ml.meaning value, ml.description from mfg_lookups ml where ml.lookup_type='WIP_SUPPLY' order by ml.meaning US 8E2FF36EDEA679D2E0530100007F1FF2 Yes Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US 4F4EAF7A51AA7E37E0530100007FCCF6Y insert into xxen_report_search_ids xrsi (rowid1) select msiv.row_id row_id from mtl_system_items_vl msiv where 1=1 and msiv.organization_id in ( select oav.organization_id from org_access_view oav, mtl_parameters mp where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id and oav.organization_id=mp.organization_id and (fnd_profile.value('XXEN_SCHUB_EXCLUDE_INV_MASTER_ORG')='N' or mp.organization_id<>mp.master_organization_id) ) and rownum<=xxen_schub.search_row_limit use unified search_row_limit function with profile option default S US XXEN_SCHUB_ITEM_SEARCH System report controlling the search functionality on the Supply Chain Hub form Please enter more parameters Supply Chain Hub 1=1 1 -70 1=1 msiv.inventory_item_id in ( select x.component_item_id from ( select bsb.assembly_item_id, bcb.component_item_id from bom_structures_b bsb, bom_components_b bcb where :order_number=:order_number and (:organization_name is null or bsb.organization_id in (select haou.organization_id from hr_all_organization_units haou where haou.name=:organization_name)) and bsb.bill_sequence_id=bcb.bill_sequence_id ) x connect by nocycle prior x.component_item_id=x.assembly_item_id start with x.assembly_item_id in ( select oola.inventory_item_id from hr_all_organization_units haou, oe_order_headers_all ooha, oe_order_lines_all oola where ooha.order_number=:order_number and (haou.name=:operating_unit or :operating_unit is null and ooha.org_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat)) and haou.organization_id=ooha.org_id and ooha.header_id=oola.header_id and oola.item_type_code not in ('CLASS','MODEL','OPTION') ) union select oola.inventory_item_id from hr_all_organization_units haou, oe_order_headers_all ooha, oe_order_lines_all oola where ooha.order_number=:order_number and (haou.name=:operating_unit or :operating_unit is null and ooha.org_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat)) and haou.organization_id=ooha.org_id and ooha.header_id=oola.header_id and oola.item_type_code not in ('CLASS','MODEL','OPTION') ) Char US Sales Order Components draft parameter, not used yet 2 -60 1=1 msiv.inventory_item_id in ( select x.component_item_id from ( select bsb.assembly_item_id, bcb.component_item_id from bom_structures_b bsb, bom_components_b bcb where :project_number=:project_number and (:organization_name is null or bsb.organization_id in (select haou.organization_id from hr_all_organization_units haou where haou.name=:organization_name)) and bsb.bill_sequence_id=bcb.bill_sequence_id ) x connect by nocycle prior x.component_item_id=x.assembly_item_id start with x.assembly_item_id in ( select oola.inventory_item_id from pa_projects_all ppa, hr_all_organization_units haou, oe_order_lines_all oola where ppa.segment1=:project_number and ppa.project_id=oola.project_id and (haou.name=:operating_unit or :operating_unit is null and oola.org_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat)) and haou.organization_id=oola.org_id and oola.item_type_code not in ('CLASS','MODEL','OPTION') ) union select oola.inventory_item_id from pa_projects_all ppa, hr_all_organization_units haou, oe_order_lines_all oola where ppa.segment1=:project_number and ppa.project_id=oola.project_id and (haou.name=:operating_unit or :operating_unit is null and oola.org_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat)) and haou.organization_id=oola.org_id and oola.item_type_code not in ('CLASS','MODEL','OPTION') ) Char US Project Components draft parameter, not used yet 3 100 1=1 msiv.concatenated_segments=:item LOV custom Y Y select msiv.concatenated_segments value, msiv.description from mtl_system_items_vl msiv where :$flex$.organization_name is null and msiv.organization_id=( select max(mp.master_organization_id) master_organization_id from mtl_parameters mp where mp.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') or fnd_profile.value('MFG_ORGANIZATION_ID') is null and mp.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 msiv.organization_id in (select haout.organization_id from hr_all_organization_units_tl haout where xxen_util.contains(:$flex$.organization_name,haout.name)='Y' and haout.language=userenv('lang')) order by msiv.concatenated_segments xxen_schub.get_item_search_parameter US Item 4 102 1=1 (msiv.organization_id, msiv.inventory_item_id) in ( select /*+ cardinality(msit 100)*/ msit.organization_id, msit.inventory_item_id from mtl_system_items_tl msit where contains(msit.description,nvl(xxen_report.search_text(:description),'üüü'),1)>0 and (:language is null or msit.language=(select flv.language_code from fnd_languages_vl flv where flv.description=:language)) ) Char US Description 5 104 1=1 (msiv.organization_id, msiv.inventory_item_id) in ( select /*+ cardinality(msit 100)*/ msit.organization_id, msit.inventory_item_id from mtl_system_items_tl msit where contains(msit.long_description,nvl(xxen_report.search_text(:long_description),'üüü'),2)>0 and (:language is null or msit.language=(select flv.language_code from fnd_languages_vl flv where flv.description=:language)) ) Char US Long Description 6 106 1=1 :language=:language LOV custom Y select flv.description value, flv.iso_language description from fnd_languages_vl flv where flv.installed_flag in ('I','B') order by flv.description select flv.description value from fnd_languages_vl flv where flv.language_code=userenv('lang') US Language 7 108 1=1 upper(msiv.concatenated_segments) like '%'||upper(:item_number_contains)||'%' LOV custom Y select msiv.concatenated_segments value, msiv.description from mtl_system_items_vl msiv where msiv.organization_id=( select max(mp.master_organization_id) master_organization_id from mtl_parameters mp where mp.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') or fnd_profile.value('MFG_ORGANIZATION_ID') is null and mp.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) ) order by msiv.concatenated_segments US Item-Number contains 8 110 1=1 msiv.item_type=xxen_util.lookup_code(:item_type,'ITEM_TYPE',3) LOV INV Item Type 8E2FF36EDE8579D2E0530100007F1FF2 Y select flvv.meaning value, flvv.lookup_code description from fnd_lookup_values_vl flvv where flvv.enabled_flag='Y' and flvv.lookup_type='ITEM_TYPE' and flvv.view_application_id=3 and flvv.security_group_id=0 order by flvv.lookup_code US Item Type 9 112 1=1 not (msiv.item_type=xxen_util.lookup_code(:exclude_item_type,'ITEM_TYPE',3)) LOV INV Item Type 8E2FF36EDE8579D2E0530100007F1FF2 Y select flvv.meaning value, flvv.lookup_code description from fnd_lookup_values_vl flvv where flvv.enabled_flag='Y' and flvv.lookup_type='ITEM_TYPE' and flvv.view_application_id=3 and flvv.security_group_id=0 order by flvv.lookup_code US Exclude Item Type 10 114 1=1 msiv.inventory_item_status_code in (select misv.inventory_item_status_code from mtl_item_status_vl misv where misv.inventory_item_status_code_tl=:item_status) LOV INV Item Status 8E2FF36EDE9C79D2E0530100007F1FF2 Y select misv.inventory_item_status_code_tl value, misv.description from mtl_item_status_vl misv order by misv.inventory_item_status_code_tl US Item Status 11 116 1=1 (msiv.organization_id, msiv.inventory_item_id) in ( select mic.organization_id, mic.inventory_item_id from mtl_category_sets_v mcsv, mtl_item_categories mic where mcsv.category_set_name=:category_set_name and mcsv.category_set_id=mic.category_set_id) LOV custom Y select distinct mcsv.category_set_name value, mcsv.description from mtl_category_sets_vl mcsv order by mcsv.category_set_name US Category Set 12 118 1=1 (msiv.organization_id, msiv.inventory_item_id) in ( select mic.organization_id, mic.inventory_item_id from mtl_item_categories mic, mtl_category_sets mcs, mtl_categories_kfv mck where mck.concatenated_segments=:category and mck.structure_id=mcs.structure_id and mck.category_id=mic.category_id and mcs.category_set_id=mic.category_set_id ) LOV custom Y select distinct mck.concatenated_segments value, mct.description from mtl_category_sets_v mcsv, mtl_categories_kfv mck, mtl_categories_tl mct where mcsv.category_set_name=:$flex$.category_set and mcsv.structure_id=mck.structure_id and mck.category_id=mct.category_id and mct.language=userenv('lang') order by mck.concatenated_segments US Category 13 120 1=1 msiv.inventory_item_id in ( select mcrb.inventory_item_id from mtl_cross_references_b mcrb where mcrb.cross_reference_type=:cross_reference_type and sysdate between nvl(mcrb.start_date_active,sysdate) and nvl(mcrb.end_date_active,sysdate) ) LOV INV Cross Reference Type 8E2FF36EDEE479D2E0530100007F1FF2 Y select mcrt.cross_reference_type value, mcrt.description from mtl_cross_reference_types mcrt where sysdate<nvl(mcrt.disable_date,sysdate+1) order by mcrt.cross_reference_type US Cross Reference Type 14 122 1=1 msiv.inventory_item_id in ( select mcrb.inventory_item_id from mtl_cross_references_b mcrb where mcrb.cross_reference=:cross_reference and mcrb.cross_reference_type=:cross_reference_type and sysdate between nvl(mcrb.start_date_active,sysdate) and nvl(mcrb.end_date_active,sysdate) ) LOV custom Y Y select distinct mcrv.cross_reference value, mcrv.description from mtl_cross_references_vl mcrv where (mcrv.organization_id is null or :$flex$.organization_name is null or mcrv.organization_id in (select haou.organization_id from hr_all_organization_units haou where xxen_util.contains(:$flex$.organization_name,haou.name)='Y') ) and mcrv.cross_reference_type=:$flex$.cross_reference_type and sysdate between nvl(mcrv.start_date_active,sysdate) and nvl(mcrv.end_date_active,sysdate) order by mcrv.cross_reference US Cross Reference 15 150 1=1 msiv.bom_item_type=:bom_item_type LOV Oracle BOM_TYPE Y select to_char(lookup_code) id, meaning value, null description from fnd_lookup_values where lookup_type='BOM_ITEM_TYPE' and language=userenv('LANG') order by value,description US BOM Item Type 16 155 1=1 (msiv.inventory_item_id, msiv.organization_id) in ( select bsb.assembly_item_id, bsb.organization_id from bom_structures_b bsb where bsb.alternate_bom_designator=:bom_alternate_designator and bsb.structure_type_id=1 ) LOV custom Y select distinct badv.alternate_designator_code value, badv.description description from bom_alternate_designators_vl badv where (:$flex$.organization_name is null or badv.organization_id in (select haou.organization_id from hr_all_organization_units haou where xxen_util.contains(:$flex$.organization_name,haou.name)='Y')) order by badv.alternate_designator_code US BOM Alt. Designator 17 160 1=1 :bom_exists=:bom_exists and (msiv.inventory_item_id,msiv.organization_id) in ( select bsb.assembly_item_id, bsb.organization_id from org_access_view oav, bom_structures_b bsb where oav.resp_application_id = fnd_global.resp_appl_id and oav.responsibility_id = fnd_global.resp_id and (:organization_name is null or oav.organization_name = :organization_name) and oav.organization_id = bsb.organization_id and bsb.assembly_type=1 union select grvr.inventory_item_id, oav.organization_id from org_access_view oav, gmd_recipe_validity_rules grvr, gmd_recipes gr, fm_form_mst ffm where oav.resp_application_id = fnd_global.resp_appl_id and oav.responsibility_id = fnd_global.resp_id and (:organization_name is null or oav.organization_name = :organization_name) and oav.organization_id = nvl(grvr.organization_id,oav.organization_id) and grvr.recipe_id = gr.recipe_id and gr.formula_id = ffm.formula_id and grvr.validity_rule_status in (700,900) and grvr.delete_mark = 0 and grvr.recipe_use in (0,1) and trunc(sysdate) between grvr.start_date and nvl(grvr.end_date, trunc(sysdate)+1) and gr.recipe_status IN (700,900) ) 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 US BOM Exists 18 1=1 :bom_exists=:bom_exists and (msiv.inventory_item_id,msiv.organization_id) not in ( select bsb.assembly_item_id, bsb.organization_id from org_access_view oav, bom_structures_b bsb where oav.resp_application_id = fnd_global.resp_appl_id and oav.responsibility_id = fnd_global.resp_id and (:organization_name is null or oav.organization_name = :organization_name) and oav.organization_id = bsb.organization_id and bsb.assembly_type=1 union select grvr.inventory_item_id, oav.organization_id from org_access_view oav, gmd_recipe_validity_rules grvr, gmd_recipes gr, fm_form_mst ffm where oav.resp_application_id = fnd_global.resp_appl_id and oav.responsibility_id = fnd_global.resp_id and (:organization_name is null or oav.organization_name = :organization_name) and oav.organization_id = nvl(grvr.organization_id,oav.organization_id) and grvr.recipe_id = gr.recipe_id and gr.formula_id = ffm.formula_id and grvr.validity_rule_status in (700,900) and grvr.delete_mark = 0 and grvr.recipe_use in (0,1) and trunc(sysdate) between grvr.start_date and nvl(grvr.end_date, trunc(sysdate)+1) and gr.recipe_status IN (700,900) ) N US BOM Exists 19 165 1=1 :routing_exists=:routing_exists and (msiv.inventory_item_id,msiv.organization_id) in ( select bor.assembly_item_id, bor.organization_id from org_access_view oav, bom_operational_routings bor where oav.resp_application_id = fnd_global.resp_appl_id and oav.responsibility_id = fnd_global.resp_id and (:organization_name is null or oav.organization_name = :organization_name) and oav.organization_id = bor.organization_id union select grvr.inventory_item_id, oav.organization_id from org_access_view oav, gmd_recipe_validity_rules grvr, gmd_recipes gr, fm_form_mst ffm, fm_rout_hdr frh where oav.resp_application_id = fnd_global.resp_appl_id and oav.responsibility_id = fnd_global.resp_id and (:organization_name is null or oav.organization_name = :organization_name) and oav.organization_id = nvl(grvr.organization_id,oav.organization_id) and grvr.recipe_id = gr.recipe_id and gr.formula_id = ffm.formula_id and gr.routing_id = frh.routing_id and grvr.validity_rule_status in (700,900) and grvr.delete_mark = 0 and grvr.recipe_use in (0,1) and trunc(sysdate) between grvr.start_date and nvl(grvr.end_date, trunc(sysdate)+1) and gr.recipe_status IN (700,900) and frh.delete_mark = 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 US Routing Exists 20 1=1 :routing_exists=:routing_exists and (msiv.inventory_item_id,msiv.organization_id) not in ( select bor.assembly_item_id, bor.organization_id from org_access_view oav, bom_operational_routings bor where oav.resp_application_id = fnd_global.resp_appl_id and oav.responsibility_id = fnd_global.resp_id and (:organization_name is null or oav.organization_name = :organization_name) and oav.organization_id = bor.organization_id union select grvr.inventory_item_id, oav.organization_id from org_access_view oav, gmd_recipe_validity_rules grvr, gmd_recipes gr, fm_form_mst ffm, fm_rout_hdr frh where oav.resp_application_id = fnd_global.resp_appl_id and oav.responsibility_id = fnd_global.resp_id and (:organization_name is null or oav.organization_name = :organization_name) and oav.organization_id = nvl(grvr.organization_id,oav.organization_id) and grvr.recipe_id = gr.recipe_id and gr.formula_id = ffm.formula_id and gr.routing_id = frh.routing_id and grvr.validity_rule_status in (700,900) and grvr.delete_mark = 0 and grvr.recipe_use in (0,1) and trunc(sysdate) between grvr.start_date and nvl(grvr.end_date, trunc(sysdate)+1) and gr.recipe_status IN (700,900) and frh.delete_mark = 0 ) N US Routing Exists 21 170 1=1 msiv.wip_supply_type=xxen_util.lookup_code(:wip_supply_type_incl,'WIP_SUPPLY',700) LOV WIP Supply Type FA4C095F18CC772AE0530100007F3924 Y select ml.meaning value, ml.description from mfg_lookups ml where ml.lookup_type='WIP_SUPPLY' order by ml.meaning US WIP Supply Type 22 172 1=1 msiv.wip_supply_type!=xxen_util.lookup_code(:wip_supply_type_excl,'WIP_SUPPLY',700) LOV WIP Supply Type FA4C095F18CC772AE0530100007F3924 Y select ml.meaning value, ml.description from mfg_lookups ml where ml.lookup_type='WIP_SUPPLY' order by ml.meaning US Excl. WIP Supply Type 23 192 1=1 msiv.inventory_item_flag='Y' LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US Inventory Items only 24 194 1=1 msiv.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 US Item Created By 25 196 1=1 msiv.creation_date>=:creation_date_from Date US Item Creation Date from 26 198 1=1 msiv.creation_date<:creation_date_to+1 Date US Item Creation Date to 27 200 1=1 msiv.buyer_id in ( select ppx.person_id from per_people_x ppx where ppx.full_name=:buyer and ppx.current_employee_flag='Y' and ppx.person_id in (select pa.agent_id from po_agents pa) ) LOV PO Buyer 8E2FF36EDF2F79D2E0530100007F1FF2 Y Y select ppx.full_name value, ppx.employee_number description from per_people_x ppx where ppx.current_employee_flag='Y' and ppx.person_id in (select pa.agent_id from po_agents pa where sysdate between nvl(pa.start_date_active,sysdate) and nvl(pa.end_date_active,sysdate)) and ppx.person_id in ( select paaf.person_id from per_all_assignments_f paaf where trunc(sysdate) between paaf.effective_start_date and paaf.effective_end_date and (:$flex$.organization_code is null or paaf.business_group_id in (select ood.business_group_id from org_organization_definitions ood where xxen_util.contains(:$flex$.organization_code,ood.organization_code)='Y') ) ) order by ppx.full_name US Buyer 28 205 1=1 msiv.planner_code=:planner_code LOV custom Y select distinct mp.planner_code value, mp.description from mtl_planners mp where nvl(mp.disable_date,sysdate+1)>=sysdate and (:$flex$.organization_name is null or mp.organization_id in (select haou.organization_id from hr_all_organization_units haou where xxen_util.contains(:$flex$.organization_name,haou.name)='Y')) order by mp.planner_code US Planner 29 210 1=1 msiv.planning_make_buy_code=xxen_util.lookup_code(:make_or_buy,'MTL_PLANNING_MAKE_BUY',700) LOV custom Y select flv.meaning value, null description from fnd_lookup_values flv where flv.lookup_type='MTL_PLANNING_MAKE_BUY' and flv.language=userenv('lang') and flv.view_application_id=700 and flv.security_group_id=0 order by flv.meaning US Make or Buy 30 212 1=1 msiv.end_assembly_pegging_flag=xxen_util.lookup_code(:pegging,'ASSEMBLY_PEGGING_CODE',0) LOV INV Pegging 8E2FF36EDEFB79D2E0530100007F1FF2 Y select flvv.meaning value, null description from fnd_lookup_values_vl flvv where flvv.lookup_type='ASSEMBLY_PEGGING_CODE' and flvv.view_application_id=0 and flvv.security_group_id=0 order by decode(flvv.lookup_code,'A',1,'Y',2,'B',3,'I',4,'X',5,'N',6) US Pegging 31 215 1=1 exists ( select null from mtl_onhand_quantities moq where moq.organization_id = msiv.organization_id and moq.inventory_item_id = msiv.inventory_item_id group by moq.organization_id ,moq.inventory_item_id having sum(moq.transaction_quantity) > 0 ) LOV custom Y select value,description from (select 'Across Org' value , 'Onhand Exists across all accessible Organizations' description from dual union select 'By Org' value, 'Onhand Exists within each selected Organization' description from dual union select 'No' value, 'No Onhand Exists within each selected Organization' description from dual ) order by value By Org US Onhand Exists 32 1=1 exists ( select null from mtl_onhand_quantities moq where moq.inventory_item_id = msiv.inventory_item_id and moq.organization_id in (select oav.organization_id from org_access_view oav, mtl_parameters mp where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id and oav.organization_id = mp.organization_id and ( nvl(fnd_profile.value('XXEN_SCHUB_EXCLUDE_INV_MASTER_ORG'),'Y') = 'N' or oav.organization_id != mp.master_organization_id ) ) group by moq.inventory_item_id having sum(moq.transaction_quantity) > 0 ) Across Org US Onhand Exists 33 1=1 not exists ( select null from mtl_onhand_quantities moq where moq.organization_id = msiv.organization_id and moq.inventory_item_id = msiv.inventory_item_id group by moq.organization_id ,moq.inventory_item_id having sum(moq.transaction_quantity) > 0 ) No US Onhand Exists 34 220 1=1 msiv.inventory_item_id in ( select pla.item_id from hr_all_organization_units haou, po_headers_all pha, po_lines_all pla where haou.organization_id=pha.org_id and pha.segment1=:po_number and (haou.name=:operating_unit or :operating_unit is null and pha.org_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat)) and pha.po_header_id=pla.po_header_id ) LOV custom Y Y select pha.segment1 value, xxen_util.meaning(pha.type_lookup_code,'PO TYPE',201)||nvl2(aps.vendor_name,': '||aps.vendor_name,null) description from po_headers_all pha, ap_suppliers aps where (:$flex$.operating_unit is null or pha.org_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat where xxen_util.contains(:$flex$.operating_unit,mgoat.organization_name)='Y') ) and pha.vendor_id=aps.vendor_id(+) order by pha.creation_date desc US Purchase Order 35 225 1=1 (msiv.organization_id,msiv.inventory_item_id) in ( select ms.to_organization_id,ms.item_id from mtl_supply ms ,po_line_locations_all polla where :po_exists is not null and ms.po_line_location_id = polla.line_location_id and ms.supply_type_code in ('PO','RECEIVING') and ms.destination_type_code = 'INVENTORY' and ms.po_line_location_id is not null and ms.quantity > 0 and nvl(polla.cancel_flag,'N') = 'N' and ( :organization_name is null or ms.to_organization_id in (select haou.organization_id from hr_all_organization_units haou where haou.name=:organization_name) ) and ( (:operating_unit is null and polla.org_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat)) or polla.org_id in (select haou.organization_id from hr_all_organization_units haou where haou.name=:operating_unit) ) ) 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 US Puchase Order Exists Purchase Order Supply Exists 36 1=1 (msiv.organization_id,msiv.inventory_item_id) not in ( select ms.to_organization_id,ms.item_id from mtl_supply ms ,po_line_locations_all polla where :po_exists is not null and ms.po_line_location_id = polla.line_location_id and ms.supply_type_code in ('PO','RECEIVING') and ms.destination_type_code = 'INVENTORY' and ms.po_line_location_id is not null and ms.quantity > 0 and nvl(polla.cancel_flag,'N') = 'N' and ( :organization_name is null or ms.to_organization_id in (select haou.organization_id from hr_all_organization_units haou where haou.name=:organization_name) ) and ( (:operating_unit is null and polla.org_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat)) or polla.org_id in (select haou.organization_id from hr_all_organization_units haou where haou.name=:operating_unit) ) ) N US Puchase Order Exists 37 230 1=1 msiv.inventory_item_id in ( select oola.inventory_item_id from hr_all_organization_units haou, oe_order_headers_all ooha, oe_order_lines_all oola where ooha.order_number=:order_number and (haou.name=:operating_unit or :operating_unit is null and ooha.org_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat)) and haou.organization_id=ooha.org_id and ooha.header_id=oola.header_id and oola.item_type_code not in ('CLASS','MODEL','OPTION') ) LOV custom Y Y select ooha.order_number value, ottt.name||': '||hca.account_name||' ('||xxen_util.meaning(ooha.flow_status_code,'FLOW_STATUS',660)||')' description from oe_order_headers_all ooha, oe_transaction_types_tl ottt, hz_cust_accounts hca where ooha.open_flag='Y' and (:$flex$.operating_unit is null or ooha.org_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat where xxen_util.contains(:$flex$.operating_unit,mgoat.organization_name)='Y') ) and ooha.sold_to_org_id=hca.cust_account_id and ooha.order_type_id=ottt.transaction_type_id and ottt.language=userenv('lang') order by ooha.header_id desc US Sales Order 38 235 1=1 msiv.inventory_item_id in ( select oola.inventory_item_id from fnd_user fu, hr_all_organization_units haou, oe_order_headers_all ooha, oe_order_lines_all oola where fu.user_name=:order_created_by and fu.user_id=ooha.created_by and (haou.name=:operating_unit or :operating_unit is null and ooha.org_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat)) and haou.organization_id=ooha.org_id and ooha.header_id=oola.header_id and oola.item_type_code not in ('CLASS','MODEL','OPTION') ) 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 US Sales Order Created By 39 240 1=1 (msiv.organization_id,msiv.inventory_item_id) in ( select md.organization_id,md.inventory_item_id from mtl_demand md ,oe_order_lines_all ool where :so_exists is not null and md.demand_source_line = ool.line_id and md.demand_source_type = 2 -- sales order and md.line_item_quantity > nvl(md.completed_quantity,0) and ool.open_flag = 'Y' and nvl(ool.cancelled_flag,'N') = 'N' and ( :organization_name is null or md.organization_id in (select haou.organization_id from hr_all_organization_units haou where haou.name=:organization_name) ) and ( (:operating_unit is null and ool.org_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat)) or ool.org_id in (select haou.organization_id from hr_all_organization_units haou where haou.name=:operating_unit) ) ) 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 US Sales Order Exists Sales Order Demand Exists 40 1=1 (msiv.organization_id,msiv.inventory_item_id) not in ( select md.organization_id,md.inventory_item_id from mtl_demand md ,oe_order_lines_all ool where :so_exists is not null and md.demand_source_line = ool.line_id and md.demand_source_type = 2 -- sales order and md.line_item_quantity > nvl(md.completed_quantity,0) and ool.open_flag = 'Y' and nvl(ool.cancelled_flag,'N') = 'N' and ( :organization_name is null or md.organization_id in (select haou.organization_id from hr_all_organization_units haou where haou.name=:organization_name) ) and ( (:operating_unit is null and ool.org_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat)) or ool.org_id in (select haou.organization_id from hr_all_organization_units haou where haou.name=:operating_unit) ) ) N US Sales Order Exists 41 245 1=1 msiv.inventory_item_id in ( select oola.inventory_item_id from pa_projects_all ppa, hr_all_organization_units haou, oe_order_lines_all oola where ppa.segment1=:project_number and ppa.project_id=oola.project_id and (haou.name=:operating_unit or :operating_unit is null and oola.org_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat)) and haou.organization_id=oola.org_id and oola.item_type_code not in ('CLASS','MODEL','OPTION') ) LOV custom Y Y select ppa.project_number value, ppa.project_type||': '||ppa.name description from ( select ppa.segment1 project_number, ppa.name, ppa.project_type, ppa.org_id, ppa.creation_date from pa_projects_all ppa union all select psm.project_number, psm.project_name, 'PJM Seiban' project_type, psm.operating_unit, psm.creation_date from pjm_seiban_numbers psm ) ppa, hr_all_organization_units haou where (haou.name=:$flex$.operating_unit or :$flex$.operating_unit is null and ppa.org_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat)) and ppa.org_id=haou.organization_id order by ppa.creation_date desc, ppa.project_number desc US Project 42 250 1=1 msiv.inventory_item_id in ( select oola.inventory_item_id from pa_projects_all ppa, pa_tasks pt, oe_order_lines_all oola where pt.task_number=:task_number and ppa.segment1=:project_number and ppa.project_id=pt.project_id and ppa.project_id=oola.project_id and pt.task_id=oola.task_id ) LOV custom Y Y select pt.task_number value, pt.task_name||': '||pt.description description from pa_tasks pt, ( select ppa.project_id, ppa.segment1 project_number from pa_projects_all ppa union all select psm.project_id, psm.project_number from pjm_seiban_numbers psm ) ppa where ppa.project_number=:$flex$.project_number and pt.project_id=ppa.project_id order by pt.task_number US Task 43 255 1=1 msiv.inventory_item_id in ( select oola.inventory_item_id from hr_all_organization_units haou, oe_order_headers_all ooha, oe_order_lines_all oola where ooha.order_type_id in (select ottt.transaction_type_id from oe_transaction_types_tl ottt where ottt.name=:order_type and ottt.language=userenv('lang')) and (haou.name=:operating_unit or :operating_unit is null and ooha.org_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat)) and haou.organization_id=ooha.org_id and ooha.header_id=oola.header_id and oola.item_type_code not in ('CLASS','MODEL','OPTION') ) LOV custom Y select ottt.name value, xxen_util.meaning(otta.order_category_code,'ORDER_CATEGORY',660) description from oe_transaction_types_all otta, oe_transaction_types_tl ottt where (:$flex$.operating_unit is null or otta.org_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat where xxen_util.contains(:$flex$.operating_unit,mgoat.organization_name)='Y') ) and otta.transaction_type_code='ORDER' and otta.transaction_type_id=ottt.transaction_type_id and ottt.language=userenv('lang') order by decode(otta.order_category_code,'ORDER',1,'MIXED',2,3), ottt.name US Order Type 44 260 1=1 msiv.inventory_item_id in ( select oola.inventory_item_id from hr_all_organization_units haou, oe_order_lines_all oola where oola.schedule_ship_date>=:schedule_ship_date_from and (haou.name=:operating_unit or :operating_unit is null and oola.org_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat)) and haou.organization_id=oola.org_id and oola.item_type_code not in ('CLASS','MODEL','OPTION') ) Date US Sched. Ship Date From 45 265 1=1 msiv.inventory_item_id in ( select oola.inventory_item_id from hr_all_organization_units haou, oe_order_lines_all oola where oola.schedule_ship_date<:schedule_ship_date_to+1 and (haou.name=:operating_unit or :operating_unit is null and oola.org_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat)) and haou.organization_id=oola.org_id and oola.item_type_code not in ('CLASS','MODEL','OPTION') ) Date US Sched. Ship Date To 46 270 1=1 msiv.inventory_item_id in ( select oola.inventory_item_id from hr_all_organization_units haou, hz_parties hp, hz_cust_accounts hca, oe_order_headers_all ooha, oe_order_lines_all oola where hp.party_name=:customer_name and (haou.name=:operating_unit or :operating_unit is null and ooha.org_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat)) and haou.organization_id=ooha.org_id and hp.party_id=hca.party_id and hca.cust_account_id=ooha.sold_to_org_id and ooha.header_id=oola.header_id ) LOV custom Y Y select hp.party_name value, hca.account_number description from hz_parties hp, hz_cust_accounts hca where hp.party_id=hca.party_id and (:$flex$.operating_unit is null or hca.cust_account_id in (select hcasa.cust_account_id from hz_cust_acct_sites_all hcasa, mo_glob_org_access_tmp mgoat where hcasa.org_id = mgoat.organization_id and xxen_util.contains(:$flex$.operating_unit,mgoat.organization_name)='Y' ) ) order by hp.party_name US Customer 47 272 1=1 :p_supplier_name is not null and (msiv.organization_id,msiv.inventory_item_id) in (select to_number(substr(x.column_value,1,instr(x.column_value,'|')-1)),to_number(substr(x.column_value,instr(x.column_value,'|')+1)) from table(xxen_schub.get_supplier_item_list(:p_supplier_name)) x ) LOV custom Y select aps.vendor_name value, aps.segment1 description from ap_suppliers aps where (:$flex$.operating_unit is null or aps.vendor_id in (select assa.vendor_id from ap_supplier_sites_all assa, mo_glob_org_access_tmp mgoat where assa.org_id=mgoat.organization_id and xxen_util.contains(:$flex$.operating_unit,mgoat.organization_name)='Y' ) ) order by aps.vendor_name, aps.vendor_id US Supplier 48 275 1=1 :operating_unit=: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 select mgoat.organization_name from mo_glob_org_access_tmp mgoat where mgoat.organization_id = xxen_schub.get_curr_default_ou_id US Operating Unit 49 277 1=1 :planned_orgs_only is not null and msiv.organization_id in (select xspov.organization_id from xxen_schub_plan_orgs_v xspov where xspov.sr_instance_id=xxen_schub.get_planning_instance_id and xspov.compile_designator = xxen_schub.get_plan_name and nvl(xspov.plan_id,-99) = nvl(xxen_schub.get_plan_id,-99)) LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual Y US Plan Organizations Only 50 280 1=1 msiv.organization_id in (select haou.organization_id from hr_all_organization_units haou where haou.name=:organization_name) LOV custom Y select oav.organization_name value, oav.organization_code description from org_access_view oav, mtl_parameters mp where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id and oav.organization_id = mp.organization_id and ( nvl(fnd_profile.value('XXEN_SCHUB_EXCLUDE_INV_MASTER_ORG'),'Y') = 'N' or oav.organization_id != mp.master_organization_id ) and (:$flex$.plan_organizations_only is null or oav.organization_id in (select xspov.organization_id from xxen_schub_plan_orgs_v xspov where xspov.sr_instance_id=xxen_schub.get_planning_instance_id and xspov.compile_designator = xxen_schub.get_plan_name and nvl(xspov.plan_id,-99) = nvl(xxen_schub.get_plan_id,-99)) ) order by oav.organization_code select haou.name from hr_all_organization_units haou, mtl_parameters mp where haou.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') and haou.organization_id = mp.organization_id and ( nvl(fnd_profile.value('XXEN_SCHUB_EXCLUDE_INV_MASTER_ORG'),'N') = 'N' or haou.organization_id != mp.master_organization_id ) and xxen_schub.all_org_sd_flag is null US Organization Name 51 285 1=1 (msiv.inventory_item_id,msiv.organization_id) in ( select x.inventory_item_id, x.organization_id from ( select sum(moqd.primary_transaction_quantity) quantity, moqd.inventory_item_id, moqd.organization_id from mtl_onhand_quantities_detail moqd where moqd.subinventory_code=:secondary_inventory_name and (:organization_name is null or moqd.organization_id in (select haou.organization_id from hr_all_organization_units haou where haou.name=:organization_name)) group by moqd.inventory_item_id, moqd.organization_id having sum(moqd.primary_transaction_quantity)>0 ) x ) LOV custom Y select distinct msi.secondary_inventory_name value, msi.description from hr_all_organization_units haou, mtl_secondary_inventories msi where (:$flex$.organization_name is null or xxen_util.contains(:$flex$.organization_name,haou.name)='Y') and haou.organization_id=msi.organization_id order by msi.secondary_inventory_name US Subinventory 52 290 1=1 (msiv.inventory_item_id,msiv.organization_id) in ( select x.inventory_item_id, x.organization_id from ( select sum(moqd.primary_transaction_quantity) quantity, moqd.inventory_item_id, moqd.organization_id from mtl_onhand_quantities_detail moqd where moqd.locator_id in ( select milk.inventory_location_id from mtl_item_locations_kfv milk where milk.concatenated_segments=:locator and (:organization_name is null or milk.organization_id in (select haou.organization_id from hr_all_organization_units haou where haou.name=:organization_name)) and milk.subinventory_code=:secondary_inventory_name ) and moqd.subinventory_code=:secondary_inventory_name and (:organization_name is null or moqd.organization_id in (select haou.organization_id from hr_all_organization_units haou where haou.name=:organization_name)) group by moqd.inventory_item_id, moqd.organization_id having sum(moqd.primary_transaction_quantity)>0 ) x ) LOV custom Y select distinct milk.concatenated_segments value, milk.description from mtl_item_locations_kfv milk where (:$flex$.organization_name is null or milk.organization_id in (select haou.organization_id from hr_all_organization_units haou where xxen_util.contains(:$flex$.organization_name,haou.name)='Y')) and milk.subinventory_code=:$flex$.subinventory order by milk.concatenated_segments US Locator 53 300 1=1 :exception_message is not null and (msiv.organization_id,msiv.inventory_item_id) in (select to_number(substr(x.column_value,1,instr(x.column_value,'|')-1)), to_number(substr(x.column_value,instr(x.column_value,'|')+1)) from table(xxen_schub.get_exceptions_item_list(xxen_schub.get_planning_instance_id,xxen_schub.get_plan_id,xxen_schub.get_plan_name,null,:exception_message)) x ) LOV custom Y select y.exception_type value ,y.exception_cnt description from ( select substr(column_value,1, instr(column_value,'|',1,1)-1) exception_type , substr(column_value, instr(column_value,'|',1,1)+1) exception_cnt from table(xxen_schub.get_planning_excptns_summary(xxen_schub.get_planning_instance_id,xxen_schub.get_plan_id,xxen_schub.get_plan_name, :$flex$.Organization_Name)) order by exception_type asc ) y US Exception 54 310 1=1 :exception_exists='Y' and (msiv.organization_id,msiv.inventory_item_id) in (select to_number(substr(x.column_value,1,instr(x.column_value,'|')-1)), to_number(substr(x.column_value,instr(x.column_value,'|')+1)) from table(xxen_schub.get_exceptions_item_list(xxen_schub.get_planning_instance_id,xxen_schub.get_plan_id,xxen_schub.get_plan_name,null,null)) x ) 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 US Exception exists 55 1=1 :exception_exists='N' and (msiv.organization_id,msiv.inventory_item_id) not in (select to_number(substr(x.column_value,1,instr(x.column_value,'|')-1)), to_number(substr(x.column_value,instr(x.column_value,'|')+1)) from table(xxen_schub.get_exceptions_item_list(xxen_schub.get_planning_instance_id,xxen_schub.get_plan_id,xxen_schub.get_plan_name,null,null)) x ) N US Exception exists 56 320 1=1 :mrp_msc_order_type is not null and (msiv.organization_id,msiv.inventory_item_id) in (select to_number(substr(x.column_value,1,instr(x.column_value,'|')-1)), to_number(substr(x.column_value,instr(x.column_value,'|')+1)) from table(xxen_schub.get_order_type_item_list(xxen_schub.get_planning_instance_id,xxen_schub.get_plan_id,xxen_schub.get_plan_name,null,:mrp_msc_order_type,:p_action)) x ) LOV custom Y select y.order_type value ,null description from ( select column_value order_type from table(xxen_schub.get_planning_sd_types(xxen_schub.get_planning_instance_id,xxen_schub.get_plan_id,xxen_schub.get_plan_name, :$flex$.Organization_Name)) ) y order by value US MRP/MSC Order Type 57 325 1=1 :p_action=:p_action LOV custom Y select ml.meaning value, null description from mfg_lookups ml where ml.lookup_type = 'MRP_ACTIONS' and :$flex$.MRP_MSC_Order_Type is not null and (ml.lookup_code = 6 or (xxen_util.lookup_code(:$flex$.MRP_MSC_Order_Type,'MRP_ORDER_TYPE',700) = 5 and ml.lookup_code = 4) or (xxen_util.lookup_code(:$flex$.MRP_MSC_Order_Type,'MRP_ORDER_TYPE',700) in (1,2,3) and ml.lookup_code in (1,2,3)) ) order by value US Action 58 330 1=1 :planned_order_exists='Y' and (msiv.organization_id,msiv.inventory_item_id) in (select to_number(substr(x.column_value,1,instr(x.column_value,'|')-1)), to_number(substr(x.column_value,instr(x.column_value,'|')+1)) from table(xxen_schub.get_order_type_item_list(xxen_schub.get_planning_instance_id,xxen_schub.get_plan_id,xxen_schub.get_plan_name,null,xxen_util.meaning('5','MRP_ORDER_TYPE',700),null)) x ) 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 US Planned Order exists 59 1=1 :planned_order_exists='N' and (msiv.organization_id,msiv.inventory_item_id) not in (select to_number(substr(x.column_value,1,instr(x.column_value,'|')-1)), to_number(substr(x.column_value,instr(x.column_value,'|')+1)) from table(xxen_schub.get_order_type_item_list(xxen_schub.get_planning_instance_id,xxen_schub.get_plan_id,xxen_schub.get_plan_name,null,xxen_util.meaning('5','MRP_ORDER_TYPE',700),null)) x ) N US Planned Order exists 60 340 1=1 :planned_order_date_to is not null and (msiv.organization_id,msiv.inventory_item_id) in (select to_number(substr(x.column_value,1,instr(x.column_value,'|')-1)), to_number(substr(x.column_value,instr(x.column_value,'|')+1)) from table(xxen_schub.get_planned_date_to_item_list(xxen_schub.get_planning_instance_id,xxen_schub.get_plan_id,xxen_schub.get_plan_name,null,:planned_order_date_to)) x ) Date US Planned Order to Date 61 350 1=1 (msiv.inventory_item_id,msiv.organization_id) in ( select we.primary_item_id, we.organization_id from org_access_view oav, wip_entities we where oav.resp_application_id = fnd_global.resp_appl_id and oav.responsibility_id = fnd_global.resp_id and (:organization_name is null or oav.organization_name = :organization_name) and oav.organization_id = we.organization_id and we.wip_entity_name=:job_name ) LOV custom Y Y select x.value, x.description from ( select we.wip_entity_name value, xxen_util.meaning(wdj.status_type,'WIP_JOB_STATUS',700)||': '||wdj.scheduled_start_date||': '||msiv.description description, wdj.scheduled_start_date start_date from org_access_view oav, wip_entities we, wip_discrete_jobs wdj, mtl_system_items_vl msiv where oav.resp_application_id = fnd_global.resp_appl_id and oav.responsibility_id = fnd_global.resp_id and (:$flex$.organization_name is null or xxen_util.contains(:$flex$.organization_name,oav.organization_name)='Y') and oav.organization_id = we.organization_id and we.organization_id=wdj.organization_id and we.entity_type=1 and we.wip_entity_id=wdj.wip_entity_id and wdj.status_type in (1,10,11,13,14,15,16,17,3,6,8,9) and we.primary_item_id=msiv.inventory_item_id and we.organization_id=msiv.organization_id union select we.wip_entity_name value, xxen_util.meaning(gbh.batch_status,'GME_BATCH_STATUS',553)||': '||gbh.plan_start_date||': '||msiv.description description, gbh.plan_start_date start_date from org_access_view oav, wip_entities we, gme_batch_header gbh, mtl_system_items_vl msiv where oav.resp_application_id = fnd_global.resp_appl_id and oav.responsibility_id = fnd_global.resp_id and (:$flex$.organization_name is null or xxen_util.contains(:$flex$.organization_name,oav.organization_name)='Y') and oav.organization_id = we.organization_id and we.entity_type=10 and we.organization_id = gbh.organization_id and we.wip_entity_id=gbh.batch_id and gbh.batch_status in (1,2) and gbh.delete_mark = 0 and we.primary_item_id=msiv.inventory_item_id and we.organization_id=msiv.organization_id ) x order by x.start_date desc US WIP Job (open) 62 360 1=1 (msiv.inventory_item_id,msiv.organization_id) in ( select /*+ cardinality(wdj 10)*/ we.primary_item_id, we.organization_id from org_access_view oav, wip_discrete_jobs wdj, wip_entities we where oav.resp_application_id = fnd_global.resp_appl_id and oav.responsibility_id = fnd_global.resp_id and (:organization_name is null or oav.organization_name = :organization_name) and oav.organization_id = wdj.organization_id and wdj.status_type=to_number(xxen_util.lookup_code(:wip_status,'WIP_JOB_STATUS',700)) and wdj.wip_entity_id=we.wip_entity_id and wdj.organization_id=we.organization_id and we.entity_type=1 union select we.primary_item_id, we.organization_id from org_access_view oav, gme_batch_header gbh, wip_entities we where oav.resp_application_id = fnd_global.resp_appl_id and oav.responsibility_id = fnd_global.resp_id and (:organization_name is null or oav.organization_name = :organization_name) and oav.organization_id = gbh.organization_id and gbh.batch_status=to_number(xxen_util.lookup_code(:wip_status,'GME_BATCH_STATUS',553)) and gbh.batch_id=we.wip_entity_id and gbh.organization_id=we.organization_id and we.entity_type=10 ) LOV custom Y select x.value, sum(x.cnt) description from ( select xxen_util.meaning(wdj.status_type,'WIP_JOB_STATUS',700) value, count(*) cnt from org_access_view oav, wip_discrete_jobs wdj where oav.resp_application_id = fnd_global.resp_appl_id and oav.responsibility_id = fnd_global.resp_id and (:$flex$.organization_name is null or xxen_util.contains(:$flex$.organization_name,oav.organization_name)='Y') and oav.organization_id=wdj.organization_id and wdj.status_type != 12 group by wdj.status_type union select xxen_util.meaning(to_char(gbh.batch_status),'GME_BATCH_STATUS',553) value, count(*) cnt from org_access_view oav, gme_batch_header gbh where oav.resp_application_id = fnd_global.resp_appl_id and oav.responsibility_id = fnd_global.resp_id and (:$flex$.organization_name is null or xxen_util.contains(:$flex$.organization_name,oav.organization_name)='Y') and oav.organization_id=gbh.organization_id and gbh.batch_status != 4 group by gbh.batch_status ) x group by x.value order by sum(x.cnt) desc US WIP Job Status 63 370 1=1 (msiv.inventory_item_id,msiv.organization_id) in ( select we.primary_item_id, we.organization_id from org_access_view oav, wip_discrete_jobs wdj, wip_entities we where oav.resp_application_id = fnd_global.resp_appl_id and oav.responsibility_id = fnd_global.resp_id and (:organization_name is null or oav.organization_name = :organization_name) and oav.organization_id = wdj.organization_id and wdj.scheduled_start_date<:wip_start_date_to+1 and wdj.wip_entity_id=we.wip_entity_id and wdj.organization_id=we.organization_id and we.entity_type=1 and wdj.status_type=1 union select we.primary_item_id, we.organization_id from org_access_view oav, gme_batch_header gbh, wip_entities we where oav.resp_application_id = fnd_global.resp_appl_id and oav.responsibility_id = fnd_global.resp_id and (:organization_name is null or oav.organization_name = :organization_name) and oav.organization_id = gbh.organization_id and gbh.plan_start_date<:wip_start_date_to+1 and gbh.batch_id=we.wip_entity_id and gbh.organization_id=we.organization_id and we.entity_type=10 and gbh.batch_status=1 ) Date US Unrel. WIP Job to Date Item with unreleased WIP job up to date 64 380 1=1 (msiv.inventory_item_id,msiv.organization_id) in (select mss.inventory_item_id, mss.organization_id from (select distinct mss.inventory_item_id, mss.organization_id, max(mss.safety_stock_quantity) keep (dense_rank last order by mss.effectivity_date) over (partition by mss.organization_id,mss.inventory_item_id) safety_stock_quantity from mtl_safety_stocks mss where mss.effectivity_date<=sysdate ) mss where mss.safety_stock_quantity>=:safety_stock_quantity_from ) Number US Safety Stock at least