APPS.INV_REDUCE_MOQD_PVT dependencies on MTL_MOQD_BACKUP

Line 176: DELETE FROM mtl_moqd_backup

172: END;
173:
174: l_stmt_count := 200;
175: --delete non-summarized rows from mtl_moq_backup table
176: DELETE FROM mtl_moqd_backup
177: WHERE summarized_flag = 'N';
178:
179: l_stmt_count := 300;
180:

Line 190: INSERT INTO MTL_MOQD_BACKUP(

186: debug('Running for Org - '||elig_orgs_rec.organization_code||', Id = '||elig_orgs_rec.organization_id);
187: END IF;
188:
189: --copy records from mtl_onhand_quantities_detail into mtl_moq_backup table
190: INSERT INTO MTL_MOQD_BACKUP(
191: INVENTORY_ITEM_ID
192: ,ORGANIZATION_ID
193: ,DATE_RECEIVED
194: ,LAST_UPDATE_DATE

Line 268: debug('Finished insert into MTL_MOQD_BACKUP');

264: AND OWNING_TP_TYPE = 2
265: AND NVL(SECONDARY_TRANSACTION_QUANTITY,0) = 0;
266:
267: IF(l_debug = 1) THEN
268: debug('Finished insert into MTL_MOQD_BACKUP');
269: END IF;
270:
271: l_stmt_count := 310;
272:

Line 283: AND ROWID IN (SELECT ROW_ID FROM MTL_MOQD_BACKUP mmb

279: AND OWNING_ORGANIZATION_ID = ORGANIZATION_ID
280: AND PLANNING_TP_TYPE = 2
281: AND OWNING_TP_TYPE = 2
282: AND NVL(SECONDARY_TRANSACTION_QUANTITY,0) = 0
283: AND ROWID IN (SELECT ROW_ID FROM MTL_MOQD_BACKUP mmb
284: WHERE ORGANIZATION_ID = elig_orgs_rec.ORGANIZATION_ID
285: AND SUMMARIZED_FLAG = 'N');
286:
287: l_stmt_count := 320;

Line 291: FROM mtl_moqd_backup

287: l_stmt_count := 320;
288:
289: SELECT count(*)
290: INTO l_moq_backup_count
291: FROM mtl_moqd_backup
292: WHERE ORGANIZATION_ID = elig_orgs_rec.ORGANIZATION_ID
293: AND PLANNING_ORGANIZATION_ID = ORGANIZATION_ID
294: AND OWNING_ORGANIZATION_ID = ORGANIZATION_ID
295: AND PLANNING_TP_TYPE = 2

Line 333: AND ROWID IN (SELECT ROW_ID FROM MTL_MOQD_BACKUP mmb

329: AND OWNING_ORGANIZATION_ID = ORGANIZATION_ID
330: AND PLANNING_TP_TYPE = 2
331: AND OWNING_TP_TYPE = 2
332: AND NVL(SECONDARY_TRANSACTION_QUANTITY,0) = 0
333: AND ROWID IN (SELECT ROW_ID FROM MTL_MOQD_BACKUP mmb
334: WHERE ORGANIZATION_ID = elig_orgs_rec.ORGANIZATION_ID
335: AND SUMMARIZED_FLAG = 'N');
336:
337: IF(l_debug = 1) THEN

Line 409: FROM MTL_MOQD_BACKUP

405: ,ROUND(SUM(PRIMARY_TRANSACTION_QUANTITY),5)
406: ,SECONDARY_UOM_CODE
407: ,ROUND(SUM(SECONDARY_TRANSACTION_QUANTITY),5)
408: ,IS_CONSIGNED
409: FROM MTL_MOQD_BACKUP
410: WHERE ORGANIZATION_ID = elig_orgs_rec.ORGANIZATION_ID
411: AND PLANNING_ORGANIZATION_ID = ORGANIZATION_ID
412: AND OWNING_ORGANIZATION_ID = ORGANIZATION_ID
413: AND PLANNING_TP_TYPE = 2

Line 460: FROM mtl_moqd_backup

456: l_stmt_count := 370;
457:
458: SELECT nvl(sum(primary_transaction_quantity) ,0)
459: INTO l_moq_backup_sum
460: FROM mtl_moqd_backup
461: WHERE ORGANIZATION_ID = elig_orgs_rec.ORGANIZATION_ID
462: AND PLANNING_ORGANIZATION_ID = ORGANIZATION_ID
463: AND OWNING_ORGANIZATION_ID = ORGANIZATION_ID
464: AND PLANNING_TP_TYPE = 2

Line 493: INSERT INTO MTL_MOQD_BACKUP(

489:
490: l_stmt_count := 385;
491:
492: -- Insert Summary records into mtl_moq_backup table capturing the user_id, request_id and request run date.
493: INSERT INTO MTL_MOQD_BACKUP(
494: INVENTORY_ITEM_ID
495: ,ORGANIZATION_ID
496: ,DATE_RECEIVED
497: ,LAST_UPDATE_DATE

Line 583: DELETE FROM MTL_MOQD_BACKUP

579:
580: l_stmt_count := 390;
581:
582: -- Delete all non-summary records from mtl_moq_backup table
583: DELETE FROM MTL_MOQD_BACKUP
584: WHERE SUMMARIZED_FLAG = 'N';
585:
586: IF(l_debug = 1) THEN
587: debug('Deleted '||SQL%ROWCOUNT||' Non-Summary rows from MOQD_BACKUP');