<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 Shipping Networks Missing Interco OU Relationships -->
 <REPORTS_ROW>
  <GUID>A3BFC166CC697F77E053BB6B6358CAD3</GUID><ENABLED>Y</ENABLED>
  <SQL_TEXT>select
nvl(gl.short_name,gl.name) ledger,
haouv_ou_from.name from_operating_unit,
mp_from.organization_code from_org_code,
haouv_from.name from_org_name,
haouv_ou_to.name to_operating_unit,
mp_to.organization_code to_org_code,
decode(mip.intransit_type,1,xxen_util.meaning(&apos;DIRECT&apos;,&apos;PV_PURCHASE_METHOD&apos;,0),2,xxen_util.meaning(&apos;3&apos;,&apos;MSC_CALENDAR_TYPE&apos;,700)) intransit_type,
xxen_util.meaning(mip.fob_point,&apos;MTL_FOB_POINT&apos;,700) fob_point,
xxen_util.yes(decode(mip.internal_order_required_flag,1,&apos;Y&apos;)) internal_order_required,
xxen_util.yes(mip.elemental_visibility_enabled) elemental_visibility,
xxen_util.yes(mip.manual_receipt_expense) manual_receipt_at_expense_dest
from
mtl_interorg_parameters mip,
mtl_parameters mp_from,
hr_organization_information hoi_from,
hr_all_organization_units_vl haouv_from,
hr_all_organization_units_vl haouv_ou_from,
gl_ledgers gl,
mtl_parameters mp_to,
hr_organization_information hoi_to,
hr_all_organization_units_vl haouv_ou_to
where
mip.intransit_type in (1,2) and
mip.from_organization_id=mp_from.organization_id and
mp_from.organization_id=hoi_from.organization_id and
hoi_from.org_information_context=&apos;Accounting Information&apos; and
hoi_from.organization_id=haouv_from.organization_id and
nvl(haouv_from.date_to,sysdate+1)&gt;sysdate and
to_number(hoi_from.org_information3)=haouv_ou_from.organization_id and
to_number(hoi_from.org_information1)=gl.ledger_id and
mip.to_organization_id=mp_to.organization_id and
mp_to.organization_id=hoi_to.organization_id and
hoi_to.org_information_context=&apos;Accounting Information&apos; and
to_number(hoi_to.org_information3)=haouv_ou_to.organization_id and
haouv_ou_from.organization_id&lt;&gt;haouv_ou_to.organization_id and
(haouv_ou_from.organization_id,haouv_ou_to.organization_id) not in (select mip2.ship_organization_id, mip2.sell_organization_id from mtl_intercompany_parameters mip2)
order by
ledger,
from_operating_unit,
from_org_code,
to_operating_unit,
to_org_code</SQL_TEXT>
  <VERSION_COMMENTS>Rebuilt to the Blitz Report SQL standards. FOB Point is reported, and a relationship without a price list counts as existing. Setup report without organization security, so that every user sees the setup of all organizations.</VERSION_COMMENTS>
  <REPORT_TRANSLATIONS>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>US</LANGUAGE>
    <REPORT_NAME>CAC Shipping Networks Missing Interco OU Relationships</REPORT_NAME>
    <DESCRIPTION>Report to show the missing inventory intercompany operating unit relationships.  This report has no parameters.

/* +=============================================================================+
-- |  Copyright 2009 - 2020 Douglas Volz Consulting, Inc.                        |
-- |  All rights reserved.                                                       |
-- |  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_missing_interco_setups_for_shipping_networks_v1.sql
-- |
-- |  Parameters:
-- |  None
-- | 
-- |  Description:
-- |  Report to show the missing inventory intercompany operating unit relationships.
-- | 
-- |  Version Modified on Modified  by   Description
-- |  ======= =========== ============== =========================================
-- |  1.0     16 Oct 2018 Douglas Volz   Initial Coding
-- |  1.1     11 Apr 2019 Douglas Volz   Revert to Release 12
-- |  1.2     29 Apr 2020 Douglas Volz   Changed to multi-language views for the 
-- |                                     inventory orgs and operating units.
-- |  1.3     23 Oct 2026 Andy Haack    Rebuilt to the Blitz Report SQL standards.
-- +=============================================================================+*/</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
  </REPORT_TRANSLATIONS>
  <CATEGORY_ASSIGNMENTS>
   <CATEGORY_ASSIGNMENTS_ROW>
    <CATEGORY>Enginatics</CATEGORY>
   </CATEGORY_ASSIGNMENTS_ROW>
  </CATEGORY_ASSIGNMENTS>
  <ANCHORS>
  </ANCHORS>
  <PARAMETERS>
  </PARAMETERS>
  <TEMPLATES>
  </TEMPLATES>
  <DEFAULT_TEMPLATES>
  </DEFAULT_TEMPLATES>
  <UPLOAD_COLUMNS>
  </UPLOAD_COLUMNS>
  <UPLOAD_PARAMETERS>
  </UPLOAD_PARAMETERS>
  <UPLOAD_SQLS>
  </UPLOAD_SQLS>
 </REPORTS_ROW>
</REPORTS>
</ROOT>
