APPS.DDR_BASE_UTIL_PKG dependencies on DDR_E_RTL_SHIP_ITEM

Line 344: INSERT INTO DDR_E_RTL_SHIP_ITEM

340: BEGIN
341: -- INSERT DUPLICATE RECORDS IN THE ERROR TABLE --
342:
343:
344: INSERT INTO DDR_E_RTL_SHIP_ITEM
345: (REC_ID, LOAD_ID, ERR_REASON,
346: RTL_BSNS_UNIT_CD,GLBL_ITEM_ID,
347: RTL_SKU_ITEM_NBR, GLBL_ITEM_ID_TYP,
348: UOM,SHIP_QTY, SHIP_AMT, SRC_SYS_IDNT,

Line 406: FROM DDR_E_RTL_SHIP_ITEM

402: RTL_SKU_ITEM_NBR,
403: GLBL_ITEM_ID_TYP,
404: TRANS_DT, RTL_ORG_CD,
405: SHIP_TO_ORG_CD, SHIP_TO_BSNS_UNIT_CD
406: FROM DDR_E_RTL_SHIP_ITEM
407: GROUP BY
408: GLBL_ITEM_ID,
409: RTL_BSNS_UNIT_CD,
410: RTL_SKU_ITEM_NBR,

Line 1001: INSERT INTO ddr_e_rtl_ship_item

997:
998: -- INSERT DUPLICATE RECORDS IN THE ERROR TABLE --
999:
1000: FOR rec IN c1 LOOP --{
1001: INSERT INTO ddr_e_rtl_ship_item
1002: (crncy_cd
1003: ,day_cd
1004: ,glbl_item_id
1005: ,glbl_item_id_typ