VIEW: APPS.DDR_IS_SLS_FRCST_ERR_V

Source

View Text - Preformatted

SELECT "REC_ID" , "TRANS_DT" , "FRCST_NBR" , "FRCST_TYP" , "LOC_IDNT_CD" , "GLBL_ITEM_ID" , "RTL_SKU_ITEM_NBR" , "GLBL_ITEM_ID_TYP" , "FRCST_SLS_UOM" , "FRCST_SLS_QTY" , "FRCST_SLS_AMT" , "PERIOD_TYP_FLAG" , "LOC_IDNT_FLAG" , "ORG_LVL_CD" , "SRC_SYS_IDNT" , "SRC_SYS_DT" , "RTL_ORG_CD", "FRCST_PURP" FROM DDR_I_SLS_FRCST_ITEM WHERE NOT EXISTS (SELECT "REC_ID" , "TRANS_DT" , "MFG_ORG_CD" , "RTL_ORG_CD" , "FRCST_NBR" , "FRCST_TYP" , "FRCST_VRSN" , "ORG_BSNS_UNIT_ID" , "BSNS_UNIT_CD" , "DAY_CD" , "GLBL_ITEM_ID" , "RTL_SKU_ITEM_ID" , "RTL_SKU_ITEM_NBR" , "GLBL_ITEM_ID_TYP" , "FRCST_SLS_UOM_CD" , "FRCST_SLS_UOM_CD_PRMRY" , "FRCST_SLS_UOM_CD_ALT" , "CRNCY_CD" , "FRCST_SLS_QTY" , "FRCST_SLS_QTY_PRMRY" , "FRCST_SLS_QTY_ALT" , "FRCST_SLS_AMT" , "FRCST_SLS_AMT_LCL" , "FRCST_SLS_AMT_RPT" , "SRC_SYS_IDNT" , "SRC_SYS_DT" , "LOAD_ID" , "ITM_TYP" , "MFG_SKU_ITEM_ID", "FRCST_PURP" FROM DDR_S_SLS_FRCST_ITEM WHERE DDR_S_SLS_FRCST_ITEM.rec_id = DDR_I_SLS_FRCST_ITEM.rec_id )

View Text - HTML Formatted

SELECT "REC_ID"
, "TRANS_DT"
, "FRCST_NBR"
, "FRCST_TYP"
, "LOC_IDNT_CD"
, "GLBL_ITEM_ID"
, "RTL_SKU_ITEM_NBR"
, "GLBL_ITEM_ID_TYP"
, "FRCST_SLS_UOM"
, "FRCST_SLS_QTY"
, "FRCST_SLS_AMT"
, "PERIOD_TYP_FLAG"
, "LOC_IDNT_FLAG"
, "ORG_LVL_CD"
, "SRC_SYS_IDNT"
, "SRC_SYS_DT"
, "RTL_ORG_CD"
, "FRCST_PURP"
FROM DDR_I_SLS_FRCST_ITEM
WHERE NOT EXISTS (SELECT "REC_ID"
, "TRANS_DT"
, "MFG_ORG_CD"
, "RTL_ORG_CD"
, "FRCST_NBR"
, "FRCST_TYP"
, "FRCST_VRSN"
, "ORG_BSNS_UNIT_ID"
, "BSNS_UNIT_CD"
, "DAY_CD"
, "GLBL_ITEM_ID"
, "RTL_SKU_ITEM_ID"
, "RTL_SKU_ITEM_NBR"
, "GLBL_ITEM_ID_TYP"
, "FRCST_SLS_UOM_CD"
, "FRCST_SLS_UOM_CD_PRMRY"
, "FRCST_SLS_UOM_CD_ALT"
, "CRNCY_CD"
, "FRCST_SLS_QTY"
, "FRCST_SLS_QTY_PRMRY"
, "FRCST_SLS_QTY_ALT"
, "FRCST_SLS_AMT"
, "FRCST_SLS_AMT_LCL"
, "FRCST_SLS_AMT_RPT"
, "SRC_SYS_IDNT"
, "SRC_SYS_DT"
, "LOAD_ID"
, "ITM_TYP"
, "MFG_SKU_ITEM_ID"
, "FRCST_PURP"
FROM DDR_S_SLS_FRCST_ITEM
WHERE DDR_S_SLS_FRCST_ITEM.REC_ID = DDR_I_SLS_FRCST_ITEM.REC_ID )