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

Object Details

Object Name:	PMI_HZ_PARTY_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PMI.PMI_HZ_PARTY_V
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PARTY_ID	NUMBER	(15)	Yes	Party identifier
PARTY_NUMBER	VARCHAR2	(30)	Yes	Unique identification number for this party
PARTY_NAME	VARCHAR2	(360)	Yes	Name of this party
PARTY_TYPE	VARCHAR2	(30)	Yes	The party type can only be Person, Organization, Group or Relationship.
PARTY_CITY	VARCHAR2	(60)		City of the Identifying address
PARTY_STATE	VARCHAR2	(60)		State of the Identifying address
PARTY_COUNTRY	VARCHAR2	(60)		The country listed in the TERRITORY_CODE column of the FND_TERRITORY table. for the Identifying address.
LOCATION_ID	NUMBER	(15)	Yes	Unique identifier for this location
SITE_USE_ID	NUMBER	(15)	Yes	Site use identifier
PARTY_SITE_NUMBER	VARCHAR2	(30)	Yes	Party site number
PARTY_SITE_NAME	VARCHAR2	(240)		User-defined name for the site
PARTY_SITE_CITY	VARCHAR2	(60)		City
PARTY_SITE_STATE	VARCHAR2	(60)		State
PARTY_SITE_COUNTRY	VARCHAR2	(60)	Yes	Country code from the TERRITORY_CODE column in the FND_TERRITORY table

Query Text

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


SELECT PARTY_ID
,      PARTY_NUMBER
,      PARTY_NAME
,      PARTY_TYPE
,      PARTY_CITY
,      PARTY_STATE
,      PARTY_COUNTRY
,      LOCATION_ID
,      SITE_USE_ID
,      PARTY_SITE_NUMBER
,      PARTY_SITE_NAME
,      PARTY_SITE_CITY
,      PARTY_SITE_STATE
,      PARTY_SITE_COUNTRY
FROM APPS.PMI_HZ_PARTY_V;

Dependencies

[top of page]

APPS.PMI_HZ_PARTY_V references the following:

APPS: HZ_CUST_ACCT_SITES_ALL; HZ_CUST_SITE_USES_ALL; HZ_LOCATIONS; HZ_PARTIES; HZ_PARTY_SITES

APPS.PMI_HZ_PARTY_V is referenced by following:

APPS: PMIBV_LOT_DEST_SHIP_V; PMIBV_LOT_SHARED_SHIP_V; PMIFV_LOT_DEST_SHIP_V; PMIFV_LOT_SHARED_SHIP_V; PMIFV_SALES_DETAILS_V; PMI_SALES_PKG - show dependent code