APPS.INV_REDUCE_MOQD_PVT dependencies on MTL_MOQD_BACKUP

Line 344: DELETE FROM mtl_moqd_backup

340: debug('Lock granted on item_id '||l_moqd.INVENTORY_ITEM_ID );
341: end if;
342: l_stmt_count := 200;
343: --delete non-summarized rows from mtl_moq_backup table
344: DELETE FROM mtl_moqd_backup
345: WHERE summarized_flag = 'N';
346:
347: l_stmt_count := 300;
348:

Line 361: INSERT INTO MTL_MOQD_BACKUP(

357: END IF;
358: */
359: --copy records from mtl_onhand_quantities_detail into mtl_moq_backup table
360: /* Added inventory_item_id condition for bug 7588761 */
361: INSERT INTO MTL_MOQD_BACKUP(
362: INVENTORY_ITEM_ID
363: ,ORGANIZATION_ID
364: ,DATE_RECEIVED
365: ,LAST_UPDATE_DATE

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

438: AND OWNING_TP_TYPE = 2;
439: -- AND NVL(SECONDARY_TRANSACTION_QUANTITY,0) = 0; -- Bug 7681955
440:
441: IF(g_debug = 1) THEN
442: debug('Finished insert into MTL_MOQD_BACKUP');
443: END IF;
444:
445: l_stmt_count := 310;
446:

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

455: AND OWNING_ORGANIZATION_ID = ORGANIZATION_ID
456: AND PLANNING_TP_TYPE = 2
457: AND OWNING_TP_TYPE = 2
458: -- AND NVL(SECONDARY_TRANSACTION_QUANTITY,0) = 0 -- Bug 7681955
459: AND ROWID IN (SELECT ROW_ID FROM MTL_MOQD_BACKUP mmb
460: WHERE ORGANIZATION_ID = l_moqd.ORGANIZATION_ID
461: AND INVENTORY_ITEM_ID = l_moqd.INVENTORY_ITEM_ID
462: AND SUMMARIZED_FLAG = 'N');
463:

Line 468: FROM mtl_moqd_backup

464: l_stmt_count := 320;
465:
466: SELECT count(*)
467: INTO l_moq_backup_count
468: FROM mtl_moqd_backup
469: WHERE ORGANIZATION_ID = l_moqd.ORGANIZATION_ID
470: AND INVENTORY_ITEM_ID = l_moqd.INVENTORY_ITEM_ID /* Added for bug 7588761 */
471: AND PLANNING_ORGANIZATION_ID = ORGANIZATION_ID
472: AND OWNING_ORGANIZATION_ID = ORGANIZATION_ID

Line 513: AND ROWID IN (SELECT /*+ unnest */ ROW_ID FROM MTL_MOQD_BACKUP mmb

509: AND OWNING_ORGANIZATION_ID = ORGANIZATION_ID
510: AND PLANNING_TP_TYPE = 2
511: AND OWNING_TP_TYPE = 2
512: -- AND NVL(SECONDARY_TRANSACTION_QUANTITY,0) = 0 -- Bug 7681955
513: AND ROWID IN (SELECT /*+ unnest */ ROW_ID FROM MTL_MOQD_BACKUP mmb
514: WHERE ORGANIZATION_ID = l_moqd.ORGANIZATION_ID
515: AND INVENTORY_ITEM_ID = l_moqd.INVENTORY_ITEM_ID
516: AND SUMMARIZED_FLAG = 'N');
517: /* Added hint for bug 12996651 */

Line 593: FROM MTL_MOQD_BACKUP

589: ,SECONDARY_UOM_CODE
590: ,ROUND(SUM(SECONDARY_TRANSACTION_QUANTITY),5)
591: ,IS_CONSIGNED
592: ,STATUS_ID -- Bug 12776732
593: FROM MTL_MOQD_BACKUP
594: WHERE ORGANIZATION_ID = l_moqd.ORGANIZATION_ID
595: AND INVENTORY_ITEM_ID = l_moqd.INVENTORY_ITEM_ID
596: AND PLANNING_ORGANIZATION_ID = ORGANIZATION_ID
597: AND OWNING_ORGANIZATION_ID = ORGANIZATION_ID

Line 650: FROM mtl_moqd_backup

646:
647: /* Bug 7681955 Added secondary qty check */
648: SELECT nvl(sum(primary_transaction_quantity) ,0), nvl(sum(secondary_transaction_quantity) ,0)
649: INTO l_moq_backup_sum, l_moq_sec_backup_sum
650: FROM mtl_moqd_backup
651: WHERE ORGANIZATION_ID = l_moqd.ORGANIZATION_ID
652: AND INVENTORY_ITEM_ID = l_moqd.INVENTORY_ITEM_ID
653: AND PLANNING_ORGANIZATION_ID = ORGANIZATION_ID
654: AND OWNING_ORGANIZATION_ID = ORGANIZATION_ID

Line 691: INSERT INTO MTL_MOQD_BACKUP(

687: -- Insert Summary records into mtl_moq_backup table capturing the user_id,
688: -- request_id and request run date.
689:
690: /* Added inventory_item_id condition for bug 7588761 */
691: INSERT INTO MTL_MOQD_BACKUP(
692: INVENTORY_ITEM_ID
693: ,ORGANIZATION_ID
694: ,DATE_RECEIVED
695: ,LAST_UPDATE_DATE

Line 784: DELETE FROM MTL_MOQD_BACKUP

780:
781: l_stmt_count := 390;
782:
783: -- Delete all non-summary records from mtl_moq_backup table
784: DELETE FROM MTL_MOQD_BACKUP
785: WHERE SUMMARIZED_FLAG = 'N';
786:
787: IF(g_debug = 1) THEN
788: debug('Deleted '||SQL%ROWCOUNT||' Non-Summary rows from MOQD_BACKUP');