View: OKS_SERV_PRODEXC_V

Product:	OKS - Service Contracts
Description:	View for Service Product exceptions
Implementation/DBA Data:	APPS.OKS_SERV_PRODEXC_V

View Text

SELECT EXC.ID
, EXC.SAV_ID
, EXC.OBJECT1_ID1
, EXC.OBJECT1_ID2
, EXC.JTOT_OBJECT1_CODE
, EXC.OBJECT_VERSION_NUMBER
, EXC.MANUFACTURING_ORG_ID
, EXC.REVISION_LOW
, EXC.REVISION_HIGH
, EXC.START_DATE_ACTIVE
, EXC.END_DATE_ACTIVE
, EXC.ATTRIBUTE_CATEGORY
, EXC.ATTRIBUTE1
, EXC.ATTRIBUTE2
, EXC.ATTRIBUTE3
, EXC.ATTRIBUTE4
, EXC.ATTRIBUTE5
, EXC.ATTRIBUTE6
, EXC.ATTRIBUTE7
, EXC.ATTRIBUTE8
, EXC.ATTRIBUTE9
, EXC.ATTRIBUTE10
, EXC.ATTRIBUTE11
, EXC.ATTRIBUTE12
, EXC.ATTRIBUTE13
, EXC.ATTRIBUTE14
, EXC.ATTRIBUTE15
, EXC.CREATED_BY
, EXC.CREATION_DATE
, EXC.LAST_UPDATED_BY
, EXC.LAST_UPDATE_DATE
, EXC.LAST_UPDATE_LOGIN
, PRD.NAME PRODUCT_ITEM
, PRD.DESCRIPTION PRODUCT_DESCRIPTION
, PRD.ORGANIZATION_ID ORGANIZATION_ID
FROM OKS_SERV_AVAIL_EXCEPTS EXC
, OKX_SYSTEM_ITEMS_V PRD
WHERE PRD.ID1 = EXC.OBJECT1_ID1
AND EXC.JTOT_OBJECT1_CODE = 'OKX_SYSITEM'

Columns