[Home] [Help]
View: 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 |