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


VIEW: APPS.OIE_ATTENDEES

Object Details
Object Name: OIE_ATTENDEES
Object Type: VIEW
Owner: APPS
FND Design Data: ViewSQLAP.OIE_ATTENDEES
Subobject Name:
Status: VALID

View Type

A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.

[View Source]

Columns
Name Datatype Length Mandatory Comments
ATTENDEE_LINE_ID NUMBER (15) Yes
REPORT_LINE_ID NUMBER (15) Yes
EMPLOYEE_FLAG VARCHAR2 (1)
EMPLOYEE_ID NUMBER (15)
ATTENDEE_TYPE VARCHAR2 (30)
NAME VARCHAR2 (240)
TITLE VARCHAR2 (240)
EMPLOYER VARCHAR2 (80)
EMPLOYER_ADDRESS VARCHAR2 (240)
TAX_ID VARCHAR2 (30)
ORG_ID NUMBER (15)
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER (15) Yes
LAST_UPDATE_LOGIN NUMBER (15)
ATTRIBUTE_CATEGORY VARCHAR2 (150)
Attribute category column for DFF
ATTRIBUTE1 VARCHAR2 (150)
Attribute column for DFF
ATTRIBUTE2 VARCHAR2 (15)
Attribute column for DFF
ATTRIBUTE3 VARCHAR2 (150)
Attribute column for DFF
ATTRIBUTE4 VARCHAR2 (150)
Attribute column for DFF
ATTRIBUTE5 VARCHAR2 (150)
Attribute column for DFF
ATTRIBUTE6 VARCHAR2 (150)
Attribute column for DFF
ATTRIBUTE7 VARCHAR2 (150)
Attribute column for DFF
ATTRIBUTE8 VARCHAR2 (150)
Attribute column for DFF
ATTRIBUTE9 VARCHAR2 (150)
Attribute column for DFF
ATTRIBUTE10 VARCHAR2 (150)
Attribute column for DFF
ATTRIBUTE11 VARCHAR2 (150)
Attribute column for DFF
ATTRIBUTE12 VARCHAR2 (150)
Attribute column for DFF
ATTRIBUTE13 VARCHAR2 (150)
Attribute column for DFF
ATTRIBUTE14 VARCHAR2 (150)
Attribute column for DFF
ATTRIBUTE15 VARCHAR2 (150)
Attribute column for DFF
Query Text

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


SELECT ATTENDEE_LINE_ID
,      REPORT_LINE_ID
,      EMPLOYEE_FLAG
,      EMPLOYEE_ID
,      ATTENDEE_TYPE
,      NAME
,      TITLE
,      EMPLOYER
,      EMPLOYER_ADDRESS
,      TAX_ID
,      ORG_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
FROM APPS.OIE_ATTENDEES;

Dependencies

[top of page]

APPS.OIE_ATTENDEES references the following:

SchemaAPPS
SynonymOIE_ATTENDEES_ALL
APPS.OIE_ATTENDEES is referenced by following:

SchemaAPPS
Package BodyAP_WEB_DB_EXP_ATTENDEES_PKG - show dependent code