VIEW: APPS.IBY_F_T_CA_STATUS_H_V

Source

View Text - Preformatted

SELECT STH.STATUS_HISTORY_ID, STH.REQUEST_ID, STH.PROGRAM_APPLICATION_ID, STH.PROGRAM_ID, STH.PROGRAM_UPDATE_DATE, STH.OBJECT_VERSION_NUMBER, STH.CREATED_BY, STH.CREATION_DATE, STH.LAST_UPDATED_BY, STH.LAST_UPDATE_DATE, STH.LAST_UPDATE_LOGIN, STH.CREDIT_APP_ID, STH.OLD_STATUS_ID, STVL.STATUS_CODE OLD_STATUS_CODE, STVL.NAME OLD_STATUS_NAME, STVL.DESCRIPTION OLD_STATUS_DESC, STH.NEW_STATUS_ID, STVL1.STATUS_CODE NEW_STATUS_CODE, STVL1.NAME NEW_STATUS_NAME, STVL1.DESCRIPTION NEW_STATUS_DESC, STH.USER_ID, DECODE(NVL(STH.USER_TYPE_CODE, 'CONCUR'), 'BUYER', FUR.USER_NAME, 'FINANCE_MGR', FUR.USER_NAME, 'ORDER_ADMIN', FUR.USER_NAME, 'GUARANTOR', 'Personal Guarantor', 'system') USER_NAME, STH.USER_TYPE_CODE, STH.CA_STATUS_EVENT_TIME, STH.CA_STATUS_EVENT_CODE, STH.CA_STATUS_EVENT_DESC, STH.SECURITY_GROUP_ID FROM IBY_F_T_CRDT_APP_ST_H STH, IBY_F_CRDT_APP_STATUS_VL STVL, IBY_F_CRDT_APP_STATUS_VL STVL1, FND_USER FUR WHERE STH.OLD_STATUS_ID = STVL.CREDIT_APP_STATUS_ID (+) AND STH.NEW_STATUS_ID = STVL1.CREDIT_APP_STATUS_ID AND STH.USER_ID = FUR.USER_ID (+)

View Text - HTML Formatted

SELECT STH.STATUS_HISTORY_ID
, STH.REQUEST_ID
, STH.PROGRAM_APPLICATION_ID
, STH.PROGRAM_ID
, STH.PROGRAM_UPDATE_DATE
, STH.OBJECT_VERSION_NUMBER
, STH.CREATED_BY
, STH.CREATION_DATE
, STH.LAST_UPDATED_BY
, STH.LAST_UPDATE_DATE
, STH.LAST_UPDATE_LOGIN
, STH.CREDIT_APP_ID
, STH.OLD_STATUS_ID
, STVL.STATUS_CODE OLD_STATUS_CODE
, STVL.NAME OLD_STATUS_NAME
, STVL.DESCRIPTION OLD_STATUS_DESC
, STH.NEW_STATUS_ID
, STVL1.STATUS_CODE NEW_STATUS_CODE
, STVL1.NAME NEW_STATUS_NAME
, STVL1.DESCRIPTION NEW_STATUS_DESC
, STH.USER_ID
, DECODE(NVL(STH.USER_TYPE_CODE
, 'CONCUR')
, 'BUYER'
, FUR.USER_NAME
, 'FINANCE_MGR'
, FUR.USER_NAME
, 'ORDER_ADMIN'
, FUR.USER_NAME
, 'GUARANTOR'
, 'PERSONAL GUARANTOR'
, 'SYSTEM') USER_NAME
, STH.USER_TYPE_CODE
, STH.CA_STATUS_EVENT_TIME
, STH.CA_STATUS_EVENT_CODE
, STH.CA_STATUS_EVENT_DESC
, STH.SECURITY_GROUP_ID
FROM IBY_F_T_CRDT_APP_ST_H STH
, IBY_F_CRDT_APP_STATUS_VL STVL
, IBY_F_CRDT_APP_STATUS_VL STVL1
, FND_USER FUR
WHERE STH.OLD_STATUS_ID = STVL.CREDIT_APP_STATUS_ID (+)
AND STH.NEW_STATUS_ID = STVL1.CREDIT_APP_STATUS_ID
AND STH.USER_ID = FUR.USER_ID (+)