VIEW: APPS.DDR_IS_ORDR_ERR_V

Source

View Text - Preformatted

SELECT "REC_ID" , "RTL_BSNS_UNIT_CD" , "GLBL_ITEM_ID" , "RTL_SKU_ITEM_NBR" , "GLBL_ITEM_ID_TYP" , "UOM" , "ORDR_QTY" , "ORDR_AMT" , "SRC_SYS_IDNT" , "SRC_SYS_DT" , "TRANS_DT", "RTL_ORG_CD" FROM DDR_I_RTL_ORDR_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", "ORDR_QTY", "ORDR_QTY_PRMRY", "ORDR_QTY_ALT", "ORDR_AMT", "ORDR_AMT_LCL", "ORDR_AMT_RPT", "SRC_SYS_IDNT", "SRC_SYS_DT", "TRANS_DT", "LOAD_ID", "ITM_TYP", "MFG_SKU_ITEM_ID" FROM DDR_S_RTL_ORDR_ITEM WHERE DDR_S_RTL_ORDR_ITEM.rec_id = DDR_I_RTL_ORDR_ITEM.rec_id)

View Text - HTML Formatted

SELECT "REC_ID"
, "RTL_BSNS_UNIT_CD"
, "GLBL_ITEM_ID"
, "RTL_SKU_ITEM_NBR"
, "GLBL_ITEM_ID_TYP"
, "UOM"
, "ORDR_QTY"
, "ORDR_AMT"
, "SRC_SYS_IDNT"
, "SRC_SYS_DT"
, "TRANS_DT"
, "RTL_ORG_CD"
FROM DDR_I_RTL_ORDR_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"
, "ORDR_QTY"
, "ORDR_QTY_PRMRY"
, "ORDR_QTY_ALT"
, "ORDR_AMT"
, "ORDR_AMT_LCL"
, "ORDR_AMT_RPT"
, "SRC_SYS_IDNT"
, "SRC_SYS_DT"
, "TRANS_DT"
, "LOAD_ID"
, "ITM_TYP"
, "MFG_SKU_ITEM_ID"
FROM DDR_S_RTL_ORDR_ITEM
WHERE DDR_S_RTL_ORDR_ITEM.REC_ID = DDR_I_RTL_ORDR_ITEM.REC_ID)