FND Design Data [Home] [Help]

View: INVBV_ABC_ASSGN_GROUP_CLASSES

Product: INV - Inventory
Description: - Retrofitted
Implementation/DBA Data: ViewAPPS.INVBV_ABC_ASSGN_GROUP_CLASSES
View Text

SELECT MGC.ASSIGNMENT_GROUP_ID
, MGC.ABC_CLASS_ID
, MAC.ORGANIZATION_ID
, MGC.SEQUENCE_NUMBER
, MGC.ITEM_SEQ_NUMBER
, MGC.PERCENT_OF_ITEMS
, MGC.PERCENT_OF_VALUE
, MGC.CREATED_BY
, MGC.CREATION_DATE
, MGC.LAST_UPDATED_BY
, MGC.LAST_UPDATE_DATE
FROM MTL_ABC_CLASSES MAC
, MTL_ABC_ASSGN_GROUP_CLASSES MGC
WHERE MAC.ABC_CLASS_ID = MGC.ABC_CLASS_ID
AND '_SEC:MAC.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

Columns

Name
ABC_ASSIGNMENT_GROUP_ID
ABC_CLASS_ID
ORGANIZATION_ID
PRIORITY
ITEM_SEQUENCE_NUMBER
PERCENT_OF_ITEMS
PERCENT_OF_VALUE
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE