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