View: OKL_CREDIT_REQUESTS_UV

Product:	OKL - Lease and Finance Management
Description:
Implementation/DBA Data:	APPS.OKL_CREDIT_REQUESTS_UV

View Text

SELECT CRQ.ID ID
, CRQ.QUOTE_ID QUOTE_ID
, KHR.CONTRACT_NUMBER QUOTE_NUMBER
, CRQ.CREDIT_REQ_NUMBER CREDIT_REQ_NUMBER
, CRQ.CREDIT_REQ_ID CREDIT_REQ_ID
, CRQ.CREDIT_AMOUNT CREDIT_AMOUNT
, CRQ.REQUESTED_BY REQUESTED_BY
, CRQ.REQUESTED_DATE REQUESTED_DATE
, CRQ.APPROVED_BY APPROVED_BY
, CRQ.APPROVED_DATE APPROVED_DATE
, CRQ.STATUS STATUS
, FND.MEANING MEANING
, CRQ.CREDIT_KHR_ID CREDIT_KHR_ID
, CHR.CONTRACT_NUMBER CREDIT_CONTRACT_NUMBER
, CRQ.CURRENCY_CODE CURRENCY_CODE
, CRQ.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CRQ.ORG_ID ORG_ID
, ACR.CUST_ACCOUNT_ID CUST_ACCOUNT_ID
, CAT.ACCOUNT_NUMBER ACCOUNT_NUMBER
, CAT.ACCOUNT_NAME ACCOUNT_NAME
, PTY.PARTY_NAME PARTY_NAME
, CRQ.CREATED_BY CREATED_BY
, CRQ.CREATION_DATE CREATION_DATE
, CRQ.LAST_UPDATED_BY LAST_UPDATED_BY
, CRQ.LAST_UPDATE_DATE LAST_UPDATE_DATE
, CRQ.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, NULL TLOC_EXPIRY_DATE
FROM OKL_CREDIT_REQUESTS CRQ
, AR_CMGT_CREDIT_REQUESTS ACR
, HZ_PARTIES PTY
, OKC_K_HEADERS_ALL_B KHR
, HZ_CUST_ACCOUNTS CAT
, OKC_K_HEADERS_ALL_B CHR
, FND_LOOKUPS FND
WHERE CRQ.CREDIT_KHR_ID = CHR.ID (+)
AND FND.LOOKUP_TYPE = 'OKL_REQUEST_STATUS'
AND FND.LOOKUP_CODE = CRQ.STATUS
AND KHR.ID = CRQ.QUOTE_ID
AND CRQ.CREDIT_REQ_ID = ACR.CREDIT_REQUEST_ID
AND ACR.CUST_ACCOUNT_ID = CAT.CUST_ACCOUNT_ID (+)
AND ACR.PARTY_ID = PTY.PARTY_ID

Columns