Product: | OKS - Service Contracts |
---|---|
Description: | View for Service Availability Exceptions and Parties |
Implementation/DBA Data: | APPS.OKS_SERV_CUSTEXC_V |
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
, PARTY.PARTY_NUMBER ACCOUNT_NUMBER
, PARTY.NAME ACCOUNT_NAME
, PARTY.STATUS CUST_STATUS
FROM OKS_SERV_AVAIL_EXCEPTS EXC
, OKX_PARTIES_V PARTY
WHERE PARTY.ID1 = EXC.OBJECT1_ID1
AND EXC.JTOT_OBJECT1_CODE = 'OKX_PARTY'