eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: BEN_COPY_ENTITY_TXNS_VW

Product:	BEN - Advanced Benefits
Description:	Plan Design Transaction View
Implementation/DBA Data:	APPS.BEN_COPY_ENTITY_TXNS_VW

View Text

SELECT CET.COPY_ENTITY_TXN_ID
, CET.ACTION_DATE
, CET.CONTEXT
, CET.TRANSACTION_CATEGORY_ID
, CET.SRC_EFFECTIVE_DATE
, CET.TXN_CATEGORY_ATTRIBUTE_ID
, CET.DISPLAY_NAME
, CET.REPLACEMENT_TYPE_CD
, CET.START_WITH
, CET.INCREMENT_BY
, CET.NUMBER_OF_COPIES
, CET.STATUS
, CET.OBJECT_VERSION_NUMBER
, CET.LAST_UPDATE_DATE
, CET.LAST_UPDATED_BY
, CET.LAST_UPDATE_LOGIN
, CET.CREATED_BY
, CET.CREATION_DATE
, CET.CONTEXT_BUSINESS_GROUP_ID
, CET.DATETRACK_MODE
, CET.WF_TRANSACTION_CATEGORY_ID
, CEA.COPY_ENTITY_ATTRIB_ID
, CEA.ROW_TYPE_CD
, CEA.INFORMATION_CATEGORY
, CEA.INFORMATION1
, CEA.INFORMATION2
, CEA.INFORMATION3
, CEA.INFORMATION4
, CEA.INFORMATION5
, CEA.INFORMATION6
, CEA.INFORMATION7
, CEA.INFORMATION8
, CEA.INFORMATION9
, CEA.INFORMATION10
, CEA.INFORMATION11
, CEA.INFORMATION12
, CEA.INFORMATION13
, CEA.INFORMATION14
, CEA.INFORMATION15
, CEA.INFORMATION16
, CEA.INFORMATION17
, CEA.INFORMATION18
, CEA.INFORMATION19
, CEA.INFORMATION20
, CEA.INFORMATION21
, CEA.INFORMATION22
, CEA.INFORMATION23
, CEA.INFORMATION24
, CEA.INFORMATION25
, CEA.INFORMATION26
, CEA.INFORMATION27
, CEA.INFORMATION28
, CEA.INFORMATION29
, CEA.INFORMATION30
, CEA.OBJECT_VERSION_NUMBER
FROM PQH_COPY_ENTITY_TXNS CET
, PQH_COPY_ENTITY_ATTRIBS CEA
WHERE CET.COPY_ENTITY_TXN_ID = CEA.COPY_ENTITY_TXN_ID

Columns

Name
COPY_ENTITY_TXN_ID
ACTION_DATE
PROC_TYP_CD
TRANSACTION_CATEGORY_ID
SRC_EFFECTIVE_DATE
TXN_CATEGORY_ATTRIBUTE_ID
PROCESS_NAME
REPLACEMENT_TYPE_CD
SFL_STEP_NAME
INCREMENT_BY
NUMBER_OF_COPIES
STATUS
CET_OBJECT_VERSION_NUMBER
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE
CONTEXT_BUSINESS_GROUP_ID
DATETRACK_MODE
WF_TRANSACTION_CATEGORY_ID
COPY_ENTITY_ATTRIB_ID
ROW_TYPE_CD
INFORMATION_CATEGORY
PREFIX_SUFFIX_TEXT
EXPORT_FILE_NAME
TARGET_TYP_CD
REUSE_OBJECT_FLAG
TARGET_BUSINESS_GROUP_ID
SEARCH_BY_CD1
SEARCH_VALUE1
SEARCH_BY_CD2
SEARCH_VALUE2
SEARCH_BY_CD3
SEARCH_VALUE3
PREFIX_SUFFIX_CD
INFORMATION13
INFORMATION14
INFORMATION15
INFORMATION16
INFORMATION17
INFORMATION18
INFORMATION19
INFORMATION20
INFORMATION21
INFORMATION22
INFORMATION23
INFORMATION24
INFORMATION25
INFORMATION26
INFORMATION27
INFORMATION28
INFORMATION29
INFORMATION30
CEA_OBJECT_VERSION_NUMBER