DBA Data[Home] [Help]

VIEW: APPS.IGS_FI_LB_CR_TYPES_V

Source

View Text - Preformatted

SELECT LB.ROWID, LB.LOCKBOX_NAME, LB.BANK_CD, LB.CREDIT_TYPE_ID, CR.CREDIT_TYPE_NAME, LB.CREATED_BY, LB.CREATION_DATE, LB.LAST_UPDATE_DATE, LB.LAST_UPDATED_BY, LB.LAST_UPDATE_LOGIN FROM IGS_FI_LB_CR_TYPES LB, IGS_FI_CR_TYPES CR WHERE LB.CREDIT_TYPE_ID = CR.CREDIT_TYPE_ID
View Text - HTML Formatted

SELECT LB.ROWID
, LB.LOCKBOX_NAME
, LB.BANK_CD
, LB.CREDIT_TYPE_ID
, CR.CREDIT_TYPE_NAME
, LB.CREATED_BY
, LB.CREATION_DATE
, LB.LAST_UPDATE_DATE
, LB.LAST_UPDATED_BY
, LB.LAST_UPDATE_LOGIN
FROM IGS_FI_LB_CR_TYPES LB
, IGS_FI_CR_TYPES CR
WHERE LB.CREDIT_TYPE_ID = CR.CREDIT_TYPE_ID