Product: | CSD - Depot Repair |
---|---|
Description: | View that displays the mapping between Diagnostic Codes and Product Categories. |
Implementation/DBA Data: | APPS.CSD_DC_DOMAINS_V |
SELECT CDCD.ROWID
, CDCD.DC_DOMAIN_ID
, CDCD.OBJECT_VERSION_NUMBER
, CDCD.DIAGNOSTIC_CODE_ID
, CDCD.CREATED_BY
, CDCD.CREATION_DATE
, CDCD.LAST_UPDATED_BY
, CDCD.LAST_UPDATE_DATE
, CDCD.LAST_UPDATE_LOGIN
, CDCD.DOMAIN_TYPE_CODE
, FND.MEANING
, CDCD.INVENTORY_ITEM_ID
, MSI.CONCATENATED_SEGMENTS
, MSI.DESCRIPTION
, CDCD.CATEGORY_ID
, MC.CATEGORY_CONCAT_SEGS
, MC.DESCRIPTION
, CDCD.CATEGORY_SET_ID
, MCS.CATEGORY_SET_NAME
, MCS.DESCRIPTION
, CDCD.ATTRIBUTE_CATEGORY
, CDCD.ATTRIBUTE1
, CDCD.ATTRIBUTE2
, CDCD.ATTRIBUTE3
, CDCD.ATTRIBUTE4
, CDCD.ATTRIBUTE5
, CDCD.ATTRIBUTE6
, CDCD.ATTRIBUTE7
, CDCD.ATTRIBUTE8
, CDCD.ATTRIBUTE9
, CDCD.ATTRIBUTE10
, CDCD.ATTRIBUTE11
, CDCD.ATTRIBUTE12
, CDCD.ATTRIBUTE13
, CDCD.ATTRIBUTE14
, CDCD.ATTRIBUTE15
FROM CSD_DC_DOMAINS CDCD
, 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 CDCD.DOMAIN_TYPE_CODE = FND.LOOKUP_CODE
AND MSI.ORGANIZATION_ID (+) = CS_STD.GET_ITEM_VALDN_ORGZN_ID
AND CDCD.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID (+)
AND DECODE(CDCD.DOMAIN_TYPE_CODE
, 'ITEM'
, CDCD.INVENTORY_ITEM_ID
, -99) = DECODE(CDCD.DOMAIN_TYPE_CODE
, 'ITEM'
, MSI.INVENTORY_ITEM_ID
, -99)
AND CDCD.CATEGORY_ID = MC.CATEGORY_ID (+)
AND CDCD.CATEGORY_SET_ID = MCS.CATEGORY_SET_ID (+)