<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: PO Receiving Transaction Upload -->
 <REPORTS_ROW>
  <GUID>F1A2B3C4D5E6F7081920A1B2C3D4E5F6</GUID><ENABLED>Y</ENABLED>
  <SQL_TEXT>select
null action_,
null status_,
null message_,
null modified_columns_,
to_number(null) request_id_,
to_char(null) row_id,
mp.organization_code,
(select hou.name from hr_operating_units hou where pha.org_id=hou.organization_id) operating_unit,
aps.vendor_name supplier,
assa.vendor_site_code supplier_site,
pha.segment1 po_number,
pra.release_num,
pla.line_num,
plla.shipment_num,
(select msibk.concatenated_segments from mtl_system_items_b_kfv msibk where pla.item_id=msibk.inventory_item_id and plla.ship_to_organization_id=msibk.organization_id) item,
pla.item_revision,
pla.item_description,
plla.quantity quantity_ordered,
nvl(plla.quantity_received,0) quantity_received,
plla.quantity-nvl(plla.quantity_received,0) quantity_remaining,
pla.unit_meas_lookup_code unit_of_measure,
to_number(null) quantity,
to_date(null) transaction_date,
(select xxen_util.meaning(pda.destination_type_code,&apos;DESTINATION TYPE&apos;,201) from po_distributions_all pda where plla.line_location_id=pda.line_location_id and rownum=1) destination_type,
(select pda.destination_subinventory from po_distributions_all pda where plla.line_location_id=pda.line_location_id and rownum=1) subinventory,
to_char(null) locator,
cast(null as varchar2(80)) lot_number,
to_date(null) lot_expiration_date,
cast(null as varchar2(30)) from_serial_number,
cast(null as varchar2(30)) to_serial_number,
(select hla.location_code from hr_locations_all hla where hla.location_id=(select pda.deliver_to_location_id from po_distributions_all pda where plla.line_location_id=pda.line_location_id and rownum=1)) deliver_to_location,
(select ft.territory_short_name from fnd_territories_vl ft where plla.country_of_origin_code=ft.territory_code) country_of_origin,
cast(null as varchar2(30)) vendor_lot_num,
cast(null as varchar2(240)) comments,
cast(null as varchar2(80)) receipt_attribute_category,
cast(null as varchar2(150)) receipt_attribute1,
cast(null as varchar2(150)) receipt_attribute2,
cast(null as varchar2(150)) receipt_attribute3,
cast(null as varchar2(150)) receipt_attribute4,
cast(null as varchar2(150)) receipt_attribute5,
cast(null as varchar2(150)) receipt_attribute6,
cast(null as varchar2(150)) receipt_attribute7,
cast(null as varchar2(150)) receipt_attribute8,
cast(null as varchar2(150)) receipt_attribute9,
cast(null as varchar2(150)) receipt_attribute10,
cast(null as varchar2(150)) receipt_attribute11,
cast(null as varchar2(150)) receipt_attribute12,
cast(null as varchar2(150)) receipt_attribute13,
cast(null as varchar2(150)) receipt_attribute14,
cast(null as varchar2(150)) receipt_attribute15,
cast(null as varchar2(80)) line_attribute_category,
cast(null as varchar2(150)) line_attribute1,
cast(null as varchar2(150)) line_attribute2,
cast(null as varchar2(150)) line_attribute3,
cast(null as varchar2(150)) line_attribute4,
cast(null as varchar2(150)) line_attribute5,
cast(null as varchar2(150)) line_attribute6,
cast(null as varchar2(150)) line_attribute7,
cast(null as varchar2(150)) line_attribute8,
cast(null as varchar2(150)) line_attribute9,
cast(null as varchar2(150)) line_attribute10,
cast(null as varchar2(150)) line_attribute11,
cast(null as varchar2(150)) line_attribute12,
cast(null as varchar2(150)) line_attribute13,
cast(null as varchar2(150)) line_attribute14,
cast(null as varchar2(150)) line_attribute15,
to_number(null) upload_row
from
po_headers_all pha,
ap_suppliers aps,
ap_supplier_sites_all assa,
po_lines_all pla,
po_line_locations_all plla,
po_releases_all pra,
mtl_parameters mp
where
pha.vendor_id=aps.vendor_id and
pha.vendor_site_id=assa.vendor_site_id(+) and
pha.po_header_id=pla.po_header_id and
pla.po_line_id=plla.po_line_id and
plla.po_release_id=pra.po_release_id(+) and
plla.ship_to_organization_id=mp.organization_id and
plla.shipment_type in (&apos;STANDARD&apos;,&apos;BLANKET&apos;,&apos;SCHEDULED&apos;) and
plla.approved_flag=&apos;Y&apos; and
nvl(plla.cancel_flag,&apos;N&apos;)=&apos;N&apos; and
nvl(plla.closed_code,&apos;OPEN&apos;) not in (&apos;FINALLY CLOSED&apos;,&apos;CLOSED&apos;,&apos;CLOSED FOR RECEIVING&apos;) and
plla.quantity-nvl(plla.quantity_received,0)&gt;0 and
1=1</SQL_TEXT>
  <VERSION_COMMENTS>Added the descriptive flexfield columns of the receipt header and the receipt line.</VERSION_COMMENTS>
  <TYPE>U</TYPE>
  <UPLOAD_TYPE>A</UPLOAD_TYPE>
  <UPLOAD_OBJECT>xxen_po_upload.upload_receipt</UPLOAD_OBJECT>
  <UPLOAD_POST_PROCEDURE>xxen_po_upload.do_rcv_import</UPLOAD_POST_PROCEDURE>
  <REPORT_TRANSLATIONS>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>US</LANGUAGE>
    <REPORT_NAME>PO Receiving Transaction Upload</REPORT_NAME>
    <DESCRIPTION>PO Receiving Transaction Upload
================================
Create receiving transactions (receipts) against approved standard purchase orders and blanket and scheduled releases.

Upload Modes
============

Create
------
Opens an empty spreadsheet where the user can manually enter PO receiving details.

Create, Update
--------------
Downloads open PO shipment lines with quantities available to receive for the selected organization.
The user fills in the Quantity and Transaction Date columns for each line to receive, then uploads.

Prerequisites
=============
- PO must be approved and not cancelled or closed.
- PO shipment must have remaining quantity to receive.
- Transaction date must be in an open inventory receiving period.

Fields
======
- Organization Code: Required. The receiving inventory organization.
- Operating Unit: Required. The operating unit of the purchase order, one the responsibility can access. Defaults to the operating unit of the receiving organization.
- PO Number: Required. The purchase order number.
- Release Num: Optional. The release number of a blanket or scheduled release. Leave it empty for a standard purchase order.
- Line Num: Required. The PO line number.
- Shipment Num: Required. The PO shipment number.
- Item Revision: Optional. Item revision (defaults from PO line, override for revision-controlled items).
- Quantity: Required. The quantity to receive (must be greater than zero).
- Transaction Date: Required. The date of the receipt.
- Destination Type: Optional. Inventory, Expense, or Shop Floor (defaults from PO distribution).
- Subinventory: Optional. Destination subinventory (defaults from PO distribution).
- Locator: Optional. Stock locator within the subinventory (required for locator-controlled subinventories).
- Lot Number: Required for a lot controlled item delivered to inventory. To receive several lots of one PO shipment, enter one row per lot with its quantity.
- Lot Expiration Date: Optional. Expiration date of a new lot. For an item with a shelf life in days it defaults to the transaction date plus the shelf life.
- From Serial Number, To Serial Number: Required for an item with predefined or at receipt serial control delivered to inventory. The range must contain as many serial numbers as the quantity in the primary unit of measure; To Serial Number may be left empty for a single serial number.
- Deliver To Location: Optional. Override the deliver-to location.
- Country of Origin: Optional. Country of origin for trade compliance.
- Vendor Lot Num: Optional. Supplier lot number for lot tracking.
- Comments: Optional. Receipt comments.
- Receipt Attribute Category, Receipt Attribute1-15: Optional. Descriptive flexfield of the receipt header, taken from the first row of each receipt.
- Line Attribute Category, Line Attribute1-15: Optional. Descriptive flexfield of the receipt line.</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
  </REPORT_TRANSLATIONS>
  <CATEGORY_ASSIGNMENTS>
   <CATEGORY_ASSIGNMENTS_ROW>
    <CATEGORY>Enginatics</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>
  <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>1=1</ANCHOR>
    <SQL_TEXT>mp.organization_code=:p_organization</SQL_TEXT>
    <PARAMETER_TYPE_DSP>LOV</PARAMETER_TYPE_DSP>
    <LOV_NAME>INV Organization Code (accessible)</LOV_NAME>
    <LOV_GUID>FA6954EC34B240D9A30C047DDF5BD14D</LOV_GUID>
    <LOV_QUERY_DSP>select
mp.organization_id id,
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
order by
mp.organization_code</LOV_QUERY_DSP>
    <ID_OR_VALUE>value</ID_OR_VALUE>
    <REQUIRED>Y</REQUIRED>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>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>pha.segment1=:p_po_number</SQL_TEXT>
    <PARAMETER_TYPE_DSP>LOV custom</PARAMETER_TYPE_DSP>
    <LOV_QUERY_DSP>select distinct
pha.segment1 value,
(select aps.vendor_name from ap_suppliers aps where pha.vendor_id=aps.vendor_id) description
from
po_headers_all pha,
po_line_locations_all plla
where
pha.po_header_id=plla.po_header_id and
plla.ship_to_organization_id in (select mp.organization_id from mtl_parameters mp where xxen_util.contains(:$flex$.Organization,mp.organization_id)=&apos;Y&apos;) and
plla.shipment_type in (&apos;STANDARD&apos;,&apos;BLANKET&apos;,&apos;SCHEDULED&apos;) and
plla.approved_flag=&apos;Y&apos; and
nvl(plla.cancel_flag,&apos;N&apos;)=&apos;N&apos; and
nvl(plla.closed_code,&apos;OPEN&apos;) not in (&apos;FINALLY CLOSED&apos;,&apos;CLOSED&apos;,&apos;CLOSED FOR RECEIVING&apos;) and
plla.quantity-nvl(plla.quantity_received,0)&gt;0
order by 1</LOV_QUERY_DSP>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>PO Number</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
  </PARAMETERS>
  <TEMPLATES>
   <TEMPLATES_ROW>
    <GUID>41CE55665C2D4B41BB2AC006E9311885</GUID>
    <TEMPLATE_NAME>Default</TEMPLATE_NAME>
    <DESCRIPTION>All columns.</DESCRIPTION>
    <OWNER>ENGINATICS</OWNER>
    <TEMPLATE_COLUMNS>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>28</DISPLAY_SEQUENCE>
      <COLUMN_NAME>COMMENTS</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>26</DISPLAY_SEQUENCE>
      <COLUMN_NAME>COUNTRY_OF_ORIGIN</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>25</DISPLAY_SEQUENCE>
      <COLUMN_NAME>DELIVER_TO_LOCATION</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>18</DISPLAY_SEQUENCE>
      <COLUMN_NAME>DESTINATION_TYPE</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>23</DISPLAY_SEQUENCE>
      <COLUMN_NAME>FROM_SERIAL_NUMBER</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>9</DISPLAY_SEQUENCE>
      <COLUMN_NAME>ITEM</COLUMN_NAME>
      <FREEZE_PANES>Y</FREEZE_PANES>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>11</DISPLAY_SEQUENCE>
      <COLUMN_NAME>ITEM_DESCRIPTION</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>10</DISPLAY_SEQUENCE>
      <COLUMN_NAME>ITEM_REVISION</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>7</DISPLAY_SEQUENCE>
      <COLUMN_NAME>LINE_NUM</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>20</DISPLAY_SEQUENCE>
      <COLUMN_NAME>LOCATOR</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>22</DISPLAY_SEQUENCE>
      <COLUMN_NAME>LOT_EXPIRATION_DATE</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>21</DISPLAY_SEQUENCE>
      <COLUMN_NAME>LOT_NUMBER</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>2</DISPLAY_SEQUENCE>
      <COLUMN_NAME>OPERATING_UNIT</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>1</DISPLAY_SEQUENCE>
      <COLUMN_NAME>ORGANIZATION_CODE</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>5</DISPLAY_SEQUENCE>
      <COLUMN_NAME>PO_NUMBER</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>16</DISPLAY_SEQUENCE>
      <COLUMN_NAME>QUANTITY</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>12</DISPLAY_SEQUENCE>
      <COLUMN_NAME>QUANTITY_ORDERED</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>13</DISPLAY_SEQUENCE>
      <COLUMN_NAME>QUANTITY_RECEIVED</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>14</DISPLAY_SEQUENCE>
      <COLUMN_NAME>QUANTITY_REMAINING</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>6</DISPLAY_SEQUENCE>
      <COLUMN_NAME>RELEASE_NUM</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>8</DISPLAY_SEQUENCE>
      <COLUMN_NAME>SHIPMENT_NUM</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>19</DISPLAY_SEQUENCE>
      <COLUMN_NAME>SUBINVENTORY</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>3</DISPLAY_SEQUENCE>
      <COLUMN_NAME>SUPPLIER</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>4</DISPLAY_SEQUENCE>
      <COLUMN_NAME>SUPPLIER_SITE</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>24</DISPLAY_SEQUENCE>
      <COLUMN_NAME>TO_SERIAL_NUMBER</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>17</DISPLAY_SEQUENCE>
      <COLUMN_NAME>TRANSACTION_DATE</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>15</DISPLAY_SEQUENCE>
      <COLUMN_NAME>UNIT_OF_MEASURE</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>27</DISPLAY_SEQUENCE>
      <COLUMN_NAME>VENDOR_LOT_NUM</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>6C1D3F2A8B4E4E0F9A7C2D5B8E1F3A60</GUID>
    <TEMPLATE_NAME>Descriptive Flexfield</TEMPLATE_NAME>
    <DESCRIPTION>All columns with the descriptive flexfields of the receipt header and line.</DESCRIPTION>
    <OWNER>ENGINATICS</OWNER>
    <TEMPLATE_COLUMNS>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>28</DISPLAY_SEQUENCE>
      <COLUMN_NAME>COMMENTS</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>26</DISPLAY_SEQUENCE>
      <COLUMN_NAME>COUNTRY_OF_ORIGIN</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>25</DISPLAY_SEQUENCE>
      <COLUMN_NAME>DELIVER_TO_LOCATION</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>18</DISPLAY_SEQUENCE>
      <COLUMN_NAME>DESTINATION_TYPE</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>23</DISPLAY_SEQUENCE>
      <COLUMN_NAME>FROM_SERIAL_NUMBER</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>9</DISPLAY_SEQUENCE>
      <COLUMN_NAME>ITEM</COLUMN_NAME>
      <FREEZE_PANES>Y</FREEZE_PANES>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>11</DISPLAY_SEQUENCE>
      <COLUMN_NAME>ITEM_DESCRIPTION</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>10</DISPLAY_SEQUENCE>
      <COLUMN_NAME>ITEM_REVISION</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>46</DISPLAY_SEQUENCE>
      <COLUMN_NAME>LINE_ATTRIBUTE1</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>55</DISPLAY_SEQUENCE>
      <COLUMN_NAME>LINE_ATTRIBUTE10</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>56</DISPLAY_SEQUENCE>
      <COLUMN_NAME>LINE_ATTRIBUTE11</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>57</DISPLAY_SEQUENCE>
      <COLUMN_NAME>LINE_ATTRIBUTE12</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>58</DISPLAY_SEQUENCE>
      <COLUMN_NAME>LINE_ATTRIBUTE13</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>59</DISPLAY_SEQUENCE>
      <COLUMN_NAME>LINE_ATTRIBUTE14</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>60</DISPLAY_SEQUENCE>
      <COLUMN_NAME>LINE_ATTRIBUTE15</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>47</DISPLAY_SEQUENCE>
      <COLUMN_NAME>LINE_ATTRIBUTE2</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>48</DISPLAY_SEQUENCE>
      <COLUMN_NAME>LINE_ATTRIBUTE3</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>49</DISPLAY_SEQUENCE>
      <COLUMN_NAME>LINE_ATTRIBUTE4</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>50</DISPLAY_SEQUENCE>
      <COLUMN_NAME>LINE_ATTRIBUTE5</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>51</DISPLAY_SEQUENCE>
      <COLUMN_NAME>LINE_ATTRIBUTE6</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>52</DISPLAY_SEQUENCE>
      <COLUMN_NAME>LINE_ATTRIBUTE7</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>53</DISPLAY_SEQUENCE>
      <COLUMN_NAME>LINE_ATTRIBUTE8</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>54</DISPLAY_SEQUENCE>
      <COLUMN_NAME>LINE_ATTRIBUTE9</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>45</DISPLAY_SEQUENCE>
      <COLUMN_NAME>LINE_ATTRIBUTE_CATEGORY</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>7</DISPLAY_SEQUENCE>
      <COLUMN_NAME>LINE_NUM</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>20</DISPLAY_SEQUENCE>
      <COLUMN_NAME>LOCATOR</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>22</DISPLAY_SEQUENCE>
      <COLUMN_NAME>LOT_EXPIRATION_DATE</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>21</DISPLAY_SEQUENCE>
      <COLUMN_NAME>LOT_NUMBER</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>2</DISPLAY_SEQUENCE>
      <COLUMN_NAME>OPERATING_UNIT</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>1</DISPLAY_SEQUENCE>
      <COLUMN_NAME>ORGANIZATION_CODE</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>5</DISPLAY_SEQUENCE>
      <COLUMN_NAME>PO_NUMBER</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>16</DISPLAY_SEQUENCE>
      <COLUMN_NAME>QUANTITY</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>12</DISPLAY_SEQUENCE>
      <COLUMN_NAME>QUANTITY_ORDERED</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>13</DISPLAY_SEQUENCE>
      <COLUMN_NAME>QUANTITY_RECEIVED</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>14</DISPLAY_SEQUENCE>
      <COLUMN_NAME>QUANTITY_REMAINING</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>30</DISPLAY_SEQUENCE>
      <COLUMN_NAME>RECEIPT_ATTRIBUTE1</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>39</DISPLAY_SEQUENCE>
      <COLUMN_NAME>RECEIPT_ATTRIBUTE10</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>40</DISPLAY_SEQUENCE>
      <COLUMN_NAME>RECEIPT_ATTRIBUTE11</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>41</DISPLAY_SEQUENCE>
      <COLUMN_NAME>RECEIPT_ATTRIBUTE12</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>42</DISPLAY_SEQUENCE>
      <COLUMN_NAME>RECEIPT_ATTRIBUTE13</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>43</DISPLAY_SEQUENCE>
      <COLUMN_NAME>RECEIPT_ATTRIBUTE14</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>44</DISPLAY_SEQUENCE>
      <COLUMN_NAME>RECEIPT_ATTRIBUTE15</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>31</DISPLAY_SEQUENCE>
      <COLUMN_NAME>RECEIPT_ATTRIBUTE2</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>32</DISPLAY_SEQUENCE>
      <COLUMN_NAME>RECEIPT_ATTRIBUTE3</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>33</DISPLAY_SEQUENCE>
      <COLUMN_NAME>RECEIPT_ATTRIBUTE4</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>34</DISPLAY_SEQUENCE>
      <COLUMN_NAME>RECEIPT_ATTRIBUTE5</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>35</DISPLAY_SEQUENCE>
      <COLUMN_NAME>RECEIPT_ATTRIBUTE6</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>36</DISPLAY_SEQUENCE>
      <COLUMN_NAME>RECEIPT_ATTRIBUTE7</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>37</DISPLAY_SEQUENCE>
      <COLUMN_NAME>RECEIPT_ATTRIBUTE8</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>38</DISPLAY_SEQUENCE>
      <COLUMN_NAME>RECEIPT_ATTRIBUTE9</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>29</DISPLAY_SEQUENCE>
      <COLUMN_NAME>RECEIPT_ATTRIBUTE_CATEGORY</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>6</DISPLAY_SEQUENCE>
      <COLUMN_NAME>RELEASE_NUM</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>8</DISPLAY_SEQUENCE>
      <COLUMN_NAME>SHIPMENT_NUM</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>19</DISPLAY_SEQUENCE>
      <COLUMN_NAME>SUBINVENTORY</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>3</DISPLAY_SEQUENCE>
      <COLUMN_NAME>SUPPLIER</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>4</DISPLAY_SEQUENCE>
      <COLUMN_NAME>SUPPLIER_SITE</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>24</DISPLAY_SEQUENCE>
      <COLUMN_NAME>TO_SERIAL_NUMBER</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>17</DISPLAY_SEQUENCE>
      <COLUMN_NAME>TRANSACTION_DATE</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>15</DISPLAY_SEQUENCE>
      <COLUMN_NAME>UNIT_OF_MEASURE</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>27</DISPLAY_SEQUENCE>
      <COLUMN_NAME>VENDOR_LOT_NUM</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>41CE55665C2D4B41BB2AC006E9311885</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>REQUEST_ID_</COLUMN_NAME>
    <COLUMN_TYPE_DSP>Number</COLUMN_TYPE_DSP>
    <DATA_TYPE>number</DATA_TYPE>
    <HIDDEN>Y</HIDDEN>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>6</COLUMN_NUMBER>
    <COLUMN_NAME>ROW_ID</COLUMN_NAME>
    <COLUMN_TYPE_DSP>Char</COLUMN_TYPE_DSP>
    <DATA_TYPE>varchar2</DATA_TYPE>
    <READ_ONLY>Y</READ_ONLY>
    <HIDDEN>Y</HIDDEN>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>7</COLUMN_NUMBER>
    <COLUMN_NAME>ORGANIZATION_CODE</COLUMN_NAME>
    <COLUMN_TYPE_DSP>LOV</COLUMN_TYPE_DSP>
    <DATA_TYPE>varchar2</DATA_TYPE>
    <DATA_LENGTH>3</DATA_LENGTH>
    <LOV_NAME>INV Organization Code (accessible)</LOV_NAME>
    <LOV_GUID>FA6954EC34B240D9A30C047DDF5BD14D</LOV_GUID>
    <LOV_QUERY_DSP>select
mp.organization_id id,
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
order by
mp.organization_code</LOV_QUERY_DSP>
    <REQUIRED>Y</REQUIRED>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>8</COLUMN_NUMBER>
    <COLUMN_NAME>OPERATING_UNIT</COLUMN_NAME>
    <COLUMN_TYPE_DSP>LOV</COLUMN_TYPE_DSP>
    <DATA_TYPE>varchar2</DATA_TYPE>
    <DATA_LENGTH>240</DATA_LENGTH>
    <LOV_NAME>HR Operating Unit</LOV_NAME>
    <LOV_GUID>8E2FF36EDEB979D2E0530100007F1FF2</LOV_GUID>
    <LOV_QUERY_DSP>select
hou.name value,
null description
from
hr_operating_units hou
where
sysdate between hou.date_from and nvl(hou.date_to,sysdate) and
(:$flex$.ledger is null or hou.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
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>
    <VALUE_TO_ID_QUERY>select
hou.organization_id id,
hou.name value
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;)</VALUE_TO_ID_QUERY>
    <DEFAULT_VALUE>select
hou.name
from
org_organization_definitions ood,
hr_operating_units hou
where
ood.organization_code=:$column$.organization_code and
ood.operating_unit=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>
    <REQUIRED>Y</REQUIRED>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>9</COLUMN_NUMBER>
    <COLUMN_NAME>SUPPLIER</COLUMN_NAME>
    <COLUMN_TYPE_DSP>Char</COLUMN_TYPE_DSP>
    <DATA_TYPE>varchar2</DATA_TYPE>
    <DATA_LENGTH>240</DATA_LENGTH>
    <DEFAULT_VALUE>select
aps.vendor_name
from
hr_operating_units hou,
po_headers_all pha,
ap_suppliers aps
where
hou.name=:$column$.operating_unit and
pha.segment1=:$column$.po_number and
pha.org_id=hou.organization_id and
pha.vendor_id=aps.vendor_id</DEFAULT_VALUE>
    <READ_ONLY>Y</READ_ONLY>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>10</COLUMN_NUMBER>
    <COLUMN_NAME>SUPPLIER_SITE</COLUMN_NAME>
    <COLUMN_TYPE_DSP>Char</COLUMN_TYPE_DSP>
    <DATA_TYPE>varchar2</DATA_TYPE>
    <DATA_LENGTH>15</DATA_LENGTH>
    <DEFAULT_VALUE>select
assa.vendor_site_code
from
hr_operating_units hou,
po_headers_all pha,
ap_supplier_sites_all assa
where
hou.name=:$column$.operating_unit and
pha.segment1=:$column$.po_number and
pha.org_id=hou.organization_id and
pha.vendor_site_id=assa.vendor_site_id</DEFAULT_VALUE>
    <READ_ONLY>Y</READ_ONLY>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>11</COLUMN_NUMBER>
    <COLUMN_NAME>PO_NUMBER</COLUMN_NAME>
    <COLUMN_TYPE_DSP>LOV custom</COLUMN_TYPE_DSP>
    <DATA_TYPE>varchar2</DATA_TYPE>
    <DATA_LENGTH>20</DATA_LENGTH>
    <LOV_QUERY_DSP>select distinct
pha.segment1 value,
(select aps.vendor_name from ap_suppliers aps where pha.vendor_id=aps.vendor_id) description
from
mtl_parameters mp,
hr_operating_units hou,
po_line_locations_all plla,
po_headers_all pha
where
mp.organization_code=:$column$.organization_code and
hou.name=:$column$.operating_unit and
plla.ship_to_organization_id=mp.organization_id and
plla.po_header_id=pha.po_header_id and
pha.org_id=hou.organization_id and
plla.shipment_type in (&apos;STANDARD&apos;,&apos;BLANKET&apos;,&apos;SCHEDULED&apos;) and
plla.approved_flag=&apos;Y&apos; and
nvl(plla.cancel_flag,&apos;N&apos;)=&apos;N&apos; and
nvl(plla.closed_code,&apos;OPEN&apos;) not in (&apos;FINALLY CLOSED&apos;,&apos;CLOSED&apos;,&apos;CLOSED FOR RECEIVING&apos;) and
plla.quantity-nvl(plla.quantity_received,0)&gt;0
order by 1</LOV_QUERY_DSP>
    <REQUIRED>Y</REQUIRED>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>12</COLUMN_NUMBER>
    <COLUMN_NAME>RELEASE_NUM</COLUMN_NAME>
    <COLUMN_TYPE_DSP>LOV custom</COLUMN_TYPE_DSP>
    <DATA_TYPE>number</DATA_TYPE>
    <LOV_QUERY_DSP>select distinct
pra.release_num value,
null description
from
mtl_parameters mp,
hr_operating_units hou,
po_headers_all pha,
po_releases_all pra,
po_line_locations_all plla
where
mp.organization_code=:$column$.organization_code and
hou.name=:$column$.operating_unit and
pha.segment1=:$column$.po_number and
pha.org_id=hou.organization_id and
pha.po_header_id=pra.po_header_id and
pra.po_release_id=plla.po_release_id and
plla.ship_to_organization_id=mp.organization_id and
plla.approved_flag=&apos;Y&apos; and
nvl(plla.cancel_flag,&apos;N&apos;)=&apos;N&apos; and
nvl(plla.closed_code,&apos;OPEN&apos;) not in (&apos;FINALLY CLOSED&apos;,&apos;CLOSED&apos;,&apos;CLOSED FOR RECEIVING&apos;) and
plla.quantity-nvl(plla.quantity_received,0)&gt;0
order by 1</LOV_QUERY_DSP>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>13</COLUMN_NUMBER>
    <COLUMN_NAME>LINE_NUM</COLUMN_NAME>
    <COLUMN_TYPE_DSP>LOV custom</COLUMN_TYPE_DSP>
    <DATA_TYPE>number</DATA_TYPE>
    <LOV_QUERY_DSP>select distinct
pla.line_num value,
pla.item_description description
from
mtl_parameters mp,
hr_operating_units hou,
po_headers_all pha,
po_lines_all pla,
po_line_locations_all plla
where
mp.organization_code=:$column$.organization_code and
hou.name=:$column$.operating_unit and
pha.segment1=:$column$.po_number and
pha.org_id=hou.organization_id and
pha.po_header_id=pla.po_header_id and
pla.po_line_id=plla.po_line_id and
plla.ship_to_organization_id=mp.organization_id and
plla.shipment_type in (&apos;STANDARD&apos;,&apos;BLANKET&apos;,&apos;SCHEDULED&apos;) and
decode((select pra.release_num from po_releases_all pra where plla.po_release_id=pra.po_release_id),:$column$.release_num,1)=1 and
plla.approved_flag=&apos;Y&apos; and
nvl(plla.cancel_flag,&apos;N&apos;)=&apos;N&apos; and
nvl(plla.closed_code,&apos;OPEN&apos;) not in (&apos;FINALLY CLOSED&apos;,&apos;CLOSED&apos;,&apos;CLOSED FOR RECEIVING&apos;) and
plla.quantity-nvl(plla.quantity_received,0)&gt;0
order by 1</LOV_QUERY_DSP>
    <REQUIRED>Y</REQUIRED>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>14</COLUMN_NUMBER>
    <COLUMN_NAME>SHIPMENT_NUM</COLUMN_NAME>
    <COLUMN_TYPE_DSP>LOV custom</COLUMN_TYPE_DSP>
    <DATA_TYPE>number</DATA_TYPE>
    <LOV_QUERY_DSP>select
plla.shipment_num value,
plla.quantity-nvl(plla.quantity_received,0)||&apos; &apos;||pla.unit_meas_lookup_code||&apos; remaining&apos; description
from
mtl_parameters mp,
hr_operating_units hou,
po_headers_all pha,
po_lines_all pla,
po_line_locations_all plla
where
mp.organization_code=:$column$.organization_code and
hou.name=:$column$.operating_unit and
pha.segment1=:$column$.po_number and
pha.org_id=hou.organization_id and
pha.po_header_id=pla.po_header_id and
pla.line_num=:$column$.line_num and
pla.po_line_id=plla.po_line_id and
plla.ship_to_organization_id=mp.organization_id and
plla.shipment_type in (&apos;STANDARD&apos;,&apos;BLANKET&apos;,&apos;SCHEDULED&apos;) and
decode((select pra.release_num from po_releases_all pra where plla.po_release_id=pra.po_release_id),:$column$.release_num,1)=1 and
plla.approved_flag=&apos;Y&apos; and
nvl(plla.cancel_flag,&apos;N&apos;)=&apos;N&apos; and
nvl(plla.closed_code,&apos;OPEN&apos;) not in (&apos;FINALLY CLOSED&apos;,&apos;CLOSED&apos;,&apos;CLOSED FOR RECEIVING&apos;) and
plla.quantity-nvl(plla.quantity_received,0)&gt;0
order by 1</LOV_QUERY_DSP>
    <REQUIRED>Y</REQUIRED>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>15</COLUMN_NUMBER>
    <COLUMN_NAME>ITEM</COLUMN_NAME>
    <COLUMN_TYPE_DSP>Char</COLUMN_TYPE_DSP>
    <DATA_TYPE>varchar2</DATA_TYPE>
    <DATA_LENGTH>40</DATA_LENGTH>
    <DEFAULT_VALUE>select
msibk.concatenated_segments
from
mtl_parameters mp,
hr_operating_units hou,
po_headers_all pha,
po_lines_all pla,
po_line_locations_all plla,
mtl_system_items_b_kfv msibk
where
mp.organization_code=:$column$.organization_code and
hou.name=:$column$.operating_unit and
pha.segment1=:$column$.po_number and
pha.org_id=hou.organization_id and
pha.po_header_id=pla.po_header_id and
pla.line_num=:$column$.line_num and
pla.po_line_id=plla.po_line_id and
plla.shipment_num=:$column$.shipment_num and
plla.ship_to_organization_id=mp.organization_id and
pla.item_id=msibk.inventory_item_id and
plla.ship_to_organization_id=msibk.organization_id and
plla.shipment_type in (&apos;STANDARD&apos;,&apos;BLANKET&apos;,&apos;SCHEDULED&apos;) and
decode((select pra.release_num from po_releases_all pra where plla.po_release_id=pra.po_release_id),:$column$.release_num,1)=1</DEFAULT_VALUE>
    <READ_ONLY>Y</READ_ONLY>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>16</COLUMN_NUMBER>
    <COLUMN_NAME>ITEM_REVISION</COLUMN_NAME>
    <COLUMN_TYPE_DSP>LOV custom</COLUMN_TYPE_DSP>
    <DATA_TYPE>varchar2</DATA_TYPE>
    <DATA_LENGTH>3</DATA_LENGTH>
    <FREE_TEXT>Y</FREE_TEXT>
    <LOV_QUERY_DSP>select
mir.revision value,
null description
from
mtl_parameters mp,
hr_operating_units hou,
po_headers_all pha,
po_lines_all pla,
mtl_item_revisions mir
where
mp.organization_code=:$column$.organization_code and
hou.name=:$column$.operating_unit and
pha.segment1=:$column$.po_number and
pha.org_id=hou.organization_id and
pha.po_header_id=pla.po_header_id and
pla.line_num=:$column$.line_num and
pla.item_id=mir.inventory_item_id and
mp.organization_id=mir.organization_id
order by mir.revision</LOV_QUERY_DSP>
    <DEFAULT_VALUE>select
pla.item_revision
from
hr_operating_units hou,
po_headers_all pha,
po_lines_all pla
where
hou.name=:$column$.operating_unit and
pha.segment1=:$column$.po_number and
pha.org_id=hou.organization_id and
pha.po_header_id=pla.po_header_id and
pla.line_num=:$column$.line_num</DEFAULT_VALUE>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>17</COLUMN_NUMBER>
    <COLUMN_NAME>ITEM_DESCRIPTION</COLUMN_NAME>
    <COLUMN_TYPE_DSP>Char</COLUMN_TYPE_DSP>
    <DATA_TYPE>varchar2</DATA_TYPE>
    <DATA_LENGTH>240</DATA_LENGTH>
    <DEFAULT_VALUE>select
pla.item_description
from
hr_operating_units hou,
po_headers_all pha,
po_lines_all pla
where
hou.name=:$column$.operating_unit and
pha.segment1=:$column$.po_number and
pha.org_id=hou.organization_id and
pha.po_header_id=pla.po_header_id and
pla.line_num=:$column$.line_num</DEFAULT_VALUE>
    <READ_ONLY>Y</READ_ONLY>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>18</COLUMN_NUMBER>
    <COLUMN_NAME>QUANTITY_ORDERED</COLUMN_NAME>
    <COLUMN_TYPE_DSP>Number</COLUMN_TYPE_DSP>
    <DATA_TYPE>number</DATA_TYPE>
    <DEFAULT_VALUE>select
plla.quantity
from
mtl_parameters mp,
hr_operating_units hou,
po_headers_all pha,
po_lines_all pla,
po_line_locations_all plla
where
mp.organization_code=:$column$.organization_code and
hou.name=:$column$.operating_unit and
pha.segment1=:$column$.po_number and
pha.org_id=hou.organization_id and
pha.po_header_id=pla.po_header_id and
pla.line_num=:$column$.line_num and
pla.po_line_id=plla.po_line_id and
plla.shipment_num=:$column$.shipment_num and
plla.ship_to_organization_id=mp.organization_id and
plla.shipment_type in (&apos;STANDARD&apos;,&apos;BLANKET&apos;,&apos;SCHEDULED&apos;) and
decode((select pra.release_num from po_releases_all pra where plla.po_release_id=pra.po_release_id),:$column$.release_num,1)=1</DEFAULT_VALUE>
    <READ_ONLY>Y</READ_ONLY>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>19</COLUMN_NUMBER>
    <COLUMN_NAME>QUANTITY_RECEIVED</COLUMN_NAME>
    <COLUMN_TYPE_DSP>Number</COLUMN_TYPE_DSP>
    <DATA_TYPE>number</DATA_TYPE>
    <DEFAULT_VALUE>select
nvl(plla.quantity_received,0)
from
mtl_parameters mp,
hr_operating_units hou,
po_headers_all pha,
po_lines_all pla,
po_line_locations_all plla
where
mp.organization_code=:$column$.organization_code and
hou.name=:$column$.operating_unit and
pha.segment1=:$column$.po_number and
pha.org_id=hou.organization_id and
pha.po_header_id=pla.po_header_id and
pla.line_num=:$column$.line_num and
pla.po_line_id=plla.po_line_id and
plla.shipment_num=:$column$.shipment_num and
plla.ship_to_organization_id=mp.organization_id and
plla.shipment_type in (&apos;STANDARD&apos;,&apos;BLANKET&apos;,&apos;SCHEDULED&apos;) and
decode((select pra.release_num from po_releases_all pra where plla.po_release_id=pra.po_release_id),:$column$.release_num,1)=1</DEFAULT_VALUE>
    <READ_ONLY>Y</READ_ONLY>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>20</COLUMN_NUMBER>
    <COLUMN_NAME>QUANTITY_REMAINING</COLUMN_NAME>
    <COLUMN_TYPE_DSP>Number</COLUMN_TYPE_DSP>
    <DATA_TYPE>number</DATA_TYPE>
    <DEFAULT_VALUE>select
plla.quantity-nvl(plla.quantity_received,0)
from
mtl_parameters mp,
hr_operating_units hou,
po_headers_all pha,
po_lines_all pla,
po_line_locations_all plla
where
mp.organization_code=:$column$.organization_code and
hou.name=:$column$.operating_unit and
pha.segment1=:$column$.po_number and
pha.org_id=hou.organization_id and
pha.po_header_id=pla.po_header_id and
pla.line_num=:$column$.line_num and
pla.po_line_id=plla.po_line_id and
plla.shipment_num=:$column$.shipment_num and
plla.ship_to_organization_id=mp.organization_id and
plla.shipment_type in (&apos;STANDARD&apos;,&apos;BLANKET&apos;,&apos;SCHEDULED&apos;) and
decode((select pra.release_num from po_releases_all pra where plla.po_release_id=pra.po_release_id),:$column$.release_num,1)=1</DEFAULT_VALUE>
    <READ_ONLY>Y</READ_ONLY>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>21</COLUMN_NUMBER>
    <COLUMN_NAME>UNIT_OF_MEASURE</COLUMN_NAME>
    <COLUMN_TYPE_DSP>Char</COLUMN_TYPE_DSP>
    <DATA_TYPE>varchar2</DATA_TYPE>
    <DATA_LENGTH>25</DATA_LENGTH>
    <DEFAULT_VALUE>select
pla.unit_meas_lookup_code
from
hr_operating_units hou,
po_headers_all pha,
po_lines_all pla
where
hou.name=:$column$.operating_unit and
pha.segment1=:$column$.po_number and
pha.org_id=hou.organization_id and
pha.po_header_id=pla.po_header_id and
pla.line_num=:$column$.line_num</DEFAULT_VALUE>
    <READ_ONLY>Y</READ_ONLY>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>22</COLUMN_NUMBER>
    <COLUMN_NAME>QUANTITY</COLUMN_NAME>
    <COLUMN_TYPE_DSP>Number</COLUMN_TYPE_DSP>
    <DATA_TYPE>number</DATA_TYPE>
    <DEFAULT_VALUE>:$column$.quantity_remaining</DEFAULT_VALUE>
    <REQUIRED>Y</REQUIRED>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>23</COLUMN_NUMBER>
    <COLUMN_NAME>TRANSACTION_DATE</COLUMN_NAME>
    <COLUMN_TYPE_DSP>Date</COLUMN_TYPE_DSP>
    <DATA_TYPE>date</DATA_TYPE>
    <DEFAULT_VALUE>sysdate</DEFAULT_VALUE>
    <REQUIRED>Y</REQUIRED>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>24</COLUMN_NUMBER>
    <COLUMN_NAME>DESTINATION_TYPE</COLUMN_NAME>
    <COLUMN_TYPE_DSP>LOV custom</COLUMN_TYPE_DSP>
    <DATA_TYPE>varchar2</DATA_TYPE>
    <LOV_QUERY_DSP>select
flvv.lookup_code id,
flvv.meaning value,
flvv.description
from
fnd_lookup_values_vl flvv
where
flvv.lookup_type=&apos;DESTINATION TYPE&apos; and
flvv.view_application_id=201 and
flvv.security_group_id=0 and
flvv.enabled_flag=&apos;Y&apos; and
nvl(flvv.end_date_active,sysdate)&gt;=sysdate
order by flvv.meaning</LOV_QUERY_DSP>
    <DEFAULT_VALUE>select
xxen_util.meaning(pda.destination_type_code,&apos;DESTINATION TYPE&apos;,201)
from
mtl_parameters mp,
hr_operating_units hou,
po_headers_all pha,
po_lines_all pla,
po_line_locations_all plla,
po_distributions_all pda
where
mp.organization_code=:$column$.organization_code and
hou.name=:$column$.operating_unit and
pha.segment1=:$column$.po_number and
pha.org_id=hou.organization_id and
pha.po_header_id=pla.po_header_id and
pla.line_num=:$column$.line_num and
pla.po_line_id=plla.po_line_id and
plla.shipment_num=:$column$.shipment_num and
plla.ship_to_organization_id=mp.organization_id and
plla.shipment_type in (&apos;STANDARD&apos;,&apos;BLANKET&apos;,&apos;SCHEDULED&apos;) and
decode((select pra.release_num from po_releases_all pra where plla.po_release_id=pra.po_release_id),:$column$.release_num,1)=1 and
plla.line_location_id=pda.line_location_id and
rownum=1</DEFAULT_VALUE>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>25</COLUMN_NUMBER>
    <COLUMN_NAME>SUBINVENTORY</COLUMN_NAME>
    <COLUMN_TYPE_DSP>LOV custom</COLUMN_TYPE_DSP>
    <DATA_TYPE>varchar2</DATA_TYPE>
    <DATA_LENGTH>10</DATA_LENGTH>
    <LOV_QUERY_DSP>select
msub.secondary_inventory_name value,
msub.description
from
mtl_parameters mp,
mtl_secondary_inventories msub
where
mp.organization_code=:$column$.organization_code and
mp.organization_id=msub.organization_id and
nvl(msub.disable_date,sysdate)&gt;=sysdate
order by
msub.secondary_inventory_name</LOV_QUERY_DSP>
    <DEFAULT_VALUE>select
pda.destination_subinventory
from
mtl_parameters mp,
hr_operating_units hou,
po_headers_all pha,
po_lines_all pla,
po_line_locations_all plla,
po_distributions_all pda
where
mp.organization_code=:$column$.organization_code and
hou.name=:$column$.operating_unit and
pha.segment1=:$column$.po_number and
pha.org_id=hou.organization_id and
pha.po_header_id=pla.po_header_id and
pla.line_num=:$column$.line_num and
pla.po_line_id=plla.po_line_id and
plla.shipment_num=:$column$.shipment_num and
plla.ship_to_organization_id=mp.organization_id and
plla.shipment_type in (&apos;STANDARD&apos;,&apos;BLANKET&apos;,&apos;SCHEDULED&apos;) and
decode((select pra.release_num from po_releases_all pra where plla.po_release_id=pra.po_release_id),:$column$.release_num,1)=1 and
plla.line_location_id=pda.line_location_id and
rownum=1</DEFAULT_VALUE>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>26</COLUMN_NUMBER>
    <COLUMN_NAME>LOCATOR</COLUMN_NAME>
    <COLUMN_TYPE_DSP>LOV custom</COLUMN_TYPE_DSP>
    <DATA_TYPE>varchar2</DATA_TYPE>
    <FILTER_BEFORE_DISPLAY_DSP>Y</FILTER_BEFORE_DISPLAY_DSP>
    <LOV_QUERY_DSP>select
milk.inventory_location_id id,
milk.concatenated_segments value,
milk.description
from
mtl_parameters mp,
mtl_item_locations_kfv milk
where
mp.organization_code=:$column$.organization_code and
mp.organization_id=milk.organization_id and
milk.subinventory_code=:$column$.subinventory and
nvl(milk.disable_date,sysdate)&gt;=sysdate
order by milk.concatenated_segments</LOV_QUERY_DSP>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>27</COLUMN_NUMBER>
    <COLUMN_NAME>LOT_NUMBER</COLUMN_NAME>
    <COLUMN_TYPE_DSP>Char</COLUMN_TYPE_DSP>
    <DATA_TYPE>varchar2</DATA_TYPE>
    <DATA_LENGTH>80</DATA_LENGTH>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>28</COLUMN_NUMBER>
    <COLUMN_NAME>LOT_EXPIRATION_DATE</COLUMN_NAME>
    <COLUMN_TYPE_DSP>Date</COLUMN_TYPE_DSP>
    <DATA_TYPE>date</DATA_TYPE>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>29</COLUMN_NUMBER>
    <COLUMN_NAME>FROM_SERIAL_NUMBER</COLUMN_NAME>
    <COLUMN_TYPE_DSP>Char</COLUMN_TYPE_DSP>
    <DATA_TYPE>varchar2</DATA_TYPE>
    <DATA_LENGTH>30</DATA_LENGTH>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>30</COLUMN_NUMBER>
    <COLUMN_NAME>TO_SERIAL_NUMBER</COLUMN_NAME>
    <COLUMN_TYPE_DSP>Char</COLUMN_TYPE_DSP>
    <DATA_TYPE>varchar2</DATA_TYPE>
    <DATA_LENGTH>30</DATA_LENGTH>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>31</COLUMN_NUMBER>
    <COLUMN_NAME>DELIVER_TO_LOCATION</COLUMN_NAME>
    <COLUMN_TYPE_DSP>LOV</COLUMN_TYPE_DSP>
    <DATA_TYPE>varchar2</DATA_TYPE>
    <DATA_LENGTH>60</DATA_LENGTH>
    <LOV_NAME>HR Location (active)</LOV_NAME>
    <LOV_GUID>C29634531CC44D27BD181B6FC3125D95</LOV_GUID>
    <LOV_QUERY_DSP>select hla.location_id id, hla.location_code value, hla.description from hr_locations_all hla where nvl(hla.inactive_date,sysdate+1)&gt;sysdate order by value</LOV_QUERY_DSP>
    <DEFAULT_VALUE>select
hla.location_code
from
mtl_parameters mp,
hr_operating_units hou,
po_headers_all pha,
po_lines_all pla,
po_line_locations_all plla,
po_distributions_all pda,
hr_locations_all hla
where
mp.organization_code=:$column$.organization_code and
hou.name=:$column$.operating_unit and
pha.segment1=:$column$.po_number and
pha.org_id=hou.organization_id and
pha.po_header_id=pla.po_header_id and
pla.line_num=:$column$.line_num and
pla.po_line_id=plla.po_line_id and
plla.shipment_num=:$column$.shipment_num and
plla.ship_to_organization_id=mp.organization_id and
plla.shipment_type in (&apos;STANDARD&apos;,&apos;BLANKET&apos;,&apos;SCHEDULED&apos;) and
decode((select pra.release_num from po_releases_all pra where plla.po_release_id=pra.po_release_id),:$column$.release_num,1)=1 and
plla.line_location_id=pda.line_location_id and
pda.deliver_to_location_id=hla.location_id and
rownum=1</DEFAULT_VALUE>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>32</COLUMN_NUMBER>
    <COLUMN_NAME>COUNTRY_OF_ORIGIN</COLUMN_NAME>
    <COLUMN_TYPE_DSP>LOV custom</COLUMN_TYPE_DSP>
    <DATA_TYPE>varchar2</DATA_TYPE>
    <DATA_LENGTH>80</DATA_LENGTH>
    <LOV_QUERY_DSP>select
ft.territory_code id,
ft.territory_short_name value,
null description
from
fnd_territories_vl ft
where
nvl(ft.obsolete_flag,&apos;N&apos;)=&apos;N&apos;
order by ft.territory_short_name</LOV_QUERY_DSP>
    <DEFAULT_VALUE>select
ft.territory_short_name
from
mtl_parameters mp,
hr_operating_units hou,
po_headers_all pha,
po_lines_all pla,
po_line_locations_all plla,
fnd_territories_vl ft
where
mp.organization_code=:$column$.organization_code and
hou.name=:$column$.operating_unit and
pha.segment1=:$column$.po_number and
pha.org_id=hou.organization_id and
pha.po_header_id=pla.po_header_id and
pla.line_num=:$column$.line_num and
pla.po_line_id=plla.po_line_id and
plla.shipment_num=:$column$.shipment_num and
plla.ship_to_organization_id=mp.organization_id and
plla.shipment_type in (&apos;STANDARD&apos;,&apos;BLANKET&apos;,&apos;SCHEDULED&apos;) and
decode((select pra.release_num from po_releases_all pra where plla.po_release_id=pra.po_release_id),:$column$.release_num,1)=1 and
plla.country_of_origin_code=ft.territory_code</DEFAULT_VALUE>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>33</COLUMN_NUMBER>
    <COLUMN_NAME>VENDOR_LOT_NUM</COLUMN_NAME>
    <COLUMN_TYPE_DSP>Char</COLUMN_TYPE_DSP>
    <DATA_TYPE>varchar2</DATA_TYPE>
    <DATA_LENGTH>30</DATA_LENGTH>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>34</COLUMN_NUMBER>
    <COLUMN_NAME>COMMENTS</COLUMN_NAME>
    <COLUMN_TYPE_DSP>Char</COLUMN_TYPE_DSP>
    <DATA_TYPE>varchar2</DATA_TYPE>
    <DATA_LENGTH>240</DATA_LENGTH>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>35</COLUMN_NUMBER>
    <COLUMN_NAME>RECEIPT_ATTRIBUTE_CATEGORY</COLUMN_NAME>
    <COLUMN_TYPE_DSP>LOV custom</COLUMN_TYPE_DSP>
    <DATA_TYPE>varchar2</DATA_TYPE>
    <LOV_QUERY_DSP>select
fdfcv.descriptive_flex_context_name value,
fdfcv.description
from
fnd_descr_flex_contexts_vl fdfcv
where
fdfcv.application_id=201 and
fdfcv.descriptive_flexfield_name=&apos;RCV_SHIPMENT_HEADERS&apos; and
fdfcv.enabled_flag=&apos;Y&apos; and
fdfcv.global_flag=&apos;N&apos;
order by
fdfcv.descriptive_flex_context_name</LOV_QUERY_DSP>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>36</COLUMN_NUMBER>
    <COLUMN_NAME>RECEIPT_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;201,
p_descriptive_flexfield_name=&gt;&apos;RCV_SHIPMENT_HEADERS&apos;,
p_context_name=&gt;:$column$.receipt_attribute_category,
p_column_name=&gt;&apos;ATTRIBUTE1&apos;,
p_attribute1=&gt;:$column$.receipt_attribute1,
p_attribute2=&gt;:$column$.receipt_attribute2,
p_attribute3=&gt;:$column$.receipt_attribute3,
p_attribute4=&gt;:$column$.receipt_attribute4,
p_attribute5=&gt;:$column$.receipt_attribute5,
p_attribute6=&gt;:$column$.receipt_attribute6,
p_attribute7=&gt;:$column$.receipt_attribute7,
p_attribute8=&gt;:$column$.receipt_attribute8,
p_attribute9=&gt;:$column$.receipt_attribute9,
p_attribute10=&gt;:$column$.receipt_attribute10,
p_attribute11=&gt;:$column$.receipt_attribute11,
p_attribute12=&gt;:$column$.receipt_attribute12,
p_attribute13=&gt;:$column$.receipt_attribute13,
p_attribute14=&gt;:$column$.receipt_attribute14,
p_attribute15=&gt;:$column$.receipt_attribute15
)) lov
order by
value</LOV_QUERY_DSP>
    <COMMENTS>select
&apos;(Context) &apos;||initcap(y.application_column_name)||&apos;: &apos;||listagg(y.entry,&apos;, &apos;) within group (order by y.sort_key) comments
from
(
select
x.application_column_name,
x.entry,
x.sort_key,
sum(lengthb(x.entry)+2) over (order by x.sort_key) len
from
(
select
fdfcu.application_column_name,
decode(fdfc.descriptive_flex_context_code,&apos;Global Data Elements&apos;,&apos;(Global)&apos;,&apos;(&apos;||fdfc.descriptive_flex_context_code||&apos;)&apos;)||&apos; &apos;||fdfcu.form_left_prompt entry,
decode(fdfc.descriptive_flex_context_code,&apos;Global Data Elements&apos;,&apos;1&apos;,&apos;2&apos;||fdfc.descriptive_flex_context_code) sort_key
from
fnd_descr_flex_contexts fdfc,
fnd_descr_flex_col_usage_vl fdfcu
where
fdfc.application_id=201 and
fdfc.descriptive_flexfield_name=&apos;RCV_SHIPMENT_HEADERS&apos; and
fdfc.enabled_flag=&apos;Y&apos; and
fdfc.application_id=fdfcu.application_id and
fdfc.descriptive_flexfield_name=fdfcu.descriptive_flexfield_name and
fdfc.descriptive_flex_context_code=fdfcu.descriptive_flex_context_code and
fdfcu.enabled_flag=&apos;Y&apos; and
fdfcu.application_column_name=&apos;ATTRIBUTE1&apos;
) x
) y
where
y.len&lt;=3900
group by
y.application_column_name</COMMENTS>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>37</COLUMN_NUMBER>
    <COLUMN_NAME>RECEIPT_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;201,
p_descriptive_flexfield_name=&gt;&apos;RCV_SHIPMENT_HEADERS&apos;,
p_context_name=&gt;:$column$.receipt_attribute_category,
p_column_name=&gt;&apos;ATTRIBUTE2&apos;,
p_attribute1=&gt;:$column$.receipt_attribute1,
p_attribute2=&gt;:$column$.receipt_attribute2,
p_attribute3=&gt;:$column$.receipt_attribute3,
p_attribute4=&gt;:$column$.receipt_attribute4,
p_attribute5=&gt;:$column$.receipt_attribute5,
p_attribute6=&gt;:$column$.receipt_attribute6,
p_attribute7=&gt;:$column$.receipt_attribute7,
p_attribute8=&gt;:$column$.receipt_attribute8,
p_attribute9=&gt;:$column$.receipt_attribute9,
p_attribute10=&gt;:$column$.receipt_attribute10,
p_attribute11=&gt;:$column$.receipt_attribute11,
p_attribute12=&gt;:$column$.receipt_attribute12,
p_attribute13=&gt;:$column$.receipt_attribute13,
p_attribute14=&gt;:$column$.receipt_attribute14,
p_attribute15=&gt;:$column$.receipt_attribute15
)) lov
order by
value</LOV_QUERY_DSP>
    <COMMENTS>select
&apos;(Context) &apos;||initcap(y.application_column_name)||&apos;: &apos;||listagg(y.entry,&apos;, &apos;) within group (order by y.sort_key) comments
from
(
select
x.application_column_name,
x.entry,
x.sort_key,
sum(lengthb(x.entry)+2) over (order by x.sort_key) len
from
(
select
fdfcu.application_column_name,
decode(fdfc.descriptive_flex_context_code,&apos;Global Data Elements&apos;,&apos;(Global)&apos;,&apos;(&apos;||fdfc.descriptive_flex_context_code||&apos;)&apos;)||&apos; &apos;||fdfcu.form_left_prompt entry,
decode(fdfc.descriptive_flex_context_code,&apos;Global Data Elements&apos;,&apos;1&apos;,&apos;2&apos;||fdfc.descriptive_flex_context_code) sort_key
from
fnd_descr_flex_contexts fdfc,
fnd_descr_flex_col_usage_vl fdfcu
where
fdfc.application_id=201 and
fdfc.descriptive_flexfield_name=&apos;RCV_SHIPMENT_HEADERS&apos; and
fdfc.enabled_flag=&apos;Y&apos; and
fdfc.application_id=fdfcu.application_id and
fdfc.descriptive_flexfield_name=fdfcu.descriptive_flexfield_name and
fdfc.descriptive_flex_context_code=fdfcu.descriptive_flex_context_code and
fdfcu.enabled_flag=&apos;Y&apos; and
fdfcu.application_column_name=&apos;ATTRIBUTE2&apos;
) x
) y
where
y.len&lt;=3900
group by
y.application_column_name</COMMENTS>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>38</COLUMN_NUMBER>
    <COLUMN_NAME>RECEIPT_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;201,
p_descriptive_flexfield_name=&gt;&apos;RCV_SHIPMENT_HEADERS&apos;,
p_context_name=&gt;:$column$.receipt_attribute_category,
p_column_name=&gt;&apos;ATTRIBUTE3&apos;,
p_attribute1=&gt;:$column$.receipt_attribute1,
p_attribute2=&gt;:$column$.receipt_attribute2,
p_attribute3=&gt;:$column$.receipt_attribute3,
p_attribute4=&gt;:$column$.receipt_attribute4,
p_attribute5=&gt;:$column$.receipt_attribute5,
p_attribute6=&gt;:$column$.receipt_attribute6,
p_attribute7=&gt;:$column$.receipt_attribute7,
p_attribute8=&gt;:$column$.receipt_attribute8,
p_attribute9=&gt;:$column$.receipt_attribute9,
p_attribute10=&gt;:$column$.receipt_attribute10,
p_attribute11=&gt;:$column$.receipt_attribute11,
p_attribute12=&gt;:$column$.receipt_attribute12,
p_attribute13=&gt;:$column$.receipt_attribute13,
p_attribute14=&gt;:$column$.receipt_attribute14,
p_attribute15=&gt;:$column$.receipt_attribute15
)) lov
order by
value</LOV_QUERY_DSP>
    <COMMENTS>select
&apos;(Context) &apos;||initcap(y.application_column_name)||&apos;: &apos;||listagg(y.entry,&apos;, &apos;) within group (order by y.sort_key) comments
from
(
select
x.application_column_name,
x.entry,
x.sort_key,
sum(lengthb(x.entry)+2) over (order by x.sort_key) len
from
(
select
fdfcu.application_column_name,
decode(fdfc.descriptive_flex_context_code,&apos;Global Data Elements&apos;,&apos;(Global)&apos;,&apos;(&apos;||fdfc.descriptive_flex_context_code||&apos;)&apos;)||&apos; &apos;||fdfcu.form_left_prompt entry,
decode(fdfc.descriptive_flex_context_code,&apos;Global Data Elements&apos;,&apos;1&apos;,&apos;2&apos;||fdfc.descriptive_flex_context_code) sort_key
from
fnd_descr_flex_contexts fdfc,
fnd_descr_flex_col_usage_vl fdfcu
where
fdfc.application_id=201 and
fdfc.descriptive_flexfield_name=&apos;RCV_SHIPMENT_HEADERS&apos; and
fdfc.enabled_flag=&apos;Y&apos; and
fdfc.application_id=fdfcu.application_id and
fdfc.descriptive_flexfield_name=fdfcu.descriptive_flexfield_name and
fdfc.descriptive_flex_context_code=fdfcu.descriptive_flex_context_code and
fdfcu.enabled_flag=&apos;Y&apos; and
fdfcu.application_column_name=&apos;ATTRIBUTE3&apos;
) x
) y
where
y.len&lt;=3900
group by
y.application_column_name</COMMENTS>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>39</COLUMN_NUMBER>
    <COLUMN_NAME>RECEIPT_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;201,
p_descriptive_flexfield_name=&gt;&apos;RCV_SHIPMENT_HEADERS&apos;,
p_context_name=&gt;:$column$.receipt_attribute_category,
p_column_name=&gt;&apos;ATTRIBUTE4&apos;,
p_attribute1=&gt;:$column$.receipt_attribute1,
p_attribute2=&gt;:$column$.receipt_attribute2,
p_attribute3=&gt;:$column$.receipt_attribute3,
p_attribute4=&gt;:$column$.receipt_attribute4,
p_attribute5=&gt;:$column$.receipt_attribute5,
p_attribute6=&gt;:$column$.receipt_attribute6,
p_attribute7=&gt;:$column$.receipt_attribute7,
p_attribute8=&gt;:$column$.receipt_attribute8,
p_attribute9=&gt;:$column$.receipt_attribute9,
p_attribute10=&gt;:$column$.receipt_attribute10,
p_attribute11=&gt;:$column$.receipt_attribute11,
p_attribute12=&gt;:$column$.receipt_attribute12,
p_attribute13=&gt;:$column$.receipt_attribute13,
p_attribute14=&gt;:$column$.receipt_attribute14,
p_attribute15=&gt;:$column$.receipt_attribute15
)) lov
order by
value</LOV_QUERY_DSP>
    <COMMENTS>select
&apos;(Context) &apos;||initcap(y.application_column_name)||&apos;: &apos;||listagg(y.entry,&apos;, &apos;) within group (order by y.sort_key) comments
from
(
select
x.application_column_name,
x.entry,
x.sort_key,
sum(lengthb(x.entry)+2) over (order by x.sort_key) len
from
(
select
fdfcu.application_column_name,
decode(fdfc.descriptive_flex_context_code,&apos;Global Data Elements&apos;,&apos;(Global)&apos;,&apos;(&apos;||fdfc.descriptive_flex_context_code||&apos;)&apos;)||&apos; &apos;||fdfcu.form_left_prompt entry,
decode(fdfc.descriptive_flex_context_code,&apos;Global Data Elements&apos;,&apos;1&apos;,&apos;2&apos;||fdfc.descriptive_flex_context_code) sort_key
from
fnd_descr_flex_contexts fdfc,
fnd_descr_flex_col_usage_vl fdfcu
where
fdfc.application_id=201 and
fdfc.descriptive_flexfield_name=&apos;RCV_SHIPMENT_HEADERS&apos; and
fdfc.enabled_flag=&apos;Y&apos; and
fdfc.application_id=fdfcu.application_id and
fdfc.descriptive_flexfield_name=fdfcu.descriptive_flexfield_name and
fdfc.descriptive_flex_context_code=fdfcu.descriptive_flex_context_code and
fdfcu.enabled_flag=&apos;Y&apos; and
fdfcu.application_column_name=&apos;ATTRIBUTE4&apos;
) x
) y
where
y.len&lt;=3900
group by
y.application_column_name</COMMENTS>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>40</COLUMN_NUMBER>
    <COLUMN_NAME>RECEIPT_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;201,
p_descriptive_flexfield_name=&gt;&apos;RCV_SHIPMENT_HEADERS&apos;,
p_context_name=&gt;:$column$.receipt_attribute_category,
p_column_name=&gt;&apos;ATTRIBUTE5&apos;,
p_attribute1=&gt;:$column$.receipt_attribute1,
p_attribute2=&gt;:$column$.receipt_attribute2,
p_attribute3=&gt;:$column$.receipt_attribute3,
p_attribute4=&gt;:$column$.receipt_attribute4,
p_attribute5=&gt;:$column$.receipt_attribute5,
p_attribute6=&gt;:$column$.receipt_attribute6,
p_attribute7=&gt;:$column$.receipt_attribute7,
p_attribute8=&gt;:$column$.receipt_attribute8,
p_attribute9=&gt;:$column$.receipt_attribute9,
p_attribute10=&gt;:$column$.receipt_attribute10,
p_attribute11=&gt;:$column$.receipt_attribute11,
p_attribute12=&gt;:$column$.receipt_attribute12,
p_attribute13=&gt;:$column$.receipt_attribute13,
p_attribute14=&gt;:$column$.receipt_attribute14,
p_attribute15=&gt;:$column$.receipt_attribute15
)) lov
order by
value</LOV_QUERY_DSP>
    <COMMENTS>select
&apos;(Context) &apos;||initcap(y.application_column_name)||&apos;: &apos;||listagg(y.entry,&apos;, &apos;) within group (order by y.sort_key) comments
from
(
select
x.application_column_name,
x.entry,
x.sort_key,
sum(lengthb(x.entry)+2) over (order by x.sort_key) len
from
(
select
fdfcu.application_column_name,
decode(fdfc.descriptive_flex_context_code,&apos;Global Data Elements&apos;,&apos;(Global)&apos;,&apos;(&apos;||fdfc.descriptive_flex_context_code||&apos;)&apos;)||&apos; &apos;||fdfcu.form_left_prompt entry,
decode(fdfc.descriptive_flex_context_code,&apos;Global Data Elements&apos;,&apos;1&apos;,&apos;2&apos;||fdfc.descriptive_flex_context_code) sort_key
from
fnd_descr_flex_contexts fdfc,
fnd_descr_flex_col_usage_vl fdfcu
where
fdfc.application_id=201 and
fdfc.descriptive_flexfield_name=&apos;RCV_SHIPMENT_HEADERS&apos; and
fdfc.enabled_flag=&apos;Y&apos; and
fdfc.application_id=fdfcu.application_id and
fdfc.descriptive_flexfield_name=fdfcu.descriptive_flexfield_name and
fdfc.descriptive_flex_context_code=fdfcu.descriptive_flex_context_code and
fdfcu.enabled_flag=&apos;Y&apos; and
fdfcu.application_column_name=&apos;ATTRIBUTE5&apos;
) x
) y
where
y.len&lt;=3900
group by
y.application_column_name</COMMENTS>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>41</COLUMN_NUMBER>
    <COLUMN_NAME>RECEIPT_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;201,
p_descriptive_flexfield_name=&gt;&apos;RCV_SHIPMENT_HEADERS&apos;,
p_context_name=&gt;:$column$.receipt_attribute_category,
p_column_name=&gt;&apos;ATTRIBUTE6&apos;,
p_attribute1=&gt;:$column$.receipt_attribute1,
p_attribute2=&gt;:$column$.receipt_attribute2,
p_attribute3=&gt;:$column$.receipt_attribute3,
p_attribute4=&gt;:$column$.receipt_attribute4,
p_attribute5=&gt;:$column$.receipt_attribute5,
p_attribute6=&gt;:$column$.receipt_attribute6,
p_attribute7=&gt;:$column$.receipt_attribute7,
p_attribute8=&gt;:$column$.receipt_attribute8,
p_attribute9=&gt;:$column$.receipt_attribute9,
p_attribute10=&gt;:$column$.receipt_attribute10,
p_attribute11=&gt;:$column$.receipt_attribute11,
p_attribute12=&gt;:$column$.receipt_attribute12,
p_attribute13=&gt;:$column$.receipt_attribute13,
p_attribute14=&gt;:$column$.receipt_attribute14,
p_attribute15=&gt;:$column$.receipt_attribute15
)) lov
order by
value</LOV_QUERY_DSP>
    <COMMENTS>select
&apos;(Context) &apos;||initcap(y.application_column_name)||&apos;: &apos;||listagg(y.entry,&apos;, &apos;) within group (order by y.sort_key) comments
from
(
select
x.application_column_name,
x.entry,
x.sort_key,
sum(lengthb(x.entry)+2) over (order by x.sort_key) len
from
(
select
fdfcu.application_column_name,
decode(fdfc.descriptive_flex_context_code,&apos;Global Data Elements&apos;,&apos;(Global)&apos;,&apos;(&apos;||fdfc.descriptive_flex_context_code||&apos;)&apos;)||&apos; &apos;||fdfcu.form_left_prompt entry,
decode(fdfc.descriptive_flex_context_code,&apos;Global Data Elements&apos;,&apos;1&apos;,&apos;2&apos;||fdfc.descriptive_flex_context_code) sort_key
from
fnd_descr_flex_contexts fdfc,
fnd_descr_flex_col_usage_vl fdfcu
where
fdfc.application_id=201 and
fdfc.descriptive_flexfield_name=&apos;RCV_SHIPMENT_HEADERS&apos; and
fdfc.enabled_flag=&apos;Y&apos; and
fdfc.application_id=fdfcu.application_id and
fdfc.descriptive_flexfield_name=fdfcu.descriptive_flexfield_name and
fdfc.descriptive_flex_context_code=fdfcu.descriptive_flex_context_code and
fdfcu.enabled_flag=&apos;Y&apos; and
fdfcu.application_column_name=&apos;ATTRIBUTE6&apos;
) x
) y
where
y.len&lt;=3900
group by
y.application_column_name</COMMENTS>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>42</COLUMN_NUMBER>
    <COLUMN_NAME>RECEIPT_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;201,
p_descriptive_flexfield_name=&gt;&apos;RCV_SHIPMENT_HEADERS&apos;,
p_context_name=&gt;:$column$.receipt_attribute_category,
p_column_name=&gt;&apos;ATTRIBUTE7&apos;,
p_attribute1=&gt;:$column$.receipt_attribute1,
p_attribute2=&gt;:$column$.receipt_attribute2,
p_attribute3=&gt;:$column$.receipt_attribute3,
p_attribute4=&gt;:$column$.receipt_attribute4,
p_attribute5=&gt;:$column$.receipt_attribute5,
p_attribute6=&gt;:$column$.receipt_attribute6,
p_attribute7=&gt;:$column$.receipt_attribute7,
p_attribute8=&gt;:$column$.receipt_attribute8,
p_attribute9=&gt;:$column$.receipt_attribute9,
p_attribute10=&gt;:$column$.receipt_attribute10,
p_attribute11=&gt;:$column$.receipt_attribute11,
p_attribute12=&gt;:$column$.receipt_attribute12,
p_attribute13=&gt;:$column$.receipt_attribute13,
p_attribute14=&gt;:$column$.receipt_attribute14,
p_attribute15=&gt;:$column$.receipt_attribute15
)) lov
order by
value</LOV_QUERY_DSP>
    <COMMENTS>select
&apos;(Context) &apos;||initcap(y.application_column_name)||&apos;: &apos;||listagg(y.entry,&apos;, &apos;) within group (order by y.sort_key) comments
from
(
select
x.application_column_name,
x.entry,
x.sort_key,
sum(lengthb(x.entry)+2) over (order by x.sort_key) len
from
(
select
fdfcu.application_column_name,
decode(fdfc.descriptive_flex_context_code,&apos;Global Data Elements&apos;,&apos;(Global)&apos;,&apos;(&apos;||fdfc.descriptive_flex_context_code||&apos;)&apos;)||&apos; &apos;||fdfcu.form_left_prompt entry,
decode(fdfc.descriptive_flex_context_code,&apos;Global Data Elements&apos;,&apos;1&apos;,&apos;2&apos;||fdfc.descriptive_flex_context_code) sort_key
from
fnd_descr_flex_contexts fdfc,
fnd_descr_flex_col_usage_vl fdfcu
where
fdfc.application_id=201 and
fdfc.descriptive_flexfield_name=&apos;RCV_SHIPMENT_HEADERS&apos; and
fdfc.enabled_flag=&apos;Y&apos; and
fdfc.application_id=fdfcu.application_id and
fdfc.descriptive_flexfield_name=fdfcu.descriptive_flexfield_name and
fdfc.descriptive_flex_context_code=fdfcu.descriptive_flex_context_code and
fdfcu.enabled_flag=&apos;Y&apos; and
fdfcu.application_column_name=&apos;ATTRIBUTE7&apos;
) x
) y
where
y.len&lt;=3900
group by
y.application_column_name</COMMENTS>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>43</COLUMN_NUMBER>
    <COLUMN_NAME>RECEIPT_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;201,
p_descriptive_flexfield_name=&gt;&apos;RCV_SHIPMENT_HEADERS&apos;,
p_context_name=&gt;:$column$.receipt_attribute_category,
p_column_name=&gt;&apos;ATTRIBUTE8&apos;,
p_attribute1=&gt;:$column$.receipt_attribute1,
p_attribute2=&gt;:$column$.receipt_attribute2,
p_attribute3=&gt;:$column$.receipt_attribute3,
p_attribute4=&gt;:$column$.receipt_attribute4,
p_attribute5=&gt;:$column$.receipt_attribute5,
p_attribute6=&gt;:$column$.receipt_attribute6,
p_attribute7=&gt;:$column$.receipt_attribute7,
p_attribute8=&gt;:$column$.receipt_attribute8,
p_attribute9=&gt;:$column$.receipt_attribute9,
p_attribute10=&gt;:$column$.receipt_attribute10,
p_attribute11=&gt;:$column$.receipt_attribute11,
p_attribute12=&gt;:$column$.receipt_attribute12,
p_attribute13=&gt;:$column$.receipt_attribute13,
p_attribute14=&gt;:$column$.receipt_attribute14,
p_attribute15=&gt;:$column$.receipt_attribute15
)) lov
order by
value</LOV_QUERY_DSP>
    <COMMENTS>select
&apos;(Context) &apos;||initcap(y.application_column_name)||&apos;: &apos;||listagg(y.entry,&apos;, &apos;) within group (order by y.sort_key) comments
from
(
select
x.application_column_name,
x.entry,
x.sort_key,
sum(lengthb(x.entry)+2) over (order by x.sort_key) len
from
(
select
fdfcu.application_column_name,
decode(fdfc.descriptive_flex_context_code,&apos;Global Data Elements&apos;,&apos;(Global)&apos;,&apos;(&apos;||fdfc.descriptive_flex_context_code||&apos;)&apos;)||&apos; &apos;||fdfcu.form_left_prompt entry,
decode(fdfc.descriptive_flex_context_code,&apos;Global Data Elements&apos;,&apos;1&apos;,&apos;2&apos;||fdfc.descriptive_flex_context_code) sort_key
from
fnd_descr_flex_contexts fdfc,
fnd_descr_flex_col_usage_vl fdfcu
where
fdfc.application_id=201 and
fdfc.descriptive_flexfield_name=&apos;RCV_SHIPMENT_HEADERS&apos; and
fdfc.enabled_flag=&apos;Y&apos; and
fdfc.application_id=fdfcu.application_id and
fdfc.descriptive_flexfield_name=fdfcu.descriptive_flexfield_name and
fdfc.descriptive_flex_context_code=fdfcu.descriptive_flex_context_code and
fdfcu.enabled_flag=&apos;Y&apos; and
fdfcu.application_column_name=&apos;ATTRIBUTE8&apos;
) x
) y
where
y.len&lt;=3900
group by
y.application_column_name</COMMENTS>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>44</COLUMN_NUMBER>
    <COLUMN_NAME>RECEIPT_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;201,
p_descriptive_flexfield_name=&gt;&apos;RCV_SHIPMENT_HEADERS&apos;,
p_context_name=&gt;:$column$.receipt_attribute_category,
p_column_name=&gt;&apos;ATTRIBUTE9&apos;,
p_attribute1=&gt;:$column$.receipt_attribute1,
p_attribute2=&gt;:$column$.receipt_attribute2,
p_attribute3=&gt;:$column$.receipt_attribute3,
p_attribute4=&gt;:$column$.receipt_attribute4,
p_attribute5=&gt;:$column$.receipt_attribute5,
p_attribute6=&gt;:$column$.receipt_attribute6,
p_attribute7=&gt;:$column$.receipt_attribute7,
p_attribute8=&gt;:$column$.receipt_attribute8,
p_attribute9=&gt;:$column$.receipt_attribute9,
p_attribute10=&gt;:$column$.receipt_attribute10,
p_attribute11=&gt;:$column$.receipt_attribute11,
p_attribute12=&gt;:$column$.receipt_attribute12,
p_attribute13=&gt;:$column$.receipt_attribute13,
p_attribute14=&gt;:$column$.receipt_attribute14,
p_attribute15=&gt;:$column$.receipt_attribute15
)) lov
order by
value</LOV_QUERY_DSP>
    <COMMENTS>select
&apos;(Context) &apos;||initcap(y.application_column_name)||&apos;: &apos;||listagg(y.entry,&apos;, &apos;) within group (order by y.sort_key) comments
from
(
select
x.application_column_name,
x.entry,
x.sort_key,
sum(lengthb(x.entry)+2) over (order by x.sort_key) len
from
(
select
fdfcu.application_column_name,
decode(fdfc.descriptive_flex_context_code,&apos;Global Data Elements&apos;,&apos;(Global)&apos;,&apos;(&apos;||fdfc.descriptive_flex_context_code||&apos;)&apos;)||&apos; &apos;||fdfcu.form_left_prompt entry,
decode(fdfc.descriptive_flex_context_code,&apos;Global Data Elements&apos;,&apos;1&apos;,&apos;2&apos;||fdfc.descriptive_flex_context_code) sort_key
from
fnd_descr_flex_contexts fdfc,
fnd_descr_flex_col_usage_vl fdfcu
where
fdfc.application_id=201 and
fdfc.descriptive_flexfield_name=&apos;RCV_SHIPMENT_HEADERS&apos; and
fdfc.enabled_flag=&apos;Y&apos; and
fdfc.application_id=fdfcu.application_id and
fdfc.descriptive_flexfield_name=fdfcu.descriptive_flexfield_name and
fdfc.descriptive_flex_context_code=fdfcu.descriptive_flex_context_code and
fdfcu.enabled_flag=&apos;Y&apos; and
fdfcu.application_column_name=&apos;ATTRIBUTE9&apos;
) x
) y
where
y.len&lt;=3900
group by
y.application_column_name</COMMENTS>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>45</COLUMN_NUMBER>
    <COLUMN_NAME>RECEIPT_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;201,
p_descriptive_flexfield_name=&gt;&apos;RCV_SHIPMENT_HEADERS&apos;,
p_context_name=&gt;:$column$.receipt_attribute_category,
p_column_name=&gt;&apos;ATTRIBUTE10&apos;,
p_attribute1=&gt;:$column$.receipt_attribute1,
p_attribute2=&gt;:$column$.receipt_attribute2,
p_attribute3=&gt;:$column$.receipt_attribute3,
p_attribute4=&gt;:$column$.receipt_attribute4,
p_attribute5=&gt;:$column$.receipt_attribute5,
p_attribute6=&gt;:$column$.receipt_attribute6,
p_attribute7=&gt;:$column$.receipt_attribute7,
p_attribute8=&gt;:$column$.receipt_attribute8,
p_attribute9=&gt;:$column$.receipt_attribute9,
p_attribute10=&gt;:$column$.receipt_attribute10,
p_attribute11=&gt;:$column$.receipt_attribute11,
p_attribute12=&gt;:$column$.receipt_attribute12,
p_attribute13=&gt;:$column$.receipt_attribute13,
p_attribute14=&gt;:$column$.receipt_attribute14,
p_attribute15=&gt;:$column$.receipt_attribute15
)) lov
order by
value</LOV_QUERY_DSP>
    <COMMENTS>select
&apos;(Context) &apos;||initcap(y.application_column_name)||&apos;: &apos;||listagg(y.entry,&apos;, &apos;) within group (order by y.sort_key) comments
from
(
select
x.application_column_name,
x.entry,
x.sort_key,
sum(lengthb(x.entry)+2) over (order by x.sort_key) len
from
(
select
fdfcu.application_column_name,
decode(fdfc.descriptive_flex_context_code,&apos;Global Data Elements&apos;,&apos;(Global)&apos;,&apos;(&apos;||fdfc.descriptive_flex_context_code||&apos;)&apos;)||&apos; &apos;||fdfcu.form_left_prompt entry,
decode(fdfc.descriptive_flex_context_code,&apos;Global Data Elements&apos;,&apos;1&apos;,&apos;2&apos;||fdfc.descriptive_flex_context_code) sort_key
from
fnd_descr_flex_contexts fdfc,
fnd_descr_flex_col_usage_vl fdfcu
where
fdfc.application_id=201 and
fdfc.descriptive_flexfield_name=&apos;RCV_SHIPMENT_HEADERS&apos; and
fdfc.enabled_flag=&apos;Y&apos; and
fdfc.application_id=fdfcu.application_id and
fdfc.descriptive_flexfield_name=fdfcu.descriptive_flexfield_name and
fdfc.descriptive_flex_context_code=fdfcu.descriptive_flex_context_code and
fdfcu.enabled_flag=&apos;Y&apos; and
fdfcu.application_column_name=&apos;ATTRIBUTE10&apos;
) x
) y
where
y.len&lt;=3900
group by
y.application_column_name</COMMENTS>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>46</COLUMN_NUMBER>
    <COLUMN_NAME>RECEIPT_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;201,
p_descriptive_flexfield_name=&gt;&apos;RCV_SHIPMENT_HEADERS&apos;,
p_context_name=&gt;:$column$.receipt_attribute_category,
p_column_name=&gt;&apos;ATTRIBUTE11&apos;,
p_attribute1=&gt;:$column$.receipt_attribute1,
p_attribute2=&gt;:$column$.receipt_attribute2,
p_attribute3=&gt;:$column$.receipt_attribute3,
p_attribute4=&gt;:$column$.receipt_attribute4,
p_attribute5=&gt;:$column$.receipt_attribute5,
p_attribute6=&gt;:$column$.receipt_attribute6,
p_attribute7=&gt;:$column$.receipt_attribute7,
p_attribute8=&gt;:$column$.receipt_attribute8,
p_attribute9=&gt;:$column$.receipt_attribute9,
p_attribute10=&gt;:$column$.receipt_attribute10,
p_attribute11=&gt;:$column$.receipt_attribute11,
p_attribute12=&gt;:$column$.receipt_attribute12,
p_attribute13=&gt;:$column$.receipt_attribute13,
p_attribute14=&gt;:$column$.receipt_attribute14,
p_attribute15=&gt;:$column$.receipt_attribute15
)) lov
order by
value</LOV_QUERY_DSP>
    <COMMENTS>select
&apos;(Context) &apos;||initcap(y.application_column_name)||&apos;: &apos;||listagg(y.entry,&apos;, &apos;) within group (order by y.sort_key) comments
from
(
select
x.application_column_name,
x.entry,
x.sort_key,
sum(lengthb(x.entry)+2) over (order by x.sort_key) len
from
(
select
fdfcu.application_column_name,
decode(fdfc.descriptive_flex_context_code,&apos;Global Data Elements&apos;,&apos;(Global)&apos;,&apos;(&apos;||fdfc.descriptive_flex_context_code||&apos;)&apos;)||&apos; &apos;||fdfcu.form_left_prompt entry,
decode(fdfc.descriptive_flex_context_code,&apos;Global Data Elements&apos;,&apos;1&apos;,&apos;2&apos;||fdfc.descriptive_flex_context_code) sort_key
from
fnd_descr_flex_contexts fdfc,
fnd_descr_flex_col_usage_vl fdfcu
where
fdfc.application_id=201 and
fdfc.descriptive_flexfield_name=&apos;RCV_SHIPMENT_HEADERS&apos; and
fdfc.enabled_flag=&apos;Y&apos; and
fdfc.application_id=fdfcu.application_id and
fdfc.descriptive_flexfield_name=fdfcu.descriptive_flexfield_name and
fdfc.descriptive_flex_context_code=fdfcu.descriptive_flex_context_code and
fdfcu.enabled_flag=&apos;Y&apos; and
fdfcu.application_column_name=&apos;ATTRIBUTE11&apos;
) x
) y
where
y.len&lt;=3900
group by
y.application_column_name</COMMENTS>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>47</COLUMN_NUMBER>
    <COLUMN_NAME>RECEIPT_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;201,
p_descriptive_flexfield_name=&gt;&apos;RCV_SHIPMENT_HEADERS&apos;,
p_context_name=&gt;:$column$.receipt_attribute_category,
p_column_name=&gt;&apos;ATTRIBUTE12&apos;,
p_attribute1=&gt;:$column$.receipt_attribute1,
p_attribute2=&gt;:$column$.receipt_attribute2,
p_attribute3=&gt;:$column$.receipt_attribute3,
p_attribute4=&gt;:$column$.receipt_attribute4,
p_attribute5=&gt;:$column$.receipt_attribute5,
p_attribute6=&gt;:$column$.receipt_attribute6,
p_attribute7=&gt;:$column$.receipt_attribute7,
p_attribute8=&gt;:$column$.receipt_attribute8,
p_attribute9=&gt;:$column$.receipt_attribute9,
p_attribute10=&gt;:$column$.receipt_attribute10,
p_attribute11=&gt;:$column$.receipt_attribute11,
p_attribute12=&gt;:$column$.receipt_attribute12,
p_attribute13=&gt;:$column$.receipt_attribute13,
p_attribute14=&gt;:$column$.receipt_attribute14,
p_attribute15=&gt;:$column$.receipt_attribute15
)) lov
order by
value</LOV_QUERY_DSP>
    <COMMENTS>select
&apos;(Context) &apos;||initcap(y.application_column_name)||&apos;: &apos;||listagg(y.entry,&apos;, &apos;) within group (order by y.sort_key) comments
from
(
select
x.application_column_name,
x.entry,
x.sort_key,
sum(lengthb(x.entry)+2) over (order by x.sort_key) len
from
(
select
fdfcu.application_column_name,
decode(fdfc.descriptive_flex_context_code,&apos;Global Data Elements&apos;,&apos;(Global)&apos;,&apos;(&apos;||fdfc.descriptive_flex_context_code||&apos;)&apos;)||&apos; &apos;||fdfcu.form_left_prompt entry,
decode(fdfc.descriptive_flex_context_code,&apos;Global Data Elements&apos;,&apos;1&apos;,&apos;2&apos;||fdfc.descriptive_flex_context_code) sort_key
from
fnd_descr_flex_contexts fdfc,
fnd_descr_flex_col_usage_vl fdfcu
where
fdfc.application_id=201 and
fdfc.descriptive_flexfield_name=&apos;RCV_SHIPMENT_HEADERS&apos; and
fdfc.enabled_flag=&apos;Y&apos; and
fdfc.application_id=fdfcu.application_id and
fdfc.descriptive_flexfield_name=fdfcu.descriptive_flexfield_name and
fdfc.descriptive_flex_context_code=fdfcu.descriptive_flex_context_code and
fdfcu.enabled_flag=&apos;Y&apos; and
fdfcu.application_column_name=&apos;ATTRIBUTE12&apos;
) x
) y
where
y.len&lt;=3900
group by
y.application_column_name</COMMENTS>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>48</COLUMN_NUMBER>
    <COLUMN_NAME>RECEIPT_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;201,
p_descriptive_flexfield_name=&gt;&apos;RCV_SHIPMENT_HEADERS&apos;,
p_context_name=&gt;:$column$.receipt_attribute_category,
p_column_name=&gt;&apos;ATTRIBUTE13&apos;,
p_attribute1=&gt;:$column$.receipt_attribute1,
p_attribute2=&gt;:$column$.receipt_attribute2,
p_attribute3=&gt;:$column$.receipt_attribute3,
p_attribute4=&gt;:$column$.receipt_attribute4,
p_attribute5=&gt;:$column$.receipt_attribute5,
p_attribute6=&gt;:$column$.receipt_attribute6,
p_attribute7=&gt;:$column$.receipt_attribute7,
p_attribute8=&gt;:$column$.receipt_attribute8,
p_attribute9=&gt;:$column$.receipt_attribute9,
p_attribute10=&gt;:$column$.receipt_attribute10,
p_attribute11=&gt;:$column$.receipt_attribute11,
p_attribute12=&gt;:$column$.receipt_attribute12,
p_attribute13=&gt;:$column$.receipt_attribute13,
p_attribute14=&gt;:$column$.receipt_attribute14,
p_attribute15=&gt;:$column$.receipt_attribute15
)) lov
order by
value</LOV_QUERY_DSP>
    <COMMENTS>select
&apos;(Context) &apos;||initcap(y.application_column_name)||&apos;: &apos;||listagg(y.entry,&apos;, &apos;) within group (order by y.sort_key) comments
from
(
select
x.application_column_name,
x.entry,
x.sort_key,
sum(lengthb(x.entry)+2) over (order by x.sort_key) len
from
(
select
fdfcu.application_column_name,
decode(fdfc.descriptive_flex_context_code,&apos;Global Data Elements&apos;,&apos;(Global)&apos;,&apos;(&apos;||fdfc.descriptive_flex_context_code||&apos;)&apos;)||&apos; &apos;||fdfcu.form_left_prompt entry,
decode(fdfc.descriptive_flex_context_code,&apos;Global Data Elements&apos;,&apos;1&apos;,&apos;2&apos;||fdfc.descriptive_flex_context_code) sort_key
from
fnd_descr_flex_contexts fdfc,
fnd_descr_flex_col_usage_vl fdfcu
where
fdfc.application_id=201 and
fdfc.descriptive_flexfield_name=&apos;RCV_SHIPMENT_HEADERS&apos; and
fdfc.enabled_flag=&apos;Y&apos; and
fdfc.application_id=fdfcu.application_id and
fdfc.descriptive_flexfield_name=fdfcu.descriptive_flexfield_name and
fdfc.descriptive_flex_context_code=fdfcu.descriptive_flex_context_code and
fdfcu.enabled_flag=&apos;Y&apos; and
fdfcu.application_column_name=&apos;ATTRIBUTE13&apos;
) x
) y
where
y.len&lt;=3900
group by
y.application_column_name</COMMENTS>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>49</COLUMN_NUMBER>
    <COLUMN_NAME>RECEIPT_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;201,
p_descriptive_flexfield_name=&gt;&apos;RCV_SHIPMENT_HEADERS&apos;,
p_context_name=&gt;:$column$.receipt_attribute_category,
p_column_name=&gt;&apos;ATTRIBUTE14&apos;,
p_attribute1=&gt;:$column$.receipt_attribute1,
p_attribute2=&gt;:$column$.receipt_attribute2,
p_attribute3=&gt;:$column$.receipt_attribute3,
p_attribute4=&gt;:$column$.receipt_attribute4,
p_attribute5=&gt;:$column$.receipt_attribute5,
p_attribute6=&gt;:$column$.receipt_attribute6,
p_attribute7=&gt;:$column$.receipt_attribute7,
p_attribute8=&gt;:$column$.receipt_attribute8,
p_attribute9=&gt;:$column$.receipt_attribute9,
p_attribute10=&gt;:$column$.receipt_attribute10,
p_attribute11=&gt;:$column$.receipt_attribute11,
p_attribute12=&gt;:$column$.receipt_attribute12,
p_attribute13=&gt;:$column$.receipt_attribute13,
p_attribute14=&gt;:$column$.receipt_attribute14,
p_attribute15=&gt;:$column$.receipt_attribute15
)) lov
order by
value</LOV_QUERY_DSP>
    <COMMENTS>select
&apos;(Context) &apos;||initcap(y.application_column_name)||&apos;: &apos;||listagg(y.entry,&apos;, &apos;) within group (order by y.sort_key) comments
from
(
select
x.application_column_name,
x.entry,
x.sort_key,
sum(lengthb(x.entry)+2) over (order by x.sort_key) len
from
(
select
fdfcu.application_column_name,
decode(fdfc.descriptive_flex_context_code,&apos;Global Data Elements&apos;,&apos;(Global)&apos;,&apos;(&apos;||fdfc.descriptive_flex_context_code||&apos;)&apos;)||&apos; &apos;||fdfcu.form_left_prompt entry,
decode(fdfc.descriptive_flex_context_code,&apos;Global Data Elements&apos;,&apos;1&apos;,&apos;2&apos;||fdfc.descriptive_flex_context_code) sort_key
from
fnd_descr_flex_contexts fdfc,
fnd_descr_flex_col_usage_vl fdfcu
where
fdfc.application_id=201 and
fdfc.descriptive_flexfield_name=&apos;RCV_SHIPMENT_HEADERS&apos; and
fdfc.enabled_flag=&apos;Y&apos; and
fdfc.application_id=fdfcu.application_id and
fdfc.descriptive_flexfield_name=fdfcu.descriptive_flexfield_name and
fdfc.descriptive_flex_context_code=fdfcu.descriptive_flex_context_code and
fdfcu.enabled_flag=&apos;Y&apos; and
fdfcu.application_column_name=&apos;ATTRIBUTE14&apos;
) x
) y
where
y.len&lt;=3900
group by
y.application_column_name</COMMENTS>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>50</COLUMN_NUMBER>
    <COLUMN_NAME>RECEIPT_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;201,
p_descriptive_flexfield_name=&gt;&apos;RCV_SHIPMENT_HEADERS&apos;,
p_context_name=&gt;:$column$.receipt_attribute_category,
p_column_name=&gt;&apos;ATTRIBUTE15&apos;,
p_attribute1=&gt;:$column$.receipt_attribute1,
p_attribute2=&gt;:$column$.receipt_attribute2,
p_attribute3=&gt;:$column$.receipt_attribute3,
p_attribute4=&gt;:$column$.receipt_attribute4,
p_attribute5=&gt;:$column$.receipt_attribute5,
p_attribute6=&gt;:$column$.receipt_attribute6,
p_attribute7=&gt;:$column$.receipt_attribute7,
p_attribute8=&gt;:$column$.receipt_attribute8,
p_attribute9=&gt;:$column$.receipt_attribute9,
p_attribute10=&gt;:$column$.receipt_attribute10,
p_attribute11=&gt;:$column$.receipt_attribute11,
p_attribute12=&gt;:$column$.receipt_attribute12,
p_attribute13=&gt;:$column$.receipt_attribute13,
p_attribute14=&gt;:$column$.receipt_attribute14,
p_attribute15=&gt;:$column$.receipt_attribute15
)) lov
order by
value</LOV_QUERY_DSP>
    <COMMENTS>select
&apos;(Context) &apos;||initcap(y.application_column_name)||&apos;: &apos;||listagg(y.entry,&apos;, &apos;) within group (order by y.sort_key) comments
from
(
select
x.application_column_name,
x.entry,
x.sort_key,
sum(lengthb(x.entry)+2) over (order by x.sort_key) len
from
(
select
fdfcu.application_column_name,
decode(fdfc.descriptive_flex_context_code,&apos;Global Data Elements&apos;,&apos;(Global)&apos;,&apos;(&apos;||fdfc.descriptive_flex_context_code||&apos;)&apos;)||&apos; &apos;||fdfcu.form_left_prompt entry,
decode(fdfc.descriptive_flex_context_code,&apos;Global Data Elements&apos;,&apos;1&apos;,&apos;2&apos;||fdfc.descriptive_flex_context_code) sort_key
from
fnd_descr_flex_contexts fdfc,
fnd_descr_flex_col_usage_vl fdfcu
where
fdfc.application_id=201 and
fdfc.descriptive_flexfield_name=&apos;RCV_SHIPMENT_HEADERS&apos; and
fdfc.enabled_flag=&apos;Y&apos; and
fdfc.application_id=fdfcu.application_id and
fdfc.descriptive_flexfield_name=fdfcu.descriptive_flexfield_name and
fdfc.descriptive_flex_context_code=fdfcu.descriptive_flex_context_code and
fdfcu.enabled_flag=&apos;Y&apos; and
fdfcu.application_column_name=&apos;ATTRIBUTE15&apos;
) x
) y
where
y.len&lt;=3900
group by
y.application_column_name</COMMENTS>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>51</COLUMN_NUMBER>
    <COLUMN_NAME>LINE_ATTRIBUTE_CATEGORY</COLUMN_NAME>
    <COLUMN_TYPE_DSP>LOV custom</COLUMN_TYPE_DSP>
    <DATA_TYPE>varchar2</DATA_TYPE>
    <LOV_QUERY_DSP>select
fdfcv.descriptive_flex_context_name value,
fdfcv.description
from
fnd_descr_flex_contexts_vl fdfcv
where
fdfcv.application_id=201 and
fdfcv.descriptive_flexfield_name=&apos;RCV_TRANSACTIONS&apos; and
fdfcv.enabled_flag=&apos;Y&apos; and
fdfcv.global_flag=&apos;N&apos;
order by
fdfcv.descriptive_flex_context_name</LOV_QUERY_DSP>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>52</COLUMN_NUMBER>
    <COLUMN_NAME>LINE_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;201,
p_descriptive_flexfield_name=&gt;&apos;RCV_TRANSACTIONS&apos;,
p_context_name=&gt;:$column$.line_attribute_category,
p_column_name=&gt;&apos;ATTRIBUTE1&apos;,
p_attribute1=&gt;:$column$.line_attribute1,
p_attribute2=&gt;:$column$.line_attribute2,
p_attribute3=&gt;:$column$.line_attribute3,
p_attribute4=&gt;:$column$.line_attribute4,
p_attribute5=&gt;:$column$.line_attribute5,
p_attribute6=&gt;:$column$.line_attribute6,
p_attribute7=&gt;:$column$.line_attribute7,
p_attribute8=&gt;:$column$.line_attribute8,
p_attribute9=&gt;:$column$.line_attribute9,
p_attribute10=&gt;:$column$.line_attribute10,
p_attribute11=&gt;:$column$.line_attribute11,
p_attribute12=&gt;:$column$.line_attribute12,
p_attribute13=&gt;:$column$.line_attribute13,
p_attribute14=&gt;:$column$.line_attribute14,
p_attribute15=&gt;:$column$.line_attribute15
)) lov
order by
value</LOV_QUERY_DSP>
    <COMMENTS>select
&apos;(Context) &apos;||initcap(y.application_column_name)||&apos;: &apos;||listagg(y.entry,&apos;, &apos;) within group (order by y.sort_key) comments
from
(
select
x.application_column_name,
x.entry,
x.sort_key,
sum(lengthb(x.entry)+2) over (order by x.sort_key) len
from
(
select
fdfcu.application_column_name,
decode(fdfc.descriptive_flex_context_code,&apos;Global Data Elements&apos;,&apos;(Global)&apos;,&apos;(&apos;||fdfc.descriptive_flex_context_code||&apos;)&apos;)||&apos; &apos;||fdfcu.form_left_prompt entry,
decode(fdfc.descriptive_flex_context_code,&apos;Global Data Elements&apos;,&apos;1&apos;,&apos;2&apos;||fdfc.descriptive_flex_context_code) sort_key
from
fnd_descr_flex_contexts fdfc,
fnd_descr_flex_col_usage_vl fdfcu
where
fdfc.application_id=201 and
fdfc.descriptive_flexfield_name=&apos;RCV_TRANSACTIONS&apos; and
fdfc.enabled_flag=&apos;Y&apos; and
fdfc.application_id=fdfcu.application_id and
fdfc.descriptive_flexfield_name=fdfcu.descriptive_flexfield_name and
fdfc.descriptive_flex_context_code=fdfcu.descriptive_flex_context_code and
fdfcu.enabled_flag=&apos;Y&apos; and
fdfcu.application_column_name=&apos;ATTRIBUTE1&apos;
) x
) y
where
y.len&lt;=3900
group by
y.application_column_name</COMMENTS>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>53</COLUMN_NUMBER>
    <COLUMN_NAME>LINE_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;201,
p_descriptive_flexfield_name=&gt;&apos;RCV_TRANSACTIONS&apos;,
p_context_name=&gt;:$column$.line_attribute_category,
p_column_name=&gt;&apos;ATTRIBUTE2&apos;,
p_attribute1=&gt;:$column$.line_attribute1,
p_attribute2=&gt;:$column$.line_attribute2,
p_attribute3=&gt;:$column$.line_attribute3,
p_attribute4=&gt;:$column$.line_attribute4,
p_attribute5=&gt;:$column$.line_attribute5,
p_attribute6=&gt;:$column$.line_attribute6,
p_attribute7=&gt;:$column$.line_attribute7,
p_attribute8=&gt;:$column$.line_attribute8,
p_attribute9=&gt;:$column$.line_attribute9,
p_attribute10=&gt;:$column$.line_attribute10,
p_attribute11=&gt;:$column$.line_attribute11,
p_attribute12=&gt;:$column$.line_attribute12,
p_attribute13=&gt;:$column$.line_attribute13,
p_attribute14=&gt;:$column$.line_attribute14,
p_attribute15=&gt;:$column$.line_attribute15
)) lov
order by
value</LOV_QUERY_DSP>
    <COMMENTS>select
&apos;(Context) &apos;||initcap(y.application_column_name)||&apos;: &apos;||listagg(y.entry,&apos;, &apos;) within group (order by y.sort_key) comments
from
(
select
x.application_column_name,
x.entry,
x.sort_key,
sum(lengthb(x.entry)+2) over (order by x.sort_key) len
from
(
select
fdfcu.application_column_name,
decode(fdfc.descriptive_flex_context_code,&apos;Global Data Elements&apos;,&apos;(Global)&apos;,&apos;(&apos;||fdfc.descriptive_flex_context_code||&apos;)&apos;)||&apos; &apos;||fdfcu.form_left_prompt entry,
decode(fdfc.descriptive_flex_context_code,&apos;Global Data Elements&apos;,&apos;1&apos;,&apos;2&apos;||fdfc.descriptive_flex_context_code) sort_key
from
fnd_descr_flex_contexts fdfc,
fnd_descr_flex_col_usage_vl fdfcu
where
fdfc.application_id=201 and
fdfc.descriptive_flexfield_name=&apos;RCV_TRANSACTIONS&apos; and
fdfc.enabled_flag=&apos;Y&apos; and
fdfc.application_id=fdfcu.application_id and
fdfc.descriptive_flexfield_name=fdfcu.descriptive_flexfield_name and
fdfc.descriptive_flex_context_code=fdfcu.descriptive_flex_context_code and
fdfcu.enabled_flag=&apos;Y&apos; and
fdfcu.application_column_name=&apos;ATTRIBUTE2&apos;
) x
) y
where
y.len&lt;=3900
group by
y.application_column_name</COMMENTS>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>54</COLUMN_NUMBER>
    <COLUMN_NAME>LINE_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;201,
p_descriptive_flexfield_name=&gt;&apos;RCV_TRANSACTIONS&apos;,
p_context_name=&gt;:$column$.line_attribute_category,
p_column_name=&gt;&apos;ATTRIBUTE3&apos;,
p_attribute1=&gt;:$column$.line_attribute1,
p_attribute2=&gt;:$column$.line_attribute2,
p_attribute3=&gt;:$column$.line_attribute3,
p_attribute4=&gt;:$column$.line_attribute4,
p_attribute5=&gt;:$column$.line_attribute5,
p_attribute6=&gt;:$column$.line_attribute6,
p_attribute7=&gt;:$column$.line_attribute7,
p_attribute8=&gt;:$column$.line_attribute8,
p_attribute9=&gt;:$column$.line_attribute9,
p_attribute10=&gt;:$column$.line_attribute10,
p_attribute11=&gt;:$column$.line_attribute11,
p_attribute12=&gt;:$column$.line_attribute12,
p_attribute13=&gt;:$column$.line_attribute13,
p_attribute14=&gt;:$column$.line_attribute14,
p_attribute15=&gt;:$column$.line_attribute15
)) lov
order by
value</LOV_QUERY_DSP>
    <COMMENTS>select
&apos;(Context) &apos;||initcap(y.application_column_name)||&apos;: &apos;||listagg(y.entry,&apos;, &apos;) within group (order by y.sort_key) comments
from
(
select
x.application_column_name,
x.entry,
x.sort_key,
sum(lengthb(x.entry)+2) over (order by x.sort_key) len
from
(
select
fdfcu.application_column_name,
decode(fdfc.descriptive_flex_context_code,&apos;Global Data Elements&apos;,&apos;(Global)&apos;,&apos;(&apos;||fdfc.descriptive_flex_context_code||&apos;)&apos;)||&apos; &apos;||fdfcu.form_left_prompt entry,
decode(fdfc.descriptive_flex_context_code,&apos;Global Data Elements&apos;,&apos;1&apos;,&apos;2&apos;||fdfc.descriptive_flex_context_code) sort_key
from
fnd_descr_flex_contexts fdfc,
fnd_descr_flex_col_usage_vl fdfcu
where
fdfc.application_id=201 and
fdfc.descriptive_flexfield_name=&apos;RCV_TRANSACTIONS&apos; and
fdfc.enabled_flag=&apos;Y&apos; and
fdfc.application_id=fdfcu.application_id and
fdfc.descriptive_flexfield_name=fdfcu.descriptive_flexfield_name and
fdfc.descriptive_flex_context_code=fdfcu.descriptive_flex_context_code and
fdfcu.enabled_flag=&apos;Y&apos; and
fdfcu.application_column_name=&apos;ATTRIBUTE3&apos;
) x
) y
where
y.len&lt;=3900
group by
y.application_column_name</COMMENTS>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>55</COLUMN_NUMBER>
    <COLUMN_NAME>LINE_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;201,
p_descriptive_flexfield_name=&gt;&apos;RCV_TRANSACTIONS&apos;,
p_context_name=&gt;:$column$.line_attribute_category,
p_column_name=&gt;&apos;ATTRIBUTE4&apos;,
p_attribute1=&gt;:$column$.line_attribute1,
p_attribute2=&gt;:$column$.line_attribute2,
p_attribute3=&gt;:$column$.line_attribute3,
p_attribute4=&gt;:$column$.line_attribute4,
p_attribute5=&gt;:$column$.line_attribute5,
p_attribute6=&gt;:$column$.line_attribute6,
p_attribute7=&gt;:$column$.line_attribute7,
p_attribute8=&gt;:$column$.line_attribute8,
p_attribute9=&gt;:$column$.line_attribute9,
p_attribute10=&gt;:$column$.line_attribute10,
p_attribute11=&gt;:$column$.line_attribute11,
p_attribute12=&gt;:$column$.line_attribute12,
p_attribute13=&gt;:$column$.line_attribute13,
p_attribute14=&gt;:$column$.line_attribute14,
p_attribute15=&gt;:$column$.line_attribute15
)) lov
order by
value</LOV_QUERY_DSP>
    <COMMENTS>select
&apos;(Context) &apos;||initcap(y.application_column_name)||&apos;: &apos;||listagg(y.entry,&apos;, &apos;) within group (order by y.sort_key) comments
from
(
select
x.application_column_name,
x.entry,
x.sort_key,
sum(lengthb(x.entry)+2) over (order by x.sort_key) len
from
(
select
fdfcu.application_column_name,
decode(fdfc.descriptive_flex_context_code,&apos;Global Data Elements&apos;,&apos;(Global)&apos;,&apos;(&apos;||fdfc.descriptive_flex_context_code||&apos;)&apos;)||&apos; &apos;||fdfcu.form_left_prompt entry,
decode(fdfc.descriptive_flex_context_code,&apos;Global Data Elements&apos;,&apos;1&apos;,&apos;2&apos;||fdfc.descriptive_flex_context_code) sort_key
from
fnd_descr_flex_contexts fdfc,
fnd_descr_flex_col_usage_vl fdfcu
where
fdfc.application_id=201 and
fdfc.descriptive_flexfield_name=&apos;RCV_TRANSACTIONS&apos; and
fdfc.enabled_flag=&apos;Y&apos; and
fdfc.application_id=fdfcu.application_id and
fdfc.descriptive_flexfield_name=fdfcu.descriptive_flexfield_name and
fdfc.descriptive_flex_context_code=fdfcu.descriptive_flex_context_code and
fdfcu.enabled_flag=&apos;Y&apos; and
fdfcu.application_column_name=&apos;ATTRIBUTE4&apos;
) x
) y
where
y.len&lt;=3900
group by
y.application_column_name</COMMENTS>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>56</COLUMN_NUMBER>
    <COLUMN_NAME>LINE_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;201,
p_descriptive_flexfield_name=&gt;&apos;RCV_TRANSACTIONS&apos;,
p_context_name=&gt;:$column$.line_attribute_category,
p_column_name=&gt;&apos;ATTRIBUTE5&apos;,
p_attribute1=&gt;:$column$.line_attribute1,
p_attribute2=&gt;:$column$.line_attribute2,
p_attribute3=&gt;:$column$.line_attribute3,
p_attribute4=&gt;:$column$.line_attribute4,
p_attribute5=&gt;:$column$.line_attribute5,
p_attribute6=&gt;:$column$.line_attribute6,
p_attribute7=&gt;:$column$.line_attribute7,
p_attribute8=&gt;:$column$.line_attribute8,
p_attribute9=&gt;:$column$.line_attribute9,
p_attribute10=&gt;:$column$.line_attribute10,
p_attribute11=&gt;:$column$.line_attribute11,
p_attribute12=&gt;:$column$.line_attribute12,
p_attribute13=&gt;:$column$.line_attribute13,
p_attribute14=&gt;:$column$.line_attribute14,
p_attribute15=&gt;:$column$.line_attribute15
)) lov
order by
value</LOV_QUERY_DSP>
    <COMMENTS>select
&apos;(Context) &apos;||initcap(y.application_column_name)||&apos;: &apos;||listagg(y.entry,&apos;, &apos;) within group (order by y.sort_key) comments
from
(
select
x.application_column_name,
x.entry,
x.sort_key,
sum(lengthb(x.entry)+2) over (order by x.sort_key) len
from
(
select
fdfcu.application_column_name,
decode(fdfc.descriptive_flex_context_code,&apos;Global Data Elements&apos;,&apos;(Global)&apos;,&apos;(&apos;||fdfc.descriptive_flex_context_code||&apos;)&apos;)||&apos; &apos;||fdfcu.form_left_prompt entry,
decode(fdfc.descriptive_flex_context_code,&apos;Global Data Elements&apos;,&apos;1&apos;,&apos;2&apos;||fdfc.descriptive_flex_context_code) sort_key
from
fnd_descr_flex_contexts fdfc,
fnd_descr_flex_col_usage_vl fdfcu
where
fdfc.application_id=201 and
fdfc.descriptive_flexfield_name=&apos;RCV_TRANSACTIONS&apos; and
fdfc.enabled_flag=&apos;Y&apos; and
fdfc.application_id=fdfcu.application_id and
fdfc.descriptive_flexfield_name=fdfcu.descriptive_flexfield_name and
fdfc.descriptive_flex_context_code=fdfcu.descriptive_flex_context_code and
fdfcu.enabled_flag=&apos;Y&apos; and
fdfcu.application_column_name=&apos;ATTRIBUTE5&apos;
) x
) y
where
y.len&lt;=3900
group by
y.application_column_name</COMMENTS>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>57</COLUMN_NUMBER>
    <COLUMN_NAME>LINE_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;201,
p_descriptive_flexfield_name=&gt;&apos;RCV_TRANSACTIONS&apos;,
p_context_name=&gt;:$column$.line_attribute_category,
p_column_name=&gt;&apos;ATTRIBUTE6&apos;,
p_attribute1=&gt;:$column$.line_attribute1,
p_attribute2=&gt;:$column$.line_attribute2,
p_attribute3=&gt;:$column$.line_attribute3,
p_attribute4=&gt;:$column$.line_attribute4,
p_attribute5=&gt;:$column$.line_attribute5,
p_attribute6=&gt;:$column$.line_attribute6,
p_attribute7=&gt;:$column$.line_attribute7,
p_attribute8=&gt;:$column$.line_attribute8,
p_attribute9=&gt;:$column$.line_attribute9,
p_attribute10=&gt;:$column$.line_attribute10,
p_attribute11=&gt;:$column$.line_attribute11,
p_attribute12=&gt;:$column$.line_attribute12,
p_attribute13=&gt;:$column$.line_attribute13,
p_attribute14=&gt;:$column$.line_attribute14,
p_attribute15=&gt;:$column$.line_attribute15
)) lov
order by
value</LOV_QUERY_DSP>
    <COMMENTS>select
&apos;(Context) &apos;||initcap(y.application_column_name)||&apos;: &apos;||listagg(y.entry,&apos;, &apos;) within group (order by y.sort_key) comments
from
(
select
x.application_column_name,
x.entry,
x.sort_key,
sum(lengthb(x.entry)+2) over (order by x.sort_key) len
from
(
select
fdfcu.application_column_name,
decode(fdfc.descriptive_flex_context_code,&apos;Global Data Elements&apos;,&apos;(Global)&apos;,&apos;(&apos;||fdfc.descriptive_flex_context_code||&apos;)&apos;)||&apos; &apos;||fdfcu.form_left_prompt entry,
decode(fdfc.descriptive_flex_context_code,&apos;Global Data Elements&apos;,&apos;1&apos;,&apos;2&apos;||fdfc.descriptive_flex_context_code) sort_key
from
fnd_descr_flex_contexts fdfc,
fnd_descr_flex_col_usage_vl fdfcu
where
fdfc.application_id=201 and
fdfc.descriptive_flexfield_name=&apos;RCV_TRANSACTIONS&apos; and
fdfc.enabled_flag=&apos;Y&apos; and
fdfc.application_id=fdfcu.application_id and
fdfc.descriptive_flexfield_name=fdfcu.descriptive_flexfield_name and
fdfc.descriptive_flex_context_code=fdfcu.descriptive_flex_context_code and
fdfcu.enabled_flag=&apos;Y&apos; and
fdfcu.application_column_name=&apos;ATTRIBUTE6&apos;
) x
) y
where
y.len&lt;=3900
group by
y.application_column_name</COMMENTS>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>58</COLUMN_NUMBER>
    <COLUMN_NAME>LINE_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;201,
p_descriptive_flexfield_name=&gt;&apos;RCV_TRANSACTIONS&apos;,
p_context_name=&gt;:$column$.line_attribute_category,
p_column_name=&gt;&apos;ATTRIBUTE7&apos;,
p_attribute1=&gt;:$column$.line_attribute1,
p_attribute2=&gt;:$column$.line_attribute2,
p_attribute3=&gt;:$column$.line_attribute3,
p_attribute4=&gt;:$column$.line_attribute4,
p_attribute5=&gt;:$column$.line_attribute5,
p_attribute6=&gt;:$column$.line_attribute6,
p_attribute7=&gt;:$column$.line_attribute7,
p_attribute8=&gt;:$column$.line_attribute8,
p_attribute9=&gt;:$column$.line_attribute9,
p_attribute10=&gt;:$column$.line_attribute10,
p_attribute11=&gt;:$column$.line_attribute11,
p_attribute12=&gt;:$column$.line_attribute12,
p_attribute13=&gt;:$column$.line_attribute13,
p_attribute14=&gt;:$column$.line_attribute14,
p_attribute15=&gt;:$column$.line_attribute15
)) lov
order by
value</LOV_QUERY_DSP>
    <COMMENTS>select
&apos;(Context) &apos;||initcap(y.application_column_name)||&apos;: &apos;||listagg(y.entry,&apos;, &apos;) within group (order by y.sort_key) comments
from
(
select
x.application_column_name,
x.entry,
x.sort_key,
sum(lengthb(x.entry)+2) over (order by x.sort_key) len
from
(
select
fdfcu.application_column_name,
decode(fdfc.descriptive_flex_context_code,&apos;Global Data Elements&apos;,&apos;(Global)&apos;,&apos;(&apos;||fdfc.descriptive_flex_context_code||&apos;)&apos;)||&apos; &apos;||fdfcu.form_left_prompt entry,
decode(fdfc.descriptive_flex_context_code,&apos;Global Data Elements&apos;,&apos;1&apos;,&apos;2&apos;||fdfc.descriptive_flex_context_code) sort_key
from
fnd_descr_flex_contexts fdfc,
fnd_descr_flex_col_usage_vl fdfcu
where
fdfc.application_id=201 and
fdfc.descriptive_flexfield_name=&apos;RCV_TRANSACTIONS&apos; and
fdfc.enabled_flag=&apos;Y&apos; and
fdfc.application_id=fdfcu.application_id and
fdfc.descriptive_flexfield_name=fdfcu.descriptive_flexfield_name and
fdfc.descriptive_flex_context_code=fdfcu.descriptive_flex_context_code and
fdfcu.enabled_flag=&apos;Y&apos; and
fdfcu.application_column_name=&apos;ATTRIBUTE7&apos;
) x
) y
where
y.len&lt;=3900
group by
y.application_column_name</COMMENTS>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>59</COLUMN_NUMBER>
    <COLUMN_NAME>LINE_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;201,
p_descriptive_flexfield_name=&gt;&apos;RCV_TRANSACTIONS&apos;,
p_context_name=&gt;:$column$.line_attribute_category,
p_column_name=&gt;&apos;ATTRIBUTE8&apos;,
p_attribute1=&gt;:$column$.line_attribute1,
p_attribute2=&gt;:$column$.line_attribute2,
p_attribute3=&gt;:$column$.line_attribute3,
p_attribute4=&gt;:$column$.line_attribute4,
p_attribute5=&gt;:$column$.line_attribute5,
p_attribute6=&gt;:$column$.line_attribute6,
p_attribute7=&gt;:$column$.line_attribute7,
p_attribute8=&gt;:$column$.line_attribute8,
p_attribute9=&gt;:$column$.line_attribute9,
p_attribute10=&gt;:$column$.line_attribute10,
p_attribute11=&gt;:$column$.line_attribute11,
p_attribute12=&gt;:$column$.line_attribute12,
p_attribute13=&gt;:$column$.line_attribute13,
p_attribute14=&gt;:$column$.line_attribute14,
p_attribute15=&gt;:$column$.line_attribute15
)) lov
order by
value</LOV_QUERY_DSP>
    <COMMENTS>select
&apos;(Context) &apos;||initcap(y.application_column_name)||&apos;: &apos;||listagg(y.entry,&apos;, &apos;) within group (order by y.sort_key) comments
from
(
select
x.application_column_name,
x.entry,
x.sort_key,
sum(lengthb(x.entry)+2) over (order by x.sort_key) len
from
(
select
fdfcu.application_column_name,
decode(fdfc.descriptive_flex_context_code,&apos;Global Data Elements&apos;,&apos;(Global)&apos;,&apos;(&apos;||fdfc.descriptive_flex_context_code||&apos;)&apos;)||&apos; &apos;||fdfcu.form_left_prompt entry,
decode(fdfc.descriptive_flex_context_code,&apos;Global Data Elements&apos;,&apos;1&apos;,&apos;2&apos;||fdfc.descriptive_flex_context_code) sort_key
from
fnd_descr_flex_contexts fdfc,
fnd_descr_flex_col_usage_vl fdfcu
where
fdfc.application_id=201 and
fdfc.descriptive_flexfield_name=&apos;RCV_TRANSACTIONS&apos; and
fdfc.enabled_flag=&apos;Y&apos; and
fdfc.application_id=fdfcu.application_id and
fdfc.descriptive_flexfield_name=fdfcu.descriptive_flexfield_name and
fdfc.descriptive_flex_context_code=fdfcu.descriptive_flex_context_code and
fdfcu.enabled_flag=&apos;Y&apos; and
fdfcu.application_column_name=&apos;ATTRIBUTE8&apos;
) x
) y
where
y.len&lt;=3900
group by
y.application_column_name</COMMENTS>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>60</COLUMN_NUMBER>
    <COLUMN_NAME>LINE_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;201,
p_descriptive_flexfield_name=&gt;&apos;RCV_TRANSACTIONS&apos;,
p_context_name=&gt;:$column$.line_attribute_category,
p_column_name=&gt;&apos;ATTRIBUTE9&apos;,
p_attribute1=&gt;:$column$.line_attribute1,
p_attribute2=&gt;:$column$.line_attribute2,
p_attribute3=&gt;:$column$.line_attribute3,
p_attribute4=&gt;:$column$.line_attribute4,
p_attribute5=&gt;:$column$.line_attribute5,
p_attribute6=&gt;:$column$.line_attribute6,
p_attribute7=&gt;:$column$.line_attribute7,
p_attribute8=&gt;:$column$.line_attribute8,
p_attribute9=&gt;:$column$.line_attribute9,
p_attribute10=&gt;:$column$.line_attribute10,
p_attribute11=&gt;:$column$.line_attribute11,
p_attribute12=&gt;:$column$.line_attribute12,
p_attribute13=&gt;:$column$.line_attribute13,
p_attribute14=&gt;:$column$.line_attribute14,
p_attribute15=&gt;:$column$.line_attribute15
)) lov
order by
value</LOV_QUERY_DSP>
    <COMMENTS>select
&apos;(Context) &apos;||initcap(y.application_column_name)||&apos;: &apos;||listagg(y.entry,&apos;, &apos;) within group (order by y.sort_key) comments
from
(
select
x.application_column_name,
x.entry,
x.sort_key,
sum(lengthb(x.entry)+2) over (order by x.sort_key) len
from
(
select
fdfcu.application_column_name,
decode(fdfc.descriptive_flex_context_code,&apos;Global Data Elements&apos;,&apos;(Global)&apos;,&apos;(&apos;||fdfc.descriptive_flex_context_code||&apos;)&apos;)||&apos; &apos;||fdfcu.form_left_prompt entry,
decode(fdfc.descriptive_flex_context_code,&apos;Global Data Elements&apos;,&apos;1&apos;,&apos;2&apos;||fdfc.descriptive_flex_context_code) sort_key
from
fnd_descr_flex_contexts fdfc,
fnd_descr_flex_col_usage_vl fdfcu
where
fdfc.application_id=201 and
fdfc.descriptive_flexfield_name=&apos;RCV_TRANSACTIONS&apos; and
fdfc.enabled_flag=&apos;Y&apos; and
fdfc.application_id=fdfcu.application_id and
fdfc.descriptive_flexfield_name=fdfcu.descriptive_flexfield_name and
fdfc.descriptive_flex_context_code=fdfcu.descriptive_flex_context_code and
fdfcu.enabled_flag=&apos;Y&apos; and
fdfcu.application_column_name=&apos;ATTRIBUTE9&apos;
) x
) y
where
y.len&lt;=3900
group by
y.application_column_name</COMMENTS>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>61</COLUMN_NUMBER>
    <COLUMN_NAME>LINE_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;201,
p_descriptive_flexfield_name=&gt;&apos;RCV_TRANSACTIONS&apos;,
p_context_name=&gt;:$column$.line_attribute_category,
p_column_name=&gt;&apos;ATTRIBUTE10&apos;,
p_attribute1=&gt;:$column$.line_attribute1,
p_attribute2=&gt;:$column$.line_attribute2,
p_attribute3=&gt;:$column$.line_attribute3,
p_attribute4=&gt;:$column$.line_attribute4,
p_attribute5=&gt;:$column$.line_attribute5,
p_attribute6=&gt;:$column$.line_attribute6,
p_attribute7=&gt;:$column$.line_attribute7,
p_attribute8=&gt;:$column$.line_attribute8,
p_attribute9=&gt;:$column$.line_attribute9,
p_attribute10=&gt;:$column$.line_attribute10,
p_attribute11=&gt;:$column$.line_attribute11,
p_attribute12=&gt;:$column$.line_attribute12,
p_attribute13=&gt;:$column$.line_attribute13,
p_attribute14=&gt;:$column$.line_attribute14,
p_attribute15=&gt;:$column$.line_attribute15
)) lov
order by
value</LOV_QUERY_DSP>
    <COMMENTS>select
&apos;(Context) &apos;||initcap(y.application_column_name)||&apos;: &apos;||listagg(y.entry,&apos;, &apos;) within group (order by y.sort_key) comments
from
(
select
x.application_column_name,
x.entry,
x.sort_key,
sum(lengthb(x.entry)+2) over (order by x.sort_key) len
from
(
select
fdfcu.application_column_name,
decode(fdfc.descriptive_flex_context_code,&apos;Global Data Elements&apos;,&apos;(Global)&apos;,&apos;(&apos;||fdfc.descriptive_flex_context_code||&apos;)&apos;)||&apos; &apos;||fdfcu.form_left_prompt entry,
decode(fdfc.descriptive_flex_context_code,&apos;Global Data Elements&apos;,&apos;1&apos;,&apos;2&apos;||fdfc.descriptive_flex_context_code) sort_key
from
fnd_descr_flex_contexts fdfc,
fnd_descr_flex_col_usage_vl fdfcu
where
fdfc.application_id=201 and
fdfc.descriptive_flexfield_name=&apos;RCV_TRANSACTIONS&apos; and
fdfc.enabled_flag=&apos;Y&apos; and
fdfc.application_id=fdfcu.application_id and
fdfc.descriptive_flexfield_name=fdfcu.descriptive_flexfield_name and
fdfc.descriptive_flex_context_code=fdfcu.descriptive_flex_context_code and
fdfcu.enabled_flag=&apos;Y&apos; and
fdfcu.application_column_name=&apos;ATTRIBUTE10&apos;
) x
) y
where
y.len&lt;=3900
group by
y.application_column_name</COMMENTS>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>62</COLUMN_NUMBER>
    <COLUMN_NAME>LINE_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;201,
p_descriptive_flexfield_name=&gt;&apos;RCV_TRANSACTIONS&apos;,
p_context_name=&gt;:$column$.line_attribute_category,
p_column_name=&gt;&apos;ATTRIBUTE11&apos;,
p_attribute1=&gt;:$column$.line_attribute1,
p_attribute2=&gt;:$column$.line_attribute2,
p_attribute3=&gt;:$column$.line_attribute3,
p_attribute4=&gt;:$column$.line_attribute4,
p_attribute5=&gt;:$column$.line_attribute5,
p_attribute6=&gt;:$column$.line_attribute6,
p_attribute7=&gt;:$column$.line_attribute7,
p_attribute8=&gt;:$column$.line_attribute8,
p_attribute9=&gt;:$column$.line_attribute9,
p_attribute10=&gt;:$column$.line_attribute10,
p_attribute11=&gt;:$column$.line_attribute11,
p_attribute12=&gt;:$column$.line_attribute12,
p_attribute13=&gt;:$column$.line_attribute13,
p_attribute14=&gt;:$column$.line_attribute14,
p_attribute15=&gt;:$column$.line_attribute15
)) lov
order by
value</LOV_QUERY_DSP>
    <COMMENTS>select
&apos;(Context) &apos;||initcap(y.application_column_name)||&apos;: &apos;||listagg(y.entry,&apos;, &apos;) within group (order by y.sort_key) comments
from
(
select
x.application_column_name,
x.entry,
x.sort_key,
sum(lengthb(x.entry)+2) over (order by x.sort_key) len
from
(
select
fdfcu.application_column_name,
decode(fdfc.descriptive_flex_context_code,&apos;Global Data Elements&apos;,&apos;(Global)&apos;,&apos;(&apos;||fdfc.descriptive_flex_context_code||&apos;)&apos;)||&apos; &apos;||fdfcu.form_left_prompt entry,
decode(fdfc.descriptive_flex_context_code,&apos;Global Data Elements&apos;,&apos;1&apos;,&apos;2&apos;||fdfc.descriptive_flex_context_code) sort_key
from
fnd_descr_flex_contexts fdfc,
fnd_descr_flex_col_usage_vl fdfcu
where
fdfc.application_id=201 and
fdfc.descriptive_flexfield_name=&apos;RCV_TRANSACTIONS&apos; and
fdfc.enabled_flag=&apos;Y&apos; and
fdfc.application_id=fdfcu.application_id and
fdfc.descriptive_flexfield_name=fdfcu.descriptive_flexfield_name and
fdfc.descriptive_flex_context_code=fdfcu.descriptive_flex_context_code and
fdfcu.enabled_flag=&apos;Y&apos; and
fdfcu.application_column_name=&apos;ATTRIBUTE11&apos;
) x
) y
where
y.len&lt;=3900
group by
y.application_column_name</COMMENTS>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>63</COLUMN_NUMBER>
    <COLUMN_NAME>LINE_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;201,
p_descriptive_flexfield_name=&gt;&apos;RCV_TRANSACTIONS&apos;,
p_context_name=&gt;:$column$.line_attribute_category,
p_column_name=&gt;&apos;ATTRIBUTE12&apos;,
p_attribute1=&gt;:$column$.line_attribute1,
p_attribute2=&gt;:$column$.line_attribute2,
p_attribute3=&gt;:$column$.line_attribute3,
p_attribute4=&gt;:$column$.line_attribute4,
p_attribute5=&gt;:$column$.line_attribute5,
p_attribute6=&gt;:$column$.line_attribute6,
p_attribute7=&gt;:$column$.line_attribute7,
p_attribute8=&gt;:$column$.line_attribute8,
p_attribute9=&gt;:$column$.line_attribute9,
p_attribute10=&gt;:$column$.line_attribute10,
p_attribute11=&gt;:$column$.line_attribute11,
p_attribute12=&gt;:$column$.line_attribute12,
p_attribute13=&gt;:$column$.line_attribute13,
p_attribute14=&gt;:$column$.line_attribute14,
p_attribute15=&gt;:$column$.line_attribute15
)) lov
order by
value</LOV_QUERY_DSP>
    <COMMENTS>select
&apos;(Context) &apos;||initcap(y.application_column_name)||&apos;: &apos;||listagg(y.entry,&apos;, &apos;) within group (order by y.sort_key) comments
from
(
select
x.application_column_name,
x.entry,
x.sort_key,
sum(lengthb(x.entry)+2) over (order by x.sort_key) len
from
(
select
fdfcu.application_column_name,
decode(fdfc.descriptive_flex_context_code,&apos;Global Data Elements&apos;,&apos;(Global)&apos;,&apos;(&apos;||fdfc.descriptive_flex_context_code||&apos;)&apos;)||&apos; &apos;||fdfcu.form_left_prompt entry,
decode(fdfc.descriptive_flex_context_code,&apos;Global Data Elements&apos;,&apos;1&apos;,&apos;2&apos;||fdfc.descriptive_flex_context_code) sort_key
from
fnd_descr_flex_contexts fdfc,
fnd_descr_flex_col_usage_vl fdfcu
where
fdfc.application_id=201 and
fdfc.descriptive_flexfield_name=&apos;RCV_TRANSACTIONS&apos; and
fdfc.enabled_flag=&apos;Y&apos; and
fdfc.application_id=fdfcu.application_id and
fdfc.descriptive_flexfield_name=fdfcu.descriptive_flexfield_name and
fdfc.descriptive_flex_context_code=fdfcu.descriptive_flex_context_code and
fdfcu.enabled_flag=&apos;Y&apos; and
fdfcu.application_column_name=&apos;ATTRIBUTE12&apos;
) x
) y
where
y.len&lt;=3900
group by
y.application_column_name</COMMENTS>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>64</COLUMN_NUMBER>
    <COLUMN_NAME>LINE_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;201,
p_descriptive_flexfield_name=&gt;&apos;RCV_TRANSACTIONS&apos;,
p_context_name=&gt;:$column$.line_attribute_category,
p_column_name=&gt;&apos;ATTRIBUTE13&apos;,
p_attribute1=&gt;:$column$.line_attribute1,
p_attribute2=&gt;:$column$.line_attribute2,
p_attribute3=&gt;:$column$.line_attribute3,
p_attribute4=&gt;:$column$.line_attribute4,
p_attribute5=&gt;:$column$.line_attribute5,
p_attribute6=&gt;:$column$.line_attribute6,
p_attribute7=&gt;:$column$.line_attribute7,
p_attribute8=&gt;:$column$.line_attribute8,
p_attribute9=&gt;:$column$.line_attribute9,
p_attribute10=&gt;:$column$.line_attribute10,
p_attribute11=&gt;:$column$.line_attribute11,
p_attribute12=&gt;:$column$.line_attribute12,
p_attribute13=&gt;:$column$.line_attribute13,
p_attribute14=&gt;:$column$.line_attribute14,
p_attribute15=&gt;:$column$.line_attribute15
)) lov
order by
value</LOV_QUERY_DSP>
    <COMMENTS>select
&apos;(Context) &apos;||initcap(y.application_column_name)||&apos;: &apos;||listagg(y.entry,&apos;, &apos;) within group (order by y.sort_key) comments
from
(
select
x.application_column_name,
x.entry,
x.sort_key,
sum(lengthb(x.entry)+2) over (order by x.sort_key) len
from
(
select
fdfcu.application_column_name,
decode(fdfc.descriptive_flex_context_code,&apos;Global Data Elements&apos;,&apos;(Global)&apos;,&apos;(&apos;||fdfc.descriptive_flex_context_code||&apos;)&apos;)||&apos; &apos;||fdfcu.form_left_prompt entry,
decode(fdfc.descriptive_flex_context_code,&apos;Global Data Elements&apos;,&apos;1&apos;,&apos;2&apos;||fdfc.descriptive_flex_context_code) sort_key
from
fnd_descr_flex_contexts fdfc,
fnd_descr_flex_col_usage_vl fdfcu
where
fdfc.application_id=201 and
fdfc.descriptive_flexfield_name=&apos;RCV_TRANSACTIONS&apos; and
fdfc.enabled_flag=&apos;Y&apos; and
fdfc.application_id=fdfcu.application_id and
fdfc.descriptive_flexfield_name=fdfcu.descriptive_flexfield_name and
fdfc.descriptive_flex_context_code=fdfcu.descriptive_flex_context_code and
fdfcu.enabled_flag=&apos;Y&apos; and
fdfcu.application_column_name=&apos;ATTRIBUTE13&apos;
) x
) y
where
y.len&lt;=3900
group by
y.application_column_name</COMMENTS>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>65</COLUMN_NUMBER>
    <COLUMN_NAME>LINE_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;201,
p_descriptive_flexfield_name=&gt;&apos;RCV_TRANSACTIONS&apos;,
p_context_name=&gt;:$column$.line_attribute_category,
p_column_name=&gt;&apos;ATTRIBUTE14&apos;,
p_attribute1=&gt;:$column$.line_attribute1,
p_attribute2=&gt;:$column$.line_attribute2,
p_attribute3=&gt;:$column$.line_attribute3,
p_attribute4=&gt;:$column$.line_attribute4,
p_attribute5=&gt;:$column$.line_attribute5,
p_attribute6=&gt;:$column$.line_attribute6,
p_attribute7=&gt;:$column$.line_attribute7,
p_attribute8=&gt;:$column$.line_attribute8,
p_attribute9=&gt;:$column$.line_attribute9,
p_attribute10=&gt;:$column$.line_attribute10,
p_attribute11=&gt;:$column$.line_attribute11,
p_attribute12=&gt;:$column$.line_attribute12,
p_attribute13=&gt;:$column$.line_attribute13,
p_attribute14=&gt;:$column$.line_attribute14,
p_attribute15=&gt;:$column$.line_attribute15
)) lov
order by
value</LOV_QUERY_DSP>
    <COMMENTS>select
&apos;(Context) &apos;||initcap(y.application_column_name)||&apos;: &apos;||listagg(y.entry,&apos;, &apos;) within group (order by y.sort_key) comments
from
(
select
x.application_column_name,
x.entry,
x.sort_key,
sum(lengthb(x.entry)+2) over (order by x.sort_key) len
from
(
select
fdfcu.application_column_name,
decode(fdfc.descriptive_flex_context_code,&apos;Global Data Elements&apos;,&apos;(Global)&apos;,&apos;(&apos;||fdfc.descriptive_flex_context_code||&apos;)&apos;)||&apos; &apos;||fdfcu.form_left_prompt entry,
decode(fdfc.descriptive_flex_context_code,&apos;Global Data Elements&apos;,&apos;1&apos;,&apos;2&apos;||fdfc.descriptive_flex_context_code) sort_key
from
fnd_descr_flex_contexts fdfc,
fnd_descr_flex_col_usage_vl fdfcu
where
fdfc.application_id=201 and
fdfc.descriptive_flexfield_name=&apos;RCV_TRANSACTIONS&apos; and
fdfc.enabled_flag=&apos;Y&apos; and
fdfc.application_id=fdfcu.application_id and
fdfc.descriptive_flexfield_name=fdfcu.descriptive_flexfield_name and
fdfc.descriptive_flex_context_code=fdfcu.descriptive_flex_context_code and
fdfcu.enabled_flag=&apos;Y&apos; and
fdfcu.application_column_name=&apos;ATTRIBUTE14&apos;
) x
) y
where
y.len&lt;=3900
group by
y.application_column_name</COMMENTS>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>66</COLUMN_NUMBER>
    <COLUMN_NAME>LINE_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;201,
p_descriptive_flexfield_name=&gt;&apos;RCV_TRANSACTIONS&apos;,
p_context_name=&gt;:$column$.line_attribute_category,
p_column_name=&gt;&apos;ATTRIBUTE15&apos;,
p_attribute1=&gt;:$column$.line_attribute1,
p_attribute2=&gt;:$column$.line_attribute2,
p_attribute3=&gt;:$column$.line_attribute3,
p_attribute4=&gt;:$column$.line_attribute4,
p_attribute5=&gt;:$column$.line_attribute5,
p_attribute6=&gt;:$column$.line_attribute6,
p_attribute7=&gt;:$column$.line_attribute7,
p_attribute8=&gt;:$column$.line_attribute8,
p_attribute9=&gt;:$column$.line_attribute9,
p_attribute10=&gt;:$column$.line_attribute10,
p_attribute11=&gt;:$column$.line_attribute11,
p_attribute12=&gt;:$column$.line_attribute12,
p_attribute13=&gt;:$column$.line_attribute13,
p_attribute14=&gt;:$column$.line_attribute14,
p_attribute15=&gt;:$column$.line_attribute15
)) lov
order by
value</LOV_QUERY_DSP>
    <COMMENTS>select
&apos;(Context) &apos;||initcap(y.application_column_name)||&apos;: &apos;||listagg(y.entry,&apos;, &apos;) within group (order by y.sort_key) comments
from
(
select
x.application_column_name,
x.entry,
x.sort_key,
sum(lengthb(x.entry)+2) over (order by x.sort_key) len
from
(
select
fdfcu.application_column_name,
decode(fdfc.descriptive_flex_context_code,&apos;Global Data Elements&apos;,&apos;(Global)&apos;,&apos;(&apos;||fdfc.descriptive_flex_context_code||&apos;)&apos;)||&apos; &apos;||fdfcu.form_left_prompt entry,
decode(fdfc.descriptive_flex_context_code,&apos;Global Data Elements&apos;,&apos;1&apos;,&apos;2&apos;||fdfc.descriptive_flex_context_code) sort_key
from
fnd_descr_flex_contexts fdfc,
fnd_descr_flex_col_usage_vl fdfcu
where
fdfc.application_id=201 and
fdfc.descriptive_flexfield_name=&apos;RCV_TRANSACTIONS&apos; and
fdfc.enabled_flag=&apos;Y&apos; and
fdfc.application_id=fdfcu.application_id and
fdfc.descriptive_flexfield_name=fdfcu.descriptive_flexfield_name and
fdfc.descriptive_flex_context_code=fdfcu.descriptive_flex_context_code and
fdfcu.enabled_flag=&apos;Y&apos; and
fdfcu.application_column_name=&apos;ATTRIBUTE15&apos;
) x
) y
where
y.len&lt;=3900
group by
y.application_column_name</COMMENTS>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>67</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>p_organization_id</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Number</PARAMETER_TYPE>
    <COLUMN_NAME>ORGANIZATION_CODE</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>2</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_org_id</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Number</PARAMETER_TYPE>
    <COLUMN_NAME>OPERATING_UNIT</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>3</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_po_number</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Char</PARAMETER_TYPE>
    <COLUMN_NAME>PO_NUMBER</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>4</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_release_num</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Number</PARAMETER_TYPE>
    <DEFAULTED>Y</DEFAULTED>
    <COLUMN_NAME>RELEASE_NUM</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>5</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_line_num</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Number</PARAMETER_TYPE>
    <COLUMN_NAME>LINE_NUM</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>6</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_shipment_num</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Number</PARAMETER_TYPE>
    <COLUMN_NAME>SHIPMENT_NUM</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>7</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_quantity</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Number</PARAMETER_TYPE>
    <COLUMN_NAME>QUANTITY</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>8</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_transaction_date</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Date</PARAMETER_TYPE>
    <COLUMN_NAME>TRANSACTION_DATE</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>9</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_item_revision</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Char</PARAMETER_TYPE>
    <COLUMN_NAME>ITEM_REVISION</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>10</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_destination_type_code</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Char</PARAMETER_TYPE>
    <COLUMN_NAME>DESTINATION_TYPE</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>11</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_subinventory</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Char</PARAMETER_TYPE>
    <COLUMN_NAME>SUBINVENTORY</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>12</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_locator_id</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Number</PARAMETER_TYPE>
    <COLUMN_NAME>LOCATOR</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>13</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_deliver_to_location_id</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Number</PARAMETER_TYPE>
    <COLUMN_NAME>DELIVER_TO_LOCATION</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>14</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_country_of_origin_code</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Char</PARAMETER_TYPE>
    <COLUMN_NAME>COUNTRY_OF_ORIGIN</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>15</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_vendor_lot_num</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Char</PARAMETER_TYPE>
    <COLUMN_NAME>VENDOR_LOT_NUM</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>16</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_comments</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Char</PARAMETER_TYPE>
    <COLUMN_NAME>COMMENTS</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>17</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_row_id</PARAMETER_NAME>
    <IN_OUT>in/out</IN_OUT>
    <PARAMETER_TYPE>Char</PARAMETER_TYPE>
    <COLUMN_NAME>ROW_ID</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>18</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>19</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>20</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_lot_number</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Char</PARAMETER_TYPE>
    <DEFAULTED>Y</DEFAULTED>
    <COLUMN_NAME>LOT_NUMBER</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>21</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_lot_expiration_date</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Date</PARAMETER_TYPE>
    <DEFAULTED>Y</DEFAULTED>
    <COLUMN_NAME>LOT_EXPIRATION_DATE</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>22</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_from_serial_number</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Char</PARAMETER_TYPE>
    <DEFAULTED>Y</DEFAULTED>
    <COLUMN_NAME>FROM_SERIAL_NUMBER</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>23</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_to_serial_number</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Char</PARAMETER_TYPE>
    <DEFAULTED>Y</DEFAULTED>
    <COLUMN_NAME>TO_SERIAL_NUMBER</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>24</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_receipt_attribute_category</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Char</PARAMETER_TYPE>
    <DEFAULTED>Y</DEFAULTED>
    <COLUMN_NAME>RECEIPT_ATTRIBUTE_CATEGORY</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>25</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_receipt_attribute1</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Char</PARAMETER_TYPE>
    <DEFAULTED>Y</DEFAULTED>
    <COLUMN_NAME>RECEIPT_ATTRIBUTE1</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>26</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_receipt_attribute2</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Char</PARAMETER_TYPE>
    <DEFAULTED>Y</DEFAULTED>
    <COLUMN_NAME>RECEIPT_ATTRIBUTE2</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>27</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_receipt_attribute3</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Char</PARAMETER_TYPE>
    <DEFAULTED>Y</DEFAULTED>
    <COLUMN_NAME>RECEIPT_ATTRIBUTE3</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>28</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_receipt_attribute4</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Char</PARAMETER_TYPE>
    <DEFAULTED>Y</DEFAULTED>
    <COLUMN_NAME>RECEIPT_ATTRIBUTE4</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>29</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_receipt_attribute5</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Char</PARAMETER_TYPE>
    <DEFAULTED>Y</DEFAULTED>
    <COLUMN_NAME>RECEIPT_ATTRIBUTE5</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>30</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_receipt_attribute6</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Char</PARAMETER_TYPE>
    <DEFAULTED>Y</DEFAULTED>
    <COLUMN_NAME>RECEIPT_ATTRIBUTE6</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>31</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_receipt_attribute7</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Char</PARAMETER_TYPE>
    <DEFAULTED>Y</DEFAULTED>
    <COLUMN_NAME>RECEIPT_ATTRIBUTE7</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>32</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_receipt_attribute8</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Char</PARAMETER_TYPE>
    <DEFAULTED>Y</DEFAULTED>
    <COLUMN_NAME>RECEIPT_ATTRIBUTE8</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>33</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_receipt_attribute9</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Char</PARAMETER_TYPE>
    <DEFAULTED>Y</DEFAULTED>
    <COLUMN_NAME>RECEIPT_ATTRIBUTE9</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>34</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_receipt_attribute10</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Char</PARAMETER_TYPE>
    <DEFAULTED>Y</DEFAULTED>
    <COLUMN_NAME>RECEIPT_ATTRIBUTE10</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>35</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_receipt_attribute11</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Char</PARAMETER_TYPE>
    <DEFAULTED>Y</DEFAULTED>
    <COLUMN_NAME>RECEIPT_ATTRIBUTE11</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>36</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_receipt_attribute12</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Char</PARAMETER_TYPE>
    <DEFAULTED>Y</DEFAULTED>
    <COLUMN_NAME>RECEIPT_ATTRIBUTE12</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>37</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_receipt_attribute13</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Char</PARAMETER_TYPE>
    <DEFAULTED>Y</DEFAULTED>
    <COLUMN_NAME>RECEIPT_ATTRIBUTE13</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>38</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_receipt_attribute14</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Char</PARAMETER_TYPE>
    <DEFAULTED>Y</DEFAULTED>
    <COLUMN_NAME>RECEIPT_ATTRIBUTE14</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>39</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_receipt_attribute15</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Char</PARAMETER_TYPE>
    <DEFAULTED>Y</DEFAULTED>
    <COLUMN_NAME>RECEIPT_ATTRIBUTE15</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>40</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_line_attribute_category</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Char</PARAMETER_TYPE>
    <DEFAULTED>Y</DEFAULTED>
    <COLUMN_NAME>LINE_ATTRIBUTE_CATEGORY</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>41</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_line_attribute1</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Char</PARAMETER_TYPE>
    <DEFAULTED>Y</DEFAULTED>
    <COLUMN_NAME>LINE_ATTRIBUTE1</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>42</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_line_attribute2</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Char</PARAMETER_TYPE>
    <DEFAULTED>Y</DEFAULTED>
    <COLUMN_NAME>LINE_ATTRIBUTE2</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>43</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_line_attribute3</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Char</PARAMETER_TYPE>
    <DEFAULTED>Y</DEFAULTED>
    <COLUMN_NAME>LINE_ATTRIBUTE3</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>44</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_line_attribute4</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Char</PARAMETER_TYPE>
    <DEFAULTED>Y</DEFAULTED>
    <COLUMN_NAME>LINE_ATTRIBUTE4</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>45</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_line_attribute5</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Char</PARAMETER_TYPE>
    <DEFAULTED>Y</DEFAULTED>
    <COLUMN_NAME>LINE_ATTRIBUTE5</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>46</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_line_attribute6</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Char</PARAMETER_TYPE>
    <DEFAULTED>Y</DEFAULTED>
    <COLUMN_NAME>LINE_ATTRIBUTE6</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>47</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_line_attribute7</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Char</PARAMETER_TYPE>
    <DEFAULTED>Y</DEFAULTED>
    <COLUMN_NAME>LINE_ATTRIBUTE7</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>48</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_line_attribute8</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Char</PARAMETER_TYPE>
    <DEFAULTED>Y</DEFAULTED>
    <COLUMN_NAME>LINE_ATTRIBUTE8</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>49</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_line_attribute9</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Char</PARAMETER_TYPE>
    <DEFAULTED>Y</DEFAULTED>
    <COLUMN_NAME>LINE_ATTRIBUTE9</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>50</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_line_attribute10</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Char</PARAMETER_TYPE>
    <DEFAULTED>Y</DEFAULTED>
    <COLUMN_NAME>LINE_ATTRIBUTE10</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>51</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_line_attribute11</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Char</PARAMETER_TYPE>
    <DEFAULTED>Y</DEFAULTED>
    <COLUMN_NAME>LINE_ATTRIBUTE11</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>52</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_line_attribute12</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Char</PARAMETER_TYPE>
    <DEFAULTED>Y</DEFAULTED>
    <COLUMN_NAME>LINE_ATTRIBUTE12</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>53</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_line_attribute13</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Char</PARAMETER_TYPE>
    <DEFAULTED>Y</DEFAULTED>
    <COLUMN_NAME>LINE_ATTRIBUTE13</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>54</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_line_attribute14</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Char</PARAMETER_TYPE>
    <DEFAULTED>Y</DEFAULTED>
    <COLUMN_NAME>LINE_ATTRIBUTE14</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>55</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_line_attribute15</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Char</PARAMETER_TYPE>
    <DEFAULTED>Y</DEFAULTED>
    <COLUMN_NAME>LINE_ATTRIBUTE15</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>P</SOURCE>
    <DISPLAY_SEQUENCE>1</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_organization_id</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Number</PARAMETER_TYPE>
    <COLUMN_NAME>ORGANIZATION_CODE</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>P</SOURCE>
    <DISPLAY_SEQUENCE>2</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>x_request_id</PARAMETER_NAME>
    <IN_OUT>out</IN_OUT>
    <PARAMETER_TYPE>Number</PARAMETER_TYPE>
    <COLUMN_NAME>REQUEST_ID_</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>P</SOURCE>
    <DISPLAY_SEQUENCE>3</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>P</SOURCE>
    <DISPLAY_SEQUENCE>4</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>
  <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,
organization_code,
operating_unit,
po_number,
release_num,
line_num,
shipment_num</SQL_TEXT>
   </UPLOAD_SQLS_ROW>
   <UPLOAD_SQLS_ROW>
    <SQL_TYPE>Success SQL</SQL_TYPE>
    <SQL_TEXT>select
xu.action_,
xxen_upload.status_meaning(xxen_upload.status_success) status_,
&apos;Receipt &apos;||rsh.receipt_num||&apos; created, quantity &apos;||rt.quantity message_,
xu.modified_columns_,
xu.request_id_,
xu.row_id,
mp.organization_code,
(select hou.name from hr_operating_units hou where pha.org_id=hou.organization_id) operating_unit,
aps.vendor_name supplier,
assa.vendor_site_code supplier_site,
pha.segment1 po_number,
pra.release_num,
pla.line_num,
plla.shipment_num,
(select msibk.concatenated_segments from mtl_system_items_b_kfv msibk where pla.item_id=msibk.inventory_item_id and plla.ship_to_organization_id=msibk.organization_id) item,
xu.item_revision,
pla.item_description,
plla.quantity quantity_ordered,
nvl(plla.quantity_received,0) quantity_received,
plla.quantity-nvl(plla.quantity_received,0) quantity_remaining,
pla.unit_meas_lookup_code unit_of_measure,
rt.quantity,
rt.transaction_date,
xu.destination_type,
xu.subinventory,
xu.locator,
(select max(rlt.lot_num) from rcv_lot_transactions rlt where rt.transaction_id=rlt.transaction_id) lot_number,
(select max(mln.expiration_date) from rcv_lot_transactions rlt, mtl_lot_numbers mln where rt.transaction_id=rlt.transaction_id and rt.organization_id=mln.organization_id and rlt.item_id=mln.inventory_item_id and rlt.lot_num=mln.lot_number) lot_expiration_date,
(select min(rst.serial_num) from rcv_serial_transactions rst where rt.transaction_id=rst.transaction_id) from_serial_number,
(select max(rst.serial_num) from rcv_serial_transactions rst where rt.transaction_id=rst.transaction_id) to_serial_number,
xu.deliver_to_location,
xu.country_of_origin,
xu.vendor_lot_num,
rt.comments,
xxen_util.display_flexfield_context(201,&apos;RCV_SHIPMENT_HEADERS&apos;,rsh.attribute_category) receipt_attribute_category,
xxen_util.display_flexfield_value(201,&apos;RCV_SHIPMENT_HEADERS&apos;,rsh.attribute_category,&apos;ATTRIBUTE1&apos;,rsh.rowid,rsh.attribute1) receipt_attribute1,
xxen_util.display_flexfield_value(201,&apos;RCV_SHIPMENT_HEADERS&apos;,rsh.attribute_category,&apos;ATTRIBUTE2&apos;,rsh.rowid,rsh.attribute2) receipt_attribute2,
xxen_util.display_flexfield_value(201,&apos;RCV_SHIPMENT_HEADERS&apos;,rsh.attribute_category,&apos;ATTRIBUTE3&apos;,rsh.rowid,rsh.attribute3) receipt_attribute3,
xxen_util.display_flexfield_value(201,&apos;RCV_SHIPMENT_HEADERS&apos;,rsh.attribute_category,&apos;ATTRIBUTE4&apos;,rsh.rowid,rsh.attribute4) receipt_attribute4,
xxen_util.display_flexfield_value(201,&apos;RCV_SHIPMENT_HEADERS&apos;,rsh.attribute_category,&apos;ATTRIBUTE5&apos;,rsh.rowid,rsh.attribute5) receipt_attribute5,
xxen_util.display_flexfield_value(201,&apos;RCV_SHIPMENT_HEADERS&apos;,rsh.attribute_category,&apos;ATTRIBUTE6&apos;,rsh.rowid,rsh.attribute6) receipt_attribute6,
xxen_util.display_flexfield_value(201,&apos;RCV_SHIPMENT_HEADERS&apos;,rsh.attribute_category,&apos;ATTRIBUTE7&apos;,rsh.rowid,rsh.attribute7) receipt_attribute7,
xxen_util.display_flexfield_value(201,&apos;RCV_SHIPMENT_HEADERS&apos;,rsh.attribute_category,&apos;ATTRIBUTE8&apos;,rsh.rowid,rsh.attribute8) receipt_attribute8,
xxen_util.display_flexfield_value(201,&apos;RCV_SHIPMENT_HEADERS&apos;,rsh.attribute_category,&apos;ATTRIBUTE9&apos;,rsh.rowid,rsh.attribute9) receipt_attribute9,
xxen_util.display_flexfield_value(201,&apos;RCV_SHIPMENT_HEADERS&apos;,rsh.attribute_category,&apos;ATTRIBUTE10&apos;,rsh.rowid,rsh.attribute10) receipt_attribute10,
xxen_util.display_flexfield_value(201,&apos;RCV_SHIPMENT_HEADERS&apos;,rsh.attribute_category,&apos;ATTRIBUTE11&apos;,rsh.rowid,rsh.attribute11) receipt_attribute11,
xxen_util.display_flexfield_value(201,&apos;RCV_SHIPMENT_HEADERS&apos;,rsh.attribute_category,&apos;ATTRIBUTE12&apos;,rsh.rowid,rsh.attribute12) receipt_attribute12,
xxen_util.display_flexfield_value(201,&apos;RCV_SHIPMENT_HEADERS&apos;,rsh.attribute_category,&apos;ATTRIBUTE13&apos;,rsh.rowid,rsh.attribute13) receipt_attribute13,
xxen_util.display_flexfield_value(201,&apos;RCV_SHIPMENT_HEADERS&apos;,rsh.attribute_category,&apos;ATTRIBUTE14&apos;,rsh.rowid,rsh.attribute14) receipt_attribute14,
xxen_util.display_flexfield_value(201,&apos;RCV_SHIPMENT_HEADERS&apos;,rsh.attribute_category,&apos;ATTRIBUTE15&apos;,rsh.rowid,rsh.attribute15) receipt_attribute15,
xxen_util.display_flexfield_context(201,&apos;RCV_TRANSACTIONS&apos;,rt.attribute_category) line_attribute_category,
xxen_util.display_flexfield_value(201,&apos;RCV_TRANSACTIONS&apos;,rt.attribute_category,&apos;ATTRIBUTE1&apos;,rt.rowid,rt.attribute1) line_attribute1,
xxen_util.display_flexfield_value(201,&apos;RCV_TRANSACTIONS&apos;,rt.attribute_category,&apos;ATTRIBUTE2&apos;,rt.rowid,rt.attribute2) line_attribute2,
xxen_util.display_flexfield_value(201,&apos;RCV_TRANSACTIONS&apos;,rt.attribute_category,&apos;ATTRIBUTE3&apos;,rt.rowid,rt.attribute3) line_attribute3,
xxen_util.display_flexfield_value(201,&apos;RCV_TRANSACTIONS&apos;,rt.attribute_category,&apos;ATTRIBUTE4&apos;,rt.rowid,rt.attribute4) line_attribute4,
xxen_util.display_flexfield_value(201,&apos;RCV_TRANSACTIONS&apos;,rt.attribute_category,&apos;ATTRIBUTE5&apos;,rt.rowid,rt.attribute5) line_attribute5,
xxen_util.display_flexfield_value(201,&apos;RCV_TRANSACTIONS&apos;,rt.attribute_category,&apos;ATTRIBUTE6&apos;,rt.rowid,rt.attribute6) line_attribute6,
xxen_util.display_flexfield_value(201,&apos;RCV_TRANSACTIONS&apos;,rt.attribute_category,&apos;ATTRIBUTE7&apos;,rt.rowid,rt.attribute7) line_attribute7,
xxen_util.display_flexfield_value(201,&apos;RCV_TRANSACTIONS&apos;,rt.attribute_category,&apos;ATTRIBUTE8&apos;,rt.rowid,rt.attribute8) line_attribute8,
xxen_util.display_flexfield_value(201,&apos;RCV_TRANSACTIONS&apos;,rt.attribute_category,&apos;ATTRIBUTE9&apos;,rt.rowid,rt.attribute9) line_attribute9,
xxen_util.display_flexfield_value(201,&apos;RCV_TRANSACTIONS&apos;,rt.attribute_category,&apos;ATTRIBUTE10&apos;,rt.rowid,rt.attribute10) line_attribute10,
xxen_util.display_flexfield_value(201,&apos;RCV_TRANSACTIONS&apos;,rt.attribute_category,&apos;ATTRIBUTE11&apos;,rt.rowid,rt.attribute11) line_attribute11,
xxen_util.display_flexfield_value(201,&apos;RCV_TRANSACTIONS&apos;,rt.attribute_category,&apos;ATTRIBUTE12&apos;,rt.rowid,rt.attribute12) line_attribute12,
xxen_util.display_flexfield_value(201,&apos;RCV_TRANSACTIONS&apos;,rt.attribute_category,&apos;ATTRIBUTE13&apos;,rt.rowid,rt.attribute13) line_attribute13,
xxen_util.display_flexfield_value(201,&apos;RCV_TRANSACTIONS&apos;,rt.attribute_category,&apos;ATTRIBUTE14&apos;,rt.rowid,rt.attribute14) line_attribute14,
xxen_util.display_flexfield_value(201,&apos;RCV_TRANSACTIONS&apos;,rt.attribute_category,&apos;ATTRIBUTE15&apos;,rt.rowid,rt.attribute15) line_attribute15,
xu.upload_row
from
xxen_po_receiving_trans_7009_u xu,
rcv_transactions rt,
rcv_shipment_headers rsh,
po_line_locations_all plla,
po_releases_all pra,
po_lines_all pla,
po_headers_all pha,
ap_suppliers aps,
ap_supplier_sites_all assa,
mtl_parameters mp
where
xu.status_code_=xxen_upload.status_success and
to_number(xu.row_id)=rt.interface_transaction_id and
rt.transaction_type=&apos;RECEIVE&apos; and
rt.shipment_header_id=rsh.shipment_header_id and
rt.po_line_location_id=plla.line_location_id and
plla.po_release_id=pra.po_release_id(+) and
plla.po_line_id=pla.po_line_id and
pla.po_header_id=pha.po_header_id and
pha.vendor_id=aps.vendor_id and
pha.vendor_site_id=assa.vendor_site_id(+) and
rt.organization_id=mp.organization_id</SQL_TEXT>
   </UPLOAD_SQLS_ROW>
  </UPLOAD_SQLS>
 </REPORTS_ROW>
</REPORTS>
</ROOT>
