Product: | OKC - Contracts Core |
---|---|
Description: | View based on tables OKC_PROCESS_DEF_PARAMETERS_B and OKC_PROCESS_DEF_PARAMETERS_TL. |
Implementation/DBA Data: | APPS.OKC_PROCESS_DEF_PARAMETERS_V |
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')