VIEW: APPS.OKC_PROCESS_DEF_FUNCTION_V

Source

View Text - Preformatted

SELECT pdf.id pdf_id, pdp.id pdp_id, pdpt.name name, pdp.required_yn, pdp.data_type data_type, to_number(NULL) cnl_id FROM okc_process_defs_b pdf, okc_process_def_parms_b pdp, okc_process_def_parms_tl pdpt WHERE pdf.id = pdp.pdf_id AND pdf.usage = 'FUNCTION' and pdpt.id = pdp.id AND PDPT.LANGUAGE = USERENV('LANG') UNION SELECT pdf.id pdf_id, pdp.id pdp_id, pdpt.name name, pdp.required_yn, pdp.data_type data_type, cnl.id cnl_id FROM okc_process_defs_b pdf, okc_process_def_parms_b pdp, okc_process_def_parms_tl pdpt, okc_condition_lines_b cnl WHERE pdf.id = pdp.pdf_id AND pdf.usage = 'FUNCTION' and pdf.id = cnl.pdf_id and pdpt.id = pdp.id AND PDPT.LANGUAGE = USERENV('LANG') AND pdp.id not in(select pdp_id from okc_function_expr_params fep, okc_condition_lines_b cnl1 where cnl.id = fep.cnl_id and cnl1.id = cnl.id)

View Text - HTML Formatted

SELECT PDF.ID PDF_ID
, PDP.ID PDP_ID
, PDPT.NAME NAME
, PDP.REQUIRED_YN
, PDP.DATA_TYPE DATA_TYPE
, TO_NUMBER(NULL) CNL_ID
FROM OKC_PROCESS_DEFS_B PDF
, OKC_PROCESS_DEF_PARMS_B PDP
, OKC_PROCESS_DEF_PARMS_TL PDPT
WHERE PDF.ID = PDP.PDF_ID
AND PDF.USAGE = 'FUNCTION'
AND PDPT.ID = PDP.ID
AND PDPT.LANGUAGE = USERENV('LANG') UNION SELECT PDF.ID PDF_ID
, PDP.ID PDP_ID
, PDPT.NAME NAME
, PDP.REQUIRED_YN
, PDP.DATA_TYPE DATA_TYPE
, CNL.ID CNL_ID
FROM OKC_PROCESS_DEFS_B PDF
, OKC_PROCESS_DEF_PARMS_B PDP
, OKC_PROCESS_DEF_PARMS_TL PDPT
, OKC_CONDITION_LINES_B CNL
WHERE PDF.ID = PDP.PDF_ID
AND PDF.USAGE = 'FUNCTION'
AND PDF.ID = CNL.PDF_ID
AND PDPT.ID = PDP.ID
AND PDPT.LANGUAGE = USERENV('LANG')
AND PDP.ID NOT IN(SELECT PDP_ID
FROM OKC_FUNCTION_EXPR_PARAMS FEP
, OKC_CONDITION_LINES_B CNL1
WHERE CNL.ID = FEP.CNL_ID
AND CNL1.ID = CNL.ID)