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

VIEW: CZ.CZ_OPPORTUNITY_HDRS#

Object Details
Object Name: CZ_OPPORTUNITY_HDRS#
Object Type: VIEW
Owner: CZ
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
LAST_UPDATE_LOGIN NUMBER (15)
OPPORTUNITY_HDR_ID NUMBER (9) Yes
CUSTOMER_ID NUMBER (9)
OPPTY_DESC VARCHAR2 (255)
OPPTY_STATUS VARCHAR2 (20)
OPPTY_NOTE VARCHAR2 (255)
END_USER_ID NUMBER (9)
OPPTY_NAME VARCHAR2 (255)
USER_NUM01 NUMBER (16)
USER_NUM02 NUMBER (16)
USER_NUM03 NUMBER (16)
USER_NUM04 NUMBER (16)
USER_STR01 VARCHAR2 (255)
USER_STR02 VARCHAR2 (255)
USER_STR03 VARCHAR2 (255)
USER_STR04 VARCHAR2 (255)
CREATION_DATE DATE
Yes
LAST_UPDATE_DATE DATE
Yes
DELETED_FLAG VARCHAR2 (1) Yes
EFF_FROM DATE

EFF_TO DATE

CREATED_BY NUMBER (15) Yes
LAST_UPDATED_BY NUMBER (15) Yes
SECURITY_MASK VARCHAR2 (40)
EFF_MASK VARCHAR2 (40)
CHECKOUT_USER VARCHAR2 (40)
Query Text

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


SELECT LAST_UPDATE_LOGIN
,      OPPORTUNITY_HDR_ID
,      CUSTOMER_ID
,      OPPTY_DESC
,      OPPTY_STATUS
,      OPPTY_NOTE
,      END_USER_ID
,      OPPTY_NAME
,      USER_NUM01
,      USER_NUM02
,      USER_NUM03
,      USER_NUM04
,      USER_STR01
,      USER_STR02
,      USER_STR03
,      USER_STR04
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      DELETED_FLAG
,      EFF_FROM
,      EFF_TO
,      CREATED_BY
,      LAST_UPDATED_BY
,      SECURITY_MASK
,      EFF_MASK
,      CHECKOUT_USER
FROM CZ.CZ_OPPORTUNITY_HDRS#;

Dependencies

[top of page]

CZ.CZ_OPPORTUNITY_HDRS# references the following:

SchemaCZ
TableCZ_OPPORTUNITY_HDRS
CZ.CZ_OPPORTUNITY_HDRS# is referenced by following:

SchemaAPPS
SynonymCZ_OPPORTUNITY_HDRS
TriggerCZ_OPPORTUNITY_HDRS_T1