APPS.DDR_BASE_UTIL_PKG dependencies on DDR_E_RTL_INV_ITEM

Line 21: INSERT INTO DDR_E_RTL_INV_ITEM

17: BEGIN
18:
19: -- INSERT DUPLICATE RECORDS IN THE ERROR TABLE --
20:
21: INSERT INTO DDR_E_RTL_INV_ITEM
22: (REC_ID, LOAD_ID, ERR_REASON,
23: GLBL_ITEM_ID, GLBL_ITEM_ID_TYP,RTL_BSNS_UNIT_CD,
24: RTL_SKU_ITEM_NBR,INV_LOC_CD,UOM, ON_HAND_QTY,RECVD_QTY,
25: IN_TRANSIT_QTY,BCK_ORDR_QTY,QLTY_HOLD_QTY,

Line 93: FROM DDR_E_RTL_INV_ITEM

89: GLBL_ITEM_ID,
90: RTL_SKU_ITEM_NBR,
91: GLBL_ITEM_ID_TYP,
92: INV_LOC_CD, RTL_ORG_CD
93: FROM DDR_E_RTL_INV_ITEM
94: GROUP BY
95: RTL_BSNS_UNIT_CD,
96: TRANS_DT,
97: GLBL_ITEM_ID,

Line 823: INSERT INTO ddr_e_rtl_inv_item

819:
820: -- INSERT DUPLICATE RECORDS IN THE ERROR TABLE --
821:
822: FOR rec IN c1 LOOP --{
823: INSERT INTO ddr_e_rtl_inv_item
824: (bck_ordr_qty
825: ,bck_ordr_qty_alt
826: ,bck_ordr_qty_prmry
827: ,bckordr_net_cost_amt