View: IBY_F_T_CRDT_APPS_V

Product:	IBY - Payments
Description:
Implementation/DBA Data:	APPS.IBY_F_T_CRDT_APPS_V

View Text

SELECT CAVL.CREDIT_APP_ID
, CAVL.REQUEST_ID
, CAVL.PROGRAM_APPLICATION_ID
, CAVL.PROGRAM_ID
, CAVL.PROGRAM_UPDATE_DATE
, CAVL.OBJECT_VERSION_NUMBER
, CAVL.CREATED_BY
, CAVL.CREATION_DATE
, CAVL.LAST_UPDATED_BY
, CAVL.LAST_UPDATE_DATE
, CAVL.LAST_UPDATE_LOGIN
, CAVL.TRXN_SUMMARY_ID
, TRNS.TRANSACTIONID
, CAVL.CREDIT_APP_STATUS_ID
, STVL.NAME
, STVL.DESCRIPTION
, STVL.CUST_FACING_NAME
, STVL.STATUS_NUMBER
, CAVL.CREDIT_APP_XML_ID
, CAVL.TERMS_N_CONDITIONS_XML_ID
, TRNS.BEPID
, BEP.PARTY_ID
, HPE1.PARTY_NAME
, TRNS.CUST_ACCOUNT_ID
, HPE.PARTY_NAME
, CAVL.FINANCING_TYPE_CODE
, CAVL.DURATION
, CAVL.DURATION_UOM_CODE
, CAVL.PAYMENT_STRUCTURE_CODE
, CAVL.INTEREST_RATE
, CAVL.DECISION_TIME_FRAME
, CAVL.DECISION_TIME_FRAME_UOM_CODE
, CAVL.FIRST_SAVED_DATE
, CAVL.EXPIRATION_DATE
, CAVL.EXP_EXTENDED_COUNT
, CAVL.EXPIRING_FLAG
, CAVL.DOC_RECEIVED_DATE
, CAVL.DOC_RECEIVED_FLAG
, CAVL.N_PG_REQUESTED
, CAVL.N_PG_SUBMITTED
, CAVL.BUYER_FORM_MARKUP_FLAG
, CAVL.NAME
, CAVL.DESCRIPTION
, TRNS.MTANGIBLEID
, TANG.AMOUNT
, TANG.CURRENCYNAMECODE
, TRNS.PAYEEID
, TRNS.MPAYEEID
, TRNS.ECAPPID
, TANG.SOURCE_OBJECT_TYPE_CODE
, TANG.SOURCE_OBJECT_ID
, CAVL.ORG_ID
, CAVL.SECURITY_GROUP_ID
, CAVL.ATTRIBUTE_CATEGORY
, CAVL.ATTRIBUTE1
, CAVL.ATTRIBUTE2
, CAVL.ATTRIBUTE3
, CAVL.ATTRIBUTE4
, CAVL.ATTRIBUTE5
, CAVL.ATTRIBUTE6
, CAVL.ATTRIBUTE7
, CAVL.ATTRIBUTE8
, CAVL.ATTRIBUTE9
, CAVL.ATTRIBUTE10
, CAVL.ATTRIBUTE11
, CAVL.ATTRIBUTE12
, CAVL.ATTRIBUTE13
, CAVL.ATTRIBUTE15
, CAVL.ATTRIBUTE14
FROM IBY_F_CRDT_APP_STATUS_VL STVL
, IBY_F_T_CRDT_APPS_ALL_VL CAVL
, IBY_TRXN_SUMMARIES_ALL TRNS
, IBY_TRXN_DOCUMENTS TRND
, IBY_TANGIBLE TANG
, IBY_BEPINFO BEP
, HZ_PARTIES HPE
, HZ_PARTIES HPE1
, HZ_CUST_ACCOUNTS HCT
, IBY_TRXN_DOCUMENTS TRND1
WHERE CAVL.TRXN_SUMMARY_ID = TRNS.TRXNMID
AND TRNS.MTANGIBLEID = TANG.MTANGIBLEID
AND TRNS.CUST_ACCOUNT_ID = HCT.CUST_ACCOUNT_ID (+)
AND HCT.PARTY_ID = HPE.PARTY_ID
AND CAVL.CREDIT_APP_XML_ID = TRND.TRXN_DOCUMENT_ID (+)
AND CAVL.TERMS_N_CONDITIONS_XML_ID = TRND1.TRXN_DOCUMENT_ID (+)
AND CAVL.CREDIT_APP_STATUS_ID = STVL.CREDIT_APP_STATUS_ID
AND TRNS.BEPID = BEP.BEPID (+)
AND BEP.PARTY_ID = HPE1.PARTY_ID (+)

Columns