View: CLN_ITEMMST_ABC_V

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

View Text

SELECT MAA.INVENTORY_ITEM_ID
, MAC.ABC_CLASS_NAME
, MAC.ABC_CLASS_ID
, MAAG.ASSIGNMENT_GROUP_NAME
, MAAG.ASSIGNMENT_GROUP_ID
FROM MTL_ABC_ASSIGNMENTS MAA
, MTL_ABC_CLASSES MAC
, MTL_ABC_ASSIGNMENT_GROUPS MAAG
WHERE MAA.ABC_CLASS_ID = MAC.ABC_CLASS_ID
AND MAA.ASSIGNMENT_GROUP_ID = MAAG.ASSIGNMENT_GROUP_ID

Columns