VIEW: HR.GHR_COMPL_CA_DETAILS#

Source

View Text - Preformatted

select COMPL_CA_DETAIL_ID COMPL_CA_DETAIL_ID, COMPL_CA_HEADER_ID COMPL_CA_HEADER_ID, AMOUNT AMOUNT, ORDER_DATE ORDER_DATE, DUE_DATE DUE_DATE, REQUEST_DATE REQUEST_DATE, COMPLETE_DATE COMPLETE_DATE, CATEGORY CATEGORY, PHASE PHASE, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, DESCRIPTION DESCRIPTION, ACTION_TYPE ACTION_TYPE, PAYMENT_TYPE PAYMENT_TYPE from "HR"."GHR_COMPL_CA_DETAILS"

View Text - HTML Formatted

SELECT COMPL_CA_DETAIL_ID COMPL_CA_DETAIL_ID
, COMPL_CA_HEADER_ID COMPL_CA_HEADER_ID
, AMOUNT AMOUNT
, ORDER_DATE ORDER_DATE
, DUE_DATE DUE_DATE
, REQUEST_DATE REQUEST_DATE
, COMPLETE_DATE COMPLETE_DATE
, CATEGORY CATEGORY
, PHASE PHASE
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, DESCRIPTION DESCRIPTION
, ACTION_TYPE ACTION_TYPE
, PAYMENT_TYPE PAYMENT_TYPE
FROM "HR"."GHR_COMPL_CA_DETAILS"