VIEW: APPS.IBY_F_T_CRDT_APPS_V

Source

View Text - Preformatted

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 (+)

View Text - HTML Formatted

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 (+)