View: INVBV_ABC_ASSIGNMENTS

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

View Text

SELECT MAA.ASSIGNMENT_GROUP_ID
, MAA.ABC_CLASS_ID
, MAA.INVENTORY_ITEM_ID
, MAG.ORGANIZATION_ID
, MAA.CREATED_BY
, MAA.CREATION_DATE
, MAA.LAST_UPDATED_BY
, MAA.LAST_UPDATE_DATE
FROM MTL_ABC_ASSIGNMENT_GROUPS MAG
, MTL_ABC_ASSIGNMENTS MAA
WHERE MAG.ASSIGNMENT_GROUP_ID = MAA.ASSIGNMENT_GROUP_ID
AND '_SEC:MAG.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

Columns