Product: | MSC - Advanced Supply Chain Planning |
---|---|
Description: | This view shows the allocation assignments |
Implementation/DBA Data: | APPS.MSC_ALLOCATION_ASSIGNMENTS_V |
SELECT ASSIGNMENT_ID
, ASSIGNMENT_TYPE
, INVENTORY_ITEM_ID
, MSC_GET_NAME.ITEM_NAME(INVENTORY_ITEM_ID
, NULL
, NULL
, NULL)
, CATEGORY_SET_ID
, CATEGORY_NAME
, SR_INSTANCE_ID
, ORGANIZATION_ID
, MSC_GET_NAME.ORG_CODE(ORGANIZATION_ID
, SR_INSTANCE_ID)
, DEPARTMENT_ID
, RESOURCE_ID
, NULL
, NULL
, RESOURCE_GROUP
, NULL
, ALLOCATION_RULE_NAME
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
FROM MSC_ALLOCATION_ASSIGNMENTS