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.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.BEN_COPY_ENTITY_TXNS_VW

Object Details

Object Name:	BEN_COPY_ENTITY_TXNS_VW
Object Type:	VIEW
Owner:	APPS
FND Design Data:	BEN.BEN_COPY_ENTITY_TXNS_VW
Subobject Name:
Status:	VALID

View Type

A Web view designed to simplify access from Oracle Self-Service Web Applications.

BEN_COPY_ENTITY_TXNS_VW holds the list of current ongoing plan copy transactions.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
COPY_ENTITY_TXN_ID	NUMBER	(15)	Yes	copy_entity_txn_id
ACTION_DATE	DATE			action_date
PROC_TYP_CD	VARCHAR2	(27)	Yes	proc_typ_cd
TRANSACTION_CATEGORY_ID	NUMBER	(15)	Yes	transaction_category_id
SRC_EFFECTIVE_DATE	DATE			src_effective_date
TXN_CATEGORY_ATTRIBUTE_ID	NUMBER	(15)		txn_category_attribute_id
PROCESS_NAME	VARCHAR2	(100)	Yes	process_name
REPLACEMENT_TYPE_CD	VARCHAR2	(30)		replacement_type_cd
SFL_STEP_NAME	VARCHAR2	(255)		sfl_step_name
INCREMENT_BY	NUMBER	(15)		increment_by
NUMBER_OF_COPIES	NUMBER	(10)		number_of_copies
STATUS	VARCHAR2	(30)		status
CET_OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	cet_object_version_number
LAST_UPDATE_DATE	DATE			Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER	(15)		Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATED_BY	NUMBER	(15)	Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
CONTEXT_BUSINESS_GROUP_ID	NUMBER	(15)		context_business_group_id
DATETRACK_MODE	VARCHAR2	(30)		datetrack_mode
WF_TRANSACTION_CATEGORY_ID	NUMBER	(15)		wf_transaction_category_id
COPY_ENTITY_ATTRIB_ID	NUMBER	(15)	Yes	copy_entity_attrib_id
ROW_TYPE_CD	VARCHAR2	(30)	Yes	row_type_cd
INFORMATION_CATEGORY	VARCHAR2	(30)		information_category
PREFIX_SUFFIX_TEXT	VARCHAR2	(2000)		prefix_suffix_text
EXPORT_FILE_NAME	VARCHAR2	(255)		export_file_name
TARGET_TYP_CD	VARCHAR2	(255)		target_typ_cd
REUSE_OBJECT_FLAG	VARCHAR2	(255)		reuse_object_flag
TARGET_BUSINESS_GROUP_ID	VARCHAR2	(255)		target_business_group_id
SEARCH_BY_CD1	VARCHAR2	(255)		search_by_cd1
SEARCH_VALUE1	VARCHAR2	(255)		search_value1
SEARCH_BY_CD2	VARCHAR2	(255)		search_by_cd2
SEARCH_VALUE2	VARCHAR2	(255)		search_value2
SEARCH_BY_CD3	VARCHAR2	(255)		search_by_cd3
SEARCH_VALUE3	VARCHAR2	(255)		search_value3
PREFIX_SUFFIX_CD	VARCHAR2	(255)		prefix_suffix_cd
INFORMATION13	VARCHAR2	(255)		information13
INFORMATION14	VARCHAR2	(255)		information14
INFORMATION15	VARCHAR2	(255)		information15
INFORMATION16	VARCHAR2	(255)		information16
INFORMATION17	VARCHAR2	(2000)		information17
INFORMATION18	VARCHAR2	(2000)		information18
INFORMATION19	VARCHAR2	(255)		information19
INFORMATION20	VARCHAR2	(255)		information20
INFORMATION21	VARCHAR2	(255)		information21
INFORMATION22	VARCHAR2	(255)		information22
INFORMATION23	VARCHAR2	(255)		information23
INFORMATION24	VARCHAR2	(2000)		information24
INFORMATION25	VARCHAR2	(2000)		information25
INFORMATION26	VARCHAR2	(2000)		information26
INFORMATION27	VARCHAR2	(2000)		information27
INFORMATION28	VARCHAR2	(255)		information28
INFORMATION29	VARCHAR2	(2000)		information29
INFORMATION30	VARCHAR2	(2000)		information30
CEA_OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	cea_object_version_number

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT 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
FROM APPS.BEN_COPY_ENTITY_TXNS_VW;

Dependencies

[top of page]

APPS.BEN_COPY_ENTITY_TXNS_VW references the following:

APPS: PQH_COPY_ENTITY_ATTRIBS; PQH_COPY_ENTITY_TXNS

APPS.BEN_COPY_ENTITY_TXNS_VW is referenced by following:

APPS: BEN_PD_COPY_TO_BEN_FOUR - show dependent code; BEN_PD_COPY_TO_BEN_ONE - show dependent code; BEN_PD_COPY_TO_BEN_TWO - show dependent code; BEN_PD_COPY_TO_BEN_TWO - show dependent code; BEN_PLAN_DESIGN_TXNS_API - show dependent code