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 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 所有活动的清单组织代码，不包括主组织，仅限于当前用户的组织访问视图。 3866712BC93506CFE0636DFB0905937B select case when :purge_option is not null then xxen_upload.action_meaning(xxen_upload.action_update) else null end action_, case when :purge_option is not null then xxen_upload.status_meaning(xxen_upload.status_new) else null end status_, case when :purge_option is not null then xxen_util.description('U_EXCEL_MSG_VALIDATION_PENDING','XXEN_REPORT_TRANSLATIONS',0) else null end message_, null request_id_, null modified_columns_, to_number(null) upload_row, mpiv.physical_inventory_id, mp.organization_code, mpiv.physical_inventory_name, :purge_option purge_option, mpiv.description, mpiv.physical_inventory_date, xxen_util.meaning(mpiv.snapshot_complete,'INV_YES_NO',3) snapshot_complete from mtl_physical_inventories_v mpiv, mtl_parameters mp where 1=1 and mpiv.organization_id = mp.organization_id and mpiv.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) Y U A xxen_inv_upload.purge_physical_inventory US INV Physical Inventory Purge Upload This upload supports the purging of existing Physical Inventories. For each Physical Inventory to be purged the user can select to purge the tags only, or to purge the full Physical Inventory. On upload, the upload process will submit the standard 'Purge physical inventory information' concurrent program for each Physical Inventory to be purged. To improve performance of the upload process, the upload does not wait for completion of the purge concurrent requests before completing. The ‘Create, Update’ upload mode can be used to first download the Physical Inventories to be purged for initial review and selection. Alternatively, the ‘Create’ upload mode can be used to generate an empty upload excel into which the details of the Physical Inventories to be purged can be pasted. In this mode the only columns that need to be populated in the excel are the Organization Code, Physical Inventory Name, and the Purge Option. Enginatics R12 only Upload 1=1 :purge_option 1 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,U Y US Upload Mode 2 15 :purge_option LOV custom Y select meaning value, null description from mfg_lookups where lookup_type='MTL_PHYSICAL_PURGE_TYPE' order by value US Default Purge Option 3 20 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 4 30 1=1 mpiv.physical_inventory_name=:p_phys_inv_name LOV custom Y select mpiv.physical_inventory_name value, mpiv.description || ' (' || mp.organization_code || ')' description from mtl_physical_inventories_v mpiv, mtl_parameters mp where mpiv.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$.organization_code is null or xxen_util.contains(:$flex$.organization_code,mp.organization_code) = 'Y') order by value US Physical Inventory 5 40 1=1 lower(mpiv.physical_inventory_name) like lower(:p_phys_inv_name_like) || '%' Char US Physical Inventory Like 6 50 1=1 mpiv.physical_inventory_date >= trunc(:p_phys_inv_date_fr) Date US Physical Inventory Date From 7 60 1=1 mpiv.physical_inventory_date < trunc(:p_phys_inv_date_to)+1 Date US Physical Inventory Date To 8 65 1=1 mpiv.physical_inventory_date < add_months(trunc(sysdate),-1 * abs(:p_phys_inv_date_age)) Number US Phys. Inv. Date Older Than (Mths) 9 70 1=1 mpiv.freeze_date is not null 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 Y US Snapshot Complete 10 1=1 mpiv.freeze_date is null N US Snapshot Complete :$flex$.organization_code Organization Code Physical Inventory CB3427F76D0D8B8AD84A411814B246FA R12.1 Default Template R12.1 Default Template. Does not include the Serial Count and Serial Detail Option columns SYSADMIN 10 ALLOW_DYNAMIC_TAGS 13 ALL_SUBINVENTORIES 5 APPROVAL_REQUIRED 15 DELETE_SUBINVENTORY 3 DESCRIPTION 12 EXCLUDE_NEGATIVE_BALANCE 11 EXCLUDE_ZERO_BALANCE 17 FREEZE_DATE 1 ORGANIZATION_CODE 4 PHYSICAL_INVENTORY_DATE 2 PHYSICAL_INVENTORY_NAME 7 QUANTITY_TOLERANCE_MINUS 6 QUANTITY_TOLERANCE_PLUS 16 SNAPSHOT_COMPLETE 14 SUBINVENTORY 9 VALUE_TOLERANCE_MINUS 8 VALUE_TOLERANCE_PLUS S Site 1 ACTION_ Char varchar2 2 STATUS_ Char varchar2 3 MESSAGE_ Char varchar2 Y 4 REQUEST_ID_ Char varchar2 Y 5 MODIFIED_COLUMNS_ Char varchar2 Y 6 UPLOAD_ROW Number number 7 PHYSICAL_INVENTORY_ID Number number Y Y 8 ORGANIZATION_CODE LOV varchar2 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 ood.organization_id id, ood.organization_code value from org_organization_definitions ood Y Y 9 PHYSICAL_INVENTORY_NAME LOV custom varchar2 Y select mpiv.physical_inventory_name value, mpiv.description description from mtl_physical_inventories_v mpiv, mtl_parameters mp where mpiv.organization_id=mp.organization_id and mp.organization_code = :$column$.organization_code order by value Y Y 10 PURGE_OPTION LOV custom varchar2 Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='MTL_PHYSICAL_PURGE_TYPE' order by value :$flex$.default_purge_option Y 11 DESCRIPTION Char varchar2 select mpiv.description description from mtl_physical_inventories_v mpiv, mtl_parameters mp where mpiv.snapshot_complete = 2 and mpiv.organization_id=mp.organization_id and mp.organization_code = :$column$.organization_code and mpiv.physical_inventory_name = :$column$.physical_inventory_name 12 PHYSICAL_INVENTORY_DATE Date date select mpiv.physical_inventory_date from mtl_physical_inventories_v mpiv, mtl_parameters mp where mpiv.snapshot_complete = 2 and mpiv.organization_id=mp.organization_id and mp.organization_code = :$column$.organization_code and mpiv.physical_inventory_name = :$column$.physical_inventory_name 13 SNAPSHOT_COMPLETE Char varchar2 U 2 status_ out Char STATUS_CODE_ U 3 message_ out Char MESSAGE_ U 4 request_id_ out Number REQUEST_ID_ U 5 p_physical_inventory_id in/out Number PHYSICAL_INVENTORY_ID U 6 p_organization_id in Number ORGANIZATION_CODE U 7 p_physical_inventory_name in Char PHYSICAL_INVENTORY_NAME U 8 p_purge_option in Number PURGE_OPTION Order By upload_row, organization_code, physical_inventory_date desc, physical_inventory_name Success SQL select xu.action_, xu.status_, xu.message_, xu.request_id_, xu.modified_columns_, xu.upload_row, xu.physical_inventory_id, xu.organization_code, xu.physical_inventory_name, xu.purge_option, xu.description, xu.physical_inventory_date, xu.snapshot_complete from xxen_inv_physical_inven_6696_u xu Default value :$column$.organization_code ORGANIZATION_CODE DESCRIPTION Default value :$column$.physical_inventory_name PHYSICAL_INVENTORY_NAME DESCRIPTION Default value :$column$.organization_code ORGANIZATION_CODE PHYSICAL_INVENTORY_DATE Default value :$column$.physical_inventory_name PHYSICAL_INVENTORY_NAME PHYSICAL_INVENTORY_DATE LOV query :$column$.organization_code ORGANIZATION_CODE PHYSICAL_INVENTORY_NAME Default value :$flex$.default_purge_option Default Purge Option|:purge_option| PURGE_OPTION