ECC Product Information Management, Manufactured Items

Description

Categories: Enterprise Command Center
Columns: Ecc Spec Id, Inventory Item Id, Organization Id, Item, Org Code, Manufacturers, Manufacturer Part Numbers, 'Itemmanfdffrow Id', 'Itemmanfdffcontext Value', 'Itemmanfdffaml Frequency' ...

Imported from Enterprise Command Center
Dataset Key: inv-item-manufactures
Query Procedure: INV_ECC_ITEM_UTIL_PVT.GET_ECC_DATA_LOAD_INFO
Security Procedure: INV_ITEM_ECC_DATASECURITY_PKG.GetFilterAttributeValues

Copy

select
x.*
from
(
SELECT *
  FROM (
    SELECT
      ECC_SPEC_ID,
      INVENTORY_ITEM_ID,
      ORGANIZATION_ID,
      ITEM,
      ORG_CODE,
      DESCRIPTION,
      MANUFACTURERS,
      MANUFACTURER_PART_NUMBERS,
      LANGUAGE
	  , ITEMMANFDFF.* 
    FROM
      MTL_ITEM_ECC_MANF_V  mtl_v , (select ROW_ID "'ITEMMANFDFFROW_ID'",CONTEXT_VALUE "'ITEMMANFDFFCONTEXT_VALUE'",AML_FREQUENCY "'ITEMMANFDFFAML_FREQUENCY'",TOTAL_3_MONTHS_USAGE "'ITEMMANFDFFTOTAL_3_MONTHS_USAGE'",CONCATENATED_SEGMENTS "'ITEMMANFDFFCONCATENATED_SEGMENTS'" from MTL_MFG_PART_NUMBERS_DFV) ITEMMANFDFF where language in ('US') AND ITEMMANFDFF."'ITEMMANFDFFROW_ID'"(+) = ITEM_MANF_ROWID)
      PIVOT (MAX(DESCRIPTION) AS DESCRIPTION
      for LANGUAGE in ('US' "US"))
) x
where
2=2