ENGINATICSSYSTEM_ADMINISTRATORSYSADMINE811F942597A2075E0530100007FF4F2Blitz Upload ModeYselect 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
US8E2FF36EDEB279D2E0530100007F1FF2INV Organization CodeYselect
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_codeARجميع أكواد تنظيم المخزون النشط باستثناء المؤسسات الرئيسية ، مقيدة بعرض الوصول إلى مؤسسة المستخدم الحاليDAlle aktiven Inventar-Organisationscodes mit Ausnahme von Master-Organisationen, beschränkt auf die Org-Zugriffsansicht des aktuellen BenutzersETodos 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 actualFTous 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 actuelITutti i codici di organizzazione dell'inventario attivi, escluse le organizzazioni master, limitati alla vista di accesso all'org dell'utente correnteJAすべてのアクティブなインベントリの組織コードは、マスター組織を除いて、現在のユーザーの組織のアクセスビューに制限されます。KO현재 사용자의 조직 액세스보기로 제한되는 마스터 조직을 제외한 모든 활성 재고 조직 코드PTBTodos os códigos ativos de organização de inventário, excluindo organizações mestre, restritos à visão de acesso org do usuário atualRUВсе активные инвентаризационные организационные коды, исключая основные организации, ограниченные текущим представлением доступа пользователя к оргструктуре.SAlla aktiva lagerorganisationskoder exklusive huvudorganisationer, begränsade till den aktuella användarens organisationsåtkomstvyTRAna 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ırUSAll active inventory organization codes excluding master organizations, restricted to the current user's org access viewZHS所有活动的清单组织代码，不包括主组织，仅限于当前用户的组织访问视图。8E2FF36EDEA679D2E0530100007F1FF2YesYselect 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dualUS3863B7B3563406B7E0636DFB0905C38Cselect
null action_,
null status_,
null message_,
null request_id_,
null modified_columns_,
:p_replace_subinventories replace_subinventories,
:p_freeze_physical_inventory freeze_physical_inventory,
to_number(null) upload_row,
to_number(null) physical_inventory_row_id,
-- Physical Inventory
mp.organization_code,
mpiv.physical_inventory_name,
mpiv.description,
mpiv.physical_inventory_date,
decode(mpiv.approval_required,1,'Always',2,'Never',3,'If out of tolerance',mpiv.approval_required) approval_required,
mpiv.approval_tolerance_pos quantity_tolerance_plus,
mpiv.approval_tolerance_neg quantity_tolerance_minus,
mpiv.cost_variance_pos value_tolerance_plus,
mpiv.cost_variance_neg value_tolerance_minus,
&lp_serial_control_cols
xxen_util.meaning(decode(mpiv.dynamic_tag_entry_flag,1,'Y',null),'YES_NO',0) allow_dynamic_tags,
xxen_util.meaning(decode(mpiv.exclude_zero_balance,'Y','Y',null),'YES_NO',0) exclude_zero_balance,
xxen_util.meaning(decode(mpiv.exclude_negative_balance,'Y','Y',null),'YES_NO',0) exclude_negative_balance,
xxen_util.meaning(decode(mpiv.all_subinventories_flag,1,'Y',null),'YES_NO',0) all_subinventories,
-- DFF Attributes
xxen_util.display_flexfield_context(401,'MTL_PHYSICAL_INVENTORIES',mpiv.attribute_category) attribute_category,
xxen_util.display_flexfield_value(401,'MTL_PHYSICAL_INVENTORIES',mpiv.attribute_category,'ATTRIBUTE1',mpiv.row_id,mpiv.attribute1) phys_inv_attribute1,
xxen_util.display_flexfield_value(401,'MTL_PHYSICAL_INVENTORIES',mpiv.attribute_category,'ATTRIBUTE2',mpiv.row_id,mpiv.attribute2) phys_inv_attribute2,
xxen_util.display_flexfield_value(401,'MTL_PHYSICAL_INVENTORIES',mpiv.attribute_category,'ATTRIBUTE3',mpiv.row_id,mpiv.attribute3) phys_inv_attribute3,
xxen_util.display_flexfield_value(401,'MTL_PHYSICAL_INVENTORIES',mpiv.attribute_category,'ATTRIBUTE4',mpiv.row_id,mpiv.attribute4) phys_inv_attribute4,
xxen_util.display_flexfield_value(401,'MTL_PHYSICAL_INVENTORIES',mpiv.attribute_category,'ATTRIBUTE5',mpiv.row_id,mpiv.attribute5) phys_inv_attribute5,
xxen_util.display_flexfield_value(401,'MTL_PHYSICAL_INVENTORIES',mpiv.attribute_category,'ATTRIBUTE6',mpiv.row_id,mpiv.attribute6) phys_inv_attribute6,
xxen_util.display_flexfield_value(401,'MTL_PHYSICAL_INVENTORIES',mpiv.attribute_category,'ATTRIBUTE7',mpiv.row_id,mpiv.attribute7) phys_inv_attribute7,
xxen_util.display_flexfield_value(401,'MTL_PHYSICAL_INVENTORIES',mpiv.attribute_category,'ATTRIBUTE8',mpiv.row_id,mpiv.attribute8) phys_inv_attribute8,
xxen_util.display_flexfield_value(401,'MTL_PHYSICAL_INVENTORIES',mpiv.attribute_category,'ATTRIBUTE9',mpiv.row_id,mpiv.attribute9) phys_inv_attribute9,
xxen_util.display_flexfield_value(401,'MTL_PHYSICAL_INVENTORIES',mpiv.attribute_category,'ATTRIBUTE10',mpiv.row_id,mpiv.attribute10) phys_inv_attribute10,
xxen_util.display_flexfield_value(401,'MTL_PHYSICAL_INVENTORIES',mpiv.attribute_category,'ATTRIBUTE11',mpiv.row_id,mpiv.attribute11) phys_inv_attribute11,
xxen_util.display_flexfield_value(401,'MTL_PHYSICAL_INVENTORIES',mpiv.attribute_category,'ATTRIBUTE12',mpiv.row_id,mpiv.attribute12) phys_inv_attribute12,
xxen_util.display_flexfield_value(401,'MTL_PHYSICAL_INVENTORIES',mpiv.attribute_category,'ATTRIBUTE13',mpiv.row_id,mpiv.attribute13) phys_inv_attribute13,
xxen_util.display_flexfield_value(401,'MTL_PHYSICAL_INVENTORIES',mpiv.attribute_category,'ATTRIBUTE14',mpiv.row_id,mpiv.attribute14) phys_inv_attribute14,
xxen_util.display_flexfield_value(401,'MTL_PHYSICAL_INVENTORIES',mpiv.attribute_category,'ATTRIBUTE15',mpiv.row_id,mpiv.attribute15) phys_inv_attribute15,
-- Subinventories
mps.subinventory,
null delete_subinventory,
--
xxen_util.meaning(decode(mpiv.snapshot_complete,1,'Y',null),'YES_NO',0) snapshot_complete,
mpiv.freeze_date,
-- Ids
mpiv.physical_inventory_id
from
mtl_physical_inventories_v mpiv,
mtl_physical_subinventories mps,
mtl_parameters mp
where
1=1 and
mpiv.physical_inventory_id = mps.physical_inventory_id (+) and
mpiv.organization_id = mps.organization_id (+) and
mpiv.organization_id = mp.organization_id and
mpiv.snapshot_complete = 2 and -- No
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)YUAxxen_inv_upload.upload_physical_inventoryxxen_inv_upload.freeze_physical_inventoryUSINV Physical Inventory UploadThis upload supports the creation of new Physical Inventories and the update of existing Physical Inventories that have not yet been frozen.
The upload supports the specification of the subinventories to be included in the Physical Inventory.
When updating an existing Physical Inventory, the Delete Subinventory upload column allows for individual subinventories to be removed from the Physical Inventory subinventory list.
Replace Existing Subinventories
==========================
When the Replace Existing Subinventories report parameter is set to Yes, the existing physical inventory subinventories will be replaced by those specified in the upload.
When set to No, the upload will update the existing Physical Inventory subinventories, create additional subinventories, or delete specific subinventories as determined from the uploaded data.
Freeze Physical Inventory
=====================
When set to Yes, the Freeze Physical Inventory concurrent program will be submitted after the upload is complete to freeze the uploaded Physical Inventories.
This will only occur for each uploaded Physical Inventory if no upload error has occurred in any upload row for that Physical Inventory.
Once a Physical Inventory has been frozen, it can no longer be updated by this upload.
The Snapshot Complete and Freeze Date columns in the upload excel are display only columns. They will be displayed after the upload when the Freeze Physical Inventory option is selected.
EnginaticsR12 onlyUpload&lp_serial_control_cols1=1:p_freeze_physical_inventory:p_replace_subinventories1-10&lp_serial_control_colsxxen_util.meaning(decode(mpiv.serial_count_option,1,2,2,3,mpiv.serial_count_option),'INV_CC_SC_OPTIONS',700) serial_count_option,
xxen_util.meaning(mpiv.serial_detail_option, 'INV_CC_DETAIL',700) serial_detail_option,CharYselect nvl((select 'Y' from dba_tab_columns where owner = 'INV' and table_name = 'MTL_PHYSICAL_INVENTORIES' and column_name = 'SERIAL_COUNT_OPTION'),'N')
from dualUSSerial Control Columns2&lp_serial_control_colsnull serial_count_option,
null serial_detail_option,NUSSerial Control Columns3101=1:p_upload_mode like '%' || xxen_upload.action_updateLOVBlitz Upload ModeE811F942597A2075E0530100007FF4F2Yselect 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
CYUSUpload Mode420:p_replace_subinventoriesLOV OracleYes_NoYselect
lookup_code id,
meaning value,
null description
from
fnd_lookups
where fnd_lookups.lookup_type='YES_NO'
order by value,descriptionNYUSReplace Existing SubinventoriesSelect Yes if this upload will replace all existing subinventory entries in the Physical Inventory. Select No if this upload is creating new subinventory entries to add to the existing Physical Inventory subinventories.530:p_freeze_physical_inventoryLOV OracleYes_NoYselect
lookup_code id,
meaning value,
null description
from
fnd_lookups
where fnd_lookups.lookup_type='YES_NO'
order by value,descriptionNYUSFreeze Physical InventorySelect Yes to Freeze the Physical Inventory after Upload. No further updates can be made to the Physical Inventory after it has been frozen.6401=1mp.organization_code=:p_organization_codeLOVINV Organization Code8E2FF36EDEB279D2E0530100007F1FF2Yselect
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_codeselect mp.organization_code from mtl_parameters mp where mp.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID')USOrganization Code7501=1mpiv.physical_inventory_name=:p_phys_inv_nameLOV customYselect
mpiv.physical_inventory_name value,
mpiv.description||' ('||oav.organization_code||')' description
from
org_access_view oav,
mtl_physical_inventories_v mpiv
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,oav.organization_code)='Y') and
oav.organization_id=mpiv.organization_id and
mpiv.freeze_date is null
order by
valueUSPhysical Inventory:$flex$.organization_codeOrganization CodePhysical InventoryDefaultDefault TemplateSYSADMIN12ALLOW_DYNAMIC_TAGS15ALL_SUBINVENTORIES5APPROVAL_REQUIRED17DELETE_SUBINVENTORY3DESCRIPTION14EXCLUDE_NEGATIVE_BALANCE13EXCLUDE_ZERO_BALANCE19FREEZE_DATE1ORGANIZATION_CODE4PHYSICAL_INVENTORY_DATE2PHYSICAL_INVENTORY_NAME7QUANTITY_TOLERANCE_MINUS6QUANTITY_TOLERANCE_PLUS10SERIAL_COUNT_OPTIONY11SERIAL_DETAIL_OPTIONY18SNAPSHOT_COMPLETE16SUBINVENTORY9VALUE_TOLERANCE_MINUS8VALUE_TOLERANCE_PLUSSSiteR12.1 Default TemplateR12.1 Default Template.
Does not include the Serial Count and Serial Detail Option columnsSYSADMIN10ALLOW_DYNAMIC_TAGS13ALL_SUBINVENTORIES5APPROVAL_REQUIRED15DELETE_SUBINVENTORY3DESCRIPTION12EXCLUDE_NEGATIVE_BALANCE11EXCLUDE_ZERO_BALANCE17FREEZE_DATE1ORGANIZATION_CODE4PHYSICAL_INVENTORY_DATE2PHYSICAL_INVENTORY_NAME7QUANTITY_TOLERANCE_MINUS6QUANTITY_TOLERANCE_PLUS16SNAPSHOT_COMPLETE14SUBINVENTORY9VALUE_TOLERANCE_MINUS8VALUE_TOLERANCE_PLUSSSiteDefault1ACTION_Charvarchar22STATUS_Charvarchar23MESSAGE_Charvarchar2Y4REQUEST_ID_Charvarchar2Y5MODIFIED_COLUMNS_Charvarchar2Y6REPLACE_SUBINVENTORIESCharvarchar2:$flex$.Replace_Existing_SubinventoriesYYY7FREEZE_PHYSICAL_INVENTORYCharvarchar2:$flex$.Freeze_Physical_InventoryYYY8UPLOAD_ROWNumbernumber9PHYSICAL_INVENTORY_ROW_IDNumbernumberYY10ORGANIZATION_CODELOVvarchar2INV Organization Code8E2FF36EDEB279D2E0530100007F1FF2Yselect
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_codeselect
ood.organization_id id,
ood.organization_code value
from
org_organization_definitions oodYY11PHYSICAL_INVENTORY_NAMELOV customvarchar2select
mpiv.physical_inventory_name value,
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
order by
valueYY12DESCRIPTIONCharvarchar2select
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_name13PHYSICAL_INVENTORY_DATEDatedateselect
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_nameY14APPROVAL_REQUIREDLOV customvarchar2Yselect
x.id,
x.value,
null description
from
(select 1 id, 'Always' value from dual union
select 2 id, 'Never' value from dual union
select 3 id, 'If out of tolerance' value from dual
) x
order by
x.value
select
decode(mpiv.approval_required,1,'Always',2,'Never',3,'If out of tolerance',mpiv.approval_required)
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_nameY15QUANTITY_TOLERANCE_PLUSNumbernumberselect
mpiv.approval_tolerance_pos
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_name16QUANTITY_TOLERANCE_MINUSNumbernumberselect
mpiv.approval_tolerance_neg
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_name17VALUE_TOLERANCE_PLUSNumbernumberselect
mpiv.cost_variance_pos
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_name18VALUE_TOLERANCE_MINUSNumbernumberselect
mpiv.cost_variance_neg
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_name19SERIAL_COUNT_OPTIONLOV customvarchar2Yselect
decode(lookup_code,2,1,3,2) id,
meaning value,
null description
from
mfg_lookups
where
lookup_type = 'INV_CC_SC_OPTIONS' and
lookup_code in (2,3) and
'Y' = (select 'Y' from dba_tab_columns where owner = 'INV' and table_name = 'MTL_PHYSICAL_INVENTORIES' and column_name = 'SERIAL_COUNT_OPTION')
order by
value
xxen_inv_upload.get_phys_inv_sc_option(:$column$.organization_code, :$column$.physical_inventory_name)select 'Serial Count Option is required in this release ' || fnd_release.major_version||'.'||fnd_release.minor_version||'.'||fnd_release.point_version
from
dual
where
'Y' = (select 'Y' from dba_tab_columns where owner = 'INV' and table_name = 'MTL_PHYSICAL_INVENTORIES' and column_name = 'SERIAL_COUNT_OPTION')
union
select 'Serial Count Option is not available in this release ' || fnd_release.major_version||'.'||fnd_release.minor_version||'.'||fnd_release.point_version
from
dual
where
not exists (select 'Y' from dba_tab_columns where owner = 'INV' and table_name = 'MTL_PHYSICAL_INVENTORIES' and column_name = 'SERIAL_COUNT_OPTION')20SERIAL_DETAIL_OPTIONLOV customvarchar2Yselect
lookup_code id,
meaning value,
null description
from
mfg_lookups
where
lookup_type = 'INV_CC_DETAIL' and
'Y' = (select 'Y' from dba_tab_columns where owner = 'INV' and table_name = 'MTL_PHYSICAL_INVENTORIES' and column_name = 'SERIAL_COUNT_OPTION')
order by
valuexxen_inv_upload.get_phys_inv_sc_detail(:$column$.organization_code, :$column$.physical_inventory_name)select 'Serial Detail Option is required in this release ' || fnd_release.major_version||'.'||fnd_release.minor_version||'.'||fnd_release.point_version
from
dual
where
'Y' = (select 'Y' from dba_tab_columns where owner = 'INV' and table_name = 'MTL_PHYSICAL_INVENTORIES' and column_name = 'SERIAL_COUNT_OPTION')
union
select 'Serial Detail Option is not available in this release ' || fnd_release.major_version||'.'||fnd_release.minor_version||'.'||fnd_release.point_version
from
dual
where
not exists (select 'Y' from dba_tab_columns where owner = 'INV' and table_name = 'MTL_PHYSICAL_INVENTORIES' and column_name = 'SERIAL_COUNT_OPTION')21ALLOW_DYNAMIC_TAGSLOV customvarchar2Yselect 1 id, xxen_util.meaning('Y','YES_NO',0) value, null description from dualselect
xxen_util.meaning(decode(mpiv.dynamic_tag_entry_flag,1,1,null),'INV_YES_NO',3)
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_name22EXCLUDE_ZERO_BALANCELOVvarchar2Yes8E2FF36EDEA679D2E0530100007F1FF2Yselect 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dualselect
xxen_util.meaning(decode(mpiv.exclude_zero_balance,'Y','Y',null),'INV_YES_NO',3)
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_name23EXCLUDE_NEGATIVE_BALANCELOVvarchar2Yes8E2FF36EDEA679D2E0530100007F1FF2Yselect 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dualselect
xxen_util.meaning(decode(mpiv.exclude_negative_balance,'Y','Y',null),'INV_YES_NO',3)
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_name24ALL_SUBINVENTORIESLOV customvarchar2Yselect 1 id, xxen_util.meaning('Y','YES_NO',0) value, null description from dualselect
xxen_util.meaning(decode(mpiv.all_subinventories_flag,1,1,null),'INV_YES_NO',3)
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_name25ATTRIBUTE_CATEGORYLOV customvarchar2Yselect distinct
fdfcv.descriptive_flex_context_name value,
fdfcv.description
from
fnd_descriptive_flexs_vl fdfv,
fnd_descr_flex_contexts_vl fdfcv
where
fdfv.descriptive_flexfield_name='MTL_PHYSICAL_INVENTORIES' and
fdfv.application_id=401 and
fdfv.application_id=fdfcv.application_id and
fdfv.descriptive_flexfield_name=fdfcv.descriptive_flexfield_name and
fdfcv.enabled_flag='Y' and
fdfcv.descriptive_flex_context_code<>'Global Data Elements'
order by
fdfcv.descriptive_flex_context_nameselect
xxen_util.display_flexfield_context(401,'MTL_PHYSICAL_INVENTORIES',mpiv.attribute_category)
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_name26PHYS_INV_ATTRIBUTE1LOV customvarchar2Yselect
substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value,
substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description
from
table(
xxen_util.dff_attribute_lov
(p_application_id => 401,
p_descriptive_flexfield_name => 'MTL_PHYSICAL_INVENTORIES',
p_context_name => :$column$.attribute_category,
p_column_name => 'ATTRIBUTE1',
p_attribute1 => :$column$.phys_inv_attribute1,
p_attribute2 => :$column$.phys_inv_attribute2,
p_attribute3 => :$column$.phys_inv_attribute3,
p_attribute4 => :$column$.phys_inv_attribute4,
p_attribute5 => :$column$.phys_inv_attribute5,
p_attribute6 => :$column$.phys_inv_attribute6,
p_attribute7 => :$column$.phys_inv_attribute7,
p_attribute8 => :$column$.phys_inv_attribute8,
p_attribute9 => :$column$.phys_inv_attribute9,
p_attribute10 => :$column$.phys_inv_attribute10,
p_attribute11 => :$column$.phys_inv_attribute11,
p_attribute12 => :$column$.phys_inv_attribute12,
p_attribute13 => :$column$.phys_inv_attribute13,
p_attribute14 => :$column$.phys_inv_attribute14,
p_attribute15 => :$column$.phys_inv_attribute15
)
) lov
order by
valueselect
xxen_util.display_flexfield_value(401,'MTL_PHYSICAL_INVENTORIES',mpiv.attribute_category,'ATTRIBUTE1',mpiv.row_id,mpiv.attribute1)
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_nameSELECT distinct
'(Context) ' || initcap(dffcu.application_column_name) || ': ' ||
listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name)
FROM
fnd_descriptive_flexs_vl dff,
fnd_descr_flex_contexts dffcx,
fnd_descr_flex_col_usage_vl dffcu
WHERE
dffcx.application_id = dff.application_id and
dffcx.descriptive_flexfield_name = dff.descriptive_flexfield_name and
dffcx.enabled_flag = 'Y' and
dffcu.application_id = dffcx.application_id and
dffcu.descriptive_flexfield_name = dffcx.descriptive_flexfield_name and
dffcu.descriptive_flex_context_code = dffcx.descriptive_flex_context_code and
dffcu.enabled_flag = 'Y' and
dff.application_id = 401 and
dff.application_table_name = 'MTL_PHYSICAL_INVENTORIES' and
dffcu.application_column_name = 'ATTRIBUTE1'27PHYS_INV_ATTRIBUTE2LOV customvarchar2Yselect
substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value,
substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description
from
table(
xxen_util.dff_attribute_lov
(p_application_id => 401,
p_descriptive_flexfield_name => 'MTL_PHYSICAL_INVENTORIES',
p_context_name => :$column$.attribute_category,
p_column_name => 'ATTRIBUTE2',
p_attribute1 => :$column$.phys_inv_attribute1,
p_attribute2 => :$column$.phys_inv_attribute2,
p_attribute3 => :$column$.phys_inv_attribute3,
p_attribute4 => :$column$.phys_inv_attribute4,
p_attribute5 => :$column$.phys_inv_attribute5,
p_attribute6 => :$column$.phys_inv_attribute6,
p_attribute7 => :$column$.phys_inv_attribute7,
p_attribute8 => :$column$.phys_inv_attribute8,
p_attribute9 => :$column$.phys_inv_attribute9,
p_attribute10 => :$column$.phys_inv_attribute10,
p_attribute11 => :$column$.phys_inv_attribute11,
p_attribute12 => :$column$.phys_inv_attribute12,
p_attribute13 => :$column$.phys_inv_attribute13,
p_attribute14 => :$column$.phys_inv_attribute14,
p_attribute15 => :$column$.phys_inv_attribute15
)
) lov
order by
valueselect
xxen_util.display_flexfield_value(401,'MTL_PHYSICAL_INVENTORIES',mpiv.attribute_category,'ATTRIBUTE2',mpiv.row_id,mpiv.attribute2)
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_nameSELECT distinct
'(Context) ' || initcap(dffcu.application_column_name) || ': ' ||
listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name)
FROM
fnd_descriptive_flexs_vl dff,
fnd_descr_flex_contexts dffcx,
fnd_descr_flex_col_usage_vl dffcu
WHERE
dffcx.application_id = dff.application_id and
dffcx.descriptive_flexfield_name = dff.descriptive_flexfield_name and
dffcx.enabled_flag = 'Y' and
dffcu.application_id = dffcx.application_id and
dffcu.descriptive_flexfield_name = dffcx.descriptive_flexfield_name and
dffcu.descriptive_flex_context_code = dffcx.descriptive_flex_context_code and
dffcu.enabled_flag = 'Y' and
dff.application_id = 401 and
dff.application_table_name = 'MTL_PHYSICAL_INVENTORIES' and
dffcu.application_column_name = 'ATTRIBUTE2'28PHYS_INV_ATTRIBUTE3LOV customvarchar2Yselect
substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value,
substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description
from
table(
xxen_util.dff_attribute_lov
(p_application_id => 401,
p_descriptive_flexfield_name => 'MTL_PHYSICAL_INVENTORIES',
p_context_name => :$column$.attribute_category,
p_column_name => 'ATTRIBUTE3',
p_attribute1 => :$column$.phys_inv_attribute1,
p_attribute2 => :$column$.phys_inv_attribute2,
p_attribute3 => :$column$.phys_inv_attribute3,
p_attribute4 => :$column$.phys_inv_attribute4,
p_attribute5 => :$column$.phys_inv_attribute5,
p_attribute6 => :$column$.phys_inv_attribute6,
p_attribute7 => :$column$.phys_inv_attribute7,
p_attribute8 => :$column$.phys_inv_attribute8,
p_attribute9 => :$column$.phys_inv_attribute9,
p_attribute10 => :$column$.phys_inv_attribute10,
p_attribute11 => :$column$.phys_inv_attribute11,
p_attribute12 => :$column$.phys_inv_attribute12,
p_attribute13 => :$column$.phys_inv_attribute13,
p_attribute14 => :$column$.phys_inv_attribute14,
p_attribute15 => :$column$.phys_inv_attribute15
)
) lov
order by
valueselect
xxen_util.display_flexfield_value(401,'MTL_PHYSICAL_INVENTORIES',mpiv.attribute_category,'ATTRIBUTE3',mpiv.row_id,mpiv.attribute3)
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_nameSELECT distinct
'(Context) ' || initcap(dffcu.application_column_name) || ': ' ||
listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name)
FROM
fnd_descriptive_flexs_vl dff,
fnd_descr_flex_contexts dffcx,
fnd_descr_flex_col_usage_vl dffcu
WHERE
dffcx.application_id = dff.application_id and
dffcx.descriptive_flexfield_name = dff.descriptive_flexfield_name and
dffcx.enabled_flag = 'Y' and
dffcu.application_id = dffcx.application_id and
dffcu.descriptive_flexfield_name = dffcx.descriptive_flexfield_name and
dffcu.descriptive_flex_context_code = dffcx.descriptive_flex_context_code and
dffcu.enabled_flag = 'Y' and
dff.application_id = 401 and
dff.application_table_name = 'MTL_PHYSICAL_INVENTORIES' and
dffcu.application_column_name = 'ATTRIBUTE3'29PHYS_INV_ATTRIBUTE4LOV customvarchar2Yselect
substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value,
substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description
from
table(
xxen_util.dff_attribute_lov
(p_application_id => 401,
p_descriptive_flexfield_name => 'MTL_PHYSICAL_INVENTORIES',
p_context_name => :$column$.attribute_category,
p_column_name => 'ATTRIBUTE4',
p_attribute1 => :$column$.phys_inv_attribute1,
p_attribute2 => :$column$.phys_inv_attribute2,
p_attribute3 => :$column$.phys_inv_attribute3,
p_attribute4 => :$column$.phys_inv_attribute4,
p_attribute5 => :$column$.phys_inv_attribute5,
p_attribute6 => :$column$.phys_inv_attribute6,
p_attribute7 => :$column$.phys_inv_attribute7,
p_attribute8 => :$column$.phys_inv_attribute8,
p_attribute9 => :$column$.phys_inv_attribute9,
p_attribute10 => :$column$.phys_inv_attribute10,
p_attribute11 => :$column$.phys_inv_attribute11,
p_attribute12 => :$column$.phys_inv_attribute12,
p_attribute13 => :$column$.phys_inv_attribute13,
p_attribute14 => :$column$.phys_inv_attribute14,
p_attribute15 => :$column$.phys_inv_attribute15
)
) lov
order by
valueselect
xxen_util.display_flexfield_value(401,'MTL_PHYSICAL_INVENTORIES',mpiv.attribute_category,'ATTRIBUTE4',mpiv.row_id,mpiv.attribute4)
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_nameSELECT distinct
'(Context) ' || initcap(dffcu.application_column_name) || ': ' ||
listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name)
FROM
fnd_descriptive_flexs_vl dff,
fnd_descr_flex_contexts dffcx,
fnd_descr_flex_col_usage_vl dffcu
WHERE
dffcx.application_id = dff.application_id and
dffcx.descriptive_flexfield_name = dff.descriptive_flexfield_name and
dffcx.enabled_flag = 'Y' and
dffcu.application_id = dffcx.application_id and
dffcu.descriptive_flexfield_name = dffcx.descriptive_flexfield_name and
dffcu.descriptive_flex_context_code = dffcx.descriptive_flex_context_code and
dffcu.enabled_flag = 'Y' and
dff.application_id = 401 and
dff.application_table_name = 'MTL_PHYSICAL_INVENTORIES' and
dffcu.application_column_name = 'ATTRIBUTE4'30PHYS_INV_ATTRIBUTE5LOV customvarchar2Yselect
substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value,
substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description
from
table(
xxen_util.dff_attribute_lov
(p_application_id => 401,
p_descriptive_flexfield_name => 'MTL_PHYSICAL_INVENTORIES',
p_context_name => :$column$.attribute_category,
p_column_name => 'ATTRIBUTE5',
p_attribute1 => :$column$.phys_inv_attribute1,
p_attribute2 => :$column$.phys_inv_attribute2,
p_attribute3 => :$column$.phys_inv_attribute3,
p_attribute4 => :$column$.phys_inv_attribute4,
p_attribute5 => :$column$.phys_inv_attribute5,
p_attribute6 => :$column$.phys_inv_attribute6,
p_attribute7 => :$column$.phys_inv_attribute7,
p_attribute8 => :$column$.phys_inv_attribute8,
p_attribute9 => :$column$.phys_inv_attribute9,
p_attribute10 => :$column$.phys_inv_attribute10,
p_attribute11 => :$column$.phys_inv_attribute11,
p_attribute12 => :$column$.phys_inv_attribute12,
p_attribute13 => :$column$.phys_inv_attribute13,
p_attribute14 => :$column$.phys_inv_attribute14,
p_attribute15 => :$column$.phys_inv_attribute15
)
) lov
order by
valueselect
xxen_util.display_flexfield_value(401,'MTL_PHYSICAL_INVENTORIES',mpiv.attribute_category,'ATTRIBUTE5',mpiv.row_id,mpiv.attribute5)
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_nameSELECT distinct
'(Context) ' || initcap(dffcu.application_column_name) || ': ' ||
listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name)
FROM
fnd_descriptive_flexs_vl dff,
fnd_descr_flex_contexts dffcx,
fnd_descr_flex_col_usage_vl dffcu
WHERE
dffcx.application_id = dff.application_id and
dffcx.descriptive_flexfield_name = dff.descriptive_flexfield_name and
dffcx.enabled_flag = 'Y' and
dffcu.application_id = dffcx.application_id and
dffcu.descriptive_flexfield_name = dffcx.descriptive_flexfield_name and
dffcu.descriptive_flex_context_code = dffcx.descriptive_flex_context_code and
dffcu.enabled_flag = 'Y' and
dff.application_id = 401 and
dff.application_table_name = 'MTL_PHYSICAL_INVENTORIES' and
dffcu.application_column_name = 'ATTRIBUTE5'31PHYS_INV_ATTRIBUTE6LOV customvarchar2Yselect
substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value,
substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description
from
table(
xxen_util.dff_attribute_lov
(p_application_id => 401,
p_descriptive_flexfield_name => 'MTL_PHYSICAL_INVENTORIES',
p_context_name => :$column$.attribute_category,
p_column_name => 'ATTRIBUTE6',
p_attribute1 => :$column$.phys_inv_attribute1,
p_attribute2 => :$column$.phys_inv_attribute2,
p_attribute3 => :$column$.phys_inv_attribute3,
p_attribute4 => :$column$.phys_inv_attribute4,
p_attribute5 => :$column$.phys_inv_attribute5,
p_attribute6 => :$column$.phys_inv_attribute6,
p_attribute7 => :$column$.phys_inv_attribute7,
p_attribute8 => :$column$.phys_inv_attribute8,
p_attribute9 => :$column$.phys_inv_attribute9,
p_attribute10 => :$column$.phys_inv_attribute10,
p_attribute11 => :$column$.phys_inv_attribute11,
p_attribute12 => :$column$.phys_inv_attribute12,
p_attribute13 => :$column$.phys_inv_attribute13,
p_attribute14 => :$column$.phys_inv_attribute14,
p_attribute15 => :$column$.phys_inv_attribute15
)
) lov
order by
valueselect
xxen_util.display_flexfield_value(401,'MTL_PHYSICAL_INVENTORIES',mpiv.attribute_category,'ATTRIBUTE6',mpiv.row_id,mpiv.attribute6)
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_nameSELECT distinct
'(Context) ' || initcap(dffcu.application_column_name) || ': ' ||
listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name)
FROM
fnd_descriptive_flexs_vl dff,
fnd_descr_flex_contexts dffcx,
fnd_descr_flex_col_usage_vl dffcu
WHERE
dffcx.application_id = dff.application_id and
dffcx.descriptive_flexfield_name = dff.descriptive_flexfield_name and
dffcx.enabled_flag = 'Y' and
dffcu.application_id = dffcx.application_id and
dffcu.descriptive_flexfield_name = dffcx.descriptive_flexfield_name and
dffcu.descriptive_flex_context_code = dffcx.descriptive_flex_context_code and
dffcu.enabled_flag = 'Y' and
dff.application_id = 401 and
dff.application_table_name = 'MTL_PHYSICAL_INVENTORIES' and
dffcu.application_column_name = 'ATTRIBUTE6'32PHYS_INV_ATTRIBUTE7LOV customvarchar2Yselect
substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value,
substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description
from
table(
xxen_util.dff_attribute_lov
(p_application_id => 401,
p_descriptive_flexfield_name => 'MTL_PHYSICAL_INVENTORIES',
p_context_name => :$column$.attribute_category,
p_column_name => 'ATTRIBUTE7',
p_attribute1 => :$column$.phys_inv_attribute1,
p_attribute2 => :$column$.phys_inv_attribute2,
p_attribute3 => :$column$.phys_inv_attribute3,
p_attribute4 => :$column$.phys_inv_attribute4,
p_attribute5 => :$column$.phys_inv_attribute5,
p_attribute6 => :$column$.phys_inv_attribute6,
p_attribute7 => :$column$.phys_inv_attribute7,
p_attribute8 => :$column$.phys_inv_attribute8,
p_attribute9 => :$column$.phys_inv_attribute9,
p_attribute10 => :$column$.phys_inv_attribute10,
p_attribute11 => :$column$.phys_inv_attribute11,
p_attribute12 => :$column$.phys_inv_attribute12,
p_attribute13 => :$column$.phys_inv_attribute13,
p_attribute14 => :$column$.phys_inv_attribute14,
p_attribute15 => :$column$.phys_inv_attribute15
)
) lov
order by
valueselect
xxen_util.display_flexfield_value(401,'MTL_PHYSICAL_INVENTORIES',mpiv.attribute_category,'ATTRIBUTE7',mpiv.row_id,mpiv.attribute7)
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_nameSELECT distinct
'(Context) ' || initcap(dffcu.application_column_name) || ': ' ||
listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name)
FROM
fnd_descriptive_flexs_vl dff,
fnd_descr_flex_contexts dffcx,
fnd_descr_flex_col_usage_vl dffcu
WHERE
dffcx.application_id = dff.application_id and
dffcx.descriptive_flexfield_name = dff.descriptive_flexfield_name and
dffcx.enabled_flag = 'Y' and
dffcu.application_id = dffcx.application_id and
dffcu.descriptive_flexfield_name = dffcx.descriptive_flexfield_name and
dffcu.descriptive_flex_context_code = dffcx.descriptive_flex_context_code and
dffcu.enabled_flag = 'Y' and
dff.application_id = 401 and
dff.application_table_name = 'MTL_PHYSICAL_INVENTORIES' and
dffcu.application_column_name = 'ATTRIBUTE7'33PHYS_INV_ATTRIBUTE8LOV customvarchar2Yselect
substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value,
substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description
from
table(
xxen_util.dff_attribute_lov
(p_application_id => 401,
p_descriptive_flexfield_name => 'MTL_PHYSICAL_INVENTORIES',
p_context_name => :$column$.attribute_category,
p_column_name => 'ATTRIBUTE8',
p_attribute1 => :$column$.phys_inv_attribute1,
p_attribute2 => :$column$.phys_inv_attribute2,
p_attribute3 => :$column$.phys_inv_attribute3,
p_attribute4 => :$column$.phys_inv_attribute4,
p_attribute5 => :$column$.phys_inv_attribute5,
p_attribute6 => :$column$.phys_inv_attribute6,
p_attribute7 => :$column$.phys_inv_attribute7,
p_attribute8 => :$column$.phys_inv_attribute8,
p_attribute9 => :$column$.phys_inv_attribute9,
p_attribute10 => :$column$.phys_inv_attribute10,
p_attribute11 => :$column$.phys_inv_attribute11,
p_attribute12 => :$column$.phys_inv_attribute12,
p_attribute13 => :$column$.phys_inv_attribute13,
p_attribute14 => :$column$.phys_inv_attribute14,
p_attribute15 => :$column$.phys_inv_attribute15
)
) lov
order by
valueselect
xxen_util.display_flexfield_value(401,'MTL_PHYSICAL_INVENTORIES',mpiv.attribute_category,'ATTRIBUTE8',mpiv.row_id,mpiv.attribute8)
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_nameSELECT distinct
'(Context) ' || initcap(dffcu.application_column_name) || ': ' ||
listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name)
FROM
fnd_descriptive_flexs_vl dff,
fnd_descr_flex_contexts dffcx,
fnd_descr_flex_col_usage_vl dffcu
WHERE
dffcx.application_id = dff.application_id and
dffcx.descriptive_flexfield_name = dff.descriptive_flexfield_name and
dffcx.enabled_flag = 'Y' and
dffcu.application_id = dffcx.application_id and
dffcu.descriptive_flexfield_name = dffcx.descriptive_flexfield_name and
dffcu.descriptive_flex_context_code = dffcx.descriptive_flex_context_code and
dffcu.enabled_flag = 'Y' and
dff.application_id = 401 and
dff.application_table_name = 'MTL_PHYSICAL_INVENTORIES' and
dffcu.application_column_name = 'ATTRIBUTE8'34PHYS_INV_ATTRIBUTE9LOV customvarchar2Yselect
substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value,
substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description
from
table(
xxen_util.dff_attribute_lov
(p_application_id => 401,
p_descriptive_flexfield_name => 'MTL_PHYSICAL_INVENTORIES',
p_context_name => :$column$.attribute_category,
p_column_name => 'ATTRIBUTE9',
p_attribute1 => :$column$.phys_inv_attribute1,
p_attribute2 => :$column$.phys_inv_attribute2,
p_attribute3 => :$column$.phys_inv_attribute3,
p_attribute4 => :$column$.phys_inv_attribute4,
p_attribute5 => :$column$.phys_inv_attribute5,
p_attribute6 => :$column$.phys_inv_attribute6,
p_attribute7 => :$column$.phys_inv_attribute7,
p_attribute8 => :$column$.phys_inv_attribute8,
p_attribute9 => :$column$.phys_inv_attribute9,
p_attribute10 => :$column$.phys_inv_attribute10,
p_attribute11 => :$column$.phys_inv_attribute11,
p_attribute12 => :$column$.phys_inv_attribute12,
p_attribute13 => :$column$.phys_inv_attribute13,
p_attribute14 => :$column$.phys_inv_attribute14,
p_attribute15 => :$column$.phys_inv_attribute15
)
) lov
order by
valueselect
xxen_util.display_flexfield_value(401,'MTL_PHYSICAL_INVENTORIES',mpiv.attribute_category,'ATTRIBUTE9',mpiv.row_id,mpiv.attribute9)
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_nameSELECT distinct
'(Context) ' || initcap(dffcu.application_column_name) || ': ' ||
listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name)
FROM
fnd_descriptive_flexs_vl dff,
fnd_descr_flex_contexts dffcx,
fnd_descr_flex_col_usage_vl dffcu
WHERE
dffcx.application_id = dff.application_id and
dffcx.descriptive_flexfield_name = dff.descriptive_flexfield_name and
dffcx.enabled_flag = 'Y' and
dffcu.application_id = dffcx.application_id and
dffcu.descriptive_flexfield_name = dffcx.descriptive_flexfield_name and
dffcu.descriptive_flex_context_code = dffcx.descriptive_flex_context_code and
dffcu.enabled_flag = 'Y' and
dff.application_id = 401 and
dff.application_table_name = 'MTL_PHYSICAL_INVENTORIES' and
dffcu.application_column_name = 'ATTRIBUTE9'35PHYS_INV_ATTRIBUTE10LOV customvarchar2Yselect
substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value,
substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description
from
table(
xxen_util.dff_attribute_lov
(p_application_id => 401,
p_descriptive_flexfield_name => 'MTL_PHYSICAL_INVENTORIES',
p_context_name => :$column$.attribute_category,
p_column_name => 'ATTRIBUTE10',
p_attribute1 => :$column$.phys_inv_attribute1,
p_attribute2 => :$column$.phys_inv_attribute2,
p_attribute3 => :$column$.phys_inv_attribute3,
p_attribute4 => :$column$.phys_inv_attribute4,
p_attribute5 => :$column$.phys_inv_attribute5,
p_attribute6 => :$column$.phys_inv_attribute6,
p_attribute7 => :$column$.phys_inv_attribute7,
p_attribute8 => :$column$.phys_inv_attribute8,
p_attribute9 => :$column$.phys_inv_attribute9,
p_attribute10 => :$column$.phys_inv_attribute10,
p_attribute11 => :$column$.phys_inv_attribute11,
p_attribute12 => :$column$.phys_inv_attribute12,
p_attribute13 => :$column$.phys_inv_attribute13,
p_attribute14 => :$column$.phys_inv_attribute14,
p_attribute15 => :$column$.phys_inv_attribute15
)
) lov
order by
valueselect
xxen_util.display_flexfield_value(401,'MTL_PHYSICAL_INVENTORIES',mpiv.attribute_category,'ATTRIBUTE10',mpiv.row_id,mpiv.attribute10)
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_nameSELECT distinct
'(Context) ' || initcap(dffcu.application_column_name) || ': ' ||
listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name)
FROM
fnd_descriptive_flexs_vl dff,
fnd_descr_flex_contexts dffcx,
fnd_descr_flex_col_usage_vl dffcu
WHERE
dffcx.application_id = dff.application_id and
dffcx.descriptive_flexfield_name = dff.descriptive_flexfield_name and
dffcx.enabled_flag = 'Y' and
dffcu.application_id = dffcx.application_id and
dffcu.descriptive_flexfield_name = dffcx.descriptive_flexfield_name and
dffcu.descriptive_flex_context_code = dffcx.descriptive_flex_context_code and
dffcu.enabled_flag = 'Y' and
dff.application_id = 401 and
dff.application_table_name = 'MTL_PHYSICAL_INVENTORIES' and
dffcu.application_column_name = 'ATTRIBUTE10'36PHYS_INV_ATTRIBUTE11LOV customvarchar2Yselect
substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value,
substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description
from
table(
xxen_util.dff_attribute_lov
(p_application_id => 401,
p_descriptive_flexfield_name => 'MTL_PHYSICAL_INVENTORIES',
p_context_name => :$column$.attribute_category,
p_column_name => 'ATTRIBUTE11',
p_attribute1 => :$column$.phys_inv_attribute1,
p_attribute2 => :$column$.phys_inv_attribute2,
p_attribute3 => :$column$.phys_inv_attribute3,
p_attribute4 => :$column$.phys_inv_attribute4,
p_attribute5 => :$column$.phys_inv_attribute5,
p_attribute6 => :$column$.phys_inv_attribute6,
p_attribute7 => :$column$.phys_inv_attribute7,
p_attribute8 => :$column$.phys_inv_attribute8,
p_attribute9 => :$column$.phys_inv_attribute9,
p_attribute10 => :$column$.phys_inv_attribute10,
p_attribute11 => :$column$.phys_inv_attribute11,
p_attribute12 => :$column$.phys_inv_attribute12,
p_attribute13 => :$column$.phys_inv_attribute13,
p_attribute14 => :$column$.phys_inv_attribute14,
p_attribute15 => :$column$.phys_inv_attribute15
)
) lov
order by
valueselect
xxen_util.display_flexfield_value(401,'MTL_PHYSICAL_INVENTORIES',mpiv.attribute_category,'ATTRIBUTE11',mpiv.row_id,mpiv.attribute11)
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_nameSELECT distinct
'(Context) ' || initcap(dffcu.application_column_name) || ': ' ||
listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name)
FROM
fnd_descriptive_flexs_vl dff,
fnd_descr_flex_contexts dffcx,
fnd_descr_flex_col_usage_vl dffcu
WHERE
dffcx.application_id = dff.application_id and
dffcx.descriptive_flexfield_name = dff.descriptive_flexfield_name and
dffcx.enabled_flag = 'Y' and
dffcu.application_id = dffcx.application_id and
dffcu.descriptive_flexfield_name = dffcx.descriptive_flexfield_name and
dffcu.descriptive_flex_context_code = dffcx.descriptive_flex_context_code and
dffcu.enabled_flag = 'Y' and
dff.application_id = 401 and
dff.application_table_name = 'MTL_PHYSICAL_INVENTORIES' and
dffcu.application_column_name = 'ATTRIBUTE11'37PHYS_INV_ATTRIBUTE12LOV customvarchar2Yselect
substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value,
substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description
from
table(
xxen_util.dff_attribute_lov
(p_application_id => 401,
p_descriptive_flexfield_name => 'MTL_PHYSICAL_INVENTORIES',
p_context_name => :$column$.attribute_category,
p_column_name => 'ATTRIBUTE12',
p_attribute1 => :$column$.phys_inv_attribute1,
p_attribute2 => :$column$.phys_inv_attribute2,
p_attribute3 => :$column$.phys_inv_attribute3,
p_attribute4 => :$column$.phys_inv_attribute4,
p_attribute5 => :$column$.phys_inv_attribute5,
p_attribute6 => :$column$.phys_inv_attribute6,
p_attribute7 => :$column$.phys_inv_attribute7,
p_attribute8 => :$column$.phys_inv_attribute8,
p_attribute9 => :$column$.phys_inv_attribute9,
p_attribute10 => :$column$.phys_inv_attribute10,
p_attribute11 => :$column$.phys_inv_attribute11,
p_attribute12 => :$column$.phys_inv_attribute12,
p_attribute13 => :$column$.phys_inv_attribute13,
p_attribute14 => :$column$.phys_inv_attribute14,
p_attribute15 => :$column$.phys_inv_attribute15
)
) lov
order by
valueselect
xxen_util.display_flexfield_value(401,'MTL_PHYSICAL_INVENTORIES',mpiv.attribute_category,'ATTRIBUTE12',mpiv.row_id,mpiv.attribute12)
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_nameSELECT distinct
'(Context) ' || initcap(dffcu.application_column_name) || ': ' ||
listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name)
FROM
fnd_descriptive_flexs_vl dff,
fnd_descr_flex_contexts dffcx,
fnd_descr_flex_col_usage_vl dffcu
WHERE
dffcx.application_id = dff.application_id and
dffcx.descriptive_flexfield_name = dff.descriptive_flexfield_name and
dffcx.enabled_flag = 'Y' and
dffcu.application_id = dffcx.application_id and
dffcu.descriptive_flexfield_name = dffcx.descriptive_flexfield_name and
dffcu.descriptive_flex_context_code = dffcx.descriptive_flex_context_code and
dffcu.enabled_flag = 'Y' and
dff.application_id = 401 and
dff.application_table_name = 'MTL_PHYSICAL_INVENTORIES' and
dffcu.application_column_name = 'ATTRIBUTE12'38PHYS_INV_ATTRIBUTE13LOV customvarchar2Yselect
substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value,
substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description
from
table(
xxen_util.dff_attribute_lov
(p_application_id => 401,
p_descriptive_flexfield_name => 'MTL_PHYSICAL_INVENTORIES',
p_context_name => :$column$.attribute_category,
p_column_name => 'ATTRIBUTE13',
p_attribute1 => :$column$.phys_inv_attribute1,
p_attribute2 => :$column$.phys_inv_attribute2,
p_attribute3 => :$column$.phys_inv_attribute3,
p_attribute4 => :$column$.phys_inv_attribute4,
p_attribute5 => :$column$.phys_inv_attribute5,
p_attribute6 => :$column$.phys_inv_attribute6,
p_attribute7 => :$column$.phys_inv_attribute7,
p_attribute8 => :$column$.phys_inv_attribute8,
p_attribute9 => :$column$.phys_inv_attribute9,
p_attribute10 => :$column$.phys_inv_attribute10,
p_attribute11 => :$column$.phys_inv_attribute11,
p_attribute12 => :$column$.phys_inv_attribute12,
p_attribute13 => :$column$.phys_inv_attribute13,
p_attribute14 => :$column$.phys_inv_attribute14,
p_attribute15 => :$column$.phys_inv_attribute15
)
) lov
order by
valueselect
xxen_util.display_flexfield_value(401,'MTL_PHYSICAL_INVENTORIES',mpiv.attribute_category,'ATTRIBUTE13',mpiv.row_id,mpiv.attribute13)
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_nameSELECT distinct
'(Context) ' || initcap(dffcu.application_column_name) || ': ' ||
listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name)
FROM
fnd_descriptive_flexs_vl dff,
fnd_descr_flex_contexts dffcx,
fnd_descr_flex_col_usage_vl dffcu
WHERE
dffcx.application_id = dff.application_id and
dffcx.descriptive_flexfield_name = dff.descriptive_flexfield_name and
dffcx.enabled_flag = 'Y' and
dffcu.application_id = dffcx.application_id and
dffcu.descriptive_flexfield_name = dffcx.descriptive_flexfield_name and
dffcu.descriptive_flex_context_code = dffcx.descriptive_flex_context_code and
dffcu.enabled_flag = 'Y' and
dff.application_id = 401 and
dff.application_table_name = 'MTL_PHYSICAL_INVENTORIES' and
dffcu.application_column_name = 'ATTRIBUTE13'39PHYS_INV_ATTRIBUTE14LOV customvarchar2Yselect
substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value,
substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description
from
table(
xxen_util.dff_attribute_lov
(p_application_id => 401,
p_descriptive_flexfield_name => 'MTL_PHYSICAL_INVENTORIES',
p_context_name => :$column$.attribute_category,
p_column_name => 'ATTRIBUTE14',
p_attribute1 => :$column$.phys_inv_attribute1,
p_attribute2 => :$column$.phys_inv_attribute2,
p_attribute3 => :$column$.phys_inv_attribute3,
p_attribute4 => :$column$.phys_inv_attribute4,
p_attribute5 => :$column$.phys_inv_attribute5,
p_attribute6 => :$column$.phys_inv_attribute6,
p_attribute7 => :$column$.phys_inv_attribute7,
p_attribute8 => :$column$.phys_inv_attribute8,
p_attribute9 => :$column$.phys_inv_attribute9,
p_attribute10 => :$column$.phys_inv_attribute10,
p_attribute11 => :$column$.phys_inv_attribute11,
p_attribute12 => :$column$.phys_inv_attribute12,
p_attribute13 => :$column$.phys_inv_attribute13,
p_attribute14 => :$column$.phys_inv_attribute14,
p_attribute15 => :$column$.phys_inv_attribute15
)
) lov
order by
valueselect
xxen_util.display_flexfield_value(401,'MTL_PHYSICAL_INVENTORIES',mpiv.attribute_category,'ATTRIBUTE14',mpiv.row_id,mpiv.attribute14)
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_nameSELECT distinct
'(Context) ' || initcap(dffcu.application_column_name) || ': ' ||
listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name)
FROM
fnd_descriptive_flexs_vl dff,
fnd_descr_flex_contexts dffcx,
fnd_descr_flex_col_usage_vl dffcu
WHERE
dffcx.application_id = dff.application_id and
dffcx.descriptive_flexfield_name = dff.descriptive_flexfield_name and
dffcx.enabled_flag = 'Y' and
dffcu.application_id = dffcx.application_id and
dffcu.descriptive_flexfield_name = dffcx.descriptive_flexfield_name and
dffcu.descriptive_flex_context_code = dffcx.descriptive_flex_context_code and
dffcu.enabled_flag = 'Y' and
dff.application_id = 401 and
dff.application_table_name = 'MTL_PHYSICAL_INVENTORIES' and
dffcu.application_column_name = 'ATTRIBUTE14'40PHYS_INV_ATTRIBUTE15LOV customvarchar2Yselect
substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value,
substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description
from
table(
xxen_util.dff_attribute_lov
(p_application_id => 401,
p_descriptive_flexfield_name => 'MTL_PHYSICAL_INVENTORIES',
p_context_name => :$column$.attribute_category,
p_column_name => 'ATTRIBUTE15',
p_attribute1 => :$column$.phys_inv_attribute1,
p_attribute2 => :$column$.phys_inv_attribute2,
p_attribute3 => :$column$.phys_inv_attribute3,
p_attribute4 => :$column$.phys_inv_attribute4,
p_attribute5 => :$column$.phys_inv_attribute5,
p_attribute6 => :$column$.phys_inv_attribute6,
p_attribute7 => :$column$.phys_inv_attribute7,
p_attribute8 => :$column$.phys_inv_attribute8,
p_attribute9 => :$column$.phys_inv_attribute9,
p_attribute10 => :$column$.phys_inv_attribute10,
p_attribute11 => :$column$.phys_inv_attribute11,
p_attribute12 => :$column$.phys_inv_attribute12,
p_attribute13 => :$column$.phys_inv_attribute13,
p_attribute14 => :$column$.phys_inv_attribute14,
p_attribute15 => :$column$.phys_inv_attribute15
)
) lov
order by
valueselect
xxen_util.display_flexfield_value(401,'MTL_PHYSICAL_INVENTORIES',mpiv.attribute_category,'ATTRIBUTE15',mpiv.row_id,mpiv.attribute15)
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_nameSELECT distinct
'(Context) ' || initcap(dffcu.application_column_name) || ': ' ||
listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name)
FROM
fnd_descriptive_flexs_vl dff,
fnd_descr_flex_contexts dffcx,
fnd_descr_flex_col_usage_vl dffcu
WHERE
dffcx.application_id = dff.application_id and
dffcx.descriptive_flexfield_name = dff.descriptive_flexfield_name and
dffcx.enabled_flag = 'Y' and
dffcu.application_id = dffcx.application_id and
dffcu.descriptive_flexfield_name = dffcx.descriptive_flexfield_name and
dffcu.descriptive_flex_context_code = dffcx.descriptive_flex_context_code and
dffcu.enabled_flag = 'Y' and
dff.application_id = 401 and
dff.application_table_name = 'MTL_PHYSICAL_INVENTORIES' and
dffcu.application_column_name = 'ATTRIBUTE15'41SUBINVENTORYLOV customvarchar2Yselect
msi.secondary_inventory_name value,
msi.description
from
mtl_parameters mp,
mtl_secondary_inventories msi
where
mp.organization_id = msi.organization_id and
mp.organization_code = :$column$.organization_code and
nvl(msi.disable_date,sysdate+1) > sysdate and
msi.quantity_tracked = 1 and
nvl(:$column$.all_subinventories,xxen_util.meaning(2,'INV_YES_NO',3)) != xxen_util.meaning(1,'INV_YES_NO',3)
order by
value42DELETE_SUBINVENTORYLOV customvarchar2Yselect 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual
where :$column$.subinventory is not null43SNAPSHOT_COMPLETECharvarchar2Display only field. This will be updated by the upload if the Freeze Physical Inventory report parameter is set to Yes.44FREEZE_DATEDatedateDisplay only field. This will be updated by the upload if the Freeze Physical Inventory report parameter is set to Yes.45PHYSICAL_INVENTORY_IDNumbernumberYYU1action_inCharACTION_CODE_U2status_outCharSTATUS_CODE_U3message_outCharMESSAGE_U4request_id_outNumberREQUEST_ID_U5p_physical_inventory_row_idoutNumberPHYSICAL_INVENTORY_ROW_IDU6p_replace_subinventoriesinCharREPLACE_SUBINVENTORIESU7p_organization_idinNumberORGANIZATION_CODEU8p_physical_inventory_nameinCharPHYSICAL_INVENTORY_NAMEU9p_physical_inventory_idinNumberPHYSICAL_INVENTORY_IDU10p_descriptioninCharDESCRIPTIONU11p_physical_inventory_dateinDatePHYSICAL_INVENTORY_DATEU12p_approval_requiredinNumberAPPROVAL_REQUIREDU13p_quantity_tolerance_plusinNumberQUANTITY_TOLERANCE_PLUSU14p_quantity_tolerance_minusinNumberQUANTITY_TOLERANCE_MINUSU15p_value_tolerance_plusinNumberVALUE_TOLERANCE_PLUSU16p_value_tolerance_minusinNumberVALUE_TOLERANCE_MINUSU17p_serial_count_optioninNumberSERIAL_COUNT_OPTIONU18p_serial_detail_optioninNumberSERIAL_DETAIL_OPTIONU19p_allow_dynamic_tagsinNumberALLOW_DYNAMIC_TAGSU20p_exclude_zero_balanceinCharEXCLUDE_ZERO_BALANCEU21p_exclude_negative_balanceinCharEXCLUDE_NEGATIVE_BALANCEU22p_all_subinventoriesinNumberALL_SUBINVENTORIESU23p_attribute_categoryinCharATTRIBUTE_CATEGORYU24p_attribute1inCharPHYS_INV_ATTRIBUTE1U25p_attribute2inCharPHYS_INV_ATTRIBUTE2U26p_attribute3inCharPHYS_INV_ATTRIBUTE3U27p_attribute4inCharPHYS_INV_ATTRIBUTE4U28p_attribute5inCharPHYS_INV_ATTRIBUTE5U29p_attribute6inCharPHYS_INV_ATTRIBUTE6U30p_attribute7inCharPHYS_INV_ATTRIBUTE7U31p_attribute8inCharPHYS_INV_ATTRIBUTE8U32p_attribute9inCharPHYS_INV_ATTRIBUTE9U33p_attribute10inCharPHYS_INV_ATTRIBUTE10U34p_attribute11inCharPHYS_INV_ATTRIBUTE11U35p_attribute12inCharPHYS_INV_ATTRIBUTE12U36p_attribute13inCharPHYS_INV_ATTRIBUTE13U37p_attribute14inCharPHYS_INV_ATTRIBUTE14U38p_attribute15inCharPHYS_INV_ATTRIBUTE15U39p_subinventoryinCharSUBINVENTORYU40p_delete_subinventoryinCharDELETE_SUBINVENTORYP1status_outCharSTATUS_CODE_P2message_outCharMESSAGE_P3p_freeze_physical_inventoryinCharYFREEZE_PHYSICAL_INVENTORYP4p_organization_idinNumberORGANIZATION_CODEP5p_physical_inventory_idinNumberPHYSICAL_INVENTORY_ROW_IDError SQLOrder Byupload_row,
organization_code,
physical_inventory_date desc,
physical_inventory_name,
subinventorySuccess SQLselect
xu.action_,
xu.status_,
nvl(xu.message_,case when xxen_util.lookup_code(xu.delete_subinventory,'YES_NO',0) = 'Y' and mps.subinventory is null then 'Subinventory Deleted' else null end) message_,
xu.request_id_,
xu.modified_columns_,
xu.replace_subinventories,
xu.freeze_physical_inventory,
xu.upload_row,
xu.physical_inventory_row_id,
-- Physical Inventory
mp.organization_code,
mpiv.physical_inventory_name,
mpiv.description,
mpiv.physical_inventory_date,
decode(mpiv.approval_required,1,'Always',2,'Never',3,'If out of tolerance',mpiv.approval_required) approval_required,
mpiv.approval_tolerance_pos quantity_tolerance_plus,
mpiv.approval_tolerance_neg quantity_tolerance_minus,
mpiv.cost_variance_pos value_tolerance_plus,
mpiv.cost_variance_neg value_tolerance_minus,
&lp_serial_control_cols
xxen_util.meaning(decode(mpiv.dynamic_tag_entry_flag,1,'Y',null),'YES_NO',0) allow_dynamic_tags,
xxen_util.meaning(decode(mpiv.exclude_zero_balance,'Y','Y',null),'YES_NO',0) exclude_zero_balance,
xxen_util.meaning(decode(mpiv.exclude_negative_balance,'Y','Y',null),'YES_NO',0) exclude_negative_balance,
xxen_util.meaning(decode(mpiv.all_subinventories_flag,1,'Y',null),'YES_NO',0) all_subinventories,
-- DFF Attributes
xxen_util.display_flexfield_context(401,'MTL_PHYSICAL_INVENTORIES',mpiv.attribute_category) attribute_category,
xxen_util.display_flexfield_value(401,'MTL_PHYSICAL_INVENTORIES',mpiv.attribute_category,'ATTRIBUTE1',mpiv.row_id,mpiv.attribute1) phys_inv_attribute1,
xxen_util.display_flexfield_value(401,'MTL_PHYSICAL_INVENTORIES',mpiv.attribute_category,'ATTRIBUTE2',mpiv.row_id,mpiv.attribute2) phys_inv_attribute2,
xxen_util.display_flexfield_value(401,'MTL_PHYSICAL_INVENTORIES',mpiv.attribute_category,'ATTRIBUTE3',mpiv.row_id,mpiv.attribute3) phys_inv_attribute3,
xxen_util.display_flexfield_value(401,'MTL_PHYSICAL_INVENTORIES',mpiv.attribute_category,'ATTRIBUTE4',mpiv.row_id,mpiv.attribute4) phys_inv_attribute4,
xxen_util.display_flexfield_value(401,'MTL_PHYSICAL_INVENTORIES',mpiv.attribute_category,'ATTRIBUTE5',mpiv.row_id,mpiv.attribute5) phys_inv_attribute5,
xxen_util.display_flexfield_value(401,'MTL_PHYSICAL_INVENTORIES',mpiv.attribute_category,'ATTRIBUTE6',mpiv.row_id,mpiv.attribute6) phys_inv_attribute6,
xxen_util.display_flexfield_value(401,'MTL_PHYSICAL_INVENTORIES',mpiv.attribute_category,'ATTRIBUTE7',mpiv.row_id,mpiv.attribute7) phys_inv_attribute7,
xxen_util.display_flexfield_value(401,'MTL_PHYSICAL_INVENTORIES',mpiv.attribute_category,'ATTRIBUTE8',mpiv.row_id,mpiv.attribute8) phys_inv_attribute8,
xxen_util.display_flexfield_value(401,'MTL_PHYSICAL_INVENTORIES',mpiv.attribute_category,'ATTRIBUTE9',mpiv.row_id,mpiv.attribute9) phys_inv_attribute9,
xxen_util.display_flexfield_value(401,'MTL_PHYSICAL_INVENTORIES',mpiv.attribute_category,'ATTRIBUTE10',mpiv.row_id,mpiv.attribute10) phys_inv_attribute10,
xxen_util.display_flexfield_value(401,'MTL_PHYSICAL_INVENTORIES',mpiv.attribute_category,'ATTRIBUTE11',mpiv.row_id,mpiv.attribute11) phys_inv_attribute11,
xxen_util.display_flexfield_value(401,'MTL_PHYSICAL_INVENTORIES',mpiv.attribute_category,'ATTRIBUTE12',mpiv.row_id,mpiv.attribute12) phys_inv_attribute12,
xxen_util.display_flexfield_value(401,'MTL_PHYSICAL_INVENTORIES',mpiv.attribute_category,'ATTRIBUTE13',mpiv.row_id,mpiv.attribute13) phys_inv_attribute13,
xxen_util.display_flexfield_value(401,'MTL_PHYSICAL_INVENTORIES',mpiv.attribute_category,'ATTRIBUTE14',mpiv.row_id,mpiv.attribute14) phys_inv_attribute14,
xxen_util.display_flexfield_value(401,'MTL_PHYSICAL_INVENTORIES',mpiv.attribute_category,'ATTRIBUTE15',mpiv.row_id,mpiv.attribute15) phys_inv_attribute15,
-- Subinventories
nvl(mps.subinventory,decode(xxen_util.lookup_code(xu.delete_subinventory,'YES_NO',0),'Y',xu.subinventory,null)) subinventory,
xu.delete_subinventory,
--
xxen_util.meaning(decode(mpiv.snapshot_complete,1,'Y',null),'YES_NO',0) snapshot_complete,
mpiv.freeze_date,
-- Ids
mpiv.physical_inventory_id
from
xxen_inv_physical_inven_2468_u xu,
mtl_physical_inventories_v mpiv,
mtl_physical_subinventories mps,
mtl_parameters mp
where
nvl(xu.status_code_,xxen_upload.status_error) = xxen_upload.status_success and
xu.physical_inventory_row_id = mpiv.physical_inventory_id and
xu.physical_inventory_row_id = mps.physical_inventory_id(+) and
xu.subinventory = mps.subinventory(+) and
mpiv.organization_id = mp.organization_idDefault value:$column$.organization_codeORGANIZATION_CODEALLOW_DYNAMIC_TAGSDefault value:$column$.physical_inventory_namePHYSICAL_INVENTORY_NAMEALLOW_DYNAMIC_TAGSDefault value:$column$.organization_codeORGANIZATION_CODEALL_SUBINVENTORIESDefault value:$column$.physical_inventory_namePHYSICAL_INVENTORY_NAMEALL_SUBINVENTORIESDefault value:$column$.organization_codeORGANIZATION_CODEAPPROVAL_REQUIREDDefault value:$column$.physical_inventory_namePHYSICAL_INVENTORY_NAMEAPPROVAL_REQUIREDDefault value:$column$.organization_codeORGANIZATION_CODEATTRIBUTE_CATEGORYDefault value:$column$.physical_inventory_namePHYSICAL_INVENTORY_NAMEATTRIBUTE_CATEGORYLOV query:$column$.subinventorySUBINVENTORYDELETE_SUBINVENTORYDefault value:$column$.organization_codeORGANIZATION_CODEDESCRIPTIONDefault value:$column$.physical_inventory_namePHYSICAL_INVENTORY_NAMEDESCRIPTIONDefault value:$column$.organization_codeORGANIZATION_CODEEXCLUDE_NEGATIVE_BALANCEDefault value:$column$.physical_inventory_namePHYSICAL_INVENTORY_NAMEEXCLUDE_NEGATIVE_BALANCEDefault value:$column$.organization_codeORGANIZATION_CODEEXCLUDE_ZERO_BALANCEDefault value:$column$.physical_inventory_namePHYSICAL_INVENTORY_NAMEEXCLUDE_ZERO_BALANCEDefault value:$flex$.Freeze_Physical_InventoryFreeze Physical Inventory|:p_freeze_physical_inventory|FREEZE_PHYSICAL_INVENTORYDefault value:$column$.organization_codeORGANIZATION_CODEPHYSICAL_INVENTORY_DATEDefault value:$column$.physical_inventory_namePHYSICAL_INVENTORY_NAMEPHYSICAL_INVENTORY_DATELOV query:$column$.organization_codeORGANIZATION_CODEPHYSICAL_INVENTORY_NAMELOV query:$column$.attribute_categoryATTRIBUTE_CATEGORYPHYS_INV_ATTRIBUTE1Default value:$column$.organization_codeORGANIZATION_CODEPHYS_INV_ATTRIBUTE1Default value:$column$.physical_inventory_namePHYSICAL_INVENTORY_NAMEPHYS_INV_ATTRIBUTE1LOV query:$column$.phys_inv_attribute1PHYS_INV_ATTRIBUTE1PHYS_INV_ATTRIBUTE1LOV query:$column$.phys_inv_attribute10PHYS_INV_ATTRIBUTE10PHYS_INV_ATTRIBUTE1LOV query:$column$.phys_inv_attribute11PHYS_INV_ATTRIBUTE11PHYS_INV_ATTRIBUTE1LOV query:$column$.phys_inv_attribute12PHYS_INV_ATTRIBUTE12PHYS_INV_ATTRIBUTE1LOV query:$column$.phys_inv_attribute13PHYS_INV_ATTRIBUTE13PHYS_INV_ATTRIBUTE1LOV query:$column$.phys_inv_attribute14PHYS_INV_ATTRIBUTE14PHYS_INV_ATTRIBUTE1LOV query:$column$.phys_inv_attribute15PHYS_INV_ATTRIBUTE15PHYS_INV_ATTRIBUTE1LOV query:$column$.phys_inv_attribute2PHYS_INV_ATTRIBUTE2PHYS_INV_ATTRIBUTE1LOV query:$column$.phys_inv_attribute3PHYS_INV_ATTRIBUTE3PHYS_INV_ATTRIBUTE1LOV query:$column$.phys_inv_attribute4PHYS_INV_ATTRIBUTE4PHYS_INV_ATTRIBUTE1LOV query:$column$.phys_inv_attribute5PHYS_INV_ATTRIBUTE5PHYS_INV_ATTRIBUTE1LOV query:$column$.phys_inv_attribute6PHYS_INV_ATTRIBUTE6PHYS_INV_ATTRIBUTE1LOV query:$column$.phys_inv_attribute7PHYS_INV_ATTRIBUTE7PHYS_INV_ATTRIBUTE1LOV query:$column$.phys_inv_attribute8PHYS_INV_ATTRIBUTE8PHYS_INV_ATTRIBUTE1LOV query:$column$.phys_inv_attribute9PHYS_INV_ATTRIBUTE9PHYS_INV_ATTRIBUTE1LOV query:$column$.attribute_categoryATTRIBUTE_CATEGORYPHYS_INV_ATTRIBUTE10Default value:$column$.organization_codeORGANIZATION_CODEPHYS_INV_ATTRIBUTE10Default value:$column$.physical_inventory_namePHYSICAL_INVENTORY_NAMEPHYS_INV_ATTRIBUTE10LOV query:$column$.phys_inv_attribute1PHYS_INV_ATTRIBUTE1PHYS_INV_ATTRIBUTE10LOV query:$column$.phys_inv_attribute10PHYS_INV_ATTRIBUTE10PHYS_INV_ATTRIBUTE10LOV query:$column$.phys_inv_attribute11PHYS_INV_ATTRIBUTE11PHYS_INV_ATTRIBUTE10LOV query:$column$.phys_inv_attribute12PHYS_INV_ATTRIBUTE12PHYS_INV_ATTRIBUTE10LOV query:$column$.phys_inv_attribute13PHYS_INV_ATTRIBUTE13PHYS_INV_ATTRIBUTE10LOV query:$column$.phys_inv_attribute14PHYS_INV_ATTRIBUTE14PHYS_INV_ATTRIBUTE10LOV query:$column$.phys_inv_attribute15PHYS_INV_ATTRIBUTE15PHYS_INV_ATTRIBUTE10LOV query:$column$.phys_inv_attribute2PHYS_INV_ATTRIBUTE2PHYS_INV_ATTRIBUTE10LOV query:$column$.phys_inv_attribute3PHYS_INV_ATTRIBUTE3PHYS_INV_ATTRIBUTE10LOV query:$column$.phys_inv_attribute4PHYS_INV_ATTRIBUTE4PHYS_INV_ATTRIBUTE10LOV query:$column$.phys_inv_attribute5PHYS_INV_ATTRIBUTE5PHYS_INV_ATTRIBUTE10LOV query:$column$.phys_inv_attribute6PHYS_INV_ATTRIBUTE6PHYS_INV_ATTRIBUTE10LOV query:$column$.phys_inv_attribute7PHYS_INV_ATTRIBUTE7PHYS_INV_ATTRIBUTE10LOV query:$column$.phys_inv_attribute8PHYS_INV_ATTRIBUTE8PHYS_INV_ATTRIBUTE10LOV query:$column$.phys_inv_attribute9PHYS_INV_ATTRIBUTE9PHYS_INV_ATTRIBUTE10LOV query:$column$.attribute_categoryATTRIBUTE_CATEGORYPHYS_INV_ATTRIBUTE11Default value:$column$.organization_codeORGANIZATION_CODEPHYS_INV_ATTRIBUTE11Default value:$column$.physical_inventory_namePHYSICAL_INVENTORY_NAMEPHYS_INV_ATTRIBUTE11LOV query:$column$.phys_inv_attribute1PHYS_INV_ATTRIBUTE1PHYS_INV_ATTRIBUTE11LOV query:$column$.phys_inv_attribute10PHYS_INV_ATTRIBUTE10PHYS_INV_ATTRIBUTE11LOV query:$column$.phys_inv_attribute11PHYS_INV_ATTRIBUTE11PHYS_INV_ATTRIBUTE11LOV query:$column$.phys_inv_attribute12PHYS_INV_ATTRIBUTE12PHYS_INV_ATTRIBUTE11LOV query:$column$.phys_inv_attribute13PHYS_INV_ATTRIBUTE13PHYS_INV_ATTRIBUTE11LOV query:$column$.phys_inv_attribute14PHYS_INV_ATTRIBUTE14PHYS_INV_ATTRIBUTE11LOV query:$column$.phys_inv_attribute15PHYS_INV_ATTRIBUTE15PHYS_INV_ATTRIBUTE11LOV query:$column$.phys_inv_attribute2PHYS_INV_ATTRIBUTE2PHYS_INV_ATTRIBUTE11LOV query:$column$.phys_inv_attribute3PHYS_INV_ATTRIBUTE3PHYS_INV_ATTRIBUTE11LOV query:$column$.phys_inv_attribute4PHYS_INV_ATTRIBUTE4PHYS_INV_ATTRIBUTE11LOV query:$column$.phys_inv_attribute5PHYS_INV_ATTRIBUTE5PHYS_INV_ATTRIBUTE11LOV query:$column$.phys_inv_attribute6PHYS_INV_ATTRIBUTE6PHYS_INV_ATTRIBUTE11LOV query:$column$.phys_inv_attribute7PHYS_INV_ATTRIBUTE7PHYS_INV_ATTRIBUTE11LOV query:$column$.phys_inv_attribute8PHYS_INV_ATTRIBUTE8PHYS_INV_ATTRIBUTE11LOV query:$column$.phys_inv_attribute9PHYS_INV_ATTRIBUTE9PHYS_INV_ATTRIBUTE11LOV query:$column$.attribute_categoryATTRIBUTE_CATEGORYPHYS_INV_ATTRIBUTE12Default value:$column$.organization_codeORGANIZATION_CODEPHYS_INV_ATTRIBUTE12Default value:$column$.physical_inventory_namePHYSICAL_INVENTORY_NAMEPHYS_INV_ATTRIBUTE12LOV query:$column$.phys_inv_attribute1PHYS_INV_ATTRIBUTE1PHYS_INV_ATTRIBUTE12LOV query:$column$.phys_inv_attribute10PHYS_INV_ATTRIBUTE10PHYS_INV_ATTRIBUTE12LOV query:$column$.phys_inv_attribute11PHYS_INV_ATTRIBUTE11PHYS_INV_ATTRIBUTE12LOV query:$column$.phys_inv_attribute12PHYS_INV_ATTRIBUTE12PHYS_INV_ATTRIBUTE12LOV query:$column$.phys_inv_attribute13PHYS_INV_ATTRIBUTE13PHYS_INV_ATTRIBUTE12LOV query:$column$.phys_inv_attribute14PHYS_INV_ATTRIBUTE14PHYS_INV_ATTRIBUTE12LOV query:$column$.phys_inv_attribute15PHYS_INV_ATTRIBUTE15PHYS_INV_ATTRIBUTE12LOV query:$column$.phys_inv_attribute2PHYS_INV_ATTRIBUTE2PHYS_INV_ATTRIBUTE12LOV query:$column$.phys_inv_attribute3PHYS_INV_ATTRIBUTE3PHYS_INV_ATTRIBUTE12LOV query:$column$.phys_inv_attribute4PHYS_INV_ATTRIBUTE4PHYS_INV_ATTRIBUTE12LOV query:$column$.phys_inv_attribute5PHYS_INV_ATTRIBUTE5PHYS_INV_ATTRIBUTE12LOV query:$column$.phys_inv_attribute6PHYS_INV_ATTRIBUTE6PHYS_INV_ATTRIBUTE12LOV query:$column$.phys_inv_attribute7PHYS_INV_ATTRIBUTE7PHYS_INV_ATTRIBUTE12LOV query:$column$.phys_inv_attribute8PHYS_INV_ATTRIBUTE8PHYS_INV_ATTRIBUTE12LOV query:$column$.phys_inv_attribute9PHYS_INV_ATTRIBUTE9PHYS_INV_ATTRIBUTE12LOV query:$column$.attribute_categoryATTRIBUTE_CATEGORYPHYS_INV_ATTRIBUTE13Default value:$column$.organization_codeORGANIZATION_CODEPHYS_INV_ATTRIBUTE13Default value:$column$.physical_inventory_namePHYSICAL_INVENTORY_NAMEPHYS_INV_ATTRIBUTE13LOV query:$column$.phys_inv_attribute1PHYS_INV_ATTRIBUTE1PHYS_INV_ATTRIBUTE13LOV query:$column$.phys_inv_attribute10PHYS_INV_ATTRIBUTE10PHYS_INV_ATTRIBUTE13LOV query:$column$.phys_inv_attribute11PHYS_INV_ATTRIBUTE11PHYS_INV_ATTRIBUTE13LOV query:$column$.phys_inv_attribute12PHYS_INV_ATTRIBUTE12PHYS_INV_ATTRIBUTE13LOV query:$column$.phys_inv_attribute13PHYS_INV_ATTRIBUTE13PHYS_INV_ATTRIBUTE13LOV query:$column$.phys_inv_attribute14PHYS_INV_ATTRIBUTE14PHYS_INV_ATTRIBUTE13LOV query:$column$.phys_inv_attribute15PHYS_INV_ATTRIBUTE15PHYS_INV_ATTRIBUTE13LOV query:$column$.phys_inv_attribute2PHYS_INV_ATTRIBUTE2PHYS_INV_ATTRIBUTE13LOV query:$column$.phys_inv_attribute3PHYS_INV_ATTRIBUTE3PHYS_INV_ATTRIBUTE13LOV query:$column$.phys_inv_attribute4PHYS_INV_ATTRIBUTE4PHYS_INV_ATTRIBUTE13LOV query:$column$.phys_inv_attribute5PHYS_INV_ATTRIBUTE5PHYS_INV_ATTRIBUTE13LOV query:$column$.phys_inv_attribute6PHYS_INV_ATTRIBUTE6PHYS_INV_ATTRIBUTE13LOV query:$column$.phys_inv_attribute7PHYS_INV_ATTRIBUTE7PHYS_INV_ATTRIBUTE13LOV query:$column$.phys_inv_attribute8PHYS_INV_ATTRIBUTE8PHYS_INV_ATTRIBUTE13LOV query:$column$.phys_inv_attribute9PHYS_INV_ATTRIBUTE9PHYS_INV_ATTRIBUTE13LOV query:$column$.attribute_categoryATTRIBUTE_CATEGORYPHYS_INV_ATTRIBUTE14Default value:$column$.organization_codeORGANIZATION_CODEPHYS_INV_ATTRIBUTE14Default value:$column$.physical_inventory_namePHYSICAL_INVENTORY_NAMEPHYS_INV_ATTRIBUTE14LOV query:$column$.phys_inv_attribute1PHYS_INV_ATTRIBUTE1PHYS_INV_ATTRIBUTE14LOV query:$column$.phys_inv_attribute10PHYS_INV_ATTRIBUTE10PHYS_INV_ATTRIBUTE14LOV query:$column$.phys_inv_attribute11PHYS_INV_ATTRIBUTE11PHYS_INV_ATTRIBUTE14LOV query:$column$.phys_inv_attribute12PHYS_INV_ATTRIBUTE12PHYS_INV_ATTRIBUTE14LOV query:$column$.phys_inv_attribute13PHYS_INV_ATTRIBUTE13PHYS_INV_ATTRIBUTE14LOV query:$column$.phys_inv_attribute14PHYS_INV_ATTRIBUTE14PHYS_INV_ATTRIBUTE14LOV query:$column$.phys_inv_attribute15PHYS_INV_ATTRIBUTE15PHYS_INV_ATTRIBUTE14LOV query:$column$.phys_inv_attribute2PHYS_INV_ATTRIBUTE2PHYS_INV_ATTRIBUTE14LOV query:$column$.phys_inv_attribute3PHYS_INV_ATTRIBUTE3PHYS_INV_ATTRIBUTE14LOV query:$column$.phys_inv_attribute4PHYS_INV_ATTRIBUTE4PHYS_INV_ATTRIBUTE14LOV query:$column$.phys_inv_attribute5PHYS_INV_ATTRIBUTE5PHYS_INV_ATTRIBUTE14LOV query:$column$.phys_inv_attribute6PHYS_INV_ATTRIBUTE6PHYS_INV_ATTRIBUTE14LOV query:$column$.phys_inv_attribute7PHYS_INV_ATTRIBUTE7PHYS_INV_ATTRIBUTE14LOV query:$column$.phys_inv_attribute8PHYS_INV_ATTRIBUTE8PHYS_INV_ATTRIBUTE14LOV query:$column$.phys_inv_attribute9PHYS_INV_ATTRIBUTE9PHYS_INV_ATTRIBUTE14LOV query:$column$.attribute_categoryATTRIBUTE_CATEGORYPHYS_INV_ATTRIBUTE15Default value:$column$.organization_codeORGANIZATION_CODEPHYS_INV_ATTRIBUTE15Default value:$column$.physical_inventory_namePHYSICAL_INVENTORY_NAMEPHYS_INV_ATTRIBUTE15LOV query:$column$.phys_inv_attribute1PHYS_INV_ATTRIBUTE1PHYS_INV_ATTRIBUTE15LOV query:$column$.phys_inv_attribute10PHYS_INV_ATTRIBUTE10PHYS_INV_ATTRIBUTE15LOV query:$column$.phys_inv_attribute11PHYS_INV_ATTRIBUTE11PHYS_INV_ATTRIBUTE15LOV query:$column$.phys_inv_attribute12PHYS_INV_ATTRIBUTE12PHYS_INV_ATTRIBUTE15LOV query:$column$.phys_inv_attribute13PHYS_INV_ATTRIBUTE13PHYS_INV_ATTRIBUTE15LOV query:$column$.phys_inv_attribute14PHYS_INV_ATTRIBUTE14PHYS_INV_ATTRIBUTE15LOV query:$column$.phys_inv_attribute15PHYS_INV_ATTRIBUTE15PHYS_INV_ATTRIBUTE15LOV query:$column$.phys_inv_attribute2PHYS_INV_ATTRIBUTE2PHYS_INV_ATTRIBUTE15LOV query:$column$.phys_inv_attribute3PHYS_INV_ATTRIBUTE3PHYS_INV_ATTRIBUTE15LOV query:$column$.phys_inv_attribute4PHYS_INV_ATTRIBUTE4PHYS_INV_ATTRIBUTE15LOV query:$column$.phys_inv_attribute5PHYS_INV_ATTRIBUTE5PHYS_INV_ATTRIBUTE15LOV query:$column$.phys_inv_attribute6PHYS_INV_ATTRIBUTE6PHYS_INV_ATTRIBUTE15LOV query:$column$.phys_inv_attribute7PHYS_INV_ATTRIBUTE7PHYS_INV_ATTRIBUTE15LOV query:$column$.phys_inv_attribute8PHYS_INV_ATTRIBUTE8PHYS_INV_ATTRIBUTE15LOV query:$column$.phys_inv_attribute9PHYS_INV_ATTRIBUTE9PHYS_INV_ATTRIBUTE15LOV query:$column$.attribute_categoryATTRIBUTE_CATEGORYPHYS_INV_ATTRIBUTE2Default value:$column$.organization_codeORGANIZATION_CODEPHYS_INV_ATTRIBUTE2Default value:$column$.physical_inventory_namePHYSICAL_INVENTORY_NAMEPHYS_INV_ATTRIBUTE2LOV query:$column$.phys_inv_attribute1PHYS_INV_ATTRIBUTE1PHYS_INV_ATTRIBUTE2LOV query:$column$.phys_inv_attribute10PHYS_INV_ATTRIBUTE10PHYS_INV_ATTRIBUTE2LOV query:$column$.phys_inv_attribute11PHYS_INV_ATTRIBUTE11PHYS_INV_ATTRIBUTE2LOV query:$column$.phys_inv_attribute12PHYS_INV_ATTRIBUTE12PHYS_INV_ATTRIBUTE2LOV query:$column$.phys_inv_attribute13PHYS_INV_ATTRIBUTE13PHYS_INV_ATTRIBUTE2LOV query:$column$.phys_inv_attribute14PHYS_INV_ATTRIBUTE14PHYS_INV_ATTRIBUTE2LOV query:$column$.phys_inv_attribute15PHYS_INV_ATTRIBUTE15PHYS_INV_ATTRIBUTE2LOV query:$column$.phys_inv_attribute2PHYS_INV_ATTRIBUTE2PHYS_INV_ATTRIBUTE2LOV query:$column$.phys_inv_attribute3PHYS_INV_ATTRIBUTE3PHYS_INV_ATTRIBUTE2LOV query:$column$.phys_inv_attribute4PHYS_INV_ATTRIBUTE4PHYS_INV_ATTRIBUTE2LOV query:$column$.phys_inv_attribute5PHYS_INV_ATTRIBUTE5PHYS_INV_ATTRIBUTE2LOV query:$column$.phys_inv_attribute6PHYS_INV_ATTRIBUTE6PHYS_INV_ATTRIBUTE2LOV query:$column$.phys_inv_attribute7PHYS_INV_ATTRIBUTE7PHYS_INV_ATTRIBUTE2LOV query:$column$.phys_inv_attribute8PHYS_INV_ATTRIBUTE8PHYS_INV_ATTRIBUTE2LOV query:$column$.phys_inv_attribute9PHYS_INV_ATTRIBUTE9PHYS_INV_ATTRIBUTE2LOV query:$column$.attribute_categoryATTRIBUTE_CATEGORYPHYS_INV_ATTRIBUTE3Default value:$column$.organization_codeORGANIZATION_CODEPHYS_INV_ATTRIBUTE3Default value:$column$.physical_inventory_namePHYSICAL_INVENTORY_NAMEPHYS_INV_ATTRIBUTE3LOV query:$column$.phys_inv_attribute1PHYS_INV_ATTRIBUTE1PHYS_INV_ATTRIBUTE3LOV query:$column$.phys_inv_attribute10PHYS_INV_ATTRIBUTE10PHYS_INV_ATTRIBUTE3LOV query:$column$.phys_inv_attribute11PHYS_INV_ATTRIBUTE11PHYS_INV_ATTRIBUTE3LOV query:$column$.phys_inv_attribute12PHYS_INV_ATTRIBUTE12PHYS_INV_ATTRIBUTE3LOV query:$column$.phys_inv_attribute13PHYS_INV_ATTRIBUTE13PHYS_INV_ATTRIBUTE3LOV query:$column$.phys_inv_attribute14PHYS_INV_ATTRIBUTE14PHYS_INV_ATTRIBUTE3LOV query:$column$.phys_inv_attribute15PHYS_INV_ATTRIBUTE15PHYS_INV_ATTRIBUTE3LOV query:$column$.phys_inv_attribute2PHYS_INV_ATTRIBUTE2PHYS_INV_ATTRIBUTE3LOV query:$column$.phys_inv_attribute3PHYS_INV_ATTRIBUTE3PHYS_INV_ATTRIBUTE3LOV query:$column$.phys_inv_attribute4PHYS_INV_ATTRIBUTE4PHYS_INV_ATTRIBUTE3LOV query:$column$.phys_inv_attribute5PHYS_INV_ATTRIBUTE5PHYS_INV_ATTRIBUTE3LOV query:$column$.phys_inv_attribute6PHYS_INV_ATTRIBUTE6PHYS_INV_ATTRIBUTE3LOV query:$column$.phys_inv_attribute7PHYS_INV_ATTRIBUTE7PHYS_INV_ATTRIBUTE3LOV query:$column$.phys_inv_attribute8PHYS_INV_ATTRIBUTE8PHYS_INV_ATTRIBUTE3LOV query:$column$.phys_inv_attribute9PHYS_INV_ATTRIBUTE9PHYS_INV_ATTRIBUTE3LOV query:$column$.attribute_categoryATTRIBUTE_CATEGORYPHYS_INV_ATTRIBUTE4Default value:$column$.organization_codeORGANIZATION_CODEPHYS_INV_ATTRIBUTE4Default value:$column$.physical_inventory_namePHYSICAL_INVENTORY_NAMEPHYS_INV_ATTRIBUTE4LOV query:$column$.phys_inv_attribute1PHYS_INV_ATTRIBUTE1PHYS_INV_ATTRIBUTE4LOV query:$column$.phys_inv_attribute10PHYS_INV_ATTRIBUTE10PHYS_INV_ATTRIBUTE4LOV query:$column$.phys_inv_attribute11PHYS_INV_ATTRIBUTE11PHYS_INV_ATTRIBUTE4LOV query:$column$.phys_inv_attribute12PHYS_INV_ATTRIBUTE12PHYS_INV_ATTRIBUTE4LOV query:$column$.phys_inv_attribute13PHYS_INV_ATTRIBUTE13PHYS_INV_ATTRIBUTE4LOV query:$column$.phys_inv_attribute14PHYS_INV_ATTRIBUTE14PHYS_INV_ATTRIBUTE4LOV query:$column$.phys_inv_attribute15PHYS_INV_ATTRIBUTE15PHYS_INV_ATTRIBUTE4LOV query:$column$.phys_inv_attribute2PHYS_INV_ATTRIBUTE2PHYS_INV_ATTRIBUTE4LOV query:$column$.phys_inv_attribute3PHYS_INV_ATTRIBUTE3PHYS_INV_ATTRIBUTE4LOV query:$column$.phys_inv_attribute4PHYS_INV_ATTRIBUTE4PHYS_INV_ATTRIBUTE4LOV query:$column$.phys_inv_attribute5PHYS_INV_ATTRIBUTE5PHYS_INV_ATTRIBUTE4LOV query:$column$.phys_inv_attribute6PHYS_INV_ATTRIBUTE6PHYS_INV_ATTRIBUTE4LOV query:$column$.phys_inv_attribute7PHYS_INV_ATTRIBUTE7PHYS_INV_ATTRIBUTE4LOV query:$column$.phys_inv_attribute8PHYS_INV_ATTRIBUTE8PHYS_INV_ATTRIBUTE4LOV query:$column$.phys_inv_attribute9PHYS_INV_ATTRIBUTE9PHYS_INV_ATTRIBUTE4LOV query:$column$.attribute_categoryATTRIBUTE_CATEGORYPHYS_INV_ATTRIBUTE5Default value:$column$.organization_codeORGANIZATION_CODEPHYS_INV_ATTRIBUTE5Default value:$column$.physical_inventory_namePHYSICAL_INVENTORY_NAMEPHYS_INV_ATTRIBUTE5LOV query:$column$.phys_inv_attribute1PHYS_INV_ATTRIBUTE1PHYS_INV_ATTRIBUTE5LOV query:$column$.phys_inv_attribute10PHYS_INV_ATTRIBUTE10PHYS_INV_ATTRIBUTE5LOV query:$column$.phys_inv_attribute11PHYS_INV_ATTRIBUTE11PHYS_INV_ATTRIBUTE5LOV query:$column$.phys_inv_attribute12PHYS_INV_ATTRIBUTE12PHYS_INV_ATTRIBUTE5LOV query:$column$.phys_inv_attribute13PHYS_INV_ATTRIBUTE13PHYS_INV_ATTRIBUTE5LOV query:$column$.phys_inv_attribute14PHYS_INV_ATTRIBUTE14PHYS_INV_ATTRIBUTE5LOV query:$column$.phys_inv_attribute15PHYS_INV_ATTRIBUTE15PHYS_INV_ATTRIBUTE5LOV query:$column$.phys_inv_attribute2PHYS_INV_ATTRIBUTE2PHYS_INV_ATTRIBUTE5LOV query:$column$.phys_inv_attribute3PHYS_INV_ATTRIBUTE3PHYS_INV_ATTRIBUTE5LOV query:$column$.phys_inv_attribute4PHYS_INV_ATTRIBUTE4PHYS_INV_ATTRIBUTE5LOV query:$column$.phys_inv_attribute5PHYS_INV_ATTRIBUTE5PHYS_INV_ATTRIBUTE5LOV query:$column$.phys_inv_attribute6PHYS_INV_ATTRIBUTE6PHYS_INV_ATTRIBUTE5LOV query:$column$.phys_inv_attribute7PHYS_INV_ATTRIBUTE7PHYS_INV_ATTRIBUTE5LOV query:$column$.phys_inv_attribute8PHYS_INV_ATTRIBUTE8PHYS_INV_ATTRIBUTE5LOV query:$column$.phys_inv_attribute9PHYS_INV_ATTRIBUTE9PHYS_INV_ATTRIBUTE5LOV query:$column$.attribute_categoryATTRIBUTE_CATEGORYPHYS_INV_ATTRIBUTE6Default value:$column$.organization_codeORGANIZATION_CODEPHYS_INV_ATTRIBUTE6Default value:$column$.physical_inventory_namePHYSICAL_INVENTORY_NAMEPHYS_INV_ATTRIBUTE6LOV query:$column$.phys_inv_attribute1PHYS_INV_ATTRIBUTE1PHYS_INV_ATTRIBUTE6LOV query:$column$.phys_inv_attribute10PHYS_INV_ATTRIBUTE10PHYS_INV_ATTRIBUTE6LOV query:$column$.phys_inv_attribute11PHYS_INV_ATTRIBUTE11PHYS_INV_ATTRIBUTE6LOV query:$column$.phys_inv_attribute12PHYS_INV_ATTRIBUTE12PHYS_INV_ATTRIBUTE6LOV query:$column$.phys_inv_attribute13PHYS_INV_ATTRIBUTE13PHYS_INV_ATTRIBUTE6LOV query:$column$.phys_inv_attribute14PHYS_INV_ATTRIBUTE14PHYS_INV_ATTRIBUTE6LOV query:$column$.phys_inv_attribute15PHYS_INV_ATTRIBUTE15PHYS_INV_ATTRIBUTE6LOV query:$column$.phys_inv_attribute2PHYS_INV_ATTRIBUTE2PHYS_INV_ATTRIBUTE6LOV query:$column$.phys_inv_attribute3PHYS_INV_ATTRIBUTE3PHYS_INV_ATTRIBUTE6LOV query:$column$.phys_inv_attribute4PHYS_INV_ATTRIBUTE4PHYS_INV_ATTRIBUTE6LOV query:$column$.phys_inv_attribute5PHYS_INV_ATTRIBUTE5PHYS_INV_ATTRIBUTE6LOV query:$column$.phys_inv_attribute6PHYS_INV_ATTRIBUTE6PHYS_INV_ATTRIBUTE6LOV query:$column$.phys_inv_attribute7PHYS_INV_ATTRIBUTE7PHYS_INV_ATTRIBUTE6LOV query:$column$.phys_inv_attribute8PHYS_INV_ATTRIBUTE8PHYS_INV_ATTRIBUTE6LOV query:$column$.phys_inv_attribute9PHYS_INV_ATTRIBUTE9PHYS_INV_ATTRIBUTE6LOV query:$column$.attribute_categoryATTRIBUTE_CATEGORYPHYS_INV_ATTRIBUTE7Default value:$column$.organization_codeORGANIZATION_CODEPHYS_INV_ATTRIBUTE7Default value:$column$.physical_inventory_namePHYSICAL_INVENTORY_NAMEPHYS_INV_ATTRIBUTE7LOV query:$column$.phys_inv_attribute1PHYS_INV_ATTRIBUTE1PHYS_INV_ATTRIBUTE7LOV query:$column$.phys_inv_attribute10PHYS_INV_ATTRIBUTE10PHYS_INV_ATTRIBUTE7LOV query:$column$.phys_inv_attribute11PHYS_INV_ATTRIBUTE11PHYS_INV_ATTRIBUTE7LOV query:$column$.phys_inv_attribute12PHYS_INV_ATTRIBUTE12PHYS_INV_ATTRIBUTE7LOV query:$column$.phys_inv_attribute13PHYS_INV_ATTRIBUTE13PHYS_INV_ATTRIBUTE7LOV query:$column$.phys_inv_attribute14PHYS_INV_ATTRIBUTE14PHYS_INV_ATTRIBUTE7LOV query:$column$.phys_inv_attribute15PHYS_INV_ATTRIBUTE15PHYS_INV_ATTRIBUTE7LOV query:$column$.phys_inv_attribute2PHYS_INV_ATTRIBUTE2PHYS_INV_ATTRIBUTE7LOV query:$column$.phys_inv_attribute3PHYS_INV_ATTRIBUTE3PHYS_INV_ATTRIBUTE7LOV query:$column$.phys_inv_attribute4PHYS_INV_ATTRIBUTE4PHYS_INV_ATTRIBUTE7LOV query:$column$.phys_inv_attribute5PHYS_INV_ATTRIBUTE5PHYS_INV_ATTRIBUTE7LOV query:$column$.phys_inv_attribute6PHYS_INV_ATTRIBUTE6PHYS_INV_ATTRIBUTE7LOV query:$column$.phys_inv_attribute7PHYS_INV_ATTRIBUTE7PHYS_INV_ATTRIBUTE7LOV query:$column$.phys_inv_attribute8PHYS_INV_ATTRIBUTE8PHYS_INV_ATTRIBUTE7LOV query:$column$.phys_inv_attribute9PHYS_INV_ATTRIBUTE9PHYS_INV_ATTRIBUTE7LOV query:$column$.attribute_categoryATTRIBUTE_CATEGORYPHYS_INV_ATTRIBUTE8Default value:$column$.organization_codeORGANIZATION_CODEPHYS_INV_ATTRIBUTE8Default value:$column$.physical_inventory_namePHYSICAL_INVENTORY_NAMEPHYS_INV_ATTRIBUTE8LOV query:$column$.phys_inv_attribute1PHYS_INV_ATTRIBUTE1PHYS_INV_ATTRIBUTE8LOV query:$column$.phys_inv_attribute10PHYS_INV_ATTRIBUTE10PHYS_INV_ATTRIBUTE8LOV query:$column$.phys_inv_attribute11PHYS_INV_ATTRIBUTE11PHYS_INV_ATTRIBUTE8LOV query:$column$.phys_inv_attribute12PHYS_INV_ATTRIBUTE12PHYS_INV_ATTRIBUTE8LOV query:$column$.phys_inv_attribute13PHYS_INV_ATTRIBUTE13PHYS_INV_ATTRIBUTE8LOV query:$column$.phys_inv_attribute14PHYS_INV_ATTRIBUTE14PHYS_INV_ATTRIBUTE8LOV query:$column$.phys_inv_attribute15PHYS_INV_ATTRIBUTE15PHYS_INV_ATTRIBUTE8LOV query:$column$.phys_inv_attribute2PHYS_INV_ATTRIBUTE2PHYS_INV_ATTRIBUTE8LOV query:$column$.phys_inv_attribute3PHYS_INV_ATTRIBUTE3PHYS_INV_ATTRIBUTE8LOV query:$column$.phys_inv_attribute4PHYS_INV_ATTRIBUTE4PHYS_INV_ATTRIBUTE8LOV query:$column$.phys_inv_attribute5PHYS_INV_ATTRIBUTE5PHYS_INV_ATTRIBUTE8LOV query:$column$.phys_inv_attribute6PHYS_INV_ATTRIBUTE6PHYS_INV_ATTRIBUTE8LOV query:$column$.phys_inv_attribute7PHYS_INV_ATTRIBUTE7PHYS_INV_ATTRIBUTE8LOV query:$column$.phys_inv_attribute8PHYS_INV_ATTRIBUTE8PHYS_INV_ATTRIBUTE8LOV query:$column$.phys_inv_attribute9PHYS_INV_ATTRIBUTE9PHYS_INV_ATTRIBUTE8LOV query:$column$.attribute_categoryATTRIBUTE_CATEGORYPHYS_INV_ATTRIBUTE9Default value:$column$.organization_codeORGANIZATION_CODEPHYS_INV_ATTRIBUTE9Default value:$column$.physical_inventory_namePHYSICAL_INVENTORY_NAMEPHYS_INV_ATTRIBUTE9LOV query:$column$.phys_inv_attribute1PHYS_INV_ATTRIBUTE1PHYS_INV_ATTRIBUTE9LOV query:$column$.phys_inv_attribute10PHYS_INV_ATTRIBUTE10PHYS_INV_ATTRIBUTE9LOV query:$column$.phys_inv_attribute11PHYS_INV_ATTRIBUTE11PHYS_INV_ATTRIBUTE9LOV query:$column$.phys_inv_attribute12PHYS_INV_ATTRIBUTE12PHYS_INV_ATTRIBUTE9LOV query:$column$.phys_inv_attribute13PHYS_INV_ATTRIBUTE13PHYS_INV_ATTRIBUTE9LOV query:$column$.phys_inv_attribute14PHYS_INV_ATTRIBUTE14PHYS_INV_ATTRIBUTE9LOV query:$column$.phys_inv_attribute15PHYS_INV_ATTRIBUTE15PHYS_INV_ATTRIBUTE9LOV query:$column$.phys_inv_attribute2PHYS_INV_ATTRIBUTE2PHYS_INV_ATTRIBUTE9LOV query:$column$.phys_inv_attribute3PHYS_INV_ATTRIBUTE3PHYS_INV_ATTRIBUTE9LOV query:$column$.phys_inv_attribute4PHYS_INV_ATTRIBUTE4PHYS_INV_ATTRIBUTE9LOV query:$column$.phys_inv_attribute5PHYS_INV_ATTRIBUTE5PHYS_INV_ATTRIBUTE9LOV query:$column$.phys_inv_attribute6PHYS_INV_ATTRIBUTE6PHYS_INV_ATTRIBUTE9LOV query:$column$.phys_inv_attribute7PHYS_INV_ATTRIBUTE7PHYS_INV_ATTRIBUTE9LOV query:$column$.phys_inv_attribute8PHYS_INV_ATTRIBUTE8PHYS_INV_ATTRIBUTE9LOV query:$column$.phys_inv_attribute9PHYS_INV_ATTRIBUTE9PHYS_INV_ATTRIBUTE9Default value:$column$.organization_codeORGANIZATION_CODEQUANTITY_TOLERANCE_MINUSDefault value:$column$.physical_inventory_namePHYSICAL_INVENTORY_NAMEQUANTITY_TOLERANCE_MINUSDefault value:$column$.organization_codeORGANIZATION_CODEQUANTITY_TOLERANCE_PLUSDefault value:$column$.physical_inventory_namePHYSICAL_INVENTORY_NAMEQUANTITY_TOLERANCE_PLUSDefault value:$flex$.Replace_Existing_SubinventoriesReplace Existing Subinventories|:p_replace_subinventories|REPLACE_SUBINVENTORIESDefault value:$column$.organization_codeORGANIZATION_CODESERIAL_COUNT_OPTIONDefault value:$column$.physical_inventory_namePHYSICAL_INVENTORY_NAMESERIAL_COUNT_OPTIONDefault value:$column$.organization_codeORGANIZATION_CODESERIAL_DETAIL_OPTIONDefault value:$column$.physical_inventory_namePHYSICAL_INVENTORY_NAMESERIAL_DETAIL_OPTIONLOV query:$column$.all_subinventoriesALL_SUBINVENTORIESSUBINVENTORYLOV query:$column$.organization_codeORGANIZATION_CODESUBINVENTORYDefault value:$column$.organization_codeORGANIZATION_CODEVALUE_TOLERANCE_MINUSDefault value:$column$.physical_inventory_namePHYSICAL_INVENTORY_NAMEVALUE_TOLERANCE_MINUSDefault value:$column$.organization_codeORGANIZATION_CODEVALUE_TOLERANCE_PLUSDefault value:$column$.physical_inventory_namePHYSICAL_INVENTORY_NAMEVALUE_TOLERANCE_PLUSValue to id query:$column$.subinventorySUBINVENTORYp_delete_subinventory