<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: QP Modifier Copy Upload -->
 <REPORTS_ROW>
  <GUID>3BAFA3075DFE41DEA0131870EDBF9AED</GUID><ENABLED>Y</ENABLED>
  <SQL_TEXT>select
null action_,
null status_,
null message_,
null modified_columns_,
xxen_util.meaning(qslhv.list_type_code,&apos;LIST_TYPE_CODE&apos;,661) list_type,
qslhv.name list_number,
qslhv.version_no list_version,
qslhv.description list_name,
qslhv.currency_code list_currency,
qslhv.start_date_active list_effective_from,
qslhv.end_date_active list_effective_to,
to_char(null) retain_effective_dates,
to_char(null) new_modifier_number,
to_char(null) new_modifier_name,
to_date(null) new_effective_from,
to_date(null) new_effective_to,
xxen_util.yes(decode(hou.organization_id,null,&apos;Y&apos;)) new_global_list,
hou.name new_operating_unit,
null upload_row
from
qp_secu_list_headers_vl qslhv,
(select hou.organization_id, hou.name from hr_operating_units hou where hou.organization_id in (select xroa.id from xxen_report_org_access xroa where xroa.access_type=&apos;OU&apos;)) hou
where
:p_upload_mode like &apos;%&apos;||xxen_upload.action_update and
1=1 and
qslhv.list_type_code in (&apos;DLT&apos;,&apos;DEL&apos;,&apos;CHARGES&apos;,&apos;PRO&apos;,&apos;SLT&apos;) and
nvl(qslhv.pte_code,&apos;ORDFUL&apos;)&lt;&gt;&apos;LOGSTX&apos; and
nvl(qslhv.list_source_code,&apos;X&apos;)&lt;&gt;&apos;BSO&apos; and
qslhv.view_flag=&apos;Y&apos; and
nvl(fnd_profile.value(&apos;QP_PRICING_TRANSACTION_ENTITY&apos;),&apos;QP&apos;)=nvl(qslhv.pte_code,&apos;QP&apos;) and
qslhv.orig_org_id=hou.organization_id(+)</SQL_TEXT>
  <VERSION_COMMENTS>Initial version: copies modifier lists as the Copy Modifier List window, and end-dates the modifier list of the row.</VERSION_COMMENTS>
  <TYPE>U</TYPE>
  <UPLOAD_TYPE>A</UPLOAD_TYPE>
  <UPLOAD_OBJECT>xxen_qp_upload.upload_modifier_copy</UPLOAD_OBJECT>
  <REPORT_TRANSLATIONS>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>US</LANGUAGE>
    <REPORT_NAME>QP Modifier Copy Upload</REPORT_NAME>
    <DESCRIPTION>Copies modifier lists, one row per modifier list, as the Copy Modifier List window of Advanced Pricing (Modifiers &gt; Copy) does.

Upload Mode Create, Update downloads the selected modifier lists; Create gives an empty sheet to paste rows into.

Enter a New Modifier Number and New Modifier Name to copy the row&apos;s modifier list with its qualifiers and the lines active today. The copy keeps the type and version of its source.

A list number can exist in several versions. List Version then selects the modifier list, and a row without it is rejected.

Change List Effective To to end-date the row&apos;s modifier list, for example the day before the new list starts. Only a modifier list without an end date can be end-dated: an existing end date cannot be changed or removed, and a blank List Effective To leaves the modifier list unchanged.

The copy is saved as soon as it runs. A row that fails afterwards keeps the new modifier list and its message says so: end-date the source in a separate row instead of uploading the row again.</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>:p_upload_mode</ANCHOR>
    <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>1=1</ANCHOR>
    <SQL_TEXT>qslhv.list_type_code=:list_type</SQL_TEXT>
    <PARAMETER_TYPE_DSP>LOV custom</PARAMETER_TYPE_DSP>
    <LOV_QUERY_DSP>select
flvv.lookup_code id,
flvv.meaning value,
null description
from
fnd_lookup_values_vl flvv
where
flvv.lookup_type=&apos;LIST_TYPE_CODE&apos; and
flvv.view_application_id=661 and
flvv.security_group_id=0 and
flvv.enabled_flag=&apos;Y&apos; and
flvv.lookup_code in (&apos;DLT&apos;,&apos;DEL&apos;,&apos;CHARGES&apos;,&apos;PRO&apos;,&apos;SLT&apos;)
order by
2</LOV_QUERY_DSP>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>List Type</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>qslhv.name=:list_number</SQL_TEXT>
    <PARAMETER_TYPE_DSP>LOV custom</PARAMETER_TYPE_DSP>
    <LOV_QUERY_DSP>select
qslhv.name value,
qslhv.description||nvl2(qslhv.version_no,&apos; Vn: &apos;||qslhv.version_no,null) description
from
qp_secu_list_headers_vl qslhv
where
qslhv.list_type_code in (&apos;DLT&apos;,&apos;DEL&apos;,&apos;CHARGES&apos;,&apos;PRO&apos;,&apos;SLT&apos;) and
nvl(qslhv.pte_code,&apos;ORDFUL&apos;)&lt;&gt;&apos;LOGSTX&apos; and
nvl(qslhv.list_source_code,&apos;X&apos;)&lt;&gt;&apos;BSO&apos; and
qslhv.view_flag=&apos;Y&apos; and
nvl(fnd_profile.value(&apos;QP_PRICING_TRANSACTION_ENTITY&apos;),&apos;QP&apos;)=nvl(qslhv.pte_code,&apos;QP&apos;) and
(:$flex$.list_type is null or xxen_util.contains(:$flex$.list_type,qslhv.list_type_code)=&apos;Y&apos;)
order by
1</LOV_QUERY_DSP>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>List Number</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>4</SORT_ORDER>
    <DISPLAY_SEQUENCE>40</DISPLAY_SEQUENCE>
    <ANCHOR>1=1</ANCHOR>
    <SQL_TEXT>qslhv.name like :list_number_like</SQL_TEXT>
    <PARAMETER_TYPE_DSP>Char</PARAMETER_TYPE_DSP>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>List Number Like</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>5</SORT_ORDER>
    <DISPLAY_SEQUENCE>50</DISPLAY_SEQUENCE>
    <ANCHOR>1=1</ANCHOR>
    <SQL_TEXT>qslhv.name&gt;=:list_number_from</SQL_TEXT>
    <PARAMETER_TYPE_DSP>LOV custom</PARAMETER_TYPE_DSP>
    <FREE_TEXT>Y</FREE_TEXT>
    <LOV_QUERY_DSP>select
qslhv.name value,
qslhv.description||nvl2(qslhv.version_no,&apos; Vn: &apos;||qslhv.version_no,null) description
from
qp_secu_list_headers_vl qslhv
where
qslhv.list_type_code in (&apos;DLT&apos;,&apos;DEL&apos;,&apos;CHARGES&apos;,&apos;PRO&apos;,&apos;SLT&apos;) and
nvl(qslhv.pte_code,&apos;ORDFUL&apos;)&lt;&gt;&apos;LOGSTX&apos; and
nvl(qslhv.list_source_code,&apos;X&apos;)&lt;&gt;&apos;BSO&apos; and
qslhv.view_flag=&apos;Y&apos; and
nvl(fnd_profile.value(&apos;QP_PRICING_TRANSACTION_ENTITY&apos;),&apos;QP&apos;)=nvl(qslhv.pte_code,&apos;QP&apos;) and
(:$flex$.list_type is null or xxen_util.contains(:$flex$.list_type,qslhv.list_type_code)=&apos;Y&apos;)
order by
1</LOV_QUERY_DSP>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>List Number From</PARAMETER_NAME>
      <DESCRIPTION>Downloads the modifier lists whose numbers are from List Number From to List Number To, compared as text.</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>6</SORT_ORDER>
    <DISPLAY_SEQUENCE>60</DISPLAY_SEQUENCE>
    <ANCHOR>1=1</ANCHOR>
    <SQL_TEXT>qslhv.name&lt;=:list_number_to</SQL_TEXT>
    <PARAMETER_TYPE_DSP>LOV custom</PARAMETER_TYPE_DSP>
    <FREE_TEXT>Y</FREE_TEXT>
    <LOV_QUERY_DSP>select
qslhv.name value,
qslhv.description||nvl2(qslhv.version_no,&apos; Vn: &apos;||qslhv.version_no,null) description
from
qp_secu_list_headers_vl qslhv
where
qslhv.list_type_code in (&apos;DLT&apos;,&apos;DEL&apos;,&apos;CHARGES&apos;,&apos;PRO&apos;,&apos;SLT&apos;) and
nvl(qslhv.pte_code,&apos;ORDFUL&apos;)&lt;&gt;&apos;LOGSTX&apos; and
nvl(qslhv.list_source_code,&apos;X&apos;)&lt;&gt;&apos;BSO&apos; and
qslhv.view_flag=&apos;Y&apos; and
nvl(fnd_profile.value(&apos;QP_PRICING_TRANSACTION_ENTITY&apos;),&apos;QP&apos;)=nvl(qslhv.pte_code,&apos;QP&apos;) and
(:$flex$.list_type is null or xxen_util.contains(:$flex$.list_type,qslhv.list_type_code)=&apos;Y&apos;)
order by
1</LOV_QUERY_DSP>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>List Number To</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>7</SORT_ORDER>
    <DISPLAY_SEQUENCE>70</DISPLAY_SEQUENCE>
    <ANCHOR>1=1</ANCHOR>
    <SQL_TEXT>nvl(qslhv.start_date_active,:effective_date)&lt;=:effective_date and nvl(qslhv.end_date_active,:effective_date)&gt;=:effective_date</SQL_TEXT>
    <PARAMETER_TYPE_DSP>Date</PARAMETER_TYPE_DSP>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Effective Date</PARAMETER_NAME>
      <DESCRIPTION>Downloads the modifier lists effective on this date.</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
  </PARAMETERS>
  <TEMPLATES>
   <TEMPLATES_ROW>
    <GUID>5C9B5A599F4041A1947D847CB0274B95</GUID>
    <TEMPLATE_NAME>Default</TEMPLATE_NAME>
    <DESCRIPTION>Copy modifier lists and optionally end-date the source modifier lists.</DESCRIPTION>
    <OWNER>ENGINATICS</OWNER>
    <TEMPLATE_COLUMNS>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>5</DISPLAY_SEQUENCE>
      <COLUMN_NAME>LIST_CURRENCY</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>6</DISPLAY_SEQUENCE>
      <COLUMN_NAME>LIST_EFFECTIVE_FROM</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>7</DISPLAY_SEQUENCE>
      <COLUMN_NAME>LIST_EFFECTIVE_TO</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>4</DISPLAY_SEQUENCE>
      <COLUMN_NAME>LIST_NAME</COLUMN_NAME>
      <FREEZE_PANES>Y</FREEZE_PANES>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>2</DISPLAY_SEQUENCE>
      <COLUMN_NAME>LIST_NUMBER</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>1</DISPLAY_SEQUENCE>
      <COLUMN_NAME>LIST_TYPE</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>3</DISPLAY_SEQUENCE>
      <COLUMN_NAME>LIST_VERSION</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>11</DISPLAY_SEQUENCE>
      <COLUMN_NAME>NEW_EFFECTIVE_FROM</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>12</DISPLAY_SEQUENCE>
      <COLUMN_NAME>NEW_EFFECTIVE_TO</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>13</DISPLAY_SEQUENCE>
      <COLUMN_NAME>NEW_GLOBAL_LIST</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>10</DISPLAY_SEQUENCE>
      <COLUMN_NAME>NEW_MODIFIER_NAME</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>9</DISPLAY_SEQUENCE>
      <COLUMN_NAME>NEW_MODIFIER_NUMBER</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>14</DISPLAY_SEQUENCE>
      <COLUMN_NAME>NEW_OPERATING_UNIT</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>8</DISPLAY_SEQUENCE>
      <COLUMN_NAME>RETAIN_EFFECTIVE_DATES</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_ROW>
    <GUID>FF69EA00769A4C0592F05A358F2E5FC4</GUID>
    <TEMPLATE_NAME>End Date Only</TEMPLATE_NAME>
    <DESCRIPTION>End-date the downloaded modifier lists.</DESCRIPTION>
    <OWNER>ENGINATICS</OWNER>
    <TEMPLATE_COLUMNS>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>5</DISPLAY_SEQUENCE>
      <COLUMN_NAME>LIST_CURRENCY</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>6</DISPLAY_SEQUENCE>
      <COLUMN_NAME>LIST_EFFECTIVE_FROM</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>7</DISPLAY_SEQUENCE>
      <COLUMN_NAME>LIST_EFFECTIVE_TO</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>4</DISPLAY_SEQUENCE>
      <COLUMN_NAME>LIST_NAME</COLUMN_NAME>
      <FREEZE_PANES>Y</FREEZE_PANES>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>2</DISPLAY_SEQUENCE>
      <COLUMN_NAME>LIST_NUMBER</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>1</DISPLAY_SEQUENCE>
      <COLUMN_NAME>LIST_TYPE</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>3</DISPLAY_SEQUENCE>
      <COLUMN_NAME>LIST_VERSION</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
    </TEMPLATE_COLUMNS>
    <TEMPLATE_PIVOT>
    </TEMPLATE_PIVOT>
    <TEMPLATE_SHARED_STRINGS>
    </TEMPLATE_SHARED_STRINGS>
    <TEMPLATE_PARAMETER_DEFAULTS>
     <TEMPLATE_PARAMETER_DEFAULTS_ROW>
      <PARAMETER_NAME>Upload Mode</PARAMETER_NAME>
      <DEFAULT_VALUE>C,U</DEFAULT_VALUE>
     </TEMPLATE_PARAMETER_DEFAULTS_ROW>
    </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>5C9B5A599F4041A1947D847CB0274B95</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>LIST_TYPE</COLUMN_NAME>
    <COLUMN_TYPE_DSP>Char</COLUMN_TYPE_DSP>
    <DATA_TYPE>varchar2</DATA_TYPE>
    <DEFAULT_VALUE>select xxen_util.meaning(qlhv.list_type_code,&apos;LIST_TYPE_CODE&apos;,661) from qp_list_headers_vl qlhv where qlhv.name=:$column$.list_number and qlhv.list_type_code in (&apos;DLT&apos;,&apos;DEL&apos;,&apos;CHARGES&apos;,&apos;PRO&apos;,&apos;SLT&apos;) and (:$column$.list_version is null or qlhv.version_no=:$column$.list_version)</DEFAULT_VALUE>
    <READ_ONLY>Y</READ_ONLY>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>6</COLUMN_NUMBER>
    <COLUMN_NAME>LIST_NUMBER</COLUMN_NAME>
    <COLUMN_TYPE_DSP>LOV custom</COLUMN_TYPE_DSP>
    <DATA_TYPE>varchar2</DATA_TYPE>
    <LOV_QUERY_DSP>select
qslhv.name value,
min(qslhv.description) description
from
qp_secu_list_headers_vl qslhv
where
qslhv.list_type_code in (&apos;DLT&apos;,&apos;DEL&apos;,&apos;CHARGES&apos;,&apos;PRO&apos;,&apos;SLT&apos;) and
nvl(qslhv.pte_code,&apos;ORDFUL&apos;)&lt;&gt;&apos;LOGSTX&apos; and
nvl(qslhv.list_source_code,&apos;X&apos;)&lt;&gt;&apos;BSO&apos; and
qslhv.view_flag=&apos;Y&apos; and
nvl(fnd_profile.value(&apos;QP_PRICING_TRANSACTION_ENTITY&apos;),&apos;QP&apos;)=nvl(qslhv.pte_code,&apos;QP&apos;)
group by
qslhv.name
order by
1</LOV_QUERY_DSP>
    <REQUIRED>Y</REQUIRED>
    <READ_ONLY>Y</READ_ONLY>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>7</COLUMN_NUMBER>
    <COLUMN_NAME>LIST_VERSION</COLUMN_NAME>
    <COLUMN_TYPE_DSP>LOV custom</COLUMN_TYPE_DSP>
    <DATA_TYPE>varchar2</DATA_TYPE>
    <LOV_QUERY_DSP>select
qslhv.version_no value,
qslhv.description
from
qp_secu_list_headers_vl qslhv
where
qslhv.name=:$column$.list_number and
qslhv.version_no is not null and
qslhv.list_type_code in (&apos;DLT&apos;,&apos;DEL&apos;,&apos;CHARGES&apos;,&apos;PRO&apos;,&apos;SLT&apos;) and
nvl(qslhv.pte_code,&apos;ORDFUL&apos;)&lt;&gt;&apos;LOGSTX&apos; and
nvl(qslhv.list_source_code,&apos;X&apos;)&lt;&gt;&apos;BSO&apos; and
qslhv.view_flag=&apos;Y&apos; and
nvl(fnd_profile.value(&apos;QP_PRICING_TRANSACTION_ENTITY&apos;),&apos;QP&apos;)=nvl(qslhv.pte_code,&apos;QP&apos;)
order by
1</LOV_QUERY_DSP>
    <DEFAULT_VALUE>select qlhv.version_no from qp_list_headers_vl qlhv where qlhv.name=:$column$.list_number and qlhv.list_type_code in (&apos;DLT&apos;,&apos;DEL&apos;,&apos;CHARGES&apos;,&apos;PRO&apos;,&apos;SLT&apos;)</DEFAULT_VALUE>
    <COMMENTS>Version of the modifier list. Required when the list number exists in several versions.</COMMENTS>
    <READ_ONLY>Y</READ_ONLY>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>8</COLUMN_NUMBER>
    <COLUMN_NAME>LIST_NAME</COLUMN_NAME>
    <COLUMN_TYPE_DSP>Char</COLUMN_TYPE_DSP>
    <DATA_TYPE>varchar2</DATA_TYPE>
    <DEFAULT_VALUE>select qlhv.description from qp_list_headers_vl qlhv where qlhv.name=:$column$.list_number and qlhv.list_type_code in (&apos;DLT&apos;,&apos;DEL&apos;,&apos;CHARGES&apos;,&apos;PRO&apos;,&apos;SLT&apos;) and (:$column$.list_version is null or qlhv.version_no=:$column$.list_version)</DEFAULT_VALUE>
    <READ_ONLY>Y</READ_ONLY>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>9</COLUMN_NUMBER>
    <COLUMN_NAME>LIST_CURRENCY</COLUMN_NAME>
    <COLUMN_TYPE_DSP>Char</COLUMN_TYPE_DSP>
    <DATA_TYPE>varchar2</DATA_TYPE>
    <DEFAULT_VALUE>select qlhv.currency_code from qp_list_headers_vl qlhv where qlhv.name=:$column$.list_number and qlhv.list_type_code in (&apos;DLT&apos;,&apos;DEL&apos;,&apos;CHARGES&apos;,&apos;PRO&apos;,&apos;SLT&apos;) and (:$column$.list_version is null or qlhv.version_no=:$column$.list_version)</DEFAULT_VALUE>
    <READ_ONLY>Y</READ_ONLY>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>10</COLUMN_NUMBER>
    <COLUMN_NAME>LIST_EFFECTIVE_FROM</COLUMN_NAME>
    <COLUMN_TYPE_DSP>Date</COLUMN_TYPE_DSP>
    <DATA_TYPE>date</DATA_TYPE>
    <DEFAULT_VALUE>select qlhv.start_date_active from qp_list_headers_vl qlhv where qlhv.name=:$column$.list_number and qlhv.list_type_code in (&apos;DLT&apos;,&apos;DEL&apos;,&apos;CHARGES&apos;,&apos;PRO&apos;,&apos;SLT&apos;) and (:$column$.list_version is null or qlhv.version_no=:$column$.list_version)</DEFAULT_VALUE>
    <READ_ONLY>Y</READ_ONLY>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>11</COLUMN_NUMBER>
    <COLUMN_NAME>LIST_EFFECTIVE_TO</COLUMN_NAME>
    <COLUMN_TYPE_DSP>Date</COLUMN_TYPE_DSP>
    <DATA_TYPE>date</DATA_TYPE>
    <DEFAULT_VALUE>select qlhv.end_date_active from qp_list_headers_vl qlhv where qlhv.name=:$column$.list_number and qlhv.list_type_code in (&apos;DLT&apos;,&apos;DEL&apos;,&apos;CHARGES&apos;,&apos;PRO&apos;,&apos;SLT&apos;) and (:$column$.list_version is null or qlhv.version_no=:$column$.list_version)</DEFAULT_VALUE>
    <COMMENTS>Change it to end-date the source modifier list, for example the day before the new modifier list starts. Only a modifier list without an end date can be end-dated.</COMMENTS>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>12</COLUMN_NUMBER>
    <COLUMN_NAME>RETAIN_EFFECTIVE_DATES</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>Keeps the effective dates of the copied lines.</COMMENTS>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>13</COLUMN_NUMBER>
    <COLUMN_NAME>NEW_MODIFIER_NUMBER</COLUMN_NAME>
    <COLUMN_TYPE_DSP>Char</COLUMN_TYPE_DSP>
    <DATA_TYPE>varchar2</DATA_TYPE>
    <COMMENTS>Number of the new modifier list. Entering it copies this row&apos;s modifier list with its qualifiers and the lines active today.</COMMENTS>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>14</COLUMN_NUMBER>
    <COLUMN_NAME>NEW_MODIFIER_NAME</COLUMN_NAME>
    <COLUMN_TYPE_DSP>Char</COLUMN_TYPE_DSP>
    <DATA_TYPE>varchar2</DATA_TYPE>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>15</COLUMN_NUMBER>
    <COLUMN_NAME>NEW_EFFECTIVE_FROM</COLUMN_NAME>
    <COLUMN_TYPE_DSP>Date</COLUMN_TYPE_DSP>
    <DATA_TYPE>date</DATA_TYPE>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>16</COLUMN_NUMBER>
    <COLUMN_NAME>NEW_EFFECTIVE_TO</COLUMN_NAME>
    <COLUMN_TYPE_DSP>Date</COLUMN_TYPE_DSP>
    <DATA_TYPE>date</DATA_TYPE>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>17</COLUMN_NUMBER>
    <COLUMN_NAME>NEW_GLOBAL_LIST</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>
    <DEFAULT_VALUE>select
xxen_util.yes(decode(hou.organization_id,null,&apos;Y&apos;))
from
qp_list_headers_vl qlhv,
(select hou.organization_id from hr_operating_units hou where hou.organization_id in (select xroa.id from xxen_report_org_access xroa where xroa.access_type=&apos;OU&apos;)) hou
where
qlhv.name=:$column$.list_number and
qlhv.list_type_code in (&apos;DLT&apos;,&apos;DEL&apos;,&apos;CHARGES&apos;,&apos;PRO&apos;,&apos;SLT&apos;) and
(:$column$.list_version is null or qlhv.version_no=:$column$.list_version) and
qlhv.orig_org_id=hou.organization_id(+)</DEFAULT_VALUE>
    <COMMENTS>Global flag of the new modifier list.</COMMENTS>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>18</COLUMN_NUMBER>
    <COLUMN_NAME>NEW_OPERATING_UNIT</COLUMN_NAME>
    <COLUMN_TYPE_DSP>LOV custom</COLUMN_TYPE_DSP>
    <DATA_TYPE>varchar2</DATA_TYPE>
    <LOV_QUERY_DSP>select
hou.organization_id id,
hou.name value,
null description
from
hr_operating_units hou
where
:$column$.new_global_list is null and
hou.organization_id in (select xroa.id from xxen_report_org_access xroa where xroa.access_type=&apos;OU&apos;)
order by
hou.name</LOV_QUERY_DSP>
    <DEFAULT_VALUE>select
hou.name
from
qp_list_headers_vl qlhv,
hr_operating_units hou
where
:$column$.new_global_list is null and
qlhv.name=:$column$.list_number and
qlhv.list_type_code in (&apos;DLT&apos;,&apos;DEL&apos;,&apos;CHARGES&apos;,&apos;PRO&apos;,&apos;SLT&apos;) and
(:$column$.list_version is null or qlhv.version_no=:$column$.list_version) and
qlhv.orig_org_id=hou.organization_id and
hou.organization_id in (select xroa.id from xxen_report_org_access xroa where xroa.access_type=&apos;OU&apos;)</DEFAULT_VALUE>
    <COMMENTS>Operating unit of the new modifier list, when it is not global.</COMMENTS>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>19</COLUMN_NUMBER>
    <COLUMN_NAME>UPLOAD_ROW</COLUMN_NAME>
    <COLUMN_TYPE_DSP>Char</COLUMN_TYPE_DSP>
    <DATA_TYPE>varchar2</DATA_TYPE>
    <HIDDEN>Y</HIDDEN>
   </UPLOAD_COLUMNS_ROW>
  </UPLOAD_COLUMNS>
  <UPLOAD_PARAMETERS>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>10</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>20</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>30</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_list_number</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Char</PARAMETER_TYPE>
    <COLUMN_NAME>LIST_NUMBER</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>40</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_list_version</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Char</PARAMETER_TYPE>
    <DEFAULTED>Y</DEFAULTED>
    <COLUMN_NAME>LIST_VERSION</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>50</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_list_version_out</PARAMETER_NAME>
    <IN_OUT>out</IN_OUT>
    <PARAMETER_TYPE>Char</PARAMETER_TYPE>
    <COLUMN_NAME>LIST_VERSION</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>60</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_list_effective_to</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Date</PARAMETER_TYPE>
    <DEFAULTED>Y</DEFAULTED>
    <COLUMN_NAME>LIST_EFFECTIVE_TO</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>70</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_retain_effective_dates</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Char</PARAMETER_TYPE>
    <DEFAULTED>Y</DEFAULTED>
    <COLUMN_NAME>RETAIN_EFFECTIVE_DATES</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>80</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_new_modifier_number</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Char</PARAMETER_TYPE>
    <DEFAULTED>Y</DEFAULTED>
    <COLUMN_NAME>NEW_MODIFIER_NUMBER</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>90</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_new_modifier_name</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Char</PARAMETER_TYPE>
    <DEFAULTED>Y</DEFAULTED>
    <COLUMN_NAME>NEW_MODIFIER_NAME</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>100</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_new_effective_from</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Date</PARAMETER_TYPE>
    <DEFAULTED>Y</DEFAULTED>
    <COLUMN_NAME>NEW_EFFECTIVE_FROM</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>110</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_new_effective_to</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Date</PARAMETER_TYPE>
    <DEFAULTED>Y</DEFAULTED>
    <COLUMN_NAME>NEW_EFFECTIVE_TO</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>120</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_new_global_list</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Char</PARAMETER_TYPE>
    <DEFAULTED>Y</DEFAULTED>
    <COLUMN_NAME>NEW_GLOBAL_LIST</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>130</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_new_org_id</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Number</PARAMETER_TYPE>
    <DEFAULTED>Y</DEFAULTED>
    <COLUMN_NAME>NEW_OPERATING_UNIT</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, list_number, list_version</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(xxen_util.meaning(qlhv.list_type_code,&apos;LIST_TYPE_CODE&apos;,661),xu.list_type) list_type,
xu.list_number,
xu.list_version,
nvl(qlhv.description,xu.list_name) list_name,
nvl(qlhv.currency_code,xu.list_currency) list_currency,
nvl(qlhv.start_date_active,xu.list_effective_from) list_effective_from,
nvl(qlhv.end_date_active,xu.list_effective_to) list_effective_to,
xu.retain_effective_dates,
xu.new_modifier_number,
nvl(qlhv_new.description,xu.new_modifier_name) new_modifier_name,
nvl(qlhv_new.start_date_active,xu.new_effective_from) new_effective_from,
nvl(qlhv_new.end_date_active,xu.new_effective_to) new_effective_to,
nvl2(qlhv_new.list_header_id,xxen_util.yes(qlhv_new.global_flag),xu.new_global_list) new_global_list,
nvl2(qlhv_new.list_header_id,(select hou.name from hr_operating_units hou where qlhv_new.orig_org_id=hou.organization_id),xu.new_operating_unit) new_operating_unit,
xu.upload_row
from
xxen_qp_modifier_copy_u_6802_u xu,
(select qlhv.name, qlhv.version_no, qlhv.list_type_code, qlhv.description, qlhv.currency_code, qlhv.start_date_active, qlhv.end_date_active from qp_list_headers_vl qlhv where qlhv.list_type_code in (&apos;DLT&apos;,&apos;DEL&apos;,&apos;CHARGES&apos;,&apos;PRO&apos;,&apos;SLT&apos;)) qlhv,
qp_list_headers_vl qlhv_new
where
xu.status_code_=xxen_upload.status_success and
xu.list_number=qlhv.name(+) and
nvl(xu.list_version,&apos; &apos;)=nvl(qlhv.version_no(+),&apos; &apos;) and
xu.new_modifier_number=qlhv_new.name(+) and
nvl(xu.list_version,&apos; &apos;)=nvl(qlhv_new.version_no(+),&apos; &apos;)</SQL_TEXT>
   </UPLOAD_SQLS_ROW>
  </UPLOAD_SQLS>
 </REPORTS_ROW>
</REPORTS>
</ROOT>
