APPS.INV_REDUCE_MOQD_PVT dependencies on MTL_ONHAND_QUANTITIES_DETAIL

Line 97: FROM MTL_ONHAND_QUANTITIES_DETAIL

93: l_lock_handle VARCHAR2(128);
94:
95: CURSOR C IS
96: SELECT *
97: FROM MTL_ONHAND_QUANTITIES_DETAIL
98: WHERE ORGANIZATION_ID = p_org_id
99: AND INVENTORY_ITEM_ID = p_item_id
100: FOR UPDATE NOWAIT;
101:

Line 194: FROM MTL_ONHAND_QUANTITIES_DETAIL

190: CURSOR lock_moqd IS */
191:
192: CURSOR moqd_org_item (p_org_id NUMBER) IS
193: SELECT ORGANIZATION_ID, INVENTORY_ITEM_ID
194: FROM MTL_ONHAND_QUANTITIES_DETAIL
195: WHERE ORGANIZATION_ID = P_ORG_ID
196: GROUP BY ORGANIZATION_ID, INVENTORY_ITEM_ID;
197: -- FOR UPDATE NOWAIT; /* commented for bug 7588761 */
198: BEGIN

Line 359: --copy records from mtl_onhand_quantities_detail into mtl_moq_backup table

355: debug('-----------------------------------------------');
356: debug('Running for Org - '||elig_orgs_rec.organization_code||', Id = '||elig_orgs_rec.organization_id);
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

Line 432: FROM MTL_ONHAND_QUANTITIES_DETAIL

428: ,IS_CONSIGNED
429: ,ROWID
430: ,'N'
431: ,STATUS_ID -- Bug 12776732
432: FROM MTL_ONHAND_QUANTITIES_DETAIL
433: WHERE ORGANIZATION_ID = l_moqd.ORGANIZATION_ID
434: AND INVENTORY_ITEM_ID = l_moqd.INVENTORY_ITEM_ID
435: AND PLANNING_ORGANIZATION_ID = ORGANIZATION_ID
436: AND OWNING_ORGANIZATION_ID = ORGANIZATION_ID

Line 451: FROM mtl_onhand_quantities_detail moqd

447: --check count(*) to make sure copy went okay
448: /* Added inventory_item_id condition for bug 7588761 */
449: SELECT count(*)
450: INTO l_moq_count
451: FROM mtl_onhand_quantities_detail moqd
452: WHERE ORGANIZATION_ID = l_moqd.ORGANIZATION_ID
453: AND INVENTORY_ITEM_ID = l_moqd.INVENTORY_ITEM_ID
454: AND PLANNING_ORGANIZATION_ID = ORGANIZATION_ID
455: AND OWNING_ORGANIZATION_ID = ORGANIZATION_ID

Line 503: --delete records from mtl_onhand_quantities_detail in that Org

499: END IF;
500: IF l_moq_count <> 0 THEN
501: l_stmt_count := 340;
502:
503: --delete records from mtl_onhand_quantities_detail in that Org
504: /* Added inventory_item_id condition for bug 7588761 */
505: delete from mtl_onhand_quantities_detail moqd
506: WHERE ORGANIZATION_ID = l_moqd.ORGANIZATION_ID
507: AND INVENTORY_ITEM_ID = l_moqd.INVENTORY_ITEM_ID

Line 505: delete from mtl_onhand_quantities_detail moqd

501: l_stmt_count := 340;
502:
503: --delete records from mtl_onhand_quantities_detail in that Org
504: /* Added inventory_item_id condition for bug 7588761 */
505: delete from mtl_onhand_quantities_detail moqd
506: WHERE ORGANIZATION_ID = l_moqd.ORGANIZATION_ID
507: AND INVENTORY_ITEM_ID = l_moqd.INVENTORY_ITEM_ID
508: AND PLANNING_ORGANIZATION_ID = ORGANIZATION_ID
509: AND OWNING_ORGANIZATION_ID = ORGANIZATION_ID

Line 525: --copy grouped records from mtl_moq_backup into mtl_onhand_quantities_detail

521: END IF;
522:
523: l_stmt_count := 350;
524:
525: --copy grouped records from mtl_moq_backup into mtl_onhand_quantities_detail
526: insert into mtl_onhand_quantities_detail(
527: INVENTORY_ITEM_ID
528: ,ORGANIZATION_ID
529: ,DATE_RECEIVED

Line 526: insert into mtl_onhand_quantities_detail(

522:
523: l_stmt_count := 350;
524:
525: --copy grouped records from mtl_moq_backup into mtl_onhand_quantities_detail
526: insert into mtl_onhand_quantities_detail(
527: INVENTORY_ITEM_ID
528: ,ORGANIZATION_ID
529: ,DATE_RECEIVED
530: ,LAST_UPDATE_DATE

Line 636: FROM mtl_onhand_quantities_detail

632: /* Added inventory_item_id condition for bug 7588761 */
633: /* Bug 7681955 Added secondary qty check */
634: SELECT nvl(sum(primary_transaction_quantity) ,0), nvl(sum(secondary_transaction_quantity) ,0)
635: INTO l_moq_sum, l_moq_sec_sum
636: FROM mtl_onhand_quantities_detail
637: WHERE ORGANIZATION_ID = l_moqd.ORGANIZATION_ID
638: AND INVENTORY_ITEM_ID = l_moqd.INVENTORY_ITEM_ID
639: AND PLANNING_ORGANIZATION_ID = ORGANIZATION_ID
640: AND OWNING_ORGANIZATION_ID = ORGANIZATION_ID

Line 768: FROM MTL_ONHAND_QUANTITIES_DETAIL

764: ,l_user_id
765: ,SYSDATE
766: ,ROWID
767: ,STATUS_ID -- Bug 12776732
768: FROM MTL_ONHAND_QUANTITIES_DETAIL
769: WHERE ORGANIZATION_ID = l_moqd.ORGANIZATION_ID
770: AND INVENTORY_ITEM_ID = l_moqd.INVENTORY_ITEM_ID
771: AND PLANNING_ORGANIZATION_ID = ORGANIZATION_ID
772: AND OWNING_ORGANIZATION_ID = ORGANIZATION_ID