VIEW: APPS.MTH_SRC_ITEMS_V

Source

View Text - Preformatted

SELECT ITEM_PK, SYSTEM_FK, SOURCE_ORG_CODE, ITEM_NAME, PRIMARY_UOM, SECONDARY_UOM, EBS_ITEM_ID, EBS_ORG_ID, DESCRIPTION, UNIT_WEIGHT, WEIGHT_UOM, UNIT_VOLUME, VOLUME_UOM, BASE_ITEM, USER_ATTR1, USER_ATTR2, USER_ATTR3, USER_ATTR4, USER_ATTR5, USER_ATTR6, USER_ATTR7, USER_ATTR8, USER_ATTR9, USER_ATTR10, USER_ATTR11, USER_ATTR12, USER_ATTR13, USER_ATTR14, USER_ATTR15, USER_ATTR16, USER_ATTR17, USER_ATTR18, USER_ATTR19, USER_ATTR20, USER_MEASURE1, USER_MEASURE2, USER_MEASURE3, USER_MEASURE4, USER_MEASURE5, USER_ATTR21, USER_ATTR22, USER_ATTR23, USER_ATTR24, USER_ATTR25, USER_ATTR26, USER_ATTR27, USER_ATTR28, USER_ATTR29, USER_ATTR30, LAST_UPDATE_DATE, END_DATE_ACTIVE FROM ( SELECT CAST(NULL AS VARCHAR2(150)) ITEM_PK, fnd_profile.value('MTH_EBS_GLOBAL_NAME') SYSTEM_FK, mp.ORGANIZATION_CODE SOURCE_ORG_CODE, msi.CONCATENATED_SEGMENTS ITEM_NAME, msi.primary_uom_code PRIMARY_UOM, msi.secondary_uom_code SECONDARY_UOM, msi.inventory_item_id EBS_ITEM_ID, msi.organization_id EBS_ORG_ID, msi.description DESCRIPTION, msi.unit_weight UNIT_WEIGHT, msi.weight_uom_code WEIGHT_UOM, msi.unit_volume UNIT_VOLUME, msi.volume_uom_code VOLUME_UOM, (SELECT msib.CONCATENATED_SEGMENTS FROM MTL_SYSTEM_ITEMS_B_KFV msib WHERE msi.BASE_ITEM_ID = msib.inventory_item_id AND msi.ORGANIZATION_ID = msib.ORGANIZATION_ID AND msi.INVENTORY_ITEM_FLAG = 'Y' AND msi.STOCK_ENABLED_FLAG = 'Y' AND msi.MTL_TRANSACTIONS_ENABLED_FLAG = 'Y' AND msi.BOM_ITEM_TYPE IN (1,4) AND msi.SERVICE_ITEM_FLAG = 'N') BASE_ITEM, msi.attribute1 USER_ATTR1, msi.attribute2 USER_ATTR2, msi.attribute3 USER_ATTR3, msi.attribute4 USER_ATTR4, msi.attribute5 USER_ATTR5, msi.attribute6 USER_ATTR6, msi.attribute7 USER_ATTR7, msi.attribute8 USER_ATTR8, msi.attribute9 USER_ATTR9, msi.attribute10 USER_ATTR10, msi.attribute11 USER_ATTR11, msi.attribute12 USER_ATTR12, msi.attribute13 USER_ATTR13, msi.attribute14 USER_ATTR14, msi.attribute15 USER_ATTR15, msi.attribute16 USER_ATTR16, msi.attribute17 USER_ATTR17, msi.attribute18 USER_ATTR18, msi.attribute19 USER_ATTR19, msi.attribute20 USER_ATTR20, NULL USER_MEASURE1, NULL USER_MEASURE2, NULL USER_MEASURE3, NULL USER_MEASURE4, NULL USER_MEASURE5, msi.attribute21 USER_ATTR21, msi.attribute22 USER_ATTR22, msi.attribute23 USER_ATTR23, msi.attribute24 USER_ATTR24, msi.attribute25 USER_ATTR25, msi.attribute26 USER_ATTR26, msi.attribute27 USER_ATTR27, msi.attribute28 USER_ATTR28, msi.attribute29 USER_ATTR29, msi.attribute30 USER_ATTR30, msi.last_update_date LAST_UPDATE_DATE, msi.END_DATE_ACTIVE END_DATE_ACTIVE FROM MTL_SYSTEM_ITEMS_B_KFV msi, MTL_PARAMETERS mp WHERE msi.organization_id = mp.organization_id AND msi.INVENTORY_ITEM_FLAG = 'Y' AND msi.STOCK_ENABLED_FLAG = 'Y' AND msi.MTL_TRANSACTIONS_ENABLED_FLAG = 'Y' AND msi.BOM_ITEM_TYPE IN (1,4) AND msi.SERVICE_ITEM_FLAG = 'N')

View Text - HTML Formatted

SELECT ITEM_PK
, SYSTEM_FK
, SOURCE_ORG_CODE
, ITEM_NAME
, PRIMARY_UOM
, SECONDARY_UOM
, EBS_ITEM_ID
, EBS_ORG_ID
, DESCRIPTION
, UNIT_WEIGHT
, WEIGHT_UOM
, UNIT_VOLUME
, VOLUME_UOM
, BASE_ITEM
, USER_ATTR1
, USER_ATTR2
, USER_ATTR3
, USER_ATTR4
, USER_ATTR5
, USER_ATTR6
, USER_ATTR7
, USER_ATTR8
, USER_ATTR9
, USER_ATTR10
, USER_ATTR11
, USER_ATTR12
, USER_ATTR13
, USER_ATTR14
, USER_ATTR15
, USER_ATTR16
, USER_ATTR17
, USER_ATTR18
, USER_ATTR19
, USER_ATTR20
, USER_MEASURE1
, USER_MEASURE2
, USER_MEASURE3
, USER_MEASURE4
, USER_MEASURE5
, USER_ATTR21
, USER_ATTR22
, USER_ATTR23
, USER_ATTR24
, USER_ATTR25
, USER_ATTR26
, USER_ATTR27
, USER_ATTR28
, USER_ATTR29
, USER_ATTR30
, LAST_UPDATE_DATE
, END_DATE_ACTIVE
FROM ( SELECT CAST(NULL AS VARCHAR2(150)) ITEM_PK
, FND_PROFILE.VALUE('MTH_EBS_GLOBAL_NAME') SYSTEM_FK
, MP.ORGANIZATION_CODE SOURCE_ORG_CODE
, MSI.CONCATENATED_SEGMENTS ITEM_NAME
, MSI.PRIMARY_UOM_CODE PRIMARY_UOM
, MSI.SECONDARY_UOM_CODE SECONDARY_UOM
, MSI.INVENTORY_ITEM_ID EBS_ITEM_ID
, MSI.ORGANIZATION_ID EBS_ORG_ID
, MSI.DESCRIPTION DESCRIPTION
, MSI.UNIT_WEIGHT UNIT_WEIGHT
, MSI.WEIGHT_UOM_CODE WEIGHT_UOM
, MSI.UNIT_VOLUME UNIT_VOLUME
, MSI.VOLUME_UOM_CODE VOLUME_UOM
, (SELECT MSIB.CONCATENATED_SEGMENTS
FROM MTL_SYSTEM_ITEMS_B_KFV MSIB
WHERE MSI.BASE_ITEM_ID = MSIB.INVENTORY_ITEM_ID
AND MSI.ORGANIZATION_ID = MSIB.ORGANIZATION_ID
AND MSI.INVENTORY_ITEM_FLAG = 'Y'
AND MSI.STOCK_ENABLED_FLAG = 'Y'
AND MSI.MTL_TRANSACTIONS_ENABLED_FLAG = 'Y'
AND MSI.BOM_ITEM_TYPE IN (1
, 4)
AND MSI.SERVICE_ITEM_FLAG = 'N') BASE_ITEM
, MSI.ATTRIBUTE1 USER_ATTR1
, MSI.ATTRIBUTE2 USER_ATTR2
, MSI.ATTRIBUTE3 USER_ATTR3
, MSI.ATTRIBUTE4 USER_ATTR4
, MSI.ATTRIBUTE5 USER_ATTR5
, MSI.ATTRIBUTE6 USER_ATTR6
, MSI.ATTRIBUTE7 USER_ATTR7
, MSI.ATTRIBUTE8 USER_ATTR8
, MSI.ATTRIBUTE9 USER_ATTR9
, MSI.ATTRIBUTE10 USER_ATTR10
, MSI.ATTRIBUTE11 USER_ATTR11
, MSI.ATTRIBUTE12 USER_ATTR12
, MSI.ATTRIBUTE13 USER_ATTR13
, MSI.ATTRIBUTE14 USER_ATTR14
, MSI.ATTRIBUTE15 USER_ATTR15
, MSI.ATTRIBUTE16 USER_ATTR16
, MSI.ATTRIBUTE17 USER_ATTR17
, MSI.ATTRIBUTE18 USER_ATTR18
, MSI.ATTRIBUTE19 USER_ATTR19
, MSI.ATTRIBUTE20 USER_ATTR20
, NULL USER_MEASURE1
, NULL USER_MEASURE2
, NULL USER_MEASURE3
, NULL USER_MEASURE4
, NULL USER_MEASURE5
, MSI.ATTRIBUTE21 USER_ATTR21
, MSI.ATTRIBUTE22 USER_ATTR22
, MSI.ATTRIBUTE23 USER_ATTR23
, MSI.ATTRIBUTE24 USER_ATTR24
, MSI.ATTRIBUTE25 USER_ATTR25
, MSI.ATTRIBUTE26 USER_ATTR26
, MSI.ATTRIBUTE27 USER_ATTR27
, MSI.ATTRIBUTE28 USER_ATTR28
, MSI.ATTRIBUTE29 USER_ATTR29
, MSI.ATTRIBUTE30 USER_ATTR30
, MSI.LAST_UPDATE_DATE LAST_UPDATE_DATE
, MSI.END_DATE_ACTIVE END_DATE_ACTIVE
FROM MTL_SYSTEM_ITEMS_B_KFV MSI
, MTL_PARAMETERS MP
WHERE MSI.ORGANIZATION_ID = MP.ORGANIZATION_ID
AND MSI.INVENTORY_ITEM_FLAG = 'Y'
AND MSI.STOCK_ENABLED_FLAG = 'Y'
AND MSI.MTL_TRANSACTIONS_ENABLED_FLAG = 'Y'
AND MSI.BOM_ITEM_TYPE IN (1
, 4)
AND MSI.SERVICE_ITEM_FLAG = 'N')