[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 |