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

VIEW: APPS.PAYBV_ELEMENT_ENTRY

Object Details
Object Name: PAYBV_ELEMENT_ENTRY
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPAY.PAYBV_ELEMENT_ENTRY
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view

[View Source]

Columns
Name Datatype Length Mandatory Comments
EFFECTIVE_START_DATE DATE
Yes Effective start date for an element entry.
EFFECTIVE_END_DATE DATE
Yes Effective end date for an element entry.
CREATOR_TYPE VARCHAR2 (4000)
ENTRY_TYPE VARCHAR2 (4000)
REASON VARCHAR2 (4000)
SUBPRIORITY NUMBER (9)
DATE_EARNED DATE

BALANCE_ADJ_COST_FLAG VARCHAR2 (4000)
SOURCE_TRIGGER_ENTRY NUMBER (15)
SOURCE_PERIOD NUMBER (15)
SOURCE_RUN_TYPE NUMBER (9)
UPDATING_ACTION_TYPE VARCHAR2 (4000)
SOURCE_START_DATE DATE

SOURCE_END_DATE DATE

_DF:AEE CHAR (31)
ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
ATTRIBUTE16 VARCHAR2 (150)
ATTRIBUTE17 VARCHAR2 (150)
ATTRIBUTE18 VARCHAR2 (150)
ATTRIBUTE19 VARCHAR2 (150)
ATTRIBUTE20 VARCHAR2 (150)
ENTRY_INFORMATION_CATEGORY VARCHAR2 (30)
ENTRY_INFORMATION1 VARCHAR2 (150)
ENTRY_INFORMATION2 VARCHAR2 (150)
ENTRY_INFORMATION3 VARCHAR2 (150)
ENTRY_INFORMATION4 VARCHAR2 (150)
ENTRY_INFORMATION5 VARCHAR2 (150)
ENTRY_INFORMATION6 VARCHAR2 (150)
ENTRY_INFORMATION7 VARCHAR2 (150)
ENTRY_INFORMATION8 VARCHAR2 (150)
ENTRY_INFORMATION9 VARCHAR2 (150)
ENTRY_INFORMATION10 VARCHAR2 (150)
ENTRY_INFORMATION11 VARCHAR2 (150)
ENTRY_INFORMATION12 VARCHAR2 (150)
ENTRY_INFORMATION13 VARCHAR2 (150)
ENTRY_INFORMATION14 VARCHAR2 (150)
ENTRY_INFORMATION15 VARCHAR2 (150)
ENTRY_INFORMATION16 VARCHAR2 (150)
ENTRY_INFORMATION17 VARCHAR2 (150)
ENTRY_INFORMATION18 VARCHAR2 (150)
ENTRY_INFORMATION19 VARCHAR2 (150)
ENTRY_INFORMATION20 VARCHAR2 (150)
ENTRY_INFORMATION21 VARCHAR2 (150)
ENTRY_INFORMATION22 VARCHAR2 (150)
ENTRY_INFORMATION23 VARCHAR2 (150)
ENTRY_INFORMATION24 VARCHAR2 (150)
ENTRY_INFORMATION25 VARCHAR2 (150)
ENTRY_INFORMATION26 VARCHAR2 (150)
ENTRY_INFORMATION27 VARCHAR2 (150)
ENTRY_INFORMATION28 VARCHAR2 (150)
ENTRY_INFORMATION29 VARCHAR2 (150)
ENTRY_INFORMATION30 VARCHAR2 (150)
OBJECT_VERSION_NUMBER NUMBER (9)
CREATOR_TYPE_CODE VARCHAR2 (30) Yes
ENTRY_TYPE_CODE VARCHAR2 (30) Yes
REASON_CODE VARCHAR2 (30)
BALANCE_ADJ_COST_FLAG_CODE VARCHAR2 (30)
UPDATING_ACTION_TYPE_CODE VARCHAR2 (30)
ELEMENT_ENTRY_ID NUMBER (15) Yes
COST_ALLOCATION_KEYFLEX_ID NUMBER (9)
ASSIGNMENT_ID NUMBER (10) Yes
UPDATING_ACTION_ID NUMBER (15)
ELEMENT_LINK_ID NUMBER (9) Yes
ORIGINAL_ENTRY_ID NUMBER (15)
COMMENT_ID NUMBER (15)
CREATOR_ID NUMBER (15)
TARGET_ENTRY_ID NUMBER (15)
PERSONAL_PAYMENT_METHOD_ID NUMBER (9)
SOURCE_ID NUMBER (15)
SOURCE_ASG_ACTION_ID NUMBER (15)
SOURCE_LINK_ID NUMBER (9)
ELEMENT_TYPE_ID NUMBER (9)
LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER (15)
LAST_UPDATE_LOGIN NUMBER (15)
CREATED_BY NUMBER (15)
CREATION_DATE DATE

Query Text

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


SELECT EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      CREATOR_TYPE
,      ENTRY_TYPE
,      REASON
,      SUBPRIORITY
,      DATE_EARNED
,      BALANCE_ADJ_COST_FLAG
,      SOURCE_TRIGGER_ENTRY
,      SOURCE_PERIOD
,      SOURCE_RUN_TYPE
,      UPDATING_ACTION_TYPE
,      SOURCE_START_DATE
,      SOURCE_END_DATE
,      _DF:AEE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ENTRY_INFORMATION_CATEGORY
,      ENTRY_INFORMATION1
,      ENTRY_INFORMATION2
,      ENTRY_INFORMATION3
,      ENTRY_INFORMATION4
,      ENTRY_INFORMATION5
,      ENTRY_INFORMATION6
,      ENTRY_INFORMATION7
,      ENTRY_INFORMATION8
,      ENTRY_INFORMATION9
,      ENTRY_INFORMATION10
,      ENTRY_INFORMATION11
,      ENTRY_INFORMATION12
,      ENTRY_INFORMATION13
,      ENTRY_INFORMATION14
,      ENTRY_INFORMATION15
,      ENTRY_INFORMATION16
,      ENTRY_INFORMATION17
,      ENTRY_INFORMATION18
,      ENTRY_INFORMATION19
,      ENTRY_INFORMATION20
,      ENTRY_INFORMATION21
,      ENTRY_INFORMATION22
,      ENTRY_INFORMATION23
,      ENTRY_INFORMATION24
,      ENTRY_INFORMATION25
,      ENTRY_INFORMATION26
,      ENTRY_INFORMATION27
,      ENTRY_INFORMATION28
,      ENTRY_INFORMATION29
,      ENTRY_INFORMATION30
,      OBJECT_VERSION_NUMBER
,      CREATOR_TYPE_CODE
,      ENTRY_TYPE_CODE
,      REASON_CODE
,      BALANCE_ADJ_COST_FLAG_CODE
,      UPDATING_ACTION_TYPE_CODE
,      ELEMENT_ENTRY_ID
,      COST_ALLOCATION_KEYFLEX_ID
,      ASSIGNMENT_ID
,      UPDATING_ACTION_ID
,      ELEMENT_LINK_ID
,      ORIGINAL_ENTRY_ID
,      COMMENT_ID
,      CREATOR_ID
,      TARGET_ENTRY_ID
,      PERSONAL_PAYMENT_METHOD_ID
,      SOURCE_ID
,      SOURCE_ASG_ACTION_ID
,      SOURCE_LINK_ID
,      ELEMENT_TYPE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
FROM APPS.PAYBV_ELEMENT_ENTRY;

Dependencies

[top of page]

APPS.PAYBV_ELEMENT_ENTRY references the following:

SchemaAPPS
PL/SQL PackageHR_BIS - show dependent code
SynonymPAY_ELEMENT_ENTRIES_F

APPS.PAYBV_ELEMENT_ENTRY is not referenced by any database object