VIEW: APPS.IEX_CASES_V

Source

View Text - Preformatted

SELECT CASE.CAS_ID , CASE.CASE_NUMBER , CASE.ORIG_CAS_ID , CASE.STATUS_CODE , CASE.CASE_STATE , CASE.ACTIVE_FLAG , CASE.OBJECT_VERSION_NUMBER , CASE.CASE_ESTABLISHED_DATE , CASE.CASE_CLOSING_DATE , CASE.OWNER_RESOURCE_ID , NAME.SOURCE_NAME , CASE.ACCESS_RESOURCE_ID , CASE.REQUEST_ID , CASE.PROGRAM_APPLICATION_ID , CASE.PROGRAM_ID , CASE.PROGRAM_UPDATE_DATE , CASE.ORG_ID , MO_GLOBAL.GET_OU_NAME(CASE.ORG_ID) OPERATING_UNIT, CASE.CREATED_BY , CASE.CREATION_DATE , CASE.LAST_UPDATED_BY , CASE.LAST_UPDATE_DATE , CASE.LAST_UPDATE_LOGIN , CASE.CLOSE_REASON , CASE.PARTY_ID , DEF.COLUMN_VALUE, DEF2.COLUMN_VALUE, null FROM IEX_CASES CASE , JTF_RS_RESOURCE_EXTNS NAME , IEX_CASE_DEFINITIONS DEF , IEX_CASE_DEFINITIONS DEF2 WHERE NAME.RESOURCE_ID(+) = CASE.OWNER_RESOURCE_ID AND CASE.CAS_ID = DEF.CAS_ID(+) AND DEF.COLUMN_NAME(+) = 'CUSTOMER_ACCOUNT' AND CASE.CAS_ID = DEF2.CAS_ID(+) AND DEF2.COLUMN_NAME(+) = 'BILL_TO_ADDRESS_ID'

View Text - HTML Formatted

SELECT CASE.CAS_ID
, CASE.CASE_NUMBER
, CASE.ORIG_CAS_ID
, CASE.STATUS_CODE
, CASE.CASE_STATE
, CASE.ACTIVE_FLAG
, CASE.OBJECT_VERSION_NUMBER
, CASE.CASE_ESTABLISHED_DATE
, CASE.CASE_CLOSING_DATE
, CASE.OWNER_RESOURCE_ID
, NAME.SOURCE_NAME
, CASE.ACCESS_RESOURCE_ID
, CASE.REQUEST_ID
, CASE.PROGRAM_APPLICATION_ID
, CASE.PROGRAM_ID
, CASE.PROGRAM_UPDATE_DATE
, CASE.ORG_ID
, MO_GLOBAL.GET_OU_NAME(CASE.ORG_ID) OPERATING_UNIT
, CASE.CREATED_BY
, CASE.CREATION_DATE
, CASE.LAST_UPDATED_BY
, CASE.LAST_UPDATE_DATE
, CASE.LAST_UPDATE_LOGIN
, CASE.CLOSE_REASON
, CASE.PARTY_ID
, DEF.COLUMN_VALUE
, DEF2.COLUMN_VALUE
, NULL
FROM IEX_CASES CASE
, JTF_RS_RESOURCE_EXTNS NAME
, IEX_CASE_DEFINITIONS DEF
, IEX_CASE_DEFINITIONS DEF2
WHERE NAME.RESOURCE_ID(+) = CASE.OWNER_RESOURCE_ID
AND CASE.CAS_ID = DEF.CAS_ID(+)
AND DEF.COLUMN_NAME(+) = 'CUSTOMER_ACCOUNT'
AND CASE.CAS_ID = DEF2.CAS_ID(+)
AND DEF2.COLUMN_NAME(+) = 'BILL_TO_ADDRESS_ID'