DBA Data[Home] [Help]

VIEW: APPS.OKL_AM_CREATE_RES_QUOTE_UV

Source

View Text - Preformatted

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'
View Text - HTML Formatted

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'