[Home] [Help]
View: OKL_AM_CREATE_RES_QUOTE_UV
View Text
SELECT OKHFV.CONTRACT_NUMBER
, OKHFV.START_DATE
, OKHFV.END_DATE
, OKHFV.ID CONTRACT_ID
, NULL QRS_CODE
, NULL COMMENTS
, NULL POP_CODE_END
, NULL PURCHASE_AMOUNT
, NULL PURCHASE_FORMULA
, NULL PURCHASE_FORMULA_ID
, NULL PURCHASE_PERCENT
, FND.LOOKUP_CODE QTP_CODE
, FND.MEANING QTP_MEANING
, NULL TERM
, NULL RENT_AMT
FROM OKC_K_HEADERS_B OKHFV
, FND_LOOKUPS FND
WHERE FND.LOOKUP_CODE = 'RES_SOLVE_RENT'
AND FND.LOOKUP_TYPE = 'OKL_QUOTE_TYPE'
Columns
Name |
CONTRACT_NUMBER |
START_DATE |
END_DATE |
CONTRACT_ID |
QRS_CODE |
COMMENTS |
POP_CODE_END |
PURCHASE_AMOUNT |
PURCHASE_FORMULA |
PURCHASE_FORMULA_ID |
PURCHASE_PERCENT |
QTP_CODE |
QTP_MEANING |
TERM |
RENT_AMT |