VIEW: APPS.IBY_F_T_CA_GRNTRS_VL

Source

View Text - Preformatted

SELECT CAGB.ROWID ROW_ID, CAGB.CREDIT_APP_GRNTR_ID CREDIT_APP_GRNTR_ID, CAGB.CREDIT_APP_ID CREDIT_APP_ID, CAGB.CREATED_BY CREATED_BY, CAGB.CREATION_DATE CREATION_DATE, CAGB.LAST_UPDATED_BY LAST_UPDATED_BY, CAGB.LAST_UPDATE_DATE LAST_UPDATE_DATE, CAGB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CAGB.ACTIVE_FLAG ACTIVE_FLAG, CAGB.START_DATE_ACTIVE START_DATE_ACTIVE, CAGB.END_DATE_ACTIVE END_DATE_ACTIVE, CAGT.FIRST_NAME FIRST_NAME, CAGT.LAST_NAME LAST_NAME, CAGB.EMAIL_ADDRESS EMAIL_ADDRESS, CAGB.SECURITY_KEY SECURITY_KEY, CAGB.CREDIT_APP_GRNTR_SEQ CREDIT_APP_GRNTR_SEQ, CAGB.SECURITY_GROUP_ID SECURITY_GROUP_ID, CAGB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER FROM IBY_F_T_CA_GRNTRS_B CAGB, IBY_F_T_CA_GRNTRS_TL CAGT WHERE CAGB.CREDIT_APP_GRNTR_ID = CAGT.CREDIT_APP_GRNTR_ID AND CAGT.LANGUAGE = USERENV('LANG')

View Text - HTML Formatted

SELECT CAGB.ROWID ROW_ID
, CAGB.CREDIT_APP_GRNTR_ID CREDIT_APP_GRNTR_ID
, CAGB.CREDIT_APP_ID CREDIT_APP_ID
, CAGB.CREATED_BY CREATED_BY
, CAGB.CREATION_DATE CREATION_DATE
, CAGB.LAST_UPDATED_BY LAST_UPDATED_BY
, CAGB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, CAGB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CAGB.ACTIVE_FLAG ACTIVE_FLAG
, CAGB.START_DATE_ACTIVE START_DATE_ACTIVE
, CAGB.END_DATE_ACTIVE END_DATE_ACTIVE
, CAGT.FIRST_NAME FIRST_NAME
, CAGT.LAST_NAME LAST_NAME
, CAGB.EMAIL_ADDRESS EMAIL_ADDRESS
, CAGB.SECURITY_KEY SECURITY_KEY
, CAGB.CREDIT_APP_GRNTR_SEQ CREDIT_APP_GRNTR_SEQ
, CAGB.SECURITY_GROUP_ID SECURITY_GROUP_ID
, CAGB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
FROM IBY_F_T_CA_GRNTRS_B CAGB
, IBY_F_T_CA_GRNTRS_TL CAGT
WHERE CAGB.CREDIT_APP_GRNTR_ID = CAGT.CREDIT_APP_GRNTR_ID
AND CAGT.LANGUAGE = USERENV('LANG')