VIEW: APPS.DDR_IS_SL_RTN_ERR_V

Source

View Text - Preformatted

SELECT REC_ID, LOC_IDNT_CD, GLBL_ITEM_ID, RTL_SKU_ITEM_NBR, GLBL_ITEM_ID_TYP, UOM, SLS_QTY, SLS_AMT, RTRN_QTY, RTRN_AMT, SLS_COST_AMT, RTRN_COST_AMT, TRANS_DT, SRC_SYS_IDNT, SRC_SYS_DT, PERIOD_TYP_FLAG, LOC_IDNT_FLAG, ORG_LVL_CD, PRMTN_FLAG, RTL_ORG_CD FROM DDR_I_RTL_SL_RTN_ITEM WHERE NOT EXISTS ( SELECT "REC_ID" , "MFG_ORG_CD" , "RTL_ORG_CD" , "ORG_BSNS_UNIT_ID" , "RTL_BSNS_UNIT_CD" , "DAY_CD" , "GLBL_ITEM_ID" , "RTL_SKU_ITEM_ID" , "RTL_SKU_ITEM_NBR" , "GLBL_ITEM_ID_TYP" , "UOM_CD" , "UOM_CD_PRMRY" , "UOM_CD_ALT" , "CRNCY_CD" , "SLS_QTY" , "SLS_QTY_PRMRY" , "SLS_QTY_ALT" , "SLS_AMT" , "SLS_AMT_LCL" , "SLS_AMT_RPT" , "SLS_COST_AMT" , "SLS_COST_AMT_LCL" , "SLS_COST_AMT_RPT" , "RTRN_QTY" , "RTRN_QTY_PRMRY" , "RTRN_QTY_ALT" , "RTRN_AMT" , "RTRN_AMT_LCL" , "RTRN_AMT_RPT" , "RTRN_COST_AMT" , "RTRN_COST_AMT_LCL" , "RTRN_COST_AMT_RPT" , "SRC_SYS_IDNT" , "SRC_SYS_DT" , "TRANS_DT" , "ITEM_BSNS_UNT_ASSC_ID" , "MFG_SKU_ITEM_ID" , "MFG_SKU_ITEM_NBR" , "EFF_FROM_DT" , "EFF_TO_DT" , "LOAD_ID" , "PRMTN_FLAG" , "ITM_TYP" FROM DDR_S_RTL_SL_RTN_ITEM WHERE DDR_S_RTL_SL_RTN_ITEM.rec_id = DDR_I_RTL_SL_RTN_ITEM.REC_ID )

View Text - HTML Formatted

SELECT REC_ID
, LOC_IDNT_CD
, GLBL_ITEM_ID
, RTL_SKU_ITEM_NBR
, GLBL_ITEM_ID_TYP
, UOM
, SLS_QTY
, SLS_AMT
, RTRN_QTY
, RTRN_AMT
, SLS_COST_AMT
, RTRN_COST_AMT
, TRANS_DT
, SRC_SYS_IDNT
, SRC_SYS_DT
, PERIOD_TYP_FLAG
, LOC_IDNT_FLAG
, ORG_LVL_CD
, PRMTN_FLAG
, RTL_ORG_CD
FROM DDR_I_RTL_SL_RTN_ITEM
WHERE NOT EXISTS ( SELECT "REC_ID"
, "MFG_ORG_CD"
, "RTL_ORG_CD"
, "ORG_BSNS_UNIT_ID"
, "RTL_BSNS_UNIT_CD"
, "DAY_CD"
, "GLBL_ITEM_ID"
, "RTL_SKU_ITEM_ID"
, "RTL_SKU_ITEM_NBR"
, "GLBL_ITEM_ID_TYP"
, "UOM_CD"
, "UOM_CD_PRMRY"
, "UOM_CD_ALT"
, "CRNCY_CD"
, "SLS_QTY"
, "SLS_QTY_PRMRY"
, "SLS_QTY_ALT"
, "SLS_AMT"
, "SLS_AMT_LCL"
, "SLS_AMT_RPT"
, "SLS_COST_AMT"
, "SLS_COST_AMT_LCL"
, "SLS_COST_AMT_RPT"
, "RTRN_QTY"
, "RTRN_QTY_PRMRY"
, "RTRN_QTY_ALT"
, "RTRN_AMT"
, "RTRN_AMT_LCL"
, "RTRN_AMT_RPT"
, "RTRN_COST_AMT"
, "RTRN_COST_AMT_LCL"
, "RTRN_COST_AMT_RPT"
, "SRC_SYS_IDNT"
, "SRC_SYS_DT"
, "TRANS_DT"
, "ITEM_BSNS_UNT_ASSC_ID"
, "MFG_SKU_ITEM_ID"
, "MFG_SKU_ITEM_NBR"
, "EFF_FROM_DT"
, "EFF_TO_DT"
, "LOAD_ID"
, "PRMTN_FLAG"
, "ITM_TYP"
FROM DDR_S_RTL_SL_RTN_ITEM
WHERE DDR_S_RTL_SL_RTN_ITEM.REC_ID = DDR_I_RTL_SL_RTN_ITEM.REC_ID )