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

TABLE: APPS.DDR_R_MFG_ITEM_SKU_DN_MV

Object Details
Object Name: DDR_R_MFG_ITEM_SKU_DN_MV
Object Type: TABLE
Owner: APPS
FND Design Data: TableDDR.DDR_R_MFG_ITEM_SKU_DN_MV
TableFND.DDR_R_MFG_ITEM_SKU_DN_MV
Subobject Name:
Status: VALID
Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
SKU_ROWID ROWID (10)
ITM_ROWID ROWID (10)
SBC_ROWID ROWID (10)
CLS_ROWID ROWID (10)
GRP_ROWID ROWID (10)
DIV_ROWID ROWID (10)
ORG_ROWID ROWID (10)
LKUP_ROWID ROWID (10)
MFG_ORG_CD VARCHAR2 (30) Yes
MFG_ORG_NAME VARCHAR2 (240)
ORG_CD VARCHAR2 (30) Yes
MFG_SKU_ITEM_ID NUMBER
Yes
MFG_SKU_ITEM_NAME VARCHAR2 (240)
MFG_SKU_ITEM_NBR VARCHAR2 (30) Yes
GLBL_ITEM_ID VARCHAR2 (30) Yes
GLBL_ITEM_ID_TYP VARCHAR2 (30) Yes
UNIT_PRICE_FCTR NUMBER

SZ_TYP_CD VARCHAR2 (30)
STCK_ITEM_WEAVE_CD VARCHAR2 (30)
STCK_ITEM_TYP_CD VARCHAR2 (30)
STCK_ITEM_STYLE_CD VARCHAR2 (30)
STCK_ITEM_FIBER_CD VARCHAR2 (30)
STCK_ITEM_FABRIC_CD VARCHAR2 (30)
STCK_ITEM_DYE_CD VARCHAR2 (30)
STCK_ITEM_COLOR_CD VARCHAR2 (30)
STCK_ITEM_COATING_CD VARCHAR2 (30)
SU_LAST_RCVD_NET_COST_AMT_RPT NUMBER

SU_LAST_RCVD_NET_COST_AMT_LCL NUMBER

SU_LAST_RCVD_NET_COST_AMT NUMBER

SU_LAST_RCVD_COST_ESTBL_DT DATE

SU_LAST_RCVD_BASE_COST_AMT_RPT NUMBER

SU_LAST_RCVD_BASE_COST_AMT_LCL NUMBER

SU_LAST_RCVD_BASE_COST_AMT NUMBER

SU_LNDED_COST_AMT NUMBER

SU_LNDED_COST_AMT_LCL NUMBER

SU_LNDED_COST_AMT_RPT NUMBER

PKG_SZ VARCHAR2 (30)
MFG_SKU_ITEM_TYP_CD VARCHAR2 (30)
MFG_SKU_ITEM_DESC VARCHAR2 (240)
MFG_SKU_ITEM_LNG_DESC VARCHAR2 (240)
COLLCTN_SKU_FLG VARCHAR2 (1)
AVLBL_FOR_SL_DT DATE

RECALL_IND VARCHAR2 (1)
UOM_CD VARCHAR2 (30)
ALT_UOM_CD VARCHAR2 (30)
MFG_ITEM_DESC VARCHAR2 (240)
MFG_ITEM_ID NUMBER
Yes
MFG_ITEM_NAME VARCHAR2 (240)
MFG_ITEM_NBR VARCHAR2 (30) Yes
MFG_BRND_CD VARCHAR2 (30)
MFG_ITEM_SHORT_DESC VARCHAR2 (240)
MFG_ITEM_SCND_DESC VARCHAR2 (240)
BRND_NAME VARCHAR2 (240)
BRND_DESC VARCHAR2 (240)
MFG_ITEM_SBC_ID NUMBER
Yes
MFG_SBC_CD VARCHAR2 (30) Yes
MFG_SBC_NAME VARCHAR2 (240)
MFG_ITEM_CLASS_ID NUMBER
Yes
MFG_CLASS_CD VARCHAR2 (30) Yes
MFG_CLASS_NAME VARCHAR2 (240)
MFG_ITEM_GRP_ID NUMBER
Yes
MFG_GRP_CD VARCHAR2 (30) Yes
MFG_GRP_NAME VARCHAR2 (240)
MFG_ITEM_DIV_ID NUMBER
Yes
MFG_DIV_CD VARCHAR2 (30) Yes
MFG_DIV_NAME VARCHAR2 (240)
MFG_ITEM_CMPNY_ID NUMBER

EFF_FROM_DT DATE

EFF_TO_DT DATE

ATTRIBUTE1 VARCHAR2 (240)
ATTRIBUTE2 VARCHAR2 (240)
ATTRIBUTE3 VARCHAR2 (240)
Query Text

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


SELECT SKU_ROWID
,      ITM_ROWID
,      SBC_ROWID
,      CLS_ROWID
,      GRP_ROWID
,      DIV_ROWID
,      ORG_ROWID
,      LKUP_ROWID
,      MFG_ORG_CD
,      MFG_ORG_NAME
,      ORG_CD
,      MFG_SKU_ITEM_ID
,      MFG_SKU_ITEM_NAME
,      MFG_SKU_ITEM_NBR
,      GLBL_ITEM_ID
,      GLBL_ITEM_ID_TYP
,      UNIT_PRICE_FCTR
,      SZ_TYP_CD
,      STCK_ITEM_WEAVE_CD
,      STCK_ITEM_TYP_CD
,      STCK_ITEM_STYLE_CD
,      STCK_ITEM_FIBER_CD
,      STCK_ITEM_FABRIC_CD
,      STCK_ITEM_DYE_CD
,      STCK_ITEM_COLOR_CD
,      STCK_ITEM_COATING_CD
,      SU_LAST_RCVD_NET_COST_AMT_RPT
,      SU_LAST_RCVD_NET_COST_AMT_LCL
,      SU_LAST_RCVD_NET_COST_AMT
,      SU_LAST_RCVD_COST_ESTBL_DT
,      SU_LAST_RCVD_BASE_COST_AMT_RPT
,      SU_LAST_RCVD_BASE_COST_AMT_LCL
,      SU_LAST_RCVD_BASE_COST_AMT
,      SU_LNDED_COST_AMT
,      SU_LNDED_COST_AMT_LCL
,      SU_LNDED_COST_AMT_RPT
,      PKG_SZ
,      MFG_SKU_ITEM_TYP_CD
,      MFG_SKU_ITEM_DESC
,      MFG_SKU_ITEM_LNG_DESC
,      COLLCTN_SKU_FLG
,      AVLBL_FOR_SL_DT
,      RECALL_IND
,      UOM_CD
,      ALT_UOM_CD
,      MFG_ITEM_DESC
,      MFG_ITEM_ID
,      MFG_ITEM_NAME
,      MFG_ITEM_NBR
,      MFG_BRND_CD
,      MFG_ITEM_SHORT_DESC
,      MFG_ITEM_SCND_DESC
,      BRND_NAME
,      BRND_DESC
,      MFG_ITEM_SBC_ID
,      MFG_SBC_CD
,      MFG_SBC_NAME
,      MFG_ITEM_CLASS_ID
,      MFG_CLASS_CD
,      MFG_CLASS_NAME
,      MFG_ITEM_GRP_ID
,      MFG_GRP_CD
,      MFG_GRP_NAME
,      MFG_ITEM_DIV_ID
,      MFG_DIV_CD
,      MFG_DIV_NAME
,      MFG_ITEM_CMPNY_ID
,      EFF_FROM_DT
,      EFF_TO_DT
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
FROM APPS.DDR_R_MFG_ITEM_SKU_DN_MV;

Dependencies

[top of page]

APPS.DDR_R_MFG_ITEM_SKU_DN_MV does not reference any database object

APPS.DDR_R_MFG_ITEM_SKU_DN_MV is referenced by following:

SchemaAPPS
Materialized ViewDDR_BS_BU_ITM_ASSC_WK_MV
ViewDDR_BS_BU_ITM_ASSC_WK_MV#
Materialized ViewDDR_BS_CLS_DAY_MV
ViewDDR_BS_CLS_DAY_MV#
Materialized ViewDDR_BS_EXCPTN_SKU_BU_WK_C_MV
ViewDDR_BS_EXCPTN_SKU_BU_WK_C_MV#
Materialized ViewDDR_BS_EXCPTN_SKU_BU_WK_MV
ViewDDR_BS_EXCPTN_SKU_BU_WK_MV#
Materialized ViewDDR_BS_FRCST_ITM_BU_WK_C_MV
ViewDDR_BS_FRCST_ITM_BU_WK_C_MV#
Materialized ViewDDR_BS_FRCST_ITM_BU_WK_MV
ViewDDR_BS_FRCST_ITM_BU_WK_MV#
Materialized ViewDDR_BS_INV_ITM_BU_WK_C_MV
ViewDDR_BS_INV_ITM_BU_WK_C_MV#
Materialized ViewDDR_BS_INV_ITM_BU_WK_MV
ViewDDR_BS_INV_ITM_BU_WK_MV#
Materialized ViewDDR_BS_ITM_BU_ASSC_DAY_MV
ViewDDR_BS_ITM_BU_ASSC_DAY_MV#
Materialized ViewDDR_BS_MFG_SHIP_ITM_BU_WK_MV
ViewDDR_BS_MFG_SHIP_ITM_BU_WK_MV#
Materialized ViewDDR_BS_MFG_SHP_ITM_BU_WK_C_MV
ViewDDR_BS_MFG_SHP_ITM_BU_WK_C_MV#
Materialized ViewDDR_BS_ORDR_ITM_BU_WK_C_MV
ViewDDR_BS_ORDR_ITM_BU_WK_C_MV#
Materialized ViewDDR_BS_ORDR_ITM_BU_WK_MV
ViewDDR_BS_ORDR_ITM_BU_WK_MV#
Materialized ViewDDR_BS_SHIP_ITM_BU_WK_C_MV
ViewDDR_BS_SHIP_ITM_BU_WK_C_MV#
Materialized ViewDDR_BS_SHIP_ITM_BU_WK_MV
ViewDDR_BS_SHIP_ITM_BU_WK_MV#
Materialized ViewDDR_BS_SLSR_ITM_BU_WK_C_MV
ViewDDR_BS_SLSR_ITM_BU_WK_C_MV#
Materialized ViewDDR_BS_SLSR_ITM_BU_WK_MV
ViewDDR_BS_SLSR_ITM_BU_WK_MV#
Materialized ViewDDR_R_MFG_ITEM_SKU_DN_MV
Materialized ViewDDR_SV_FRCST_C_MV
ViewDDR_SV_FRCST_C_MV#
Materialized ViewDDR_SV_INV_INT_C_MV
ViewDDR_SV_INV_INT_C_MV#
Materialized ViewDDR_SV_MFG_SHIP_C_MV
ViewDDR_SV_MFG_SHIP_C_MV#
Materialized ViewDDR_SV_ORDR_C_MV
ViewDDR_SV_ORDR_C_MV#
Materialized ViewDDR_SV_SHIP_C_MV
ViewDDR_SV_SHIP_C_MV#
Materialized ViewDDR_SV_SLSR_C_MV
ViewDDR_SV_SLSR_C_MV#