VIEW: APPS.DDR_IS_INV_ERR_V

Source

View Text - Preformatted

SELECT "REC_ID", "RTL_BSNS_UNIT_CD", "TRANS_DT", "GLBL_ITEM_ID", "RTL_SKU_ITEM_NBR", "GLBL_ITEM_ID_TYP", "INV_LOC_CD", "UOM", "ON_HAND_QTY", "RECVD_QTY", "IN_TRANSIT_QTY", "BCK_ORDR_QTY", "QLTY_HOLD_QTY", "ON_HAND_NET_COST_AMT", "RECVD_NET_COST_AMT", "IN_TRANSIT_NET_COST_AMT", "BCKORDR_NET_COST_AMT", "QLTY_HOLD_NET_COST_AMT", "ON_HAND_RTL_AMT", "RECVD_RTL_AMT", "IN_TRANSIT_RTL_AMT", "BCKORDR_RTL_AMT", "QLTY_HOLD_RTL_AMT", "SRC_SYS_IDNT", "SRC_SYS_DT", "RTL_ORG_CD" FROM DDR_I_RTL_INV_ITEM WHERE NOT EXISTS (SELECT "REC_ID", "TRANS_DT", "MFG_ORG_CD", "RTL_ORG_CD", "ORG_BSNS_UNIT_ID", "RTL_BSNS_UNIT_CD", "GLBL_ITEM_ID", "RTL_SKU_ITEM_ID", "RTL_SKU_ITEM_NBR", "DAY_CD", "GLBL_ITEM_ID_TYP", "INV_LOC_TYP_CD", "INV_LOC_ID", "INV_LOC_CD", "UOM_CD", "UOM_CD_PRMRY", "UOM_CD_ALT", "CRNCY_CD", "ON_HAND_QTY", "ON_HAND_QTY_PRMRY", "ON_HAND_QTY_ALT", "RECVD_QTY", "RECVD_QTY_PRMRY", "RECVD_QTY_ALT", "IN_TRANSIT_QTY", "IN_TRANSIT_QTY_PRMRY", "IN_TRANSIT_QTY_ALT", "BCK_ORDR_QTY", "BCK_ORDR_QTY_PRMRY", "BCK_ORDR_QTY_ALT", "QLTY_HOLD_QTY", "QLTY_HOLD_QTY_PRMRY", "QLTY_HOLD_QTY_ALT", "ON_HAND_NET_COST_AMT", "ON_HAND_NET_COST_AMT_LCL", "ON_HAND_NET_COST_AMT_RPT", "RECVD_NET_COST_AMT", "RECVD_NET_COST_AMT_LCL", "RECVD_NET_COST_AMT_RPT", "IN_TRANSIT_NET_COST_AMT", "IN_TRANSIT_NET_COST_AMT_LCL", "IN_TRANSIT_NET_COST_AMT_RPT", "BCKORDR_NET_COST_AMT", "BCKORDR_NET_COST_AMT_LCL", "BCKORDR_NET_COST_AMT_RPT", "QLTY_HOLD_NET_COST_AMT", "QLTY_HOLD_NET_COST_AMT_LCL", "QLTY_HOLD_NET_COST_AMT_RPT", "ON_HAND_RTL_AMT", "ON_HAND_RTL_AMT_LCL", "ON_HAND_RTL_AMT_RPT", "RECVD_RTL_AMT", "RECVD_RTL_AMT_LCL", "RECVD_RTL_AMT_RPT", "IN_TRANSIT_RTL_AMT", "IN_TRANSIT_RTL_AMT_LCL", "IN_TRANSIT_RTL_AMT_RPT", "BCKORDR_RTL_AMT", "BCKORDR_RTL_AMT_LCL", "BCKORDR_RTL_AMT_RPT", "QLTY_HOLD_RTL_AMT", "QLTY_HOLD_RTL_AMT_LCL", "QLTY_HOLD_RTL_AMT_RPT", "SRC_SYS_IDNT", "SRC_SYS_DT", "LOAD_ID", "ITM_TYP", "MFG_SKU_ITEM_ID" FROM DDR_S_RTL_INV_ITEM WHERE DDR_S_RTL_INV_ITEM.rec_id = DDR_I_RTL_INV_ITEM.rec_id)

View Text - HTML Formatted

SELECT "REC_ID"
, "RTL_BSNS_UNIT_CD"
, "TRANS_DT"
, "GLBL_ITEM_ID"
, "RTL_SKU_ITEM_NBR"
, "GLBL_ITEM_ID_TYP"
, "INV_LOC_CD"
, "UOM"
, "ON_HAND_QTY"
, "RECVD_QTY"
, "IN_TRANSIT_QTY"
, "BCK_ORDR_QTY"
, "QLTY_HOLD_QTY"
, "ON_HAND_NET_COST_AMT"
, "RECVD_NET_COST_AMT"
, "IN_TRANSIT_NET_COST_AMT"
, "BCKORDR_NET_COST_AMT"
, "QLTY_HOLD_NET_COST_AMT"
, "ON_HAND_RTL_AMT"
, "RECVD_RTL_AMT"
, "IN_TRANSIT_RTL_AMT"
, "BCKORDR_RTL_AMT"
, "QLTY_HOLD_RTL_AMT"
, "SRC_SYS_IDNT"
, "SRC_SYS_DT"
, "RTL_ORG_CD"
FROM DDR_I_RTL_INV_ITEM
WHERE NOT EXISTS (SELECT "REC_ID"
, "TRANS_DT"
, "MFG_ORG_CD"
, "RTL_ORG_CD"
, "ORG_BSNS_UNIT_ID"
, "RTL_BSNS_UNIT_CD"
, "GLBL_ITEM_ID"
, "RTL_SKU_ITEM_ID"
, "RTL_SKU_ITEM_NBR"
, "DAY_CD"
, "GLBL_ITEM_ID_TYP"
, "INV_LOC_TYP_CD"
, "INV_LOC_ID"
, "INV_LOC_CD"
, "UOM_CD"
, "UOM_CD_PRMRY"
, "UOM_CD_ALT"
, "CRNCY_CD"
, "ON_HAND_QTY"
, "ON_HAND_QTY_PRMRY"
, "ON_HAND_QTY_ALT"
, "RECVD_QTY"
, "RECVD_QTY_PRMRY"
, "RECVD_QTY_ALT"
, "IN_TRANSIT_QTY"
, "IN_TRANSIT_QTY_PRMRY"
, "IN_TRANSIT_QTY_ALT"
, "BCK_ORDR_QTY"
, "BCK_ORDR_QTY_PRMRY"
, "BCK_ORDR_QTY_ALT"
, "QLTY_HOLD_QTY"
, "QLTY_HOLD_QTY_PRMRY"
, "QLTY_HOLD_QTY_ALT"
, "ON_HAND_NET_COST_AMT"
, "ON_HAND_NET_COST_AMT_LCL"
, "ON_HAND_NET_COST_AMT_RPT"
, "RECVD_NET_COST_AMT"
, "RECVD_NET_COST_AMT_LCL"
, "RECVD_NET_COST_AMT_RPT"
, "IN_TRANSIT_NET_COST_AMT"
, "IN_TRANSIT_NET_COST_AMT_LCL"
, "IN_TRANSIT_NET_COST_AMT_RPT"
, "BCKORDR_NET_COST_AMT"
, "BCKORDR_NET_COST_AMT_LCL"
, "BCKORDR_NET_COST_AMT_RPT"
, "QLTY_HOLD_NET_COST_AMT"
, "QLTY_HOLD_NET_COST_AMT_LCL"
, "QLTY_HOLD_NET_COST_AMT_RPT"
, "ON_HAND_RTL_AMT"
, "ON_HAND_RTL_AMT_LCL"
, "ON_HAND_RTL_AMT_RPT"
, "RECVD_RTL_AMT"
, "RECVD_RTL_AMT_LCL"
, "RECVD_RTL_AMT_RPT"
, "IN_TRANSIT_RTL_AMT"
, "IN_TRANSIT_RTL_AMT_LCL"
, "IN_TRANSIT_RTL_AMT_RPT"
, "BCKORDR_RTL_AMT"
, "BCKORDR_RTL_AMT_LCL"
, "BCKORDR_RTL_AMT_RPT"
, "QLTY_HOLD_RTL_AMT"
, "QLTY_HOLD_RTL_AMT_LCL"
, "QLTY_HOLD_RTL_AMT_RPT"
, "SRC_SYS_IDNT"
, "SRC_SYS_DT"
, "LOAD_ID"
, "ITM_TYP"
, "MFG_SKU_ITEM_ID"
FROM DDR_S_RTL_INV_ITEM
WHERE DDR_S_RTL_INV_ITEM.REC_ID = DDR_I_RTL_INV_ITEM.REC_ID)