VIEW: APPS.IBY_F_T_CRDT_APPS_ALL_VL

Source

View Text - Preformatted

SELECT CAB.ROWID ROW_ID, CAB.CREDIT_APP_ID, CAB.TRXN_SUMMARY_ID, CAB.REQUEST_ID, CAB.PROGRAM_APPLICATION_ID, CAB.PROGRAM_ID, CAB.PROGRAM_UPDATE_DATE, CAB.OBJECT_VERSION_NUMBER, CAB.CREATED_BY, CAB.CREATION_DATE, CAB.LAST_UPDATED_BY, CAB.LAST_UPDATE_DATE, CAB.LAST_UPDATE_LOGIN, CATL.NAME, CATL.DESCRIPTION, CAB.FINANCING_TYPE_CODE, CAB.CREDIT_APP_STATUS_ID, CAB.DURATION, CAB.DURATION_UOM_CODE, CAB.INTEREST_RATE, CAB.PAYMENT_STRUCTURE_CODE, CAB.DECISION_TIME_FRAME, CAB.DECISION_TIME_FRAME_UOM_CODE, CAB.CREDIT_APP_XML_ID, CAB.TERMS_N_CONDITIONS_XML_ID, CAB.FIRST_SAVED_DATE, CAB.EXPIRATION_DATE, CAB.EXP_EXTENDED_COUNT, CAB.EXPIRING_FLAG, CAB.DOC_RECEIVED_DATE, CAB.DOC_RECEIVED_FLAG, CAB.N_PG_REQUESTED, CAB.N_PG_SUBMITTED, CAB.BUYER_FORM_MARKUP_FLAG, CAB.ORG_ID, CAB.SECURITY_GROUP_ID, CAB.ATTRIBUTE_CATEGORY, CAB.ATTRIBUTE1, CAB.ATTRIBUTE2, CAB.ATTRIBUTE3, CAB.ATTRIBUTE4, CAB.ATTRIBUTE5, CAB.ATTRIBUTE6, CAB.ATTRIBUTE7, CAB.ATTRIBUTE8, CAB.ATTRIBUTE9, CAB.ATTRIBUTE10, CAB.ATTRIBUTE11, CAB.ATTRIBUTE12, CAB.ATTRIBUTE13, CAB.ATTRIBUTE14, CAB.ATTRIBUTE15 FROM IBY_F_T_CRDT_APPS_ALL_B CAB, IBY_F_T_CRDT_APPS_ALL_TL CATL WHERE CAB.CREDIT_APP_ID = CATL.CREDIT_APP_ID AND CATL.LANGUAGE = USERENV('LANG')

View Text - HTML Formatted

SELECT CAB.ROWID ROW_ID
, CAB.CREDIT_APP_ID
, CAB.TRXN_SUMMARY_ID
, CAB.REQUEST_ID
, CAB.PROGRAM_APPLICATION_ID
, CAB.PROGRAM_ID
, CAB.PROGRAM_UPDATE_DATE
, CAB.OBJECT_VERSION_NUMBER
, CAB.CREATED_BY
, CAB.CREATION_DATE
, CAB.LAST_UPDATED_BY
, CAB.LAST_UPDATE_DATE
, CAB.LAST_UPDATE_LOGIN
, CATL.NAME
, CATL.DESCRIPTION
, CAB.FINANCING_TYPE_CODE
, CAB.CREDIT_APP_STATUS_ID
, CAB.DURATION
, CAB.DURATION_UOM_CODE
, CAB.INTEREST_RATE
, CAB.PAYMENT_STRUCTURE_CODE
, CAB.DECISION_TIME_FRAME
, CAB.DECISION_TIME_FRAME_UOM_CODE
, CAB.CREDIT_APP_XML_ID
, CAB.TERMS_N_CONDITIONS_XML_ID
, CAB.FIRST_SAVED_DATE
, CAB.EXPIRATION_DATE
, CAB.EXP_EXTENDED_COUNT
, CAB.EXPIRING_FLAG
, CAB.DOC_RECEIVED_DATE
, CAB.DOC_RECEIVED_FLAG
, CAB.N_PG_REQUESTED
, CAB.N_PG_SUBMITTED
, CAB.BUYER_FORM_MARKUP_FLAG
, CAB.ORG_ID
, CAB.SECURITY_GROUP_ID
, CAB.ATTRIBUTE_CATEGORY
, CAB.ATTRIBUTE1
, CAB.ATTRIBUTE2
, CAB.ATTRIBUTE3
, CAB.ATTRIBUTE4
, CAB.ATTRIBUTE5
, CAB.ATTRIBUTE6
, CAB.ATTRIBUTE7
, CAB.ATTRIBUTE8
, CAB.ATTRIBUTE9
, CAB.ATTRIBUTE10
, CAB.ATTRIBUTE11
, CAB.ATTRIBUTE12
, CAB.ATTRIBUTE13
, CAB.ATTRIBUTE14
, CAB.ATTRIBUTE15
FROM IBY_F_T_CRDT_APPS_ALL_B CAB
, IBY_F_T_CRDT_APPS_ALL_TL CATL
WHERE CAB.CREDIT_APP_ID = CATL.CREDIT_APP_ID
AND CATL.LANGUAGE = USERENV('LANG')