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


VIEW: APPS.HZ_DQM_AC_AS_V

Object Details
Object Name: HZ_DQM_AC_AS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewAR.HZ_DQM_AC_AS_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
DQCUST_ACCOUNT_ID NUMBER (15) Yes
DQCUST_ACCT_SITE_ID NUMBER (15) Yes
DQPARTY_SITE_ID NUMBER (15) Yes
DQBILL_TO_FLAG VARCHAR2 (1)
DQSHIP_TO_FLAG VARCHAR2 (1)
DQSTATUS VARCHAR2 (1) Yes
DQSTATUSM VARCHAR2 (4000)
DQADDRESS1 VARCHAR2 (240) Yes
DQADDRESS2 VARCHAR2 (240)
DQCITY VARCHAR2 (60)
DQPROVINCE VARCHAR2 (60)
DQCOUNTY VARCHAR2 (60)
DQCOUNTRY VARCHAR2 (80)
DQSTATE VARCHAR2 (60)
DQPOSTAL_CODE VARCHAR2 (60)
DQORG_ID NUMBER (15)
Query Text

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


SELECT DQPARTY_ID
,      DQCUST_ACCOUNT_ID
,      DQCUST_ACCT_SITE_ID
,      DQPARTY_SITE_ID
,      DQBILL_TO_FLAG
,      DQSHIP_TO_FLAG
,      DQSTATUS
,      DQSTATUSM
,      DQADDRESS1
,      DQADDRESS2
,      DQCITY
,      DQPROVINCE
,      DQCOUNTY
,      DQCOUNTRY
,      DQSTATE
,      DQPOSTAL_CODE
,      DQORG_ID
FROM APPS.HZ_DQM_AC_AS_V;

Dependencies

[top of page]

APPS.HZ_DQM_AC_AS_V references the following:

SchemaAPPS
PL/SQL PackageARH_DQM_TREE_HELPER - show dependent code
PL/SQL PackageARPT_SQL_FUNC_UTIL - show dependent code
ViewFND_TERRITORIES_VL
SynonymHZ_CUST_ACCOUNTS
SynonymHZ_CUST_ACCT_SITES_ALL
SynonymHZ_LOCATIONS
SynonymHZ_MATCHED_PARTY_SITES_GT
SynonymHZ_PARTY_SITES

APPS.HZ_DQM_AC_AS_V is not referenced by any database object