VIEW: APPS.OKC_PROCESS_DEF_PARAMETERS_V

Source

View Text - Preformatted

SELECT PDPB.ROWID ROW_ID, PDPB.ID ID, PDPB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, PDPT.SFWT_FLAG SFWT_FLAG, PDPB.PDF_ID PDF_ID, PDPB.NAME NAME, PDPT.NAME USER_NAME, PDPB.DATA_TYPE DATA_TYPE, PDPB.DEFAULT_VALUE DEFAULT_VALUE, PDPB.REQUIRED_YN REQUIRED_YN, PDPT.DESCRIPTION DESCRIPTION, PDPB.APPLICATION_ID APPLICATION_ID, PDPB.SEEDED_FLAG SEEDED_FLAG, PDPB.CREATED_BY CREATED_BY, PDPB.CREATION_DATE CREATION_DATE, PDPB.LAST_UPDATED_BY LAST_UPDATED_BY, PDPB.LAST_UPDATE_DATE LAST_UPDATE_DATE, PDPB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, PDPB.JTOT_OBJECT_CODE JTOT_OBJECT_CODE, PDPB.NAME_COLUMN NAME_COLUMN, PDPB.DESCRIPTION_COLUMN DESCRIPTION_COLUMN FROM OKC_PROCESS_DEF_PARMS_B PDPB,OKC_PROCESS_DEF_PARMS_TL PDPT WHERE PDPB.ID = PDPT.ID and PDPT.LANGUAGE = USERENV('LANG')

View Text - HTML Formatted

SELECT PDPB.ROWID ROW_ID
, PDPB.ID ID
, PDPB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, PDPT.SFWT_FLAG SFWT_FLAG
, PDPB.PDF_ID PDF_ID
, PDPB.NAME NAME
, PDPT.NAME USER_NAME
, PDPB.DATA_TYPE DATA_TYPE
, PDPB.DEFAULT_VALUE DEFAULT_VALUE
, PDPB.REQUIRED_YN REQUIRED_YN
, PDPT.DESCRIPTION DESCRIPTION
, PDPB.APPLICATION_ID APPLICATION_ID
, PDPB.SEEDED_FLAG SEEDED_FLAG
, PDPB.CREATED_BY CREATED_BY
, PDPB.CREATION_DATE CREATION_DATE
, PDPB.LAST_UPDATED_BY LAST_UPDATED_BY
, PDPB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, PDPB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PDPB.JTOT_OBJECT_CODE JTOT_OBJECT_CODE
, PDPB.NAME_COLUMN NAME_COLUMN
, PDPB.DESCRIPTION_COLUMN DESCRIPTION_COLUMN
FROM OKC_PROCESS_DEF_PARMS_B PDPB
, OKC_PROCESS_DEF_PARMS_TL PDPT
WHERE PDPB.ID = PDPT.ID
AND PDPT.LANGUAGE = USERENV('LANG')