<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 Failure Sets Upload -->
 <REPORTS_ROW>
  <GUID>EA11F501A1B2C3D4E5F60718293A4B5C</GUID><ENABLED>Y</ENABLED>
  <SQL_TEXT>select
x.*,
rownum upload_row
from
(
select
null action_,
null status_,
null message_,
null modified_columns_,
efs.set_name,
efs.description set_description,
efs.effective_end_date set_effective_end_date,
&apos;SET&apos; row_type,
cast(null as varchar2(240)) inventory_item,
cast(null as varchar2(10)) failure_code_required,
cast(null as date) association_effective_end_date,
cast(null as varchar2(80)) failure_code,
cast(null as varchar2(80)) cause_code,
cast(null as varchar2(80)) resolution_code,
cast(null as date) combination_effective_end_date,
cast(null as varchar2(10)) delete_record
from
eam_failure_sets efs
where
2=2
union all
select
null action_,
null status_,
null message_,
null modified_columns_,
efs.set_name,
cast(null as varchar2(240)) set_description,
cast(null as date) set_effective_end_date,
&apos;ASSOCIATION&apos; row_type,
(select msibk.concatenated_segments from mtl_system_items_b_kfv msibk where efsa.inventory_item_id=msibk.inventory_item_id and rownum=1) inventory_item,
decode(efsa.failure_code_required,&apos;Y&apos;,xxen_util.meaning(&apos;Y&apos;,&apos;YES_NO&apos;,0)) failure_code_required,
efsa.effective_end_date association_effective_end_date,
cast(null as varchar2(80)) failure_code,
cast(null as varchar2(80)) cause_code,
cast(null as varchar2(80)) resolution_code,
cast(null as date) combination_effective_end_date,
cast(null as varchar2(10)) delete_record
from
eam_failure_sets efs,
eam_failure_set_associations efsa
where
efs.set_id=efsa.set_id and
2=2
union all
select
null action_,
null status_,
null message_,
null modified_columns_,
efs.set_name,
cast(null as varchar2(240)) set_description,
cast(null as date) set_effective_end_date,
&apos;COMBINATION&apos; row_type,
cast(null as varchar2(240)) inventory_item,
cast(null as varchar2(10)) failure_code_required,
cast(null as date) association_effective_end_date,
efc.failure_code,
efc.cause_code,
efc.resolution_code,
efc.effective_end_date combination_effective_end_date,
cast(null as varchar2(10)) delete_record
from
eam_failure_sets efs,
eam_failure_combinations efc
where
efs.set_id=efc.set_id and
2=2
) x
where
1=1</SQL_TEXT>
  <VERSION_COMMENTS>Upload Mode Create downloads no rows; associations and the Inventory Item list show an item once instead of once per master organization; result report shows the stored values; Delete Record offered on association and combination rows only.</VERSION_COMMENTS>
  <TYPE>U</TYPE>
  <UPLOAD_TYPE>A</UPLOAD_TYPE>
  <UPLOAD_OBJECT>xxen_eam_upload.upload_failure_sets</UPLOAD_OBJECT>
  <UPLOAD_EXCEL_VALIDATION>xxen_eam_upload.validate_failure_set_row(
:$column$.row_type,
:$column$.inventory_item,
:$column$.failure_code,
:$column$.cause_code,
:$column$.resolution_code
)</UPLOAD_EXCEL_VALIDATION>
  <REPORT_TRANSLATIONS>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>US</LANGUAGE>
    <REPORT_NAME>EAM Failure Sets Upload</REPORT_NAME>
    <DESCRIPTION>Create and update EAM failure sets with their asset group and rebuildable item associations and their failure, cause and resolution code combinations. One row is one SET, ASSOCIATION or COMBINATION, and the rows of a set share its Set Name.

A new ASSOCIATION or COMBINATION row creates its failure set when no set of that name exists, from the row&apos;s Set Description and Set Effective End Date.

The associated item is an asset group or rebuildable item of a master organization. The codes of a combination must exist (EAM Failure Codes Upload).

A failure set cannot be deleted; end-date it with Set Effective End Date, and clear the date to reactivate it. Delete Record ends an association or deletes a combination.
</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>2=2</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</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>2=2</ANCHOR>
    <SQL_TEXT>efs.set_name=:p_set_name</SQL_TEXT>
    <PARAMETER_TYPE_DSP>LOV custom</PARAMETER_TYPE_DSP>
    <LOV_QUERY_DSP>select
efs.set_name value,
efs.description
from
eam_failure_sets efs
order by
efs.set_name</LOV_QUERY_DSP>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Set Name</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
  </PARAMETERS>
  <TEMPLATES>
   <TEMPLATES_ROW>
    <GUID>E8D4CB4203B745B3BFB51DDF011A277F</GUID>
    <TEMPLATE_NAME>Default</TEMPLATE_NAME>
    <DESCRIPTION>All columns.</DESCRIPTION>
    <OWNER>ENGINATICS</OWNER>
    <TEMPLATE_COLUMNS>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>7</DISPLAY_SEQUENCE>
      <COLUMN_NAME>ASSOCIATION_EFFECTIVE_END_DATE</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>9</DISPLAY_SEQUENCE>
      <COLUMN_NAME>CAUSE_CODE</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>11</DISPLAY_SEQUENCE>
      <COLUMN_NAME>COMBINATION_EFFECTIVE_END_DATE</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>12</DISPLAY_SEQUENCE>
      <COLUMN_NAME>DELETE_RECORD</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>8</DISPLAY_SEQUENCE>
      <COLUMN_NAME>FAILURE_CODE</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>6</DISPLAY_SEQUENCE>
      <COLUMN_NAME>FAILURE_CODE_REQUIRED</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>5</DISPLAY_SEQUENCE>
      <COLUMN_NAME>INVENTORY_ITEM</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>10</DISPLAY_SEQUENCE>
      <COLUMN_NAME>RESOLUTION_CODE</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>4</DISPLAY_SEQUENCE>
      <COLUMN_NAME>ROW_TYPE</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>2</DISPLAY_SEQUENCE>
      <COLUMN_NAME>SET_DESCRIPTION</COLUMN_NAME>
      <FREEZE_PANES>Y</FREEZE_PANES>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>3</DISPLAY_SEQUENCE>
      <COLUMN_NAME>SET_EFFECTIVE_END_DATE</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>1</DISPLAY_SEQUENCE>
      <COLUMN_NAME>SET_NAME</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>E8D4CB4203B745B3BFB51DDF011A277F</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>SET_NAME</COLUMN_NAME>
    <COLUMN_TYPE_DSP>Char</COLUMN_TYPE_DSP>
    <DATA_TYPE>varchar2</DATA_TYPE>
    <DATA_LENGTH>80</DATA_LENGTH>
    <COMMENTS>Name of the failure set (unique). Repeat across child rows that belong to the same set.</COMMENTS>
    <REQUIRED>Y</REQUIRED>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>6</COLUMN_NUMBER>
    <COLUMN_NAME>SET_DESCRIPTION</COLUMN_NAME>
    <COLUMN_TYPE_DSP>Char</COLUMN_TYPE_DSP>
    <DATA_TYPE>varchar2</DATA_TYPE>
    <DATA_LENGTH>240</DATA_LENGTH>
    <COMMENTS>Description of the failure set. Processed on SET rows and on Create child rows when the failure set header does not exist yet.</COMMENTS>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>7</COLUMN_NUMBER>
    <COLUMN_NAME>SET_EFFECTIVE_END_DATE</COLUMN_NAME>
    <COLUMN_TYPE_DSP>Date</COLUMN_TYPE_DSP>
    <DATA_TYPE>date</DATA_TYPE>
    <COMMENTS>Effective end date of the failure set, on SET rows, and on a new child row that creates its failure set. Clearing it reactivates the set.</COMMENTS>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>8</COLUMN_NUMBER>
    <COLUMN_NAME>ROW_TYPE</COLUMN_NAME>
    <COLUMN_TYPE_DSP>LOV custom</COLUMN_TYPE_DSP>
    <DATA_TYPE>varchar2</DATA_TYPE>
    <DATA_LENGTH>11</DATA_LENGTH>
    <LOV_QUERY_DSP>select
&apos;SET&apos; value,
&apos;Failure Set Header&apos; description
from
dual
union all
select
&apos;ASSOCIATION&apos; value,
&apos;Asset Group Item Association&apos; description
from
dual
union all
select
&apos;COMBINATION&apos; value,
&apos;Failure / Cause / Resolution Combination&apos; description
from
dual</LOV_QUERY_DSP>
    <COMMENTS>Row type: SET = failure set header; ASSOCIATION = set to asset-group item link; COMBINATION = failure/cause/resolution triple within a set.</COMMENTS>
    <REQUIRED>Y</REQUIRED>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>9</COLUMN_NUMBER>
    <COLUMN_NAME>INVENTORY_ITEM</COLUMN_NAME>
    <COLUMN_TYPE_DSP>LOV custom</COLUMN_TYPE_DSP>
    <DATA_TYPE>varchar2</DATA_TYPE>
    <DATA_LENGTH>240</DATA_LENGTH>
    <LOV_QUERY_DSP>select
x.inventory_item_id id,
x.concatenated_segments value,
x.description
from
(
select
msibk.inventory_item_id,
msibk.concatenated_segments,
msibk.description,
row_number() over (partition by msibk.inventory_item_id order by msibk.organization_id) rn
from
mtl_system_items_b_kfv msibk,
mtl_parameters mp
where
msibk.organization_id=mp.organization_id and
mp.master_organization_id=mp.organization_id and
msibk.eam_item_type in (1,3)
) x
where
x.rn=1
order by
x.concatenated_segments</LOV_QUERY_DSP>
    <VALUE_TO_ID_QUERY>select
x.inventory_item_id id,
x.concatenated_segments value
from
(
select
msibk.inventory_item_id,
msibk.concatenated_segments,
msibk.description,
row_number() over (partition by msibk.inventory_item_id order by msibk.organization_id) rn
from
mtl_system_items_b_kfv msibk,
mtl_parameters mp
where
msibk.organization_id=mp.organization_id and
mp.master_organization_id=mp.organization_id and
msibk.eam_item_type in (1,3)
) x
where
x.rn=1</VALUE_TO_ID_QUERY>
    <COMMENTS>Asset group or rebuildable item of a master organization. Required on ASSOCIATION rows.</COMMENTS>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>10</COLUMN_NUMBER>
    <COLUMN_NAME>FAILURE_CODE_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>
    <COMMENTS>Yes: work order completions against the associated asset-group item must record a failure code. Blank = not required. Only used on ASSOCIATION rows.</COMMENTS>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>11</COLUMN_NUMBER>
    <COLUMN_NAME>ASSOCIATION_EFFECTIVE_END_DATE</COLUMN_NAME>
    <COLUMN_TYPE_DSP>Date</COLUMN_TYPE_DSP>
    <DATA_TYPE>date</DATA_TYPE>
    <COMMENTS>Effective end date of the association. Blank = active. Only used on ASSOCIATION rows.</COMMENTS>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>12</COLUMN_NUMBER>
    <COLUMN_NAME>FAILURE_CODE</COLUMN_NAME>
    <COLUMN_TYPE_DSP>LOV custom</COLUMN_TYPE_DSP>
    <DATA_TYPE>varchar2</DATA_TYPE>
    <DATA_LENGTH>80</DATA_LENGTH>
    <LOV_QUERY_DSP>select
efc.failure_code value,
efc.description
from
eam_failure_codes efc
where
nvl(efc.effective_end_date,sysdate+1)&gt;trunc(sysdate)
order by
efc.failure_code</LOV_QUERY_DSP>
    <COMMENTS>Failure code. Must already exist in EAM Failure Codes setup. Required on COMBINATION rows.</COMMENTS>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>13</COLUMN_NUMBER>
    <COLUMN_NAME>CAUSE_CODE</COLUMN_NAME>
    <COLUMN_TYPE_DSP>LOV custom</COLUMN_TYPE_DSP>
    <DATA_TYPE>varchar2</DATA_TYPE>
    <DATA_LENGTH>80</DATA_LENGTH>
    <LOV_QUERY_DSP>select
ecc.cause_code value,
ecc.description
from
eam_cause_codes ecc
where
nvl(ecc.effective_end_date,sysdate+1)&gt;trunc(sysdate)
order by
ecc.cause_code</LOV_QUERY_DSP>
    <COMMENTS>Cause code. Must already exist in EAM Cause Codes setup. Required on COMBINATION rows.</COMMENTS>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>14</COLUMN_NUMBER>
    <COLUMN_NAME>RESOLUTION_CODE</COLUMN_NAME>
    <COLUMN_TYPE_DSP>LOV custom</COLUMN_TYPE_DSP>
    <DATA_TYPE>varchar2</DATA_TYPE>
    <DATA_LENGTH>80</DATA_LENGTH>
    <LOV_QUERY_DSP>select
erc.resolution_code value,
erc.description
from
eam_resolution_codes erc
where
nvl(erc.effective_end_date,sysdate+1)&gt;trunc(sysdate)
order by
erc.resolution_code</LOV_QUERY_DSP>
    <COMMENTS>Resolution code. Must already exist in EAM Resolution Codes setup. Required on COMBINATION rows.</COMMENTS>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>15</COLUMN_NUMBER>
    <COLUMN_NAME>COMBINATION_EFFECTIVE_END_DATE</COLUMN_NAME>
    <COLUMN_TYPE_DSP>Date</COLUMN_TYPE_DSP>
    <DATA_TYPE>date</DATA_TYPE>
    <COMMENTS>Effective end date of the combination. Blank = active. Only used on COMBINATION rows.</COMMENTS>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>16</COLUMN_NUMBER>
    <COLUMN_NAME>DELETE_RECORD</COLUMN_NAME>
    <COLUMN_TYPE_DSP>LOV custom</COLUMN_TYPE_DSP>
    <DATA_TYPE>varchar2</DATA_TYPE>
    <DATA_LENGTH>10</DATA_LENGTH>
    <LOV_QUERY_DSP>select &apos;Y&apos; id, xxen_util.meaning(&apos;Y&apos;,&apos;YES_NO&apos;,0) value, null description from dual where :$column$.row_type in (&apos;ASSOCIATION&apos;,&apos;COMBINATION&apos;)</LOV_QUERY_DSP>
    <COMMENTS>Yes ends an association or deletes a combination. A failure set cannot be deleted: end-date it with Set Effective End Date.</COMMENTS>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>17</COLUMN_NUMBER>
    <COLUMN_NAME>UPLOAD_ROW</COLUMN_NAME>
    <COLUMN_TYPE_DSP>Number</COLUMN_TYPE_DSP>
    <DATA_TYPE>number</DATA_TYPE>
    <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>4</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_set_name</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Char</PARAMETER_TYPE>
    <COLUMN_NAME>SET_NAME</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>5</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_set_description</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Char</PARAMETER_TYPE>
    <COLUMN_NAME>SET_DESCRIPTION</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>6</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_set_effective_end_date</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Date</PARAMETER_TYPE>
    <COLUMN_NAME>SET_EFFECTIVE_END_DATE</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>7</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_row_type</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Char</PARAMETER_TYPE>
    <COLUMN_NAME>ROW_TYPE</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>8</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_inventory_item_id</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Number</PARAMETER_TYPE>
    <COLUMN_NAME>INVENTORY_ITEM</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>9</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_failure_code_required</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Char</PARAMETER_TYPE>
    <COLUMN_NAME>FAILURE_CODE_REQUIRED</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>10</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_assoc_effective_end_date</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Date</PARAMETER_TYPE>
    <COLUMN_NAME>ASSOCIATION_EFFECTIVE_END_DATE</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>11</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_failure_code</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Char</PARAMETER_TYPE>
    <COLUMN_NAME>FAILURE_CODE</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>12</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_cause_code</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Char</PARAMETER_TYPE>
    <COLUMN_NAME>CAUSE_CODE</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>13</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_resolution_code</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Char</PARAMETER_TYPE>
    <COLUMN_NAME>RESOLUTION_CODE</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>14</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_combo_effective_end_date</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Date</PARAMETER_TYPE>
    <COLUMN_NAME>COMBINATION_EFFECTIVE_END_DATE</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>15</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_delete_record</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Char</PARAMETER_TYPE>
    <COLUMN_NAME>DELETE_RECORD</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>set_name,
decode(row_type,&apos;SET&apos;,1,&apos;ASSOCIATION&apos;,2,&apos;COMBINATION&apos;,3,4),
inventory_item,
failure_code,
cause_code,
resolution_code</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_,
xu.set_name,
nvl(decode(xu.row_type,&apos;SET&apos;,efs.description),xu.set_description) set_description,
nvl(decode(xu.row_type,&apos;SET&apos;,efs.effective_end_date),xu.set_effective_end_date) set_effective_end_date,
xu.row_type,
nvl(a.inventory_item,xu.inventory_item) inventory_item,
nvl(xxen_util.yes(a.failure_code_required),xu.failure_code_required) failure_code_required,
nvl(a.effective_end_date,xu.association_effective_end_date) association_effective_end_date,
nvl(c.failure_code,xu.failure_code) failure_code,
nvl(c.cause_code,xu.cause_code) cause_code,
nvl(c.resolution_code,xu.resolution_code) resolution_code,
nvl(c.effective_end_date,xu.combination_effective_end_date) combination_effective_end_date,
xu.delete_record,
xu.upload_row
from
xxen_eam_failure_sets_u_0610_u xu,
eam_failure_sets efs,
(
select
efs.set_name,
(select msibk.concatenated_segments from mtl_system_items_b_kfv msibk where efsa.inventory_item_id=msibk.inventory_item_id and rownum=1) inventory_item,
efsa.failure_code_required,
efsa.effective_end_date
from
eam_failure_sets efs,
eam_failure_set_associations efsa
where
efs.set_id=efsa.set_id
) a,
(
select
efs.set_name,
efc.failure_code,
efc.cause_code,
efc.resolution_code,
efc.effective_end_date
from
eam_failure_sets efs,
eam_failure_combinations efc
where
efs.set_id=efc.set_id
) c
where
xu.status_code_=xxen_upload.status_success and
xu.set_name=efs.set_name(+) and
decode(xu.row_type,&apos;ASSOCIATION&apos;,xu.set_name)=a.set_name(+) and
xu.inventory_item=a.inventory_item(+) and
decode(xu.row_type,&apos;COMBINATION&apos;,xu.set_name)=c.set_name(+) and
xu.failure_code=c.failure_code(+) and
xu.cause_code=c.cause_code(+) and
xu.resolution_code=c.resolution_code(+)</SQL_TEXT>
   </UPLOAD_SQLS_ROW>
  </UPLOAD_SQLS>
 </REPORTS_ROW>
</REPORTS>
</ROOT>
