APPS.INV_MATERIAL_STATUS_GRP dependencies on DUAL

Line 190: INTO l_allow_status FROM DUAL

186:
187: IF l_return_status_id <> -1 THEN
188: BEGIN
189: SELECT 'Y'
190: INTO l_allow_status FROM DUAL
191: where l_return_status_id IN
192: (SELECT moqddst.status_id
193: FROM mtl_onhand_quantities_detail moqddst
194: WHERE moqddst.organization_id = p_organization_id

Line 291: FROM dual

287: inv_trx_util_pub.TRACE('mixed status: inv id is null and from LPN ID not null .. 30','Material Status', 9);
288:
289: SELECT 'N'
290: INTO l_allow_status
291: FROM dual
292: WHERE EXISTS (
293: (SELECT DISTINCT moqdsrc.status_id
294: FROM mtl_onhand_quantities_detail moqdsrc
295: WHERE moqdsrc.organization_id = p_organization_id

Line 365: FROM dual

361:
362: inv_trx_util_pub.TRACE('txn allowed or not: ..60.1 verifying at source','Material Status', 9);
363: SELECT 'N'
364: INTO l_allow_transaction
365: FROM dual
366: WHERE EXISTS
367: (SELECT 1
368: FROM mtl_onhand_quantities_detail moqd,
369: mtl_status_transaction_control mtc

Line 398: FROM dual

394: BEGIN
395: inv_trx_util_pub.TRACE('txn allowed or not: .. 80.1 verifying at dest','Material Status', 9);
396: SELECT 'N'
397: INTO l_allow_transaction
398: FROM dual
399: WHERE EXISTS
400: (SELECT 1
401: FROM mtl_onhand_quantities_detail moqd,
402: mtl_status_transaction_control mtc

Line 426: FROM dual

422: BEGIN
423: inv_trx_util_pub.TRACE('txn allowed or not: .. 100 verifying at dest, xfer lpn id is null','Material Status', 9);
424: SELECT 'N'
425: INTO l_allow_transaction
426: FROM dual
427: WHERE EXISTS
428: (SELECT 1
429: FROM mtl_onhand_quantities_detail moqd,
430: mtl_status_transaction_control mtc

Line 486: FROM dual

482: --check for all non-serial items
483:
484: SELECT 'N'
485: INTO l_allow_transaction
486: FROM dual
487: WHERE EXISTS
488: (SELECT 1
489: FROM mtl_onhand_quantities_detail moqd,
490: mtl_status_transaction_control mtc

Line 519: FROM dual

515: IF l_counter <> 0 AND l_allow_transaction = 'Y' THEN --if l_counter !=0 then serials exist in the LPN
516: inv_trx_util_pub.TRACE('txn allowed or not: .. 120.5 Serials Exist so need to check MSN Status','Material Status', 9);
517: SELECT 'N'
518: INTO l_allow_transaction
519: FROM dual
520: WHERE EXISTS
521: (SELECT 1
522: FROM wms_lpn_contents wlc ,
523: mtl_serial_numbers msn,

Line 550: FROM dual

546: inv_trx_util_pub.TRACE('txn allowed or not: .. 140 verifying at dest-- xfer lpn allows/not','Material Status', 9);
547: BEGIN
548: SELECT 'N'
549: INTO l_allow_transaction
550: FROM dual
551: WHERE EXISTS
552: (SELECT 1
553: FROM mtl_onhand_quantities_detail moqd,
554: mtl_status_transaction_control mtc

Line 3627: FROM DUAL WHERE EXISTS

3623:
3624: IF l_source_status_id <> -9999 and p_item_id is not null THEN
3625: BEGIN
3626: SELECT 'Y' INTO l_comingle
3627: FROM DUAL WHERE EXISTS
3628: (SELECT 1
3629: FROM mtl_onhand_quantities_detail
3630: WHERE organization_id = p_xfr_org_id
3631: AND inventory_item_id = p_item_id

Line 3669: FROM DUAL WHERE EXISTS

3665: inv_trx_util_pub.TRACE('l_wlc_rec.status_id: '||l_wlc_rec.status_id);
3666: END IF;
3667:
3668: SELECT 'Y' INTO l_comingle
3669: FROM DUAL WHERE EXISTS
3670: (SELECT 1
3671: FROM mtl_onhand_quantities_detail
3672: WHERE organization_id = p_xfr_org_id
3673: AND inventory_item_id =l_wlc_rec.inventory_item_id

Line 4087: FROM dual

4083:
4084: /* BEGIN
4085: SELECT 'N'
4086: INTO l_allow_transaction
4087: FROM dual
4088: WHERE EXISTS
4089: (SELECT 1
4090: FROM mtl_onhand_quantities_detail moqd,
4091: mtl_status_transaction_control mtc