ECC Product Information Management, Item Cross-Reference

➜ Back to Library
Description
Categories: Enterprise Command Center
Imported from Enterprise Command Center
Dataset Key: inv-cross-ref
Query Procedure: INV_ECC_ITEM_UTIL_PVT.GET_ECC_DATA_LOAD_INFO
Security Procedure: INV_ITEM_ECC_DATASECURITY_PKG.GetFilterAttributeValues
select
x.*
from
(
SELECT *
  FROM (
    SELECT
      ECC_SPEC_ID,
      INVENTORY_ITEM_ID,
      ORGANIZATION_ID,
      ITEM,
      ORG_CODE,
      DESCRIPTION,
      CROSS_REFERENCE_TYPE,
      CROSS_REFERENCE_VALUE,
      LANGUAGE
 
    FROM
      MTL_ITEM_ECC_CROSS_REF_V mtl_v 
      where language in ('US')  )
      PIVOT (
      MAX(DESCRIPTION) AS DESCRIPTION
      for LANGUAGE in ('US' "US"))
) x
where
2=2
Parameter NameSQL textValidation
Organization Code
x.org_code=:organization_code
LOV
Download
Related Blitz Reports
ECC Projects, Projects Costing: Transactions, SQL1 ECC Enterprise Asset Management, Stores Materials (Maintenance), SQL1 CAC Internal Order Shipment Margin ECC iStore, iStore Search CAC Purchase Price Variance ECC Procurement, Requisitions ECC Sourcing, Negotiations, SQL2 ECC Sourcing, Negotiations, SQL1 AP Invoices and Lines - Test
Blitz Report™