FND Design Data [Home] [Help]

View: INVBV_ABC_ASSIGNMENT_GROUPS

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

SELECT MAG.ASSIGNMENT_GROUP_ID
, MAG.ASSIGNMENT_GROUP_NAME
, MAG.ORGANIZATION_ID
, MAG.COMPILE_ID
, MAG.SECONDARY_INVENTORY
, '_LA:MAG.ITEM_SCOPE_TYPE:MFG_LOOKUPS:MTL_ABC_ITEM_SCOPE:MEANING' /* LOOKUP */
, MAG.CREATED_BY
, MAG.CREATION_DATE
, MAG.LAST_UPDATED_BY
, MAG.LAST_UPDATE_DATE
FROM MTL_ABC_ASSIGNMENT_GROUPS MAG
WHERE '_SEC:MAG.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

Columns

Name
ABC_ASSIGNMENT_GROUP_ID
ABC_ASSIGNMENT_GROUP_NAME
ORGANIZATION_ID
ABC_COMPILE_ID
SUBINVENTORY_NAME
"_LA:VALUATION_SCOPE"
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE