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

VIEW: CZ.CZ_QUOTE_SPECIAL_ITEMS#

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
LAST_UPDATE_LOGIN NUMBER (15)
SEQ_NUMBER NUMBER (9) Yes
QUOTE_REV_NBR NUMBER (9) Yes
QUOTE_HDR_ID NUMBER (9) Yes
PACKAGE_SEQ NUMBER (9) Yes
TYPE_FLAG VARCHAR2 (1) Yes
SPEC_ITEM_NAME VARCHAR2 (255) Yes
LEAD_TIME NUMBER (9)
ITEM_QTY NUMBER (9)
ITEM_COMMENT VARCHAR2 (255)
SPEC_ITEM_TEXT VARCHAR2 (255)
SPEC_ITEM_PRICE NUMBER (16)
DISC_PERCENTAGE NUMBER (16)
DISC_TYPE VARCHAR2 (1)
QUOTED_LIST_PRICE NUMBER (16)
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
,      SEQ_NUMBER
,      QUOTE_REV_NBR
,      QUOTE_HDR_ID
,      PACKAGE_SEQ
,      TYPE_FLAG
,      SPEC_ITEM_NAME
,      LEAD_TIME
,      ITEM_QTY
,      ITEM_COMMENT
,      SPEC_ITEM_TEXT
,      SPEC_ITEM_PRICE
,      DISC_PERCENTAGE
,      DISC_TYPE
,      QUOTED_LIST_PRICE
,      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_QUOTE_SPECIAL_ITEMS#;

Dependencies

[top of page]

CZ.CZ_QUOTE_SPECIAL_ITEMS# references the following:

SchemaCZ
TableCZ_QUOTE_SPECIAL_ITEMS
CZ.CZ_QUOTE_SPECIAL_ITEMS# is referenced by following:

SchemaAPPS
SynonymCZ_QUOTE_SPECIAL_ITEMS
TriggerCZ_QUOTE_SPECIAL_ITEMS_T1