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_PARTNER_LOV_V

Object Details

Object Name:	PV_PARTNER_LOV_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PV.PV_PARTNER_LOV_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
PARTY_NAME	VARCHAR2	(360)	Yes	Party name
PARTY_NUMBER	VARCHAR2	(30)	Yes	Party number
PARTY_ID	NUMBER	(15)	Yes	Party identifier
LOCATION_ID	NUMBER	(15)		Location identifier
SITE_ID	NUMBER	(15)		Site identifier
SITE_USE_ID	NUMBER	(15)		Site in use identifier
ADDRESS1	VARCHAR2	(240)		First line for address
ADDRESS2	VARCHAR2	(240)		Second line for address
ADDRESS3	VARCHAR2	(240)		Third line for address
ADDRESS4	VARCHAR2	(240)		Fourth line for address
CITY	VARCHAR2	(60)		City
STATE	VARCHAR2	(60)		State
PROVINCE	VARCHAR2	(60)		Province
POSTAL_CODE	VARCHAR2	(60)		Postal code
COUNTY	VARCHAR2	(60)		County
COUNTRY	VARCHAR2	(60)		Country
SITE_USE_TYPE	VARCHAR2	(30)		Site use type
IDENTIFYING_ADDRESS_FLAG	VARCHAR2	(1)		Indicates if this is the identifying address for the party. Y for the indentifying, N for sites that are not the indentifying site
STATUS	VARCHAR2	(1)		Party site status flag.
PARTY_TYPE	VARCHAR2	(30)	Yes	The party type can only be Person, Organization, Group or Relationship.

Query Text

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


SELECT PARTY_NAME
,      PARTY_NUMBER
,      PARTY_ID
,      LOCATION_ID
,      SITE_ID
,      SITE_USE_ID
,      ADDRESS1
,      ADDRESS2
,      ADDRESS3
,      ADDRESS4
,      CITY
,      STATE
,      PROVINCE
,      POSTAL_CODE
,      COUNTY
,      COUNTRY
,      SITE_USE_TYPE
,      IDENTIFYING_ADDRESS_FLAG
,      STATUS
,      PARTY_TYPE
FROM APPS.PV_PARTNER_LOV_V;

Dependencies

[top of page]

APPS.PV_PARTNER_LOV_V references the following:

APPS: HZ_LOCATIONS; HZ_PARTIES; HZ_PARTY_SITES; HZ_PARTY_SITE_USES

APPS.PV_PARTNER_LOV_V is not referenced by any database object