DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.HZ_DQM_PS_V

Object Details
Object Name: HZ_DQM_PS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewAR.HZ_DQM_PS_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_SITE_ID NUMBER (15) Yes Party site identifier
DQPARTY_ID NUMBER (15) Yes Identifier for the party. Foreign key to the HZ_PARTIES table.
DQSTATUS VARCHAR2 (8)
DQSTATUSM VARCHAR2 (4000)
DQADDRESS VARCHAR2 (481)
DQCOUNTY VARCHAR2 (60)
DQPROVINCE VARCHAR2 (60)
DQCITY VARCHAR2 (60)
DQSTATE VARCHAR2 (60)
DQPOSTAL_CODE VARCHAR2 (60)
DQCOUNTRY VARCHAR2 (80)
Query Text

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


SELECT DQPARTY_SITE_ID
,      DQPARTY_ID
,      DQSTATUS
,      DQSTATUSM
,      DQADDRESS
,      DQCOUNTY
,      DQPROVINCE
,      DQCITY
,      DQSTATE
,      DQPOSTAL_CODE
,      DQCOUNTRY
FROM APPS.HZ_DQM_PS_V;

Dependencies

[top of page]

APPS.HZ_DQM_PS_V references the following:

SchemaAPPS
PL/SQL PackageARPT_SQL_FUNC_UTIL - show dependent code
ViewFND_TERRITORIES_VL
SynonymHZ_LOCATIONS
SynonymHZ_PARTY_SITES

APPS.HZ_DQM_PS_V is not referenced by any database object