[Home] [Help] [Dependency Information]
Object Name: | OZF_OFFER_ADJ_RLTD_LINES |
---|---|
Object Type: | TABLE |
Owner: | OZF |
FND Design Data: | OZF.OZF_OFFER_ADJ_RLTD_LINES |
Subobject Name: | |
Status: | VALID |
This table is used for Trade Deal offer adjustment. Trade Deal Offers can have two modifiers in one deal line. This table captures the relation between two lines. From_list_line_id and to_list_line_id are foreign keys to list_line_id in QP_LIST_LINES.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
OZF_OFFER_ADJ_RLTD_LINES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | OFFER_ADJ_RLTD_LINE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OFFER_ADJ_RLTD_LINE_ID | NUMBER | Yes | Unique identifier | |
OFFER_ADJUSTMENT_ID | NUMBER | Yes | Identifier of offer adjustment | |
FROM_LIST_LINE_ID | NUMBER | Yes | list_line_id in QP_LIST_LINES. This could correspond to any of the modifiers on the deal lines. | |
TO_LIST_LINE_ID | NUMBER | Yes | list_line_id in QP_LIST_LINES. This could correspond to any of the modifiers on the deal lines. | |
LAST_UPDATE_DATE | DATE | Yes | Standard WHO Column | |
LAST_UPDATED_BY | NUMBER | Yes | Standard WHO Column | |
CREATION_DATE | DATE | Yes | Standard WHO Column | |
CREATED_BY | NUMBER | Yes | Standard WHO Column | |
LAST_UPDATE_LOGIN | NUMBER | Standard WHO Column | ||
OBJECT_VERSION_NUMBER | NUMBER | Yes | Standard WHO Column | |
SECURITY_GROUP_ID | NUMBER | Security group id |
Cut, paste (and edit) the following text to query this object:
SELECT OFFER_ADJ_RLTD_LINE_ID
, OFFER_ADJUSTMENT_ID
, FROM_LIST_LINE_ID
, TO_LIST_LINE_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER
, SECURITY_GROUP_ID
FROM OZF.OZF_OFFER_ADJ_RLTD_LINES;
OZF.OZF_OFFER_ADJ_RLTD_LINES does not reference any database object
OZF.OZF_OFFER_ADJ_RLTD_LINES is referenced by following:
|
|
|