<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: CAC Receiving Account Detail -->
 <REPORTS_ROW>
  <GUID>E337769634F05A38E0530100007F1DF9</GUID><ENABLED>Y</ENABLED>
  <SQL_TEXT>select /*+ leading(mp rae) use_nl(rrsl) */
gl.name ledger,
haouv.name operating_unit,
mp.organization_code org_code,
rrsl.period_name,
&amp;segment_columns
msiv.concatenated_segments item_number,
msiv.description item_description,
xxen_util.meaning(msiv.item_type,&apos;ITEM_TYPE&apos;,3) item_type,
&amp;category_columns
mck.concatenated_segments purchasing_category,
rrsl.accounting_line_type,
xxen_util.meaning(rt.transaction_type,&apos;RCV TRANSACTION TYPE&apos;,201) transaction_type,
rt.transaction_id,
rt.transaction_date,
rt.creation_date,
xxen_util.user_name(rt.created_by) created_by,
aps.vendor_name supplier_name,
xxen_util.meaning(pda.destination_type_code,&apos;DESTINATION TYPE&apos;,201) destination_type,
pha.segment1 po_number,
pla.line_num po_line,
(select pra.release_num from po_releases_all pra where rt.po_release_id=pra.po_release_id) release_number,
&amp;project_columns
&amp;wip_osp_columns
msiv.primary_uom_code uom_code,
decode(sign(nvl(rrsl.accounted_dr,0)-nvl(rrsl.accounted_cr,0)),0,rt.primary_quantity,sign(nvl(rrsl.accounted_dr,0)-nvl(rrsl.accounted_cr,0))*abs(rt.primary_quantity)) quantity,
gl.currency_code,
rae.unit_price,
nvl(rrsl.accounted_dr,0)-nvl(rrsl.accounted_cr,0) amount
&amp;il_reg_columns
&amp;il_columns_amt
&amp;il_columns_rate
&amp;il_columns_tp
from
mtl_parameters mp,
hr_organization_information hoi,
hr_all_organization_units_vl haouv,
gl_ledgers gl,
rcv_accounting_events rae,
rcv_receiving_sub_ledger rrsl,
rcv_transactions rt,
rcv_shipment_lines rsl,
po_headers_all pha,
po_lines_all pla,
po_distributions_all pda,
ap_suppliers aps,
mtl_system_items_vl msiv,
mtl_categories_kfv mck,
&amp;project_tables
&amp;sla_tables
gl_code_combinations_kfv gcck
&amp;il_from
where
1=1 and
mp.organization_id in (select xroa.id from xxen_report_org_access xroa where xroa.access_type=&apos;INV&apos;) and
mp.organization_id=hoi.organization_id and
hoi.org_information_context=&apos;Accounting Information&apos; and
to_number(hoi.org_information3)=haouv.organization_id and
to_number(hoi.org_information1)=gl.ledger_id and
mp.organization_id=rae.organization_id and
rae.rcv_transaction_id=rrsl.rcv_transaction_id and
rae.accounting_event_id=rrsl.accounting_event_id and
rrsl.rcv_transaction_id=rt.transaction_id and
rt.shipment_line_id=rsl.shipment_line_id and
rt.po_header_id=pha.po_header_id and
rt.po_line_id=pla.po_line_id and
nvl(rt.po_distribution_id,to_number(rrsl.reference3))=pda.po_distribution_id and
pha.vendor_id=aps.vendor_id and
rsl.item_id=msiv.inventory_item_id(+) and
rsl.to_organization_id=msiv.organization_id(+) and
pla.category_id=mck.category_id(+) and
&amp;project_joins
&amp;account_join
&amp;account_join_sla
&amp;il_where
order by
gl.name,
haouv.name,
mp.organization_code,
rrsl.period_name,
gcck.concatenated_segments,
msiv.concatenated_segments,
rt.transaction_date,
rt.transaction_id,
rrsl.accounting_line_type</SQL_TEXT>
  <VERSION_COMMENTS>Organization security from the Blitz Report organization access: inventory organizations, with operating unit and ledger security through profiles Blitz Report Use Operating Unit Security and Blitz Report Use Ledger Security. The operating unit and ledger lists show those of the accessible inventory organizations.</VERSION_COMMENTS>
  <REQUIRED_PARAMETERS>(:Transaction_Type is not null or :Minimum_Absolute_Amount is not null or :Supplier_Name is not null or :PO_Number is not null or :Destination_Code is not null or :Item_Number is not null) and
(:Organization_Code is not null)</REQUIRED_PARAMETERS>
  <REPORT_TRANSLATIONS>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>US</LANGUAGE>
    <REPORT_NAME>CAC Receiving Account Detail</REPORT_NAME>
    <DESCRIPTION>Receiving accounting distributions in detail by item, purchase order, release, transaction date, creation date, created by and transaction id.
Show SLA Accounting = Yes reports the Subledger Accounting (Create Accounting) account, and only distributions accounted in Subledger Accounting. No reports the receiving subledger account.
Show Project Information and Show WIP Outside Processing add the project and task, and the WIP job and outside processing resource columns.
Purchasing Category is the purchase order line category, which also categorizes expense receipts without an item.
On instances with India Localization, GST columns (GST/PAN/TAN, tax, HSN/SAC, NR Tax) are also included.

/* +=============================================================================+
-- |  Copyright 2010 - 2022 Douglas Volz Consulting, Inc.
-- |  Permission to use this code is granted provided the original author is
-- |  acknowledged.  No warranties, express or otherwise is included in this
-- |  permission.
-- +=============================================================================+
-- |
-- |  Original Author: Douglas Volz (doug@volzconsulting.com)
-- |
-- |  Program Name:  xxx_rcv_dist_xla_detail_rept.sql
-- |
-- |  Version Modified on Modified  by   Description
-- |  ======= =========== ============== =========================================
-- |  1.0     05 Apr 2010 Douglas Volz   Initial Coding based on XXX_RCV_DIST_XLA_SUM_REPT.sql
-- |  1.18    21 Aug 2022 Douglas Volz   Streamline dynamic SQL code.
-- |  1.19    03 Sep 2022 Douglas Volz   Add Accounting Line Type, Transaction Type and Minimum Amount parameters.
-- |                                     And language translations for Accounting Line Types.
-- |  1.20   08 Oct 2022 Douglas Volz    Add project task information.
-- +=============================================================================+*/</DESCRIPTION>
    <REQUIRED_PARAMETERS_MESSAGE>Please specify at least one or more of the following: Transaction Type, Minimum Absolute Amount, Supplier Name, PO Number, Destination Code or Item Number, plus one or more Organization Codes.

Hint:  to show all detailed entries, enter zero (0) for the Minimum Absolute Amount, along with one or more Organization Codes.</REQUIRED_PARAMETERS_MESSAGE>
   </REPORT_TRANSLATIONS_ROW>
  </REPORT_TRANSLATIONS>
  <CATEGORY_ASSIGNMENTS>
   <CATEGORY_ASSIGNMENTS_ROW>
    <CATEGORY>Enginatics</CATEGORY>
   </CATEGORY_ASSIGNMENTS_ROW>
  </CATEGORY_ASSIGNMENTS>
  <ANCHORS>
   <ANCHORS_ROW>
    <ANCHOR>&amp;account_join</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>&amp;account_join_sla</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>&amp;category_columns</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>&amp;il_columns_amt</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>&amp;il_columns_rate</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>&amp;il_columns_tp</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>&amp;il_from</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>&amp;il_reg_columns</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>&amp;il_where</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>&amp;project_columns</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>&amp;project_joins</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>&amp;project_tables</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>&amp;segment_columns</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>&amp;sla_tables</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>&amp;wip_osp_columns</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>1=1</ANCHOR>
   </ANCHORS_ROW>
  </ANCHORS>
  <PARAMETERS>
   <PARAMETERS_ROW>
    <SORT_ORDER>1</SORT_ORDER>
    <DISPLAY_SEQUENCE>-110</DISPLAY_SEQUENCE>
    <ANCHOR>1=1</ANCHOR>
    <SQL_TEXT>:India_Localization=:India_Localization</SQL_TEXT>
    <PARAMETER_TYPE_DSP>Char</PARAMETER_TYPE_DSP>
    <MATCHING_VALUE>Y</MATCHING_VALUE>
    <DEFAULT_VALUE>xxen_util.jai_installed</DEFAULT_VALUE>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>India Localization</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>2</SORT_ORDER>
    <ANCHOR>&amp;il_columns_amt</ANCHOR>
    <SQL_TEXT>il_tax.cgst_amount &quot;CGST Amount&quot;,
il_tax.sgst_amount &quot;SGST Amount&quot;,
il_tax.igst_amount &quot;IGST Amount&quot;,
il_tax.cess_amount &quot;CESS Amount&quot;,
il_tax.custom_amount &quot;Custom Amount&quot;,
il_tax.unclassified_amount &quot;Unclassified Tax Amount&quot;,
il_tax.non_recoverable_gst &quot;Non-Recoverable GST&quot;,
il_tax.taxable_value &quot;Taxable Value&quot;,</SQL_TEXT>
    <MATCHING_VALUE>Y</MATCHING_VALUE>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>India Localization</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>3</SORT_ORDER>
    <ANCHOR>&amp;il_columns_rate</ANCHOR>
    <SQL_TEXT>il_tax.cgst_tax_rate &quot;CGST Rate&quot;,
il_tax.sgst_tax_rate &quot;SGST Rate&quot;,
il_tax.igst_tax_rate &quot;IGST Rate&quot;,
il_tax.cess_tax_rate &quot;CESS Rate&quot;,</SQL_TEXT>
    <MATCHING_VALUE>Y</MATCHING_VALUE>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>India Localization</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>4</SORT_ORDER>
    <ANCHOR>&amp;il_columns_tp</ANCHOR>
    <SQL_TEXT>xxen_util.meaning(il_tax.reverse_charge_flag,&apos;YES_NO&apos;,0) &quot;Reverse Charge Flag&quot;,
(select max(jtdf.ship_to_state) from jai_tax_det_factors jtdf where jtdf.trx_id=rt.shipment_header_id and jtdf.application_id=707) &quot;Place of Supply&quot;,
(select max(jtdf.ship_from_state) from jai_tax_det_factors jtdf where jtdf.trx_id=rt.shipment_header_id and jtdf.application_id=707) &quot;Ship From State&quot;,
(select max(jrc.reporting_code) from jai_tax_det_factors jtdf, jai_reporting_codes jrc where jtdf.trx_id=rt.shipment_header_id and jtdf.trx_line_id=rt.shipment_line_id and jtdf.application_id=707 and nvl(jtdf.hsn_code_id,jtdf.sac_code_id)=jrc.reporting_code_id) &quot;HSN SAC Code&quot;,
(select sum(jtl.rounded_tax_amt_fun_curr)
from jai_tax_lines jtl, mtl_system_items_b msib, mtl_secondary_inventories msi
where jtl.trx_loc_line_id=rt.transaction_id and
jtl.entity_code=&apos;RCV_TRANSACTION&apos; and
jtl.application_id=707 and
jtl.rounded_tax_amt_fun_curr&gt;0 and
nvl(jtl.self_assessed_flag,&apos;N&apos;)&lt;&gt;&apos;Y&apos; and
nvl(jtl.recoverable_flag,&apos;N&apos;)&lt;&gt;&apos;Y&apos; and
nvl(jtl.inclusive_flag,&apos;N&apos;)=&apos;N&apos; and
jtl.tax_point_basis=&apos;DELIVERY&apos; and
rt.transaction_type=&apos;DELIVER&apos; and
rt.destination_type_code=&apos;INVENTORY&apos; and
jtl.item_id=msib.inventory_item_id and
jtl.organization_id=msib.organization_id and
msib.inventory_asset_flag=&apos;Y&apos; and
msib.inventory_item_flag=&apos;Y&apos; and
rt.subinventory=msi.secondary_inventory_name and
jtl.organization_id=msi.organization_id and
msi.asset_inventory=1 and
not exists (select null from mtl_material_transactions mmt where mmt.source_code=&apos;Localization-Value Change&apos; and mmt.transaction_source_type_id=13 and mmt.transaction_action_id=24 and mmt.transaction_type_id=80 and mmt.transaction_reference=to_char(jtl.trx_loc_line_id))
) &quot;NR Tax Not In Item Cost&quot;</SQL_TEXT>
    <MATCHING_VALUE>Y</MATCHING_VALUE>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>India Localization</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>5</SORT_ORDER>
    <ANCHOR>&amp;il_from</ANCHOR>
    <SQL_TEXT>,(select jpr.party_id, jpr.party_site_id,
coalesce(max(case when jprl.regime_id in (select jr.regime_id from jai_regimes jr where jr.regime_type=&apos;T&apos;) and jprl.registration_type_code in (&apos;GST&apos;,&apos;GSTIN&apos;) then nvl(jprl.registration_number,jprl.secondary_registration_number) end),max(case when regexp_like(nvl(jprl.registration_number,jprl.secondary_registration_number),&apos;^[0-9]{2}[A-Z]{5}[0-9]{4}[A-Z][0-9A-Z]Z[0-9A-Z]$&apos;) and jprl.regime_id in (select jr.regime_id from jai_regimes jr where jr.regime_type=&apos;T&apos;) then nvl(jprl.registration_number,jprl.secondary_registration_number) end)) gstin,
max(decode(jprl.registration_type_code,&apos;PAN&apos;,jprl.registration_number)) pan_site,
max(decode(jprl.registration_type_code,&apos;TAN&apos;,jprl.registration_number)) tan_site,
max(decode(jprl.sec_registration_type_code,&apos;PAN&apos;,jprl.secondary_registration_number)) sec_pan_site,
max(decode(jprl.sec_registration_type_code,&apos;TAN&apos;,jprl.secondary_registration_number)) sec_tan_site
from jai_party_regs_v jpr, jai_party_reg_lines_v jprl
where jpr.party_reg_id=jprl.party_reg_id and jpr.party_type_code=&apos;THIRD_PARTY_SITE&apos; and jpr.supplier_flag=&apos;Y&apos;
and jprl.effective_from&lt;=sysdate and (jprl.effective_to is null or jprl.effective_to&gt;=sysdate)
group by jpr.party_id, jpr.party_site_id) il_reg_site
,(select jpr.party_id,
coalesce(max(case when jprl.regime_id in (select jr.regime_id from jai_regimes jr where jr.regime_type=&apos;T&apos;) and jprl.registration_type_code in (&apos;GST&apos;,&apos;GSTIN&apos;) then nvl(jprl.registration_number,jprl.secondary_registration_number) end),max(case when regexp_like(nvl(jprl.registration_number,jprl.secondary_registration_number),&apos;^[0-9]{2}[A-Z]{5}[0-9]{4}[A-Z][0-9A-Z]Z[0-9A-Z]$&apos;) and jprl.regime_id in (select jr.regime_id from jai_regimes jr where jr.regime_type=&apos;T&apos;) then nvl(jprl.registration_number,jprl.secondary_registration_number) end)) gstin_hdr,
max(decode(jprl.registration_type_code,&apos;PAN&apos;,jprl.registration_number)) pan_hdr,
max(decode(jprl.registration_type_code,&apos;TAN&apos;,jprl.registration_number)) tan_hdr,
max(decode(jprl.sec_registration_type_code,&apos;PAN&apos;,jprl.secondary_registration_number)) sec_pan_hdr,
max(decode(jprl.sec_registration_type_code,&apos;TAN&apos;,jprl.secondary_registration_number)) sec_tan_hdr
from jai_party_regs_v jpr, jai_party_reg_lines_v jprl
where jpr.party_reg_id=jprl.party_reg_id and jpr.party_type_code=&apos;THIRD_PARTY&apos; and jpr.supplier_flag=&apos;Y&apos;
and jprl.effective_from&lt;=sysdate and (jprl.effective_to is null or jprl.effective_to&gt;=sysdate)
group by jpr.party_id) il_reg_hdr
,(select
jtlv.trx_id,
sum(decode(jrav.reporting_code,&apos;CGST&apos;,jtlv.rounded_tax_amt_trx_curr)) cgst_amount,
sum(decode(jrav.reporting_code,&apos;SGST&apos;,jtlv.rounded_tax_amt_trx_curr)) sgst_amount,
sum(decode(jrav.reporting_code,&apos;IGST&apos;,jtlv.rounded_tax_amt_trx_curr)) igst_amount,
sum(decode(jrav.reporting_code,&apos;CESS&apos;,jtlv.rounded_tax_amt_trx_curr)) cess_amount,
sum(decode(jrav.reporting_code,&apos;CUSTOM&apos;,jtlv.rounded_tax_amt_trx_curr)) custom_amount,
sum(decode(jrav.reporting_code,null,jtlv.rounded_tax_amt_trx_curr)) unclassified_amount,
max(decode(jrav.reporting_code,&apos;CGST&apos;,jtlv.tax_rate_code)) cgst_tax_rate,
max(decode(jrav.reporting_code,&apos;SGST&apos;,jtlv.tax_rate_code)) sgst_tax_rate,
max(decode(jrav.reporting_code,&apos;IGST&apos;,jtlv.tax_rate_code)) igst_tax_rate,
max(decode(jrav.reporting_code,&apos;CESS&apos;,jtlv.tax_rate_code)) cess_tax_rate,
sum(decode(jrav.reporting_code,&apos;CGST&apos;,jtlv.rec_tax_amt_trx_curr)) cgst_rec_amount,
sum(decode(jrav.reporting_code,&apos;CGST&apos;,jtlv.nrec_tax_amt_trx_curr)) cgst_nrec_amount,
sum(decode(jrav.reporting_code,&apos;SGST&apos;,jtlv.rec_tax_amt_trx_curr)) sgst_rec_amount,
sum(decode(jrav.reporting_code,&apos;SGST&apos;,jtlv.nrec_tax_amt_trx_curr)) sgst_nrec_amount,
sum(decode(jrav.reporting_code,&apos;IGST&apos;,jtlv.rec_tax_amt_trx_curr)) igst_rec_amount,
sum(decode(jrav.reporting_code,&apos;IGST&apos;,jtlv.nrec_tax_amt_trx_curr)) igst_nrec_amount,
sum(case when jr.regime_type=&apos;T&apos; then jtlv.nrec_tax_amt_trx_curr end) non_recoverable_gst,
max(jtlv.self_assessed_flag) reverse_charge_flag,
sum(decode(jrav.reporting_code,&apos;CGST&apos;,jtlv.rounded_taxable_amt_trx_curr,&apos;IGST&apos;,jtlv.rounded_taxable_amt_trx_curr)) taxable_value,
max(jrc.reporting_code) hsn_sac_code
from
jai_tax_lines_v jtlv,
jai_reporting_associations_v jrav,
jai_tax_det_factors jtdf,
jai_reporting_codes jrc,
jai_tax_types jtt,
jai_regimes jr
where
jtlv.tax_type_id=jrav.entity_id(+) and
jrav.entity_code(+)=&apos;TAX_TYPE&apos; and
jrav.reporting_type_code(+)=&apos;TAX_TYPES_CLASSIFICATION&apos; and
jtlv.tax_type_id=jtt.tax_type_id(+) and
jtt.regime_id=jr.regime_id(+) and
jtlv.det_factor_id=jtdf.det_factor_id(+) and
jtdf.application_id(+)=707 and
nvl(jtdf.hsn_code_id,jtdf.sac_code_id)=jrc.reporting_code_id(+) and
jtlv.application_id=707
group by jtlv.trx_id
) il_tax</SQL_TEXT>
    <MATCHING_VALUE>Y</MATCHING_VALUE>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>India Localization</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>6</SORT_ORDER>
    <ANCHOR>&amp;il_reg_columns</ANCHOR>
    <SQL_TEXT>,nvl(il_reg_site.gstin,il_reg_hdr.gstin_hdr) &quot;GST Registration No&quot;,
nvl(il_reg_site.pan_site,nvl(il_reg_site.sec_pan_site,nvl(il_reg_hdr.pan_hdr,il_reg_hdr.sec_pan_hdr))) &quot;GST PAN No&quot;,
nvl(il_reg_site.tan_site,nvl(il_reg_site.sec_tan_site,nvl(il_reg_hdr.tan_hdr,il_reg_hdr.sec_tan_hdr))) &quot;GST TAN No&quot;,</SQL_TEXT>
    <MATCHING_VALUE>Y</MATCHING_VALUE>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>India Localization</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>7</SORT_ORDER>
    <ANCHOR>&amp;il_where</ANCHOR>
    <SQL_TEXT>and pha.vendor_site_id=il_reg_site.party_site_id(+) and pha.vendor_id=il_reg_hdr.party_id(+) and rt.shipment_header_id=il_tax.trx_id(+)</SQL_TEXT>
    <MATCHING_VALUE>Y</MATCHING_VALUE>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>India Localization</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>8</SORT_ORDER>
    <DISPLAY_SEQUENCE>-10</DISPLAY_SEQUENCE>
    <ANCHOR>&amp;segment_columns</ANCHOR>
    <SQL_TEXT>select
&apos;gcck.&apos;||lower(fifsv.application_column_name)||&apos; &quot;&apos;||substrb(fifsv.form_left_prompt_,1,xxen_report.max_column_length)||&apos;&quot;,&apos; text
from
(select xxen_util.init_cap(fifsv.form_left_prompt) form_left_prompt_, fifsv.* from fnd_id_flex_segments_vl fifsv) fifsv
where
fifsv.application_id=101 and
fifsv.id_flex_code=&apos;GL#&apos; and
fifsv.enabled_flag=&apos;Y&apos; and
fifsv.id_flex_num=(select fifsv0.id_flex_num from fnd_id_flex_structures_vl fifsv0 where fifsv0.application_id=101 and fifsv0.id_flex_code=&apos;GL#&apos; and fifsv0.id_flex_structure_name=:chart_of_accounts)
order by
fifsv.segment_num</SQL_TEXT>
    <PARAMETER_TYPE_DSP>LOV</PARAMETER_TYPE_DSP>
    <LOV_NAME>GL Chart of Accounts (inv org related)</LOV_NAME>
    <LOV_GUID>8E2FF36EDEC879D2E0530100007F1FF2</LOV_GUID>
    <LOV_QUERY_DSP>select
fifsv.id_flex_structure_name value,
fifsv.id_flex_structure_code description
from
fnd_id_flex_structures_vl fifsv
where
fifsv.id_flex_code=&apos;GL#&apos; and
fifsv.application_id=101 and
fifsv.id_flex_num in (select ood.chart_of_accounts_id from org_organization_definitions ood where nvl(ood.disable_date,sysdate + 1) &gt; sysdate)
order by
fifsv.id_flex_structure_name</LOV_QUERY_DSP>
    <DEFAULT_VALUE>select
fifsv.id_flex_structure_name
from
fnd_id_flex_structures_vl fifsv
where
fifsv.id_flex_code=&apos;GL#&apos; and
fifsv.application_id=101 and
fifsv.id_flex_num=(select ood.chart_of_accounts_id from org_organization_definitions ood where ood.organization_id=fnd_profile.value(&apos;MFG_ORGANIZATION_ID&apos;))</DEFAULT_VALUE>
    <REQUIRED>Y</REQUIRED>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Chart of Accounts</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>9</SORT_ORDER>
    <DISPLAY_SEQUENCE>10</DISPLAY_SEQUENCE>
    <ANCHOR>1=1</ANCHOR>
    <SQL_TEXT>rae.transaction_date&gt;=:p_trx_date_from</SQL_TEXT>
    <PARAMETER_TYPE_DSP>Date</PARAMETER_TYPE_DSP>
    <DEFAULT_VALUE>select max(oap.period_start_date)
from org_acct_periods oap,
 mtl_parameters   mp
where mp.organization_id = oap.organization_id
and mp.organization_id &lt;&gt; mp.master_organization_id</DEFAULT_VALUE>
    <REQUIRED>Y</REQUIRED>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Transaction Date From</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>10</SORT_ORDER>
    <DISPLAY_SEQUENCE>20</DISPLAY_SEQUENCE>
    <ANCHOR>1=1</ANCHOR>
    <SQL_TEXT>rae.transaction_date&lt;:p_trx_date_to+1</SQL_TEXT>
    <PARAMETER_TYPE_DSP>Date</PARAMETER_TYPE_DSP>
    <DEFAULT_VALUE>select max(oap.schedule_close_date)
from org_acct_periods oap,
 mtl_parameters   mp
where mp.organization_id = oap.organization_id
and mp.organization_id &lt;&gt; mp.master_organization_id</DEFAULT_VALUE>
    <REQUIRED>Y</REQUIRED>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Transaction Date To</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>11</SORT_ORDER>
    <DISPLAY_SEQUENCE>30</DISPLAY_SEQUENCE>
    <ANCHOR>&amp;sla_tables</ANCHOR>
    <SQL_TEXT>xla_distribution_links xdl,
xla_ae_lines xal,</SQL_TEXT>
    <PARAMETER_TYPE_DSP>LOV Oracle</PARAMETER_TYPE_DSP>
    <LOV_NAME>Yes_No</LOV_NAME>
    <LOV_QUERY_DSP>select
lookup_code id,
meaning value,
null description
from
fnd_lookups
where fnd_lookups.lookup_type=&apos;YES_NO&apos;
order by value,description</LOV_QUERY_DSP>
    <MATCHING_VALUE>Y</MATCHING_VALUE>
    <DEFAULT_VALUE>Y</DEFAULT_VALUE>
    <REQUIRED>Y</REQUIRED>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Show SLA Accounting</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>12</SORT_ORDER>
    <ANCHOR>&amp;account_join</ANCHOR>
    <SQL_TEXT>rrsl.code_combination_id=gcck.code_combination_id(+)</SQL_TEXT>
    <MATCHING_VALUE>N</MATCHING_VALUE>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Show SLA Accounting</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>13</SORT_ORDER>
    <ANCHOR>&amp;account_join_sla</ANCHOR>
    <SQL_TEXT>rrsl.rcv_sub_ledger_id=xdl.source_distribution_id_num_1 and
xdl.source_distribution_type=&apos;RCV_RECEIVING_SUB_LEDGER&apos; and
xdl.application_id=707 and
xdl.ae_header_id=xal.ae_header_id and
xdl.ae_line_num=xal.ae_line_num and
xdl.application_id=xal.application_id and
gl.ledger_id=xal.ledger_id and
xal.code_combination_id=gcck.code_combination_id(+)</SQL_TEXT>
    <MATCHING_VALUE>Y</MATCHING_VALUE>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Show SLA Accounting</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>14</SORT_ORDER>
    <DISPLAY_SEQUENCE>40</DISPLAY_SEQUENCE>
    <ANCHOR>&amp;project_columns</ANCHOR>
    <SQL_TEXT>ppa.segment1 project_number,
ppa.name project_name,
pt.task_number,
pt.task_name project_task,
pt.wbs_level,
pt.description task_description,</SQL_TEXT>
    <PARAMETER_TYPE_DSP>LOV Oracle</PARAMETER_TYPE_DSP>
    <LOV_NAME>Yes_No</LOV_NAME>
    <LOV_QUERY_DSP>select
lookup_code id,
meaning value,
null description
from
fnd_lookups
where fnd_lookups.lookup_type=&apos;YES_NO&apos;
order by value,description</LOV_QUERY_DSP>
    <MATCHING_VALUE>Y</MATCHING_VALUE>
    <DEFAULT_VALUE>N</DEFAULT_VALUE>
    <REQUIRED>Y</REQUIRED>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Show Project Information</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>15</SORT_ORDER>
    <ANCHOR>&amp;project_joins</ANCHOR>
    <SQL_TEXT>pda.project_id=ppa.project_id(+) and
pda.task_id=pt.task_id(+) and</SQL_TEXT>
    <MATCHING_VALUE>Y</MATCHING_VALUE>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Show Project Information</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>16</SORT_ORDER>
    <ANCHOR>&amp;project_tables</ANCHOR>
    <SQL_TEXT>pa_projects_all ppa,
pa_tasks pt,</SQL_TEXT>
    <MATCHING_VALUE>Y</MATCHING_VALUE>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Show Project Information</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>17</SORT_ORDER>
    <DISPLAY_SEQUENCE>50</DISPLAY_SEQUENCE>
    <ANCHOR>&amp;wip_osp_columns</ANCHOR>
    <SQL_TEXT>(select we.wip_entity_name from wip_entities we where rt.wip_entity_id=we.wip_entity_id) wip_job,
(select br.resource_code from bom_resources br where rt.bom_resource_id=br.resource_id) resource_code,</SQL_TEXT>
    <PARAMETER_TYPE_DSP>LOV Oracle</PARAMETER_TYPE_DSP>
    <LOV_NAME>Yes_No</LOV_NAME>
    <LOV_QUERY_DSP>select
lookup_code id,
meaning value,
null description
from
fnd_lookups
where fnd_lookups.lookup_type=&apos;YES_NO&apos;
order by value,description</LOV_QUERY_DSP>
    <MATCHING_VALUE>Y</MATCHING_VALUE>
    <DEFAULT_VALUE>N</DEFAULT_VALUE>
    <REQUIRED>Y</REQUIRED>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Show WIP Outside Processing</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>18</SORT_ORDER>
    <DISPLAY_SEQUENCE>60</DISPLAY_SEQUENCE>
    <ANCHOR>&amp;category_columns</ANCHOR>
    <SQL_TEXT>select xxen_util.item_category_columns(p_category_set_name=&gt;&apos;&lt;parameter_value&gt;&apos;, p_table_alias=&gt;&apos;rsl&apos;, p_item_id_column=&gt;&apos;item_id&apos;, p_org_id_column=&gt;&apos;to_organization_id&apos;) sql_text from dual</SQL_TEXT>
    <PARAMETER_TYPE_DSP>LOV</PARAMETER_TYPE_DSP>
    <LOV_NAME>INV Category Set</LOV_NAME>
    <LOV_GUID>8E2FF36EDECA79D2E0530100007F1FF2</LOV_GUID>
    <LOV_QUERY_DSP>select distinct
mcsv.category_set_name value,
mcsv.description
from
mtl_category_sets_vl mcsv
where
:$flex$.organization_code is null or
mcsv.category_set_id in (select mic.category_set_id from mtl_parameters mp, mtl_item_categories mic where xxen_util.contains(:$flex$.organization_code,mp.organization_code)=&apos;Y&apos; and mp.organization_id=mic.organization_id)
order by
mcsv.category_set_name</LOV_QUERY_DSP>
    <DEFAULT_VALUE>coalesce(xxen_util.previous_parameter_value(:parameter_id),(select mdsv.category_set_name from mtl_default_sets_view mdsv where mdsv.functional_area_id=11))</DEFAULT_VALUE>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Category Set 1</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>19</SORT_ORDER>
    <DISPLAY_SEQUENCE>70</DISPLAY_SEQUENCE>
    <ANCHOR>&amp;category_columns</ANCHOR>
    <SQL_TEXT>select xxen_util.item_category_columns(p_category_set_name=&gt;&apos;&lt;parameter_value&gt;&apos;, p_table_alias=&gt;&apos;rsl&apos;, p_item_id_column=&gt;&apos;item_id&apos;, p_org_id_column=&gt;&apos;to_organization_id&apos;) sql_text from dual</SQL_TEXT>
    <PARAMETER_TYPE_DSP>LOV</PARAMETER_TYPE_DSP>
    <LOV_NAME>INV Category Set</LOV_NAME>
    <LOV_GUID>8E2FF36EDECA79D2E0530100007F1FF2</LOV_GUID>
    <LOV_QUERY_DSP>select distinct
mcsv.category_set_name value,
mcsv.description
from
mtl_category_sets_vl mcsv
where
:$flex$.organization_code is null or
mcsv.category_set_id in (select mic.category_set_id from mtl_parameters mp, mtl_item_categories mic where xxen_util.contains(:$flex$.organization_code,mp.organization_code)=&apos;Y&apos; and mp.organization_id=mic.organization_id)
order by
mcsv.category_set_name</LOV_QUERY_DSP>
    <DEFAULT_VALUE>coalesce(xxen_util.previous_parameter_value(:parameter_id),(select mdsv.category_set_name from mtl_default_sets_view mdsv where mdsv.functional_area_id=5))</DEFAULT_VALUE>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Category Set 2</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>20</SORT_ORDER>
    <DISPLAY_SEQUENCE>80</DISPLAY_SEQUENCE>
    <ANCHOR>&amp;category_columns</ANCHOR>
    <SQL_TEXT>select xxen_util.item_category_columns(p_category_set_name=&gt;&apos;&lt;parameter_value&gt;&apos;, p_table_alias=&gt;&apos;rsl&apos;, p_item_id_column=&gt;&apos;item_id&apos;, p_org_id_column=&gt;&apos;to_organization_id&apos;) sql_text from dual</SQL_TEXT>
    <PARAMETER_TYPE_DSP>LOV</PARAMETER_TYPE_DSP>
    <LOV_NAME>INV Category Set</LOV_NAME>
    <LOV_GUID>8E2FF36EDECA79D2E0530100007F1FF2</LOV_GUID>
    <LOV_QUERY_DSP>select distinct
mcsv.category_set_name value,
mcsv.description
from
mtl_category_sets_vl mcsv
where
:$flex$.organization_code is null or
mcsv.category_set_id in (select mic.category_set_id from mtl_parameters mp, mtl_item_categories mic where xxen_util.contains(:$flex$.organization_code,mp.organization_code)=&apos;Y&apos; and mp.organization_id=mic.organization_id)
order by
mcsv.category_set_name</LOV_QUERY_DSP>
    <DEFAULT_VALUE>xxen_util.previous_parameter_value(:parameter_id)</DEFAULT_VALUE>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Category Set 3</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>21</SORT_ORDER>
    <DISPLAY_SEQUENCE>90</DISPLAY_SEQUENCE>
    <ANCHOR>1=1</ANCHOR>
    <SQL_TEXT>xxen_util.meaning(rt.transaction_type,&apos;RCV TRANSACTION TYPE&apos;,201)=:p_transaction_type</SQL_TEXT>
    <PARAMETER_TYPE_DSP>LOV</PARAMETER_TYPE_DSP>
    <LOV_NAME>RCV Transaction Type</LOV_NAME>
    <LOV_GUID>E7C3CD67B84B2AEFE0530100007FA2E5</LOV_GUID>
    <LOV_QUERY_DSP>select
flvv.meaning value,
flvv.description
from
fnd_lookup_values_vl flvv
where
flvv.lookup_type=&apos;RCV TRANSACTION TYPE&apos; and
flvv.security_group_id=0 and
flvv.enabled_flag=&apos;Y&apos;
order by
flvv.meaning,
flvv.description</LOV_QUERY_DSP>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Transaction Type</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>22</SORT_ORDER>
    <DISPLAY_SEQUENCE>100</DISPLAY_SEQUENCE>
    <ANCHOR>1=1</ANCHOR>
    <SQL_TEXT>abs(nvl(rrsl.accounted_dr,0)-nvl(rrsl.accounted_cr,0))&gt;=:p_minimum_amount</SQL_TEXT>
    <PARAMETER_TYPE_DSP>Number</PARAMETER_TYPE_DSP>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Minimum Absolute Amount</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>23</SORT_ORDER>
    <DISPLAY_SEQUENCE>110</DISPLAY_SEQUENCE>
    <ANCHOR>1=1</ANCHOR>
    <SQL_TEXT>aps.vendor_name=:p_supplier_name</SQL_TEXT>
    <PARAMETER_TYPE_DSP>LOV</PARAMETER_TYPE_DSP>
    <LOV_NAME>AP Supplier</LOV_NAME>
    <LOV_GUID>B9847D20A0E4742FE0538931640A6379</LOV_GUID>
    <LOV_QUERY_DSP>select
aps.vendor_name value,
aps.segment1 description
from
ap_suppliers aps
where
(:$flex$.operating_unit is null or aps.vendor_id in (select assa.vendor_id from hr_all_organization_units_vl haouv, ap_supplier_sites_all assa where xxen_util.contains(:$flex$.operating_unit,haouv.name)=&apos;Y&apos; and haouv.organization_id=assa.org_id)) and
(:$flex$.organization_code is null or aps.vendor_id in (select assa.vendor_id from org_organization_definitions ood, ap_supplier_sites_all assa where xxen_util.contains(:$flex$.organization_code,ood.organization_code)=&apos;Y&apos; and ood.operating_unit=assa.org_id))
order by
aps.vendor_name,
aps.vendor_id</LOV_QUERY_DSP>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Supplier Name</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>24</SORT_ORDER>
    <DISPLAY_SEQUENCE>120</DISPLAY_SEQUENCE>
    <ANCHOR>1=1</ANCHOR>
    <SQL_TEXT>pha.segment1=:p_po_number</SQL_TEXT>
    <PARAMETER_TYPE_DSP>LOV</PARAMETER_TYPE_DSP>
    <LOV_NAME>CAC PO Number</LOV_NAME>
    <LOV_GUID>6CD916F8AF474C5FB41CD477C8B373D4</LOV_GUID>
    <LOV_QUERY_DSP>select
pha.segment1 value,
xxen_util.meaning(pha.type_lookup_code,&apos;PO TYPE&apos;,201)||nvl2(aps.vendor_name,&apos;: &apos;||aps.vendor_name,null) description
from
po_headers_all pha,
ap_suppliers aps
where pha.org_id in 
(select haouv.organization_id from hr_all_organization_units_vl haouv
 where haouv.organization_id in 
 (select to_number(hoi.org_information3)
  from mtl_parameters mp,
  hr_organization_information hoi,
  hr_all_organization_units haou
  where mp.organization_id&lt;&gt;mp.master_organization_id
  and mp.organization_id=hoi.organization_id
  and hoi.org_information_context=&apos;Accounting Information&apos;
  and hoi.organization_id=haou.organization_id
  and nvl(haou.date_to,sysdate)&gt;=sysdate
))
and pha.vendor_id=aps.vendor_id(+)
order by
pha.creation_date desc</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_ROW>
    <SORT_ORDER>25</SORT_ORDER>
    <DISPLAY_SEQUENCE>130</DISPLAY_SEQUENCE>
    <ANCHOR>1=1</ANCHOR>
    <SQL_TEXT>xxen_util.meaning(pda.destination_type_code,&apos;DESTINATION TYPE&apos;,201)=:p_dest_type_code</SQL_TEXT>
    <PARAMETER_TYPE_DSP>LOV</PARAMETER_TYPE_DSP>
    <LOV_NAME>PO Requisition Destination Type</LOV_NAME>
    <LOV_GUID>E0E902FE6FE5309CE0530100007F091E</LOV_GUID>
    <LOV_QUERY_DSP>select
plc.lookup_code id,
plc.displayed_field value,
plc.displayed_field description
from
po_lookup_codes plc 
where
plc.lookup_type=&apos;DESTINATION TYPE&apos;
order by
value</LOV_QUERY_DSP>
    <ID_OR_VALUE>value</ID_OR_VALUE>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Destination Code</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>26</SORT_ORDER>
    <DISPLAY_SEQUENCE>140</DISPLAY_SEQUENCE>
    <ANCHOR>1=1</ANCHOR>
    <SQL_TEXT>msiv.concatenated_segments=:p_item_number</SQL_TEXT>
    <PARAMETER_TYPE_DSP>LOV</PARAMETER_TYPE_DSP>
    <LOV_NAME>INV Item</LOV_NAME>
    <LOV_GUID>8E2FF36EDEF179D2E0530100007F1FF2</LOV_GUID>
    <LOV_QUERY_DSP>select
msiv.concatenated_segments value,
msiv.description||&apos; (&apos;||mp.organization_code||&apos;)&apos; description
from
mtl_system_items_vl msiv,
mtl_parameters mp
where
(
:$flex$.organization_code is null and (
fnd_profile.value(&apos;MFG_ORGANIZATION_ID&apos;) is null and msiv.organization_id in (select xroa.id from xxen_report_org_access xroa where xroa.access_type=&apos;INV&apos;) or
msiv.organization_id=fnd_profile.value(&apos;MFG_ORGANIZATION_ID&apos;)
) or
xxen_util.contains(:$flex$.organization_code,mp.organization_code)=&apos;Y&apos;
) and
msiv.organization_id=mp.organization_id
order by
mp.organization_code,
msiv.concatenated_segments</LOV_QUERY_DSP>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Item Number</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>27</SORT_ORDER>
    <DISPLAY_SEQUENCE>150</DISPLAY_SEQUENCE>
    <ANCHOR>1=1</ANCHOR>
    <SQL_TEXT>mp.organization_code=:p_org_code</SQL_TEXT>
    <PARAMETER_TYPE_DSP>LOV custom</PARAMETER_TYPE_DSP>
    <LOV_QUERY_DSP>select
ood.organization_code value,
ood.organization_name description
from
org_organization_definitions ood
where
ood.organization_id not in (select mp.organization_id from mtl_parameters mp where mp.organization_id=mp.master_organization_id) and
ood.organization_id in (select xroa.id from xxen_report_org_access xroa where xroa.access_type=&apos;INV&apos;) and
(:$flex$.operating_unit is null or ood.operating_unit in (select haouv.organization_id from hr_all_organization_units_vl haouv where xxen_util.contains(:$flex$.operating_unit,haouv.name)=&apos;Y&apos;)) and
(:$flex$.ledger is null or ood.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)=&apos;Y&apos;)) and
nvl(ood.disable_date,sysdate)&gt;=sysdate
order by
ood.organization_code</LOV_QUERY_DSP>
    <DEFAULT_VALUE>select mp.organization_code from mtl_parameters mp where mp.organization_id=fnd_profile.value(&apos;MFG_ORGANIZATION_ID&apos;)</DEFAULT_VALUE>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Organization Code</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>28</SORT_ORDER>
    <DISPLAY_SEQUENCE>160</DISPLAY_SEQUENCE>
    <ANCHOR>1=1</ANCHOR>
    <SQL_TEXT>haouv.name=:p_operating_unit</SQL_TEXT>
    <PARAMETER_TYPE_DSP>LOV</PARAMETER_TYPE_DSP>
    <LOV_NAME>INV Operating Unit</LOV_NAME>
    <LOV_GUID>9B9627743E84607DE053BB6B635805FB</LOV_GUID>
    <LOV_QUERY_DSP>select
haouv.name value,
&apos;Operating Unit&apos; description
from
hr_all_organization_units_vl haouv
where
haouv.organization_id in
(
select
to_number(hoi.org_information3)
from
mtl_parameters mp,
hr_organization_information hoi,
hr_all_organization_units haou
where
mp.organization_id&lt;&gt;mp.master_organization_id and
mp.organization_id in (select xroa.id from xxen_report_org_access xroa where xroa.access_type=&apos;INV&apos;) and
mp.organization_id=hoi.organization_id and
hoi.org_information_context=&apos;Accounting Information&apos; and
(:$flex$.ledger is null or to_number(hoi.org_information1) in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)=&apos;Y&apos;)) and
hoi.organization_id=haou.organization_id and
nvl(haou.date_to,sysdate)&gt;=sysdate
)
order by 1</LOV_QUERY_DSP>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Operating Unit</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>29</SORT_ORDER>
    <DISPLAY_SEQUENCE>170</DISPLAY_SEQUENCE>
    <ANCHOR>1=1</ANCHOR>
    <SQL_TEXT>gl.name=:p_ledger</SQL_TEXT>
    <PARAMETER_TYPE_DSP>LOV</PARAMETER_TYPE_DSP>
    <LOV_NAME>GL Ledger (inv org related)</LOV_NAME>
    <LOV_GUID>8E2FF36EDF3A79D2E0530100007F1FF2</LOV_GUID>
    <LOV_QUERY_DSP>select
gl.name value,
fifsv.id_flex_structure_name||&apos;: &apos;||gl.description description
from
gl_ledgers gl,
fnd_id_flex_structures_vl fifsv
where
gl.ledger_id in (select ood.set_of_books_id from org_organization_definitions ood where nvl(ood.disable_date,sysdate)&gt;=sysdate and ood.organization_id in (select xroa.id from xxen_report_org_access xroa where xroa.access_type=&apos;INV&apos;)) and
(:$flex$.chart_of_accounts is null or xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)=&apos;Y&apos;) and
gl.chart_of_accounts_id=fifsv.id_flex_num and
fifsv.id_flex_code=&apos;GL#&apos; and
fifsv.application_id=101
order by
fifsv.id_flex_structure_name,
gl.name</LOV_QUERY_DSP>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Ledger</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
  </PARAMETERS>
  <TEMPLATES>
  </TEMPLATES>
  <DEFAULT_TEMPLATES>
  </DEFAULT_TEMPLATES>
  <UPLOAD_COLUMNS>
  </UPLOAD_COLUMNS>
  <UPLOAD_PARAMETERS>
  </UPLOAD_PARAMETERS>
  <UPLOAD_SQLS>
  </UPLOAD_SQLS>
 </REPORTS_ROW>
</REPORTS>
</ROOT>
