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_SALESFORCE

Object Details

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

View Type

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

BIL_DIMV_SALESFORCE - Dimension view used to provide descriptive information for salesforce
members (salesreps), using resource_id in jtf_rs_resource_extns table.
.
Source is Oracle Applications Human Resource and CRM Foundation schemas.
.
.

[View Source]

Columns

Name	Datatype	Length	Comments
SALESFORCE_PK	NUMBER		Resource identifier for salesrep
RESOURCE_NUMBER	VARCHAR2	(30)	Resource Number for sales person. This is a Unique and shown to user on forms.
SALESFORCE_STATUS	NUMBER		Status of salesrep whether he or she is active in AR or not ( Used for OTHER type of Salesreps)
SALESFORCE_TYPE	VARCHAR2	(30)	Category of Resource. Validating from JTF_OBJECTS_VL. Allowed values: EMPLOYEE, PARTNER, PARTY, SUPPLIER_CONTACT, OTHER
EMPLOYEE_PERSON_FK	VARCHAR2	(30)	Salesrep employee id
LAST_NAME	VARCHAR2	(150)	Salesrep last name
FIRST_NAME	VARCHAR2	(150)	Salesrep first name
FULL_NAME	VARCHAR2	(301)	Salesrep full name
COMPENSATION_CURRENCY_CODE	VARCHAR2	(15)	Currency in which salesrep is compensated
START_DATE_ACTIVE	DATE		Date this Resource becomes active, if limited
END_DATE_ACTIVE	DATE		Date this Resource becomes inactive, if limited
EMPLOYMENT_STATUS_FK	VARCHAR2	(30)	User defined category. For example Full-Time Permanent or Part-Time Permanent.
JOB_FK	NUMBER		Salesrep job title
MANAGING_EMPLOYEE_ID	NUMBER		Employee id of salesrep's manager
ID	VARCHAR2	(40)	Salesrep id
VALUE	VARCHAR2	(80)	Salesrep name

Query Text

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


SELECT SALESFORCE_PK
,      RESOURCE_NUMBER
,      SALESFORCE_STATUS
,      SALESFORCE_TYPE
,      EMPLOYEE_PERSON_FK
,      LAST_NAME
,      FIRST_NAME
,      FULL_NAME
,      COMPENSATION_CURRENCY_CODE
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      EMPLOYMENT_STATUS_FK
,      JOB_FK
,      MANAGING_EMPLOYEE_ID
,      ID
,      VALUE
FROM APPS.BIL_DIMV_SALESFORCE;

Dependencies

[top of page]

APPS.BIL_DIMV_SALESFORCE references the following:

APPS: FND_GLOBAL - show dependent code; FND_LOOKUPS; JTF_RS_RESOURCE_EXTNS; JTF_RS_SALESREPS; PER_ALL_ASSIGNMENTS_F; PER_ALL_PEOPLE_F

APPS.BIL_DIMV_SALESFORCE is referenced by following:

APPS: BIL_DIMV_QUALIFICATIONS; BIL_DIMV_SKILLS