Oracle Home Help
eTRM Technical Reference
 FND     DBA  

VIEW

Root
SchemaDDR
ViewDDR_B_CRNCY_EXCHNG_RATE#
ViewDDR_B_EXCPTN_ITEM_DAY#
ViewDDR_B_GOAL_TARGET#
ViewDDR_B_MFG_SHIP_ITEM_DAY#
ViewDDR_B_MKT_ITEM_SLS_DAY#
ViewDDR_B_NEW_ITEM_NO_SLS#
ViewDDR_B_PRMTN_PLN#
ViewDDR_B_RTL_INV_ITEM_DAY#
ViewDDR_B_RTL_ORDR_ITEM_DAY#
ViewDDR_B_RTL_SHIP_ITEM_DAY#
ViewDDR_B_RTL_SL_ADDTNL_MSRS#
ViewDDR_B_RTL_SL_RTN_ITM_DAY#
ViewDDR_B_SLS_FRCST_ITEM_DAY#
ViewDDR_B_SYND_CNSMPTN_DATA#
ViewDDR_DMNT_ITEM_MAP#
ViewDDR_DMNT_LOCATION_MAP#
ViewDDR_E_AOH_ACCT_ATTR#
ViewDDR_E_AOH_ATTR#
ViewDDR_E_BU_AOH_ASSOC#
ViewDDR_E_CAUSAL_CNDTN#
ViewDDR_E_CRNCY_EXCHNG_RATE#
ViewDDR_E_GEO_DEMOG#
ViewDDR_E_GEO_RGN_HCHY#
ViewDDR_E_GOAL_TARGET#
ViewDDR_E_ITEM_BSNS_UNT_ASSC#
ViewDDR_E_ITEM_CLSTR#
ViewDDR_E_LKUP#
ViewDDR_E_MFG_ITEM_HCHY#
ViewDDR_E_MFG_PRMTN#
ViewDDR_E_MFG_PRMTN_DTL#
ViewDDR_E_MFG_RTL_ORG_HCHY_ATTR#
ViewDDR_E_MFG_SHIP_ITEM#
ViewDDR_E_MFG_SKU_ITEM#
ViewDDR_E_MKT_AREA#
ViewDDR_E_MKT_AREA_BSNS_UNIT#
ViewDDR_E_ORG#
ViewDDR_E_ORG_BSNS_UNIT#
ViewDDR_E_ORG_BSNS_UNIT_HDAY#
ViewDDR_E_ORG_HCHY#
ViewDDR_E_PRMTN_PLN#
ViewDDR_E_RTL_CLSTR#
ViewDDR_E_RTL_INV_ITEM#
ViewDDR_E_RTL_ITEM_HCHY#
ViewDDR_E_RTL_ORDR_ITEM#
ViewDDR_E_RTL_SHIP_ITEM#
ViewDDR_E_RTL_SKU_BU_INV_RL#
ViewDDR_E_RTL_SKU_ITEM#
ViewDDR_E_RTL_SL_RTN_ITEM#
ViewDDR_E_SLS_FRCST_ITEM#
ViewDDR_E_STR_CLSTR#
ViewDDR_E_STR_CLSTR_BU_ASSC#
ViewDDR_E_SYND_CNSMPTN_DATA#
ViewDDR_E_SYND_GEO_KEY#
ViewDDR_E_SYND_PROD_KEY#
ViewDDR_E_TRD_AREA#
ViewDDR_E_TRD_AREA_COVRG#
ViewDDR_E_UOM#
ViewDDR_I_AOH_ACCT_ATTR#
ViewDDR_I_AOH_ATTR#
ViewDDR_I_BU_AOH_ASSOC#
ViewDDR_I_CAUSAL_CNDTN#
ViewDDR_I_CRNCY_EXCHNG_RATE#
ViewDDR_I_GEO_DEMOG#
ViewDDR_I_GEO_RGN_HCHY#
ViewDDR_I_GOAL_TARGET#
ViewDDR_I_ITEM_BSNS_UNT_ASSC#
ViewDDR_I_ITEM_CLSTR#
ViewDDR_I_LKUP#
ViewDDR_I_MFG_ITEM_HCHY#
ViewDDR_I_MFG_PRMTN#
ViewDDR_I_MFG_PRMTN_DTL#
ViewDDR_I_MFG_RTL_ORG_HCHY_ATTR#
ViewDDR_I_MFG_SHIP_ITEM#
ViewDDR_I_MFG_SKU_ITEM#
ViewDDR_I_MKT_AREA#
ViewDDR_I_MKT_AREA_BSNS_UNIT#
ViewDDR_I_ORG#
ViewDDR_I_ORG_BSNS_UNIT#
ViewDDR_I_ORG_BSNS_UNIT_HDAY#
ViewDDR_I_ORG_HCHY#
ViewDDR_I_PRMTN_PLN#
ViewDDR_I_RTL_CLSTR#
ViewDDR_I_RTL_INV_ITEM#
ViewDDR_I_RTL_ITEM_HCHY#
ViewDDR_I_RTL_ORDR_ITEM#
ViewDDR_I_RTL_SHIP_ITEM#
ViewDDR_I_RTL_SKU_BU_INV_RL#
ViewDDR_I_RTL_SKU_ITEM#
ViewDDR_I_RTL_SL_RTN_ITEM#
ViewDDR_I_SLS_FRCST_ITEM#
ViewDDR_I_STR_CLSTR#
ViewDDR_I_STR_CLSTR_BU_ASSC#
ViewDDR_I_SYND_CNSMPTN_DATA#
ViewDDR_I_SYND_GEO_KEY#
ViewDDR_I_SYND_PROD_KEY#
ViewDDR_I_TRD_AREA#
ViewDDR_I_TRD_AREA_COVRG#
ViewDDR_I_UOM#
ViewDDR_R_ADDR_LOC#
ViewDDR_R_ADVR_PRD#
ViewDDR_R_ADVR_QTR#
ViewDDR_R_ADVR_WK#
ViewDDR_R_ADVR_YR#
ViewDDR_R_AOH_LVL_DTL#
ViewDDR_R_BASE_DAY#
ViewDDR_R_BSNS_MNTH#
ViewDDR_R_BSNS_QTR#
ViewDDR_R_BSNS_WK#
ViewDDR_R_BSNS_YR#
ViewDDR_R_BU_AOH_ASSOC#
ViewDDR_R_CAUSAL_CNDTN#
ViewDDR_R_CITY#
ViewDDR_R_CLNDR#
ViewDDR_R_CLNDR_MNTH#
ViewDDR_R_CLNDR_QTR#
ViewDDR_R_CLNDR_WK#
ViewDDR_R_CLNDR_YR#
ViewDDR_R_CNTRY#
ViewDDR_R_CRNCY#
ViewDDR_R_DAY#
ViewDDR_R_DAY_TODATE_TRANS#
ViewDDR_R_DAY_TRANS#
ViewDDR_R_EXCPTN_SLS_THRSHLD#
ViewDDR_R_FSCL_MNTH#
ViewDDR_R_FSCL_QTR#
ViewDDR_R_FSCL_YR#
ViewDDR_R_GEO_DEMOG#
ViewDDR_R_GEO_ENT#
ViewDDR_R_GEO_ENT_EXTN#
ViewDDR_R_GEO_ENT_HCHY_ASSC#
ViewDDR_R_GEO_ENT_HCHY_STAR#
ViewDDR_R_GEO_HCHY#
ViewDDR_R_GEO_HCHY_LVL#
ViewDDR_R_GEO_HCHY_VRSN#
ViewDDR_R_GEO_LVL#
ViewDDR_R_GEO_LVL_ATTR#
ViewDDR_R_GEO_LVL_ATTR_VAL#
ViewDDR_R_GEO_RGN#
ViewDDR_R_GEO_SUB_RGN#
ViewDDR_R_INV_LOC#
ViewDDR_R_ITEM_BSNS_UNT_ASSC#
ViewDDR_R_ITEM_CLSTR#
ViewDDR_R_ITEM_CLSTR_ASSC#
ViewDDR_R_ITEM_HCHY#
ViewDDR_R_ITEM_HCHY_ASSC#
ViewDDR_R_ITEM_HCHY_LVL#
ViewDDR_R_ITEM_HCHY_VRSN#
ViewDDR_R_ITEM_LVL#
ViewDDR_R_ITEM_LVL_ATTR#
ViewDDR_R_ITEM_LVL_ATTR_VAL#
ViewDDR_R_ITEM_ORG_ASSC_RULE#
ViewDDR_R_LKUP_MST#
ViewDDR_R_LKUP_TYP#
ViewDDR_R_LYLTY_AWRD#
ViewDDR_R_MFG_ITEM#
ViewDDR_R_MFG_ITEM_CLASS#
ViewDDR_R_MFG_ITEM_CMPNY#
ViewDDR_R_MFG_ITEM_DIV#
ViewDDR_R_MFG_ITEM_GRP#
ViewDDR_R_MFG_ITEM_SBC#
ViewDDR_R_MFG_PRMTN#
ViewDDR_R_MFG_PRMTN_DTL#
ViewDDR_R_MFG_SKU_COLLCTN#
ViewDDR_R_MFG_SKU_ITEM#
ViewDDR_R_MFG_SKU_ITEM_VRTY#
ViewDDR_R_MFG_VRTY#
ViewDDR_R_MKT_AREA#
ViewDDR_R_MKT_ITEM#
ViewDDR_R_MKT_ITEM_DEPT#
ViewDDR_R_MKT_ITEM_DEPT_ASSC#
ViewDDR_R_MNTH_TODATE_TRANS#
ViewDDR_R_MNTH_TRANS#
ViewDDR_R_ORG#
ViewDDR_R_ORG_ALLOC#
ViewDDR_R_ORG_AREA#
ViewDDR_R_ORG_BSNS_ENT#
ViewDDR_R_ORG_BSNS_ENT_EXTN#
ViewDDR_R_ORG_BSNS_UNIT#
ViewDDR_R_ORG_BSNS_UNIT_HDAY#
ViewDDR_R_ORG_CHAIN#
ViewDDR_R_ORG_DEMOG_ATTR#
ViewDDR_R_ORG_DEMOG_GRP#
ViewDDR_R_ORG_DEMOG_VAL#
ViewDDR_R_ORG_DSTRCT#
ViewDDR_R_ORG_HCHY#
ViewDDR_R_ORG_HCHY_ASSC#
ViewDDR_R_ORG_HCHY_LVL#
ViewDDR_R_ORG_HCHY_STAR#
ViewDDR_R_ORG_HCHY_VRSN#
ViewDDR_R_ORG_LVL#
ViewDDR_R_ORG_LVL_ATTR#
ViewDDR_R_ORG_LVL_ATTR_VAL#
ViewDDR_R_ORG_RGN#
ViewDDR_R_PLNG_PRD#
ViewDDR_R_PLNG_QTR#
ViewDDR_R_PLNG_WK#
ViewDDR_R_PLNG_YR#
ViewDDR_R_PRD_TODATE_TRANS#
ViewDDR_R_PRD_TRANS#
ViewDDR_R_PROD_ENT#
ViewDDR_R_PROD_ENT_EXTN#
ViewDDR_R_PROD_ENT_HCHY_STAR#
ViewDDR_R_QTR_TODATE_TRANS#
ViewDDR_R_QTR_TRANS#
ViewDDR_R_RTL_CLSTR#
ViewDDR_R_RTL_CLSTR_RTL_ASSC#
ViewDDR_R_RTL_ITEM#
ViewDDR_R_RTL_ITEM_CLASS#
ViewDDR_R_RTL_ITEM_CMPNY#
ViewDDR_R_RTL_ITEM_DEPT#
ViewDDR_R_RTL_ITEM_DIV#
ViewDDR_R_RTL_ITEM_GRP#
ViewDDR_R_RTL_ITEM_SBC#
ViewDDR_R_RTL_SKU_BU_INV_RL#
ViewDDR_R_RTL_SKU_ITEM#
ViewDDR_R_RTL_SKU_ITEM_VRTY#
ViewDDR_R_RTL_SKU_SLNG_PRC#
ViewDDR_R_RTL_SKU_SLNG_PRC_H#
ViewDDR_R_RTL_VRTY#
ViewDDR_R_STATE#
ViewDDR_R_STR_CLSTR#
ViewDDR_R_STR_CLSTR_BU_ASSC#
ViewDDR_R_SYND_GEO_KEY#
ViewDDR_R_SYND_PROD_KEY#
ViewDDR_R_TIME_ALLOC#
ViewDDR_R_TIME_ZN#
ViewDDR_R_TRD_AREA#
ViewDDR_R_TRD_AREA_COVRG#
ViewDDR_R_UOM#
ViewDDR_R_UOM_CNVRSN#
ViewDDR_R_WKDAY#
ViewDDR_R_WK_TODATE_TRANS#
ViewDDR_R_WK_TRANS#
ViewDDR_R_YR_TRANS#
ViewDDR_S_AOH_ACCT_ATTR#
ViewDDR_S_MFG_SHIP_ITEM#
ViewDDR_S_PRMTN_PLN#
ViewDDR_S_RTL_INV_ITEM#
ViewDDR_S_RTL_ORDR_ITEM#
ViewDDR_S_RTL_SHIP_ITEM#
ViewDDR_S_RTL_SL_RTN_ITEM#
ViewDDR_S_SLS_FRCST_ITEM#
ViewDDR_S_SYND_CNSMPTN_DATA#
ViewDDR_TRANSLATED_MESSAGE#
ViewDDR_U_MV_RFRSH_LOG#
ViewDDR_WS_JOB#
ViewDDR_WS_JOB_FILE_DLS#
ViewDDR_WS_METADATA#
248 objects

12.2.2 DBA Data