[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 |
APPS.OKL_AM_CREATE_RES_QUOTE_UV