[Home] [Help] [Dependency Information]
Object Name: | CZ_EXP_TMP_LINES |
---|---|
Object Type: | TABLE |
Owner: | CZ |
FND Design Data: | CZ.CZ_EXP_TMP_LINES |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CONFIG_ID | NUMBER | (9) | Configuration unique identifier for this order line | |
SELF_LINE | NUMBER | (9) | Identifies line to which this exported order line is mapped | |
CHILD_ID | NUMBER | (9) | Identifies a child order line for export | |
PARENT_ID | NUMBER | (9) | Identifies the parent record of this one to implement a data hierarchy | |
PARENT_LINE | NUMBER | (9) | Identifies the parent line of this exported order line | |
ROOT_LINE | NUMBER | (9) | Identifies root line of this exported order | |
ROOT_ID | NUMBER | (9) | Identifies root of this exported order | |
SO_ITEM_TYPE_CODE | VARCHAR2 | (30) | Item type code used in Order Entry: Model, Class, Kit, Standard | |
PS_NODE_TYPE | NUMBER | (9) | Associates a type with the psnode | |
QUOTE_HDR_ID | NUMBER | (9) | Yes | Associates this record with a customer quote |
QUOTE_REV_NBR | NUMBER | (9) | Yes | Identifies the revision of the associated customer quote |
BOM_REQUIRED_FLAG | VARCHAR2 | (1) | Flag indicating if the node is optional or required in BOM. | |
QUANTITY | NUMBER | (9) | Quantity of the item in this order line | |
CREATION_DATE | DATE | Standard field recording the date this record was created | ||
LAST_UPDATE_DATE | DATE | Standard field recording the date/time this record was last updated | ||
CREATED_BY | NUMBER | (15) | Standard field recording the ID of the user that created this record | |
LAST_UPDATED_BY | NUMBER | (15) | Standard field recording the ID of the user that last updated this record |
Cut, paste (and edit) the following text to query this object:
SELECT CONFIG_ID
, SELF_LINE
, CHILD_ID
, PARENT_ID
, PARENT_LINE
, ROOT_LINE
, ROOT_ID
, SO_ITEM_TYPE_CODE
, PS_NODE_TYPE
, QUOTE_HDR_ID
, QUOTE_REV_NBR
, BOM_REQUIRED_FLAG
, QUANTITY
, CREATION_DATE
, LAST_UPDATE_DATE
, CREATED_BY
, LAST_UPDATED_BY
FROM CZ.CZ_EXP_TMP_LINES;
CZ.CZ_EXP_TMP_LINES does not reference any database object
CZ.CZ_EXP_TMP_LINES is referenced by following:
|
|
|