ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN E811F942597A2075E0530100007FF4F2 Blitz Upload Mode Y select xxen_upload.action_create id, xxen_upload.action_meaning(xxen_upload.action_create) value, null description from dual union all select xxen_upload.action_create || ',' || xxen_upload.action_update id, xxen_upload.action_meaning(xxen_upload.action_create)||', '||xxen_upload.action_meaning(xxen_upload.action_update) value, null description from dual US 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 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 F7A3C19E5B2D4488A1B2C3D4E5F60718Y select null action_, null status_, null message_, null request_id_, null modified_columns_, to_char(null) row_id, :p_upload_mode upload_mode, :p_source_code source_code, -- mp.organization_code, msd.schedule_designator, xxen_util.meaning(msd.schedule_type,'MRP_SCHEDULE_TYPE',700) schedule_type, msd.description schedule_description, msiv.concatenated_segments item, msiv.description item_description, msiv.primary_uom_code uom, msiv.planner_code planner, msdt.schedule_date, to_date(null) new_schedule_date, msdt.rate_end_date, msdt.schedule_quantity, to_char(null) workday_control, msdt.schedule_comments, msdt.attribute1, msdt.attribute2, msdt.attribute3, msdt.attribute4, msdt.attribute5, msdt.attribute6, msdt.attribute7, msdt.attribute8, msdt.attribute9, msdt.attribute10, msdt.attribute11, msdt.attribute12, msdt.attribute13, msdt.attribute14, msdt.attribute15, msdt.mps_transaction_id transaction_id, to_number(null) upload_row from mtl_parameters mp, mrp_schedule_designators msd, mrp_schedule_dates msdt, mtl_system_items_vl msiv where 1=1 and msd.organization_id=mp.organization_id and msd.organization_id=msdt.organization_id and msd.schedule_designator=msdt.schedule_designator and msdt.schedule_level=2 and msdt.organization_id=msiv.organization_id and msdt.inventory_item_id=msiv.inventory_item_id U A xxen_mrp_upload.upload_mrp_schedule_entry US MRP Master Schedule Upload MRP Master Schedule Upload ========================== - Create new MDS/MPS schedule entries. - Create and Update existing schedule entries. Each row stages one schedule entry into the MRP schedule interface (mrp_schedule_interface, process_status=2) for an existing schedule designator (MDS or MPS). The staged entries are loaded into the master schedule (mrp_schedule_dates) asynchronously by the customer's MRP Planning Manager. Upload Modes ============ Create - opens an empty spreadsheet to enter new schedule entries against any accessible schedule designator. Create and Update - downloads existing schedule entries for the selected schedule designators and lets the user add new entries and re-stage modifications. Existing entries are matched on the hidden Transaction Id. Prerequisites ============= - Schedule designators (Master Demand Schedule / Master Production Schedule) must be defined. Enginatics Upload 1=1 :p_source_code 1 -30 :p_source_code Char Blitz US Upload Source Code 2 10 1=1 :p_upload_mode like '%' || xxen_upload.action_update LOV Blitz Upload Mode E811F942597A2075E0530100007FF4F2 Y select xxen_upload.action_create id, xxen_upload.action_meaning(xxen_upload.action_create) value, null description from dual union all select xxen_upload.action_create || ',' || xxen_upload.action_update id, xxen_upload.action_meaning(xxen_upload.action_create)||', '||xxen_upload.action_meaning(xxen_upload.action_update) value, null description from dual C Y US Upload Mode 3 20 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) US Default Workday Control The default behaviour for handling a non-workday schedule date or rate end date. The options are Reject the schedule entry, shift the date backwards to the previous working bucket date, or shift the date forward to the next working bucket date. 4 30 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') US Organization Code 5 40 1=1 xxen_util.meaning(msd.schedule_type,'MRP_SCHEDULE_TYPE',700)=:p_schedule_type LOV custom Y select xxen_util.meaning(1,'MRP_SCHEDULE_TYPE',700) value, null description from dual union all select xxen_util.meaning(2,'MRP_SCHEDULE_TYPE',700) value, null description from dual US Schedule Type 6 50 1=1 msd.schedule_designator=:p_schedule_designator LOV custom Y select msd.schedule_designator value, msd.description from mrp_schedule_designators msd where trunc(sysdate)<=nvl(msd.disable_date,sysdate) and (:$flex$.organization_code is null or msd.organization_id in (select mp.organization_id from mtl_parameters mp where xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y')) and (:$flex$.schedule_type is null or xxen_util.meaning(msd.schedule_type,'MRP_SCHEDULE_TYPE',700)=:$flex$.schedule_type) and msd.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 Schedule Name 7 60 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 US Planner 8 70 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 US Item 9 80 1=1 msdt.schedule_date>=:schedule_date_from Date US Schedule Date From 10 90 1=1 msdt.schedule_date<:p_schedule_date_to+1 Date US Schedule Date To :$flex$.organization_code Organization Code Item :$flex$.organization_code Organization Code Planner :$flex$.organization_code Organization Code Schedule Name :$flex$.schedule_type Schedule Type Schedule Name A1B2C3D4E5F60718293A4B5C6D7E8F90 Create Opens an empty spreadsheet where the user can enter new schedule entries against any accessible schedule designator. SYSADMIN 5 ITEM 6 ITEM_DESCRIPTION 1 ORGANIZATION_CODE 8 PLANNER 12 SCHEDULE_COMMENTS 9 SCHEDULE_DATE 4 SCHEDULE_DESCRIPTION 2 SCHEDULE_DESIGNATOR 10 SCHEDULE_QUANTITY 3 SCHEDULE_TYPE 7 UOM 11 WORKDAY_CONTROL Organization Code Upload Mode C S Site Item Planner Schedule Date From Schedule Date To B2C3D4E5F60718293A4B5C6D7E8F90A1 Create and Update Downloads existing schedule entries for the selected schedule designators and lets the user add new entries and re-stage modifications. Existing entries are matched on the hidden Transaction Id. SYSADMIN 5 ITEM 6 ITEM_DESCRIPTION 10 NEW_SCHEDULE_DATE 1 ORGANIZATION_CODE 8 PLANNER 11 RATE_END_DATE 14 SCHEDULE_COMMENTS 9 SCHEDULE_DATE 4 SCHEDULE_DESCRIPTION 2 SCHEDULE_DESIGNATOR 12 SCHEDULE_QUANTITY 3 SCHEDULE_TYPE 7 UOM 13 WORKDAY_CONTROL Organization Code Upload Mode C,U S Site C3D4E5F60718293A4B5C6D7E8F90A1B2 Update Downloads existing schedule entries for the selected schedule designators and lets the user re-stage modifications. Existing entries are matched on the hidden Transaction Id. SYSADMIN 5 ITEM 6 ITEM_DESCRIPTION 10 NEW_SCHEDULE_DATE 1 ORGANIZATION_CODE 8 PLANNER 11 RATE_END_DATE 14 SCHEDULE_COMMENTS 9 SCHEDULE_DATE 4 SCHEDULE_DESCRIPTION 2 SCHEDULE_DESIGNATOR 12 SCHEDULE_QUANTITY 3 SCHEDULE_TYPE 7 UOM 13 WORKDAY_CONTROL Organization Code Upload Mode U S Site B2C3D4E5F60718293A4B5C6D7E8F90A1 1 ACTION_ Char varchar2 2 STATUS_ Char varchar2 3 MESSAGE_ Char varchar2 4 REQUEST_ID_ Char varchar2 Y 5 MODIFIED_COLUMNS_ Char varchar2 Y 6 ROW_ID Char varchar2 Y Y 7 UPLOAD_MODE Char varchar2 :$flex$.upload_mode Y Y 8 SOURCE_CODE Char varchar2 :$flex$.upload_source_code Y Y 9 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) order by value Y Y 10 SCHEDULE_DESIGNATOR LOV custom varchar2 Y select msd.schedule_designator value, msd.description from mtl_parameters mp, mrp_schedule_designators msd where mp.organization_code=:$column$.organization_code and msd.organization_id=mp.organization_id and trunc(sysdate)<=nvl(msd.disable_date,sysdate) order by value Y Y 11 SCHEDULE_TYPE LOV custom varchar2 Y select xxen_util.meaning(msd.schedule_type,'MRP_SCHEDULE_TYPE',700) value, null description from mtl_parameters mp, mrp_schedule_designators msd where mp.organization_code=:$column$.organization_code and msd.organization_id=mp.organization_id and msd.schedule_designator=:$column$.schedule_designator select xxen_util.meaning(msd.schedule_type,'MRP_SCHEDULE_TYPE',700) from mtl_parameters mp, mrp_schedule_designators msd where mp.organization_code=:$column$.organization_code and msd.organization_id=mp.organization_id and msd.schedule_designator=:$column$.schedule_designator Y 12 SCHEDULE_DESCRIPTION LOV custom varchar2 Y select msd.description value, null description from mtl_parameters mp, mrp_schedule_designators msd where mp.organization_code=:$column$.organization_code and msd.organization_id=mp.organization_id and msd.schedule_designator=:$column$.schedule_designator select msd.description from mtl_parameters mp, mrp_schedule_designators msd where mp.organization_code=:$column$.organization_code and msd.organization_id=mp.organization_id and msd.schedule_designator=:$column$.schedule_designator Y 13 ITEM LOV custom varchar2 Y Y select msiv.concatenated_segments value, 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 order by value Y Y 14 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 15 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 16 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 17 SCHEDULE_DATE Date date Y 18 NEW_SCHEDULE_DATE Date date 19 RATE_END_DATE Date date 20 SCHEDULE_QUANTITY Number number Y 21 WORKDAY_CONTROL LOV custom varchar2 Y select flvv.meaning value, flvv.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 22 SCHEDULE_COMMENTS Char varchar2 23 ATTRIBUTE1 Char varchar2 24 ATTRIBUTE2 Char varchar2 25 ATTRIBUTE3 Char varchar2 26 ATTRIBUTE4 Char varchar2 27 ATTRIBUTE5 Char varchar2 28 ATTRIBUTE6 Char varchar2 29 ATTRIBUTE7 Char varchar2 30 ATTRIBUTE8 Char varchar2 31 ATTRIBUTE9 Char varchar2 32 ATTRIBUTE10 Char varchar2 33 ATTRIBUTE11 Char varchar2 34 ATTRIBUTE12 Char varchar2 35 ATTRIBUTE13 Char varchar2 36 ATTRIBUTE14 Char varchar2 37 ATTRIBUTE15 Char varchar2 38 TRANSACTION_ID Number number Y Y 39 UPLOAD_ROW Number number Y U 1 action_ in Char ACTION_CODE_ U 3 p_transaction_id in Number TRANSACTION_ID U 4 p_organization_code in Char ORGANIZATION_CODE U 5 p_schedule_designator in Char SCHEDULE_DESIGNATOR U 6 p_item in Char ITEM U 7 p_schedule_date in Date SCHEDULE_DATE U 8 p_new_schedule_date in Date NEW_SCHEDULE_DATE U 9 p_rate_end_date in Date RATE_END_DATE U 10 p_schedule_quantity in Number SCHEDULE_QUANTITY U 11 p_workday_control in Char WORKDAY_CONTROL U 12 p_schedule_comments in Char SCHEDULE_COMMENTS U 13 p_source_code in Char SOURCE_CODE U 15 p_attribute1 in Char ATTRIBUTE1 U 16 p_attribute2 in Char ATTRIBUTE2 U 17 p_attribute3 in Char ATTRIBUTE3 U 18 p_attribute4 in Char ATTRIBUTE4 U 19 p_attribute5 in Char ATTRIBUTE5 U 20 p_attribute6 in Char ATTRIBUTE6 U 21 p_attribute7 in Char ATTRIBUTE7 U 22 p_attribute8 in Char ATTRIBUTE8 U 23 p_attribute9 in Char ATTRIBUTE9 U 24 p_attribute10 in Char ATTRIBUTE10 U 25 p_attribute11 in Char ATTRIBUTE11 U 26 p_attribute12 in Char ATTRIBUTE12 U 27 p_attribute13 in Char ATTRIBUTE13 U 28 p_attribute14 in Char ATTRIBUTE14 U 29 p_attribute15 in Char ATTRIBUTE15 U 30 p_row_id in/out Char ROW_ID U 31 request_id_ out Number REQUEST_ID_ U 32 status_ out Char STATUS_CODE_ U 33 message_ out Char MESSAGE_ Error SQL Order By schedule_designator, item, schedule_date Success SQL select xu.action_, xu.status_, xu.message_, xu.request_id_, xu.modified_columns_, xu.row_id, xu.upload_mode, xu.source_code, nvl(mp.organization_code,xu.organization_code) organization_code, nvl(msd.schedule_designator,xu.schedule_designator) schedule_designator, nvl(xxen_util.meaning(msd.schedule_type,'MRP_SCHEDULE_TYPE',700),xu.schedule_type) schedule_type, nvl(msd.description,xu.schedule_description) schedule_description, nvl(msiv.concatenated_segments,xu.item) item, nvl(msiv.description,xu.item_description) item_description, nvl(msiv.primary_uom_code,xu.uom) uom, nvl(msiv.planner_code,xu.planner) planner, nvl(msi.schedule_date,xu.schedule_date) schedule_date, nvl(msi.new_schedule_date,xu.new_schedule_date) new_schedule_date, nvl(msi.rate_end_date,xu.rate_end_date) rate_end_date, nvl(msi.schedule_quantity,xu.schedule_quantity) schedule_quantity, nvl(xxen_util.meaning(msi.workday_control,'MRP_WORKDAY_CONTROL_TYPE',700),xu.workday_control) workday_control, nvl(msi.schedule_comments,xu.schedule_comments) schedule_comments, nvl(msi.attribute1,xu.attribute1) attribute1, nvl(msi.attribute2,xu.attribute2) attribute2, nvl(msi.attribute3,xu.attribute3) attribute3, nvl(msi.attribute4,xu.attribute4) attribute4, nvl(msi.attribute5,xu.attribute5) attribute5, nvl(msi.attribute6,xu.attribute6) attribute6, nvl(msi.attribute7,xu.attribute7) attribute7, nvl(msi.attribute8,xu.attribute8) attribute8, nvl(msi.attribute9,xu.attribute9) attribute9, nvl(msi.attribute10,xu.attribute10) attribute10, nvl(msi.attribute11,xu.attribute11) attribute11, nvl(msi.attribute12,xu.attribute12) attribute12, nvl(msi.attribute13,xu.attribute13) attribute13, nvl(msi.attribute14,xu.attribute14) attribute14, nvl(msi.attribute15,xu.attribute15) attribute15, nvl(msi.transaction_id,xu.transaction_id) transaction_id, xu.upload_row from xxen_mrp_master_schedul_0216_u xu, mrp_schedule_interface msi, mtl_parameters mp, mrp_schedule_designators msd, mtl_system_items_vl msiv where msi.request_id(+)=to_number(xu.request_id_) and msi.source_line_id(+)=to_number(xu.row_id) and mp.organization_id(+)=msi.organization_id and msd.organization_id(+)=msi.organization_id and msd.schedule_designator(+)=msi.schedule_designator and msiv.organization_id(+)=msi.organization_id and msiv.inventory_item_id(+)=msi.inventory_item_id and xu.status_code_=xxen_upload.status_success