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 3DBCBE9D85316C0CE0630100007F2A8F select x.* from ( select null action_, null status_, null message_, null modified_columns_, 'SUBINVENTORY' default_type, decode(misd.default_type,1,'Shipping',2,'Receiving',3,'Move Order Receipt') default_for, haouv.name organization, msiv.concatenated_segments item, misd.subinventory_code subinventory, null locator from mtl_item_sub_defaults misd, hr_all_organization_units_vl haouv, mtl_system_items_vl msiv where haouv.organization_id=misd.organization_id and msiv.organization_id=haouv.organization_id and msiv.inventory_item_id=misd.inventory_item_id and 1=1 union all select null action_, null status_, null message_, null modified_columns_, 'LOCATOR' default_type, decode(mild.default_type,1,'Shipping',2,'Receiving',3,'Move Order Receipt') default_for, haouv.name organization, msiv.concatenated_segments item, mild.subinventory_code subinventory, milk.concatenated_segments locator from mtl_item_loc_defaults mild, hr_all_organization_units_vl haouv, mtl_system_items_vl msiv, mtl_item_locations_kfv milk where haouv.organization_id=mild.organization_id and msiv.organization_id=haouv.organization_id and msiv.inventory_item_id=mild.inventory_item_id and mild.locator_id=milk.inventory_location_id and mild.organization_id=milk.organization_id and 1=1 ) x where 2=2 Y U A xxen_inv_upload.create_item_sub_loc_defaults US INV Item Transaction Defaults Upload This upload can be used to create and update Item transaction default subinventories and locators Enginatics R12 only Upload 1=1 2=2 1 10 1=1 haouv.name=:name LOV custom Y select haouv.name value, null description from mtl_parameters mp, hr_all_organization_units_vl haouv where mp.organization_id=haouv.organization_id coalesce(xxen_util.default_operating_unit,xxen_util.previous_parameter_value(:parameter_id)) Y US Organization 2 20 1=1 :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 Y US Upload Mode 3 30 2=2 x.default_type=:default_type LOV custom Y select 'SUBINVENTORY' value, 'Subinventory' description from dual union all select 'LOCATOR' value, 'Locator' description from dual US Default Type 1 ACTION_ Char varchar2 2 STATUS_ Char varchar2 3 MESSAGE_ Char varchar2 4 MODIFIED_COLUMNS_ Char varchar2 5 DEFAULT_TYPE LOV custom varchar2 Y select 'SUBINVENTORY' value, 'Subinventory' description from dual union all select 'LOCATOR' value, 'Locator' description from dual Y 6 DEFAULT_FOR LOV custom varchar2 Y select 1 id, 'Shipping' value, null description from dual union all select 2 id, 'Receiving' value, null description from dual union all select 3 id, 'Move Order Receipt' value, null description from dual Y 7 ORGANIZATION LOV custom varchar2 Y select haouv.name value, null description from mtl_parameters mp, hr_all_organization_units_vl haouv where mp.organization_id=haouv.organization_id select haouv.organization_id id, haouv.name value, null description from hr_all_organization_units_vl haouv :$flex$.organization Y 8 ITEM LOV custom varchar2 Y Y select msiv.inventory_item_id id, msiv.concatenated_segments value, msiv.description from mtl_system_items_vl msiv, hr_all_organization_units_vl haouv where haouv.name=:$column$.organization and msiv.organization_id=haouv.organization_id Y 9 SUBINVENTORY LOV custom varchar2 Y select msvv.secondary_inventory_name value, msvv.description from mtl_subinventories_val_v msvv , mtl_parameters mp, hr_all_organization_units_vl haouv where mp.organization_id=haouv.organization_id and msvv.organization_id=mp.organization_id and haouv.name=:$column$.organization and :$column$.default_type='SUBINVENTORY' union select msvv.secondary_inventory_name value, msvv.description from mtl_subinventories_val_v msvv, mtl_parameters mp, mtl_system_items_b msib, hr_all_organization_units_vl haouv where msvv.organization_id=mp.organization_id and mp.organization_id=haouv.organization_id and :$column$.default_type='LOCATOR' and haouv.name=:$column$.organization and msib.segment1=:$column$.item and msib.organization_id=mp.organization_id and (mp.stock_locator_control_code in (2,3) or (msvv.locator_type in (2,3)) or (nvl(msib.location_control_code,1) in (2,3) and msvv.locator_type in (4, 5))) and exists ( select null from mtl_item_locations mm where mm.subinventory_code=msvv.secondary_inventory_name and mm.organization_id=mp.organization_id and nvl(mm.disable_date,sysdate+1)>sysdate ) order by value Y 10 LOCATOR LOV custom varchar2 Y select milk.inventory_location_id id, milk.concatenated_segments value, milk.description from mtl_item_locations_kfv milk, hr_all_organization_units_vl haouv where haouv.name=:$column$.organization and milk.organization_id = haouv.organization_id and milk.subinventory_code=:$column$.subinventory and :$column$.default_type='LOCATOR' and nvl(milk.disable_date,sysdate) >= sysdate U 1 action_ in Char ACTION_CODE_ U 2 status_ out Char STATUS_CODE_ U 3 message_ out Char MESSAGE_ U 4 p_entity in Char DEFAULT_TYPE U 5 p_default_type_id in Number DEFAULT_FOR U 6 p_organization_id in Number ORGANIZATION U 7 p_inventory_item_id in Number ITEM U 8 p_subinventory_code in Char SUBINVENTORY U 9 p_locator_id in Number LOCATOR Error SQL Success SQL select xu.action_, xu.status_, 'Successfully Processed' message_, null modified_columns_, 'SUBINVENTORY' default_type, decode(misd.default_type,1,'Shipping',2,'Receiving',3,'Move Order Receipt') default_for, haouv.name organization, msiv.concatenated_segments item, misd.subinventory_code subinventory, null locator from mtl_item_sub_defaults misd, hr_all_organization_units_vl haouv, mtl_system_items_vl msiv, xxen_inv_item_transacti_3968_u xu where haouv.organization_id=misd.organization_id and msiv.organization_id=haouv.organization_id and msiv.inventory_item_id=misd.inventory_item_id and xu.status_code_=xxen_upload.status_success and xu.default_type='SUBINVENTORY' and xu.default_for=decode(misd.default_type,1,'Shipping',2,'Receiving',3,'Move Order Receipt') and xu.item=msiv.concatenated_segments and xu.organization=haouv.name and xu.subinventory=misd.subinventory_code union all select xu.action_, xu.status_, 'Successfully Processed' message_, null modified_columns_, 'LOCATOR' default_type, decode(mild.default_type,1,'Shipping',2,'Receiving',3,'Move Order Receipt') default_for, haouv.name organization, msiv.concatenated_segments item, mild.subinventory_code subinventory, milk.concatenated_segments locator from mtl_item_loc_defaults mild, hr_all_organization_units_vl haouv, mtl_system_items_vl msiv, mtl_item_locations_kfv milk, xxen_inv_item_transacti_3968_u xu where haouv.organization_id=mild.organization_id and msiv.organization_id=haouv.organization_id and msiv.inventory_item_id=mild.inventory_item_id and mild.locator_id=milk.inventory_location_id and mild.organization_id=milk.organization_id and xu.status_code_=xxen_upload.status_success and xu.default_type='LOCATOR' and xu.default_for=decode(mild.default_type,1,'Shipping',2,'Receiving',3,'Move Order Receipt') and xu.item=msiv.concatenated_segments and xu.organization=haouv.name and xu.subinventory=mild.subinventory_code LOV query :$column$.organization ORGANIZATION ITEM LOV query :$column$.default_type DEFAULT_TYPE LOCATOR LOV query :$column$.organization ORGANIZATION LOCATOR LOV query :$column$.subinventory SUBINVENTORY LOCATOR Default value :$flex$.organization Organization|1=1| ORGANIZATION LOV query :$column$.default_type DEFAULT_TYPE SUBINVENTORY LOV query :$column$.item ITEM SUBINVENTORY LOV query :$column$.organization ORGANIZATION SUBINVENTORY Value to id query :$column$.default_type DEFAULT_TYPE p_locator_id Value to id query :$column$.organization ORGANIZATION p_inventory_item_id Value to id query :$column$.organization ORGANIZATION p_locator_id Value to id query :$column$.subinventory SUBINVENTORY p_locator_id