[Home] [Help]
APPS.DDR_BASE_UTIL_PKG dependencies on DDR_E_RTL_ORDR_ITEM
Line 211: INSERT INTO DDR_E_RTL_ORDR_ITEM
207:
208: -- INSERT DUPLICATE RECORDS IN THE ERROR TABLE --
209:
210:
211: INSERT INTO DDR_E_RTL_ORDR_ITEM
212: (REC_ID, LOAD_ID, ERR_REASON,
213: RTL_BSNS_UNIT_CD,GLBL_ITEM_ID,
214: RTL_SKU_ITEM_NBR, GLBL_ITEM_ID_TYP, UOM,
215: ORDR_QTY,ORDR_AMT,SRC_SYS_IDNT,
Line 267: FROM DDR_E_RTL_ORDR_ITEM
263: GLBL_ITEM_ID,
264: RTL_SKU_ITEM_NBR,
265: GLBL_ITEM_ID_TYP,
266: TRANS_DT
267: FROM DDR_E_RTL_ORDR_ITEM
268: GROUP BY
269: RTL_BSNS_UNIT_CD,
270: GLBL_ITEM_ID,
271: RTL_SKU_ITEM_NBR,