<ROOT>
 <APPS_INITIALIZE_DATA>
  <USER_NAME>ENGINATICS</USER_NAME>
  <RESPONSIBILITY_KEY>SYSTEM_ADMINISTRATOR</RESPONSIBILITY_KEY>
  <APPLICATION_SHORT_NAME>SYSADMIN</APPLICATION_SHORT_NAME>
 </APPS_INITIALIZE_DATA>
<REPORTS>
<!-- loader xml for Enginatics Blitz Report: EAM Asset Activity Association Upload -->
 <REPORTS_ROW>
  <GUID>3D7DD2FF8533436AA472437688E5A144</GUID><ENABLED>Y</ENABLED>
  <SQL_TEXT>select
null action_,
null status_,
null message_,
null modified_columns_,
x.organization_code maintenance_organization,
x.activity,
xxen_util.meaning(to_char(decode(x.maintenance_object_type,2,decode(msi_grp.eam_item_type,1,1,3),3,decode(msi_grp.eam_item_type,1,1,3),nvl(msi_grp.eam_item_type,1))),&apos;MTL_EAM_ITEM_TYPE&apos;,700) asset_type,
msi_grp.concatenated_segments asset_group,
x.instance_number asset_number,
x.start_date_active from_date,
x.end_date_active to_date,
xxen_util.meaning(x.priority_code,&apos;WIP_EAM_ACTIVITY_PRIORITY&apos;,700) priority,
xxen_util.meaning(x.eomd_activity_cause_code,&apos;MTL_EAM_ACTIVITY_CAUSE&apos;,700) activity_cause,
xxen_util.meaning(x.eomd_activity_type_code,&apos;MTL_EAM_ACTIVITY_TYPE&apos;,700) activity_type,
xxen_util.meaning(x.eomd_shutdown_type_code,&apos;BOM_EAM_SHUTDOWN_TYPE&apos;,700) shutdown_type,
xxen_util.meaning(x.eomd_activity_source_code,&apos;MTL_EAM_ACTIVITY_SOURCE&apos;,700) activity_source,
bd.department_code owning_department,
x.eomd_accounting_class_code wip_accounting_class,
xxen_util.yes(x.eomd_tagging_required_flag) tagging_required,
xxen_util.display_flexfield_context(401,&apos;MTL_EAM_ASSET_ACTIVITIES&apos;,x.attribute_category) attribute_category,
xxen_util.display_flexfield_value(401,&apos;MTL_EAM_ASSET_ACTIVITIES&apos;,x.attribute_category,&apos;ATTRIBUTE1&apos;,x.row_id,x.attribute1) attribute1,
xxen_util.display_flexfield_value(401,&apos;MTL_EAM_ASSET_ACTIVITIES&apos;,x.attribute_category,&apos;ATTRIBUTE2&apos;,x.row_id,x.attribute2) attribute2,
xxen_util.display_flexfield_value(401,&apos;MTL_EAM_ASSET_ACTIVITIES&apos;,x.attribute_category,&apos;ATTRIBUTE3&apos;,x.row_id,x.attribute3) attribute3,
xxen_util.display_flexfield_value(401,&apos;MTL_EAM_ASSET_ACTIVITIES&apos;,x.attribute_category,&apos;ATTRIBUTE4&apos;,x.row_id,x.attribute4) attribute4,
xxen_util.display_flexfield_value(401,&apos;MTL_EAM_ASSET_ACTIVITIES&apos;,x.attribute_category,&apos;ATTRIBUTE5&apos;,x.row_id,x.attribute5) attribute5,
xxen_util.display_flexfield_value(401,&apos;MTL_EAM_ASSET_ACTIVITIES&apos;,x.attribute_category,&apos;ATTRIBUTE6&apos;,x.row_id,x.attribute6) attribute6,
xxen_util.display_flexfield_value(401,&apos;MTL_EAM_ASSET_ACTIVITIES&apos;,x.attribute_category,&apos;ATTRIBUTE7&apos;,x.row_id,x.attribute7) attribute7,
xxen_util.display_flexfield_value(401,&apos;MTL_EAM_ASSET_ACTIVITIES&apos;,x.attribute_category,&apos;ATTRIBUTE8&apos;,x.row_id,x.attribute8) attribute8,
xxen_util.display_flexfield_value(401,&apos;MTL_EAM_ASSET_ACTIVITIES&apos;,x.attribute_category,&apos;ATTRIBUTE9&apos;,x.row_id,x.attribute9) attribute9,
xxen_util.display_flexfield_value(401,&apos;MTL_EAM_ASSET_ACTIVITIES&apos;,x.attribute_category,&apos;ATTRIBUTE10&apos;,x.row_id,x.attribute10) attribute10,
xxen_util.display_flexfield_value(401,&apos;MTL_EAM_ASSET_ACTIVITIES&apos;,x.attribute_category,&apos;ATTRIBUTE11&apos;,x.row_id,x.attribute11) attribute11,
xxen_util.display_flexfield_value(401,&apos;MTL_EAM_ASSET_ACTIVITIES&apos;,x.attribute_category,&apos;ATTRIBUTE12&apos;,x.row_id,x.attribute12) attribute12,
xxen_util.display_flexfield_value(401,&apos;MTL_EAM_ASSET_ACTIVITIES&apos;,x.attribute_category,&apos;ATTRIBUTE13&apos;,x.row_id,x.attribute13) attribute13,
xxen_util.display_flexfield_value(401,&apos;MTL_EAM_ASSET_ACTIVITIES&apos;,x.attribute_category,&apos;ATTRIBUTE14&apos;,x.row_id,x.attribute14) attribute14,
xxen_util.display_flexfield_value(401,&apos;MTL_EAM_ASSET_ACTIVITIES&apos;,x.attribute_category,&apos;ATTRIBUTE15&apos;,x.row_id,x.attribute15) attribute15,
x.activity_association_id assoc_row_id,
to_number(null) upload_row
from
(
select
meaa.*,
meaa.rowid row_id,
mp.organization_id maint_organization_id,
mp.organization_code,
msi_act.concatenated_segments activity,
cii.instance_number,
decode(meaa.maintenance_object_type,3,cii.inventory_item_id,2,meaa.maintenance_object_id) asset_group_id,
eomd.owning_department_id eomd_owning_department_id,
eomd.accounting_class_code eomd_accounting_class_code,
eomd.activity_cause_code eomd_activity_cause_code,
eomd.activity_type_code eomd_activity_type_code,
eomd.activity_source_code eomd_activity_source_code,
eomd.shutdown_type_code eomd_shutdown_type_code,
eomd.tagging_required_flag eomd_tagging_required_flag
from
inv.mtl_eam_asset_activities meaa,
eam_org_maint_defaults eomd,
mtl_parameters mp,
mtl_system_items_b_kfv msi_act,
csi_item_instances cii
where
:p_upload_mode like &apos;%&apos; || xxen_upload.action_update and
nvl(meaa.tmpl_flag,&apos;N&apos;)=&apos;N&apos; and
decode(meaa.maintenance_object_type,2,40,60)=eomd.object_type(+) and
meaa.activity_association_id=eomd.object_id(+) and
nvl(eomd.organization_id,meaa.organization_id)=mp.organization_id and
mp.organization_id in (select xroa.id from xxen_report_org_access xroa where xroa.access_type=&apos;INV&apos;) and
meaa.asset_activity_id=msi_act.inventory_item_id and
mp.organization_id=msi_act.organization_id and
decode(meaa.maintenance_object_type,3,meaa.maintenance_object_id)=cii.instance_id(+) and
1=1
) x,
mtl_system_items_b_kfv msi_grp,
bom_departments bd
where
x.asset_group_id=msi_grp.inventory_item_id(+) and
x.maint_organization_id=msi_grp.organization_id(+) and
x.eomd_owning_department_id=bd.department_id(+)</SQL_TEXT>
  <VERSION_COMMENTS>Organization specific defaults (department, accounting class, cause, type, source, shutdown type, tagging) read from eam_org_maint_defaults, where the API stores them, and associations without an organization downloaded through it; organization access restriction; non-serialized rebuildables in the Asset Group list; Maintenance accounting classes only.</VERSION_COMMENTS>
  <TYPE>U</TYPE>
  <UPLOAD_TYPE>A</UPLOAD_TYPE>
  <UPLOAD_OBJECT>xxen_eam_upload.upload_activity_assoc</UPLOAD_OBJECT>
  <REPORT_TRANSLATIONS>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>US</LANGUAGE>
    <REPORT_NAME>EAM Asset Activity Association Upload</REPORT_NAME>
    <DESCRIPTION>Create and update the associations of maintenance activities with assets and rebuildables, including the activity defaults that work orders take from the association: priority, cause, type, shutdown type, source, owning department, WIP accounting class and tagging.

An association is for an Asset Number (an asset or a serialized rebuildable), or for a non-serialized Rebuildable item without an asset number. Asset group template associations, which Oracle copies to new assets of the group, are not supported.

An existing association is found by activity and asset number, or by activity and rebuildable item. Owning department, accounting class, cause, type, source, shutdown type and tagging are kept per maintenance organization, so a row updates them for the organization in its Maintenance Organization column.

Associations cannot be deleted. End-date them with To Date.
</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
  </REPORT_TRANSLATIONS>
  <CATEGORY_ASSIGNMENTS>
   <CATEGORY_ASSIGNMENTS_ROW>
    <CATEGORY>Enginatics</CATEGORY>
   </CATEGORY_ASSIGNMENTS_ROW>
   <CATEGORY_ASSIGNMENTS_ROW>
    <CATEGORY>R12 only</CATEGORY>
   </CATEGORY_ASSIGNMENTS_ROW>
   <CATEGORY_ASSIGNMENTS_ROW>
    <CATEGORY>Upload</CATEGORY>
   </CATEGORY_ASSIGNMENTS_ROW>
  </CATEGORY_ASSIGNMENTS>
  <ANCHORS>
   <ANCHORS_ROW>
    <ANCHOR>1=1</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_upload_mode</ANCHOR>
   </ANCHORS_ROW>
  </ANCHORS>
  <PARAMETERS>
   <PARAMETERS_ROW>
    <SORT_ORDER>1</SORT_ORDER>
    <DISPLAY_SEQUENCE>10</DISPLAY_SEQUENCE>
    <ANCHOR>1=1</ANCHOR>
    <SQL_TEXT>:p_upload_mode like &apos;%&apos; || xxen_upload.action_update</SQL_TEXT>
    <PARAMETER_TYPE_DSP>LOV</PARAMETER_TYPE_DSP>
    <LOV_NAME>Blitz Upload Mode</LOV_NAME>
    <LOV_GUID>E811F942597A2075E0530100007FF4F2</LOV_GUID>
    <LOV_QUERY_DSP>select xxen_upload.action_create id, xxen_upload.action_meaning(xxen_upload.action_create) value, null description from dual union all
select xxen_upload.action_create||&apos;,&apos;||xxen_upload.action_update id, xxen_upload.action_meaning(xxen_upload.action_create)||&apos;, &apos;||xxen_upload.action_meaning(xxen_upload.action_update) value, null description from dual</LOV_QUERY_DSP>
    <DEFAULT_VALUE>C,U</DEFAULT_VALUE>
    <REQUIRED>Y</REQUIRED>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Upload Mode</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>2</SORT_ORDER>
    <DISPLAY_SEQUENCE>20</DISPLAY_SEQUENCE>
    <ANCHOR>1=1</ANCHOR>
    <SQL_TEXT>mp.organization_code=:p_maint_org</SQL_TEXT>
    <PARAMETER_TYPE_DSP>LOV</PARAMETER_TYPE_DSP>
    <LOV_NAME>EAM Maintenance Organization</LOV_NAME>
    <LOV_GUID>7141C5E32F8343C7A65351A16ADDD82E</LOV_GUID>
    <LOV_QUERY_DSP>select
mp.organization_code value,
ood.organization_name description
from
mtl_parameters mp,
org_organization_definitions ood
where
mp.organization_id in (select xroa.id from xxen_report_org_access xroa where xroa.access_type=&apos;INV&apos;) and
mp.organization_id=ood.organization_id and
nvl(ood.disable_date,sysdate)&gt;=sysdate and
mp.eam_enabled_flag=&apos;Y&apos;
order by
mp.organization_code</LOV_QUERY_DSP>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Maintenance Organization</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>3</SORT_ORDER>
    <DISPLAY_SEQUENCE>30</DISPLAY_SEQUENCE>
    <ANCHOR>1=1</ANCHOR>
    <SQL_TEXT>msi_act.concatenated_segments=:p_activity</SQL_TEXT>
    <PARAMETER_TYPE_DSP>LOV custom</PARAMETER_TYPE_DSP>
    <LOV_QUERY_DSP>select
msi.concatenated_segments value,
msi.description
from
mtl_system_items_b_kfv msi,
mtl_parameters mp
where
msi.eam_item_type=2 and
msi.organization_id=mp.organization_id and
mp.maint_organization_id=mp.organization_id and
mp.organization_code=:$flex$.Maintenance_Organization
order by
msi.concatenated_segments</LOV_QUERY_DSP>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Activity</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
  </PARAMETERS>
  <TEMPLATES>
   <TEMPLATES_ROW>
    <GUID>A330A6E8D9BD43CA8F3E2A19CDAB9C8E</GUID>
    <TEMPLATE_NAME>Default</TEMPLATE_NAME>
    <DESCRIPTION>All columns except the descriptive flexfield attributes.</DESCRIPTION>
    <OWNER>ENGINATICS</OWNER>
    <TEMPLATE_COLUMNS>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>2</DISPLAY_SEQUENCE>
      <COLUMN_NAME>ACTIVITY</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>9</DISPLAY_SEQUENCE>
      <COLUMN_NAME>ACTIVITY_CAUSE</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>12</DISPLAY_SEQUENCE>
      <COLUMN_NAME>ACTIVITY_SOURCE</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>10</DISPLAY_SEQUENCE>
      <COLUMN_NAME>ACTIVITY_TYPE</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>4</DISPLAY_SEQUENCE>
      <COLUMN_NAME>ASSET_GROUP</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>5</DISPLAY_SEQUENCE>
      <COLUMN_NAME>ASSET_NUMBER</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>3</DISPLAY_SEQUENCE>
      <COLUMN_NAME>ASSET_TYPE</COLUMN_NAME>
      <FREEZE_PANES>Y</FREEZE_PANES>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>6</DISPLAY_SEQUENCE>
      <COLUMN_NAME>FROM_DATE</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>1</DISPLAY_SEQUENCE>
      <COLUMN_NAME>MAINTENANCE_ORGANIZATION</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>13</DISPLAY_SEQUENCE>
      <COLUMN_NAME>OWNING_DEPARTMENT</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>8</DISPLAY_SEQUENCE>
      <COLUMN_NAME>PRIORITY</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>11</DISPLAY_SEQUENCE>
      <COLUMN_NAME>SHUTDOWN_TYPE</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>15</DISPLAY_SEQUENCE>
      <COLUMN_NAME>TAGGING_REQUIRED</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>7</DISPLAY_SEQUENCE>
      <COLUMN_NAME>TO_DATE</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>14</DISPLAY_SEQUENCE>
      <COLUMN_NAME>WIP_ACCOUNTING_CLASS</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
    </TEMPLATE_COLUMNS>
    <TEMPLATE_PIVOT>
    </TEMPLATE_PIVOT>
    <TEMPLATE_SHARED_STRINGS>
    </TEMPLATE_SHARED_STRINGS>
    <TEMPLATE_PARAMETER_DEFAULTS>
    </TEMPLATE_PARAMETER_DEFAULTS>
    <TEMPLATE_STYLES>
    </TEMPLATE_STYLES>
    <TEMPLATE_SHARING>
     <TEMPLATE_SHARING_ROW>
      <SHARING_LEVEL>S</SHARING_LEVEL>
      <LEVEL_VALUE>Site</LEVEL_VALUE>
     </TEMPLATE_SHARING_ROW>
    </TEMPLATE_SHARING>
    <PARAMETER_EXCLUSION>
    </PARAMETER_EXCLUSION>
    <TEMPLATE_CONDITIONS>
    </TEMPLATE_CONDITIONS>
   </TEMPLATES_ROW>
  </TEMPLATES>
  <DEFAULT_TEMPLATES>
   <DEFAULT_TEMPLATES_ROW>
    <TEMPLATE_GUID>A330A6E8D9BD43CA8F3E2A19CDAB9C8E</TEMPLATE_GUID>
   </DEFAULT_TEMPLATES_ROW>
  </DEFAULT_TEMPLATES>
  <UPLOAD_COLUMNS>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>1</COLUMN_NUMBER>
    <COLUMN_NAME>ACTION_</COLUMN_NAME>
    <COLUMN_TYPE_DSP>Char</COLUMN_TYPE_DSP>
    <DATA_TYPE>varchar2</DATA_TYPE>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>2</COLUMN_NUMBER>
    <COLUMN_NAME>STATUS_</COLUMN_NAME>
    <COLUMN_TYPE_DSP>Char</COLUMN_TYPE_DSP>
    <DATA_TYPE>varchar2</DATA_TYPE>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>3</COLUMN_NUMBER>
    <COLUMN_NAME>MESSAGE_</COLUMN_NAME>
    <COLUMN_TYPE_DSP>Char</COLUMN_TYPE_DSP>
    <DATA_TYPE>varchar2</DATA_TYPE>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>4</COLUMN_NUMBER>
    <COLUMN_NAME>MODIFIED_COLUMNS_</COLUMN_NAME>
    <COLUMN_TYPE_DSP>Char</COLUMN_TYPE_DSP>
    <DATA_TYPE>varchar2</DATA_TYPE>
    <HIDDEN>Y</HIDDEN>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>5</COLUMN_NUMBER>
    <COLUMN_NAME>MAINTENANCE_ORGANIZATION</COLUMN_NAME>
    <COLUMN_TYPE_DSP>LOV</COLUMN_TYPE_DSP>
    <DATA_TYPE>varchar2</DATA_TYPE>
    <DATA_LENGTH>3</DATA_LENGTH>
    <LOV_NAME>INV Organization Code</LOV_NAME>
    <LOV_GUID>8E2FF36EDEB279D2E0530100007F1FF2</LOV_GUID>
    <LOV_QUERY_DSP>select
ood.organization_code value,
ood.organization_name||&apos; (&apos;||ftv.territory_short_name||&apos;, &apos;||hla.town_or_city||decode(mp.organization_id,mp.master_organization_id,null,&apos;, &apos;||mp0.organization_code)||&apos;)&apos; 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&lt;&gt;mp.master_organization_id and
(
ood.organization_id in (select xroa.id from xxen_report_org_access xroa where xroa.access_type=&apos;INV&apos;) or
not exists (select null from xxen_report_org_access xroa where xroa.access_type=&apos;INV&apos;) and
ood.operating_unit in (select xroa.id from xxen_report_org_access xroa where xroa.access_type=&apos;OU&apos;)
) 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)=&apos;Y&apos;)) 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)=&apos;Y&apos;)) and
nvl(ood.disable_date,sysdate)&gt;=sysdate and
mp.master_organization_id=mp0.organization_id and
ood.organization_id=haou.organization_id(+) and
haou.location_id=hla.location_id(+) and
hla.country=ftv.territory_code(+)
order by
ood.organization_code</LOV_QUERY_DSP>
    <VALUE_TO_ID_QUERY>select
mp.organization_id id,
mp.organization_code value
from
mtl_parameters mp
where
mp.eam_enabled_flag=&apos;Y&apos; and
mp.organization_id in (select xroa.id from xxen_report_org_access xroa where xroa.access_type=&apos;INV&apos;)</VALUE_TO_ID_QUERY>
    <DEFAULT_VALUE>:$flex$.Maintenance_Organization</DEFAULT_VALUE>
    <REQUIRED>Y</REQUIRED>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>6</COLUMN_NUMBER>
    <COLUMN_NAME>ACTIVITY</COLUMN_NAME>
    <COLUMN_TYPE_DSP>LOV custom</COLUMN_TYPE_DSP>
    <DATA_TYPE>varchar2</DATA_TYPE>
    <DATA_LENGTH>40</DATA_LENGTH>
    <LOV_QUERY_DSP>select
msi.inventory_item_id id,
msi.concatenated_segments value,
msi.description
from
mtl_system_items_b_kfv msi,
mtl_parameters mp
where
msi.eam_item_type=2 and
msi.organization_id=mp.organization_id and
mp.maint_organization_id=mp.organization_id and
mp.organization_code=:$column$.maintenance_organization
order by
msi.concatenated_segments</LOV_QUERY_DSP>
    <DEFAULT_VALUE>:$flex$.Activity</DEFAULT_VALUE>
    <REQUIRED>Y</REQUIRED>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>7</COLUMN_NUMBER>
    <COLUMN_NAME>ASSET_TYPE</COLUMN_NAME>
    <COLUMN_TYPE_DSP>LOV custom</COLUMN_TYPE_DSP>
    <DATA_TYPE>varchar2</DATA_TYPE>
    <LOV_QUERY_DSP>select
ml.lookup_code id,
ml.meaning value,
ml.description
from
mfg_lookups ml
where
ml.lookup_type=&apos;MTL_EAM_ITEM_TYPE&apos; and
ml.lookup_code in (1,3) and
sysdate between nvl(ml.start_date_active,sysdate) and
nvl(ml.end_date_active,sysdate) and
nvl(ml.enabled_flag,&apos;N&apos;)=&apos;Y&apos;
order by
ml.lookup_code</LOV_QUERY_DSP>
    <REQUIRED>Y</REQUIRED>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>8</COLUMN_NUMBER>
    <COLUMN_NAME>ASSET_GROUP</COLUMN_NAME>
    <COLUMN_TYPE_DSP>LOV custom</COLUMN_TYPE_DSP>
    <DATA_TYPE>varchar2</DATA_TYPE>
    <DATA_LENGTH>40</DATA_LENGTH>
    <LOV_QUERY_DSP>select
msi.inventory_item_id id,
msi.concatenated_segments value,
msi.description
from
mtl_system_items_b_kfv msi,
mtl_parameters mp
where
msi.organization_id=mp.organization_id and
mp.organization_code=:$column$.maintenance_organization and
msi.eam_item_type in (1,3) and
(msi.serial_number_control_code&lt;&gt;1 or msi.eam_item_type=3)
order by
msi.concatenated_segments</LOV_QUERY_DSP>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>9</COLUMN_NUMBER>
    <COLUMN_NAME>ASSET_NUMBER</COLUMN_NAME>
    <COLUMN_TYPE_DSP>LOV custom</COLUMN_TYPE_DSP>
    <DATA_TYPE>varchar2</DATA_TYPE>
    <DATA_LENGTH>30</DATA_LENGTH>
    <LOV_QUERY_DSP>select
cii.instance_id id,
cii.instance_number value,
msik.concatenated_segments||nvl2(cii.serial_number,&apos; - &apos;||cii.serial_number,null) description
from
mtl_parameters mp,
csi_item_instances cii,
mtl_system_items_kfv msik
where
mp.organization_code=:$column$.maintenance_organization and
mp.organization_id=cii.last_vld_organization_id and
sysdate between nvl(cii.active_start_date,sysdate) and nvl(cii.active_end_date,sysdate) and
cii.last_vld_organization_id=msik.organization_id and
cii.inventory_item_id=msik.inventory_item_id and
msik.eam_item_type in (1,3) and
msik.serial_number_control_code&lt;&gt;1 and
(:$column$.asset_group is null or msik.concatenated_segments=:$column$.asset_group)
order by
cii.instance_number</LOV_QUERY_DSP>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>10</COLUMN_NUMBER>
    <COLUMN_NAME>FROM_DATE</COLUMN_NAME>
    <COLUMN_TYPE_DSP>Date</COLUMN_TYPE_DSP>
    <DATA_TYPE>date</DATA_TYPE>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>11</COLUMN_NUMBER>
    <COLUMN_NAME>TO_DATE</COLUMN_NAME>
    <COLUMN_TYPE_DSP>Date</COLUMN_TYPE_DSP>
    <DATA_TYPE>date</DATA_TYPE>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>12</COLUMN_NUMBER>
    <COLUMN_NAME>PRIORITY</COLUMN_NAME>
    <COLUMN_TYPE_DSP>LOV</COLUMN_TYPE_DSP>
    <DATA_TYPE>varchar2</DATA_TYPE>
    <LOV_NAME>EAM Activity Priority</LOV_NAME>
    <LOV_GUID>CA452AE88BD14943B5C75F10D136AEE2</LOV_GUID>
    <LOV_QUERY_DSP>select
flvv.meaning value,
flvv.description
from
fnd_lookup_values_vl flvv
where
flvv.lookup_type=&apos;WIP_EAM_ACTIVITY_PRIORITY&apos; and
flvv.view_application_id=700 and
flvv.security_group_id=0 and
flvv.enabled_flag=&apos;Y&apos;
order by
to_number(flvv.lookup_code)</LOV_QUERY_DSP>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>13</COLUMN_NUMBER>
    <COLUMN_NAME>ACTIVITY_CAUSE</COLUMN_NAME>
    <COLUMN_TYPE_DSP>LOV</COLUMN_TYPE_DSP>
    <DATA_TYPE>varchar2</DATA_TYPE>
    <LOV_NAME>EAM Activity Cause</LOV_NAME>
    <LOV_GUID>E32489DD063F425F97285ED6B90BFC31</LOV_GUID>
    <LOV_QUERY_DSP>select
ml.meaning value,
ml.description
from
mfg_lookups ml
where
ml.lookup_type = &apos;MTL_EAM_ACTIVITY_CAUSE&apos; and
sysdate between nvl(ml.start_date_active,sysdate) and nvl(ml.end_date_active,sysdate) and
nvl(ml.enabled_flag, &apos;N&apos;) = &apos;Y&apos;
order by
value</LOV_QUERY_DSP>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>14</COLUMN_NUMBER>
    <COLUMN_NAME>ACTIVITY_TYPE</COLUMN_NAME>
    <COLUMN_TYPE_DSP>LOV</COLUMN_TYPE_DSP>
    <DATA_TYPE>varchar2</DATA_TYPE>
    <LOV_NAME>EAM Activity Type</LOV_NAME>
    <LOV_GUID>1F5F4DCAF8694BA6B649D0A3E4D9CF2F</LOV_GUID>
    <LOV_QUERY_DSP>select
ml.meaning value,
ml.description
from
mfg_lookups ml
where
ml.lookup_type = &apos;MTL_EAM_ACTIVITY_TYPE&apos; and
sysdate between nvl(ml.start_date_active,sysdate) and nvl(ml.end_date_active,sysdate) and
nvl(ml.enabled_flag, &apos;N&apos;) = &apos;Y&apos;
order by
value</LOV_QUERY_DSP>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>15</COLUMN_NUMBER>
    <COLUMN_NAME>SHUTDOWN_TYPE</COLUMN_NAME>
    <COLUMN_TYPE_DSP>LOV</COLUMN_TYPE_DSP>
    <DATA_TYPE>varchar2</DATA_TYPE>
    <LOV_NAME>EAM Shutdown Type</LOV_NAME>
    <LOV_GUID>170C3B7D4D4E4E71B790E61B4EB7DBD8</LOV_GUID>
    <LOV_QUERY_DSP>select
ml.meaning value,
ml.description
from
mfg_lookups ml
where
ml.lookup_type = &apos;BOM_EAM_SHUTDOWN_TYPE&apos; and
sysdate between nvl(ml.start_date_active,sysdate) and nvl(ml.end_date_active,sysdate) and
nvl(ml.enabled_flag, &apos;N&apos;) = &apos;Y&apos;
order by
value</LOV_QUERY_DSP>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>16</COLUMN_NUMBER>
    <COLUMN_NAME>ACTIVITY_SOURCE</COLUMN_NAME>
    <COLUMN_TYPE_DSP>LOV</COLUMN_TYPE_DSP>
    <DATA_TYPE>varchar2</DATA_TYPE>
    <LOV_NAME>EAM Activity Source</LOV_NAME>
    <LOV_GUID>4FB0C050740E4A33AC8F5103F7C8C6C6</LOV_GUID>
    <LOV_QUERY_DSP>select
ml.meaning value,
ml.description
from
mfg_lookups ml
where
ml.lookup_type=&apos;MTL_EAM_ACTIVITY_SOURCE&apos; and
sysdate between nvl(ml.start_date_active,sysdate) and
nvl(ml.end_date_active,sysdate) and
nvl(ml.enabled_flag,&apos;N&apos;)=&apos;Y&apos;
order by
ml.meaning</LOV_QUERY_DSP>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>17</COLUMN_NUMBER>
    <COLUMN_NAME>OWNING_DEPARTMENT</COLUMN_NAME>
    <COLUMN_TYPE_DSP>LOV custom</COLUMN_TYPE_DSP>
    <DATA_TYPE>varchar2</DATA_TYPE>
    <DATA_LENGTH>10</DATA_LENGTH>
    <LOV_QUERY_DSP>select
bd.department_id id,
bd.department_code value,
nvl2(bd.department_class_code,bd.department_class_code||&apos;: &apos;,null)||bd.description description
from
bom_departments bd,
mtl_parameters mp
where
bd.organization_id=mp.organization_id and
mp.organization_code=:$column$.maintenance_organization and
nvl(bd.disable_date,sysdate+1)&gt;sysdate
order by
bd.department_code</LOV_QUERY_DSP>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>18</COLUMN_NUMBER>
    <COLUMN_NAME>WIP_ACCOUNTING_CLASS</COLUMN_NAME>
    <COLUMN_TYPE_DSP>LOV custom</COLUMN_TYPE_DSP>
    <DATA_TYPE>varchar2</DATA_TYPE>
    <DATA_LENGTH>10</DATA_LENGTH>
    <LOV_QUERY_DSP>select
wac.class_code value,
wac.description
from
mtl_parameters mp,
wip_accounting_classes wac
where
mp.organization_code=:$column$.maintenance_organization and
mp.organization_id=wac.organization_id and
wac.class_type=6
order by
wac.class_code</LOV_QUERY_DSP>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>19</COLUMN_NUMBER>
    <COLUMN_NAME>TAGGING_REQUIRED</COLUMN_NAME>
    <COLUMN_TYPE_DSP>LOV</COLUMN_TYPE_DSP>
    <DATA_TYPE>varchar2</DATA_TYPE>
    <LOV_NAME>Yes</LOV_NAME>
    <LOV_GUID>8E2FF36EDEA679D2E0530100007F1FF2</LOV_GUID>
    <LOV_QUERY_DSP>select &apos;Y&apos; id, xxen_util.meaning(&apos;Y&apos;,&apos;YES_NO&apos;,0) value, null description from dual</LOV_QUERY_DSP>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>20</COLUMN_NUMBER>
    <COLUMN_NAME>ATTRIBUTE_CATEGORY</COLUMN_NAME>
    <COLUMN_TYPE_DSP>LOV custom</COLUMN_TYPE_DSP>
    <DATA_TYPE>varchar2</DATA_TYPE>
    <LOV_QUERY_DSP>select
distinct
fdfcv.descriptive_flex_context_name value,
fdfcv.description
from
fnd_descriptive_flexs_vl fdfv,
fnd_descr_flex_contexts_vl fdfcv
where
fdfv.descriptive_flexfield_name=&apos;MTL_EAM_ASSET_ACTIVITIES&apos; and
fdfv.application_id=401 and
fdfv.application_id=fdfcv.application_id and
fdfv.descriptive_flexfield_name=fdfcv.descriptive_flexfield_name and
fdfcv.enabled_flag=&apos;Y&apos; and
fdfcv.descriptive_flex_context_code&lt;&gt;&apos;Global Data Elements&apos;
order by
fdfcv.descriptive_flex_context_name</LOV_QUERY_DSP>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>21</COLUMN_NUMBER>
    <COLUMN_NAME>ATTRIBUTE1</COLUMN_NAME>
    <COLUMN_TYPE_DSP>LOV custom</COLUMN_TYPE_DSP>
    <DATA_TYPE>varchar2</DATA_TYPE>
    <LOV_QUERY_DSP>select
substrb(lov.column_value,1,instrb(lov.column_value,&apos;~&apos;,1,1)-1) value,
substrb(lov.column_value,instrb(lov.column_value,&apos;~&apos;,1,1)+1,lengthb(lov.column_value)) description
from
table(
xxen_util.dff_attribute_lov
(p_application_id =&gt; 401,
 p_descriptive_flexfield_name =&gt; &apos;MTL_EAM_ASSET_ACTIVITIES&apos;,
 p_context_name =&gt; :$column$.attribute_category,
 p_column_name  =&gt; &apos;ATTRIBUTE1&apos;,
 p_attribute1   =&gt; :$column$.attribute1,
 p_attribute2   =&gt; :$column$.attribute2,
 p_attribute3   =&gt; :$column$.attribute3,
 p_attribute4   =&gt; :$column$.attribute4,
 p_attribute5   =&gt; :$column$.attribute5,
 p_attribute6   =&gt; :$column$.attribute6,
 p_attribute7   =&gt; :$column$.attribute7,
 p_attribute8   =&gt; :$column$.attribute8,
 p_attribute9   =&gt; :$column$.attribute9,
 p_attribute10  =&gt; :$column$.attribute10,
 p_attribute11  =&gt; :$column$.attribute11,
 p_attribute12  =&gt; :$column$.attribute12,
 p_attribute13  =&gt; :$column$.attribute13,
 p_attribute14  =&gt; :$column$.attribute14,
 p_attribute15  =&gt; :$column$.attribute15
)
) lov
order by
value</LOV_QUERY_DSP>
    <COMMENTS>select
distinct
&apos;(Context) &apos; || initcap(dffcu.application_column_name) || &apos;: &apos; ||
listagg(decode(dffcx.descriptive_flex_context_code,&apos;Global Data Elements&apos;,&apos;(Global)&apos;,&apos;(&apos; || dffcx.descriptive_flex_context_code || &apos;)&apos;) || &apos; &apos; || dffcu.form_left_prompt,&apos;, &apos;) within group (order by decode(dffcx.descriptive_flex_context_code,&apos;Global Data Elements&apos;,1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name)
from
fnd_descriptive_flexs_vl dff,
fnd_descr_flex_contexts dffcx,
fnd_descr_flex_col_usage_vl dffcu
where
dffcx.application_id=dff.application_id and
dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and
dffcx.enabled_flag=&apos;Y&apos; and
dffcu.application_id=dffcx.application_id and
dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and
dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and
dffcu.enabled_flag=&apos;Y&apos; and
dff.application_id=401 and
dff.application_table_name=&apos;MTL_EAM_ASSET_ACTIVITIES&apos; and
dffcu.application_column_name=&apos;ATTRIBUTE1&apos;</COMMENTS>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>22</COLUMN_NUMBER>
    <COLUMN_NAME>ATTRIBUTE2</COLUMN_NAME>
    <COLUMN_TYPE_DSP>LOV custom</COLUMN_TYPE_DSP>
    <DATA_TYPE>varchar2</DATA_TYPE>
    <LOV_QUERY_DSP>select
substrb(lov.column_value,1,instrb(lov.column_value,&apos;~&apos;,1,1)-1) value,
substrb(lov.column_value,instrb(lov.column_value,&apos;~&apos;,1,1)+1,lengthb(lov.column_value)) description
from
table(
xxen_util.dff_attribute_lov
(p_application_id =&gt; 401,
 p_descriptive_flexfield_name =&gt; &apos;MTL_EAM_ASSET_ACTIVITIES&apos;,
 p_context_name =&gt; :$column$.attribute_category,
 p_column_name  =&gt; &apos;ATTRIBUTE2&apos;,
 p_attribute1   =&gt; :$column$.attribute1,
 p_attribute2   =&gt; :$column$.attribute2,
 p_attribute3   =&gt; :$column$.attribute3,
 p_attribute4   =&gt; :$column$.attribute4,
 p_attribute5   =&gt; :$column$.attribute5,
 p_attribute6   =&gt; :$column$.attribute6,
 p_attribute7   =&gt; :$column$.attribute7,
 p_attribute8   =&gt; :$column$.attribute8,
 p_attribute9   =&gt; :$column$.attribute9,
 p_attribute10  =&gt; :$column$.attribute10,
 p_attribute11  =&gt; :$column$.attribute11,
 p_attribute12  =&gt; :$column$.attribute12,
 p_attribute13  =&gt; :$column$.attribute13,
 p_attribute14  =&gt; :$column$.attribute14,
 p_attribute15  =&gt; :$column$.attribute15
)
) lov
order by
value</LOV_QUERY_DSP>
    <COMMENTS>select
distinct
&apos;(Context) &apos; || initcap(dffcu.application_column_name) || &apos;: &apos; ||
listagg(decode(dffcx.descriptive_flex_context_code,&apos;Global Data Elements&apos;,&apos;(Global)&apos;,&apos;(&apos; || dffcx.descriptive_flex_context_code || &apos;)&apos;) || &apos; &apos; || dffcu.form_left_prompt,&apos;, &apos;) within group (order by decode(dffcx.descriptive_flex_context_code,&apos;Global Data Elements&apos;,1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name)
from
fnd_descriptive_flexs_vl dff,
fnd_descr_flex_contexts dffcx,
fnd_descr_flex_col_usage_vl dffcu
where
dffcx.application_id=dff.application_id and
dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and
dffcx.enabled_flag=&apos;Y&apos; and
dffcu.application_id=dffcx.application_id and
dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and
dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and
dffcu.enabled_flag=&apos;Y&apos; and
dff.application_id=401 and
dff.application_table_name=&apos;MTL_EAM_ASSET_ACTIVITIES&apos; and
dffcu.application_column_name=&apos;ATTRIBUTE2&apos;</COMMENTS>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>23</COLUMN_NUMBER>
    <COLUMN_NAME>ATTRIBUTE3</COLUMN_NAME>
    <COLUMN_TYPE_DSP>LOV custom</COLUMN_TYPE_DSP>
    <DATA_TYPE>varchar2</DATA_TYPE>
    <LOV_QUERY_DSP>select
substrb(lov.column_value,1,instrb(lov.column_value,&apos;~&apos;,1,1)-1) value,
substrb(lov.column_value,instrb(lov.column_value,&apos;~&apos;,1,1)+1,lengthb(lov.column_value)) description
from
table(
xxen_util.dff_attribute_lov
(p_application_id =&gt; 401,
 p_descriptive_flexfield_name =&gt; &apos;MTL_EAM_ASSET_ACTIVITIES&apos;,
 p_context_name =&gt; :$column$.attribute_category,
 p_column_name  =&gt; &apos;ATTRIBUTE3&apos;,
 p_attribute1   =&gt; :$column$.attribute1,
 p_attribute2   =&gt; :$column$.attribute2,
 p_attribute3   =&gt; :$column$.attribute3,
 p_attribute4   =&gt; :$column$.attribute4,
 p_attribute5   =&gt; :$column$.attribute5,
 p_attribute6   =&gt; :$column$.attribute6,
 p_attribute7   =&gt; :$column$.attribute7,
 p_attribute8   =&gt; :$column$.attribute8,
 p_attribute9   =&gt; :$column$.attribute9,
 p_attribute10  =&gt; :$column$.attribute10,
 p_attribute11  =&gt; :$column$.attribute11,
 p_attribute12  =&gt; :$column$.attribute12,
 p_attribute13  =&gt; :$column$.attribute13,
 p_attribute14  =&gt; :$column$.attribute14,
 p_attribute15  =&gt; :$column$.attribute15
)
) lov
order by
value</LOV_QUERY_DSP>
    <COMMENTS>select
distinct
&apos;(Context) &apos; || initcap(dffcu.application_column_name) || &apos;: &apos; ||
listagg(decode(dffcx.descriptive_flex_context_code,&apos;Global Data Elements&apos;,&apos;(Global)&apos;,&apos;(&apos; || dffcx.descriptive_flex_context_code || &apos;)&apos;) || &apos; &apos; || dffcu.form_left_prompt,&apos;, &apos;) within group (order by decode(dffcx.descriptive_flex_context_code,&apos;Global Data Elements&apos;,1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name)
from
fnd_descriptive_flexs_vl dff,
fnd_descr_flex_contexts dffcx,
fnd_descr_flex_col_usage_vl dffcu
where
dffcx.application_id=dff.application_id and
dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and
dffcx.enabled_flag=&apos;Y&apos; and
dffcu.application_id=dffcx.application_id and
dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and
dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and
dffcu.enabled_flag=&apos;Y&apos; and
dff.application_id=401 and
dff.application_table_name=&apos;MTL_EAM_ASSET_ACTIVITIES&apos; and
dffcu.application_column_name=&apos;ATTRIBUTE3&apos;</COMMENTS>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>24</COLUMN_NUMBER>
    <COLUMN_NAME>ATTRIBUTE4</COLUMN_NAME>
    <COLUMN_TYPE_DSP>LOV custom</COLUMN_TYPE_DSP>
    <DATA_TYPE>varchar2</DATA_TYPE>
    <LOV_QUERY_DSP>select
substrb(lov.column_value,1,instrb(lov.column_value,&apos;~&apos;,1,1)-1) value,
substrb(lov.column_value,instrb(lov.column_value,&apos;~&apos;,1,1)+1,lengthb(lov.column_value)) description
from
table(
xxen_util.dff_attribute_lov
(p_application_id =&gt; 401,
 p_descriptive_flexfield_name =&gt; &apos;MTL_EAM_ASSET_ACTIVITIES&apos;,
 p_context_name =&gt; :$column$.attribute_category,
 p_column_name  =&gt; &apos;ATTRIBUTE4&apos;,
 p_attribute1   =&gt; :$column$.attribute1,
 p_attribute2   =&gt; :$column$.attribute2,
 p_attribute3   =&gt; :$column$.attribute3,
 p_attribute4   =&gt; :$column$.attribute4,
 p_attribute5   =&gt; :$column$.attribute5,
 p_attribute6   =&gt; :$column$.attribute6,
 p_attribute7   =&gt; :$column$.attribute7,
 p_attribute8   =&gt; :$column$.attribute8,
 p_attribute9   =&gt; :$column$.attribute9,
 p_attribute10  =&gt; :$column$.attribute10,
 p_attribute11  =&gt; :$column$.attribute11,
 p_attribute12  =&gt; :$column$.attribute12,
 p_attribute13  =&gt; :$column$.attribute13,
 p_attribute14  =&gt; :$column$.attribute14,
 p_attribute15  =&gt; :$column$.attribute15
)
) lov
order by
value</LOV_QUERY_DSP>
    <COMMENTS>select
distinct
&apos;(Context) &apos; || initcap(dffcu.application_column_name) || &apos;: &apos; ||
listagg(decode(dffcx.descriptive_flex_context_code,&apos;Global Data Elements&apos;,&apos;(Global)&apos;,&apos;(&apos; || dffcx.descriptive_flex_context_code || &apos;)&apos;) || &apos; &apos; || dffcu.form_left_prompt,&apos;, &apos;) within group (order by decode(dffcx.descriptive_flex_context_code,&apos;Global Data Elements&apos;,1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name)
from
fnd_descriptive_flexs_vl dff,
fnd_descr_flex_contexts dffcx,
fnd_descr_flex_col_usage_vl dffcu
where
dffcx.application_id=dff.application_id and
dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and
dffcx.enabled_flag=&apos;Y&apos; and
dffcu.application_id=dffcx.application_id and
dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and
dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and
dffcu.enabled_flag=&apos;Y&apos; and
dff.application_id=401 and
dff.application_table_name=&apos;MTL_EAM_ASSET_ACTIVITIES&apos; and
dffcu.application_column_name=&apos;ATTRIBUTE4&apos;</COMMENTS>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>25</COLUMN_NUMBER>
    <COLUMN_NAME>ATTRIBUTE5</COLUMN_NAME>
    <COLUMN_TYPE_DSP>LOV custom</COLUMN_TYPE_DSP>
    <DATA_TYPE>varchar2</DATA_TYPE>
    <LOV_QUERY_DSP>select
substrb(lov.column_value,1,instrb(lov.column_value,&apos;~&apos;,1,1)-1) value,
substrb(lov.column_value,instrb(lov.column_value,&apos;~&apos;,1,1)+1,lengthb(lov.column_value)) description
from
table(
xxen_util.dff_attribute_lov
(p_application_id =&gt; 401,
 p_descriptive_flexfield_name =&gt; &apos;MTL_EAM_ASSET_ACTIVITIES&apos;,
 p_context_name =&gt; :$column$.attribute_category,
 p_column_name  =&gt; &apos;ATTRIBUTE5&apos;,
 p_attribute1   =&gt; :$column$.attribute1,
 p_attribute2   =&gt; :$column$.attribute2,
 p_attribute3   =&gt; :$column$.attribute3,
 p_attribute4   =&gt; :$column$.attribute4,
 p_attribute5   =&gt; :$column$.attribute5,
 p_attribute6   =&gt; :$column$.attribute6,
 p_attribute7   =&gt; :$column$.attribute7,
 p_attribute8   =&gt; :$column$.attribute8,
 p_attribute9   =&gt; :$column$.attribute9,
 p_attribute10  =&gt; :$column$.attribute10,
 p_attribute11  =&gt; :$column$.attribute11,
 p_attribute12  =&gt; :$column$.attribute12,
 p_attribute13  =&gt; :$column$.attribute13,
 p_attribute14  =&gt; :$column$.attribute14,
 p_attribute15  =&gt; :$column$.attribute15
)
) lov
order by
value</LOV_QUERY_DSP>
    <COMMENTS>select
distinct
&apos;(Context) &apos; || initcap(dffcu.application_column_name) || &apos;: &apos; ||
listagg(decode(dffcx.descriptive_flex_context_code,&apos;Global Data Elements&apos;,&apos;(Global)&apos;,&apos;(&apos; || dffcx.descriptive_flex_context_code || &apos;)&apos;) || &apos; &apos; || dffcu.form_left_prompt,&apos;, &apos;) within group (order by decode(dffcx.descriptive_flex_context_code,&apos;Global Data Elements&apos;,1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name)
from
fnd_descriptive_flexs_vl dff,
fnd_descr_flex_contexts dffcx,
fnd_descr_flex_col_usage_vl dffcu
where
dffcx.application_id=dff.application_id and
dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and
dffcx.enabled_flag=&apos;Y&apos; and
dffcu.application_id=dffcx.application_id and
dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and
dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and
dffcu.enabled_flag=&apos;Y&apos; and
dff.application_id=401 and
dff.application_table_name=&apos;MTL_EAM_ASSET_ACTIVITIES&apos; and
dffcu.application_column_name=&apos;ATTRIBUTE5&apos;</COMMENTS>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>26</COLUMN_NUMBER>
    <COLUMN_NAME>ATTRIBUTE6</COLUMN_NAME>
    <COLUMN_TYPE_DSP>LOV custom</COLUMN_TYPE_DSP>
    <DATA_TYPE>varchar2</DATA_TYPE>
    <LOV_QUERY_DSP>select
substrb(lov.column_value,1,instrb(lov.column_value,&apos;~&apos;,1,1)-1) value,
substrb(lov.column_value,instrb(lov.column_value,&apos;~&apos;,1,1)+1,lengthb(lov.column_value)) description
from
table(
xxen_util.dff_attribute_lov
(p_application_id =&gt; 401,
 p_descriptive_flexfield_name =&gt; &apos;MTL_EAM_ASSET_ACTIVITIES&apos;,
 p_context_name =&gt; :$column$.attribute_category,
 p_column_name  =&gt; &apos;ATTRIBUTE6&apos;,
 p_attribute1   =&gt; :$column$.attribute1,
 p_attribute2   =&gt; :$column$.attribute2,
 p_attribute3   =&gt; :$column$.attribute3,
 p_attribute4   =&gt; :$column$.attribute4,
 p_attribute5   =&gt; :$column$.attribute5,
 p_attribute6   =&gt; :$column$.attribute6,
 p_attribute7   =&gt; :$column$.attribute7,
 p_attribute8   =&gt; :$column$.attribute8,
 p_attribute9   =&gt; :$column$.attribute9,
 p_attribute10  =&gt; :$column$.attribute10,
 p_attribute11  =&gt; :$column$.attribute11,
 p_attribute12  =&gt; :$column$.attribute12,
 p_attribute13  =&gt; :$column$.attribute13,
 p_attribute14  =&gt; :$column$.attribute14,
 p_attribute15  =&gt; :$column$.attribute15
)
) lov
order by
value</LOV_QUERY_DSP>
    <COMMENTS>select
distinct
&apos;(Context) &apos; || initcap(dffcu.application_column_name) || &apos;: &apos; ||
listagg(decode(dffcx.descriptive_flex_context_code,&apos;Global Data Elements&apos;,&apos;(Global)&apos;,&apos;(&apos; || dffcx.descriptive_flex_context_code || &apos;)&apos;) || &apos; &apos; || dffcu.form_left_prompt,&apos;, &apos;) within group (order by decode(dffcx.descriptive_flex_context_code,&apos;Global Data Elements&apos;,1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name)
from
fnd_descriptive_flexs_vl dff,
fnd_descr_flex_contexts dffcx,
fnd_descr_flex_col_usage_vl dffcu
where
dffcx.application_id=dff.application_id and
dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and
dffcx.enabled_flag=&apos;Y&apos; and
dffcu.application_id=dffcx.application_id and
dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and
dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and
dffcu.enabled_flag=&apos;Y&apos; and
dff.application_id=401 and
dff.application_table_name=&apos;MTL_EAM_ASSET_ACTIVITIES&apos; and
dffcu.application_column_name=&apos;ATTRIBUTE6&apos;</COMMENTS>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>27</COLUMN_NUMBER>
    <COLUMN_NAME>ATTRIBUTE7</COLUMN_NAME>
    <COLUMN_TYPE_DSP>LOV custom</COLUMN_TYPE_DSP>
    <DATA_TYPE>varchar2</DATA_TYPE>
    <LOV_QUERY_DSP>select
substrb(lov.column_value,1,instrb(lov.column_value,&apos;~&apos;,1,1)-1) value,
substrb(lov.column_value,instrb(lov.column_value,&apos;~&apos;,1,1)+1,lengthb(lov.column_value)) description
from
table(
xxen_util.dff_attribute_lov
(p_application_id =&gt; 401,
 p_descriptive_flexfield_name =&gt; &apos;MTL_EAM_ASSET_ACTIVITIES&apos;,
 p_context_name =&gt; :$column$.attribute_category,
 p_column_name  =&gt; &apos;ATTRIBUTE7&apos;,
 p_attribute1   =&gt; :$column$.attribute1,
 p_attribute2   =&gt; :$column$.attribute2,
 p_attribute3   =&gt; :$column$.attribute3,
 p_attribute4   =&gt; :$column$.attribute4,
 p_attribute5   =&gt; :$column$.attribute5,
 p_attribute6   =&gt; :$column$.attribute6,
 p_attribute7   =&gt; :$column$.attribute7,
 p_attribute8   =&gt; :$column$.attribute8,
 p_attribute9   =&gt; :$column$.attribute9,
 p_attribute10  =&gt; :$column$.attribute10,
 p_attribute11  =&gt; :$column$.attribute11,
 p_attribute12  =&gt; :$column$.attribute12,
 p_attribute13  =&gt; :$column$.attribute13,
 p_attribute14  =&gt; :$column$.attribute14,
 p_attribute15  =&gt; :$column$.attribute15
)
) lov
order by
value</LOV_QUERY_DSP>
    <COMMENTS>select
distinct
&apos;(Context) &apos; || initcap(dffcu.application_column_name) || &apos;: &apos; ||
listagg(decode(dffcx.descriptive_flex_context_code,&apos;Global Data Elements&apos;,&apos;(Global)&apos;,&apos;(&apos; || dffcx.descriptive_flex_context_code || &apos;)&apos;) || &apos; &apos; || dffcu.form_left_prompt,&apos;, &apos;) within group (order by decode(dffcx.descriptive_flex_context_code,&apos;Global Data Elements&apos;,1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name)
from
fnd_descriptive_flexs_vl dff,
fnd_descr_flex_contexts dffcx,
fnd_descr_flex_col_usage_vl dffcu
where
dffcx.application_id=dff.application_id and
dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and
dffcx.enabled_flag=&apos;Y&apos; and
dffcu.application_id=dffcx.application_id and
dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and
dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and
dffcu.enabled_flag=&apos;Y&apos; and
dff.application_id=401 and
dff.application_table_name=&apos;MTL_EAM_ASSET_ACTIVITIES&apos; and
dffcu.application_column_name=&apos;ATTRIBUTE7&apos;</COMMENTS>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>28</COLUMN_NUMBER>
    <COLUMN_NAME>ATTRIBUTE8</COLUMN_NAME>
    <COLUMN_TYPE_DSP>LOV custom</COLUMN_TYPE_DSP>
    <DATA_TYPE>varchar2</DATA_TYPE>
    <LOV_QUERY_DSP>select
substrb(lov.column_value,1,instrb(lov.column_value,&apos;~&apos;,1,1)-1) value,
substrb(lov.column_value,instrb(lov.column_value,&apos;~&apos;,1,1)+1,lengthb(lov.column_value)) description
from
table(
xxen_util.dff_attribute_lov
(p_application_id =&gt; 401,
 p_descriptive_flexfield_name =&gt; &apos;MTL_EAM_ASSET_ACTIVITIES&apos;,
 p_context_name =&gt; :$column$.attribute_category,
 p_column_name  =&gt; &apos;ATTRIBUTE8&apos;,
 p_attribute1   =&gt; :$column$.attribute1,
 p_attribute2   =&gt; :$column$.attribute2,
 p_attribute3   =&gt; :$column$.attribute3,
 p_attribute4   =&gt; :$column$.attribute4,
 p_attribute5   =&gt; :$column$.attribute5,
 p_attribute6   =&gt; :$column$.attribute6,
 p_attribute7   =&gt; :$column$.attribute7,
 p_attribute8   =&gt; :$column$.attribute8,
 p_attribute9   =&gt; :$column$.attribute9,
 p_attribute10  =&gt; :$column$.attribute10,
 p_attribute11  =&gt; :$column$.attribute11,
 p_attribute12  =&gt; :$column$.attribute12,
 p_attribute13  =&gt; :$column$.attribute13,
 p_attribute14  =&gt; :$column$.attribute14,
 p_attribute15  =&gt; :$column$.attribute15
)
) lov
order by
value</LOV_QUERY_DSP>
    <COMMENTS>select
distinct
&apos;(Context) &apos; || initcap(dffcu.application_column_name) || &apos;: &apos; ||
listagg(decode(dffcx.descriptive_flex_context_code,&apos;Global Data Elements&apos;,&apos;(Global)&apos;,&apos;(&apos; || dffcx.descriptive_flex_context_code || &apos;)&apos;) || &apos; &apos; || dffcu.form_left_prompt,&apos;, &apos;) within group (order by decode(dffcx.descriptive_flex_context_code,&apos;Global Data Elements&apos;,1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name)
from
fnd_descriptive_flexs_vl dff,
fnd_descr_flex_contexts dffcx,
fnd_descr_flex_col_usage_vl dffcu
where
dffcx.application_id=dff.application_id and
dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and
dffcx.enabled_flag=&apos;Y&apos; and
dffcu.application_id=dffcx.application_id and
dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and
dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and
dffcu.enabled_flag=&apos;Y&apos; and
dff.application_id=401 and
dff.application_table_name=&apos;MTL_EAM_ASSET_ACTIVITIES&apos; and
dffcu.application_column_name=&apos;ATTRIBUTE8&apos;</COMMENTS>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>29</COLUMN_NUMBER>
    <COLUMN_NAME>ATTRIBUTE9</COLUMN_NAME>
    <COLUMN_TYPE_DSP>LOV custom</COLUMN_TYPE_DSP>
    <DATA_TYPE>varchar2</DATA_TYPE>
    <LOV_QUERY_DSP>select
substrb(lov.column_value,1,instrb(lov.column_value,&apos;~&apos;,1,1)-1) value,
substrb(lov.column_value,instrb(lov.column_value,&apos;~&apos;,1,1)+1,lengthb(lov.column_value)) description
from
table(
xxen_util.dff_attribute_lov
(p_application_id =&gt; 401,
 p_descriptive_flexfield_name =&gt; &apos;MTL_EAM_ASSET_ACTIVITIES&apos;,
 p_context_name =&gt; :$column$.attribute_category,
 p_column_name  =&gt; &apos;ATTRIBUTE9&apos;,
 p_attribute1   =&gt; :$column$.attribute1,
 p_attribute2   =&gt; :$column$.attribute2,
 p_attribute3   =&gt; :$column$.attribute3,
 p_attribute4   =&gt; :$column$.attribute4,
 p_attribute5   =&gt; :$column$.attribute5,
 p_attribute6   =&gt; :$column$.attribute6,
 p_attribute7   =&gt; :$column$.attribute7,
 p_attribute8   =&gt; :$column$.attribute8,
 p_attribute9   =&gt; :$column$.attribute9,
 p_attribute10  =&gt; :$column$.attribute10,
 p_attribute11  =&gt; :$column$.attribute11,
 p_attribute12  =&gt; :$column$.attribute12,
 p_attribute13  =&gt; :$column$.attribute13,
 p_attribute14  =&gt; :$column$.attribute14,
 p_attribute15  =&gt; :$column$.attribute15
)
) lov
order by
value</LOV_QUERY_DSP>
    <COMMENTS>select
distinct
&apos;(Context) &apos; || initcap(dffcu.application_column_name) || &apos;: &apos; ||
listagg(decode(dffcx.descriptive_flex_context_code,&apos;Global Data Elements&apos;,&apos;(Global)&apos;,&apos;(&apos; || dffcx.descriptive_flex_context_code || &apos;)&apos;) || &apos; &apos; || dffcu.form_left_prompt,&apos;, &apos;) within group (order by decode(dffcx.descriptive_flex_context_code,&apos;Global Data Elements&apos;,1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name)
from
fnd_descriptive_flexs_vl dff,
fnd_descr_flex_contexts dffcx,
fnd_descr_flex_col_usage_vl dffcu
where
dffcx.application_id=dff.application_id and
dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and
dffcx.enabled_flag=&apos;Y&apos; and
dffcu.application_id=dffcx.application_id and
dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and
dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and
dffcu.enabled_flag=&apos;Y&apos; and
dff.application_id=401 and
dff.application_table_name=&apos;MTL_EAM_ASSET_ACTIVITIES&apos; and
dffcu.application_column_name=&apos;ATTRIBUTE9&apos;</COMMENTS>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>30</COLUMN_NUMBER>
    <COLUMN_NAME>ATTRIBUTE10</COLUMN_NAME>
    <COLUMN_TYPE_DSP>LOV custom</COLUMN_TYPE_DSP>
    <DATA_TYPE>varchar2</DATA_TYPE>
    <LOV_QUERY_DSP>select
substrb(lov.column_value,1,instrb(lov.column_value,&apos;~&apos;,1,1)-1) value,
substrb(lov.column_value,instrb(lov.column_value,&apos;~&apos;,1,1)+1,lengthb(lov.column_value)) description
from
table(
xxen_util.dff_attribute_lov
(p_application_id =&gt; 401,
 p_descriptive_flexfield_name =&gt; &apos;MTL_EAM_ASSET_ACTIVITIES&apos;,
 p_context_name =&gt; :$column$.attribute_category,
 p_column_name  =&gt; &apos;ATTRIBUTE10&apos;,
 p_attribute1   =&gt; :$column$.attribute1,
 p_attribute2   =&gt; :$column$.attribute2,
 p_attribute3   =&gt; :$column$.attribute3,
 p_attribute4   =&gt; :$column$.attribute4,
 p_attribute5   =&gt; :$column$.attribute5,
 p_attribute6   =&gt; :$column$.attribute6,
 p_attribute7   =&gt; :$column$.attribute7,
 p_attribute8   =&gt; :$column$.attribute8,
 p_attribute9   =&gt; :$column$.attribute9,
 p_attribute10  =&gt; :$column$.attribute10,
 p_attribute11  =&gt; :$column$.attribute11,
 p_attribute12  =&gt; :$column$.attribute12,
 p_attribute13  =&gt; :$column$.attribute13,
 p_attribute14  =&gt; :$column$.attribute14,
 p_attribute15  =&gt; :$column$.attribute15
)
) lov
order by
value</LOV_QUERY_DSP>
    <COMMENTS>select
distinct
&apos;(Context) &apos; || initcap(dffcu.application_column_name) || &apos;: &apos; ||
listagg(decode(dffcx.descriptive_flex_context_code,&apos;Global Data Elements&apos;,&apos;(Global)&apos;,&apos;(&apos; || dffcx.descriptive_flex_context_code || &apos;)&apos;) || &apos; &apos; || dffcu.form_left_prompt,&apos;, &apos;) within group (order by decode(dffcx.descriptive_flex_context_code,&apos;Global Data Elements&apos;,1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name)
from
fnd_descriptive_flexs_vl dff,
fnd_descr_flex_contexts dffcx,
fnd_descr_flex_col_usage_vl dffcu
where
dffcx.application_id=dff.application_id and
dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and
dffcx.enabled_flag=&apos;Y&apos; and
dffcu.application_id=dffcx.application_id and
dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and
dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and
dffcu.enabled_flag=&apos;Y&apos; and
dff.application_id=401 and
dff.application_table_name=&apos;MTL_EAM_ASSET_ACTIVITIES&apos; and
dffcu.application_column_name=&apos;ATTRIBUTE10&apos;</COMMENTS>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>31</COLUMN_NUMBER>
    <COLUMN_NAME>ATTRIBUTE11</COLUMN_NAME>
    <COLUMN_TYPE_DSP>LOV custom</COLUMN_TYPE_DSP>
    <DATA_TYPE>varchar2</DATA_TYPE>
    <LOV_QUERY_DSP>select
substrb(lov.column_value,1,instrb(lov.column_value,&apos;~&apos;,1,1)-1) value,
substrb(lov.column_value,instrb(lov.column_value,&apos;~&apos;,1,1)+1,lengthb(lov.column_value)) description
from
table(
xxen_util.dff_attribute_lov
(p_application_id =&gt; 401,
 p_descriptive_flexfield_name =&gt; &apos;MTL_EAM_ASSET_ACTIVITIES&apos;,
 p_context_name =&gt; :$column$.attribute_category,
 p_column_name  =&gt; &apos;ATTRIBUTE11&apos;,
 p_attribute1   =&gt; :$column$.attribute1,
 p_attribute2   =&gt; :$column$.attribute2,
 p_attribute3   =&gt; :$column$.attribute3,
 p_attribute4   =&gt; :$column$.attribute4,
 p_attribute5   =&gt; :$column$.attribute5,
 p_attribute6   =&gt; :$column$.attribute6,
 p_attribute7   =&gt; :$column$.attribute7,
 p_attribute8   =&gt; :$column$.attribute8,
 p_attribute9   =&gt; :$column$.attribute9,
 p_attribute10  =&gt; :$column$.attribute10,
 p_attribute11  =&gt; :$column$.attribute11,
 p_attribute12  =&gt; :$column$.attribute12,
 p_attribute13  =&gt; :$column$.attribute13,
 p_attribute14  =&gt; :$column$.attribute14,
 p_attribute15  =&gt; :$column$.attribute15
)
) lov
order by
value</LOV_QUERY_DSP>
    <COMMENTS>select
distinct
&apos;(Context) &apos; || initcap(dffcu.application_column_name) || &apos;: &apos; ||
listagg(decode(dffcx.descriptive_flex_context_code,&apos;Global Data Elements&apos;,&apos;(Global)&apos;,&apos;(&apos; || dffcx.descriptive_flex_context_code || &apos;)&apos;) || &apos; &apos; || dffcu.form_left_prompt,&apos;, &apos;) within group (order by decode(dffcx.descriptive_flex_context_code,&apos;Global Data Elements&apos;,1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name)
from
fnd_descriptive_flexs_vl dff,
fnd_descr_flex_contexts dffcx,
fnd_descr_flex_col_usage_vl dffcu
where
dffcx.application_id=dff.application_id and
dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and
dffcx.enabled_flag=&apos;Y&apos; and
dffcu.application_id=dffcx.application_id and
dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and
dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and
dffcu.enabled_flag=&apos;Y&apos; and
dff.application_id=401 and
dff.application_table_name=&apos;MTL_EAM_ASSET_ACTIVITIES&apos; and
dffcu.application_column_name=&apos;ATTRIBUTE11&apos;</COMMENTS>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>32</COLUMN_NUMBER>
    <COLUMN_NAME>ATTRIBUTE12</COLUMN_NAME>
    <COLUMN_TYPE_DSP>LOV custom</COLUMN_TYPE_DSP>
    <DATA_TYPE>varchar2</DATA_TYPE>
    <LOV_QUERY_DSP>select
substrb(lov.column_value,1,instrb(lov.column_value,&apos;~&apos;,1,1)-1) value,
substrb(lov.column_value,instrb(lov.column_value,&apos;~&apos;,1,1)+1,lengthb(lov.column_value)) description
from
table(
xxen_util.dff_attribute_lov
(p_application_id =&gt; 401,
 p_descriptive_flexfield_name =&gt; &apos;MTL_EAM_ASSET_ACTIVITIES&apos;,
 p_context_name =&gt; :$column$.attribute_category,
 p_column_name  =&gt; &apos;ATTRIBUTE12&apos;,
 p_attribute1   =&gt; :$column$.attribute1,
 p_attribute2   =&gt; :$column$.attribute2,
 p_attribute3   =&gt; :$column$.attribute3,
 p_attribute4   =&gt; :$column$.attribute4,
 p_attribute5   =&gt; :$column$.attribute5,
 p_attribute6   =&gt; :$column$.attribute6,
 p_attribute7   =&gt; :$column$.attribute7,
 p_attribute8   =&gt; :$column$.attribute8,
 p_attribute9   =&gt; :$column$.attribute9,
 p_attribute10  =&gt; :$column$.attribute10,
 p_attribute11  =&gt; :$column$.attribute11,
 p_attribute12  =&gt; :$column$.attribute12,
 p_attribute13  =&gt; :$column$.attribute13,
 p_attribute14  =&gt; :$column$.attribute14,
 p_attribute15  =&gt; :$column$.attribute15
)
) lov
order by
value</LOV_QUERY_DSP>
    <COMMENTS>select
distinct
&apos;(Context) &apos; || initcap(dffcu.application_column_name) || &apos;: &apos; ||
listagg(decode(dffcx.descriptive_flex_context_code,&apos;Global Data Elements&apos;,&apos;(Global)&apos;,&apos;(&apos; || dffcx.descriptive_flex_context_code || &apos;)&apos;) || &apos; &apos; || dffcu.form_left_prompt,&apos;, &apos;) within group (order by decode(dffcx.descriptive_flex_context_code,&apos;Global Data Elements&apos;,1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name)
from
fnd_descriptive_flexs_vl dff,
fnd_descr_flex_contexts dffcx,
fnd_descr_flex_col_usage_vl dffcu
where
dffcx.application_id=dff.application_id and
dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and
dffcx.enabled_flag=&apos;Y&apos; and
dffcu.application_id=dffcx.application_id and
dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and
dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and
dffcu.enabled_flag=&apos;Y&apos; and
dff.application_id=401 and
dff.application_table_name=&apos;MTL_EAM_ASSET_ACTIVITIES&apos; and
dffcu.application_column_name=&apos;ATTRIBUTE12&apos;</COMMENTS>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>33</COLUMN_NUMBER>
    <COLUMN_NAME>ATTRIBUTE13</COLUMN_NAME>
    <COLUMN_TYPE_DSP>LOV custom</COLUMN_TYPE_DSP>
    <DATA_TYPE>varchar2</DATA_TYPE>
    <LOV_QUERY_DSP>select
substrb(lov.column_value,1,instrb(lov.column_value,&apos;~&apos;,1,1)-1) value,
substrb(lov.column_value,instrb(lov.column_value,&apos;~&apos;,1,1)+1,lengthb(lov.column_value)) description
from
table(
xxen_util.dff_attribute_lov
(p_application_id =&gt; 401,
 p_descriptive_flexfield_name =&gt; &apos;MTL_EAM_ASSET_ACTIVITIES&apos;,
 p_context_name =&gt; :$column$.attribute_category,
 p_column_name  =&gt; &apos;ATTRIBUTE13&apos;,
 p_attribute1   =&gt; :$column$.attribute1,
 p_attribute2   =&gt; :$column$.attribute2,
 p_attribute3   =&gt; :$column$.attribute3,
 p_attribute4   =&gt; :$column$.attribute4,
 p_attribute5   =&gt; :$column$.attribute5,
 p_attribute6   =&gt; :$column$.attribute6,
 p_attribute7   =&gt; :$column$.attribute7,
 p_attribute8   =&gt; :$column$.attribute8,
 p_attribute9   =&gt; :$column$.attribute9,
 p_attribute10  =&gt; :$column$.attribute10,
 p_attribute11  =&gt; :$column$.attribute11,
 p_attribute12  =&gt; :$column$.attribute12,
 p_attribute13  =&gt; :$column$.attribute13,
 p_attribute14  =&gt; :$column$.attribute14,
 p_attribute15  =&gt; :$column$.attribute15
)
) lov
order by
value</LOV_QUERY_DSP>
    <COMMENTS>select
distinct
&apos;(Context) &apos; || initcap(dffcu.application_column_name) || &apos;: &apos; ||
listagg(decode(dffcx.descriptive_flex_context_code,&apos;Global Data Elements&apos;,&apos;(Global)&apos;,&apos;(&apos; || dffcx.descriptive_flex_context_code || &apos;)&apos;) || &apos; &apos; || dffcu.form_left_prompt,&apos;, &apos;) within group (order by decode(dffcx.descriptive_flex_context_code,&apos;Global Data Elements&apos;,1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name)
from
fnd_descriptive_flexs_vl dff,
fnd_descr_flex_contexts dffcx,
fnd_descr_flex_col_usage_vl dffcu
where
dffcx.application_id=dff.application_id and
dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and
dffcx.enabled_flag=&apos;Y&apos; and
dffcu.application_id=dffcx.application_id and
dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and
dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and
dffcu.enabled_flag=&apos;Y&apos; and
dff.application_id=401 and
dff.application_table_name=&apos;MTL_EAM_ASSET_ACTIVITIES&apos; and
dffcu.application_column_name=&apos;ATTRIBUTE13&apos;</COMMENTS>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>34</COLUMN_NUMBER>
    <COLUMN_NAME>ATTRIBUTE14</COLUMN_NAME>
    <COLUMN_TYPE_DSP>LOV custom</COLUMN_TYPE_DSP>
    <DATA_TYPE>varchar2</DATA_TYPE>
    <LOV_QUERY_DSP>select
substrb(lov.column_value,1,instrb(lov.column_value,&apos;~&apos;,1,1)-1) value,
substrb(lov.column_value,instrb(lov.column_value,&apos;~&apos;,1,1)+1,lengthb(lov.column_value)) description
from
table(
xxen_util.dff_attribute_lov
(p_application_id =&gt; 401,
 p_descriptive_flexfield_name =&gt; &apos;MTL_EAM_ASSET_ACTIVITIES&apos;,
 p_context_name =&gt; :$column$.attribute_category,
 p_column_name  =&gt; &apos;ATTRIBUTE14&apos;,
 p_attribute1   =&gt; :$column$.attribute1,
 p_attribute2   =&gt; :$column$.attribute2,
 p_attribute3   =&gt; :$column$.attribute3,
 p_attribute4   =&gt; :$column$.attribute4,
 p_attribute5   =&gt; :$column$.attribute5,
 p_attribute6   =&gt; :$column$.attribute6,
 p_attribute7   =&gt; :$column$.attribute7,
 p_attribute8   =&gt; :$column$.attribute8,
 p_attribute9   =&gt; :$column$.attribute9,
 p_attribute10  =&gt; :$column$.attribute10,
 p_attribute11  =&gt; :$column$.attribute11,
 p_attribute12  =&gt; :$column$.attribute12,
 p_attribute13  =&gt; :$column$.attribute13,
 p_attribute14  =&gt; :$column$.attribute14,
 p_attribute15  =&gt; :$column$.attribute15
)
) lov
order by
value</LOV_QUERY_DSP>
    <COMMENTS>select
distinct
&apos;(Context) &apos; || initcap(dffcu.application_column_name) || &apos;: &apos; ||
listagg(decode(dffcx.descriptive_flex_context_code,&apos;Global Data Elements&apos;,&apos;(Global)&apos;,&apos;(&apos; || dffcx.descriptive_flex_context_code || &apos;)&apos;) || &apos; &apos; || dffcu.form_left_prompt,&apos;, &apos;) within group (order by decode(dffcx.descriptive_flex_context_code,&apos;Global Data Elements&apos;,1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name)
from
fnd_descriptive_flexs_vl dff,
fnd_descr_flex_contexts dffcx,
fnd_descr_flex_col_usage_vl dffcu
where
dffcx.application_id=dff.application_id and
dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and
dffcx.enabled_flag=&apos;Y&apos; and
dffcu.application_id=dffcx.application_id and
dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and
dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and
dffcu.enabled_flag=&apos;Y&apos; and
dff.application_id=401 and
dff.application_table_name=&apos;MTL_EAM_ASSET_ACTIVITIES&apos; and
dffcu.application_column_name=&apos;ATTRIBUTE14&apos;</COMMENTS>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>35</COLUMN_NUMBER>
    <COLUMN_NAME>ATTRIBUTE15</COLUMN_NAME>
    <COLUMN_TYPE_DSP>LOV custom</COLUMN_TYPE_DSP>
    <DATA_TYPE>varchar2</DATA_TYPE>
    <LOV_QUERY_DSP>select
substrb(lov.column_value,1,instrb(lov.column_value,&apos;~&apos;,1,1)-1) value,
substrb(lov.column_value,instrb(lov.column_value,&apos;~&apos;,1,1)+1,lengthb(lov.column_value)) description
from
table(
xxen_util.dff_attribute_lov
(p_application_id =&gt; 401,
 p_descriptive_flexfield_name =&gt; &apos;MTL_EAM_ASSET_ACTIVITIES&apos;,
 p_context_name =&gt; :$column$.attribute_category,
 p_column_name  =&gt; &apos;ATTRIBUTE15&apos;,
 p_attribute1   =&gt; :$column$.attribute1,
 p_attribute2   =&gt; :$column$.attribute2,
 p_attribute3   =&gt; :$column$.attribute3,
 p_attribute4   =&gt; :$column$.attribute4,
 p_attribute5   =&gt; :$column$.attribute5,
 p_attribute6   =&gt; :$column$.attribute6,
 p_attribute7   =&gt; :$column$.attribute7,
 p_attribute8   =&gt; :$column$.attribute8,
 p_attribute9   =&gt; :$column$.attribute9,
 p_attribute10  =&gt; :$column$.attribute10,
 p_attribute11  =&gt; :$column$.attribute11,
 p_attribute12  =&gt; :$column$.attribute12,
 p_attribute13  =&gt; :$column$.attribute13,
 p_attribute14  =&gt; :$column$.attribute14,
 p_attribute15  =&gt; :$column$.attribute15
)
) lov
order by
value</LOV_QUERY_DSP>
    <COMMENTS>select
distinct
&apos;(Context) &apos; || initcap(dffcu.application_column_name) || &apos;: &apos; ||
listagg(decode(dffcx.descriptive_flex_context_code,&apos;Global Data Elements&apos;,&apos;(Global)&apos;,&apos;(&apos; || dffcx.descriptive_flex_context_code || &apos;)&apos;) || &apos; &apos; || dffcu.form_left_prompt,&apos;, &apos;) within group (order by decode(dffcx.descriptive_flex_context_code,&apos;Global Data Elements&apos;,1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name)
from
fnd_descriptive_flexs_vl dff,
fnd_descr_flex_contexts dffcx,
fnd_descr_flex_col_usage_vl dffcu
where
dffcx.application_id=dff.application_id and
dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and
dffcx.enabled_flag=&apos;Y&apos; and
dffcu.application_id=dffcx.application_id and
dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and
dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and
dffcu.enabled_flag=&apos;Y&apos; and
dff.application_id=401 and
dff.application_table_name=&apos;MTL_EAM_ASSET_ACTIVITIES&apos; and
dffcu.application_column_name=&apos;ATTRIBUTE15&apos;</COMMENTS>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>36</COLUMN_NUMBER>
    <COLUMN_NAME>ASSOC_ROW_ID</COLUMN_NAME>
    <COLUMN_TYPE_DSP>Number</COLUMN_TYPE_DSP>
    <DATA_TYPE>number</DATA_TYPE>
    <READ_ONLY>Y</READ_ONLY>
    <HIDDEN>Y</HIDDEN>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>37</COLUMN_NUMBER>
    <COLUMN_NAME>UPLOAD_ROW</COLUMN_NAME>
    <COLUMN_TYPE_DSP>Number</COLUMN_TYPE_DSP>
    <DATA_TYPE>number</DATA_TYPE>
    <READ_ONLY>Y</READ_ONLY>
    <HIDDEN>Y</HIDDEN>
   </UPLOAD_COLUMNS_ROW>
  </UPLOAD_COLUMNS>
  <UPLOAD_PARAMETERS>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>1</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>action_</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Char</PARAMETER_TYPE>
    <COLUMN_NAME>ACTION_CODE_</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>2</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>status_</PARAMETER_NAME>
    <IN_OUT>out</IN_OUT>
    <PARAMETER_TYPE>Char</PARAMETER_TYPE>
    <COLUMN_NAME>STATUS_CODE_</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>3</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>message_</PARAMETER_NAME>
    <IN_OUT>out</IN_OUT>
    <PARAMETER_TYPE>Char</PARAMETER_TYPE>
    <COLUMN_NAME>MESSAGE_</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>5</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_assoc_row_id</PARAMETER_NAME>
    <IN_OUT>in out</IN_OUT>
    <PARAMETER_TYPE>Char</PARAMETER_TYPE>
    <COLUMN_NAME>ASSOC_ROW_ID</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>6</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_organization_id</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Number</PARAMETER_TYPE>
    <DEFAULTED>Y</DEFAULTED>
    <COLUMN_NAME>MAINTENANCE_ORGANIZATION</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>7</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_activity_id</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Number</PARAMETER_TYPE>
    <DEFAULTED>Y</DEFAULTED>
    <COLUMN_NAME>ACTIVITY</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>8</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_asset_type</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Number</PARAMETER_TYPE>
    <DEFAULTED>Y</DEFAULTED>
    <COLUMN_NAME>ASSET_TYPE</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>9</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_asset_group_id</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Number</PARAMETER_TYPE>
    <DEFAULTED>Y</DEFAULTED>
    <COLUMN_NAME>ASSET_GROUP</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>10</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_instance_id</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Number</PARAMETER_TYPE>
    <DEFAULTED>Y</DEFAULTED>
    <COLUMN_NAME>ASSET_NUMBER</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>11</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_from_date</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Date</PARAMETER_TYPE>
    <DEFAULTED>Y</DEFAULTED>
    <COLUMN_NAME>FROM_DATE</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>12</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_to_date</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Date</PARAMETER_TYPE>
    <DEFAULTED>Y</DEFAULTED>
    <COLUMN_NAME>TO_DATE</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>13</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_priority</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Char</PARAMETER_TYPE>
    <DEFAULTED>Y</DEFAULTED>
    <COLUMN_NAME>PRIORITY</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>14</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_activity_cause</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Char</PARAMETER_TYPE>
    <DEFAULTED>Y</DEFAULTED>
    <COLUMN_NAME>ACTIVITY_CAUSE</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>15</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_activity_type</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Char</PARAMETER_TYPE>
    <DEFAULTED>Y</DEFAULTED>
    <COLUMN_NAME>ACTIVITY_TYPE</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>16</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_shutdown_type</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Char</PARAMETER_TYPE>
    <DEFAULTED>Y</DEFAULTED>
    <COLUMN_NAME>SHUTDOWN_TYPE</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>17</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_activity_source</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Char</PARAMETER_TYPE>
    <DEFAULTED>Y</DEFAULTED>
    <COLUMN_NAME>ACTIVITY_SOURCE</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>18</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_owning_department_id</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Number</PARAMETER_TYPE>
    <DEFAULTED>Y</DEFAULTED>
    <COLUMN_NAME>OWNING_DEPARTMENT</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>19</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_wip_accounting_class</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Char</PARAMETER_TYPE>
    <DEFAULTED>Y</DEFAULTED>
    <COLUMN_NAME>WIP_ACCOUNTING_CLASS</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>20</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_tagging_required</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Char</PARAMETER_TYPE>
    <DEFAULTED>Y</DEFAULTED>
    <COLUMN_NAME>TAGGING_REQUIRED</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>21</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_attribute_category</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Char</PARAMETER_TYPE>
    <DEFAULTED>Y</DEFAULTED>
    <COLUMN_NAME>ATTRIBUTE_CATEGORY</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>22</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_attribute1</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Char</PARAMETER_TYPE>
    <DEFAULTED>Y</DEFAULTED>
    <COLUMN_NAME>ATTRIBUTE1</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>23</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_attribute2</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Char</PARAMETER_TYPE>
    <DEFAULTED>Y</DEFAULTED>
    <COLUMN_NAME>ATTRIBUTE2</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>24</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_attribute3</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Char</PARAMETER_TYPE>
    <DEFAULTED>Y</DEFAULTED>
    <COLUMN_NAME>ATTRIBUTE3</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>25</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_attribute4</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Char</PARAMETER_TYPE>
    <DEFAULTED>Y</DEFAULTED>
    <COLUMN_NAME>ATTRIBUTE4</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>26</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_attribute5</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Char</PARAMETER_TYPE>
    <DEFAULTED>Y</DEFAULTED>
    <COLUMN_NAME>ATTRIBUTE5</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>27</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_attribute6</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Char</PARAMETER_TYPE>
    <DEFAULTED>Y</DEFAULTED>
    <COLUMN_NAME>ATTRIBUTE6</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>28</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_attribute7</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Char</PARAMETER_TYPE>
    <DEFAULTED>Y</DEFAULTED>
    <COLUMN_NAME>ATTRIBUTE7</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>29</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_attribute8</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Char</PARAMETER_TYPE>
    <DEFAULTED>Y</DEFAULTED>
    <COLUMN_NAME>ATTRIBUTE8</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>30</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_attribute9</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Char</PARAMETER_TYPE>
    <DEFAULTED>Y</DEFAULTED>
    <COLUMN_NAME>ATTRIBUTE9</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>31</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_attribute10</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Char</PARAMETER_TYPE>
    <DEFAULTED>Y</DEFAULTED>
    <COLUMN_NAME>ATTRIBUTE10</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>32</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_attribute11</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Char</PARAMETER_TYPE>
    <DEFAULTED>Y</DEFAULTED>
    <COLUMN_NAME>ATTRIBUTE11</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>33</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_attribute12</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Char</PARAMETER_TYPE>
    <DEFAULTED>Y</DEFAULTED>
    <COLUMN_NAME>ATTRIBUTE12</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>34</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_attribute13</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Char</PARAMETER_TYPE>
    <DEFAULTED>Y</DEFAULTED>
    <COLUMN_NAME>ATTRIBUTE13</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>35</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_attribute14</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Char</PARAMETER_TYPE>
    <DEFAULTED>Y</DEFAULTED>
    <COLUMN_NAME>ATTRIBUTE14</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>36</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_attribute15</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Char</PARAMETER_TYPE>
    <DEFAULTED>Y</DEFAULTED>
    <COLUMN_NAME>ATTRIBUTE15</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
  </UPLOAD_PARAMETERS>
  <UPLOAD_SQLS>
   <UPLOAD_SQLS_ROW>
    <SQL_TYPE>Error SQL</SQL_TYPE>
   </UPLOAD_SQLS_ROW>
   <UPLOAD_SQLS_ROW>
    <SQL_TYPE>Order By</SQL_TYPE>
    <SQL_TEXT>upload_row,
maintenance_organization,
activity,
asset_group,
asset_number</SQL_TEXT>
   </UPLOAD_SQLS_ROW>
   <UPLOAD_SQLS_ROW>
    <SQL_TYPE>Success SQL</SQL_TYPE>
    <SQL_TEXT>select
xu.action_,
xu.status_,
xu.message_,
xu.modified_columns_,
nvl(y.maintenance_organization,xu.maintenance_organization) maintenance_organization,
nvl(y.activity,xu.activity) activity,
nvl(y.asset_type,xu.asset_type) asset_type,
nvl(y.asset_group,xu.asset_group) asset_group,
nvl(y.asset_number,xu.asset_number) asset_number,
nvl(y.from_date,xu.from_date) from_date,
nvl(y.to_date,xu.to_date) to_date,
nvl(y.priority,xu.priority) priority,
nvl(y.activity_cause,xu.activity_cause) activity_cause,
nvl(y.activity_type,xu.activity_type) activity_type,
nvl(y.shutdown_type,xu.shutdown_type) shutdown_type,
nvl(y.activity_source,xu.activity_source) activity_source,
nvl(y.owning_department,xu.owning_department) owning_department,
nvl(y.wip_accounting_class,xu.wip_accounting_class) wip_accounting_class,
nvl(y.tagging_required,xu.tagging_required) tagging_required,
nvl(y.attribute_category,xu.attribute_category) attribute_category,
nvl(y.attribute1,xu.attribute1) attribute1,
nvl(y.attribute2,xu.attribute2) attribute2,
nvl(y.attribute3,xu.attribute3) attribute3,
nvl(y.attribute4,xu.attribute4) attribute4,
nvl(y.attribute5,xu.attribute5) attribute5,
nvl(y.attribute6,xu.attribute6) attribute6,
nvl(y.attribute7,xu.attribute7) attribute7,
nvl(y.attribute8,xu.attribute8) attribute8,
nvl(y.attribute9,xu.attribute9) attribute9,
nvl(y.attribute10,xu.attribute10) attribute10,
nvl(y.attribute11,xu.attribute11) attribute11,
nvl(y.attribute12,xu.attribute12) attribute12,
nvl(y.attribute13,xu.attribute13) attribute13,
nvl(y.attribute14,xu.attribute14) attribute14,
nvl(y.attribute15,xu.attribute15) attribute15,
y.assoc_row_id,
xu.upload_row
from
xxen_eam_asset_activity_1220_u xu,
(
select
x.organization_code maintenance_organization,
x.activity,
xxen_util.meaning(to_char(decode(x.maintenance_object_type,2,decode(msi_grp.eam_item_type,1,1,3),3,decode(msi_grp.eam_item_type,1,1,3),nvl(msi_grp.eam_item_type,1))),&apos;MTL_EAM_ITEM_TYPE&apos;,700) asset_type,
msi_grp.concatenated_segments asset_group,
x.instance_number asset_number,
x.start_date_active from_date,
x.end_date_active to_date,
xxen_util.meaning(x.priority_code,&apos;WIP_EAM_ACTIVITY_PRIORITY&apos;,700) priority,
xxen_util.meaning(x.eomd_activity_cause_code,&apos;MTL_EAM_ACTIVITY_CAUSE&apos;,700) activity_cause,
xxen_util.meaning(x.eomd_activity_type_code,&apos;MTL_EAM_ACTIVITY_TYPE&apos;,700) activity_type,
xxen_util.meaning(x.eomd_shutdown_type_code,&apos;BOM_EAM_SHUTDOWN_TYPE&apos;,700) shutdown_type,
xxen_util.meaning(x.eomd_activity_source_code,&apos;MTL_EAM_ACTIVITY_SOURCE&apos;,700) activity_source,
bd.department_code owning_department,
x.eomd_accounting_class_code wip_accounting_class,
xxen_util.yes(x.eomd_tagging_required_flag) tagging_required,
xxen_util.display_flexfield_context(401,&apos;MTL_EAM_ASSET_ACTIVITIES&apos;,x.attribute_category) attribute_category,
xxen_util.display_flexfield_value(401,&apos;MTL_EAM_ASSET_ACTIVITIES&apos;,x.attribute_category,&apos;ATTRIBUTE1&apos;,x.row_id,x.attribute1) attribute1,
xxen_util.display_flexfield_value(401,&apos;MTL_EAM_ASSET_ACTIVITIES&apos;,x.attribute_category,&apos;ATTRIBUTE2&apos;,x.row_id,x.attribute2) attribute2,
xxen_util.display_flexfield_value(401,&apos;MTL_EAM_ASSET_ACTIVITIES&apos;,x.attribute_category,&apos;ATTRIBUTE3&apos;,x.row_id,x.attribute3) attribute3,
xxen_util.display_flexfield_value(401,&apos;MTL_EAM_ASSET_ACTIVITIES&apos;,x.attribute_category,&apos;ATTRIBUTE4&apos;,x.row_id,x.attribute4) attribute4,
xxen_util.display_flexfield_value(401,&apos;MTL_EAM_ASSET_ACTIVITIES&apos;,x.attribute_category,&apos;ATTRIBUTE5&apos;,x.row_id,x.attribute5) attribute5,
xxen_util.display_flexfield_value(401,&apos;MTL_EAM_ASSET_ACTIVITIES&apos;,x.attribute_category,&apos;ATTRIBUTE6&apos;,x.row_id,x.attribute6) attribute6,
xxen_util.display_flexfield_value(401,&apos;MTL_EAM_ASSET_ACTIVITIES&apos;,x.attribute_category,&apos;ATTRIBUTE7&apos;,x.row_id,x.attribute7) attribute7,
xxen_util.display_flexfield_value(401,&apos;MTL_EAM_ASSET_ACTIVITIES&apos;,x.attribute_category,&apos;ATTRIBUTE8&apos;,x.row_id,x.attribute8) attribute8,
xxen_util.display_flexfield_value(401,&apos;MTL_EAM_ASSET_ACTIVITIES&apos;,x.attribute_category,&apos;ATTRIBUTE9&apos;,x.row_id,x.attribute9) attribute9,
xxen_util.display_flexfield_value(401,&apos;MTL_EAM_ASSET_ACTIVITIES&apos;,x.attribute_category,&apos;ATTRIBUTE10&apos;,x.row_id,x.attribute10) attribute10,
xxen_util.display_flexfield_value(401,&apos;MTL_EAM_ASSET_ACTIVITIES&apos;,x.attribute_category,&apos;ATTRIBUTE11&apos;,x.row_id,x.attribute11) attribute11,
xxen_util.display_flexfield_value(401,&apos;MTL_EAM_ASSET_ACTIVITIES&apos;,x.attribute_category,&apos;ATTRIBUTE12&apos;,x.row_id,x.attribute12) attribute12,
xxen_util.display_flexfield_value(401,&apos;MTL_EAM_ASSET_ACTIVITIES&apos;,x.attribute_category,&apos;ATTRIBUTE13&apos;,x.row_id,x.attribute13) attribute13,
xxen_util.display_flexfield_value(401,&apos;MTL_EAM_ASSET_ACTIVITIES&apos;,x.attribute_category,&apos;ATTRIBUTE14&apos;,x.row_id,x.attribute14) attribute14,
xxen_util.display_flexfield_value(401,&apos;MTL_EAM_ASSET_ACTIVITIES&apos;,x.attribute_category,&apos;ATTRIBUTE15&apos;,x.row_id,x.attribute15) attribute15,
x.activity_association_id assoc_row_id
from
(
select
meaa.*,
meaa.rowid row_id,
mp.organization_id maint_organization_id,
mp.organization_code,
msi_act.concatenated_segments activity,
cii.instance_number,
decode(meaa.maintenance_object_type,3,cii.inventory_item_id,2,meaa.maintenance_object_id) asset_group_id,
eomd.owning_department_id eomd_owning_department_id,
eomd.accounting_class_code eomd_accounting_class_code,
eomd.activity_cause_code eomd_activity_cause_code,
eomd.activity_type_code eomd_activity_type_code,
eomd.activity_source_code eomd_activity_source_code,
eomd.shutdown_type_code eomd_shutdown_type_code,
eomd.tagging_required_flag eomd_tagging_required_flag
from
inv.mtl_eam_asset_activities meaa,
eam_org_maint_defaults eomd,
mtl_parameters mp,
mtl_system_items_b_kfv msi_act,
csi_item_instances cii
where
nvl(meaa.tmpl_flag,&apos;N&apos;)=&apos;N&apos; and
decode(meaa.maintenance_object_type,2,40,60)=eomd.object_type(+) and
meaa.activity_association_id=eomd.object_id(+) and
nvl(eomd.organization_id,meaa.organization_id)=mp.organization_id and
meaa.asset_activity_id=msi_act.inventory_item_id and
mp.organization_id=msi_act.organization_id and
decode(meaa.maintenance_object_type,3,meaa.maintenance_object_id)=cii.instance_id(+)
) x,
mtl_system_items_b_kfv msi_grp,
bom_departments bd
where
x.asset_group_id=msi_grp.inventory_item_id(+) and
x.maint_organization_id=msi_grp.organization_id(+) and
x.eomd_owning_department_id=bd.department_id(+)
) y
where
xu.status_code_=xxen_upload.status_success and
to_number(xu.assoc_row_id)=y.assoc_row_id(+) and
xu.maintenance_organization=y.maintenance_organization(+)</SQL_TEXT>
   </UPLOAD_SQLS_ROW>
  </UPLOAD_SQLS>
 </REPORTS_ROW>
</REPORTS>
</ROOT>
