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

TABLE: DDR.DDR_B_RTL_SL_ADDTNL_MSRS

Object Details
Object Name: DDR_B_RTL_SL_ADDTNL_MSRS
Object Type: TABLE
Owner: DDR
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
RTL_ORG_CD VARCHAR2 (30) Yes Retailer Organization Code
ORG_BSNS_UNIT_ID NUMBER
Yes Organization Business Unit ID
DAY_CD VARCHAR2 (30) Yes Day Code
MFG_SKU_ITEM_ID NUMBER
Yes Manufacturer SKU Item ID
RTL_SKU_ITEM_ID NUMBER
Yes Retail SKU Item ID
MEASURE1 DATE

Measure 1
MEASURE2 DATE

Measure 2
MEASURE3 NUMBER

Measure 3
MEASURE4 NUMBER

Measure4
MEASURE5 NUMBER

Measure 5
MEASURE6 NUMBER

Measure 6
MEASURE7 NUMBER

Measure 7
MEASURE8 NUMBER

Measure 8
MEASURE9 NUMBER

Measure 9
MEASURE10 NUMBER

Measure 10
Query Text

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


SELECT RTL_ORG_CD
,      ORG_BSNS_UNIT_ID
,      DAY_CD
,      MFG_SKU_ITEM_ID
,      RTL_SKU_ITEM_ID
,      MEASURE1
,      MEASURE2
,      MEASURE3
,      MEASURE4
,      MEASURE5
,      MEASURE6
,      MEASURE7
,      MEASURE8
,      MEASURE9
,      MEASURE10
FROM DDR.DDR_B_RTL_SL_ADDTNL_MSRS;

Dependencies

[top of page]

DDR.DDR_B_RTL_SL_ADDTNL_MSRS does not reference any database object

DDR.DDR_B_RTL_SL_ADDTNL_MSRS is referenced by following:

SchemaDDR
ViewDDR_B_RTL_SL_ADDTNL_MSRS#