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


VIEW: APPS.HZ_DQM_CS_U_V

Object Details
Object Name: HZ_DQM_CS_U_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewAR.HZ_DQM_CS_U_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
DQCUST_ACCT_SITE_ID NUMBER (15) Yes Customer site identifier
DQSITE_USE_ID NUMBER (15) Yes Site use identifier
DQSITE_USE_CODE VARCHAR2 (30) Yes Business purpose assigned to customer site account, such as Bill-To, Market, and Statements.
DQPRIMARY_FLAG VARCHAR2 (1) Yes Indicates if this site is the primary site for this customer account. Y for the primary customer account site. N for other customer account sites.
DQMEANING VARCHAR2 (80)
Description of the Quickcode
DQSTATUS VARCHAR2 (1) Yes Site use status flag, Lookup code for the CODE_STATUS column.
DQSTATUSM VARCHAR2 (4000)
DQLOCATION VARCHAR2 (40) Yes
DQORG_ID NUMBER (15)
Query Text

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


SELECT DQCUST_ACCT_SITE_ID
,      DQSITE_USE_ID
,      DQSITE_USE_CODE
,      DQPRIMARY_FLAG
,      DQMEANING
,      DQSTATUS
,      DQSTATUSM
,      DQLOCATION
,      DQORG_ID
FROM APPS.HZ_DQM_CS_U_V;

Dependencies

[top of page]

APPS.HZ_DQM_CS_U_V references the following:

SchemaAPPS
PL/SQL PackageARPT_SQL_FUNC_UTIL - show dependent code
ViewAR_LOOKUPS
SynonymHZ_CUST_ACCT_SITES_ALL
SynonymHZ_CUST_SITE_USES_ALL

APPS.HZ_DQM_CS_U_V is not referenced by any database object