VIEW: HR.PQH_COPY_ENTITY_TXNS#

Source

View Text - Preformatted

select COPY_ENTITY_TXN_ID COPY_ENTITY_TXN_ID, CONTEXT CONTEXT, ACTION_DATE ACTION_DATE, TRANSACTION_CATEGORY_ID TRANSACTION_CATEGORY_ID, SRC_EFFECTIVE_DATE SRC_EFFECTIVE_DATE, TXN_CATEGORY_ATTRIBUTE_ID TXN_CATEGORY_ATTRIBUTE_ID, DISPLAY_NAME DISPLAY_NAME, REPLACEMENT_TYPE_CD REPLACEMENT_TYPE_CD, START_WITH START_WITH, INCREMENT_BY INCREMENT_BY, NUMBER_OF_COPIES NUMBER_OF_COPIES, STATUS STATUS, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, CONTEXT_BUSINESS_GROUP_ID CONTEXT_BUSINESS_GROUP_ID, DATETRACK_MODE DATETRACK_MODE, WF_TRANSACTION_CATEGORY_ID WF_TRANSACTION_CATEGORY_ID from "HR"."PQH_COPY_ENTITY_TXNS"

View Text - HTML Formatted

SELECT COPY_ENTITY_TXN_ID COPY_ENTITY_TXN_ID
, CONTEXT CONTEXT
, ACTION_DATE ACTION_DATE
, TRANSACTION_CATEGORY_ID TRANSACTION_CATEGORY_ID
, SRC_EFFECTIVE_DATE SRC_EFFECTIVE_DATE
, TXN_CATEGORY_ATTRIBUTE_ID TXN_CATEGORY_ATTRIBUTE_ID
, DISPLAY_NAME DISPLAY_NAME
, REPLACEMENT_TYPE_CD REPLACEMENT_TYPE_CD
, START_WITH START_WITH
, INCREMENT_BY INCREMENT_BY
, NUMBER_OF_COPIES NUMBER_OF_COPIES
, STATUS STATUS
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, CONTEXT_BUSINESS_GROUP_ID CONTEXT_BUSINESS_GROUP_ID
, DATETRACK_MODE DATETRACK_MODE
, WF_TRANSACTION_CATEGORY_ID WF_TRANSACTION_CATEGORY_ID
FROM "HR"."PQH_COPY_ENTITY_TXNS"