[Home] [Help]
View: PQH_CORPS_DOCUMENTS_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
, INFORMATION3 DOCUMENT_TYPE_CD
, INFORMATION4 DOCUMENT_NUMBER
, INFORMATION5 DOCUMENT_NAME
, FND_DATE.CANONICAL_TO_DATE(INFORMATION6) DOCUMENT_DATE
, HR_GENERAL.DECODE_LOOKUP('PQH_CORPS_DOC_TYPE'
, INFORMATION3) DOCUMENT_TYPE_DESC
, INFORMATION7 DOCUMENT_URL
FROM PQH_CORPS_EXTRA_INFO
WHERE INFORMATION_TYPE = 'DOCUMENT'
Columns
Name |
CORPS_DEFINITION_ID |
CORPS_EXTRA_INFO_ID |
OBJECT_VERSION_NUMBER |
INFORMATION_TYPE |
DOCUMENT_TYPE_CD |
DOCUMENT_NUMBER |
DOCUMENT_NAME |
DOCUMENT_DATE |
DOCUMENT_TYPE_DESC |
DOCUMENT_URL |