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所有活动的清单组织代码，不包括主组织，仅限于当前用户的组织访问视图。52ED22BD18F83ED1E0630100007F8FFDYselect
to_char(null) action_,
to_char(null) status_,
to_char(null) message_,
null modified_columns_,
mp.organization_code,
msi.secondary_inventory_name name,
msi.description,
mmsv.status_code status,
cg.cost_group default_cost_group,
xxen_util.meaning(msi.subinventory_type,'MTL_SUB_TYPE',700) type,
decode(msi.inventory_atp_code,1,xxen_util.meaning('Y','YES_NO',0)) include_in_atp,
decode(msi.reservable_type,1,xxen_util.meaning('Y','YES_NO',0)) allow_reservation,
decode(msi.availability_type,1,xxen_util.meaning('Y','YES_NO',0)) nettable,
decode(msi.quantity_tracked,1,xxen_util.meaning('Y','YES_NO',0)) quantity_tracked,
decode(msi.asset_inventory,1,xxen_util.meaning('Y','YES_NO',0)) asset_subinventory,
decode(msi.depreciable_flag,1,xxen_util.meaning('Y','YES_NO',0)) depreciable,
decode(msi.planning_level,1,xxen_util.meaning('Y','YES_NO',0)) enable_par_level_planning,
xxen_util.meaning(to_char(msi.locator_type),'MTL_LOCATION_CONTROL',700) locator_control,
mmsv_loc.status_code default_locator_status,
decode(msi.enable_locator_alias,'Y',xxen_util.meaning('Y','YES_NO',0)) enable_locator_alias,
decode(msi.enforce_alias_uniqueness,'Y',xxen_util.meaning('Y','YES_NO',0)) enforce_alias_uniqueness,
msi.picking_order,
msi.dropping_order,
case
when msi.subinventory_type=2 and trunc(msi.disable_date)=to_date('01-01-1700','dd-mm-yyyy') then null
when msi.subinventory_type=2 then msi.disable_date+300*365
else msi.disable_date
end inactive_on,
eeal.approval_list_name notify,
hl.location_code location,
msi.pick_uom_code picking_uom,
xxen_util.meaning(to_char(msi.default_count_type_code),'MTL_COUNT_TYPES',700) default_replenishment_count_type,
xxen_util.meaning(to_char(msi.source_type),'MTL_SOURCE_TYPES',700) source_type,
mp_src.organization_code source_organization,
msi.source_subinventory,
msi.preprocessing_lead_time pre_processing_lt,
msi.processing_lead_time processing_lt,
msi.postprocessing_lead_time post_processing_lt,
gcck_mat.concatenated_segments material,
gcck_op.concatenated_segments outside_processing,
gcck_mo.concatenated_segments material_overhead,
gcck_oh.concatenated_segments overhead,
gcck_res.concatenated_segments resource_account,
gcck_exp.concatenated_segments expense,
gcck_enc.concatenated_segments encumbrance,
decode(msi.lpn_controlled_flag,1,xxen_util.meaning('Y','YES_NO',0)) lpn_controlled,
decode(msi.cartonization_flag,1,xxen_util.meaning('Y','YES_NO',0)) enable_cartonization,
decode(msi.enable_bulk_pick,'Y',xxen_util.meaning('Y','YES_NO',0)) enable_bulk_pick,
decode(msi.enable_opp_cyc_count,'Y',xxen_util.meaning('Y','YES_NO',0)) enable_opportunistic_cycle_count,
mcch.cycle_count_header_name opportunistic_cycle_count_header,
msi.opp_cyc_count_quantity opportunistic_cycle_count_trigger_quantity,
msi.opp_cyc_count_days opportunistic_cycle_count_days_threshold,
xxen_util.display_flexfield_context(401,'MTL_SECONDARY_INVENTORIES',msi.attribute_category) attribute_category,
xxen_util.display_flexfield_value(401,'MTL_SECONDARY_INVENTORIES',msi.attribute_category,'ATTRIBUTE1',msi.rowid,msi.attribute1) sub_attribute1,
xxen_util.display_flexfield_value(401,'MTL_SECONDARY_INVENTORIES',msi.attribute_category,'ATTRIBUTE2',msi.rowid,msi.attribute2) sub_attribute2,
xxen_util.display_flexfield_value(401,'MTL_SECONDARY_INVENTORIES',msi.attribute_category,'ATTRIBUTE3',msi.rowid,msi.attribute3) sub_attribute3,
xxen_util.display_flexfield_value(401,'MTL_SECONDARY_INVENTORIES',msi.attribute_category,'ATTRIBUTE4',msi.rowid,msi.attribute4) sub_attribute4,
xxen_util.display_flexfield_value(401,'MTL_SECONDARY_INVENTORIES',msi.attribute_category,'ATTRIBUTE5',msi.rowid,msi.attribute5) sub_attribute5,
xxen_util.display_flexfield_value(401,'MTL_SECONDARY_INVENTORIES',msi.attribute_category,'ATTRIBUTE6',msi.rowid,msi.attribute6) sub_attribute6,
xxen_util.display_flexfield_value(401,'MTL_SECONDARY_INVENTORIES',msi.attribute_category,'ATTRIBUTE7',msi.rowid,msi.attribute7) sub_attribute7,
xxen_util.display_flexfield_value(401,'MTL_SECONDARY_INVENTORIES',msi.attribute_category,'ATTRIBUTE8',msi.rowid,msi.attribute8) sub_attribute8,
xxen_util.display_flexfield_value(401,'MTL_SECONDARY_INVENTORIES',msi.attribute_category,'ATTRIBUTE9',msi.rowid,msi.attribute9) sub_attribute9,
xxen_util.display_flexfield_value(401,'MTL_SECONDARY_INVENTORIES',msi.attribute_category,'ATTRIBUTE10',msi.rowid,msi.attribute10) sub_attribute10,
xxen_util.display_flexfield_value(401,'MTL_SECONDARY_INVENTORIES',msi.attribute_category,'ATTRIBUTE11',msi.rowid,msi.attribute11) sub_attribute11,
xxen_util.display_flexfield_value(401,'MTL_SECONDARY_INVENTORIES',msi.attribute_category,'ATTRIBUTE12',msi.rowid,msi.attribute12) sub_attribute12,
xxen_util.display_flexfield_value(401,'MTL_SECONDARY_INVENTORIES',msi.attribute_category,'ATTRIBUTE13',msi.rowid,msi.attribute13) sub_attribute13,
xxen_util.display_flexfield_value(401,'MTL_SECONDARY_INVENTORIES',msi.attribute_category,'ATTRIBUTE14',msi.rowid,msi.attribute14) sub_attribute14,
xxen_util.display_flexfield_value(401,'MTL_SECONDARY_INVENTORIES',msi.attribute_category,'ATTRIBUTE15',msi.rowid,msi.attribute15) sub_attribute15,
to_number(null) upload_row
from
mtl_secondary_inventories msi,
mtl_parameters mp,
mtl_material_statuses_vl mmsv,
cst_cost_groups cg,
mtl_material_statuses_vl mmsv_loc,
eng_ecn_approval_lists eeal,
hr_locations hl,
mtl_parameters mp_src,
mtl_cycle_count_headers mcch,
gl_code_combinations_kfv gcck_mat,
gl_code_combinations_kfv gcck_op,
gl_code_combinations_kfv gcck_mo,
gl_code_combinations_kfv gcck_oh,
gl_code_combinations_kfv gcck_res,
gl_code_combinations_kfv gcck_exp,
gl_code_combinations_kfv gcck_enc
where
1=1 and
msi.secondary_inventory_name<>'AX_INTRANS' and
mp.organization_id=msi.organization_id and
mp.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) and
mmsv.status_id(+)=msi.status_id and
cg.cost_group_id(+)=msi.default_cost_group_id and
mmsv_loc.status_id(+)=msi.default_loc_status_id and
eeal.approval_list_id(+)=msi.notify_list_id and
hl.location_id(+)=msi.location_id and
mp_src.organization_id(+)=msi.source_organization_id and
mcch.cycle_count_header_id(+)=msi.opp_cyc_count_header_id and
gcck_mat.code_combination_id(+)=msi.material_account and
gcck_op.code_combination_id(+)=msi.outside_processing_account and
gcck_mo.code_combination_id(+)=msi.material_overhead_account and
gcck_oh.code_combination_id(+)=msi.overhead_account and
gcck_res.code_combination_id(+)=msi.resource_account and
gcck_exp.code_combination_id(+)=msi.expense_account and
gcck_enc.code_combination_id(+)=msi.encumbrance_accountInitial version: subinventory create/update via MTL_SECONDARY_INVENTORIES_PKG table handler. Cross-org. Mirrors the INVSDSUB form (defaults from mtl_parameters, KFF detail-only accounts, ERES block on status change, cost-group strict mode with account matching, locator-type WMS rules).UAxxen_inv_upload.upload_subinventoryUSINV Subinventory UploadCreate and update Subinventories across accessible inventory organizations.
Accounts and Default Cost Group are tightly linked; the behavior depends on the organization's configuration:
- WMS=No + Standard cost method (with no on-hand or transaction history): the accounts drive the Cost Group. Enter any valid GL detail accounts and the upload auto-resolves the Cost Group — switching to an existing Cost Group whose 7 accounts match, or creating a new one when none matches. The Cost Group action taken is reported in the success message.
- WMS=Yes (any cost method): the Cost Group drives the accounts. Selecting a Cost Group sets all 7 accounts (Material, Outside Processing, Material Overhead, Overhead, Resource, Expense, Encumbrance) to its assigned values. Changing the Cost Group on an existing Subinventory automatically switches all 7 accounts, including clearing accounts that are NULL on the new Cost Group.
- WMS=No + (non-Standard cost method OR the subinventory has on-hand/transaction history): the Cost Group is fixed (existing value on Update, organization default on Create) and the accounts follow it.
All account LOVs restrict to enabled detail (non-summary) GL accounts in the organization's chart of accounts. The Cost Group LOV likewise restricts to selectable Cost Groups per the rules above.
Material Status changes require Oracle's electronic signature workflow when ERES is enabled — those changes must be made via the Subinventories form to preserve the e-signature audit trail.
There is no Delete option — Subinventories can only be inactivated (set Inactive On to a past date).EnginaticsR12 onlyUpload1=11101=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 Mode2201=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_codeUSOrganization Code3301=1msi.secondary_inventory_name=:p_subinventoryLOV customYselect
msi.secondary_inventory_name value,
msi.description
from
mtl_secondary_inventories msi,
mtl_parameters mp
where
msi.organization_id=mp.organization_id and
mp.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) and
(:$flex$.organization_code is null or xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y')
order by
valueUSSubinventory4351=1msi.status_id=:p_statusLOV customYselect
mmsv.status_id id,
mmsv.status_code value,
mmsv.status_code description
from
mtl_material_statuses_vl mmsv
where
mmsv.zone_control=1 and
mmsv.enabled_flag=1
order by
mmsv.status_codeUSStatus5401=1msi.default_cost_group_id=:p_default_cost_groupLOV customYselect
cg.cost_group_id id,
cg.cost_group value,
null description
from
cst_cost_groups cg
where
nvl(cg.disable_date,sysdate+1)>sysdate
order by
valueUSDefault Cost Group6501=1msi.subinventory_type=:p_typeLOV customYselect
to_number(ml.lookup_code) id,
ml.meaning value,
ml.description
from
mfg_lookups ml
where
ml.lookup_type='MTL_SUB_TYPE' and
ml.enabled_flag='Y'
order by
ml.lookup_codeUSType7601=1msi.inventory_atp_code=:p_include_in_atpLOV customYselect
to_number(ml.lookup_code) id,
ml.meaning value,
null description
from
mfg_lookups ml
where
ml.lookup_type='SYS_YES_NO' and
ml.enabled_flag='Y'
order by
ml.lookup_codeUSInclude in ATP8701=1msi.reservable_type=:p_allow_reservationLOV customYselect
to_number(ml.lookup_code) id,
ml.meaning value,
null description
from
mfg_lookups ml
where
ml.lookup_type='SYS_YES_NO' and
ml.enabled_flag='Y'
order by
ml.lookup_codeUSAllow Reservation9801=1msi.availability_type=:p_nettableLOV customYselect
to_number(ml.lookup_code) id,
ml.meaning value,
null description
from
mfg_lookups ml
where
ml.lookup_type='SYS_YES_NO' and
ml.enabled_flag='Y'
order by
ml.lookup_codeUSNettable10901=1msi.quantity_tracked=:p_quantity_trackedLOV customYselect
to_number(ml.lookup_code) id,
ml.meaning value,
null description
from
mfg_lookups ml
where
ml.lookup_type='SYS_YES_NO' and
ml.enabled_flag='Y'
order by
ml.lookup_codeUSQuantity Tracked111001=1msi.asset_inventory=:p_asset_subinventoryLOV customYselect
to_number(ml.lookup_code) id,
ml.meaning value,
null description
from
mfg_lookups ml
where
ml.lookup_type='SYS_YES_NO' and
ml.enabled_flag='Y'
order by
ml.lookup_codeUSAsset Subinventory121101=1msi.locator_type=:p_locator_controlLOV customYselect
to_number(ml.lookup_code) id,
ml.meaning value,
ml.description
from
mfg_lookups ml
where
ml.lookup_type='MTL_LOCATION_CONTROL' and
ml.enabled_flag='Y' and
ml.lookup_code in ('1','2','3','5')
order by
ml.lookup_codeUSLocator Control:$flex$.organization_codeOrganization CodeSubinventory1ACTION_Charvarchar22STATUS_Charvarchar23MESSAGE_Charvarchar24MODIFIED_COLUMNS_Charvarchar2Y5ORGANIZATION_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 mp.organization_id id, mp.organization_code value from mtl_parameters mpInventory organization for the subinventory. Required. Cannot be changed for an existing subinventory.YY6NAMECharvarchar2Subinventory name (max 10 characters). Required. Cannot be changed for an existing subinventory.YY7DESCRIPTIONCharvarchar28STATUSLOV customvarchar2Yselect
mmsv.status_id id,
mmsv.status_code value,
mmsv.status_code description
from
mtl_material_statuses_vl mmsv
where
mmsv.enabled_flag=1 and
(
(xxen_util.lookup_code(:$column$.type,'MTL_SUB_TYPE',700)='2' and mmsv.status_id=1)
or
(nvl(xxen_util.lookup_code(:$column$.type,'MTL_SUB_TYPE',700),'1')<>'2' and mmsv.zone_control=1)
)
order by
mmsv.status_codeActiveMaterial Status for this subinventory. For Receiving subinventories: only Active is permitted (the form forces Active for Receiving; the backend V_RCV01/V_RCV02 rules reject non-Active). For Storage subinventories: restricted to zone-control enabled statuses. When Oracle electronic signature workflow (ERES) is enabled for this instance, status changes on existing subinventories must be made via the Subinventories form to preserve the e-signature audit trail.Y9DEFAULT_COST_GROUPLOV customvarchar2Yselect
cg.cost_group_id id,
cg.cost_group value,
null description
from
cst_cost_groups cg,
mtl_parameters mp
where
mp.organization_code=:$column$.organization_code and
(
(mp.wms_enabled_flag='N' and
mp.primary_cost_method=1 and
exists (select null from cst_cost_group_accounts cga where cga.organization_id=mp.organization_id and cg.cost_group_id=cga.cost_group_id and nvl(cg.disable_date,sysdate+1) > sysdate)
) or
(mp.wms_enabled_flag='N' and
mp.primary_cost_method<>1 and
cg.cost_group_id = nvl((select msi.default_cost_group_id from mtl_secondary_inventories msi where msi.organization_id=mp.organization_id and msi.secondary_inventory_name=:$column$.name),mp.default_cost_group_id)
) or
(mp.wms_enabled_flag='Y' and
(mp.primary_cost_method<>1 or
exists (select 'Y' from mtl_onhand_quantities_detail moqd where moqd.organization_id=mp.organization_id and moqd.subinventory_code=:$column$.name and rownum<=1) or
exists (select 'Y' from mtl_material_transactions mmt where mmt.organization_id=mp.organization_id and mmt.subinventory_code=:$column$.name and rownum<=1)
) and
exists
(select
'x'
from
cst_cost_group_accounts cga,
mtl_secondary_inventories msi
where
cg.cost_group_id=cga.cost_group_id and
mp.organization_id=cga.organization_id and
mp.organization_id=msi.organization_id and
msi.secondary_inventory_name=:$column$.name and
nvl(cga.material_account,1)=nvl(msi.material_account,1) and
nvl(cga.outside_processing_account,1)=nvl(msi.outside_processing_account,1) and
nvl(cga.overhead_account,1)=nvl(msi.overhead_account,1) and
nvl(cga.material_overhead_account,1)=nvl(msi.material_overhead_account,1) and
nvl(cga.resource_account,1)=nvl(msi.resource_account,1) and
nvl(cg.disable_date,sysdate+1) > sysdate
union
select
'x'
from
mtl_secondary_inventories msi
where
mp.default_cost_group_id=cg.cost_group_id and
mp.default_cost_group_id=1 and
mp.organization_id=msi.organization_id and
msi.secondary_inventory_name=:$column$.name and
nvl(mp.material_account,1)=nvl(msi.material_account,1) and
nvl(mp.outside_processing_account,1)=nvl(msi.outside_processing_account,1) and
nvl(mp.overhead_account,1)=nvl(msi.overhead_account,1) and
nvl(mp.material_overhead_account,1)=nvl(msi.material_overhead_account,1) and
nvl(mp.resource_account,1)=nvl(msi.resource_account,1) and
nvl(cg.disable_date,sysdate+1) > sysdate
union
select
'x'
from
cst_cost_group_accounts cga
where
cg.cost_group_id=cga.cost_group_id and
mp.organization_id=cga.organization_id and
nvl(cga.material_account,1)=nvl(mp.material_account,1) and
nvl(cga.outside_processing_account,1)=nvl(mp.outside_processing_account,1) and
nvl(cga.overhead_account,1)=nvl(mp.overhead_account,1) and
nvl(cga.material_overhead_account,1)=nvl(mp.material_overhead_account,1) and
nvl(cga.resource_account,1)=nvl(mp.resource_account,1) and
nvl(cg.disable_date,sysdate+1) > sysdate and
not exists (select null from mtl_secondary_inventories msi where mp.organization_id=msi.organization_id and msi.secondary_inventory_name=:$column$.name)
)
) or
(mp.wms_enabled_flag='Y' and
mp.primary_cost_method=1 and
not exists (select 'Y' from mtl_onhand_quantities_detail moqd where moqd.organization_id=mp.organization_id and moqd.subinventory_code=:$column$.name and rownum<=1) and
not exists (select 'Y' from mtl_material_transactions mmt where mmt.organization_id=mp.organization_id and mmt.subinventory_code=:$column$.name and rownum<=1) and
exists
(select
null
from
cst_cost_group_accounts cga
where
cga.organization_id=mp.organization_id and
cg.cost_group_id=cga.cost_group_id and
nvl(cg.disable_date,sysdate+1) > sysdate
)
)
)select
cg.cost_group
from
mtl_parameters mp,
cst_cost_groups cg
where
mp.organization_code=:$column$.organization_code and
cg.cost_group_id=mp.default_cost_group_id and
nvl(cg.disable_date,sysdate+1) > sysdate and
(mp.wms_enabled_flag='N' or
(mp.wms_enabled_flag='Y' and
mp.primary_cost_method=1 and
not exists (select 'Y' from mtl_onhand_quantities_detail moqd where moqd.organization_id=mp.organization_id and moqd.subinventory_code=:$column$.name and rownum<=1) and
not exists (select 'Y' from mtl_material_transactions mmt where mmt.organization_id=mp.organization_id and mmt.subinventory_code=:$column$.name and rownum<=1)
) or
exists
(select
null
from
cst_cost_group_accounts cga
where
cg.cost_group_id=cga.cost_group_id and
mp.organization_id=cga.organization_id and
nvl(cga.material_account,1)=nvl(mp.material_account,1) and
nvl(cga.outside_processing_account,1)=nvl(mp.outside_processing_account,1) and
nvl(cga.overhead_account,1)=nvl(mp.overhead_account,1) and
nvl(cga.material_overhead_account,1)=nvl(mp.material_overhead_account,1) and
nvl(cga.resource_account,1)=nvl(mp.resource_account,1)
)
)Default Cost Group for this subinventory. The selectable values depend on WMS Enabled, the organization cost method, and whether the subinventory has onhand or transaction history. WMS=No: only the current cost group (existing sub) or the organization default (new sub). WMS=Yes + (cost method <> Standard or onhand or history exists): strict mode — cost group must match the subinventory's 5 elemental accounts (Material, Outside Processing, Overhead, Material Overhead, Resource); Common Cost Group (1) is allowed when it is the organization default and its accounts match. WMS=Yes + cost method = Standard + no onhand + no history: any enabled cost group in the organization. The default value follows the same rules.10TYPELOV customvarchar2Yselect
to_number(ml.lookup_code) id,
ml.meaning value,
ml.description
from
mfg_lookups ml
where
ml.lookup_type='MTL_SUB_TYPE' and
ml.enabled_flag='Y'
order by
ml.lookup_codexxen_util.meaning('1','MTL_SUB_TYPE',700)Subinventory type. Storage subinventories hold on-hand inventory; Receiving subinventories are linked to a receiving location for inbound goods. Cannot be changed once on-hand or transaction history exists for the subinventory.Y11INCLUDE_IN_ATPLOV customvarchar2Yselect
ml.lookup_code id,
ml.meaning value,
null description
from
mfg_lookups ml
where
ml.lookup_type='SYS_YES_NO' and
ml.enabled_flag='Y' and
ml.lookup_code=(select to_char(mmsv.inventory_atp_code) from mtl_material_statuses_vl mmsv where mmsv.status_code=:$column$.status)
order by
ml.lookup_codeselect xxen_util.meaning(to_char(mmsv.inventory_atp_code),'SYS_YES_NO',700)
from mtl_material_statuses_vl mmsv
where mmsv.status_code=:$column$.statusInformational only. This flag is always derived in the backend from the chosen Material Status (inventory_atp_code). The upload preserves the existing column for visibility but ignores any user-entered value — the effective value comes from the status. Restricted in the LOV to the corresponding value of the selected Status.12ALLOW_RESERVATIONLOV customvarchar2Yselect
ml.lookup_code id,
ml.meaning value,
null description
from
mfg_lookups ml
where
ml.lookup_type='SYS_YES_NO' and
ml.enabled_flag='Y' and
ml.lookup_code=(select to_char(mmsv.reservable_type) from mtl_material_statuses_vl mmsv where mmsv.status_code=:$column$.status)
order by
ml.lookup_codeselect xxen_util.meaning(to_char(mmsv.reservable_type),'SYS_YES_NO',700)
from mtl_material_statuses_vl mmsv
where mmsv.status_code=:$column$.statusInformational only. This flag is always derived in the backend from the chosen Material Status (reservable_type). The upload preserves the existing column for visibility but ignores any user-entered value — the effective value comes from the status. Restricted in the LOV to the corresponding value of the selected Status.13NETTABLELOV customvarchar2Yselect
ml.lookup_code id,
ml.meaning value,
null description
from
mfg_lookups ml
where
ml.lookup_type='SYS_YES_NO' and
ml.enabled_flag='Y' and
ml.lookup_code=(select to_char(mmsv.availability_type) from mtl_material_statuses_vl mmsv where mmsv.status_code=:$column$.status)
order by
ml.lookup_codeselect xxen_util.meaning(to_char(mmsv.availability_type),'SYS_YES_NO',700)
from mtl_material_statuses_vl mmsv
where mmsv.status_code=:$column$.statusInformational only. This flag is always derived in the backend from the chosen Material Status (availability_type). The upload preserves the existing column for visibility but ignores any user-entered value — the effective value comes from the status. Restricted in the LOV to the corresponding value of the selected Status.14QUANTITY_TRACKEDLOV customvarchar2Yselect
ml.lookup_code id,
ml.meaning value,
null description
from
mfg_lookups ml
where
ml.lookup_type='SYS_YES_NO' and
ml.enabled_flag='Y' and
(
ml.lookup_code='1' and nvl(xxen_util.lookup_code(:$column$.type,'MTL_SUB_TYPE',700),'1')<>'2'
or ml.lookup_code='2' and (
xxen_util.lookup_code(:$column$.type,'MTL_SUB_TYPE',700)='2'
or exists (select null from mtl_material_statuses_vl mmsv where mmsv.status_code=:$column$.status and mmsv.inventory_atp_code=2 and mmsv.reservable_type=2 and mmsv.availability_type=2)
)
)
order by
ml.lookup_codeselect xxen_util.meaning('1','SYS_YES_NO',700)
from dual
where not exists (select null from mtl_parameters mp, mtl_secondary_inventories msi where mp.organization_id=msi.organization_id and mp.organization_code=:$column$.organization_code and msi.secondary_inventory_name=:$column$.name)
and nvl(xxen_util.lookup_code(:$column$.type,'MTL_SUB_TYPE',700),'1')<>'2'Track on-hand quantity in this subinventory. For Receiving subinventories the LOV restricts to No only (the form forces No for Receiving). For Storage subinventories the LOV restricts No to cases where the chosen Material Status has ATP, Reservation, and Nettable all set to No — a status that enables any of those three implies the subinventory must be quantity-tracked.15ASSET_SUBINVENTORYLOV customvarchar2Yselect
ml.lookup_code id,
ml.meaning value,
null description
from
mfg_lookups ml
where
ml.lookup_type='SYS_YES_NO' and
ml.enabled_flag='Y' and
(
ml.lookup_code='1' and nvl(xxen_util.lookup_code(:$column$.type,'MTL_SUB_TYPE',700),'1')<>'2' and nvl(xxen_util.lookup_code(:$column$.quantity_tracked,'SYS_YES_NO',700),'1')='1'
or ml.lookup_code='2'
)
order by
ml.lookup_codeselect xxen_util.meaning('1','SYS_YES_NO',700)
from dual
where not exists (select null from mtl_parameters mp, mtl_secondary_inventories msi where mp.organization_id=msi.organization_id and mp.organization_code=:$column$.organization_code and msi.secondary_inventory_name=:$column$.name)
and nvl(xxen_util.lookup_code(:$column$.type,'MTL_SUB_TYPE',700),'1')<>'2'This subinventory holds asset items (capitalized). Asset subinventories use the Material/Material Overhead/Overhead/Resource/Outside Processing accounts; non-asset (expense) subinventories use the Expense account. Restricted to No when Subinventory Type is Receiving (form forces No) OR when Quantity Tracked is No.16DEPRECIABLELOV customvarchar2Yselect
ml.lookup_code id,
ml.meaning value,
null description
from
mfg_lookups ml
where
ml.lookup_type='SYS_YES_NO' and
ml.enabled_flag='Y' and
(
(ml.lookup_code='1'
and nvl(xxen_util.lookup_code(:$column$.type,'MTL_SUB_TYPE',700),'1')<>'2'
and nvl(xxen_util.lookup_code(:$column$.quantity_tracked,'SYS_YES_NO',700),'1')='1')
or ml.lookup_code='2'
)
order by
ml.lookup_codeThis subinventory holds items that depreciate over time. Restricted to No when Subinventory Type is Receiving (form forces No) OR when Quantity Tracked is No.17ENABLE_PAR_LEVEL_PLANNINGLOV customvarchar2Yselect
ml.lookup_code id,
ml.meaning value,
null description
from
mfg_lookups ml
where
ml.lookup_type='SYS_YES_NO' and
ml.enabled_flag='Y' and
(
ml.lookup_code='1' and nvl(xxen_util.lookup_code(:$column$.type,'MTL_SUB_TYPE',700),'1')<>'2'
or ml.lookup_code='2'
)
order by
ml.lookup_codeEnable PAR (Periodic Automatic Replenishment) level planning for this subinventory. Restricted to No when Subinventory Type is Receiving (form forces No).18LOCATOR_CONTROLLOV customvarchar2Yselect
to_number(ml.lookup_code) id,
ml.meaning value,
ml.description
from
mfg_lookups ml
where
ml.lookup_type='MTL_LOCATION_CONTROL' and
ml.enabled_flag='Y' and
ml.lookup_code in ('1','2','3','5') and
not exists (
select null from mtl_parameters mp
where mp.organization_code=:$column$.organization_code and
mp.wms_enabled_flag='Y' and
(
ml.lookup_code='5'
or (ml.lookup_code='1' and mp.stock_locator_control_code in (1,4))
)
)
order by
ml.lookup_codeselect xxen_util.meaning(
case
when mp.stock_locator_control_code in (2,3) then to_char(mp.stock_locator_control_code)
when nvl(mp.wms_enabled_flag,'N')<>'Y' then '1'
end,
'MTL_LOCATION_CONTROL', 700)
from mtl_parameters mp
where mp.organization_code=:$column$.organization_code
and not exists (select null from mtl_secondary_inventories msi where msi.organization_id=mp.organization_id and msi.secondary_inventory_name=:$column$.name)Locator control level for this subinventory. None = no locators; Prespecified = locators must be predefined; Dynamic = locators created on the fly; Determined at item level = depends on item setup. On a new subinventory this column defaults from the organization's Stock Locator Control: for Prespecified or Dynamic the default matches the organization; for None or Determined-at-subinventory-level in a non-WMS org the default is None (matching the form's initial state); for None or Determined-at-subinventory-level in a WMS-enabled org there is no safe default and the user must pick (Prespecified or Dynamic — None and Determined-at-item-level are not permitted). The LOV likewise excludes values that would violate these WMS rules.19DEFAULT_LOCATOR_STATUSLOV customvarchar2Yselect
mmsv.status_id id,
mmsv.status_code value,
mmsv.status_code description
from
mtl_material_statuses_vl mmsv
where
mmsv.locator_control=1 and
mmsv.enabled_flag=1 and
(nvl(xxen_util.lookup_code(:$column$.type,'MTL_SUB_TYPE',700),'1')<>'2' or mmsv.status_id=1) and
nvl(xxen_util.lookup_code(:$column$.locator_control,'MTL_LOCATION_CONTROL',700),
(select mp.stock_locator_control_code from mtl_parameters mp where mp.organization_code=:$column$.organization_code)
)<>1
order by
mmsv.status_codeselect mmsv.status_code
from mtl_material_statuses_vl mmsv
where mmsv.status_id=1
and nvl(xxen_util.lookup_code(:$column$.locator_control,'MTL_LOCATION_CONTROL',700),
(select mp.stock_locator_control_code from mtl_parameters mp where mp.organization_code=:$column$.organization_code)
)<>1Default Material Status applied to newly created locators in this subinventory. Defaults to Active when the effective Locator Control (row-level, falling back to the organization-level default) is not None.20ENABLE_LOCATOR_ALIASLOV customvarchar2Yselect
fl.lookup_code id,
fl.meaning value,
null description
from
fnd_lookups fl
where
fl.lookup_type='YES_NO' and
fl.enabled_flag='Y' and
(
fl.lookup_code='N' or
nvl(xxen_util.lookup_code(:$column$.locator_control,'MTL_LOCATION_CONTROL',700),
(select mp.stock_locator_control_code from mtl_parameters mp where mp.organization_code=:$column$.organization_code)
) not in (1,4)
)
order by
fl.lookup_codeEnable locator alias entry (shorthand names) for locators in this subinventory. Restricted to No when the effective Locator Control (user-supplied value, falling back to the organization-level default when blank) is None (1) or Determined at organization level (4) — neither case has locators to alias at the subinventory level.21ENFORCE_ALIAS_UNIQUENESSLOV customvarchar2Yselect
fl.lookup_code id,
fl.meaning value,
null description
from
fnd_lookups fl
where
fl.lookup_type='YES_NO' and
fl.enabled_flag='Y' and
(
fl.lookup_code='N' or
nvl(xxen_util.lookup_code(:$column$.enable_locator_alias,'YES_NO',0),'N')='Y'
)
order by
fl.lookup_codeEnforce uniqueness of locator aliases within this subinventory. Restricted to No when Enable Locator Alias is No.22PICKING_ORDERNumbernumberOrder in which this subinventory is suggested for picking transactions (lower = higher priority).23DROPPING_ORDERNumbernumberOrder in which this subinventory is suggested for putaway/drop transactions (lower = higher priority).24INACTIVE_ONDatedateDate from which this subinventory is inactive. Must be greater than or equal to yesterday. For Receiving subinventories, cannot be more than 300 years in the future.25NOTIFYLOV customvarchar2Yselect
eeal.approval_list_id id,
eeal.approval_list_name value,
null description
from
eng_ecn_approval_lists eeal
order by
eeal.approval_list_nameNotification (ECN Approval) list to notify when activity occurs in this subinventory.26LOCATIONLOV customvarchar2YYselect
hl.location_id id,
hl.location_code value,
hl.country||', '||hl.address_line_1 description
from
hr_locations hl,
mtl_parameters mp
where
mp.organization_code=:$column$.organization_code and
(
(xxen_util.lookup_code(:$column$.type,'MTL_SUB_TYPE',700)='2' and hl.inventory_organization_id=mp.organization_id and hl.receiving_site_flag='Y' and (hl.inactive_date is null or hl.inactive_date>sysdate))
or
nvl(xxen_util.lookup_code(:$column$.type,'MTL_SUB_TYPE',700),'1')='1'
)
order by
hl.country, hl.address_line_1Physical location of this subinventory. For Receiving subinventories (Type = Receiving), restricted to receiving sites of the same organization. For Storage subinventories, any HR Location.27PICKING_UOMLOV customvarchar2Yselect distinct
muomv.uom_code id,
muomv.uom_code value,
muomv.unit_of_measure_tl description
from
mtl_units_of_measure_vl muomv
where
nvl(muomv.disable_date,sysdate+1)>sysdate and
nvl(xxen_util.lookup_code(:$column$.type,'MTL_SUB_TYPE',700),'1')<>'2'
order by
muomv.unit_of_measure_tlDefault Unit of Measure for picking operations in this subinventory.28DEFAULT_REPLENISHMENT_COUNT_TYPELOV customvarchar2Yselect
to_number(ml.lookup_code) id,
ml.meaning value,
ml.description
from
mfg_lookups ml
where
ml.lookup_type='MTL_COUNT_TYPES' and
ml.enabled_flag='Y' and
trunc(nvl(ml.end_date_active,sysdate+1))>trunc(sysdate) and
trunc(nvl(ml.start_date_active,sysdate-1))<=trunc(sysdate) and
(
ml.lookup_code='2'
or
(
nvl(xxen_util.lookup_code(:$column$.type,'MTL_SUB_TYPE',700),'1')<>'2' and
(
(:$column$.quantity_tracked is null and :$column$.enable_par_level_planning is null and ml.lookup_code in ('1','3'))
or
(:$column$.quantity_tracked is null and :$column$.enable_par_level_planning is not null and ml.lookup_code in ('1','4'))
or
(:$column$.quantity_tracked is not null and :$column$.enable_par_level_planning is null and ml.lookup_code='3')
or
(:$column$.quantity_tracked is not null and :$column$.enable_par_level_planning is not null and ml.lookup_code='4')
)
)
)
order by
ml.meaningselect xxen_util.meaning('2','MTL_COUNT_TYPES',700) from dualDefault Replenishment Count Type. Optional — pre-filled in the Excel template with Order Quantity, but the user can clear it. If left blank on Create, the backend defaults to Order Quantity. For Receiving subinventories the form forces Order Quantity (the only valid option). For Storage subinventories the valid options depend on Quantity Tracked × Enable PAR Level Planning: when PAR is enabled the choices include Order PAR (instead of Order Maximum); when Quantity Tracked is enabled Onhand Quantity is no longer offered.29SOURCE_TYPELOV customvarchar2Yselect
to_number(ml.lookup_code) id,
ml.meaning value,
ml.description
from
mfg_lookups ml
where
ml.lookup_type='MTL_SOURCE_TYPES' and
ml.enabled_flag='Y' and
nvl(xxen_util.lookup_code(:$column$.type,'MTL_SUB_TYPE',700),'1')<>'2'
order by
ml.lookup_codeReplenishment source type. Inventory = replenish from another inventory organization; Supplier = replenish from a supplier; Subinventory = same-organization self-sourcing from another subinventory.30SOURCE_ORGANIZATIONLOV customvarchar2Yselect
ood.organization_id id,
ood.organization_code value,
ood.organization_name description
from
org_organization_definitions ood,
mtl_parameters mp
where
mp.organization_code=:$column$.organization_code and
nvl(ood.disable_date,sysdate+1)>sysdate and
nvl(ood.user_definition_enable_date,sysdate)<=sysdate and
(
(xxen_util.lookup_code(:$column$.source_type,'MTL_SOURCE_TYPES',700)=1 and
(ood.organization_id in (select miop.from_organization_id from mtl_interorg_parameters miop where miop.to_organization_id=mp.organization_id)
or ood.organization_id=mp.organization_id))
or
(xxen_util.lookup_code(:$column$.source_type,'MTL_SOURCE_TYPES',700)=3 and ood.organization_id=mp.organization_id)
)
order by
ood.organization_codeselect :$column$.organization_code
from dual
where xxen_util.lookup_code(:$column$.source_type,'MTL_SOURCE_TYPES',700)=3Source inventory organization for replenishment. Required when Source Type is Inventory (cross-org) or Subinventory (same-org). For Source Type = Inventory: any valid inter-organization source for this subinventory's organization, plus the subinventory's own organization. For Source Type = Subinventory: must be the same organization as this subinventory — the form auto-defaults and locks the value to the current organization; the upload mirrors this via the LOV restriction and the DEFAULT_VALUE.31SOURCE_SUBINVENTORYLOV customvarchar2Yselect
msi.secondary_inventory_name value,
msi.description
from
mtl_secondary_inventories msi,
mtl_parameters mp
where
mp.organization_code=:$column$.source_organization and
msi.organization_id=mp.organization_id and
msi.quantity_tracked=1 and
xxen_util.lookup_code(:$column$.source_type,'MTL_SOURCE_TYPES',700)=3
order by
msi.secondary_inventory_nameSource subinventory for replenishment. Returns values only when Source Type is Subinventory (same-org self-sourcing). Restricted to quantity-tracked subinventories of the chosen Source Organization.32PRE_PROCESSING_LTNumbernumberPre-Processing lead time in days. Must be greater than or equal to 0.33PROCESSING_LTNumbernumberProcessing lead time in days. Must be greater than or equal to 0.34POST_PROCESSING_LTNumbernumberPost-Processing lead time in days. Must be greater than or equal to 0.35MATERIALLOV customvarchar2YYselect
gcck.code_combination_id id,
gcck.concatenated_segments value,
gcck.description
from
gl_code_combinations_kfv gcck,
mtl_parameters mp,
org_organization_definitions ood
where
mp.organization_code=:$column$.organization_code and
ood.organization_id=mp.organization_id and
gcck.chart_of_accounts_id=ood.chart_of_accounts_id and
gcck.summary_flag='N' and
gcck.enabled_flag='Y' and
gcck.detail_posting_allowed='Y' and
(
((mp.wms_enabled_flag='Y' or
mp.primary_cost_method<>1 or
exists (select 'Y' from mtl_onhand_quantities_detail moqd where moqd.organization_id=mp.organization_id and moqd.subinventory_code=:$column$.name) or
exists (select 'Y' from mtl_material_transactions mmt where mmt.organization_id=mp.organization_id and mmt.subinventory_code=:$column$.name)
) and
gcck.code_combination_id =
case
when mp.wms_enabled_flag='Y' and exists (select null from cst_cost_groups cg, cst_cost_group_accounts cga where cg.cost_group_id=cga.cost_group_id and cga.organization_id=mp.organization_id and cg.cost_group=:$column$.default_cost_group) then (select cga.material_account from cst_cost_groups cg, cst_cost_group_accounts cga where cg.cost_group_id=cga.cost_group_id and cga.organization_id=mp.organization_id and cg.cost_group=:$column$.default_cost_group)
when exists (select null from mtl_secondary_inventories msi where mp.organization_id=msi.organization_id and msi.secondary_inventory_name=:$column$.name) then (select msi.material_account from mtl_secondary_inventories msi where mp.organization_id=msi.organization_id and msi.secondary_inventory_name=:$column$.name)
else mp.material_account
end
) or
(mp.wms_enabled_flag='N' and
mp.primary_cost_method=1 and
not exists (select 'Y' from mtl_onhand_quantities_detail moqd where moqd.organization_id=mp.organization_id and moqd.subinventory_code=:$column$.name) and
not exists (select 'Y' from mtl_material_transactions mmt where mmt.organization_id=mp.organization_id and mmt.subinventory_code=:$column$.name)
)
)
order by
gcck.concatenated_segmentsselect
gcck.concatenated_segments
from
gl_code_combinations_kfv gcck,
mtl_parameters mp,
org_organization_definitions ood
where
mp.organization_code=:$column$.organization_code and
ood.organization_id=mp.organization_id and
gcck.chart_of_accounts_id=ood.chart_of_accounts_id and
gcck.summary_flag='N' and
gcck.enabled_flag='Y' and
gcck.detail_posting_allowed='Y' and
(
((mp.wms_enabled_flag='Y' or
mp.primary_cost_method<>1 or
exists (select 'Y' from mtl_onhand_quantities_detail moqd where moqd.organization_id=mp.organization_id and moqd.subinventory_code=:$column$.name) or
exists (select 'Y' from mtl_material_transactions mmt where mmt.organization_id=mp.organization_id and mmt.subinventory_code=:$column$.name)
) and
gcck.code_combination_id =
case
when mp.wms_enabled_flag='Y' and exists (select null from cst_cost_groups cg, cst_cost_group_accounts cga where cg.cost_group_id=cga.cost_group_id and cga.organization_id=mp.organization_id and cg.cost_group=:$column$.default_cost_group) then (select cga.material_account from cst_cost_groups cg, cst_cost_group_accounts cga where cg.cost_group_id=cga.cost_group_id and cga.organization_id=mp.organization_id and cg.cost_group=:$column$.default_cost_group)
when exists (select null from mtl_secondary_inventories msi where mp.organization_id=msi.organization_id and msi.secondary_inventory_name=:$column$.name) then (select msi.material_account from mtl_secondary_inventories msi where mp.organization_id=msi.organization_id and msi.secondary_inventory_name=:$column$.name)
else mp.material_account
end
) or
(mp.wms_enabled_flag='N' and
mp.primary_cost_method=1 and
not exists (select 'Y' from mtl_onhand_quantities_detail moqd where moqd.organization_id=mp.organization_id and moqd.subinventory_code=:$column$.name) and
not exists (select 'Y' from mtl_material_transactions mmt where mmt.organization_id=mp.organization_id and mmt.subinventory_code=:$column$.name) and
gcck.code_combination_id =
case
when exists (select null from cst_cost_groups cg, cst_cost_group_accounts cga where cg.cost_group_id=cga.cost_group_id and cga.organization_id=mp.organization_id and cg.cost_group=:$column$.default_cost_group) then (select cga.material_account from cst_cost_groups cg, cst_cost_group_accounts cga where cg.cost_group_id=cga.cost_group_id and cga.organization_id=mp.organization_id and cg.cost_group=:$column$.default_cost_group)
else mp.material_account
end
)
)Material Account for inventory costing in this subinventory (GL detail account, no summary accounts). The selectable values depend on WMS, the organization cost method, and whether the subinventory has onhand or transaction history. WMS=No + Standard cost method + no onhand/history: any enabled GL detail account in the chart. WMS=Yes: locked to the Cost Group's account, falling back to the existing subinventory account, then the organization account. WMS=No + (non-Standard cost method OR onhand OR transaction history): locked to the existing subinventory account, falling back to the organization account.36OUTSIDE_PROCESSINGLOV customvarchar2YYselect
gcck.code_combination_id id,
gcck.concatenated_segments value,
gcck.description
from
gl_code_combinations_kfv gcck,
mtl_parameters mp,
org_organization_definitions ood
where
mp.organization_code=:$column$.organization_code and
ood.organization_id=mp.organization_id and
gcck.chart_of_accounts_id=ood.chart_of_accounts_id and
gcck.summary_flag='N' and
gcck.enabled_flag='Y' and
gcck.detail_posting_allowed='Y' and
(
((mp.wms_enabled_flag='Y' or
mp.primary_cost_method<>1 or
exists (select 'Y' from mtl_onhand_quantities_detail moqd where moqd.organization_id=mp.organization_id and moqd.subinventory_code=:$column$.name) or
exists (select 'Y' from mtl_material_transactions mmt where mmt.organization_id=mp.organization_id and mmt.subinventory_code=:$column$.name)
) and
gcck.code_combination_id =
case
when mp.wms_enabled_flag='Y' and exists (select null from cst_cost_groups cg, cst_cost_group_accounts cga where cg.cost_group_id=cga.cost_group_id and cga.organization_id=mp.organization_id and cg.cost_group=:$column$.default_cost_group) then (select cga.outside_processing_account from cst_cost_groups cg, cst_cost_group_accounts cga where cg.cost_group_id=cga.cost_group_id and cga.organization_id=mp.organization_id and cg.cost_group=:$column$.default_cost_group)
when exists (select null from mtl_secondary_inventories msi where mp.organization_id=msi.organization_id and msi.secondary_inventory_name=:$column$.name) then (select msi.outside_processing_account from mtl_secondary_inventories msi where mp.organization_id=msi.organization_id and msi.secondary_inventory_name=:$column$.name)
else mp.outside_processing_account
end
) or
(mp.wms_enabled_flag='N' and
mp.primary_cost_method=1 and
not exists (select 'Y' from mtl_onhand_quantities_detail moqd where moqd.organization_id=mp.organization_id and moqd.subinventory_code=:$column$.name) and
not exists (select 'Y' from mtl_material_transactions mmt where mmt.organization_id=mp.organization_id and mmt.subinventory_code=:$column$.name)
)
)
order by
gcck.concatenated_segmentsselect
gcck.concatenated_segments
from
gl_code_combinations_kfv gcck,
mtl_parameters mp,
org_organization_definitions ood
where
mp.organization_code=:$column$.organization_code and
ood.organization_id=mp.organization_id and
gcck.chart_of_accounts_id=ood.chart_of_accounts_id and
gcck.summary_flag='N' and
gcck.enabled_flag='Y' and
gcck.detail_posting_allowed='Y' and
(
((mp.wms_enabled_flag='Y' or
mp.primary_cost_method<>1 or
exists (select 'Y' from mtl_onhand_quantities_detail moqd where moqd.organization_id=mp.organization_id and moqd.subinventory_code=:$column$.name) or
exists (select 'Y' from mtl_material_transactions mmt where mmt.organization_id=mp.organization_id and mmt.subinventory_code=:$column$.name)
) and
gcck.code_combination_id =
case
when mp.wms_enabled_flag='Y' and exists (select null from cst_cost_groups cg, cst_cost_group_accounts cga where cg.cost_group_id=cga.cost_group_id and cga.organization_id=mp.organization_id and cg.cost_group=:$column$.default_cost_group) then (select cga.outside_processing_account from cst_cost_groups cg, cst_cost_group_accounts cga where cg.cost_group_id=cga.cost_group_id and cga.organization_id=mp.organization_id and cg.cost_group=:$column$.default_cost_group)
when exists (select null from mtl_secondary_inventories msi where mp.organization_id=msi.organization_id and msi.secondary_inventory_name=:$column$.name) then (select msi.outside_processing_account from mtl_secondary_inventories msi where mp.organization_id=msi.organization_id and msi.secondary_inventory_name=:$column$.name)
else mp.outside_processing_account
end
) or
(mp.wms_enabled_flag='N' and
mp.primary_cost_method=1 and
not exists (select 'Y' from mtl_onhand_quantities_detail moqd where moqd.organization_id=mp.organization_id and moqd.subinventory_code=:$column$.name) and
not exists (select 'Y' from mtl_material_transactions mmt where mmt.organization_id=mp.organization_id and mmt.subinventory_code=:$column$.name) and
gcck.code_combination_id =
case
when exists (select null from cst_cost_groups cg, cst_cost_group_accounts cga where cg.cost_group_id=cga.cost_group_id and cga.organization_id=mp.organization_id and cg.cost_group=:$column$.default_cost_group) then (select cga.outside_processing_account from cst_cost_groups cg, cst_cost_group_accounts cga where cg.cost_group_id=cga.cost_group_id and cga.organization_id=mp.organization_id and cg.cost_group=:$column$.default_cost_group)
else mp.outside_processing_account
end
)
)Outside Processing Account for outsourced operations charged through this subinventory (GL detail account). The selectable values depend on WMS, the organization cost method, and whether the subinventory has onhand or transaction history. WMS=No + Standard cost method + no onhand/history: any enabled GL detail account in the chart. WMS=Yes: locked to the Cost Group's account, falling back to the existing subinventory account, then the organization account. WMS=No + (non-Standard cost method OR onhand OR transaction history): locked to the existing subinventory account, falling back to the organization account.37MATERIAL_OVERHEADLOV customvarchar2YYselect
gcck.code_combination_id id,
gcck.concatenated_segments value,
gcck.description
from
gl_code_combinations_kfv gcck,
mtl_parameters mp,
org_organization_definitions ood
where
mp.organization_code=:$column$.organization_code and
ood.organization_id=mp.organization_id and
gcck.chart_of_accounts_id=ood.chart_of_accounts_id and
gcck.summary_flag='N' and
gcck.enabled_flag='Y' and
gcck.detail_posting_allowed='Y' and
(
((mp.wms_enabled_flag='Y' or
mp.primary_cost_method<>1 or
exists (select 'Y' from mtl_onhand_quantities_detail moqd where moqd.organization_id=mp.organization_id and moqd.subinventory_code=:$column$.name) or
exists (select 'Y' from mtl_material_transactions mmt where mmt.organization_id=mp.organization_id and mmt.subinventory_code=:$column$.name)
) and
gcck.code_combination_id =
case
when mp.wms_enabled_flag='Y' and exists (select null from cst_cost_groups cg, cst_cost_group_accounts cga where cg.cost_group_id=cga.cost_group_id and cga.organization_id=mp.organization_id and cg.cost_group=:$column$.default_cost_group) then (select cga.material_overhead_account from cst_cost_groups cg, cst_cost_group_accounts cga where cg.cost_group_id=cga.cost_group_id and cga.organization_id=mp.organization_id and cg.cost_group=:$column$.default_cost_group)
when exists (select null from mtl_secondary_inventories msi where mp.organization_id=msi.organization_id and msi.secondary_inventory_name=:$column$.name) then (select msi.material_overhead_account from mtl_secondary_inventories msi where mp.organization_id=msi.organization_id and msi.secondary_inventory_name=:$column$.name)
else mp.material_overhead_account
end
) or
(mp.wms_enabled_flag='N' and
mp.primary_cost_method=1 and
not exists (select 'Y' from mtl_onhand_quantities_detail moqd where moqd.organization_id=mp.organization_id and moqd.subinventory_code=:$column$.name) and
not exists (select 'Y' from mtl_material_transactions mmt where mmt.organization_id=mp.organization_id and mmt.subinventory_code=:$column$.name)
)
)
order by
gcck.concatenated_segmentsselect
gcck.concatenated_segments
from
gl_code_combinations_kfv gcck,
mtl_parameters mp,
org_organization_definitions ood
where
mp.organization_code=:$column$.organization_code and
ood.organization_id=mp.organization_id and
gcck.chart_of_accounts_id=ood.chart_of_accounts_id and
gcck.summary_flag='N' and
gcck.enabled_flag='Y' and
gcck.detail_posting_allowed='Y' and
(
((mp.wms_enabled_flag='Y' or
mp.primary_cost_method<>1 or
exists (select 'Y' from mtl_onhand_quantities_detail moqd where moqd.organization_id=mp.organization_id and moqd.subinventory_code=:$column$.name) or
exists (select 'Y' from mtl_material_transactions mmt where mmt.organization_id=mp.organization_id and mmt.subinventory_code=:$column$.name)
) and
gcck.code_combination_id =
case
when mp.wms_enabled_flag='Y' and exists (select null from cst_cost_groups cg, cst_cost_group_accounts cga where cg.cost_group_id=cga.cost_group_id and cga.organization_id=mp.organization_id and cg.cost_group=:$column$.default_cost_group) then (select cga.material_overhead_account from cst_cost_groups cg, cst_cost_group_accounts cga where cg.cost_group_id=cga.cost_group_id and cga.organization_id=mp.organization_id and cg.cost_group=:$column$.default_cost_group)
when exists (select null from mtl_secondary_inventories msi where mp.organization_id=msi.organization_id and msi.secondary_inventory_name=:$column$.name) then (select msi.material_overhead_account from mtl_secondary_inventories msi where mp.organization_id=msi.organization_id and msi.secondary_inventory_name=:$column$.name)
else mp.material_overhead_account
end
) or
(mp.wms_enabled_flag='N' and
mp.primary_cost_method=1 and
not exists (select 'Y' from mtl_onhand_quantities_detail moqd where moqd.organization_id=mp.organization_id and moqd.subinventory_code=:$column$.name) and
not exists (select 'Y' from mtl_material_transactions mmt where mmt.organization_id=mp.organization_id and mmt.subinventory_code=:$column$.name) and
gcck.code_combination_id =
case
when exists (select null from cst_cost_groups cg, cst_cost_group_accounts cga where cg.cost_group_id=cga.cost_group_id and cga.organization_id=mp.organization_id and cg.cost_group=:$column$.default_cost_group) then (select cga.material_overhead_account from cst_cost_groups cg, cst_cost_group_accounts cga where cg.cost_group_id=cga.cost_group_id and cga.organization_id=mp.organization_id and cg.cost_group=:$column$.default_cost_group)
else mp.material_overhead_account
end
)
)Material Overhead Account for material handling overhead absorbed in this subinventory (GL detail account). The selectable values depend on WMS, the organization cost method, and whether the subinventory has onhand or transaction history. WMS=No + Standard cost method + no onhand/history: any enabled GL detail account in the chart. WMS=Yes: locked to the Cost Group's account, falling back to the existing subinventory account, then the organization account. WMS=No + (non-Standard cost method OR onhand OR transaction history): locked to the existing subinventory account, falling back to the organization account.38OVERHEADLOV customvarchar2YYselect
gcck.code_combination_id id,
gcck.concatenated_segments value,
gcck.description
from
gl_code_combinations_kfv gcck,
mtl_parameters mp,
org_organization_definitions ood
where
mp.organization_code=:$column$.organization_code and
ood.organization_id=mp.organization_id and
gcck.chart_of_accounts_id=ood.chart_of_accounts_id and
gcck.summary_flag='N' and
gcck.enabled_flag='Y' and
gcck.detail_posting_allowed='Y' and
(
((mp.wms_enabled_flag='Y' or
mp.primary_cost_method<>1 or
exists (select 'Y' from mtl_onhand_quantities_detail moqd where moqd.organization_id=mp.organization_id and moqd.subinventory_code=:$column$.name) or
exists (select 'Y' from mtl_material_transactions mmt where mmt.organization_id=mp.organization_id and mmt.subinventory_code=:$column$.name)
) and
gcck.code_combination_id =
case
when mp.wms_enabled_flag='Y' and exists (select null from cst_cost_groups cg, cst_cost_group_accounts cga where cg.cost_group_id=cga.cost_group_id and cga.organization_id=mp.organization_id and cg.cost_group=:$column$.default_cost_group) then (select cga.overhead_account from cst_cost_groups cg, cst_cost_group_accounts cga where cg.cost_group_id=cga.cost_group_id and cga.organization_id=mp.organization_id and cg.cost_group=:$column$.default_cost_group)
when exists (select null from mtl_secondary_inventories msi where mp.organization_id=msi.organization_id and msi.secondary_inventory_name=:$column$.name) then (select msi.overhead_account from mtl_secondary_inventories msi where mp.organization_id=msi.organization_id and msi.secondary_inventory_name=:$column$.name)
else mp.overhead_account
end
) or
(mp.wms_enabled_flag='N' and
mp.primary_cost_method=1 and
not exists (select 'Y' from mtl_onhand_quantities_detail moqd where moqd.organization_id=mp.organization_id and moqd.subinventory_code=:$column$.name) and
not exists (select 'Y' from mtl_material_transactions mmt where mmt.organization_id=mp.organization_id and mmt.subinventory_code=:$column$.name)
)
)
order by
gcck.concatenated_segmentsselect
gcck.concatenated_segments
from
gl_code_combinations_kfv gcck,
mtl_parameters mp,
org_organization_definitions ood
where
mp.organization_code=:$column$.organization_code and
ood.organization_id=mp.organization_id and
gcck.chart_of_accounts_id=ood.chart_of_accounts_id and
gcck.summary_flag='N' and
gcck.enabled_flag='Y' and
gcck.detail_posting_allowed='Y' and
(
((mp.wms_enabled_flag='Y' or
mp.primary_cost_method<>1 or
exists (select 'Y' from mtl_onhand_quantities_detail moqd where moqd.organization_id=mp.organization_id and moqd.subinventory_code=:$column$.name) or
exists (select 'Y' from mtl_material_transactions mmt where mmt.organization_id=mp.organization_id and mmt.subinventory_code=:$column$.name)
) and
gcck.code_combination_id =
case
when mp.wms_enabled_flag='Y' and exists (select null from cst_cost_groups cg, cst_cost_group_accounts cga where cg.cost_group_id=cga.cost_group_id and cga.organization_id=mp.organization_id and cg.cost_group=:$column$.default_cost_group) then (select cga.overhead_account from cst_cost_groups cg, cst_cost_group_accounts cga where cg.cost_group_id=cga.cost_group_id and cga.organization_id=mp.organization_id and cg.cost_group=:$column$.default_cost_group)
when exists (select null from mtl_secondary_inventories msi where mp.organization_id=msi.organization_id and msi.secondary_inventory_name=:$column$.name) then (select msi.overhead_account from mtl_secondary_inventories msi where mp.organization_id=msi.organization_id and msi.secondary_inventory_name=:$column$.name)
else mp.overhead_account
end
) or
(mp.wms_enabled_flag='N' and
mp.primary_cost_method=1 and
not exists (select 'Y' from mtl_onhand_quantities_detail moqd where moqd.organization_id=mp.organization_id and moqd.subinventory_code=:$column$.name) and
not exists (select 'Y' from mtl_material_transactions mmt where mmt.organization_id=mp.organization_id and mmt.subinventory_code=:$column$.name) and
gcck.code_combination_id =
case
when exists (select null from cst_cost_groups cg, cst_cost_group_accounts cga where cg.cost_group_id=cga.cost_group_id and cga.organization_id=mp.organization_id and cg.cost_group=:$column$.default_cost_group) then (select cga.overhead_account from cst_cost_groups cg, cst_cost_group_accounts cga where cg.cost_group_id=cga.cost_group_id and cga.organization_id=mp.organization_id and cg.cost_group=:$column$.default_cost_group)
else mp.overhead_account
end
)
)Overhead Account for production overhead absorbed in this subinventory (GL detail account). The selectable values depend on WMS, the organization cost method, and whether the subinventory has onhand or transaction history. WMS=No + Standard cost method + no onhand/history: any enabled GL detail account in the chart. WMS=Yes: locked to the Cost Group's account, falling back to the existing subinventory account, then the organization account. WMS=No + (non-Standard cost method OR onhand OR transaction history): locked to the existing subinventory account, falling back to the organization account.39RESOURCE_ACCOUNTLOV customvarchar2YYselect
gcck.code_combination_id id,
gcck.concatenated_segments value,
gcck.description
from
gl_code_combinations_kfv gcck,
mtl_parameters mp,
org_organization_definitions ood
where
mp.organization_code=:$column$.organization_code and
ood.organization_id=mp.organization_id and
gcck.chart_of_accounts_id=ood.chart_of_accounts_id and
gcck.summary_flag='N' and
gcck.enabled_flag='Y' and
gcck.detail_posting_allowed='Y' and
(
((mp.wms_enabled_flag='Y' or
mp.primary_cost_method<>1 or
exists (select 'Y' from mtl_onhand_quantities_detail moqd where moqd.organization_id=mp.organization_id and moqd.subinventory_code=:$column$.name) or
exists (select 'Y' from mtl_material_transactions mmt where mmt.organization_id=mp.organization_id and mmt.subinventory_code=:$column$.name)
) and
gcck.code_combination_id =
case
when mp.wms_enabled_flag='Y' and exists (select null from cst_cost_groups cg, cst_cost_group_accounts cga where cg.cost_group_id=cga.cost_group_id and cga.organization_id=mp.organization_id and cg.cost_group=:$column$.default_cost_group) then (select cga.resource_account from cst_cost_groups cg, cst_cost_group_accounts cga where cg.cost_group_id=cga.cost_group_id and cga.organization_id=mp.organization_id and cg.cost_group=:$column$.default_cost_group)
when exists (select null from mtl_secondary_inventories msi where mp.organization_id=msi.organization_id and msi.secondary_inventory_name=:$column$.name) then (select msi.resource_account from mtl_secondary_inventories msi where mp.organization_id=msi.organization_id and msi.secondary_inventory_name=:$column$.name)
else mp.resource_account
end
) or
(mp.wms_enabled_flag='N' and
mp.primary_cost_method=1 and
not exists (select 'Y' from mtl_onhand_quantities_detail moqd where moqd.organization_id=mp.organization_id and moqd.subinventory_code=:$column$.name) and
not exists (select 'Y' from mtl_material_transactions mmt where mmt.organization_id=mp.organization_id and mmt.subinventory_code=:$column$.name)
)
)
order by
gcck.concatenated_segmentsselect
gcck.concatenated_segments
from
gl_code_combinations_kfv gcck,
mtl_parameters mp,
org_organization_definitions ood
where
mp.organization_code=:$column$.organization_code and
ood.organization_id=mp.organization_id and
gcck.chart_of_accounts_id=ood.chart_of_accounts_id and
gcck.summary_flag='N' and
gcck.enabled_flag='Y' and
gcck.detail_posting_allowed='Y' and
(
((mp.wms_enabled_flag='Y' or
mp.primary_cost_method<>1 or
exists (select 'Y' from mtl_onhand_quantities_detail moqd where moqd.organization_id=mp.organization_id and moqd.subinventory_code=:$column$.name) or
exists (select 'Y' from mtl_material_transactions mmt where mmt.organization_id=mp.organization_id and mmt.subinventory_code=:$column$.name)
) and
gcck.code_combination_id =
case
when mp.wms_enabled_flag='Y' and exists (select null from cst_cost_groups cg, cst_cost_group_accounts cga where cg.cost_group_id=cga.cost_group_id and cga.organization_id=mp.organization_id and cg.cost_group=:$column$.default_cost_group) then (select cga.resource_account from cst_cost_groups cg, cst_cost_group_accounts cga where cg.cost_group_id=cga.cost_group_id and cga.organization_id=mp.organization_id and cg.cost_group=:$column$.default_cost_group)
when exists (select null from mtl_secondary_inventories msi where mp.organization_id=msi.organization_id and msi.secondary_inventory_name=:$column$.name) then (select msi.resource_account from mtl_secondary_inventories msi where mp.organization_id=msi.organization_id and msi.secondary_inventory_name=:$column$.name)
else mp.resource_account
end
) or
(mp.wms_enabled_flag='N' and
mp.primary_cost_method=1 and
not exists (select 'Y' from mtl_onhand_quantities_detail moqd where moqd.organization_id=mp.organization_id and moqd.subinventory_code=:$column$.name) and
not exists (select 'Y' from mtl_material_transactions mmt where mmt.organization_id=mp.organization_id and mmt.subinventory_code=:$column$.name) and
gcck.code_combination_id =
case
when exists (select null from cst_cost_groups cg, cst_cost_group_accounts cga where cg.cost_group_id=cga.cost_group_id and cga.organization_id=mp.organization_id and cg.cost_group=:$column$.default_cost_group) then (select cga.resource_account from cst_cost_groups cg, cst_cost_group_accounts cga where cg.cost_group_id=cga.cost_group_id and cga.organization_id=mp.organization_id and cg.cost_group=:$column$.default_cost_group)
else mp.resource_account
end
)
)Resource Account for resource consumption charged through this subinventory (GL detail account). Required when BOM is installed and the organization cost method is Standard. The selectable values depend on WMS, the organization cost method, and whether the subinventory has onhand or transaction history. WMS=No + Standard cost method + no onhand/history: any enabled GL detail account in the chart. WMS=Yes: locked to the Cost Group's account, falling back to the existing subinventory account, then the organization account. WMS=No + (non-Standard cost method OR onhand OR transaction history): locked to the existing subinventory account, falling back to the organization account.40EXPENSELOV customvarchar2YYselect
gcck.code_combination_id id,
gcck.concatenated_segments value,
gcck.description
from
gl_code_combinations_kfv gcck,
mtl_parameters mp,
org_organization_definitions ood
where
mp.organization_code=:$column$.organization_code and
ood.organization_id=mp.organization_id and
gcck.chart_of_accounts_id=ood.chart_of_accounts_id and
gcck.summary_flag='N' and
gcck.enabled_flag='Y' and
gcck.detail_posting_allowed='Y' and
(
(mp.wms_enabled_flag='Y' and
gcck.code_combination_id =
case
when exists (select null from cst_cost_groups cg, cst_cost_group_accounts cga where cg.cost_group_id=cga.cost_group_id and cga.organization_id=mp.organization_id and cg.cost_group=:$column$.default_cost_group) then (select cga.expense_account from cst_cost_groups cg, cst_cost_group_accounts cga where cg.cost_group_id=cga.cost_group_id and cga.organization_id=mp.organization_id and cg.cost_group=:$column$.default_cost_group)
when exists (select null from mtl_secondary_inventories msi where mp.organization_id=msi.organization_id and msi.secondary_inventory_name=:$column$.name) then (select msi.expense_account from mtl_secondary_inventories msi where mp.organization_id=msi.organization_id and msi.secondary_inventory_name=:$column$.name)
else mp.expense_account
end
) or
mp.wms_enabled_flag='N'
)
order by
gcck.concatenated_segmentsselect
gcck.concatenated_segments
from
gl_code_combinations_kfv gcck,
mtl_parameters mp,
org_organization_definitions ood
where
mp.organization_code=:$column$.organization_code and
ood.organization_id=mp.organization_id and
gcck.chart_of_accounts_id=ood.chart_of_accounts_id and
gcck.summary_flag='N' and
gcck.enabled_flag='Y' and
gcck.detail_posting_allowed='Y' and
(
(mp.wms_enabled_flag='Y' and
gcck.code_combination_id =
case
when exists (select null from cst_cost_groups cg, cst_cost_group_accounts cga where cg.cost_group_id=cga.cost_group_id and cga.organization_id=mp.organization_id and cg.cost_group=:$column$.default_cost_group) then (select cga.expense_account from cst_cost_groups cg, cst_cost_group_accounts cga where cg.cost_group_id=cga.cost_group_id and cga.organization_id=mp.organization_id and cg.cost_group=:$column$.default_cost_group)
when exists (select null from mtl_secondary_inventories msi where mp.organization_id=msi.organization_id and msi.secondary_inventory_name=:$column$.name) then (select msi.expense_account from mtl_secondary_inventories msi where mp.organization_id=msi.organization_id and msi.secondary_inventory_name=:$column$.name)
else mp.expense_account
end
) or
(mp.wms_enabled_flag='N' and
gcck.code_combination_id =
case
when exists (select null from cst_cost_groups cg, cst_cost_group_accounts cga where cg.cost_group_id=cga.cost_group_id and cga.organization_id=mp.organization_id and cg.cost_group=:$column$.default_cost_group) then (select cga.expense_account from cst_cost_groups cg, cst_cost_group_accounts cga where cg.cost_group_id=cga.cost_group_id and cga.organization_id=mp.organization_id and cg.cost_group=:$column$.default_cost_group)
else mp.expense_account
end
)
)Expense Account for non-asset (expense) subinventories charging consumption directly to expense (GL detail account). The selectable values depend on WMS. WMS=No: any enabled GL detail account in the chart; defaults from the organization. WMS=Yes: locked to the Cost Group's account, falling back to the existing subinventory account, then the organization account.41ENCUMBRANCELOV customvarchar2YYselect
gcck.code_combination_id id,
gcck.concatenated_segments value,
gcck.description
from
gl_code_combinations_kfv gcck,
mtl_parameters mp,
org_organization_definitions ood
where
mp.organization_code=:$column$.organization_code and
ood.organization_id=mp.organization_id and
gcck.chart_of_accounts_id=ood.chart_of_accounts_id and
gcck.summary_flag='N' and
gcck.enabled_flag='Y' and
gcck.detail_posting_allowed='Y' and
(
(mp.wms_enabled_flag='Y' and
gcck.code_combination_id =
case
when exists (select null from cst_cost_groups cg, cst_cost_group_accounts cga where cg.cost_group_id=cga.cost_group_id and cga.organization_id=mp.organization_id and cg.cost_group=:$column$.default_cost_group) then (select cga.encumbrance_account from cst_cost_groups cg, cst_cost_group_accounts cga where cg.cost_group_id=cga.cost_group_id and cga.organization_id=mp.organization_id and cg.cost_group=:$column$.default_cost_group)
when exists (select null from mtl_secondary_inventories msi where mp.organization_id=msi.organization_id and msi.secondary_inventory_name=:$column$.name) then (select msi.encumbrance_account from mtl_secondary_inventories msi where mp.organization_id=msi.organization_id and msi.secondary_inventory_name=:$column$.name)
else mp.encumbrance_account
end
) or
mp.wms_enabled_flag='N'
)
order by
gcck.concatenated_segmentsselect
gcck.concatenated_segments
from
gl_code_combinations_kfv gcck,
mtl_parameters mp,
org_organization_definitions ood
where
mp.organization_code=:$column$.organization_code and
ood.organization_id=mp.organization_id and
gcck.chart_of_accounts_id=ood.chart_of_accounts_id and
gcck.summary_flag='N' and
gcck.enabled_flag='Y' and
gcck.detail_posting_allowed='Y' and
(
(mp.wms_enabled_flag='Y' and
gcck.code_combination_id =
case
when exists (select null from cst_cost_groups cg, cst_cost_group_accounts cga where cg.cost_group_id=cga.cost_group_id and cga.organization_id=mp.organization_id and cg.cost_group=:$column$.default_cost_group) then (select cga.encumbrance_account from cst_cost_groups cg, cst_cost_group_accounts cga where cg.cost_group_id=cga.cost_group_id and cga.organization_id=mp.organization_id and cg.cost_group=:$column$.default_cost_group)
when exists (select null from mtl_secondary_inventories msi where mp.organization_id=msi.organization_id and msi.secondary_inventory_name=:$column$.name) then (select msi.encumbrance_account from mtl_secondary_inventories msi where mp.organization_id=msi.organization_id and msi.secondary_inventory_name=:$column$.name)
else mp.encumbrance_account
end
) or
(mp.wms_enabled_flag='N' and
gcck.code_combination_id =
case
when exists (select null from cst_cost_groups cg, cst_cost_group_accounts cga where cg.cost_group_id=cga.cost_group_id and cga.organization_id=mp.organization_id and cg.cost_group=:$column$.default_cost_group) then (select cga.encumbrance_account from cst_cost_groups cg, cst_cost_group_accounts cga where cg.cost_group_id=cga.cost_group_id and cga.organization_id=mp.organization_id and cg.cost_group=:$column$.default_cost_group)
else mp.encumbrance_account
end
)
)Encumbrance Account for encumbrance accounting through this subinventory (GL detail account). The selectable values depend on WMS. WMS=No: any enabled GL detail account in the chart; defaults from the organization. WMS=Yes: locked to the Cost Group's account, falling back to the existing subinventory account, then the organization account.42LPN_CONTROLLEDLOV customvarchar2Yselect
to_number(ml.lookup_code) id,
ml.meaning value,
null description
from
mfg_lookups ml
where
ml.lookup_type='SYS_YES_NO' and
ml.enabled_flag='Y' and
exists (select null from mtl_parameters mp where mp.organization_code=:$column$.organization_code and mp.wms_enabled_flag='Y') and
(nvl(xxen_util.lookup_code(:$column$.type,'MTL_SUB_TYPE',700),'1')<>'2' or ml.lookup_code='1')
order by
ml.lookup_codeselect xxen_util.meaning('1','SYS_YES_NO',700)
from mtl_parameters mp
where mp.organization_code=:$column$.organization_code
and mp.wms_enabled_flag='Y'
and not exists (select null from mtl_secondary_inventories msi where msi.organization_id=mp.organization_id and msi.secondary_inventory_name=:$column$.name)This subinventory tracks LPNs (License Plate Numbers). WMS-only — LOV returns no rows for non-WMS organizations. Defaults to Yes on new subinventories in WMS-enabled organizations, matching the form's observed default; for Storage subinventories the user can toggle to No, but for Receiving subinventories the value is locked to Yes.43ENABLE_CARTONIZATIONLOV customvarchar2Yselect
to_number(ml.lookup_code) id,
ml.meaning value,
null description
from
mfg_lookups ml
where
ml.lookup_type='SYS_YES_NO' and
ml.enabled_flag='Y' and
exists (select null from mtl_parameters mp where mp.organization_code=:$column$.organization_code and mp.wms_enabled_flag='Y')
order by
ml.lookup_codeEnable Cartonization in this subinventory. WMS-only — LOV returns no rows for non-WMS organizations. Mutually exclusive with Enable Bulk Pick.44ENABLE_BULK_PICKLOV customvarchar2Yselect
fl.lookup_code id,
fl.meaning value,
null description
from
fnd_lookups fl
where
fl.lookup_type='YES_NO' and
fl.enabled_flag='Y' and
exists (select null from mtl_parameters mp where mp.organization_code=:$column$.organization_code and mp.wms_enabled_flag='Y')
order by
fl.lookup_codeEnable Bulk Pick in this subinventory. WMS-only — LOV returns no rows for non-WMS organizations. Mutually exclusive with Enable Cartonization.45ENABLE_OPPORTUNISTIC_CYCLE_COUNTLOV customvarchar2Yselect
fl.lookup_code id,
fl.meaning value,
null description
from
fnd_lookups fl
where
fl.lookup_type='YES_NO' and
fl.enabled_flag='Y' and
exists (select null from mtl_parameters mp where mp.organization_code=:$column$.organization_code and mp.wms_enabled_flag='Y')
order by
fl.lookup_codeEnable Opportunistic Cycle Count for this subinventory. WMS-only — LOV returns no rows for non-WMS organizations. When Yes, the Header, Trigger Quantity and Days Threshold columns become required.46OPPORTUNISTIC_CYCLE_COUNT_HEADERLOV customvarchar2Yselect
mcch.cycle_count_header_id id,
mcch.cycle_count_header_name value,
null description
from
mtl_cycle_count_headers mcch,
mtl_parameters mp
where
mp.organization_code=:$column$.organization_code and
mcch.organization_id=mp.organization_id and
mp.wms_enabled_flag='Y'
order by
mcch.cycle_count_header_nameCycle Count Header associated with the opportunistic cycle count. WMS-only — LOV returns no rows for non-WMS organizations. Required when Enable Opportunistic Cycle Count is Yes.47OPPORTUNISTIC_CYCLE_COUNT_TRIGGER_QUANTITYNumbernumberQuantity threshold that triggers an opportunistic cycle count. Must be a non-negative integer. Required when Enable Opportunistic Cycle Count is Yes.48OPPORTUNISTIC_CYCLE_COUNT_DAYS_THRESHOLDNumbernumberDays threshold that triggers an opportunistic cycle count. Must be a non-negative integer. Required when Enable Opportunistic Cycle Count is Yes.49ATTRIBUTE_CATEGORYLOV customvarchar2Yselect
fdfcv.descriptive_flex_context_name value,
fdfcv.description
from
fnd_descr_flex_contexts_vl fdfcv,
fnd_descriptive_flexs fdf
where
fdf.application_id=401 and
fdf.descriptive_flexfield_name='MTL_SECONDARY_INVENTORIES' and
fdfcv.descriptive_flexfield_name=fdf.descriptive_flexfield_name and
fdfcv.application_id=fdf.application_id and
fdfcv.enabled_flag='Y' and
fdfcv.descriptive_flex_context_code<>'Global Data Elements'
order by
fdfcv.descriptive_flex_context_nameDescriptive Flexfield (DFF) context for MTL_SECONDARY_INVENTORIES. Drives which Attribute columns are relevant for this subinventory.50SUB_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_SECONDARY_INVENTORIES',
p_context_name=>:$column$.attribute_category,
p_column_name=>'ATTRIBUTE1',
p_attribute1=>:$column$.sub_attribute1,
p_attribute2=>:$column$.sub_attribute2,
p_attribute3=>:$column$.sub_attribute3,
p_attribute4=>:$column$.sub_attribute4,
p_attribute5=>:$column$.sub_attribute5,
p_attribute6=>:$column$.sub_attribute6,
p_attribute7=>:$column$.sub_attribute7,
p_attribute8=>:$column$.sub_attribute8,
p_attribute9=>:$column$.sub_attribute9,
p_attribute10=>:$column$.sub_attribute10,
p_attribute11=>:$column$.sub_attribute11,
p_attribute12=>:$column$.sub_attribute12,
p_attribute13=>:$column$.sub_attribute13,
p_attribute14=>:$column$.sub_attribute14,
p_attribute15=>:$column$.sub_attribute15
)
) lovselect distinct
'(Context) ' || initcap(fdfcuv.application_column_name) || ': ' ||
listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name)
from
fnd_descriptive_flexs_vl fdfv,
fnd_descr_flex_contexts fdfc,
fnd_descr_flex_col_usage_vl fdfcuv
where
fdfc.application_id = fdfv.application_id and
fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and
fdfc.enabled_flag = 'Y' and
fdfcuv.application_id = fdfc.application_id and
fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and
fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and
fdfcuv.enabled_flag = 'Y' and
fdfv.application_id = 401 and
fdfv.descriptive_flexfield_name = 'MTL_SECONDARY_INVENTORIES' and
fdfcuv.application_column_name = 'ATTRIBUTE1'51SUB_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_SECONDARY_INVENTORIES',
p_context_name=>:$column$.attribute_category,
p_column_name=>'ATTRIBUTE2',
p_attribute1=>:$column$.sub_attribute1,
p_attribute2=>:$column$.sub_attribute2,
p_attribute3=>:$column$.sub_attribute3,
p_attribute4=>:$column$.sub_attribute4,
p_attribute5=>:$column$.sub_attribute5,
p_attribute6=>:$column$.sub_attribute6,
p_attribute7=>:$column$.sub_attribute7,
p_attribute8=>:$column$.sub_attribute8,
p_attribute9=>:$column$.sub_attribute9,
p_attribute10=>:$column$.sub_attribute10,
p_attribute11=>:$column$.sub_attribute11,
p_attribute12=>:$column$.sub_attribute12,
p_attribute13=>:$column$.sub_attribute13,
p_attribute14=>:$column$.sub_attribute14,
p_attribute15=>:$column$.sub_attribute15
)
) lovselect distinct
'(Context) ' || initcap(fdfcuv.application_column_name) || ': ' ||
listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name)
from
fnd_descriptive_flexs_vl fdfv,
fnd_descr_flex_contexts fdfc,
fnd_descr_flex_col_usage_vl fdfcuv
where
fdfc.application_id = fdfv.application_id and
fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and
fdfc.enabled_flag = 'Y' and
fdfcuv.application_id = fdfc.application_id and
fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and
fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and
fdfcuv.enabled_flag = 'Y' and
fdfv.application_id = 401 and
fdfv.descriptive_flexfield_name = 'MTL_SECONDARY_INVENTORIES' and
fdfcuv.application_column_name = 'ATTRIBUTE2'52SUB_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_SECONDARY_INVENTORIES',
p_context_name=>:$column$.attribute_category,
p_column_name=>'ATTRIBUTE3',
p_attribute1=>:$column$.sub_attribute1,
p_attribute2=>:$column$.sub_attribute2,
p_attribute3=>:$column$.sub_attribute3,
p_attribute4=>:$column$.sub_attribute4,
p_attribute5=>:$column$.sub_attribute5,
p_attribute6=>:$column$.sub_attribute6,
p_attribute7=>:$column$.sub_attribute7,
p_attribute8=>:$column$.sub_attribute8,
p_attribute9=>:$column$.sub_attribute9,
p_attribute10=>:$column$.sub_attribute10,
p_attribute11=>:$column$.sub_attribute11,
p_attribute12=>:$column$.sub_attribute12,
p_attribute13=>:$column$.sub_attribute13,
p_attribute14=>:$column$.sub_attribute14,
p_attribute15=>:$column$.sub_attribute15
)
) lovselect distinct
'(Context) ' || initcap(fdfcuv.application_column_name) || ': ' ||
listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name)
from
fnd_descriptive_flexs_vl fdfv,
fnd_descr_flex_contexts fdfc,
fnd_descr_flex_col_usage_vl fdfcuv
where
fdfc.application_id = fdfv.application_id and
fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and
fdfc.enabled_flag = 'Y' and
fdfcuv.application_id = fdfc.application_id and
fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and
fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and
fdfcuv.enabled_flag = 'Y' and
fdfv.application_id = 401 and
fdfv.descriptive_flexfield_name = 'MTL_SECONDARY_INVENTORIES' and
fdfcuv.application_column_name = 'ATTRIBUTE3'53SUB_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_SECONDARY_INVENTORIES',
p_context_name=>:$column$.attribute_category,
p_column_name=>'ATTRIBUTE4',
p_attribute1=>:$column$.sub_attribute1,
p_attribute2=>:$column$.sub_attribute2,
p_attribute3=>:$column$.sub_attribute3,
p_attribute4=>:$column$.sub_attribute4,
p_attribute5=>:$column$.sub_attribute5,
p_attribute6=>:$column$.sub_attribute6,
p_attribute7=>:$column$.sub_attribute7,
p_attribute8=>:$column$.sub_attribute8,
p_attribute9=>:$column$.sub_attribute9,
p_attribute10=>:$column$.sub_attribute10,
p_attribute11=>:$column$.sub_attribute11,
p_attribute12=>:$column$.sub_attribute12,
p_attribute13=>:$column$.sub_attribute13,
p_attribute14=>:$column$.sub_attribute14,
p_attribute15=>:$column$.sub_attribute15
)
) lovselect distinct
'(Context) ' || initcap(fdfcuv.application_column_name) || ': ' ||
listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name)
from
fnd_descriptive_flexs_vl fdfv,
fnd_descr_flex_contexts fdfc,
fnd_descr_flex_col_usage_vl fdfcuv
where
fdfc.application_id = fdfv.application_id and
fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and
fdfc.enabled_flag = 'Y' and
fdfcuv.application_id = fdfc.application_id and
fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and
fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and
fdfcuv.enabled_flag = 'Y' and
fdfv.application_id = 401 and
fdfv.descriptive_flexfield_name = 'MTL_SECONDARY_INVENTORIES' and
fdfcuv.application_column_name = 'ATTRIBUTE4'54SUB_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_SECONDARY_INVENTORIES',
p_context_name=>:$column$.attribute_category,
p_column_name=>'ATTRIBUTE5',
p_attribute1=>:$column$.sub_attribute1,
p_attribute2=>:$column$.sub_attribute2,
p_attribute3=>:$column$.sub_attribute3,
p_attribute4=>:$column$.sub_attribute4,
p_attribute5=>:$column$.sub_attribute5,
p_attribute6=>:$column$.sub_attribute6,
p_attribute7=>:$column$.sub_attribute7,
p_attribute8=>:$column$.sub_attribute8,
p_attribute9=>:$column$.sub_attribute9,
p_attribute10=>:$column$.sub_attribute10,
p_attribute11=>:$column$.sub_attribute11,
p_attribute12=>:$column$.sub_attribute12,
p_attribute13=>:$column$.sub_attribute13,
p_attribute14=>:$column$.sub_attribute14,
p_attribute15=>:$column$.sub_attribute15
)
) lovselect distinct
'(Context) ' || initcap(fdfcuv.application_column_name) || ': ' ||
listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name)
from
fnd_descriptive_flexs_vl fdfv,
fnd_descr_flex_contexts fdfc,
fnd_descr_flex_col_usage_vl fdfcuv
where
fdfc.application_id = fdfv.application_id and
fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and
fdfc.enabled_flag = 'Y' and
fdfcuv.application_id = fdfc.application_id and
fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and
fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and
fdfcuv.enabled_flag = 'Y' and
fdfv.application_id = 401 and
fdfv.descriptive_flexfield_name = 'MTL_SECONDARY_INVENTORIES' and
fdfcuv.application_column_name = 'ATTRIBUTE5'55SUB_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_SECONDARY_INVENTORIES',
p_context_name=>:$column$.attribute_category,
p_column_name=>'ATTRIBUTE6',
p_attribute1=>:$column$.sub_attribute1,
p_attribute2=>:$column$.sub_attribute2,
p_attribute3=>:$column$.sub_attribute3,
p_attribute4=>:$column$.sub_attribute4,
p_attribute5=>:$column$.sub_attribute5,
p_attribute6=>:$column$.sub_attribute6,
p_attribute7=>:$column$.sub_attribute7,
p_attribute8=>:$column$.sub_attribute8,
p_attribute9=>:$column$.sub_attribute9,
p_attribute10=>:$column$.sub_attribute10,
p_attribute11=>:$column$.sub_attribute11,
p_attribute12=>:$column$.sub_attribute12,
p_attribute13=>:$column$.sub_attribute13,
p_attribute14=>:$column$.sub_attribute14,
p_attribute15=>:$column$.sub_attribute15
)
) lovselect distinct
'(Context) ' || initcap(fdfcuv.application_column_name) || ': ' ||
listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name)
from
fnd_descriptive_flexs_vl fdfv,
fnd_descr_flex_contexts fdfc,
fnd_descr_flex_col_usage_vl fdfcuv
where
fdfc.application_id = fdfv.application_id and
fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and
fdfc.enabled_flag = 'Y' and
fdfcuv.application_id = fdfc.application_id and
fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and
fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and
fdfcuv.enabled_flag = 'Y' and
fdfv.application_id = 401 and
fdfv.descriptive_flexfield_name = 'MTL_SECONDARY_INVENTORIES' and
fdfcuv.application_column_name = 'ATTRIBUTE6'56SUB_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_SECONDARY_INVENTORIES',
p_context_name=>:$column$.attribute_category,
p_column_name=>'ATTRIBUTE7',
p_attribute1=>:$column$.sub_attribute1,
p_attribute2=>:$column$.sub_attribute2,
p_attribute3=>:$column$.sub_attribute3,
p_attribute4=>:$column$.sub_attribute4,
p_attribute5=>:$column$.sub_attribute5,
p_attribute6=>:$column$.sub_attribute6,
p_attribute7=>:$column$.sub_attribute7,
p_attribute8=>:$column$.sub_attribute8,
p_attribute9=>:$column$.sub_attribute9,
p_attribute10=>:$column$.sub_attribute10,
p_attribute11=>:$column$.sub_attribute11,
p_attribute12=>:$column$.sub_attribute12,
p_attribute13=>:$column$.sub_attribute13,
p_attribute14=>:$column$.sub_attribute14,
p_attribute15=>:$column$.sub_attribute15
)
) lovselect distinct
'(Context) ' || initcap(fdfcuv.application_column_name) || ': ' ||
listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name)
from
fnd_descriptive_flexs_vl fdfv,
fnd_descr_flex_contexts fdfc,
fnd_descr_flex_col_usage_vl fdfcuv
where
fdfc.application_id = fdfv.application_id and
fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and
fdfc.enabled_flag = 'Y' and
fdfcuv.application_id = fdfc.application_id and
fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and
fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and
fdfcuv.enabled_flag = 'Y' and
fdfv.application_id = 401 and
fdfv.descriptive_flexfield_name = 'MTL_SECONDARY_INVENTORIES' and
fdfcuv.application_column_name = 'ATTRIBUTE7'57SUB_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_SECONDARY_INVENTORIES',
p_context_name=>:$column$.attribute_category,
p_column_name=>'ATTRIBUTE8',
p_attribute1=>:$column$.sub_attribute1,
p_attribute2=>:$column$.sub_attribute2,
p_attribute3=>:$column$.sub_attribute3,
p_attribute4=>:$column$.sub_attribute4,
p_attribute5=>:$column$.sub_attribute5,
p_attribute6=>:$column$.sub_attribute6,
p_attribute7=>:$column$.sub_attribute7,
p_attribute8=>:$column$.sub_attribute8,
p_attribute9=>:$column$.sub_attribute9,
p_attribute10=>:$column$.sub_attribute10,
p_attribute11=>:$column$.sub_attribute11,
p_attribute12=>:$column$.sub_attribute12,
p_attribute13=>:$column$.sub_attribute13,
p_attribute14=>:$column$.sub_attribute14,
p_attribute15=>:$column$.sub_attribute15
)
) lovselect distinct
'(Context) ' || initcap(fdfcuv.application_column_name) || ': ' ||
listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name)
from
fnd_descriptive_flexs_vl fdfv,
fnd_descr_flex_contexts fdfc,
fnd_descr_flex_col_usage_vl fdfcuv
where
fdfc.application_id = fdfv.application_id and
fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and
fdfc.enabled_flag = 'Y' and
fdfcuv.application_id = fdfc.application_id and
fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and
fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and
fdfcuv.enabled_flag = 'Y' and
fdfv.application_id = 401 and
fdfv.descriptive_flexfield_name = 'MTL_SECONDARY_INVENTORIES' and
fdfcuv.application_column_name = 'ATTRIBUTE8'58SUB_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_SECONDARY_INVENTORIES',
p_context_name=>:$column$.attribute_category,
p_column_name=>'ATTRIBUTE9',
p_attribute1=>:$column$.sub_attribute1,
p_attribute2=>:$column$.sub_attribute2,
p_attribute3=>:$column$.sub_attribute3,
p_attribute4=>:$column$.sub_attribute4,
p_attribute5=>:$column$.sub_attribute5,
p_attribute6=>:$column$.sub_attribute6,
p_attribute7=>:$column$.sub_attribute7,
p_attribute8=>:$column$.sub_attribute8,
p_attribute9=>:$column$.sub_attribute9,
p_attribute10=>:$column$.sub_attribute10,
p_attribute11=>:$column$.sub_attribute11,
p_attribute12=>:$column$.sub_attribute12,
p_attribute13=>:$column$.sub_attribute13,
p_attribute14=>:$column$.sub_attribute14,
p_attribute15=>:$column$.sub_attribute15
)
) lovselect distinct
'(Context) ' || initcap(fdfcuv.application_column_name) || ': ' ||
listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name)
from
fnd_descriptive_flexs_vl fdfv,
fnd_descr_flex_contexts fdfc,
fnd_descr_flex_col_usage_vl fdfcuv
where
fdfc.application_id = fdfv.application_id and
fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and
fdfc.enabled_flag = 'Y' and
fdfcuv.application_id = fdfc.application_id and
fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and
fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and
fdfcuv.enabled_flag = 'Y' and
fdfv.application_id = 401 and
fdfv.descriptive_flexfield_name = 'MTL_SECONDARY_INVENTORIES' and
fdfcuv.application_column_name = 'ATTRIBUTE9'59SUB_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_SECONDARY_INVENTORIES',
p_context_name=>:$column$.attribute_category,
p_column_name=>'ATTRIBUTE10',
p_attribute1=>:$column$.sub_attribute1,
p_attribute2=>:$column$.sub_attribute2,
p_attribute3=>:$column$.sub_attribute3,
p_attribute4=>:$column$.sub_attribute4,
p_attribute5=>:$column$.sub_attribute5,
p_attribute6=>:$column$.sub_attribute6,
p_attribute7=>:$column$.sub_attribute7,
p_attribute8=>:$column$.sub_attribute8,
p_attribute9=>:$column$.sub_attribute9,
p_attribute10=>:$column$.sub_attribute10,
p_attribute11=>:$column$.sub_attribute11,
p_attribute12=>:$column$.sub_attribute12,
p_attribute13=>:$column$.sub_attribute13,
p_attribute14=>:$column$.sub_attribute14,
p_attribute15=>:$column$.sub_attribute15
)
) lovselect distinct
'(Context) ' || initcap(fdfcuv.application_column_name) || ': ' ||
listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name)
from
fnd_descriptive_flexs_vl fdfv,
fnd_descr_flex_contexts fdfc,
fnd_descr_flex_col_usage_vl fdfcuv
where
fdfc.application_id = fdfv.application_id and
fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and
fdfc.enabled_flag = 'Y' and
fdfcuv.application_id = fdfc.application_id and
fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and
fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and
fdfcuv.enabled_flag = 'Y' and
fdfv.application_id = 401 and
fdfv.descriptive_flexfield_name = 'MTL_SECONDARY_INVENTORIES' and
fdfcuv.application_column_name = 'ATTRIBUTE10'60SUB_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_SECONDARY_INVENTORIES',
p_context_name=>:$column$.attribute_category,
p_column_name=>'ATTRIBUTE11',
p_attribute1=>:$column$.sub_attribute1,
p_attribute2=>:$column$.sub_attribute2,
p_attribute3=>:$column$.sub_attribute3,
p_attribute4=>:$column$.sub_attribute4,
p_attribute5=>:$column$.sub_attribute5,
p_attribute6=>:$column$.sub_attribute6,
p_attribute7=>:$column$.sub_attribute7,
p_attribute8=>:$column$.sub_attribute8,
p_attribute9=>:$column$.sub_attribute9,
p_attribute10=>:$column$.sub_attribute10,
p_attribute11=>:$column$.sub_attribute11,
p_attribute12=>:$column$.sub_attribute12,
p_attribute13=>:$column$.sub_attribute13,
p_attribute14=>:$column$.sub_attribute14,
p_attribute15=>:$column$.sub_attribute15
)
) lovselect distinct
'(Context) ' || initcap(fdfcuv.application_column_name) || ': ' ||
listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name)
from
fnd_descriptive_flexs_vl fdfv,
fnd_descr_flex_contexts fdfc,
fnd_descr_flex_col_usage_vl fdfcuv
where
fdfc.application_id = fdfv.application_id and
fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and
fdfc.enabled_flag = 'Y' and
fdfcuv.application_id = fdfc.application_id and
fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and
fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and
fdfcuv.enabled_flag = 'Y' and
fdfv.application_id = 401 and
fdfv.descriptive_flexfield_name = 'MTL_SECONDARY_INVENTORIES' and
fdfcuv.application_column_name = 'ATTRIBUTE11'61SUB_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_SECONDARY_INVENTORIES',
p_context_name=>:$column$.attribute_category,
p_column_name=>'ATTRIBUTE12',
p_attribute1=>:$column$.sub_attribute1,
p_attribute2=>:$column$.sub_attribute2,
p_attribute3=>:$column$.sub_attribute3,
p_attribute4=>:$column$.sub_attribute4,
p_attribute5=>:$column$.sub_attribute5,
p_attribute6=>:$column$.sub_attribute6,
p_attribute7=>:$column$.sub_attribute7,
p_attribute8=>:$column$.sub_attribute8,
p_attribute9=>:$column$.sub_attribute9,
p_attribute10=>:$column$.sub_attribute10,
p_attribute11=>:$column$.sub_attribute11,
p_attribute12=>:$column$.sub_attribute12,
p_attribute13=>:$column$.sub_attribute13,
p_attribute14=>:$column$.sub_attribute14,
p_attribute15=>:$column$.sub_attribute15
)
) lovselect distinct
'(Context) ' || initcap(fdfcuv.application_column_name) || ': ' ||
listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name)
from
fnd_descriptive_flexs_vl fdfv,
fnd_descr_flex_contexts fdfc,
fnd_descr_flex_col_usage_vl fdfcuv
where
fdfc.application_id = fdfv.application_id and
fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and
fdfc.enabled_flag = 'Y' and
fdfcuv.application_id = fdfc.application_id and
fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and
fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and
fdfcuv.enabled_flag = 'Y' and
fdfv.application_id = 401 and
fdfv.descriptive_flexfield_name = 'MTL_SECONDARY_INVENTORIES' and
fdfcuv.application_column_name = 'ATTRIBUTE12'62SUB_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_SECONDARY_INVENTORIES',
p_context_name=>:$column$.attribute_category,
p_column_name=>'ATTRIBUTE13',
p_attribute1=>:$column$.sub_attribute1,
p_attribute2=>:$column$.sub_attribute2,
p_attribute3=>:$column$.sub_attribute3,
p_attribute4=>:$column$.sub_attribute4,
p_attribute5=>:$column$.sub_attribute5,
p_attribute6=>:$column$.sub_attribute6,
p_attribute7=>:$column$.sub_attribute7,
p_attribute8=>:$column$.sub_attribute8,
p_attribute9=>:$column$.sub_attribute9,
p_attribute10=>:$column$.sub_attribute10,
p_attribute11=>:$column$.sub_attribute11,
p_attribute12=>:$column$.sub_attribute12,
p_attribute13=>:$column$.sub_attribute13,
p_attribute14=>:$column$.sub_attribute14,
p_attribute15=>:$column$.sub_attribute15
)
) lovselect distinct
'(Context) ' || initcap(fdfcuv.application_column_name) || ': ' ||
listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name)
from
fnd_descriptive_flexs_vl fdfv,
fnd_descr_flex_contexts fdfc,
fnd_descr_flex_col_usage_vl fdfcuv
where
fdfc.application_id = fdfv.application_id and
fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and
fdfc.enabled_flag = 'Y' and
fdfcuv.application_id = fdfc.application_id and
fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and
fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and
fdfcuv.enabled_flag = 'Y' and
fdfv.application_id = 401 and
fdfv.descriptive_flexfield_name = 'MTL_SECONDARY_INVENTORIES' and
fdfcuv.application_column_name = 'ATTRIBUTE13'63SUB_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_SECONDARY_INVENTORIES',
p_context_name=>:$column$.attribute_category,
p_column_name=>'ATTRIBUTE14',
p_attribute1=>:$column$.sub_attribute1,
p_attribute2=>:$column$.sub_attribute2,
p_attribute3=>:$column$.sub_attribute3,
p_attribute4=>:$column$.sub_attribute4,
p_attribute5=>:$column$.sub_attribute5,
p_attribute6=>:$column$.sub_attribute6,
p_attribute7=>:$column$.sub_attribute7,
p_attribute8=>:$column$.sub_attribute8,
p_attribute9=>:$column$.sub_attribute9,
p_attribute10=>:$column$.sub_attribute10,
p_attribute11=>:$column$.sub_attribute11,
p_attribute12=>:$column$.sub_attribute12,
p_attribute13=>:$column$.sub_attribute13,
p_attribute14=>:$column$.sub_attribute14,
p_attribute15=>:$column$.sub_attribute15
)
) lovselect distinct
'(Context) ' || initcap(fdfcuv.application_column_name) || ': ' ||
listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name)
from
fnd_descriptive_flexs_vl fdfv,
fnd_descr_flex_contexts fdfc,
fnd_descr_flex_col_usage_vl fdfcuv
where
fdfc.application_id = fdfv.application_id and
fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and
fdfc.enabled_flag = 'Y' and
fdfcuv.application_id = fdfc.application_id and
fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and
fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and
fdfcuv.enabled_flag = 'Y' and
fdfv.application_id = 401 and
fdfv.descriptive_flexfield_name = 'MTL_SECONDARY_INVENTORIES' and
fdfcuv.application_column_name = 'ATTRIBUTE14'64SUB_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_SECONDARY_INVENTORIES',
p_context_name=>:$column$.attribute_category,
p_column_name=>'ATTRIBUTE15',
p_attribute1=>:$column$.sub_attribute1,
p_attribute2=>:$column$.sub_attribute2,
p_attribute3=>:$column$.sub_attribute3,
p_attribute4=>:$column$.sub_attribute4,
p_attribute5=>:$column$.sub_attribute5,
p_attribute6=>:$column$.sub_attribute6,
p_attribute7=>:$column$.sub_attribute7,
p_attribute8=>:$column$.sub_attribute8,
p_attribute9=>:$column$.sub_attribute9,
p_attribute10=>:$column$.sub_attribute10,
p_attribute11=>:$column$.sub_attribute11,
p_attribute12=>:$column$.sub_attribute12,
p_attribute13=>:$column$.sub_attribute13,
p_attribute14=>:$column$.sub_attribute14,
p_attribute15=>:$column$.sub_attribute15
)
) lovselect distinct
'(Context) ' || initcap(fdfcuv.application_column_name) || ': ' ||
listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name)
from
fnd_descriptive_flexs_vl fdfv,
fnd_descr_flex_contexts fdfc,
fnd_descr_flex_col_usage_vl fdfcuv
where
fdfc.application_id = fdfv.application_id and
fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and
fdfc.enabled_flag = 'Y' and
fdfcuv.application_id = fdfc.application_id and
fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and
fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and
fdfcuv.enabled_flag = 'Y' and
fdfv.application_id = 401 and
fdfv.descriptive_flexfield_name = 'MTL_SECONDARY_INVENTORIES' and
fdfcuv.application_column_name = 'ATTRIBUTE15'65UPLOAD_ROWNumbernumberYU1action_inCharACTION_CODE_U2status_outCharSTATUS_CODE_U3message_outCharMESSAGE_U5p_organization_idinNumberORGANIZATION_CODEidU7p_secondary_inventory_nameinCharNAMEU8p_descriptioninCharDESCRIPTIONU9p_status_codeinNumberSTATUSU10p_default_cost_group_idinNumberDEFAULT_COST_GROUPU11p_subinventory_typeinNumberTYPEU12p_inventory_atp_codeinNumberINCLUDE_IN_ATPU13p_reservable_typeinNumberALLOW_RESERVATIONU14p_availability_typeinNumberNETTABLEU15p_quantity_trackedinNumberQUANTITY_TRACKEDU16p_asset_inventoryinNumberASSET_SUBINVENTORYU17p_depreciable_flaginNumberDEPRECIABLEU18p_planning_levelinNumberENABLE_PAR_LEVEL_PLANNINGU19p_enable_locator_aliasinCharENABLE_LOCATOR_ALIASU20p_enforce_alias_uniquenessinCharENFORCE_ALIAS_UNIQUENESSU21p_locator_typeinNumberLOCATOR_CONTROLU22p_default_loc_status_codeinNumberDEFAULT_LOCATOR_STATUSU23p_picking_orderinNumberPICKING_ORDERU24p_dropping_orderinNumberDROPPING_ORDERU25p_disable_dateinDateINACTIVE_ONU26p_notify_listinNumberNOTIFYU27p_location_codeinNumberLOCATIONU28p_pick_uom_codeinCharPICKING_UOMU29p_default_count_type_codeinNumberDEFAULT_REPLENISHMENT_COUNT_TYPEU30p_source_typeinNumberSOURCE_TYPEU31p_source_organization_codeinNumberSOURCE_ORGANIZATIONU32p_source_subinventoryinCharSOURCE_SUBINVENTORYU33p_preprocessing_lead_timeinNumberPRE_PROCESSING_LTU34p_processing_lead_timeinNumberPROCESSING_LTU35p_postprocessing_lead_timeinNumberPOST_PROCESSING_LTU36p_material_accountinNumberMATERIALU37p_outside_processing_accountinNumberOUTSIDE_PROCESSINGU38p_material_overhead_accountinNumberMATERIAL_OVERHEADU39p_overhead_accountinNumberOVERHEADU40p_resource_accountinNumberRESOURCE_ACCOUNTU41p_expense_accountinNumberEXPENSEU42p_encumbrance_accountinNumberENCUMBRANCEU43p_lpn_controlled_flaginNumberLPN_CONTROLLEDU44p_cartonization_flaginNumberENABLE_CARTONIZATIONU45p_enable_bulk_pickinCharENABLE_BULK_PICKU46p_enable_opp_cyc_count_flaginCharENABLE_OPPORTUNISTIC_CYCLE_COUNTU47p_opp_cyc_count_header_nameinNumberOPPORTUNISTIC_CYCLE_COUNT_HEADERU48p_opp_cyc_count_quantityinNumberOPPORTUNISTIC_CYCLE_COUNT_TRIGGER_QUANTITYU49p_opp_cyc_count_daysinNumberOPPORTUNISTIC_CYCLE_COUNT_DAYS_THRESHOLDU50p_attribute_categoryinCharATTRIBUTE_CATEGORYU51p_sub_attribute1inCharSUB_ATTRIBUTE1U52p_sub_attribute2inCharSUB_ATTRIBUTE2U53p_sub_attribute3inCharSUB_ATTRIBUTE3U54p_sub_attribute4inCharSUB_ATTRIBUTE4U55p_sub_attribute5inCharSUB_ATTRIBUTE5U56p_sub_attribute6inCharSUB_ATTRIBUTE6U57p_sub_attribute7inCharSUB_ATTRIBUTE7U58p_sub_attribute8inCharSUB_ATTRIBUTE8U59p_sub_attribute9inCharSUB_ATTRIBUTE9U60p_sub_attribute10inCharSUB_ATTRIBUTE10U61p_sub_attribute11inCharSUB_ATTRIBUTE11U62p_sub_attribute12inCharSUB_ATTRIBUTE12U63p_sub_attribute13inCharSUB_ATTRIBUTE13U64p_sub_attribute14inCharSUB_ATTRIBUTE14U65p_sub_attribute15inCharSUB_ATTRIBUTE15Error SQLOrder Byupload_row, organization_code, nameSuccess SQLselect
xu.action_,
xu.status_,
xu.message_,
xu.modified_columns_,
mp.organization_code,
msi.secondary_inventory_name name,
msi.description,
mmsv.status_code status,
cg.cost_group default_cost_group,
xxen_util.meaning(msi.subinventory_type,'MTL_SUB_TYPE',700) type,
decode(msi.inventory_atp_code,1,xxen_util.meaning('Y','YES_NO',0)) include_in_atp,
decode(msi.reservable_type,1,xxen_util.meaning('Y','YES_NO',0)) allow_reservation,
decode(msi.availability_type,1,xxen_util.meaning('Y','YES_NO',0)) nettable,
decode(msi.quantity_tracked,1,xxen_util.meaning('Y','YES_NO',0)) quantity_tracked,
decode(msi.asset_inventory,1,xxen_util.meaning('Y','YES_NO',0)) asset_subinventory,
decode(msi.depreciable_flag,1,xxen_util.meaning('Y','YES_NO',0)) depreciable,
decode(msi.planning_level,1,xxen_util.meaning('Y','YES_NO',0)) enable_par_level_planning,
xxen_util.meaning(to_char(msi.locator_type),'MTL_LOCATION_CONTROL',700) locator_control,
mmsv_loc.status_code default_locator_status,
decode(msi.enable_locator_alias,'Y',xxen_util.meaning('Y','YES_NO',0)) enable_locator_alias,
decode(msi.enforce_alias_uniqueness,'Y',xxen_util.meaning('Y','YES_NO',0)) enforce_alias_uniqueness,
msi.picking_order,
msi.dropping_order,
case
when msi.subinventory_type=2 and trunc(msi.disable_date)=to_date('01-01-1700','dd-mm-yyyy') then null
when msi.subinventory_type=2 then msi.disable_date+300*365
else msi.disable_date
end inactive_on,
eeal.approval_list_name notify,
hl.location_code location,
msi.pick_uom_code picking_uom,
xxen_util.meaning(to_char(msi.default_count_type_code),'MTL_COUNT_TYPES',700) default_replenishment_count_type,
xxen_util.meaning(to_char(msi.source_type),'MTL_SOURCE_TYPES',700) source_type,
mp_src.organization_code source_organization,
msi.source_subinventory,
msi.preprocessing_lead_time pre_processing_lt,
msi.processing_lead_time processing_lt,
msi.postprocessing_lead_time post_processing_lt,
gcck_mat.concatenated_segments material,
gcck_op.concatenated_segments outside_processing,
gcck_mo.concatenated_segments material_overhead,
gcck_oh.concatenated_segments overhead,
gcck_res.concatenated_segments resource_account,
gcck_exp.concatenated_segments expense,
gcck_enc.concatenated_segments encumbrance,
decode(msi.lpn_controlled_flag,1,xxen_util.meaning('Y','YES_NO',0)) lpn_controlled,
decode(msi.cartonization_flag,1,xxen_util.meaning('Y','YES_NO',0)) enable_cartonization,
decode(msi.enable_bulk_pick,'Y',xxen_util.meaning('Y','YES_NO',0)) enable_bulk_pick,
decode(msi.enable_opp_cyc_count,'Y',xxen_util.meaning('Y','YES_NO',0)) enable_opportunistic_cycle_count,
mcch.cycle_count_header_name opportunistic_cycle_count_header,
msi.opp_cyc_count_quantity opportunistic_cycle_count_trigger_quantity,
msi.opp_cyc_count_days opportunistic_cycle_count_days_threshold,
xxen_util.display_flexfield_context(401,'MTL_SECONDARY_INVENTORIES',msi.attribute_category) attribute_category,
xxen_util.display_flexfield_value(401,'MTL_SECONDARY_INVENTORIES',msi.attribute_category,'ATTRIBUTE1',msi.rowid,msi.attribute1) sub_attribute1,
xxen_util.display_flexfield_value(401,'MTL_SECONDARY_INVENTORIES',msi.attribute_category,'ATTRIBUTE2',msi.rowid,msi.attribute2) sub_attribute2,
xxen_util.display_flexfield_value(401,'MTL_SECONDARY_INVENTORIES',msi.attribute_category,'ATTRIBUTE3',msi.rowid,msi.attribute3) sub_attribute3,
xxen_util.display_flexfield_value(401,'MTL_SECONDARY_INVENTORIES',msi.attribute_category,'ATTRIBUTE4',msi.rowid,msi.attribute4) sub_attribute4,
xxen_util.display_flexfield_value(401,'MTL_SECONDARY_INVENTORIES',msi.attribute_category,'ATTRIBUTE5',msi.rowid,msi.attribute5) sub_attribute5,
xxen_util.display_flexfield_value(401,'MTL_SECONDARY_INVENTORIES',msi.attribute_category,'ATTRIBUTE6',msi.rowid,msi.attribute6) sub_attribute6,
xxen_util.display_flexfield_value(401,'MTL_SECONDARY_INVENTORIES',msi.attribute_category,'ATTRIBUTE7',msi.rowid,msi.attribute7) sub_attribute7,
xxen_util.display_flexfield_value(401,'MTL_SECONDARY_INVENTORIES',msi.attribute_category,'ATTRIBUTE8',msi.rowid,msi.attribute8) sub_attribute8,
xxen_util.display_flexfield_value(401,'MTL_SECONDARY_INVENTORIES',msi.attribute_category,'ATTRIBUTE9',msi.rowid,msi.attribute9) sub_attribute9,
xxen_util.display_flexfield_value(401,'MTL_SECONDARY_INVENTORIES',msi.attribute_category,'ATTRIBUTE10',msi.rowid,msi.attribute10) sub_attribute10,
xxen_util.display_flexfield_value(401,'MTL_SECONDARY_INVENTORIES',msi.attribute_category,'ATTRIBUTE11',msi.rowid,msi.attribute11) sub_attribute11,
xxen_util.display_flexfield_value(401,'MTL_SECONDARY_INVENTORIES',msi.attribute_category,'ATTRIBUTE12',msi.rowid,msi.attribute12) sub_attribute12,
xxen_util.display_flexfield_value(401,'MTL_SECONDARY_INVENTORIES',msi.attribute_category,'ATTRIBUTE13',msi.rowid,msi.attribute13) sub_attribute13,
xxen_util.display_flexfield_value(401,'MTL_SECONDARY_INVENTORIES',msi.attribute_category,'ATTRIBUTE14',msi.rowid,msi.attribute14) sub_attribute14,
xxen_util.display_flexfield_value(401,'MTL_SECONDARY_INVENTORIES',msi.attribute_category,'ATTRIBUTE15',msi.rowid,msi.attribute15) sub_attribute15,
xu.upload_row
from
xxen_inv_subinventory_u_3646_u xu,
mtl_secondary_inventories msi,
mtl_parameters mp,
mtl_material_statuses_vl mmsv,
cst_cost_groups cg,
mtl_material_statuses_vl mmsv_loc,
eng_ecn_approval_lists eeal,
hr_locations hl,
mtl_parameters mp_src,
mtl_cycle_count_headers mcch,
gl_code_combinations_kfv gcck_mat,
gl_code_combinations_kfv gcck_op,
gl_code_combinations_kfv gcck_mo,
gl_code_combinations_kfv gcck_oh,
gl_code_combinations_kfv gcck_res,
gl_code_combinations_kfv gcck_exp,
gl_code_combinations_kfv gcck_enc
where
xu.status_code_=xxen_upload.status_success and
mp.organization_code=xu.organization_code and
msi.organization_id=mp.organization_id and
msi.secondary_inventory_name=xu.name and
mmsv.status_id(+)=msi.status_id and
cg.cost_group_id(+)=msi.default_cost_group_id and
mmsv_loc.status_id(+)=msi.default_loc_status_id and
eeal.approval_list_id(+)=msi.notify_list_id and
hl.location_id(+)=msi.location_id and
mp_src.organization_id(+)=msi.source_organization_id and
mcch.cycle_count_header_id(+)=msi.opp_cyc_count_header_id and
gcck_mat.code_combination_id(+)=msi.material_account and
gcck_op.code_combination_id(+)=msi.outside_processing_account and
gcck_mo.code_combination_id(+)=msi.material_overhead_account and
gcck_oh.code_combination_id(+)=msi.overhead_account and
gcck_res.code_combination_id(+)=msi.resource_account and
gcck_exp.code_combination_id(+)=msi.expense_account and
gcck_enc.code_combination_id(+)=msi.encumbrance_accountLOV query:$column$.statusSTATUSALLOW_RESERVATIONDefault value:$column$.statusSTATUSALLOW_RESERVATIONDefault value:$column$.nameNAMEASSET_SUBINVENTORYDefault value:$column$.organization_codeORGANIZATION_CODEASSET_SUBINVENTORYLOV query:$column$.quantity_trackedQUANTITY_TRACKEDASSET_SUBINVENTORYLOV query:$column$.typeTYPEASSET_SUBINVENTORYDefault value:$column$.typeTYPEASSET_SUBINVENTORYLOV query:$column$.nameNAMEDEFAULT_COST_GROUPDefault value:$column$.nameNAMEDEFAULT_COST_GROUPDefault value:$column$.organization_codeORGANIZATION_CODEDEFAULT_COST_GROUPLOV query:$column$.organization_codeORGANIZATION_CODEDEFAULT_COST_GROUPDefault value:$column$.locator_controlLOCATOR_CONTROLDEFAULT_LOCATOR_STATUSLOV query:$column$.locator_controlLOCATOR_CONTROLDEFAULT_LOCATOR_STATUSLOV query:$column$.organization_codeORGANIZATION_CODEDEFAULT_LOCATOR_STATUSDefault value:$column$.organization_codeORGANIZATION_CODEDEFAULT_LOCATOR_STATUSLOV query:$column$.typeTYPEDEFAULT_LOCATOR_STATUSLOV query:$column$.enable_par_level_planningENABLE_PAR_LEVEL_PLANNINGDEFAULT_REPLENISHMENT_COUNT_TYPELOV query:$column$.quantity_trackedQUANTITY_TRACKEDDEFAULT_REPLENISHMENT_COUNT_TYPELOV query:$column$.typeTYPEDEFAULT_REPLENISHMENT_COUNT_TYPELOV query:$column$.quantity_trackedQUANTITY_TRACKEDDEPRECIABLELOV query:$column$.typeTYPEDEPRECIABLELOV query:$column$.organization_codeORGANIZATION_CODEENABLE_BULK_PICKLOV query:$column$.organization_codeORGANIZATION_CODEENABLE_CARTONIZATIONLOV query:$column$.locator_controlLOCATOR_CONTROLENABLE_LOCATOR_ALIASLOV query:$column$.organization_codeORGANIZATION_CODEENABLE_LOCATOR_ALIASLOV query:$column$.organization_codeORGANIZATION_CODEENABLE_OPPORTUNISTIC_CYCLE_COUNTLOV query:$column$.typeTYPEENABLE_PAR_LEVEL_PLANNINGLOV query:$column$.default_cost_groupDEFAULT_COST_GROUPENCUMBRANCEDefault value:$column$.default_cost_groupDEFAULT_COST_GROUPENCUMBRANCELOV query:$column$.nameNAMEENCUMBRANCEDefault value:$column$.nameNAMEENCUMBRANCELOV query:$column$.organization_codeORGANIZATION_CODEENCUMBRANCEDefault value:$column$.organization_codeORGANIZATION_CODEENCUMBRANCELOV query:$column$.enable_locator_aliasENABLE_LOCATOR_ALIASENFORCE_ALIAS_UNIQUENESSLOV query:$column$.default_cost_groupDEFAULT_COST_GROUPEXPENSEDefault value:$column$.default_cost_groupDEFAULT_COST_GROUPEXPENSEDefault value:$column$.nameNAMEEXPENSELOV query:$column$.nameNAMEEXPENSEDefault value:$column$.organization_codeORGANIZATION_CODEEXPENSELOV query:$column$.organization_codeORGANIZATION_CODEEXPENSEDefault value:$column$.statusSTATUSINCLUDE_IN_ATPLOV query:$column$.statusSTATUSINCLUDE_IN_ATPLOV query:$column$.organization_codeORGANIZATION_CODELOCATIONLOV query:$column$.typeTYPELOCATIONDefault value:$column$.nameNAMELOCATOR_CONTROLDefault value:$column$.organization_codeORGANIZATION_CODELOCATOR_CONTROLLOV query:$column$.organization_codeORGANIZATION_CODELOCATOR_CONTROLDefault value:$column$.nameNAMELPN_CONTROLLEDDefault value:$column$.organization_codeORGANIZATION_CODELPN_CONTROLLEDLOV query:$column$.organization_codeORGANIZATION_CODELPN_CONTROLLEDLOV query:$column$.typeTYPELPN_CONTROLLEDDefault value:$column$.default_cost_groupDEFAULT_COST_GROUPMATERIALLOV query:$column$.default_cost_groupDEFAULT_COST_GROUPMATERIALLOV query:$column$.nameNAMEMATERIALDefault value:$column$.nameNAMEMATERIALLOV query:$column$.organization_codeORGANIZATION_CODEMATERIALDefault value:$column$.organization_codeORGANIZATION_CODEMATERIALLOV query:$column$.default_cost_groupDEFAULT_COST_GROUPMATERIAL_OVERHEADDefault value:$column$.default_cost_groupDEFAULT_COST_GROUPMATERIAL_OVERHEADDefault value:$column$.nameNAMEMATERIAL_OVERHEADLOV query:$column$.nameNAMEMATERIAL_OVERHEADLOV query:$column$.organization_codeORGANIZATION_CODEMATERIAL_OVERHEADDefault value:$column$.organization_codeORGANIZATION_CODEMATERIAL_OVERHEADDefault value:$column$.statusSTATUSNETTABLELOV query:$column$.statusSTATUSNETTABLELOV query:$column$.organization_codeORGANIZATION_CODEOPPORTUNISTIC_CYCLE_COUNT_HEADERDefault value:$column$.default_cost_groupDEFAULT_COST_GROUPOUTSIDE_PROCESSINGLOV query:$column$.default_cost_groupDEFAULT_COST_GROUPOUTSIDE_PROCESSINGLOV query:$column$.nameNAMEOUTSIDE_PROCESSINGDefault value:$column$.nameNAMEOUTSIDE_PROCESSINGLOV query:$column$.organization_codeORGANIZATION_CODEOUTSIDE_PROCESSINGDefault value:$column$.organization_codeORGANIZATION_CODEOUTSIDE_PROCESSINGLOV query:$column$.default_cost_groupDEFAULT_COST_GROUPOVERHEADDefault value:$column$.default_cost_groupDEFAULT_COST_GROUPOVERHEADLOV query:$column$.nameNAMEOVERHEADDefault value:$column$.nameNAMEOVERHEADDefault value:$column$.organization_codeORGANIZATION_CODEOVERHEADLOV query:$column$.organization_codeORGANIZATION_CODEOVERHEADLOV query:$column$.typeTYPEPICKING_UOMDefault value:$column$.nameNAMEQUANTITY_TRACKEDDefault value:$column$.organization_codeORGANIZATION_CODEQUANTITY_TRACKEDLOV query:$column$.statusSTATUSQUANTITY_TRACKEDLOV query:$column$.typeTYPEQUANTITY_TRACKEDDefault value:$column$.typeTYPEQUANTITY_TRACKEDDefault value:$column$.default_cost_groupDEFAULT_COST_GROUPRESOURCE_ACCOUNTLOV query:$column$.default_cost_groupDEFAULT_COST_GROUPRESOURCE_ACCOUNTLOV query:$column$.nameNAMERESOURCE_ACCOUNTDefault value:$column$.nameNAMERESOURCE_ACCOUNTLOV query:$column$.organization_codeORGANIZATION_CODERESOURCE_ACCOUNTDefault value:$column$.organization_codeORGANIZATION_CODERESOURCE_ACCOUNTDefault value:$column$.organization_codeORGANIZATION_CODESOURCE_ORGANIZATIONLOV query:$column$.organization_codeORGANIZATION_CODESOURCE_ORGANIZATIONDefault value:$column$.source_typeSOURCE_TYPESOURCE_ORGANIZATIONLOV query:$column$.source_typeSOURCE_TYPESOURCE_ORGANIZATIONLOV query:$column$.source_organizationSOURCE_ORGANIZATIONSOURCE_SUBINVENTORYLOV query:$column$.source_typeSOURCE_TYPESOURCE_SUBINVENTORYLOV query:$column$.typeTYPESOURCE_TYPELOV query:$column$.typeTYPESTATUSLOV query:$column$.attribute_categoryATTRIBUTE_CATEGORYSUB_ATTRIBUTE1LOV query:$column$.sub_attribute1SUB_ATTRIBUTE1SUB_ATTRIBUTE1LOV query:$column$.sub_attribute10SUB_ATTRIBUTE10SUB_ATTRIBUTE1LOV query:$column$.sub_attribute11SUB_ATTRIBUTE11SUB_ATTRIBUTE1LOV query:$column$.sub_attribute12SUB_ATTRIBUTE12SUB_ATTRIBUTE1LOV query:$column$.sub_attribute13SUB_ATTRIBUTE13SUB_ATTRIBUTE1LOV query:$column$.sub_attribute14SUB_ATTRIBUTE14SUB_ATTRIBUTE1LOV query:$column$.sub_attribute15SUB_ATTRIBUTE15SUB_ATTRIBUTE1LOV query:$column$.sub_attribute2SUB_ATTRIBUTE2SUB_ATTRIBUTE1LOV query:$column$.sub_attribute3SUB_ATTRIBUTE3SUB_ATTRIBUTE1LOV query:$column$.sub_attribute4SUB_ATTRIBUTE4SUB_ATTRIBUTE1LOV query:$column$.sub_attribute5SUB_ATTRIBUTE5SUB_ATTRIBUTE1LOV query:$column$.sub_attribute6SUB_ATTRIBUTE6SUB_ATTRIBUTE1LOV query:$column$.sub_attribute7SUB_ATTRIBUTE7SUB_ATTRIBUTE1LOV query:$column$.sub_attribute8SUB_ATTRIBUTE8SUB_ATTRIBUTE1LOV query:$column$.sub_attribute9SUB_ATTRIBUTE9SUB_ATTRIBUTE1LOV query:$column$.attribute_categoryATTRIBUTE_CATEGORYSUB_ATTRIBUTE10LOV query:$column$.sub_attribute1SUB_ATTRIBUTE1SUB_ATTRIBUTE10LOV query:$column$.sub_attribute10SUB_ATTRIBUTE10SUB_ATTRIBUTE10LOV query:$column$.sub_attribute11SUB_ATTRIBUTE11SUB_ATTRIBUTE10LOV query:$column$.sub_attribute12SUB_ATTRIBUTE12SUB_ATTRIBUTE10LOV query:$column$.sub_attribute13SUB_ATTRIBUTE13SUB_ATTRIBUTE10LOV query:$column$.sub_attribute14SUB_ATTRIBUTE14SUB_ATTRIBUTE10LOV query:$column$.sub_attribute15SUB_ATTRIBUTE15SUB_ATTRIBUTE10LOV query:$column$.sub_attribute2SUB_ATTRIBUTE2SUB_ATTRIBUTE10LOV query:$column$.sub_attribute3SUB_ATTRIBUTE3SUB_ATTRIBUTE10LOV query:$column$.sub_attribute4SUB_ATTRIBUTE4SUB_ATTRIBUTE10LOV query:$column$.sub_attribute5SUB_ATTRIBUTE5SUB_ATTRIBUTE10LOV query:$column$.sub_attribute6SUB_ATTRIBUTE6SUB_ATTRIBUTE10LOV query:$column$.sub_attribute7SUB_ATTRIBUTE7SUB_ATTRIBUTE10LOV query:$column$.sub_attribute8SUB_ATTRIBUTE8SUB_ATTRIBUTE10LOV query:$column$.sub_attribute9SUB_ATTRIBUTE9SUB_ATTRIBUTE10LOV query:$column$.attribute_categoryATTRIBUTE_CATEGORYSUB_ATTRIBUTE11LOV query:$column$.sub_attribute1SUB_ATTRIBUTE1SUB_ATTRIBUTE11LOV query:$column$.sub_attribute10SUB_ATTRIBUTE10SUB_ATTRIBUTE11LOV query:$column$.sub_attribute11SUB_ATTRIBUTE11SUB_ATTRIBUTE11LOV query:$column$.sub_attribute12SUB_ATTRIBUTE12SUB_ATTRIBUTE11LOV query:$column$.sub_attribute13SUB_ATTRIBUTE13SUB_ATTRIBUTE11LOV query:$column$.sub_attribute14SUB_ATTRIBUTE14SUB_ATTRIBUTE11LOV query:$column$.sub_attribute15SUB_ATTRIBUTE15SUB_ATTRIBUTE11LOV query:$column$.sub_attribute2SUB_ATTRIBUTE2SUB_ATTRIBUTE11LOV query:$column$.sub_attribute3SUB_ATTRIBUTE3SUB_ATTRIBUTE11LOV query:$column$.sub_attribute4SUB_ATTRIBUTE4SUB_ATTRIBUTE11LOV query:$column$.sub_attribute5SUB_ATTRIBUTE5SUB_ATTRIBUTE11LOV query:$column$.sub_attribute6SUB_ATTRIBUTE6SUB_ATTRIBUTE11LOV query:$column$.sub_attribute7SUB_ATTRIBUTE7SUB_ATTRIBUTE11LOV query:$column$.sub_attribute8SUB_ATTRIBUTE8SUB_ATTRIBUTE11LOV query:$column$.sub_attribute9SUB_ATTRIBUTE9SUB_ATTRIBUTE11LOV query:$column$.attribute_categoryATTRIBUTE_CATEGORYSUB_ATTRIBUTE12LOV query:$column$.sub_attribute1SUB_ATTRIBUTE1SUB_ATTRIBUTE12LOV query:$column$.sub_attribute10SUB_ATTRIBUTE10SUB_ATTRIBUTE12LOV query:$column$.sub_attribute11SUB_ATTRIBUTE11SUB_ATTRIBUTE12LOV query:$column$.sub_attribute12SUB_ATTRIBUTE12SUB_ATTRIBUTE12LOV query:$column$.sub_attribute13SUB_ATTRIBUTE13SUB_ATTRIBUTE12LOV query:$column$.sub_attribute14SUB_ATTRIBUTE14SUB_ATTRIBUTE12LOV query:$column$.sub_attribute15SUB_ATTRIBUTE15SUB_ATTRIBUTE12LOV query:$column$.sub_attribute2SUB_ATTRIBUTE2SUB_ATTRIBUTE12LOV query:$column$.sub_attribute3SUB_ATTRIBUTE3SUB_ATTRIBUTE12LOV query:$column$.sub_attribute4SUB_ATTRIBUTE4SUB_ATTRIBUTE12LOV query:$column$.sub_attribute5SUB_ATTRIBUTE5SUB_ATTRIBUTE12LOV query:$column$.sub_attribute6SUB_ATTRIBUTE6SUB_ATTRIBUTE12LOV query:$column$.sub_attribute7SUB_ATTRIBUTE7SUB_ATTRIBUTE12LOV query:$column$.sub_attribute8SUB_ATTRIBUTE8SUB_ATTRIBUTE12LOV query:$column$.sub_attribute9SUB_ATTRIBUTE9SUB_ATTRIBUTE12LOV query:$column$.attribute_categoryATTRIBUTE_CATEGORYSUB_ATTRIBUTE13LOV query:$column$.sub_attribute1SUB_ATTRIBUTE1SUB_ATTRIBUTE13LOV query:$column$.sub_attribute10SUB_ATTRIBUTE10SUB_ATTRIBUTE13LOV query:$column$.sub_attribute11SUB_ATTRIBUTE11SUB_ATTRIBUTE13LOV query:$column$.sub_attribute12SUB_ATTRIBUTE12SUB_ATTRIBUTE13LOV query:$column$.sub_attribute13SUB_ATTRIBUTE13SUB_ATTRIBUTE13LOV query:$column$.sub_attribute14SUB_ATTRIBUTE14SUB_ATTRIBUTE13LOV query:$column$.sub_attribute15SUB_ATTRIBUTE15SUB_ATTRIBUTE13LOV query:$column$.sub_attribute2SUB_ATTRIBUTE2SUB_ATTRIBUTE13LOV query:$column$.sub_attribute3SUB_ATTRIBUTE3SUB_ATTRIBUTE13LOV query:$column$.sub_attribute4SUB_ATTRIBUTE4SUB_ATTRIBUTE13LOV query:$column$.sub_attribute5SUB_ATTRIBUTE5SUB_ATTRIBUTE13LOV query:$column$.sub_attribute6SUB_ATTRIBUTE6SUB_ATTRIBUTE13LOV query:$column$.sub_attribute7SUB_ATTRIBUTE7SUB_ATTRIBUTE13LOV query:$column$.sub_attribute8SUB_ATTRIBUTE8SUB_ATTRIBUTE13LOV query:$column$.sub_attribute9SUB_ATTRIBUTE9SUB_ATTRIBUTE13LOV query:$column$.attribute_categoryATTRIBUTE_CATEGORYSUB_ATTRIBUTE14LOV query:$column$.sub_attribute1SUB_ATTRIBUTE1SUB_ATTRIBUTE14LOV query:$column$.sub_attribute10SUB_ATTRIBUTE10SUB_ATTRIBUTE14LOV query:$column$.sub_attribute11SUB_ATTRIBUTE11SUB_ATTRIBUTE14LOV query:$column$.sub_attribute12SUB_ATTRIBUTE12SUB_ATTRIBUTE14LOV query:$column$.sub_attribute13SUB_ATTRIBUTE13SUB_ATTRIBUTE14LOV query:$column$.sub_attribute14SUB_ATTRIBUTE14SUB_ATTRIBUTE14LOV query:$column$.sub_attribute15SUB_ATTRIBUTE15SUB_ATTRIBUTE14LOV query:$column$.sub_attribute2SUB_ATTRIBUTE2SUB_ATTRIBUTE14LOV query:$column$.sub_attribute3SUB_ATTRIBUTE3SUB_ATTRIBUTE14LOV query:$column$.sub_attribute4SUB_ATTRIBUTE4SUB_ATTRIBUTE14LOV query:$column$.sub_attribute5SUB_ATTRIBUTE5SUB_ATTRIBUTE14LOV query:$column$.sub_attribute6SUB_ATTRIBUTE6SUB_ATTRIBUTE14LOV query:$column$.sub_attribute7SUB_ATTRIBUTE7SUB_ATTRIBUTE14LOV query:$column$.sub_attribute8SUB_ATTRIBUTE8SUB_ATTRIBUTE14LOV query:$column$.sub_attribute9SUB_ATTRIBUTE9SUB_ATTRIBUTE14LOV query:$column$.attribute_categoryATTRIBUTE_CATEGORYSUB_ATTRIBUTE15LOV query:$column$.sub_attribute1SUB_ATTRIBUTE1SUB_ATTRIBUTE15LOV query:$column$.sub_attribute10SUB_ATTRIBUTE10SUB_ATTRIBUTE15LOV query:$column$.sub_attribute11SUB_ATTRIBUTE11SUB_ATTRIBUTE15LOV query:$column$.sub_attribute12SUB_ATTRIBUTE12SUB_ATTRIBUTE15LOV query:$column$.sub_attribute13SUB_ATTRIBUTE13SUB_ATTRIBUTE15LOV query:$column$.sub_attribute14SUB_ATTRIBUTE14SUB_ATTRIBUTE15LOV query:$column$.sub_attribute15SUB_ATTRIBUTE15SUB_ATTRIBUTE15LOV query:$column$.sub_attribute2SUB_ATTRIBUTE2SUB_ATTRIBUTE15LOV query:$column$.sub_attribute3SUB_ATTRIBUTE3SUB_ATTRIBUTE15LOV query:$column$.sub_attribute4SUB_ATTRIBUTE4SUB_ATTRIBUTE15LOV query:$column$.sub_attribute5SUB_ATTRIBUTE5SUB_ATTRIBUTE15LOV query:$column$.sub_attribute6SUB_ATTRIBUTE6SUB_ATTRIBUTE15LOV query:$column$.sub_attribute7SUB_ATTRIBUTE7SUB_ATTRIBUTE15LOV query:$column$.sub_attribute8SUB_ATTRIBUTE8SUB_ATTRIBUTE15LOV query:$column$.sub_attribute9SUB_ATTRIBUTE9SUB_ATTRIBUTE15LOV query:$column$.attribute_categoryATTRIBUTE_CATEGORYSUB_ATTRIBUTE2LOV query:$column$.sub_attribute1SUB_ATTRIBUTE1SUB_ATTRIBUTE2LOV query:$column$.sub_attribute10SUB_ATTRIBUTE10SUB_ATTRIBUTE2LOV query:$column$.sub_attribute11SUB_ATTRIBUTE11SUB_ATTRIBUTE2LOV query:$column$.sub_attribute12SUB_ATTRIBUTE12SUB_ATTRIBUTE2LOV query:$column$.sub_attribute13SUB_ATTRIBUTE13SUB_ATTRIBUTE2LOV query:$column$.sub_attribute14SUB_ATTRIBUTE14SUB_ATTRIBUTE2LOV query:$column$.sub_attribute15SUB_ATTRIBUTE15SUB_ATTRIBUTE2LOV query:$column$.sub_attribute2SUB_ATTRIBUTE2SUB_ATTRIBUTE2LOV query:$column$.sub_attribute3SUB_ATTRIBUTE3SUB_ATTRIBUTE2LOV query:$column$.sub_attribute4SUB_ATTRIBUTE4SUB_ATTRIBUTE2LOV query:$column$.sub_attribute5SUB_ATTRIBUTE5SUB_ATTRIBUTE2LOV query:$column$.sub_attribute6SUB_ATTRIBUTE6SUB_ATTRIBUTE2LOV query:$column$.sub_attribute7SUB_ATTRIBUTE7SUB_ATTRIBUTE2LOV query:$column$.sub_attribute8SUB_ATTRIBUTE8SUB_ATTRIBUTE2LOV query:$column$.sub_attribute9SUB_ATTRIBUTE9SUB_ATTRIBUTE2LOV query:$column$.attribute_categoryATTRIBUTE_CATEGORYSUB_ATTRIBUTE3LOV query:$column$.sub_attribute1SUB_ATTRIBUTE1SUB_ATTRIBUTE3LOV query:$column$.sub_attribute10SUB_ATTRIBUTE10SUB_ATTRIBUTE3LOV query:$column$.sub_attribute11SUB_ATTRIBUTE11SUB_ATTRIBUTE3LOV query:$column$.sub_attribute12SUB_ATTRIBUTE12SUB_ATTRIBUTE3LOV query:$column$.sub_attribute13SUB_ATTRIBUTE13SUB_ATTRIBUTE3LOV query:$column$.sub_attribute14SUB_ATTRIBUTE14SUB_ATTRIBUTE3LOV query:$column$.sub_attribute15SUB_ATTRIBUTE15SUB_ATTRIBUTE3LOV query:$column$.sub_attribute2SUB_ATTRIBUTE2SUB_ATTRIBUTE3LOV query:$column$.sub_attribute3SUB_ATTRIBUTE3SUB_ATTRIBUTE3LOV query:$column$.sub_attribute4SUB_ATTRIBUTE4SUB_ATTRIBUTE3LOV query:$column$.sub_attribute5SUB_ATTRIBUTE5SUB_ATTRIBUTE3LOV query:$column$.sub_attribute6SUB_ATTRIBUTE6SUB_ATTRIBUTE3LOV query:$column$.sub_attribute7SUB_ATTRIBUTE7SUB_ATTRIBUTE3LOV query:$column$.sub_attribute8SUB_ATTRIBUTE8SUB_ATTRIBUTE3LOV query:$column$.sub_attribute9SUB_ATTRIBUTE9SUB_ATTRIBUTE3LOV query:$column$.attribute_categoryATTRIBUTE_CATEGORYSUB_ATTRIBUTE4LOV query:$column$.sub_attribute1SUB_ATTRIBUTE1SUB_ATTRIBUTE4LOV query:$column$.sub_attribute10SUB_ATTRIBUTE10SUB_ATTRIBUTE4LOV query:$column$.sub_attribute11SUB_ATTRIBUTE11SUB_ATTRIBUTE4LOV query:$column$.sub_attribute12SUB_ATTRIBUTE12SUB_ATTRIBUTE4LOV query:$column$.sub_attribute13SUB_ATTRIBUTE13SUB_ATTRIBUTE4LOV query:$column$.sub_attribute14SUB_ATTRIBUTE14SUB_ATTRIBUTE4LOV query:$column$.sub_attribute15SUB_ATTRIBUTE15SUB_ATTRIBUTE4LOV query:$column$.sub_attribute2SUB_ATTRIBUTE2SUB_ATTRIBUTE4LOV query:$column$.sub_attribute3SUB_ATTRIBUTE3SUB_ATTRIBUTE4LOV query:$column$.sub_attribute4SUB_ATTRIBUTE4SUB_ATTRIBUTE4LOV query:$column$.sub_attribute5SUB_ATTRIBUTE5SUB_ATTRIBUTE4LOV query:$column$.sub_attribute6SUB_ATTRIBUTE6SUB_ATTRIBUTE4LOV query:$column$.sub_attribute7SUB_ATTRIBUTE7SUB_ATTRIBUTE4LOV query:$column$.sub_attribute8SUB_ATTRIBUTE8SUB_ATTRIBUTE4LOV query:$column$.sub_attribute9SUB_ATTRIBUTE9SUB_ATTRIBUTE4LOV query:$column$.attribute_categoryATTRIBUTE_CATEGORYSUB_ATTRIBUTE5LOV query:$column$.sub_attribute1SUB_ATTRIBUTE1SUB_ATTRIBUTE5LOV query:$column$.sub_attribute10SUB_ATTRIBUTE10SUB_ATTRIBUTE5LOV query:$column$.sub_attribute11SUB_ATTRIBUTE11SUB_ATTRIBUTE5LOV query:$column$.sub_attribute12SUB_ATTRIBUTE12SUB_ATTRIBUTE5LOV query:$column$.sub_attribute13SUB_ATTRIBUTE13SUB_ATTRIBUTE5LOV query:$column$.sub_attribute14SUB_ATTRIBUTE14SUB_ATTRIBUTE5LOV query:$column$.sub_attribute15SUB_ATTRIBUTE15SUB_ATTRIBUTE5LOV query:$column$.sub_attribute2SUB_ATTRIBUTE2SUB_ATTRIBUTE5LOV query:$column$.sub_attribute3SUB_ATTRIBUTE3SUB_ATTRIBUTE5LOV query:$column$.sub_attribute4SUB_ATTRIBUTE4SUB_ATTRIBUTE5LOV query:$column$.sub_attribute5SUB_ATTRIBUTE5SUB_ATTRIBUTE5LOV query:$column$.sub_attribute6SUB_ATTRIBUTE6SUB_ATTRIBUTE5LOV query:$column$.sub_attribute7SUB_ATTRIBUTE7SUB_ATTRIBUTE5LOV query:$column$.sub_attribute8SUB_ATTRIBUTE8SUB_ATTRIBUTE5LOV query:$column$.sub_attribute9SUB_ATTRIBUTE9SUB_ATTRIBUTE5LOV query:$column$.attribute_categoryATTRIBUTE_CATEGORYSUB_ATTRIBUTE6LOV query:$column$.sub_attribute1SUB_ATTRIBUTE1SUB_ATTRIBUTE6LOV query:$column$.sub_attribute10SUB_ATTRIBUTE10SUB_ATTRIBUTE6LOV query:$column$.sub_attribute11SUB_ATTRIBUTE11SUB_ATTRIBUTE6LOV query:$column$.sub_attribute12SUB_ATTRIBUTE12SUB_ATTRIBUTE6LOV query:$column$.sub_attribute13SUB_ATTRIBUTE13SUB_ATTRIBUTE6LOV query:$column$.sub_attribute14SUB_ATTRIBUTE14SUB_ATTRIBUTE6LOV query:$column$.sub_attribute15SUB_ATTRIBUTE15SUB_ATTRIBUTE6LOV query:$column$.sub_attribute2SUB_ATTRIBUTE2SUB_ATTRIBUTE6LOV query:$column$.sub_attribute3SUB_ATTRIBUTE3SUB_ATTRIBUTE6LOV query:$column$.sub_attribute4SUB_ATTRIBUTE4SUB_ATTRIBUTE6LOV query:$column$.sub_attribute5SUB_ATTRIBUTE5SUB_ATTRIBUTE6LOV query:$column$.sub_attribute6SUB_ATTRIBUTE6SUB_ATTRIBUTE6LOV query:$column$.sub_attribute7SUB_ATTRIBUTE7SUB_ATTRIBUTE6LOV query:$column$.sub_attribute8SUB_ATTRIBUTE8SUB_ATTRIBUTE6LOV query:$column$.sub_attribute9SUB_ATTRIBUTE9SUB_ATTRIBUTE6LOV query:$column$.attribute_categoryATTRIBUTE_CATEGORYSUB_ATTRIBUTE7LOV query:$column$.sub_attribute1SUB_ATTRIBUTE1SUB_ATTRIBUTE7LOV query:$column$.sub_attribute10SUB_ATTRIBUTE10SUB_ATTRIBUTE7LOV query:$column$.sub_attribute11SUB_ATTRIBUTE11SUB_ATTRIBUTE7LOV query:$column$.sub_attribute12SUB_ATTRIBUTE12SUB_ATTRIBUTE7LOV query:$column$.sub_attribute13SUB_ATTRIBUTE13SUB_ATTRIBUTE7LOV query:$column$.sub_attribute14SUB_ATTRIBUTE14SUB_ATTRIBUTE7LOV query:$column$.sub_attribute15SUB_ATTRIBUTE15SUB_ATTRIBUTE7LOV query:$column$.sub_attribute2SUB_ATTRIBUTE2SUB_ATTRIBUTE7LOV query:$column$.sub_attribute3SUB_ATTRIBUTE3SUB_ATTRIBUTE7LOV query:$column$.sub_attribute4SUB_ATTRIBUTE4SUB_ATTRIBUTE7LOV query:$column$.sub_attribute5SUB_ATTRIBUTE5SUB_ATTRIBUTE7LOV query:$column$.sub_attribute6SUB_ATTRIBUTE6SUB_ATTRIBUTE7LOV query:$column$.sub_attribute7SUB_ATTRIBUTE7SUB_ATTRIBUTE7LOV query:$column$.sub_attribute8SUB_ATTRIBUTE8SUB_ATTRIBUTE7LOV query:$column$.sub_attribute9SUB_ATTRIBUTE9SUB_ATTRIBUTE7LOV query:$column$.attribute_categoryATTRIBUTE_CATEGORYSUB_ATTRIBUTE8LOV query:$column$.sub_attribute1SUB_ATTRIBUTE1SUB_ATTRIBUTE8LOV query:$column$.sub_attribute10SUB_ATTRIBUTE10SUB_ATTRIBUTE8LOV query:$column$.sub_attribute11SUB_ATTRIBUTE11SUB_ATTRIBUTE8LOV query:$column$.sub_attribute12SUB_ATTRIBUTE12SUB_ATTRIBUTE8LOV query:$column$.sub_attribute13SUB_ATTRIBUTE13SUB_ATTRIBUTE8LOV query:$column$.sub_attribute14SUB_ATTRIBUTE14SUB_ATTRIBUTE8LOV query:$column$.sub_attribute15SUB_ATTRIBUTE15SUB_ATTRIBUTE8LOV query:$column$.sub_attribute2SUB_ATTRIBUTE2SUB_ATTRIBUTE8LOV query:$column$.sub_attribute3SUB_ATTRIBUTE3SUB_ATTRIBUTE8LOV query:$column$.sub_attribute4SUB_ATTRIBUTE4SUB_ATTRIBUTE8LOV query:$column$.sub_attribute5SUB_ATTRIBUTE5SUB_ATTRIBUTE8LOV query:$column$.sub_attribute6SUB_ATTRIBUTE6SUB_ATTRIBUTE8LOV query:$column$.sub_attribute7SUB_ATTRIBUTE7SUB_ATTRIBUTE8LOV query:$column$.sub_attribute8SUB_ATTRIBUTE8SUB_ATTRIBUTE8LOV query:$column$.sub_attribute9SUB_ATTRIBUTE9SUB_ATTRIBUTE8LOV query:$column$.attribute_categoryATTRIBUTE_CATEGORYSUB_ATTRIBUTE9LOV query:$column$.sub_attribute1SUB_ATTRIBUTE1SUB_ATTRIBUTE9LOV query:$column$.sub_attribute10SUB_ATTRIBUTE10SUB_ATTRIBUTE9LOV query:$column$.sub_attribute11SUB_ATTRIBUTE11SUB_ATTRIBUTE9LOV query:$column$.sub_attribute12SUB_ATTRIBUTE12SUB_ATTRIBUTE9LOV query:$column$.sub_attribute13SUB_ATTRIBUTE13SUB_ATTRIBUTE9LOV query:$column$.sub_attribute14SUB_ATTRIBUTE14SUB_ATTRIBUTE9LOV query:$column$.sub_attribute15SUB_ATTRIBUTE15SUB_ATTRIBUTE9LOV query:$column$.sub_attribute2SUB_ATTRIBUTE2SUB_ATTRIBUTE9LOV query:$column$.sub_attribute3SUB_ATTRIBUTE3SUB_ATTRIBUTE9LOV query:$column$.sub_attribute4SUB_ATTRIBUTE4SUB_ATTRIBUTE9LOV query:$column$.sub_attribute5SUB_ATTRIBUTE5SUB_ATTRIBUTE9LOV query:$column$.sub_attribute6SUB_ATTRIBUTE6SUB_ATTRIBUTE9LOV query:$column$.sub_attribute7SUB_ATTRIBUTE7SUB_ATTRIBUTE9LOV query:$column$.sub_attribute8SUB_ATTRIBUTE8SUB_ATTRIBUTE9LOV query:$column$.sub_attribute9SUB_ATTRIBUTE9SUB_ATTRIBUTE9Value to id query:$column$.default_cost_groupDEFAULT_COST_GROUPp_encumbrance_accountValue to id query:$column$.default_cost_groupDEFAULT_COST_GROUPp_expense_accountValue to id query:$column$.default_cost_groupDEFAULT_COST_GROUPp_material_accountValue to id query:$column$.default_cost_groupDEFAULT_COST_GROUPp_material_overhead_accountValue to id query:$column$.default_cost_groupDEFAULT_COST_GROUPp_outside_processing_accountValue to id query:$column$.default_cost_groupDEFAULT_COST_GROUPp_overhead_accountValue to id query:$column$.default_cost_groupDEFAULT_COST_GROUPp_resource_accountValue to id query:$column$.enable_locator_aliasENABLE_LOCATOR_ALIASp_enforce_alias_uniquenessValue to id query:$column$.enable_par_level_planningENABLE_PAR_LEVEL_PLANNINGp_default_count_type_codeValue to id query:$column$.locator_controlLOCATOR_CONTROLp_default_loc_status_codeValue to id query:$column$.locator_controlLOCATOR_CONTROLp_enable_locator_aliasValue to id query:$column$.nameNAMEp_default_cost_group_idValue to id query:$column$.nameNAMEp_encumbrance_accountValue to id query:$column$.nameNAMEp_expense_accountValue to id query:$column$.nameNAMEp_material_accountValue to id query:$column$.nameNAMEp_material_overhead_accountValue to id query:$column$.nameNAMEp_outside_processing_accountValue to id query:$column$.nameNAMEp_overhead_accountValue to id query:$column$.nameNAMEp_resource_accountValue to id query:$column$.organization_codeORGANIZATION_CODEp_cartonization_flagValue to id query:$column$.organization_codeORGANIZATION_CODEp_default_cost_group_idValue to id query:$column$.organization_codeORGANIZATION_CODEp_default_loc_status_codeValue to id query:$column$.organization_codeORGANIZATION_CODEp_enable_bulk_pickValue to id query:$column$.organization_codeORGANIZATION_CODEp_enable_locator_aliasValue to id query:$column$.organization_codeORGANIZATION_CODEp_enable_opp_cyc_count_flagValue to id query:$column$.organization_codeORGANIZATION_CODEp_encumbrance_accountValue to id query:$column$.organization_codeORGANIZATION_CODEp_expense_accountValue to id query:$column$.organization_codeORGANIZATION_CODEp_location_codeValue to id query:$column$.organization_codeORGANIZATION_CODEp_locator_typeValue to id query:$column$.organization_codeORGANIZATION_CODEp_lpn_controlled_flagValue to id query:$column$.organization_codeORGANIZATION_CODEp_material_accountValue to id query:$column$.organization_codeORGANIZATION_CODEp_material_overhead_accountValue to id query:$column$.organization_codeORGANIZATION_CODEp_opp_cyc_count_header_nameValue to id query:$column$.organization_codeORGANIZATION_CODEp_outside_processing_accountValue to id query:$column$.organization_codeORGANIZATION_CODEp_overhead_accountValue to id query:$column$.organization_codeORGANIZATION_CODEp_resource_accountValue to id query:$column$.organization_codeORGANIZATION_CODEp_source_organization_codeValue to id query:$column$.quantity_trackedQUANTITY_TRACKEDp_asset_inventoryValue to id query:$column$.quantity_trackedQUANTITY_TRACKEDp_default_count_type_codeValue to id query:$column$.quantity_trackedQUANTITY_TRACKEDp_depreciable_flagValue to id query:$column$.source_typeSOURCE_TYPEp_source_organization_codeValue to id query:$column$.statusSTATUSp_availability_typeValue to id query:$column$.statusSTATUSp_inventory_atp_codeValue to id query:$column$.statusSTATUSp_quantity_trackedValue to id query:$column$.statusSTATUSp_reservable_typeValue to id query:$column$.typeTYPEp_asset_inventoryValue to id query:$column$.typeTYPEp_default_count_type_codeValue to id query:$column$.typeTYPEp_default_loc_status_codeValue to id query:$column$.typeTYPEp_depreciable_flagValue to id query:$column$.typeTYPEp_location_codeValue to id query:$column$.typeTYPEp_lpn_controlled_flagValue to id query:$column$.typeTYPEp_planning_levelValue to id query:$column$.typeTYPEp_quantity_trackedValue to id query:$column$.typeTYPEp_source_typeValue to id query:$column$.typeTYPEp_status_code