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

TABLE: RLM.RLM_BLANKET_RSO

Object Details
Object Name: RLM_BLANKET_RSO
Object Type: TABLE
Owner: RLM
FND Design Data: TableRLM.RLM_BLANKET_RSO
Subobject Name:
Status: VALID


This table stores information related to the effective start and end dates of releases created against a blanket sales agreement.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
RLM_BLANKET_RSO_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnRSO_HDR_ID
ColumnEFFECTIVE_START_DATE
ColumnEFFECTIVE_END_DATE
RLM_BLANKET_RSO_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBLANKET_NUMBER
Columns
Name Datatype Length Mandatory Comments
CUSTOMER_ID NUMBER
Yes Customer ID
BLANKET_NUMBER NUMBER
Yes Blanket Sales Agreement
RSO_HDR_ID NUMBER
Yes Release Sales Order Header ID
CUSTOMER_ITEM_ID NUMBER

Customer Item ID
EFFECTIVE_START_DATE DATE
Yes Effective Start Date of the release sales order
EFFECTIVE_END_DATE DATE
Yes Effective End Date of the release sales order
Query Text

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


SELECT CUSTOMER_ID
,      BLANKET_NUMBER
,      RSO_HDR_ID
,      CUSTOMER_ITEM_ID
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
FROM RLM.RLM_BLANKET_RSO;

Dependencies

[top of page]

RLM.RLM_BLANKET_RSO does not reference any database object

RLM.RLM_BLANKET_RSO is referenced by following:

SchemaAPPS
SynonymRLM_BLANKET_RSO