DBA Data[Home] [Help]

APPS.DDR_BASE_UTIL_PKG dependencies on DDR_E_RTL_ORDR_ITEM

Line 266: INSERT INTO DDR_E_RTL_ORDR_ITEM

262: BEGIN
263: -- INSERT DUPLICATE RECORDS IN THE ERROR TABLE --
264:
265:
266: INSERT INTO DDR_E_RTL_ORDR_ITEM
267: (REC_ID, LOAD_ID, ERR_REASON,
268: RTL_BSNS_UNIT_CD,GLBL_ITEM_ID,
269: RTL_SKU_ITEM_NBR, GLBL_ITEM_ID_TYP, UOM,
270: ORDR_QTY,ORDR_AMT,SRC_SYS_IDNT,

Line 322: FROM DDR_E_RTL_ORDR_ITEM

318: GLBL_ITEM_ID,
319: RTL_SKU_ITEM_NBR,
320: GLBL_ITEM_ID_TYP,
321: TRANS_DT, RTL_ORG_CD
322: FROM DDR_E_RTL_ORDR_ITEM
323: GROUP BY
324: RTL_BSNS_UNIT_CD,
325: GLBL_ITEM_ID,
326: RTL_SKU_ITEM_NBR,

Line 1106: INSERT INTO ddr_e_rtl_ordr_item

1102:
1103: -- INSERT DUPLICATE RECORDS IN THE ERROR TABLE --
1104:
1105: FOR rec IN c1 LOOP --{
1106: INSERT INTO ddr_e_rtl_ordr_item
1107: (crncy_cd
1108: ,day_cd
1109: ,glbl_item_id
1110: ,glbl_item_id_typ