[Home] [Help] [Dependency Information]
Object Name: | DDR_B_NEW_ITEM_NO_SLS |
---|---|
Object Type: | TABLE |
Owner: | DDR |
Subobject Name: | |
Status: | VALID |
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RTL_ORG_CD | VARCHAR2 | (30) | Yes | Retailer Organization Code |
RTL_BSNS_UNIT_ID | NUMBER | Yes | Retail Business Unit ID | |
MFG_SKU_ITEM_ID | NUMBER | Yes | Manufacturer SKU Item ID | |
RTL_SKU_ITEM_ID | NUMBER | Yes | Manufacturer SKU Item ID | |
NEW_ITEM_SRT_DT | DATE | Yes | New Item Start Date | |
NEW_ITEM_END_DT | DATE | Yes | New Item End Date | |
FRST_SL_DT | DATE | First Sale Date |
Cut, paste (and edit) the following text to query this object:
SELECT RTL_ORG_CD
, RTL_BSNS_UNIT_ID
, MFG_SKU_ITEM_ID
, RTL_SKU_ITEM_ID
, NEW_ITEM_SRT_DT
, NEW_ITEM_END_DT
, FRST_SL_DT
FROM DDR.DDR_B_NEW_ITEM_NO_SLS;
DDR.DDR_B_NEW_ITEM_NO_SLS does not reference any database object
DDR.DDR_B_NEW_ITEM_NO_SLS is referenced by following:
|
|
|