View: INVFV_ABC_ASSIGNMENTS

Product:	INV - Inventory
Description:	- Retrofitted
Implementation/DBA Data:	APPS.INVFV_ABC_ASSIGNMENTS

View Text

SELECT MAA.ASSIGNMENT_GROUP_ID
, MAG.ASSIGNMENT_GROUP_NAME
, MAA.ABC_CLASS_ID
, MAC.ABC_CLASS_NAME
, MAA.INVENTORY_ITEM_ID
, '_KF:INV:MSTK:MSI' /* KEYFLEX */
, MAG.ORGANIZATION_ID
, MP.ORGANIZATION_CODE
, HOU.NAME
, MAA.CREATED_BY
, MAA.CREATION_DATE
, MAA.LAST_UPDATED_BY
, MAA.LAST_UPDATE_DATE
FROM MTL_PARAMETERS MP
, HR_ALL_ORGANIZATION_UNITS HOU
, MTL_SYSTEM_ITEMS MSI
, MTL_ABC_CLASSES MAC
, MTL_ABC_ASSIGNMENT_GROUPS MAG
, MTL_ABC_ASSIGNMENTS MAA
WHERE MAG.ASSIGNMENT_GROUP_ID = MAA.ASSIGNMENT_GROUP_ID
AND MAC.ABC_CLASS_ID = MAA.ABC_CLASS_ID
AND MSI.ORGANIZATION_ID = MAG.ORGANIZATION_ID
AND MSI.INVENTORY_ITEM_ID = MAA.INVENTORY_ITEM_ID
AND MP.ORGANIZATION_ID = MAG.ORGANIZATION_ID
AND HOU.ORGANIZATION_ID = MAG.ORGANIZATION_ID
AND '_SEC:MAG.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

Columns