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 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 0EA5F6C7353097C6E0630100007FDA77 Organization Code Y select ood.organization_code value, ood.organization_name description from org_organization_definitions ood where ood.organization_id not in (select mp.organization_id from mtl_parameters mp where 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) 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 ood.organization_id in (select mp.organization_id from mtl_parameters mp where mp.project_reference_enabled = 2 or mp.organization_id = fnd_profile.value('MFG_ORGANIZATION_ID')) and nvl(ood.disable_date,sysdate)>=sysdate order by ood.organization_code US FBCA7BD5D778FF69E0530100007FFBDA select null action_, null status_, null message_, null request_id_, null modified_columns_, rowidtochar(mss.rowid) row_id, mp.organization_code, msiv.concatenated_segments item, msiv.description item_description, ppov.project_number, ppov.project_name, ptv.task_number, ptv.task_name, mss.effectivity_date effective_date, msiv.primary_uom_code uom, mss.safety_stock_quantity quantity, null delete_this_entry, xxen_util.meaning(mss.safety_stock_code,'MTL_SAFETY_STOCK',700) safety_stock_method, mss.forecast_designator forecast, mss.safety_stock_percent, mss.service_level service_level_percent, msiv.planner_code planner, (select sum(moq.transaction_quantity) from mtl_onhand_quantities moq where moq.organization_id = mss.organization_id and moq.inventory_item_id = mss.inventory_item_id having sum(moq.transaction_quantity) != 0 ) onhand from mtl_safety_stocks mss, mtl_parameters mp, mtl_system_items_vl msiv, pjm_projects_org_v ppov, pjm_tasks_v ptv where :p_upload_mode like '%' || xxen_upload.action_update and 1=1 and mss.organization_id = mp.organization_id and mss.organization_id = msiv.organization_id and mss.inventory_item_id = msiv.inventory_item_id and mss.organization_id = ppov.inventory_organization_id (+) and mss.project_id = ppov.project_id (+) and mss.project_id = ptv.project_id (+) and mss.task_id = ptv.task_id (+) Y U A xxen_inv_upload.upload_safety_stock F INV Safety Stock Upload INV Safety Stock Upload ================================ - Télécharger de nouvelles entrées de stock de sécurité. - Mettre à jour les entrées de stock de sécurité existantes. - Supprimer des entrées de stock de sécurité existantes (supprimer en paramétrant 'Supprimer cette entrée' = Oui). Modes de téléchargement ============ Créer ------ Ouvre une feuille de calcul vide dans laquelle l'utilisateur peut saisir de nouvelles quantités de stock de sécurité. Créer ou mettre à jour ----------------- Crée de nouvelles entrées de stock de sécurité et/ou modifie les entrées de stock de sécurité existantes. Permet à l'utilisateur de - télécharger des entrées de stock de sécurité existantes sur la base des critères de sélection spécifiés dans les paramètres du rapport. - modifier (mettre à jour/supprimer) les entrées de stock de sécurité téléchargées - créer de nouvelles entrées de stock de sécurité US INV Safety Stock Upload INV Safety Stock Upload ================================ - Upload New Safety Stock Entries. - Update Existing Safety Stock Entries. - Delete Existing Saffety Stock Entries (Delete by setting the 'Delete This Entry' = Yes). Upload Modes ============ Create ------ Opens an empty spreadsheet where the user can enter new Safety Stock Quantities Create or Update ----------------- Create new Safety Stock entries and/or modify existing Safety Stock entries. Allows the user to - download existing Safety Stock entiries based on the selection criteria specified in the report parameters. - modify (update/delete) the downloaded Safety Stock entries - create new Safety Stock entries Note: The greyed out columns are display only and included to provide additional information. These cannot be altered and are ignored by the upload. Enginatics R12 only Upload 1=1 :p_upload_mode 1 10 :p_upload_mode 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 2 20 1=1 mp.organization_code=:p_organization_code LOV Organization Code 0EA5F6C7353097C6E0630100007FDA77 Y select ood.organization_code value, ood.organization_name description from org_organization_definitions ood where ood.organization_id not in (select mp.organization_id from mtl_parameters mp where 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) 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 ood.organization_id in (select mp.organization_id from mtl_parameters mp where mp.project_reference_enabled = 2 or mp.organization_id = fnd_profile.value('MFG_ORGANIZATION_ID')) and nvl(ood.disable_date,sysdate)>=sysdate order by ood.organization_code select mp.organization_code from mtl_parameters mp where mp.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') Y F Code de l'organisation US Organization Code 3 30 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 4 40 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 5 50 1=1 mss.project_id in ( select ppov.project_id from pjm_projects_org_v ppov where ppov.inventory_organization_id = mss.organization_id and ppov.project_number = :p_project_number ) LOV custom Y Y select ppov.project_number value, mp.organization_code || ' - ' || ppov.project_name description from mtl_parameters mp, pjm_projects_org_v ppov where ppov.inventory_organization_id = mp.organization_id and (:$flex$.organization_code is null or xxen_util.contains(:$flex$.organization_code,mp.organization_code) = 'Y') order by value F Projet US Project 6 60 1=1 mss.task_id in ( select ptv.task_id from pjm_tasks_v ptv where ptv.project_id = mss.project_id and ptv.task_number = :p_task_number ) LOV custom Y Y select ptv.task_number value, ptv.task_name description from mtl_parameters mp, pjm_projects_org_v ppov, pjm_tasks_v ptv where ppov.inventory_organization_id = mp.organization_id and ptv.project_id = ppov.project_id and (:$flex$.organization_code is null or xxen_util.contains(:$flex$.organization_code,mp.organization_code) = 'Y') and xxen_util.contains(:$flex$.project,ppov.project_number) = 'Y' order by value US Task 7 70 1=1 mss.effectivity_date>=:p_effective_date_from Date F Date prévisionnelle du US Effective Date From 8 80 1=1 mss.effectivity_date<:p_effective_date_to+1 Date F Date prévisionnelle jusqu'au US Effective Date To :$flex$.organization_code Organization Code Item :$flex$.organization_code Organization Code Planner :$flex$.organization_code Organization Code Project :$flex$.organization_code Organization Code Task :$flex$.project Project Task 58E9F15E01906EBC05DBDE1C84007B8F 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 restict the Organizations, Forecast Sets, and Forecasts LOVs in the spreadsheet ENGINATICS -11.0012 BUCKET_TYPE -11.0018 COMMENTS -11.0014 CONFIDENCE_PERCENTAGE 15 DELETE_THIS_ENTRY 11 EFFECTIVE_DATE 2 FORECAST -8.0009 FORECAST_DATE -3.0004 FORECAST_DESCRIPTION -8.001 FORECAST_END_DATE -1.0002 FORECAST_SET 5 ITEM 6 ITEM_DESCRIPTION 17 ONHAND 1 ORGANIZATION_CODE 13 PLANNER -11.0015 PROJECT 8 PROJECT_NAME 7 PROJECT_NUMBER 14 QUANTITY 16 SAFETY_STOCK_METHOD 3 SAFETY_STOCK_PERCENT 4 SERVICE_LEVEL_PERCENT -17.0018 SOURCE_CODE -11.0016 TASK 10 TASK_NAME 9 TASK_NUMBER 12 UOM -11.0017 WIP_LINE_CODE -11.0013 WORKDAY_CONTROL S Site Effective Date From Effective Date To Item Planner Project AA6248D5B15D6288D17F63BB79538A56 Create and Update Create new Forecast Entries and/or Modify Existing Forecast Entries Allows the user to - download existing Forecaset Entries for the Forecasts meeting the entered selection criteria - modfy (add/update/delete) the Forecast Entries within the downloaded Forecasts. - create new Forecast Entries in any accessible Forecast This template allows the creation of Forecast Entries against Forecasts not included in the download This template can be used for downloading Forecast Entries from an existing Forecast and copying them to a different Forecast. ENGINATICS -11.0012 BUCKET_TYPE -11.0018 COMMENTS -11.0014 CONFIDENCE_PERCENTAGE 2 FORECAST -8.0009 FORECAST_DATE -3.0004 FORECAST_DESCRIPTION -8.001 FORECAST_END_DATE -1.0002 FORECAST_SET 3 ITEM 4 ITEM_DESCRIPTION 8 ONHAND 1 ORGANIZATION_CODE 6 PLANNER -11.0015 PROJECT 7 QUANTITY -17.0018 SOURCE_CODE -11.0016 TASK 5 UOM -11.0017 WIP_LINE_CODE -11.0013 WORKDAY_CONTROL Upload Mode C,U S Site FD75F10B67491AA005AC1E7912A29F86 Default ENGINATICS 11 DELETE_THIS_ENTRY 8 EFFECTIVE_DATE 13 FORECAST 2 ITEM 3 ITEM_DESCRIPTION 17 ONHAND 1 ORGANIZATION_CODE 16 PLANNER 5 PROJECT_NAME 4 PROJECT_NUMBER 10 QUANTITY 12 SAFETY_STOCK_METHOD 14 SAFETY_STOCK_PERCENT 15 SERVICE_LEVEL_PERCENT 7 TASK_NAME 6 TASK_NUMBER 9 UOM S Site ENGINATICS 58E9F15E01906EBC05DBDE1C84007B8F FD75F10B67491AA005AC1E7912A29F86 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 7 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 xxen_util.contains(:$flex$.organization_code,mp.organization_code) = 'Y' order by value Y Y 8 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.mrp_safety_stock_code = 1 and pjm_unit_eff.unit_effective_item(msiv.inventory_item_id,msiv.organization_id) = 'N' order by value Y Y 9 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 10 PROJECT_NUMBER LOV custom varchar2 Y select ppov.project_number value, mp.organization_code || ' - ' || ppov.project_name description from mtl_parameters mp, pjm_projects_org_v ppov where ppov.inventory_organization_id = mp.organization_id and mp.organization_code = :$column$.organization_code and mp.project_reference_enabled = 1 order by value 11 PROJECT_NAME LOV custom varchar2 Y select ppov.project_name value, mp.organization_code || ' - ' || ppov.project_number description from mtl_parameters mp, pjm_projects_org_v ppov where ppov.inventory_organization_id = mp.organization_id and mp.organization_code = :$column$.organization_code and ppov.project_number = :$column$.project_number and mp.project_reference_enabled = 1 order by value select ppov.project_name from mtl_parameters mp, pjm_projects_org_v ppov where ppov.inventory_organization_id = mp.organization_id and mp.organization_code = :$column$.organization_code and ppov.project_number = :$column$.project_number and mp.project_reference_enabled = 1 12 TASK_NUMBER LOV custom varchar2 Y select ptv.task_number value, ptv.task_name description from mtl_parameters mp, pjm_projects_org_v ppov, pjm_tasks_v ptv where ppov.inventory_organization_id = mp.organization_id and ptv.project_id = ppov.project_id and mp.organization_code = :$column$.organization_code and ppov.project_number = :$column$.project_number and mp.project_reference_enabled = 1 13 TASK_NAME LOV custom varchar2 Y select ptv.task_name value, ptv.task_number description from mtl_parameters mp, pjm_projects_org_v ppov, pjm_tasks_v ptv where ppov.inventory_organization_id = mp.organization_id and ptv.project_id = ppov.project_id and mp.organization_code = :$column$.organization_code and ppov.project_number = :$column$.project_number and ptv.task_number = :$column$.task_number and mp.project_reference_enabled = 1 select ptv.task_name from mtl_parameters mp, pjm_projects_org_v ppov, pjm_tasks_v ptv where ppov.inventory_organization_id = mp.organization_id and ptv.project_id = ppov.project_id and mp.organization_code = :$column$.organization_code and ppov.project_number = :$column$.project_number and ptv.task_number = :$column$.task_number and mp.project_reference_enabled = 1 14 EFFECTIVE_DATE Date date 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 QUANTITY Number number Y 17 DELETE_THIS_ENTRY LOV custom varchar2 Y select xxen_util.meaning('Y','YES_NO',3) value, null description from dual 18 SAFETY_STOCK_METHOD Char varchar2 19 FORECAST Char varchar2 20 SAFETY_STOCK_PERCENT Number number 21 SERVICE_LEVEL_PERCENT Number number 22 PLANNER Char varchar2 23 ONHAND Number number U 1 action_ in Char ACTION_CODE_ U 2 status_ out Char STATUS_CODE_ U 3 message_ out Char MESSAGE_ U 4 request_id_ out Number REQUEST_ID_ U 5 p_row_id in/out Char ROW_ID U 6 p_organization_code in Char ORGANIZATION_CODE U 7 p_item in Char ITEM U 10 p_effectivity_date in Date EFFECTIVE_DATE U 11 p_safety_stock_quantity in Number QUANTITY U 12 p_project_number in Char PROJECT_NUMBER U 13 p_task_number in Char TASK_NUMBER U 14 p_delete_flag in Char DELETE_THIS_ENTRY Order By organization_code, item, effective_date, project_number, task_number Success SQL select xu.action_, xu.status_, case when xu.status_code_ = xxen_upload.status_success and xu.delete_this_entry = xxen_util.meaning('Y','YES_NO',3) and mss.rowid is null then 'This Safety Stock record has been deleted' else xu.message_ end message_, xu.request_id_, xu.modified_columns_, xu.row_id, case when xu.status_code_ = xxen_upload.status_error or xu.delete_this_entry = xxen_util.meaning('Y','YES_NO',3) then xu.organization_code else mp.organization_code end organization_code, case when xu.status_code_ = xxen_upload.status_error or xu.delete_this_entry = xxen_util.meaning('Y','YES_NO',3) then xu.item else msiv.concatenated_segments end item, case when xu.status_code_ = xxen_upload.status_error or xu.delete_this_entry = xxen_util.meaning('Y','YES_NO',3) then xu.item_description else msiv.description end item_description, case when xu.status_code_ = xxen_upload.status_error or xu.delete_this_entry = xxen_util.meaning('Y','YES_NO',3) then xu.project_number else ppov.project_number end project_number, case when xu.status_code_ = xxen_upload.status_error or xu.delete_this_entry = xxen_util.meaning('Y','YES_NO',3) then xu.project_name else ppov.project_name end project_name, case when xu.status_code_ = xxen_upload.status_error or xu.delete_this_entry = xxen_util.meaning('Y','YES_NO',3) then xu.task_number else ptv.task_number end task_number, case when xu.status_code_ = xxen_upload.status_error or xu.delete_this_entry = xxen_util.meaning('Y','YES_NO',3) then xu.task_name else ptv.task_name end task_name, case when xu.status_code_ = xxen_upload.status_error or xu.delete_this_entry = xxen_util.meaning('Y','YES_NO',3) then xu.effective_date else mss.effectivity_date end effective_date, case when xu.status_code_ = xxen_upload.status_error or xu.delete_this_entry = xxen_util.meaning('Y','YES_NO',3) then xu.uom else msiv.primary_uom_code end uom, case when xu.status_code_ = xxen_upload.status_error or xu.delete_this_entry = xxen_util.meaning('Y','YES_NO',3) then to_number(xu.quantity) else mss.safety_stock_quantity end quantity, xu.delete_this_entry, case when xu.status_code_ = xxen_upload.status_error then xu.safety_stock_method when xu.delete_this_entry = xxen_util.meaning('Y','YES_NO',3) then 'Deleted' else xxen_util.meaning(mss.safety_stock_code,'MTL_SAFETY_STOCK',700) end safety_stock_method, case when xu.status_code_ = xxen_upload.status_error then xu.forecast else mss.forecast_designator end forecast, case when xu.status_code_ = xxen_upload.status_error then to_number(xu.safety_stock_percent) else mss.safety_stock_percent end safety_stock_percent, case when xu.status_code_ = xxen_upload.status_error then to_number(xu.service_level_percent) else mss.service_level end service_level_percent, case when xu.status_code_ = xxen_upload.status_error then xu.planner else msiv.planner_code end planner, case when xu.status_code_ = xxen_upload.status_error then xu.onhand else (select sum(moq.transaction_quantity) from mtl_onhand_quantities moq where moq.organization_id = mss.organization_id and moq.inventory_item_id = mss.inventory_item_id having sum(moq.transaction_quantity) != 0 ) end onhand from xxen_inv_safety_stock_u_1857_u xu, mtl_safety_stocks mss, mtl_parameters mp, mtl_system_items_vl msiv, pjm_projects_org_v ppov, pjm_tasks_v ptv where decode(xu.status_code_,xxen_upload.status_error,null,chartorowid(xu.row_id)) = mss.rowid(+) and mss.organization_id = mp.organization_id(+) and mss.organization_id = msiv.organization_id(+) and mss.inventory_item_id = msiv.inventory_item_id(+) and mss.organization_id = ppov.inventory_organization_id(+) and mss.project_id = ppov.project_id(+) and mss.project_id = ptv.project_id(+) and mss.task_id = ptv.task_id(+) LOV query :$column$.organization_code ORGANIZATION_CODE ITEM Default value :$column$.item ITEM ITEM_DESCRIPTION LOV query :$column$.item ITEM ITEM_DESCRIPTION Default value :$column$.organization_code ORGANIZATION_CODE ITEM_DESCRIPTION LOV query :$column$.organization_code ORGANIZATION_CODE ITEM_DESCRIPTION LOV query :$flex$.organization_code Organization Code|1=1| ORGANIZATION_CODE Default value :$column$.organization_code ORGANIZATION_CODE PROJECT_NAME LOV query :$column$.organization_code ORGANIZATION_CODE PROJECT_NAME Default value :$column$.project_number PROJECT_NUMBER PROJECT_NAME LOV query :$column$.project_number PROJECT_NUMBER PROJECT_NAME LOV query :$column$.organization_code ORGANIZATION_CODE PROJECT_NUMBER Default value :$column$.organization_code ORGANIZATION_CODE TASK_NAME LOV query :$column$.organization_code ORGANIZATION_CODE TASK_NAME LOV query :$column$.project_number PROJECT_NUMBER TASK_NAME Default value :$column$.project_number PROJECT_NUMBER TASK_NAME Default value :$column$.task_number TASK_NUMBER TASK_NAME LOV query :$column$.task_number TASK_NUMBER TASK_NAME LOV query :$column$.organization_code ORGANIZATION_CODE TASK_NUMBER LOV query :$column$.project_number PROJECT_NUMBER TASK_NUMBER LOV query :$column$.item ITEM UOM Default value :$column$.item ITEM UOM LOV query :$column$.organization_code ORGANIZATION_CODE UOM Default value :$column$.organization_code ORGANIZATION_CODE UOM