Product: | OKS - Service Contracts |
---|---|
Description: | This view is used in Masschange UI to avoid the co mplexity in coding and querying purposes |
Implementation/DBA Data: | APPS.OKS_MASSCHANGE_CRITERIA_V |
SELECT OIE.ID OIE_ID
, OIE.NAME NAME
, OIE.COP_ID COP_ID
, OIE.STATUS_CODE STATUS_CODE
, OIE.REQUEST_ID REQUEST_ID
, OIE.JTOT_OBJECT1_CODE JTOT_OBJECT1_CODE
, OIE.OBJECT1_ID1 OBJECT1_ID1
, OIE.OBJECT1_ID2 OBJECT1_ID2
, MRD.ID MRD_ID
, MRD.ATTRIBUTE_NAME ATTRIBUTE_NAME
, MRD.OLD_VALUE OLD_VALUE
, MRD.NEW_VALUE NEW_VALUE
, OIE.CREATED_BY CREATED_BY
, OIE.CREATION_DATE CREATION_DATE
, OIE.LAST_UPDATED_BY LAST_UPDATED_BY
, OIE.LAST_UPDATE_DATE LAST_UPDATE_DATE
, OIE.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM OKC_OPERATION_INSTANCES_V OIE
, OKC_MASSCHANGE_REQ_DTLS_V MRD
WHERE OIE.ID = MRD.OIE_ID(+)
AND MRD.OLE_ID IS NULL