ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 3866712BC93506CFE0636DFB0905937BY 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) 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 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 CB3427F76D0D8B8AD84A411814B246FA R12.1 Default Template R12.1 Default Template. Does not include the Serial Count and Serial Detail Option columns SYSADMIN 3 DESCRIPTION -5.0006 FREEZE_DATE 1 ORGANIZATION_CODE 4 PHYSICAL_INVENTORY_DATE 2 PHYSICAL_INVENTORY_NAME 5 SNAPSHOT_COMPLETE S Site ANDY.HAACK CB3427F76D0D8B8AD84A411814B246FA 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 3 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 30 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 2000 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 50 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