[Home] [Help]
View: PQH_CORPS_FILERES_V
View Text
SELECT CORPS_DEFINITION_ID CORPS_DEFINITION_ID
, CORPS_EXTRA_INFO_ID CORPS_EXTRA_INFO_ID
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, INFORMATION_TYPE INFORMATION_TYPE
, HR_GENERAL.DECODE_SHARED_TYPE(FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION4)) FILERE_NAME
, INFORMATION4 FILERE_CD
FROM PQH_CORPS_EXTRA_INFO
WHERE INFORMATION_TYPE ='FILERE'
Columns
Name |
CORPS_DEFINITION_ID |
CORPS_EXTRA_INFO_ID |
OBJECT_VERSION_NUMBER |
INFORMATION_TYPE |
FILERE_NAME |
FILERE_CD |