VIEW: APPS.OKS_MASSCHANGE_CRITERIA_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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