VIEW: APPS.DDR_IS_SHIP_ERR_V

Source

View Text - Preformatted

SELECT REC_ID,GLBL_ITEM_ID,RTL_BSNS_UNIT_CD,RTL_SKU_ITEM_NBR,GLBL_ITEM_ID_TYP,UOM,SHIP_QTY,SHIP_AMT,SRC_SYS_IDNT,SRC_SYS_DT,TRANS_DT,RTL_ORG_CD,SHIP_TO_ORG_CD,SHIP_TO_BSNS_UNIT_CD,SHIP_COST FROM DDR_I_RTL_SHIP_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 , SHIP_QTY , SHIP_QTY_PRMRY , SHIP_QTY_ALT , SHIP_AMT , SHIP_AMT_LCL , SHIP_AMT_RPT , SRC_SYS_IDNT , SRC_SYS_DT , TRANS_DT , LOAD_ID , ITM_TYP , MFG_SKU_ITEM_ID , SHIP_TO_ORG_CD , SHIP_TO_BSNS_UNIT_ID, SHIP_TO_BSNS_UNIT_CD, SHIP_COST , SHIP_COST_RPT , SHIP_COST_LCL FROM DDR_S_RTL_SHIP_ITEM WHERE DDR_S_RTL_SHIP_ITEM.rec_id = DDR_I_RTL_SHIP_ITEM.rec_id )

View Text - HTML Formatted

SELECT REC_ID
, GLBL_ITEM_ID
, RTL_BSNS_UNIT_CD
, RTL_SKU_ITEM_NBR
, GLBL_ITEM_ID_TYP
, UOM
, SHIP_QTY
, SHIP_AMT
, SRC_SYS_IDNT
, SRC_SYS_DT
, TRANS_DT
, RTL_ORG_CD
, SHIP_TO_ORG_CD
, SHIP_TO_BSNS_UNIT_CD
, SHIP_COST
FROM DDR_I_RTL_SHIP_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
, SHIP_QTY
, SHIP_QTY_PRMRY
, SHIP_QTY_ALT
, SHIP_AMT
, SHIP_AMT_LCL
, SHIP_AMT_RPT
, SRC_SYS_IDNT
, SRC_SYS_DT
, TRANS_DT
, LOAD_ID
, ITM_TYP
, MFG_SKU_ITEM_ID
, SHIP_TO_ORG_CD
, SHIP_TO_BSNS_UNIT_ID
, SHIP_TO_BSNS_UNIT_CD
, SHIP_COST
, SHIP_COST_RPT
, SHIP_COST_LCL
FROM DDR_S_RTL_SHIP_ITEM
WHERE DDR_S_RTL_SHIP_ITEM.REC_ID = DDR_I_RTL_SHIP_ITEM.REC_ID )