ECC Product Information Management, Item Revisions

Description

Categories: Enterprise Command Center
Columns: Ecc Spec Id, Inventory Item Id, Organization Id, Item, Org Code, Revision Reasons, Current Revision, Revisions, Revision Label, Effectivity Date ...

Imported from Enterprise Command Center
Dataset Key: inv-item-revisions
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,
      REVISION_REASONS,
      CURRENT_REVISION,
      REVISIONS,
      REVISION_LABEL,
      EFFECTIVITY_DATE,
      IMPLEMENTATION_DATE,
      CHANGE_NOTICE,
      LANGUAGE,
      PENDING_CHANGE,
      'OA_MEDIA/action_link' as ITEM_ATTACHMENT
	  , ITMREVDFF.* 
    FROM
      MTL_ITEM_ECC_REVISIONS_V  mtl_v , (select ROW_ID "'ITMREVDFFROW_ID'",CONTEXT "'ITMREVDFFCONTEXT'",CONCATENATED_SEGMENTS "'ITMREVDFFCONCATENATED_SEGMENTS'" from MTL_ITEM_REVISIONS_B_DFV) ITMREVDFF
      where language in ('US') AND ITMREVDFF."'ITMREVDFFROW_ID'"(+) = ITEM_REV_ROWID)
      PIVOT (MAX(DESCRIPTION) AS DESCRIPTION
      for LANGUAGE in ('US' "US"))
) x
where
2=2