APPS.INV_REDUCE_MOQD_PVT dependencies on MTL_ONHAND_QUANTITIES_DETAIL

Line 54: FROM MTL_ONHAND_QUANTITIES_DETAIL

50: AND NOT (mp.wms_enabled_flag = 'Y' OR mp.process_enabled_flag = 'Y');
51:
52: CURSOR lock_moqd IS
53: SELECT ORGANIZATION_ID
54: FROM MTL_ONHAND_QUANTITIES_DETAIL
55: WHERE ORGANIZATION_ID = P_ORG_ID
56: FOR UPDATE NOWAIT;
57:
58: BEGIN

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

185: debug('-----------------------------------------------');
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

Line 259: FROM MTL_ONHAND_QUANTITIES_DETAIL

255: ,SECONDARY_TRANSACTION_QUANTITY
256: ,IS_CONSIGNED
257: ,ROWID
258: ,'N'
259: FROM MTL_ONHAND_QUANTITIES_DETAIL
260: WHERE ORGANIZATION_ID = elig_orgs_rec.ORGANIZATION_ID
261: AND PLANNING_ORGANIZATION_ID = ORGANIZATION_ID
262: AND OWNING_ORGANIZATION_ID = ORGANIZATION_ID
263: AND PLANNING_TP_TYPE = 2

Line 276: FROM mtl_onhand_quantities_detail moqd

272:
273: --check count(*) to make sure copy went okay
274: SELECT count(*)
275: INTO l_moq_count
276: FROM mtl_onhand_quantities_detail moqd
277: WHERE ORGANIZATION_ID = elig_orgs_rec.ORGANIZATION_ID
278: AND PLANNING_ORGANIZATION_ID = ORGANIZATION_ID
279: AND OWNING_ORGANIZATION_ID = ORGANIZATION_ID
280: AND PLANNING_TP_TYPE = 2

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

321: IF l_moq_count <> 0 THEN
322:
323: l_stmt_count := 340;
324:
325: --delete records from mtl_onhand_quantities_detail in that Org
326: delete from mtl_onhand_quantities_detail moqd
327: WHERE ORGANIZATION_ID = elig_orgs_rec.ORGANIZATION_ID
328: AND PLANNING_ORGANIZATION_ID = ORGANIZATION_ID
329: AND OWNING_ORGANIZATION_ID = ORGANIZATION_ID

Line 326: delete from mtl_onhand_quantities_detail moqd

322:
323: l_stmt_count := 340;
324:
325: --delete records from mtl_onhand_quantities_detail in that Org
326: delete from mtl_onhand_quantities_detail moqd
327: WHERE ORGANIZATION_ID = elig_orgs_rec.ORGANIZATION_ID
328: AND PLANNING_ORGANIZATION_ID = ORGANIZATION_ID
329: AND OWNING_ORGANIZATION_ID = ORGANIZATION_ID
330: AND PLANNING_TP_TYPE = 2

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

339: END IF;
340:
341: l_stmt_count := 350;
342:
343: --copy grouped records from mtl_moq_backup into mtl_onhand_quantities_detail
344: insert into mtl_onhand_quantities_detail(
345: INVENTORY_ITEM_ID
346: ,ORGANIZATION_ID
347: ,DATE_RECEIVED

Line 344: insert into mtl_onhand_quantities_detail(

340:
341: l_stmt_count := 350;
342:
343: --copy grouped records from mtl_moq_backup into mtl_onhand_quantities_detail
344: insert into mtl_onhand_quantities_detail(
345: INVENTORY_ITEM_ID
346: ,ORGANIZATION_ID
347: ,DATE_RECEIVED
348: ,LAST_UPDATE_DATE

Line 448: FROM mtl_onhand_quantities_detail

444: --check sum to see if any quantities have been lost
445:
446: SELECT nvl(sum(primary_transaction_quantity) ,0)
447: INTO l_moq_sum
448: FROM mtl_onhand_quantities_detail
449: WHERE ORGANIZATION_ID = elig_orgs_rec.ORGANIZATION_ID
450: AND PLANNING_ORGANIZATION_ID = ORGANIZATION_ID
451: AND OWNING_ORGANIZATION_ID = ORGANIZATION_ID
452: AND PLANNING_TP_TYPE = 2

Line 568: FROM MTL_ONHAND_QUANTITIES_DETAIL

564: ,l_request_id
565: ,l_user_id
566: ,SYSDATE
567: ,ROWID
568: FROM MTL_ONHAND_QUANTITIES_DETAIL
569: WHERE ORGANIZATION_ID = elig_orgs_rec.ORGANIZATION_ID
570: AND PLANNING_ORGANIZATION_ID = ORGANIZATION_ID
571: AND OWNING_ORGANIZATION_ID = ORGANIZATION_ID
572: AND PLANNING_TP_TYPE = 2