Product: | IBY - Payments |
---|---|
Description: | |
Implementation/DBA Data: | APPS.IBY_F_T_CA_STATUS_H_V |
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 (+)