VIEW: APPS.CSD_SC_DOMAINS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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