ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDEF179D2E0530100007F1FF2 INV Item Y Y select msiv.concatenated_segments value, msiv.description||' ('||mp.organization_code||')' description from mtl_system_items_vl msiv, mtl_parameters mp where ( :$flex$.organization_code is null and ( fnd_profile.value('MFG_ORGANIZATION_ID') is null and msiv.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=fnd_profile.value('MFG_ORGANIZATION_ID') ) or xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y' ) and msiv.organization_id=mp.organization_id order by mp.organization_code, msiv.concatenated_segments US Inventory items, restricted to the accessible inventory organizations 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 所有活动的清单组织代码，不包括主组织，仅限于当前用户的组织访问视图。 A5D770D0ECB301D5E0530100007F19A3 INV Planner Code (all) Y select mp.planner_code value, mp.description from mtl_planners mp where nvl(mp.disable_date,sysdate+1)>=sysdate and (:$flex$.organization_code is null or mp.organization_id in (select mp0.organization_id from mtl_parameters mp0 where xxen_util.contains(:$flex$.organization_code,mp0.organization_code)='Y')) order by mp.planner_code US EE0BAB77101DB1A6E0530100007F6311 MRP Bucket Type Y select flvv.meaning value, flvv.description description from fnd_lookup_values_vl flvv where flvv.lookup_type = 'MRP_BUCKET_TYPE' and flvv.view_application_id = 700 and flvv.enabled_flag = 'Y' and sysdate between nvl(flvv.start_date_active,sysdate) and nvl(flvv.end_date_active,sysdate) order by flvv.meaning US F45CD86816892A61E0530100007FC72D MRP Workday Control Y select flvv.meaning value, flvv.description description from fnd_lookup_values_vl flvv where flvv.lookup_type = 'MRP_WORKDAY_CONTROL_TYPE' and flvv.view_application_id = 700 and flvv.enabled_flag = 'Y' and sysdate between nvl(flvv.start_date_active,sysdate) and nvl(flvv.end_date_active,sysdate) order by flvv.meaning US 31BB3FD82A340ADBE06362FB0905F2D4Y select null action_, null status_, null message_, null request_id_, to_char(null) row_id, to_char(null) request_id, :p_upload_mode upload_mode, to_char(null) source_code, to_char(null) replace_forecast, -- mp.organization_code, mfds.forecast_set, mfds.forecast_designator forecast, mfds.description forecast_description, msiv.concatenated_segments item, msiv.description item_description, msiv.primary_uom_code uom, msiv.planner_code planner, mfd.forecast_date forecast_date, mfd.rate_end_date forecast_end_date, mfd.original_forecast_quantity original_quantity, mfd.current_forecast_quantity quantity, mfd.comments, xxen_util.meaning(mfd.bucket_type,'MRP_BUCKET_TYPE',700) bucket_type, to_char(null) workday_control, mfd.confidence_percentage, nvl( (select ppa.segment1 project_number from pa_projects_all ppa where ppa.project_id = mfd.project_id), (select psm.project_number from pjm_seiban_numbers psm where psm.project_id = mfd.project_id) ) project, (select pt.task_number from pa_tasks pt where pt.task_id = mfd.task_id) task, (select wl.line_code from wip_lines wl where wl.line_id = mfd.line_id and wl.organization_id = mfd.organization_id) wip_line_code, mfd.attribute_category, mfd.attribute1, mfd.attribute2, mfd.attribute3, mfd.attribute4, mfd.attribute5, mfd.attribute6, mfd.attribute7, mfd.attribute8, mfd.attribute9, mfd.attribute10, mfd.attribute11, mfd.attribute12, mfd.attribute13, mfd.attribute14, mfd.attribute15, mfd.transaction_id from mtl_parameters mp, mrp_forecast_designators mfds, mrp_forecast_items_v mfiv, mrp_forecast_dates mfd, mtl_system_items_vl msiv where 1=1 and mfds.forecast_set = nvl(:p_forecast_set,mfds.forecast_set) and mfds.organization_id = mp.organization_id and mfds.organization_id = mfiv.organization_id and mfds.forecast_designator = mfiv.forecast_designator and mfiv.organization_id = mfd.organization_id and mfiv.forecast_designator = mfd.forecast_designator and mfiv.inventory_item_id = mfd.inventory_item_id and mfiv.organization_id = msiv.organization_id and mfiv.inventory_item_id = msiv.inventory_item_id U F45116C306511365E0530100007FE422 (:Upload_Mode not like '%' || xxen_upload.action_update || '%' or :Forecast_Set is not null or :Forecast_Name is not null) A xxen_mrp_upload.upload_mrp_forecast_entry xxen_mrp_upload.do_forecast_import US MRP Item Forecast Upload - Training MRP Item Forecast Upload ================================ - Create New Item Forecast Entries. - Update Existing Item Forecast Entries. - Delete Existing Item Forecast Entries (Delete by setting the Forecast Quantity = 0). Prerequisites/Restrictions ========================== - Forecast Designators must be defined. - Item Forecasts can only be uploaded to a Forecast, not a Forecast Set. Upload Modes ============ Create ------ Opens an empty spreadsheet where the user can enter new Forecast Entries against any accessible Forecast. Use the Organization Code, Forecast Set, Forecast Name parameters to restrict the Organizations, Forecast Sets, and Forecasts LOVs in the spreadsheet. Create and Update ----------------- Create new Forecast Entries and/or Modify Existing Forecast Entries. Allows the user to - download existing Forecast Entries for the Forecasts meeting the entered selection criteria. - modify (add/update/delete) the Forecast Entries within the downloaded Forecasts. - create new Forecast Entries in any accessible Forecast. This mode allows the creation of Forecast Entries against Forecasts not included in the download. This mode can be used for downloading Forecast Entries from an existing Forecast and copying them to a different Forecast. Update ------ Modify (Add/Update/Delete) Forecast Entries against the downloaded Forecasts only. Allows the user to - download existing Forecast Entries for the Forecasts meeting the entered selection criteria. - modify (add/update/delete) the Forecast Entries within the downloaded Forecasts only. This mode does not allow the creation of Forecast Entries against Forecasts not included in the download. Parameters that control the upload behaviour: ====================================== Replace Forecast ----------------------- Select Yes if this upload will replace all existing entries in the forecast. In this case all existing forecast entries are deleted before the new forecast entries are loaded. Select No if this upload is creating new entries to add to the forecast and/or updating/deleting specific forecast entries. In this case the existing forecast entries are retained. Default Bucket Type --------------------------- This is the default bucket type used for the forecast entries if not specified in the upload spreadsheet. It will default from the selected forecast name, selected forecast set or will default to Days if a Forecast Set or Forecast Name is not specified. This can be overridden in the Upload spreadsheet for individual forecast entries. Default Workday Control --------------------------------- This parameter determines the default behaviour for handling a non-workday forecast date or forecast end date. The options are Reject the forecast entry, shift the date backwards to the previous working bucket date, or shift the date forward to the next working bucket date. This can be overridden in the Upload spreadsheet for individual forecast entries. A Forecast Set and/or Forecast Name must be entered in Update Mode Training Purposes Upload 1=1 :p_forecast_set :p_upload_mode 1 -30 :p_source_code Char Blitz US Upload Source Code 2 10 1=1 :p_upload_mode like '%' || xxen_upload.action_update LOV custom Y select xxen_upload.action_create id, xxen_upload.action_meaning(xxen_upload.action_create) value, 'Create new Forecast Entries in any accessible Forecast' description from dual union all select xxen_upload.action_update id, xxen_upload.action_meaning(xxen_upload.action_update) value, 'Download and add/update/delete Forecast Entries in the selected Forecasts only' description from dual union all select xxen_upload.action_create || ',' || xxen_upload.action_update id, xxen_upload.action_meaning(xxen_upload.action_create)||', '||xxen_upload.action_meaning(xxen_upload.action_update) value, 'Download Forecast Entries from selected Forecasts. Add/update/delete the existing Forecast Entries and/or Create new Forecast Entries in any accessible Forecast' description from dual order by 1 xxen_upload.action_meaning(xxen_upload.action_create) Y US Upload Mode 3 15 1=1 :p_replace_forecast=:p_replace_forecast 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 N US Replace Forecast Select Yes if this upload will replace all existing entries in the forecast. Select No if this upload is creating new entries to add to the forecast and/or updating specific forecast entries 4 20 1=1 :p_bucket_type=:p_bucket_type LOV MRP Bucket Type EE0BAB77101DB1A6E0530100007F6311 Y select flvv.meaning value, flvv.description description from fnd_lookup_values_vl flvv where flvv.lookup_type = 'MRP_BUCKET_TYPE' and flvv.view_application_id = 700 and flvv.enabled_flag = 'Y' and sysdate between nvl(flvv.start_date_active,sysdate) and nvl(flvv.end_date_active,sysdate) order by flvv.meaning select coalesce( (select xxen_util.meaning(mfds.bucket_type,'MRP_BUCKET_TYPE',700) from mrp_forecast_designators mfds where mfds.forecast_designator = :$flex$.forecast_name and (:$flex$.organization_code is null or mfds.organization_id in (select mp.organization_id from mtl_parameters mp where xxen_util.contains(:$flex$.organization_code,mp.organization_code) = 'Y')) and rownum <= 1 ), (select xxen_util.meaning(mfds.bucket_type,'MRP_BUCKET_TYPE',700) from mrp_forecast_designators mfds where mfds.forecast_designator = :$flex$.forecast_set and (:$flex$.organization_code is null or mfds.organization_id in (select mp.organization_id from mtl_parameters mp where xxen_util.contains(:$flex$.organization_code,mp.organization_code) = 'Y')) and rownum <= 1 ), 'Days' ) from dual Y US Default Bucket Type This is the default bucket type used for the forecast entries. It will default from the selected forecast name, selected forecast set or will default to Days if a Forecast Set or Forecast Name is not specified. 5 30 1=1 :p_workday_control=:p_workday_control LOV MRP Workday Control F45CD86816892A61E0530100007FC72D Y select flvv.meaning value, flvv.description description from fnd_lookup_values_vl flvv where flvv.lookup_type = 'MRP_WORKDAY_CONTROL_TYPE' and flvv.view_application_id = 700 and flvv.enabled_flag = 'Y' and sysdate between nvl(flvv.start_date_active,sysdate) and nvl(flvv.end_date_active,sysdate) order by flvv.meaning xxen_util.meaning(1,'MRP_WORKDAY_CONTROL_TYPE',700) Y US Default Workday Control The default behaviour for handling a non-workday forecast date or forecast end date. The options are Reject the forecast entry, shift the date backwards to the previous working bucket date, or shift the date forward to the next working bucket date. 6 50 1=1 mp.organization_code=:p_organization_code 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 select mp.organization_code from mtl_parameters mp where mp.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') F Code de l'organisation US Organization Code 7 60 :p_forecast_set LOV custom Y select distinct mfds.forecast_designator value, mfds.description from mrp_forecast_designators mfds where mfds.forecast_set is null and trunc(sysdate) <= nvl(mfds.disable_date,sysdate) and (:$flex$.organization_code is null or mfds.organization_id in (select mp.organization_id from mtl_parameters mp where xxen_util.contains(:$flex$.organization_code,mp.organization_code) = 'Y')) and mfds.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 value US Forecast Set 8 70 1=1 mfds.forecast_designator=:p_forecast_designator LOV custom Y select distinct mfds.forecast_designator value, mfds.description from mrp_forecast_designators mfds where mfds.forecast_set is not null and trunc(sysdate) <= nvl(mfds.disable_date,sysdate) and (:$flex$.forecast_set is null or mfds.forecast_set = :$flex$.forecast_set) and (:$flex$.organization_code is null or mfds.organization_id in (select mp.organization_id from mtl_parameters mp where xxen_util.contains(:$flex$.organization_code,mp.organization_code) = 'Y')) and mfds.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 value F Prévision US Forecast Name 9 80 1=1 msiv.planner_code=:p_planner_code LOV INV Planner Code (all) A5D770D0ECB301D5E0530100007F19A3 Y select mp.planner_code value, mp.description from mtl_planners mp where nvl(mp.disable_date,sysdate+1)>=sysdate and (:$flex$.organization_code is null or mp.organization_id in (select mp0.organization_id from mtl_parameters mp0 where xxen_util.contains(:$flex$.organization_code,mp0.organization_code)='Y')) order by mp.planner_code F Planificateur US Planner 10 90 1=1 msiv.concatenated_segments=:p_item LOV INV Item 8E2FF36EDEF179D2E0530100007F1FF2 Y Y select msiv.concatenated_segments value, msiv.description||' ('||mp.organization_code||')' description from mtl_system_items_vl msiv, mtl_parameters mp where ( :$flex$.organization_code is null and ( fnd_profile.value('MFG_ORGANIZATION_ID') is null and msiv.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=fnd_profile.value('MFG_ORGANIZATION_ID') ) or xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y' ) and msiv.organization_id=mp.organization_id order by mp.organization_code, msiv.concatenated_segments F Article US Item 11 100 1=1 mfd.project_id in ( select ppa.project_id from ( select ppa.segment1 project, ppa.project_id, ppa.org_id from pa_projects_all ppa union all select psm.project_number project, psm.project_id, psm.operating_unit org_id from pjm_seiban_numbers psm ) ppa where ppa.project = :p_project ) 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, ppa.project_id from pa_projects_all ppa union all select psm.project_number, psm.project_name, 'PJM Seiban' project_type, psm.operating_unit, psm.creation_date, psm.project_id from pjm_seiban_numbers psm ) ppa where ppa.project_id in ( select mfd.project_id from mrp_forecast_designators mfds, mrp_forecast_dates mfd where mfds.organization_id = mfd.organization_id and mfds.forecast_designator = mfd.forecast_designator and mfds.forecast_set = :$flex$.forecast_set and (:$flex$.forecast_name is null or xxen_util.contains(:$flex$.forecast_name,mfds.forecast_designator) = 'Y') and (:$flex$.organization_code is null or mfds.organization_id in (select mp.organization_id from mtl_parameters mp where xxen_util.contains(:$flex$.organization_code,mp.organization_code) = 'Y')) and mfds.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) and mfd.project_id is not null ) order by ppa.creation_date desc, ppa.project_number desc F Projet US Project 12 110 1=1 mfd.forecast_date>=:forecast_date_from Date F Date prévisionnelle du US Forecast Date From 13 120 1=1 mfd.forecast_date<:p_forecast_date_to+1 Date F Date prévisionnelle jusqu'au US Forecast Date To 1 ACTION_ Char varchar2 2 STATUS_ Char varchar2 3 MESSAGE_ Char varchar2 4 REQUEST_ID_ Char varchar2 Y 5 ROW_ID Char varchar2 Y 6 REQUEST_ID Char varchar2 Y 7 UPLOAD_MODE Char varchar2 :$flex$.upload_mode Y 8 SOURCE_CODE Char varchar2 :$flex$.upload_source_code Y 9 REPLACE_FORECAST Char varchar2 :$flex$.replace_forecast Y 10 ORGANIZATION_CODE LOV custom varchar2 Y select ood.organization_code value, ood.organization_name description from mtl_parameters mp, org_organization_definitions ood where ood.organization_id = mp.organization_id 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) and (:$flex$.upload_mode not in (xxen_upload.action_meaning(xxen_upload.action_create),xxen_upload.action_meaning(xxen_upload.action_update)) or mp.organization_id in (select mp2.organization_id from mtl_parameters mp2, mrp_forecast_designators mfds2 where mp2.organization_id = mfds2.organization_id and mfds2.forecast_set = nvl(:$flex$.forecast_set,mfds2.forecast_set) and (:$flex$.forecast_name is null or xxen_util.contains(:$flex$.forecast_name,mfds2.forecast_designator) = 'Y') and (:$flex$.organization_code is null or xxen_util.contains(:$flex$.organization_code,mp2.organization_code) = 'Y') ) ) order by value Y Y 11 FORECAST_SET LOV custom varchar2 Y select mfds.forecast_designator value, mfds.description description from mtl_parameters mp, mrp_forecast_designators mfds where mp.organization_code = :$column$.organization_code and mfds.organization_id = mp.organization_id and trunc(sysdate) < nvl(mfds.disable_date,sysdate) and mfds.forecast_set is null and (:$flex$.upload_mode not in (xxen_upload.action_meaning(xxen_upload.action_create),xxen_upload.action_meaning(xxen_upload.action_update)) or (mfds.organization_id,mfds.forecast_designator) in (select mfds2.organization_id,mfds2.forecast_set from mrp_forecast_designators mfds2 where mfds2.forecast_set = nvl(:$flex$.forecast_set,mfds2.forecast_set) and (:$flex$.forecast_name is null or xxen_util.contains(:$flex$.forecast_name,mfds2.forecast_designator) = 'Y') ) ) and (:$column$.forecast is null or mfds.forecast_designator = (select mfds2.forecast_set from mrp_forecast_designators mfds2 where mfds2.organization_id = mp.organization_id and mfds2.forecast_designator = :$column$.forecast) ) order by value Y 12 FORECAST LOV custom varchar2 Y select mfds.forecast_designator value, mfds.description description from mtl_parameters mp, mrp_forecast_designators mfds where mp.organization_code = :$column$.organization_code and mfds.organization_id = mp.organization_id and trunc(sysdate) < nvl(mfds.disable_date,sysdate) and mfds.forecast_set is not null and (:$flex$.upload_mode not in (xxen_upload.action_meaning(xxen_upload.action_create),xxen_upload.action_meaning(xxen_upload.action_update)) or (mfds.organization_id,mfds.forecast_designator) in (select mfds2.organization_id,mfds2.forecast_designator from mrp_forecast_designators mfds2 where mfds2.forecast_set = nvl(:$flex$.forecast_set,mfds2.forecast_set) and (:$flex$.forecast_name is null or xxen_util.contains(:$flex$.forecast_name,mfds2.forecast_designator) = 'Y') ) ) and mfds.forecast_set = nvl(:$column$.forecast_set,mfds.forecast_set) order by value Y Y 13 FORECAST_DESCRIPTION LOV custom varchar2 Y select mfds.description value, null description from mtl_parameters mp, mrp_forecast_designators mfds where mp.organization_code = :$column$.organization_code and mfds.organization_id = mp.organization_id and mfds.forecast_designator = :$column$.forecast select mfds.description from mtl_parameters mp, mrp_forecast_designators mfds where mp.organization_code = :$column$.organization_code and mfds.organization_id = mp.organization_id and mfds.forecast_designator = :$column$.forecast Y 14 ITEM LOV custom varchar2 Y Y select msiv.concatenated_segments value, msiv.description description from mtl_parameters mp, mtl_system_items_vl msiv where mp.organization_code = :$column$.organization_code and msiv.organization_id = mp.organization_id and msiv.effectivity_control != 2 and not (msiv.mrp_planning_code = 6 and msiv.bom_item_type = 4) -- not planned standard item order by value Y Y 15 ITEM_DESCRIPTION LOV custom varchar2 Y select msiv.description value, null description from mtl_parameters mp, mtl_system_items_vl msiv where mp.organization_code = :$column$.organization_code and msiv.organization_id = mp.organization_id and msiv.concatenated_segments = :$column$.item select msiv.description from mtl_parameters mp, mtl_system_items_vl msiv where mp.organization_code = :$column$.organization_code and msiv.organization_id = mp.organization_id and msiv.concatenated_segments = :$column$.item Y 16 UOM LOV custom varchar2 Y select msiv.primary_uom_code value, null description from mtl_parameters mp, mtl_system_items_vl msiv where mp.organization_code = :$column$.organization_code and msiv.organization_id = mp.organization_id and msiv.concatenated_segments = :$column$.item select msiv.primary_uom_code from mtl_parameters mp, mtl_system_items_vl msiv where mp.organization_code = :$column$.organization_code and msiv.organization_id = mp.organization_id and msiv.concatenated_segments = :$column$.item Y 17 PLANNER LOV custom varchar2 Y select msiv.planner_code value, null description from mtl_parameters mp, mtl_system_items_vl msiv where mp.organization_code = :$column$.organization_code and msiv.organization_id = mp.organization_id and msiv.concatenated_segments = :$column$.item select msiv.planner_code from mtl_parameters mp, mtl_system_items_vl msiv where mp.organization_code = :$column$.organization_code and msiv.organization_id = mp.organization_id and msiv.concatenated_segments = :$column$.item Y 18 FORECAST_DATE Date date Y 19 FORECAST_END_DATE Date date 20 ORIGINAL_QUANTITY Number number 21 QUANTITY Number number Y 22 COMMENTS Char varchar2 23 BUCKET_TYPE LOV custom varchar2 Y select flvv.meaning value, flvv.description description from fnd_lookup_values_vl flvv where flvv.lookup_type = 'MRP_BUCKET_TYPE' and flvv.view_application_id = 700 and flvv.enabled_flag = 'Y' and sysdate between nvl(flvv.start_date_active,sysdate-1) and nvl(flvv.end_date_active,sysdate+1) order by flvv.meaning :$flex$.default_bucket_type 24 WORKDAY_CONTROL LOV custom varchar2 Y select flvv.meaning value, flvv.description description from fnd_lookup_values_vl flvv where flvv.lookup_type = 'MRP_WORKDAY_CONTROL_TYPE' and flvv.view_application_id = 700 and flvv.enabled_flag = 'Y' and sysdate between nvl(flvv.start_date_active,sysdate-1) and nvl(flvv.end_date_active,sysdate+1) order by flvv.meaning :$flex$.default_workday_control 25 CONFIDENCE_PERCENTAGE Number number 100 Y 26 PROJECT LOV custom varchar2 Y select ppa.project_number value, ppa.project_type||': '||ppa.name description from org_organization_definitions ood, ( select ppa.segment1 project_number, ppa.name, ppa.project_type, ppa.org_id, ppa.creation_date, ppa.project_id from pa_projects_all ppa union all select psm.project_number, psm.project_name, 'PJM Seiban' project_type, psm.operating_unit, psm.creation_date, psm.project_id from pjm_seiban_numbers psm ) ppa where ood.organization_code = :$column$.organization_code and ppa.org_id = ood.operating_unit order by ppa.creation_date desc, ppa.project_number desc 27 TASK LOV custom varchar2 Y select pt.task_number value, pt.description description from org_organization_definitions ood, ( select ppa.segment1 project_number, ppa.name, ppa.project_type, ppa.org_id, ppa.creation_date, ppa.project_id from pa_projects_all ppa union all select psm.project_number, psm.project_name, 'PJM Seiban' project_type, psm.operating_unit, psm.creation_date, psm.project_id from pjm_seiban_numbers psm ) ppa, pa_tasks pt where ood.organization_code = :$column$.organization_code and ppa.org_id = ood.operating_unit and ppa.project_number = :$column$.project and pt.project_id = ppa.project_id order by pt.task_number 28 WIP_LINE_CODE Char varchar2 29 ATTRIBUTE_CATEGORY Char varchar2 30 ATTRIBUTE1 Char varchar2 31 ATTRIBUTE2 Char varchar2 32 ATTRIBUTE3 Char varchar2 33 ATTRIBUTE4 Char varchar2 34 ATTRIBUTE5 Char varchar2 35 ATTRIBUTE6 Char varchar2 36 ATTRIBUTE7 Char varchar2 37 ATTRIBUTE8 Char varchar2 38 ATTRIBUTE9 Char varchar2 39 ATTRIBUTE10 Char varchar2 40 ATTRIBUTE11 Char varchar2 41 ATTRIBUTE12 Char varchar2 42 ATTRIBUTE13 Char varchar2 43 ATTRIBUTE14 Char varchar2 44 ATTRIBUTE15 Char varchar2 45 TRANSACTION_ID Number number Y Y U 1 action_ in Char ACTION_CODE_ U 2 p_transaction_id in Number TRANSACTION_ID U 3 p_organization_code in Char ORGANIZATION_CODE U 4 p_forecast_designator in Char FORECAST U 5 p_item in Char ITEM U 6 p_forecast_date in Date FORECAST_DATE U 7 p_forecast_end_date in Date FORECAST_END_DATE U 8 p_quantity in Number QUANTITY U 9 p_comments in Char COMMENTS U 10 p_bucket_type in Char BUCKET_TYPE U 11 p_workday_control in Char WORKDAY_CONTROL U 12 p_confidence_percentage in Number CONFIDENCE_PERCENTAGE U 13 p_source_code in Char SOURCE_CODE U 14 p_project in Char PROJECT U 15 p_task in Char TASK U 16 p_wip_line_code in Char WIP_LINE_CODE U 17 p_attribute_category in Char ATTRIBUTE_CATEGORY U 18 p_attribute1 in Char ATTRIBUTE1 U 19 p_attribute2 in Char ATTRIBUTE2 U 20 p_attribute3 in Char ATTRIBUTE3 U 21 p_attribute4 in Char ATTRIBUTE4 U 22 p_attribute5 in Char ATTRIBUTE5 U 23 p_attribute6 in Char ATTRIBUTE6 U 24 p_attribute7 in Char ATTRIBUTE7 U 25 p_attribute8 in Char ATTRIBUTE8 U 26 p_attribute9 in Char ATTRIBUTE9 U 27 p_attribute10 in Char ATTRIBUTE10 U 28 p_attribute11 in Char ATTRIBUTE11 U 29 p_attribute12 in Char ATTRIBUTE12 U 30 p_attribute13 in Char ATTRIBUTE13 U 31 p_attribute14 in Char ATTRIBUTE14 U 32 p_attribute15 in Char ATTRIBUTE15 U 33 p_row_id in/out Char ROW_ID U 34 request_id_ out Number REQUEST_ID_ U 35 status_ out Char STATUS_CODE_ U 36 message_ out Char MESSAGE_ P 1 p_upload_mode in Char UPLOAD_MODE P 2 p_replace_forecast in Char REPLACE_FORECAST P 3 p_request_id in Number REQUEST_ID P 4 request_id_ out Number REQUEST_ID_ P 5 status_ out Char STATUS_CODE_ P 6 message_ out Char MESSAGE_ Order By forecast, item, forecast_date asc Success SQL select xxen_upload.action_meaning(decode(xm.pstatus,xxen_upload.status_success,xxen_upload.action_processed,xm.action_))action_, xxen_upload.status_meaning(xm.pstatus) status_, case when xm.pstatus = xxen_upload.status_success and mfd.transaction_id is null then 'Forecast Entry Deleted' else xm.pmsg end message_, xm.request_id_, xm.row_id, xm.request_id, xm.upload_mode, xm.source_code, xm.replace_forecast, -- decode(xm.pstatus,xxen_upload.status_error,xm.organization_code,nvl(mp.organization_code,xm.organization_code)) organization_code, decode(xm.pstatus,xxen_upload.status_error,xm.forecast_set,nvl(mfds.forecast_set,xm.forecast_set)) forecast_set, decode(xm.pstatus,xxen_upload.status_error,xm.forecast,nvl(mfds.forecast_designator,xm.forecast)) forecast, decode(xm.pstatus,xxen_upload.status_error,xm.forecast_description,nvl(mfds.description,xm.forecast_description)) forecast_description, decode(xm.pstatus,xxen_upload.status_error,xm.item,nvl(msiv.concatenated_segments,xm.item)) item, decode(xm.pstatus,xxen_upload.status_error,xm.item_description,nvl(msiv.description,xm.item_description)) item_description, decode(xm.pstatus,xxen_upload.status_error,xm.uom,nvl(msiv.primary_uom_code,xm.uom)) uom, decode(xm.pstatus,xxen_upload.status_error,xm.planner,nvl(msiv.planner_code,xm.planner)) planner, decode(xm.pstatus,xxen_upload.status_error,xm.forecast_date,nvl(mfd.forecast_date,xm.forecast_date)) forecast_date, decode(xm.pstatus,xxen_upload.status_error,xm.forecast_end_date,nvl(mfd.rate_end_date,xm.forecast_end_date)) forecast_end_date, decode(xm.pstatus,xxen_upload.status_error,to_number(xm.original_quantity),nvl(mfd.original_forecast_quantity,to_number(xm.original_quantity))) original_quantity, decode(xm.pstatus,xxen_upload.status_error,to_number(xm.quantity),nvl(mfd.current_forecast_quantity,to_number(xm.quantity))) quantity, decode(xm.pstatus,xxen_upload.status_error,xm.comments,nvl(mfd.comments,xm.comments)) comments, decode(xm.pstatus,xxen_upload.status_error,xm.bucket_type,nvl(xxen_util.meaning(mfd.bucket_type,'MRP_BUCKET_TYPE',700),xm.bucket_type)) bucket_type, xm.workday_control, decode(xm.pstatus,xxen_upload.status_error,to_number(xm.confidence_percentage),nvl(mfd.confidence_percentage,to_number(xm.confidence_percentage))) confidence_percentage, decode(xm.pstatus,xxen_upload.status_error,xm.project, coalesce( (select ppa.segment1 project_number from pa_projects_all ppa where ppa.project_id = mfd.project_id), (select psm.project_number from pjm_seiban_numbers psm where psm.project_id = mfd.project_id), xm.project ) ) project, decode(xm.pstatus,xxen_upload.status_error,xm.task,nvl((select pt.task_number from pa_tasks pt where pt.task_id = mfd.task_id),xm.task)) task, decode(xm.pstatus,xxen_upload.status_error,xm.wip_line_code,nvl((select wl.line_code from wip_lines wl where wl.line_id = mfd.line_id and wl.organization_id = mfd.organization_id),xm.wip_line_code)) wip_line_code, decode(xm.pstatus,xxen_upload.status_error,xm.attribute_category,nvl(mfd.attribute_category,xm.attribute_category)) attribute_category, decode(xm.pstatus,xxen_upload.status_error,xm.attribute1 ,nvl(mfd.attribute1 ,xm.attribute1 )) attribute1, decode(xm.pstatus,xxen_upload.status_error,xm.attribute2 ,nvl(mfd.attribute2 ,xm.attribute2 )) attribute2, decode(xm.pstatus,xxen_upload.status_error,xm.attribute3 ,nvl(mfd.attribute3 ,xm.attribute3 )) attribute3, decode(xm.pstatus,xxen_upload.status_error,xm.attribute4 ,nvl(mfd.attribute4 ,xm.attribute4 )) attribute4, decode(xm.pstatus,xxen_upload.status_error,xm.attribute5 ,nvl(mfd.attribute5 ,xm.attribute5 )) attribute5, decode(xm.pstatus,xxen_upload.status_error,xm.attribute6 ,nvl(mfd.attribute6 ,xm.attribute6 )) attribute6, decode(xm.pstatus,xxen_upload.status_error,xm.attribute7 ,nvl(mfd.attribute7 ,xm.attribute7 )) attribute7, decode(xm.pstatus,xxen_upload.status_error,xm.attribute8 ,nvl(mfd.attribute8 ,xm.attribute8 )) attribute8, decode(xm.pstatus,xxen_upload.status_error,xm.attribute9 ,nvl(mfd.attribute9 ,xm.attribute9 )) attribute9, decode(xm.pstatus,xxen_upload.status_error,xm.attribute10,nvl(mfd.attribute10,xm.attribute10)) attribute10, decode(xm.pstatus,xxen_upload.status_error,xm.attribute11,nvl(mfd.attribute11,xm.attribute11)) attribute11, decode(xm.pstatus,xxen_upload.status_error,xm.attribute12,nvl(mfd.attribute12,xm.attribute12)) attribute12, decode(xm.pstatus,xxen_upload.status_error,xm.attribute13,nvl(mfd.attribute13,xm.attribute13)) attribute13, decode(xm.pstatus,xxen_upload.status_error,xm.attribute14,nvl(mfd.attribute14,xm.attribute14)) attribute14, decode(xm.pstatus,xxen_upload.status_error,xm.attribute15,nvl(mfd.attribute15,xm.attribute15)) attribute15, decode(xm.pstatus,xxen_upload.status_error,to_number(xm.transaction_id),nvl(mfd.transaction_id,to_number(xm.transaction_id))) transaction_id from mtl_parameters mp, mrp_forecast_designators mfds, mrp_forecast_items_v mfiv, mrp_forecast_dates mfd, mtl_system_items_vl msiv, (select decode(xm.status_,xxen_upload.status_error,xm.status_,xxen_upload.status_valid,xxen_upload.status_error,xxen_mrp_upload.get_status_(xm.request_id_,xm.row_id)) pstatus, decode(xm.status_,xxen_upload.status_error,xm.message_,xxen_upload.status_valid,'Post Processing Failed',xxen_mrp_upload.get_message_(xm.request_id_,xm.row_id)) pmsg, xm.* from xxen_mrp_item_forecast_1745_u xm ) xm where mfd.request_id (+) = to_number(xm.request_id_) and mfd.source_line_id (+) = to_number(xm.row_id) and mfiv.organization_id (+) = mfd.organization_id and mfiv.forecast_designator (+) = mfd.forecast_designator and mfiv.inventory_item_id (+) = mfd.inventory_item_id and mfds.organization_id (+) = mfiv.organization_id and mfds.forecast_designator (+) = mfiv.forecast_designator and mp.organization_id (+) = mfds.organization_id and msiv.organization_id (+) = mfiv.organization_id and msiv.inventory_item_id (+) = mfiv.inventory_item_id