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

TABLE: DDR.DDR_B_EXCPTN_ITEM_DAY

Object Details
Object Name: DDR_B_EXCPTN_ITEM_DAY
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
MFG_ORG_CD VARCHAR2 (30) Yes Manufacturer Organization Code
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
EXCPTN_TYP VARCHAR2 (30) Yes Exception Type
EXCPTN_QTY NUMBER

Exception Quantity
EXCPTN_AMT NUMBER

Exception Amount
EXCPTN_SRC_CD VARCHAR2 (30) Yes Exception Source Code
CRTD_BY_DSR VARCHAR2 (30) Yes Audit Fields
LAST_UPDT_BY_DSR VARCHAR2 (30) Yes Audit Fields
CREATED_BY NUMBER (15) Yes Audit Fields
CREATION_DATE DATE
Yes Audit Fields timestamp
LAST_UPDATED_BY NUMBER (15) Yes Audit Fields
LAST_UPDATE_DATE DATE
Yes Audit Fields timestamp
LAST_UPDATE_LOGIN NUMBER (15) Yes Audit Fields timestamp
Query Text

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


SELECT MFG_ORG_CD
,      RTL_ORG_CD
,      ORG_BSNS_UNIT_ID
,      DAY_CD
,      MFG_SKU_ITEM_ID
,      RTL_SKU_ITEM_ID
,      EXCPTN_TYP
,      EXCPTN_QTY
,      EXCPTN_AMT
,      EXCPTN_SRC_CD
,      CRTD_BY_DSR
,      LAST_UPDT_BY_DSR
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM DDR.DDR_B_EXCPTN_ITEM_DAY;

Dependencies

[top of page]

DDR.DDR_B_EXCPTN_ITEM_DAY does not reference any database object

DDR.DDR_B_EXCPTN_ITEM_DAY is referenced by following:

SchemaAPPS
Materialized ViewDDR_BS_EXCPTN_SKU_BU_WK_C_MV
Materialized ViewDDR_BS_EXCPTN_SKU_BU_WK_MV
SchemaDDR
ViewDDR_B_EXCPTN_ITEM_DAY#