View: CLN_ITEMMST_ITEMHEADER_V

Product:	CLN - Supply Chain Trading Connector for RosettaNet
Description:	View for the Header section of the Sync Item XML message
Implementation/DBA Data:	APPS.CLN_ITEMMST_ITEMHEADER_V

View Text

SELECT MSIB.INVENTORY_ITEM_ID
, MSIB.START_DATE_ACTIVE
, MSIB.UNIT_HEIGHT
, MSIB.DIMENSION_UOM_CODE
, MSIB.UNIT_LENGTH
, MSIB.UNIT_VOLUME
, MSIB.VOLUME_UOM_CODE
, MSIB.UNIT_WEIGHT
, MSIB.WEIGHT_UOM_CODE
, MSIB.UNIT_WIDTH
, MSIB.CONCATENATED_SEGMENTS
, MSIB.ITEM_TYPE
, MSIB.PRIMARY_UOM_CODE
, MSIB.BOM_ITEM_TYPE
, MSIB.INVENTORY_ITEM_STATUS_CODE
, MSIB.ORGANIZATION_ID
, MSIB.COST_OF_SALES_ACCOUNT
, MSIB.SAFETY_STOCK_BUCKET_DAYS
, MSIB.CUMULATIVE_TOTAL_LEAD_TIME
, MSIB.PLANNING_TIME_FENCE_DAYS
, MSIB.MINIMUM_ORDER_QUANTITY
, 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.DESCRIPTION ITEM_DESCRIPTION
, MIR.REVISION
, MIR.EFFECTIVITY_DATE
, MSIB.ITEM_CATALOG_GROUP_ID
, MCI.CUSTOMER_ITEM_NUMBER
, MCI.CUSTOMER_ID
, PHCT.HAZARD_CLASS
FROM MTL_SYSTEM_ITEMS_VL MSIB
, MTL_CUSTOMER_ITEM_XREFS_V MCI
, MTL_ITEM_REVISIONS MIR
, PO_HAZARD_CLASSES_TL PHCT
WHERE MSIB.INVENTORY_ITEM_ID = MCI.INVENTORY_ITEM_ID(+)
AND MCI.CUSTOMER_ID(+) = CLN_SYNCITEM_PKG.GET_CUST_ACCT_ID ()
AND MSIB.INVENTORY_ITEM_ID = MIR.INVENTORY_ITEM_ID(+)
AND MSIB.ORGANIZATION_ID = MIR.ORGANIZATION_ID(+)
AND MSIB.SERVICE_ITEM_FLAG = 'N'
AND MSIB.INVENTORY_ITEM_FLAG = 'Y'
AND MSIB.CUSTOMER_ORDER_ENABLED_FLAG = 'Y'
AND MSIB.HAZARD_CLASS_ID = PHCT.HAZARD_CLASS_ID(+)
AND MIR.REVISION = (SELECT MAX (REVISION)
FROM MTL_ITEM_REVISIONS
WHERE INVENTORY_ITEM_ID = MIR.INVENTORY_ITEM_ID
AND ORGANIZATION_ID = MIR.ORGANIZATION_ID)
AND PHCT.LANGUAGE(+) = USERENV ('LANG')
AND ( ( NVL (FND_PROFILE.VALUE ('CLN_ITEM_SEND_CUST_XREF_ONLY')
, 'N') = 'Y'
AND MCI.CUSTOMER_ITEM_NUMBER IS NOT NULL ) OR NVL (FND_PROFILE.VALUE ('CLN_ITEM_SEND_CUST_XREF_ONLY')
, 'N') ='N' )

Columns