DBA Data[Home] [Help]

APPS.DDR_BASE_UTIL_PKG dependencies on DDR_I_PRMTN_PLN

Line 129: FROM DDR_I_PRMTN_PLN

125: PRMTN_PRICE_AMT,
126: SRC_SYS_IDNT,
127: SRC_SYS_DT,
128: 'I','N',TRANS_DT
129: FROM DDR_I_PRMTN_PLN
130: WHERE
131: (GLBL_ITEM_ID,
132: RTL_BSNS_UNIT_CD,
133: PRMTN_TYP,

Line 149: FROM DDR_I_PRMTN_PLN

145: PRMTN_TO_DT,
146: RTL_SKU_ITEM_NBR,
147: GLBL_ITEM_ID_TYP,
148: TRANS_DT
149: FROM DDR_I_PRMTN_PLN
150: GROUP BY
151: GLBL_ITEM_ID,
152: RTL_BSNS_UNIT_CD,
153: PRMTN_TYP,

Line 166: DELETE FROM DDR_I_PRMTN_PLN

162:
163: -- DELETE DUPLICATE RECORDS FROM INTERFACE TABLE --
164:
165:
166: DELETE FROM DDR_I_PRMTN_PLN
167: WHERE
168: (GLBL_ITEM_ID,
169: RTL_BSNS_UNIT_CD,
170: PRMTN_TYP,