Product: | MRP - Master Scheduling/MRP |
---|---|
Description: | Sourcing rule assignments view |
Implementation/DBA Data: | APPS.MRP_SR_ASSIGNMENTS_V |
SELECT MSRA.ROWID ROW_ID
, MSRA.ASSIGNMENT_ID
, MSRA.ASSIGNMENT_SET_ID
, MSRA.ASSIGNMENT_TYPE
, MSRA.ORGANIZATION_ID
, DECODE(MSRA.ASSIGNMENT_TYPE
, 1
, NULL
, 2
, NULL
, 3
, NULL
, 4
, MRP_GET_PROJECT.ORG_CODE(MSRA.ORGANIZATION_ID)
, 5
, MRP_GET_PROJECT.ORG_CODE(MSRA.ORGANIZATION_ID)
, 6
, MRP_GET_PROJECT.ORG_CODE(MSRA.ORGANIZATION_ID)
, NULL) ORGANIZATION_CODE
, MSRA.CUSTOMER_ID
, MRP_GET_PROJECT.CUSTOMER_NAME(MSRA.CUSTOMER_ID)
, MSRA.SHIP_TO_SITE_ID
, MRP_GET_PROJECT.SHIP_TO_ADDRESS(MSRA.SHIP_TO_SITE_ID) SHIP_TO_ADDRESS
, DECODE(MSRA.ASSIGNMENT_TYPE
, 1
, NULL
, 2
, MRP_GET_PROJECT.CATEGORY_NAME(MSRA.CATEGORY_ID)
, 3
, MRP_GET_PROJECT.ITEM_NAME(MSRA.ORGANIZATION_ID
, MSRA.INVENTORY_ITEM_ID)
, 4
, NULL
, 5
, MRP_GET_PROJECT.CATEGORY_NAME(MSRA.CATEGORY_ID)
, 6
, MRP_GET_PROJECT.ITEM_NAME(MSRA.ORGANIZATION_ID
, MSRA.INVENTORY_ITEM_ID)
, NULL) ENTITY_NAME
, DECODE(MSRA.ASSIGNMENT_TYPE
, 1
, NULL
, 2
, MRP_GET_PROJECT.CATEGORY_DESC(MSRA.CATEGORY_SET_ID
, MSRA.CATEGORY_ID)
, 3
, MRP_GET_PROJECT.ITEM_DESC(MSRA.ORGANIZATION_ID
, MSRA.INVENTORY_ITEM_ID)
, 4
, NULL
, 5
, MRP_GET_PROJECT.CATEGORY_DESC(MSRA.CATEGORY_SET_ID
, MSRA.CATEGORY_ID)
, 6
, MRP_GET_PROJECT.ITEM_DESC(MSRA.ORGANIZATION_ID
, MSRA.INVENTORY_ITEM_ID)
, NULL) DESCRIPTION
, MSRA.SOURCING_RULE_TYPE
, MRP_GET_PROJECT.LOOKUP_MEANING('MRP_SOURCING_RULE_TYPE'
, MSRA.SOURCING_RULE_TYPE) SOURCING_RULE_TYPE_TEXT
, MSRA.SOURCING_RULE_ID
, MSR.SOURCING_RULE_NAME
, MSRA.CATEGORY_ID
, MSRA.CATEGORY_SET_ID
, MSRA.INVENTORY_ITEM_ID
, MSRA.SECONDARY_INVENTORY
, MSRA.LAST_UPDATE_DATE
, MSRA.LAST_UPDATED_BY
, MSRA.CREATION_DATE
, MSRA.CREATED_BY
, MSRA.LAST_UPDATE_LOGIN
, MSRA.REQUEST_ID
, MSRA.PROGRAM_APPLICATION_ID
, MSRA.PROGRAM_ID
, MSRA.PROGRAM_UPDATE_DATE
, MSRA.ATTRIBUTE_CATEGORY
, MSRA.ATTRIBUTE1
, MSRA.ATTRIBUTE2
, MSRA.ATTRIBUTE3
, MSRA.ATTRIBUTE4
, MSRA.ATTRIBUTE5
, MSRA.ATTRIBUTE6
, MSRA.ATTRIBUTE7
, MSRA.ATTRIBUTE8
, MSRA.ATTRIBUTE9
, MSRA.ATTRIBUTE10
, MSRA.ATTRIBUTE11
, MSRA.ATTRIBUTE12
, MSRA.ATTRIBUTE13
, MSRA.ATTRIBUTE14
, MSRA.ATTRIBUTE15
FROM MRP_SOURCING_RULES MSR
, MRP_SR_ASSIGNMENTS MSRA
WHERE MSR.SOURCING_RULE_ID = MSRA.SOURCING_RULE_ID