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

VIEW: CZ.CZ_CONFIG_USAGES#

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
CALLING_APPLICATION_ID NUMBER
Yes
CALLING_APPLICATION_REF_KEY VARCHAR2 (255) Yes
CONFIG_HDR_ID NUMBER
Yes
CONFIG_REV_NBR NUMBER
Yes
CONFIG_ITEM_ID NUMBER (15) Yes
LIST_PRICE NUMBER

AUTO_DISCOUNT_ID NUMBER

AUTO_DISCOUNT_LINE_ID NUMBER

AUTO_DISCOUNT_PCT NUMBER

MANUAL_DISCOUNT_ID NUMBER

MANUAL_DISCOUNT_LINE_ID NUMBER

MANUAL_DISCOUNT_PCT NUMBER

DISCOUNTED_PRICE NUMBER

ATP_DATE DATE

UOM_CODE VARCHAR2 (3)
LAST_UPDATE_LOGIN NUMBER (15)
CREATION_DATE DATE
Yes
LAST_UPDATE_DATE DATE
Yes
CREATED_BY NUMBER (15) Yes
LAST_UPDATED_BY NUMBER (15) Yes
SECURITY_MASK VARCHAR2 (40)
EFF_MASK VARCHAR2 (40)
CHECKOUT_USER VARCHAR2 (40)
DELETED_FLAG VARCHAR2 (1) Yes
EFF_FROM DATE

EFF_TO DATE

Query Text

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


SELECT CALLING_APPLICATION_ID
,      CALLING_APPLICATION_REF_KEY
,      CONFIG_HDR_ID
,      CONFIG_REV_NBR
,      CONFIG_ITEM_ID
,      LIST_PRICE
,      AUTO_DISCOUNT_ID
,      AUTO_DISCOUNT_LINE_ID
,      AUTO_DISCOUNT_PCT
,      MANUAL_DISCOUNT_ID
,      MANUAL_DISCOUNT_LINE_ID
,      MANUAL_DISCOUNT_PCT
,      DISCOUNTED_PRICE
,      ATP_DATE
,      UOM_CODE
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      SECURITY_MASK
,      EFF_MASK
,      CHECKOUT_USER
,      DELETED_FLAG
,      EFF_FROM
,      EFF_TO
FROM CZ.CZ_CONFIG_USAGES#;

Dependencies

[top of page]

CZ.CZ_CONFIG_USAGES# references the following:

SchemaCZ
TableCZ_CONFIG_USAGES
CZ.CZ_CONFIG_USAGES# is referenced by following:

SchemaAPPS
SynonymCZ_CONFIG_USAGES
TriggerCZ_CONFIG_USAGES_T1