View: CLN_INVENTORY_REPORT_V

Product:	CLN - Supply Chain Trading Connector for RosettaNet
Description:	This view is used for mapping purposes in PIP-4C1
Implementation/DBA Data:	APPS.CLN_INVENTORY_REPORT_V

View Text

SELECT DISTINCT MSIB.START_DATE_ACTIVE
, MSIB.INVENTORY_ITEM_STATUS_CODE
, MSIB.ITEM_TYPE
, MSIB.PRIMARY_UOM_CODE
, MSIB.INVENTORY_ITEM_ID
, MSIB.ATTRIBUTE_CATEGORY
, MSIB.ATTRIBUTE1
, MSIB.ATTRIBUTE2
, MSIB.ATTRIBUTE3
, MSIB.ATTRIBUTE4
, MSIB.ATTRIBUTE5
, MSIB.ATTRIBUTE6
, MSIB.ATTRIBUTE7
, MSIB.ATTRIBUTE8
, MSIB.ATTRIBUTE9
, MSIB.ATTRIBUTE10
, MSIB.ATTRIBUTE11
, MSIB.ATTRIBUTE12
, MSIB.ATTRIBUTE13
, MSIB.ATTRIBUTE14
, MSIB.ATTRIBUTE15
, MSIB.END_DATE_ACTIVE
, MSIT.DESCRIPTION
, MIR.REVISION_ID
, MIR.REVISION
, MSIB.ORGANIZATION_ID
, HAOU.NAME
, HLA.ECE_TP_LOCATION_CODE
, HLA.ADDRESS_LINE_1
, HLA.ADDRESS_LINE_2
, HLA.ADDRESS_LINE_3
, HLA.TOWN_OR_CITY
, HLA.COUNTRY
, HLA.POSTAL_CODE
, MSIBK.CONCATENATED_SEGMENTS
, MSIB.REVISION_QTY_CONTROL_CODE
, MSIB.LOT_CONTROL_CODE
FROM MTL_SYSTEM_ITEMS_B MSIB
, MTL_SYSTEM_ITEMS_TL MSIT
, MTL_ITEM_REVISIONS MIR
, HR_ALL_ORGANIZATION_UNITS HAOU
, HR_LOCATIONS_ALL HLA
, MTL_SYSTEM_ITEMS_VL MSIBK
WHERE ( MSIB.INVENTORY_ITEM_ID = MSIT.INVENTORY_ITEM_ID
AND MSIB.ORGANIZATION_ID = MSIT.ORGANIZATION_ID )
AND ( MSIB.INVENTORY_ITEM_ID = MSIBK.INVENTORY_ITEM_ID
AND MSIB.ORGANIZATION_ID = MSIBK.ORGANIZATION_ID )
AND ( DECODE( MSIB.REVISION_QTY_CONTROL_CODE
, 1
, NULL
, MSIB.INVENTORY_ITEM_ID) = MIR.INVENTORY_ITEM_ID(+)
AND MSIB.ORGANIZATION_ID = MIR.ORGANIZATION_ID(+) )
AND (HAOU.LOCATION_ID = HLA.LOCATION_ID)
AND (MSIB.ORGANIZATION_ID = HAOU.ORGANIZATION_ID)

Columns