eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: IBY.IBY_F_T_CRDT_APPS_ALL_B#

Source

View Text - Preformatted


select CREDIT_APP_ID CREDIT_APP_ID, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, TRXN_SUMMARY_ID TRXN_SUMMARY_ID, CREDIT_APP_STATUS_ID CREDIT_APP_STATUS_ID, CREDIT_APP_XML_ID CREDIT_APP_XML_ID, TERMS_N_CONDITIONS_XML_ID TERMS_N_CONDITIONS_XML_ID, FINANCING_TYPE_CODE FINANCING_TYPE_CODE, DURATION DURATION, DURATION_UOM_CODE DURATION_UOM_CODE, PAYMENT_STRUCTURE_CODE PAYMENT_STRUCTURE_CODE, INTEREST_RATE INTEREST_RATE, DECISION_TIME_FRAME DECISION_TIME_FRAME, DECISION_TIME_FRAME_UOM_CODE DECISION_TIME_FRAME_UOM_CODE, FIRST_SAVED_DATE FIRST_SAVED_DATE, EXPIRATION_DATE EXPIRATION_DATE, EXP_EXTENDED_COUNT EXP_EXTENDED_COUNT, EXPIRING_FLAG EXPIRING_FLAG, DOC_RECEIVED_DATE DOC_RECEIVED_DATE, DOC_RECEIVED_FLAG DOC_RECEIVED_FLAG, N_PG_REQUESTED N_PG_REQUESTED, N_PG_SUBMITTED N_PG_SUBMITTED, BUYER_FORM_MARKUP_FLAG BUYER_FORM_MARKUP_FLAG, ORG_ID ORG_ID, SECURITY_GROUP_ID SECURITY_GROUP_ID, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15 from "IBY"."IBY_F_T_CRDT_APPS_ALL_B"

View Text - HTML Formatted

SELECT CREDIT_APP_ID CREDIT_APP_ID
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, TRXN_SUMMARY_ID TRXN_SUMMARY_ID
, CREDIT_APP_STATUS_ID CREDIT_APP_STATUS_ID
, CREDIT_APP_XML_ID CREDIT_APP_XML_ID
, TERMS_N_CONDITIONS_XML_ID TERMS_N_CONDITIONS_XML_ID
, FINANCING_TYPE_CODE FINANCING_TYPE_CODE
, DURATION DURATION
, DURATION_UOM_CODE DURATION_UOM_CODE
, PAYMENT_STRUCTURE_CODE PAYMENT_STRUCTURE_CODE
, INTEREST_RATE INTEREST_RATE
, DECISION_TIME_FRAME DECISION_TIME_FRAME
, DECISION_TIME_FRAME_UOM_CODE DECISION_TIME_FRAME_UOM_CODE
, FIRST_SAVED_DATE FIRST_SAVED_DATE
, EXPIRATION_DATE EXPIRATION_DATE
, EXP_EXTENDED_COUNT EXP_EXTENDED_COUNT
, EXPIRING_FLAG EXPIRING_FLAG
, DOC_RECEIVED_DATE DOC_RECEIVED_DATE
, DOC_RECEIVED_FLAG DOC_RECEIVED_FLAG
, N_PG_REQUESTED N_PG_REQUESTED
, N_PG_SUBMITTED N_PG_SUBMITTED
, BUYER_FORM_MARKUP_FLAG BUYER_FORM_MARKUP_FLAG
, ORG_ID ORG_ID
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
FROM "IBY"."IBY_F_T_CRDT_APPS_ALL_B"