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

Object Details

Object Name:	PV_LEAD_PSS_LINES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PV.PV_LEAD_PSS_LINES_V
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
LEAD_PSS_LINE_ID	NUMBER	(15)	Yes	Partner solutions or/and services lead identifier
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)	Yes	Standard Who column
OBJECT_VERSION_NUMBER	NUMBER	(15)	Yes
REQUEST_ID	NUMBER	(15)		Standard Who column
PROGRAM_APPLICATION_ID	NUMBER	(15)		Application identifier of last concurrent program to update record
PROGRAM_ID	NUMBER	(15)
PROGRAM_UPDATE_DATE	DATE			Last date concurrent program updated record
ATTR_CODE_ID	NUMBER	(15)	Yes	Attribute code identifier
LEAD_ID	NUMBER	(15)		Lead or sales lead identifier
UOM_CODE	VARCHAR2	(3)		Units of measurements
QUANTITY	NUMBER			Partner solutions or/and service quantity
AMOUNT	NUMBER			Partner solutions or/and service amount
OBJECT_NAME	VARCHAR2	(30)	Yes	Identifies whether it is a lead or an opportunity
ATTR_CODE	VARCHAR2	(30)	Yes	Attribute code
DESCRIPTION	VARCHAR2	(240)	Yes	Attribute code Description
ATTRIBUTE_ID	NUMBER		Yes	Attribute identifier
ENABLED_FLAG	VARCHAR2	(1)	Yes	Flag to indicate whether the attribute code is in use or not
START_DATE_ACTIVE	DATE			Date from which the attribute code is active
END_DATE_ACTIVE	DATE			Date up to which the code remains active
AUTO_ASSIGN_FLAG	VARCHAR2	(1)		Flag indicates whether the attribute is enabled for automatic matching
OBJECT_ID	NUMBER
PARTNER_ID	NUMBER

Query Text

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


SELECT LEAD_PSS_LINE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ATTR_CODE_ID
,      LEAD_ID
,      UOM_CODE
,      QUANTITY
,      AMOUNT
,      OBJECT_NAME
,      ATTR_CODE
,      DESCRIPTION
,      ATTRIBUTE_ID
,      ENABLED_FLAG
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      AUTO_ASSIGN_FLAG
,      OBJECT_ID
,      PARTNER_ID
FROM APPS.PV_LEAD_PSS_LINES_V;

Dependencies

[top of page]

APPS.PV_LEAD_PSS_LINES_V references the following:

APPS: PV_ATTRIBUTE_CODES_B; PV_ATTRIBUTE_CODES_TL; PV_LEAD_PSS_LINES

APPS.PV_LEAD_PSS_LINES_V is not referenced by any database object