APPS.DDR_EMD_UTIL dependencies on DDR_B_NEW_ITEM_NO_SLS

Line 191: EXECUTE IMMEDIATE 'TRUNCATE TABLE ddr.ddr_b_new_item_no_sls';

187:
188: -- Truncate the table
189: IF p_complete_refresh THEN --{
190: IF v_user = 'APPS' THEN --{
191: EXECUTE IMMEDIATE 'TRUNCATE TABLE ddr.ddr_b_new_item_no_sls';
192: ELSE
193: EXECUTE IMMEDIATE 'TRUNCATE TABLE ddr_b_new_item_no_sls';
194: END IF; --}
195: END IF; --}

Line 193: EXECUTE IMMEDIATE 'TRUNCATE TABLE ddr_b_new_item_no_sls';

189: IF p_complete_refresh THEN --{
190: IF v_user = 'APPS' THEN --{
191: EXECUTE IMMEDIATE 'TRUNCATE TABLE ddr.ddr_b_new_item_no_sls';
192: ELSE
193: EXECUTE IMMEDIATE 'TRUNCATE TABLE ddr_b_new_item_no_sls';
194: END IF; --}
195: END IF; --}
196: -- Fetch new items and check first sale
197:

Line 220: INSERT INTO ddr_b_new_item_no_sls(rtl_org_cd

216: v_first_sl_date_tbl(v_rec_count) := TO_DATE(rec2.first_sl_date,'YYYYMMDD');
217: END LOOP; --}
218: IF MOD(v_rec_count,ddr_emd_util.c_batch_size) = 0 THEN --{
219: FORALL i IN 1..v_rec_count
220: INSERT INTO ddr_b_new_item_no_sls(rtl_org_cd
221: ,rtl_bsns_unit_id
222: ,mfg_sku_item_id
223: ,rtl_sku_item_id
224: ,new_item_srt_dt

Line 251: INSERT INTO ddr_b_new_item_no_sls(rtl_org_cd

247: END LOOP; --}
248:
249: -- Insert the last batch rows
250: FORALL i IN 1..v_rec_count
251: INSERT INTO ddr_b_new_item_no_sls(rtl_org_cd
252: ,rtl_bsns_unit_id
253: ,mfg_sku_item_id
254: ,rtl_sku_item_id
255: ,new_item_srt_dt