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.BIL_DIMV_JOB_TITLE

Object Details

Object Name:	BIL_DIMV_JOB_TITLE
Object Type:	VIEW
Owner:	APPS
FND Design Data:	BIL.BIL_DIMV_JOB_TITLE
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

BIL_DIMV_JOB_TITLE - Dimension view used to provide descriptive information related to
employee job title. Used for reporting on salesforce.
.
Source is Oracle CRM Sales Schema.
.
.

[View Source]

Columns

Name	Datatype	Length	Comments
JOB_PK	NUMBER		Sales representative job identifier
JOB_TITLE	VARCHAR2	(700)	Sales representative job name
ID	VARCHAR2	(40)	Sales representative job identifier
VALUE	VARCHAR2	(700)	Sales representative job name

Query Text

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


SELECT JOB_PK
,      JOB_TITLE
,      ID
,      VALUE
FROM APPS.BIL_DIMV_JOB_TITLE;

Dependencies

[top of page]

APPS.BIL_DIMV_JOB_TITLE references the following:

APPS: FND_GLOBAL - show dependent code; FND_LOOKUPS; PER_JOBS

APPS.BIL_DIMV_JOB_TITLE is not referenced by any database object