Product: | CSD - Depot Repair |
---|---|
Description: | View that displays the mapping between Service Codes and Product Categories. |
Implementation/DBA Data: | APPS.CSD_SC_DOMAINS_V |
SELECT CSCD.ROWID
, CSCD.SC_DOMAIN_ID
, CSCD.OBJECT_VERSION_NUMBER
, CSCD.SERVICE_CODE_ID
, CSCD.CREATED_BY
, CSCD.CREATION_DATE
, CSCD.LAST_UPDATED_BY
, CSCD.LAST_UPDATE_DATE
, CSCD.LAST_UPDATE_LOGIN
, CSCD.DOMAIN_TYPE_CODE
, FND.MEANING
, CSCD.INVENTORY_ITEM_ID
, MSI.CONCATENATED_SEGMENTS
, MSI.DESCRIPTION
, CSCD.CATEGORY_ID
, MC.CATEGORY_CONCAT_SEGS
, MC.DESCRIPTION
, CSCD.CATEGORY_SET_ID
, MCS.CATEGORY_SET_NAME
, MCS.DESCRIPTION
, CSCD.ATTRIBUTE_CATEGORY
, CSCD.ATTRIBUTE1
, CSCD.ATTRIBUTE2
, CSCD.ATTRIBUTE3
, CSCD.ATTRIBUTE4
, CSCD.ATTRIBUTE5
, CSCD.ATTRIBUTE6
, CSCD.ATTRIBUTE7
, CSCD.ATTRIBUTE8
, CSCD.ATTRIBUTE9
, CSCD.ATTRIBUTE10
, CSCD.ATTRIBUTE11
, CSCD.ATTRIBUTE12
, CSCD.ATTRIBUTE13
, CSCD.ATTRIBUTE14
, CSCD.ATTRIBUTE15
FROM CSD_SC_DOMAINS CSCD
, MTL_CATEGORIES_V MC
, MTL_CATEGORY_SETS_V MCS
, MTL_SYSTEM_ITEMS_KFV MSI
, FND_LOOKUPS FND
WHERE FND.LOOKUP_TYPE = 'CSD_DOMAIN_TYPE_CODE'
AND CSCD.DOMAIN_TYPE_CODE = FND.LOOKUP_CODE
AND MSI.ORGANIZATION_ID (+) = CS_STD.GET_ITEM_VALDN_ORGZN_ID
AND CSCD.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID (+)
AND DECODE(CSCD.DOMAIN_TYPE_CODE
, 'ITEM'
, CSCD.INVENTORY_ITEM_ID
, -99) = DECODE(CSCD.DOMAIN_TYPE_CODE
, 'ITEM'
, MSI.INVENTORY_ITEM_ID
, -99)
AND CSCD.CATEGORY_ID = MC.CATEGORY_ID (+)
AND CSCD.CATEGORY_SET_ID = MCS.CATEGORY_SET_ID (+)