VIEW: APPS.CSD_DC_DOMAINS_V

Source

View Text - Preformatted

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 (+)

View Text - HTML Formatted

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 (+)