APPS.DDR_BASE_UTIL_PKG dependencies on DDR_I_RTL_INV_ITEM

Line 45: FROM DDR_I_RTL_INV_ITEM

41: ON_HAND_RTL_AMT, RECVD_RTL_AMT,
42: IN_TRANSIT_RTL_AMT, BCKORDR_RTL_AMT,
43: QLTY_HOLD_RTL_AMT, SRC_SYS_IDNT,
44: SRC_SYS_DT,'I','N',TRANS_DT, RTL_ORG_CD
45: FROM DDR_I_RTL_INV_ITEM
46: WHERE
47: (RTL_BSNS_UNIT_CD,
48: TRANS_DT,
49: GLBL_ITEM_ID,

Line 61: FROM DDR_I_RTL_INV_ITEM

57: GLBL_ITEM_ID,
58: RTL_SKU_ITEM_NBR,
59: GLBL_ITEM_ID_TYP,
60: INV_LOC_CD, RTL_ORG_CD
61: FROM DDR_I_RTL_INV_ITEM
62: GROUP BY
63: RTL_BSNS_UNIT_CD,
64: TRANS_DT,
65: GLBL_ITEM_ID,

Line 77: DELETE FROM DDR_I_RTL_INV_ITEM

73:
74: -- DELETE DUPLICATE RECORDS FROM INTERFACE TABLE --
75:
76:
77: DELETE FROM DDR_I_RTL_INV_ITEM
78: WHERE
79: (RTL_BSNS_UNIT_CD,
80: TRANS_DT,
81: GLBL_ITEM_ID,