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

Object Details

Object Name:	HZ_DQM_P_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	AR.HZ_DQM_P_V
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
DQPARTY_ID	NUMBER	(15)	Yes	Party identifier
DQPARTY_TYPE	VARCHAR2	(80)		Description of the Quickcode
DQPARTY_NAME	VARCHAR2	(360)	Yes	Name of this party
DQPARTY_NUMBER	VARCHAR2	(30)	Yes	Unique identification number for this party
DQJGZZ_FISCAL_CODE	VARCHAR2	(20)		Taxpayer identification number, often unique identifier of person or organization. Can be SSN or income taxpayer ID in US, fiscal code or NIF in Europe
DQTAX_REFERENCE	VARCHAR2	(50)		Taxpayer registration number, also known as the VAT number.
DQDUNS_NUMBER_C	VARCHAR2	(30)		DUNS_NUMBER in VARCHAR format. Column value not restricted to nine digit DUNS Number.
DQCATEGORY_CODE	VARCHAR2	(80)		Description of the Quickcode
DQSIC_CODE	VARCHAR2	(30)		Standard Industry Classification (SIC) code
DQSTATUS	VARCHAR2	(1)	Yes	Party status flag.
DQSTATUSM	VARCHAR2	(4000)
DQADDRESS1	VARCHAR2	(240)
DQADDRESS2	VARCHAR2	(240)
DQADDRESS3	VARCHAR2	(240)
DQADDRESS4	VARCHAR2	(240)
DQCITY	VARCHAR2	(60)
DQPOSTAL_CODE	VARCHAR2	(60)
DQCOUNTY	VARCHAR2	(60)
DQCOUNTRY	VARCHAR2	(80)
DQSTATE	VARCHAR2	(60)
DQPROVINCE	VARCHAR2	(60)

Query Text

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


SELECT DQPARTY_ID
,      DQPARTY_TYPE
,      DQPARTY_NAME
,      DQPARTY_NUMBER
,      DQJGZZ_FISCAL_CODE
,      DQTAX_REFERENCE
,      DQDUNS_NUMBER_C
,      DQCATEGORY_CODE
,      DQSIC_CODE
,      DQSTATUS
,      DQSTATUSM
,      DQADDRESS1
,      DQADDRESS2
,      DQADDRESS3
,      DQADDRESS4
,      DQCITY
,      DQPOSTAL_CODE
,      DQCOUNTY
,      DQCOUNTRY
,      DQSTATE
,      DQPROVINCE
FROM APPS.HZ_DQM_P_V;

Dependencies

[top of page]

APPS.HZ_DQM_P_V references the following:

APPS: ARPT_SQL_FUNC_UTIL - show dependent code; AR_LOOKUPS; FND_TERRITORIES_VL; HZ_PARTIES

APPS.HZ_DQM_P_V is not referenced by any database object