APPS.DDR_BASE_UTIL_PKG dependencies on DDR_I_RTL_INV_ITEM

Line 34: FROM DDR_I_RTL_INV_ITEM

30: ON_HAND_RTL_AMT, RECVD_RTL_AMT,
31: IN_TRANSIT_RTL_AMT, BCKORDR_RTL_AMT,
32: QLTY_HOLD_RTL_AMT, SRC_SYS_IDNT,
33: SRC_SYS_DT,'I','N',TRANS_DT
34: FROM DDR_I_RTL_INV_ITEM
35: WHERE
36: (RTL_BSNS_UNIT_CD,
37: TRANS_DT,
38: GLBL_ITEM_ID,

Line 50: FROM DDR_I_RTL_INV_ITEM

46: GLBL_ITEM_ID,
47: RTL_SKU_ITEM_NBR,
48: GLBL_ITEM_ID_TYP,
49: INV_LOC_CD
50: FROM DDR_I_RTL_INV_ITEM
51: GROUP BY
52: RTL_BSNS_UNIT_CD,
53: TRANS_DT,
54: GLBL_ITEM_ID,

Line 66: DELETE FROM DDR_I_RTL_INV_ITEM

62:
63: -- DELETE DUPLICATE RECORDS FROM INTERFACE TABLE --
64:
65:
66: DELETE FROM DDR_I_RTL_INV_ITEM
67: WHERE
68: (RTL_BSNS_UNIT_CD,
69: TRANS_DT,
70: GLBL_ITEM_ID,