[Home] [Help]
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
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
347:
348: inv_trx_util_pub.TRACE('txn allowed or not: ..60.1 verifying at source','Material Status', 9);
349: SELECT 'N'
350: INTO l_allow_transaction
351: FROM dual
352: WHERE EXISTS
353: (SELECT 1
354: FROM mtl_onhand_quantities_detail moqd,
355: mtl_status_transaction_control mtc
380: BEGIN
381: inv_trx_util_pub.TRACE('txn allowed or not: .. 80.1 verifying at dest','Material Status', 9);
382: SELECT 'N'
383: INTO l_allow_transaction
384: FROM dual
385: WHERE EXISTS
386: (SELECT 1
387: FROM mtl_onhand_quantities_detail moqd,
388: mtl_status_transaction_control mtc
408: BEGIN
409: inv_trx_util_pub.TRACE('txn allowed or not: .. 100 verifying at dest, xfer lpn id is null','Material Status', 9);
410: SELECT 'N'
411: INTO l_allow_transaction
412: FROM dual
413: WHERE EXISTS
414: (SELECT 1
415: FROM mtl_onhand_quantities_detail moqd,
416: mtl_status_transaction_control mtc
468: --check for all non-serial items
469:
470: SELECT 'N'
471: INTO l_allow_transaction
472: FROM dual
473: WHERE EXISTS
474: (SELECT 1
475: FROM mtl_onhand_quantities_detail moqd,
476: mtl_status_transaction_control mtc
501: IF l_counter <> 0 AND l_allow_transaction = 'Y' THEN --if l_counter !=0 then serials exist in the LPN
502: inv_trx_util_pub.TRACE('txn allowed or not: .. 120.5 Serials Exist so need to check MSN Status','Material Status', 9);
503: SELECT 'N'
504: INTO l_allow_transaction
505: FROM dual
506: WHERE EXISTS
507: (SELECT 1
508: FROM wms_lpn_contents wlc ,
509: mtl_serial_numbers msn,
532: inv_trx_util_pub.TRACE('txn allowed or not: .. 140 verifying at dest-- xfer lpn allows/not','Material Status', 9);
533: BEGIN
534: SELECT 'N'
535: INTO l_allow_transaction
536: FROM dual
537: WHERE EXISTS
538: (SELECT 1
539: FROM mtl_onhand_quantities_detail moqd,
540: mtl_status_transaction_control mtc
3092:
3093: IF l_source_status_id <> -9999 and p_item_id is not null THEN
3094: BEGIN
3095: SELECT 'Y' INTO l_comingle
3096: FROM DUAL WHERE EXISTS
3097: (SELECT 1
3098: FROM mtl_onhand_quantities_detail
3099: WHERE organization_id = p_xfr_org_id
3100: AND inventory_item_id = p_item_id
3134: inv_trx_util_pub.TRACE('l_wlc_rec.status_id: '||l_wlc_rec.status_id);
3135: END IF;
3136:
3137: SELECT 'Y' INTO l_comingle
3138: FROM DUAL WHERE EXISTS
3139: (SELECT 1
3140: FROM mtl_onhand_quantities_detail
3141: WHERE organization_id = p_xfr_org_id
3142: AND inventory_item_id =l_wlc_rec.inventory_item_id
3547:
3548: /* BEGIN
3549: SELECT 'N'
3550: INTO l_allow_transaction
3551: FROM dual
3552: WHERE EXISTS
3553: (SELECT 1
3554: FROM mtl_onhand_quantities_detail moqd,
3555: mtl_status_transaction_control mtc