Product: | ENG - Engineering |
---|---|
Description: | The view holds the item level item information |
Implementation/DBA Data: | APPS.EDWBV_ITEM_ITEM_LCV |
SELECT '_KF:INV:MSTK:MTI'
, MTI.INVENTORY_ITEM_ID||'-'||MTI.ORGANIZATION_ID||'-'||INST.INSTANCE_CODE
, INST.INSTANCE_CODE
, 'NA_EDW'
, 'NA_EDW'
, 'NA_EDW'
, 'NA_EDW'
, SUBSTR(MTI.CONCATENATED_SEGMENTS||'('||MTP.ORGANIZATION_CODE||')'
, 1
, 240)
, SUBSTR(MTI.CONCATENATED_SEGMENTS||'('||MTP.ORGANIZATION_CODE||')'
, 1
, 80)
, SUBSTR(MTI.CONCATENATED_SEGMENTS||'('||MTP.ORGANIZATION_CODE||')'
, 1
, 240)
, MTI.DESCRIPTION
, MTI.ORGANIZATION_ID
, MTI.INVENTORY_ITEM_ID
, MTI.LAST_UPDATE_DATE
, MTI.CREATION_DATE
, NULL
, '_DF:INV:MTL_SYSTEM_ITEMS:MTI'
FROM MTL_SYSTEM_ITEMS_KFV MTI
, MTL_PARAMETERS MTP
, EDW_LOCAL_INSTANCE INST
WHERE MTP.ORGANIZATION_ID = MTP.MASTER_ORGANIZATION_ID
AND MTI.ORGANIZATION_ID = MTP.ORGANIZATION_ID WITH READ ONLY