VIEW: APPS.OKS_SERV_PRODEXC_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'