VIEW: APPS.OKL_CREDIT_REQUESTS_UV

Source

View Text - Preformatted

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

View Text - HTML Formatted

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