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

TABLE: CZ.CZ_XFR_PRICE_LISTS

Object Details
Object Name: CZ_XFR_PRICE_LISTS
Object Type: TABLE
Owner: CZ
FND Design Data: TableCZ.CZ_XFR_PRICE_LISTS
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
CZ_XFR_PRICE_LISTS_PK NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnPRICE_LIST_ID
Columns
Name Datatype Length Mandatory Comments
PRICE_LIST_ID NUMBER
Yes Price List Identifier
IMPORT_ITEM_PRICES VARCHAR2 (1)
'0' indicates the price list "header" should be imported without actual price entries '1' indicates that the price records should be imported into the PRICE table
DESCRIPTION VARCHAR2 (240)
Price List description
LAST_IMPORT_RUN_ID NUMBER

Identifies the last run ID in which this price list was imported
LAST_IMPORT_DATE DATE

Date/time when the price list was last imported
SOURCE_PRICE_DELETED VARCHAR2 (1)
'1' Indicates the import procedures detected that the price list was deleted
DELETED_FLAG VARCHAR2 (1) Yes '1' indicates that the price list was deleted
Query Text

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


SELECT PRICE_LIST_ID
,      IMPORT_ITEM_PRICES
,      DESCRIPTION
,      LAST_IMPORT_RUN_ID
,      LAST_IMPORT_DATE
,      SOURCE_PRICE_DELETED
,      DELETED_FLAG
FROM CZ.CZ_XFR_PRICE_LISTS;

Dependencies

[top of page]

CZ.CZ_XFR_PRICE_LISTS does not reference any database object

CZ.CZ_XFR_PRICE_LISTS is referenced by following:

SchemaAPPS
SynonymCZ_XFR_PRICE_LISTS