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

TABLE: AMS.AMS_RELATED_DEAL_LINES

Object Details
Object Name: AMS_RELATED_DEAL_LINES
Object Type: TABLE
Owner: AMS
FND Design Data: TableAMS.AMS_RELATED_DEAL_LINES
Subobject Name:
Status: VALID


This table is used for Trade Deal Offers. Trade Deal Offers can have two modifiers in one deal line. This table will capture the relation between two lines. Modifier_id and related_modifier_id are foreign keys to list_line_id in QP_LIST_LINES.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AMS_RELATED_DEAL_LINES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnRELATED_DEAL_LINES_ID
Columns
Name Datatype Length Mandatory Comments
RELATED_DEAL_LINES_ID NUMBER
Yes Unique Identifier
MODIFIER_ID NUMBER

list_line_id in QP_LIST_LINES. This could correspond to any of the modifiers on the deal lines.
RELATED_MODIFIER_ID NUMBER

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 (15) Yes Standard WHO Column
CREATION_DATE DATE
Yes Standard WHO Column
CREATED_BY NUMBER (15) Yes Standard WHO Column
LAST_UPDATE_LOGIN NUMBER

Standard WHO Column
OBJECT_VERSION_NUMBER NUMBER (9)
Column Used for Locking purposes
SECURITY_GROUP_ID NUMBER

Used in Hosted environments
ESTIMATED_QTY_IS_MAX VARCHAR2 (1)
Flag indicating that the estimated quantity is pushed as a limit into QP
ESTIMATED_AMOUNT_IS_MAX VARCHAR2 (1)
Flag indicating that the estimated quantity is pushed as a limit into QP
QP_LIST_HEADER_ID NUMBER
Yes QP_LIST_HEADER_ID from ams_offers.
ESTIMATED_QTY NUMBER (15)
Forecasted Quantity
ESTIMATE_QTY_UOM VARCHAR2 (3)
Forecast Quantity Unit Of Measure
ESTIMATED_AMOUNT NUMBER (15)
Forecast Amount
Query Text

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


SELECT RELATED_DEAL_LINES_ID
,      MODIFIER_ID
,      RELATED_MODIFIER_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      SECURITY_GROUP_ID
,      ESTIMATED_QTY_IS_MAX
,      ESTIMATED_AMOUNT_IS_MAX
,      QP_LIST_HEADER_ID
,      ESTIMATED_QTY
,      ESTIMATE_QTY_UOM
,      ESTIMATED_AMOUNT
FROM AMS.AMS_RELATED_DEAL_LINES;

Dependencies

[top of page]

AMS.AMS_RELATED_DEAL_LINES does not reference any database object

AMS.AMS_RELATED_DEAL_LINES is referenced by following:

SchemaAPPS
SynonymAMS_RELATED_DEAL_LINES