eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MTL_MMTT_T dependencies on INV_GLOBALS

Line 222: ** Subinventory Xfers 2 inv_globals.G_Action_Subxfr

218: inv_trx_util_pub.TRACE('IN DB trigger-for loose item', 'update_current_capacity', 4);
219: END IF;
220: /*
221: ** The following transaction actions need to be flagged as issues
222: ** Subinventory Xfers 2 inv_globals.G_Action_Subxfr
223: ** Direct Org Xfers 3 inv_globals.G_Action_Orgxfr
224: ** Intransit Shipment 21 inv_globals.G_Action_IntransitShipment
225: ** Staging Xfers 28 inv_globals.G_Action_Stgxfr
226: ** Delivery Adjustments 29 inv_globals.G_Action_DeliveryAdj

Line 223: ** Direct Org Xfers 3 inv_globals.G_Action_Orgxfr

219: END IF;
220: /*
221: ** The following transaction actions need to be flagged as issues
222: ** Subinventory Xfers 2 inv_globals.G_Action_Subxfr
223: ** Direct Org Xfers 3 inv_globals.G_Action_Orgxfr
224: ** Intransit Shipment 21 inv_globals.G_Action_IntransitShipment
225: ** Staging Xfers 28 inv_globals.G_Action_Stgxfr
226: ** Delivery Adjustments 29 inv_globals.G_Action_DeliveryAdj
227: ** Assembly Return 32 inv_globals.G_Action_AssyReturn

Line 224: ** Intransit Shipment 21 inv_globals.G_Action_IntransitShipment

220: /*
221: ** The following transaction actions need to be flagged as issues
222: ** Subinventory Xfers 2 inv_globals.G_Action_Subxfr
223: ** Direct Org Xfers 3 inv_globals.G_Action_Orgxfr
224: ** Intransit Shipment 21 inv_globals.G_Action_IntransitShipment
225: ** Staging Xfers 28 inv_globals.G_Action_Stgxfr
226: ** Delivery Adjustments 29 inv_globals.G_Action_DeliveryAdj
227: ** Assembly Return 32 inv_globals.G_Action_AssyReturn
228: ** Negative Component Return 34 inv_globals.G_Action_NegCompReturn

Line 225: ** Staging Xfers 28 inv_globals.G_Action_Stgxfr

221: ** The following transaction actions need to be flagged as issues
222: ** Subinventory Xfers 2 inv_globals.G_Action_Subxfr
223: ** Direct Org Xfers 3 inv_globals.G_Action_Orgxfr
224: ** Intransit Shipment 21 inv_globals.G_Action_IntransitShipment
225: ** Staging Xfers 28 inv_globals.G_Action_Stgxfr
226: ** Delivery Adjustments 29 inv_globals.G_Action_DeliveryAdj
227: ** Assembly Return 32 inv_globals.G_Action_AssyReturn
228: ** Negative Component Return 34 inv_globals.G_Action_NegCompReturn
229: */

Line 226: ** Delivery Adjustments 29 inv_globals.G_Action_DeliveryAdj

222: ** Subinventory Xfers 2 inv_globals.G_Action_Subxfr
223: ** Direct Org Xfers 3 inv_globals.G_Action_Orgxfr
224: ** Intransit Shipment 21 inv_globals.G_Action_IntransitShipment
225: ** Staging Xfers 28 inv_globals.G_Action_Stgxfr
226: ** Delivery Adjustments 29 inv_globals.G_Action_DeliveryAdj
227: ** Assembly Return 32 inv_globals.G_Action_AssyReturn
228: ** Negative Component Return 34 inv_globals.G_Action_NegCompReturn
229: */
230: IF (l_transaction_action_id IN( 1,2,3,21,28,29,32,34)) THEN

Line 227: ** Assembly Return 32 inv_globals.G_Action_AssyReturn

223: ** Direct Org Xfers 3 inv_globals.G_Action_Orgxfr
224: ** Intransit Shipment 21 inv_globals.G_Action_IntransitShipment
225: ** Staging Xfers 28 inv_globals.G_Action_Stgxfr
226: ** Delivery Adjustments 29 inv_globals.G_Action_DeliveryAdj
227: ** Assembly Return 32 inv_globals.G_Action_AssyReturn
228: ** Negative Component Return 34 inv_globals.G_Action_NegCompReturn
229: */
230: IF (l_transaction_action_id IN( 1,2,3,21,28,29,32,34)) THEN
231: l_issue_flag := 'Y';

Line 228: ** Negative Component Return 34 inv_globals.G_Action_NegCompReturn

224: ** Intransit Shipment 21 inv_globals.G_Action_IntransitShipment
225: ** Staging Xfers 28 inv_globals.G_Action_Stgxfr
226: ** Delivery Adjustments 29 inv_globals.G_Action_DeliveryAdj
227: ** Assembly Return 32 inv_globals.G_Action_AssyReturn
228: ** Negative Component Return 34 inv_globals.G_Action_NegCompReturn
229: */
230: IF (l_transaction_action_id IN( 1,2,3,21,28,29,32,34)) THEN
231: l_issue_flag := 'Y';
232: ELSE

Line 268: IF (l_transaction_action_id IN(inv_globals.g_action_subxfr, inv_globals.g_action_orgxfr, inv_globals.g_action_stgxfr))

264: l_sql_stmt_num := 6;
265:
266: -- Subinventory Xfers, Direct Org Xfers, Staging Xfers, update destination
267: -- locator
268: IF (l_transaction_action_id IN(inv_globals.g_action_subxfr, inv_globals.g_action_orgxfr, inv_globals.g_action_stgxfr))
269: AND (l_transfer_to_location > 0) THEN
270: l_issue_flag := 'N';
271: l_sql_stmt_num := 7;
272:

Line 397: -- inv_globals.g_action_subxfr = 2

393: END IF;
394:
395: IF l_transfer_lpn_id IS NOT NULL OR l_content_lpn_id IS NOT NULL OR l_lpn_id IS NOT NULL THEN
396: -- Picking Suggestion
397: -- inv_globals.g_action_subxfr = 2
398: -- inv_globals.g_action_orgxfr = 3
399: -- inv_globals.g_action_stgxfr = 28
400: IF (l_transaction_action_id IN (2,3,28)) THEN
401: IF l_transfer_organization IS NULL THEN

Line 398: -- inv_globals.g_action_orgxfr = 3

394:
395: IF l_transfer_lpn_id IS NOT NULL OR l_content_lpn_id IS NOT NULL OR l_lpn_id IS NOT NULL THEN
396: -- Picking Suggestion
397: -- inv_globals.g_action_subxfr = 2
398: -- inv_globals.g_action_orgxfr = 3
399: -- inv_globals.g_action_stgxfr = 28
400: IF (l_transaction_action_id IN (2,3,28)) THEN
401: IF l_transfer_organization IS NULL THEN
402: l_transfer_organization := l_organization_id;

Line 399: -- inv_globals.g_action_stgxfr = 28

395: IF l_transfer_lpn_id IS NOT NULL OR l_content_lpn_id IS NOT NULL OR l_lpn_id IS NOT NULL THEN
396: -- Picking Suggestion
397: -- inv_globals.g_action_subxfr = 2
398: -- inv_globals.g_action_orgxfr = 3
399: -- inv_globals.g_action_stgxfr = 28
400: IF (l_transaction_action_id IN (2,3,28)) THEN
401: IF l_transfer_organization IS NULL THEN
402: l_transfer_organization := l_organization_id;
403: END IF;

Line 407: AND (l_transaction_action_id <> inv_globals.g_action_containerpack)

403: END IF;
404: /* Bug# 4046825. The following IF condition is added to prevent updating current
405: capacity in case the lpn is going to be exploded by TM. */
406: IF (NOT ( l_content_lpn_id IS NOT NULL
407: AND (l_transaction_action_id <> inv_globals.g_action_containerpack)
408: AND (l_transaction_action_id <> inv_globals.g_action_containerunpack)
409: AND (l_transaction_action_id <> inv_globals.g_action_containersplit)
410: AND NOT (l_transaction_source_type_id <> inv_globals.g_sourcetype_intorder
411: OR (l_transaction_source_type_id = inv_globals.g_sourcetype_intorder

Line 408: AND (l_transaction_action_id <> inv_globals.g_action_containerunpack)

404: /* Bug# 4046825. The following IF condition is added to prevent updating current
405: capacity in case the lpn is going to be exploded by TM. */
406: IF (NOT ( l_content_lpn_id IS NOT NULL
407: AND (l_transaction_action_id <> inv_globals.g_action_containerpack)
408: AND (l_transaction_action_id <> inv_globals.g_action_containerunpack)
409: AND (l_transaction_action_id <> inv_globals.g_action_containersplit)
410: AND NOT (l_transaction_source_type_id <> inv_globals.g_sourcetype_intorder
411: OR (l_transaction_source_type_id = inv_globals.g_sourcetype_intorder
412: AND l_transaction_action_id = inv_globals.g_action_stgxfr ) )

Line 409: AND (l_transaction_action_id <> inv_globals.g_action_containersplit)

405: capacity in case the lpn is going to be exploded by TM. */
406: IF (NOT ( l_content_lpn_id IS NOT NULL
407: AND (l_transaction_action_id <> inv_globals.g_action_containerpack)
408: AND (l_transaction_action_id <> inv_globals.g_action_containerunpack)
409: AND (l_transaction_action_id <> inv_globals.g_action_containersplit)
410: AND NOT (l_transaction_source_type_id <> inv_globals.g_sourcetype_intorder
411: OR (l_transaction_source_type_id = inv_globals.g_sourcetype_intorder
412: AND l_transaction_action_id = inv_globals.g_action_stgxfr ) )
413: AND NOT ( l_transaction_source_type_id <> inv_globals.g_sourcetype_salesorder

Line 410: AND NOT (l_transaction_source_type_id <> inv_globals.g_sourcetype_intorder

406: IF (NOT ( l_content_lpn_id IS NOT NULL
407: AND (l_transaction_action_id <> inv_globals.g_action_containerpack)
408: AND (l_transaction_action_id <> inv_globals.g_action_containerunpack)
409: AND (l_transaction_action_id <> inv_globals.g_action_containersplit)
410: AND NOT (l_transaction_source_type_id <> inv_globals.g_sourcetype_intorder
411: OR (l_transaction_source_type_id = inv_globals.g_sourcetype_intorder
412: AND l_transaction_action_id = inv_globals.g_action_stgxfr ) )
413: AND NOT ( l_transaction_source_type_id <> inv_globals.g_sourcetype_salesorder
414: OR (l_transaction_source_type_id = inv_globals.g_sourcetype_salesorder

Line 411: OR (l_transaction_source_type_id = inv_globals.g_sourcetype_intorder

407: AND (l_transaction_action_id <> inv_globals.g_action_containerpack)
408: AND (l_transaction_action_id <> inv_globals.g_action_containerunpack)
409: AND (l_transaction_action_id <> inv_globals.g_action_containersplit)
410: AND NOT (l_transaction_source_type_id <> inv_globals.g_sourcetype_intorder
411: OR (l_transaction_source_type_id = inv_globals.g_sourcetype_intorder
412: AND l_transaction_action_id = inv_globals.g_action_stgxfr ) )
413: AND NOT ( l_transaction_source_type_id <> inv_globals.g_sourcetype_salesorder
414: OR (l_transaction_source_type_id = inv_globals.g_sourcetype_salesorder
415: AND l_transaction_action_id = inv_globals.g_action_stgxfr ) )

Line 412: AND l_transaction_action_id = inv_globals.g_action_stgxfr ) )

408: AND (l_transaction_action_id <> inv_globals.g_action_containerunpack)
409: AND (l_transaction_action_id <> inv_globals.g_action_containersplit)
410: AND NOT (l_transaction_source_type_id <> inv_globals.g_sourcetype_intorder
411: OR (l_transaction_source_type_id = inv_globals.g_sourcetype_intorder
412: AND l_transaction_action_id = inv_globals.g_action_stgxfr ) )
413: AND NOT ( l_transaction_source_type_id <> inv_globals.g_sourcetype_salesorder
414: OR (l_transaction_source_type_id = inv_globals.g_sourcetype_salesorder
415: AND l_transaction_action_id = inv_globals.g_action_stgxfr ) )
416: AND ( l_transaction_action_id <> inv_globals.G_Action_Subxfr AND l_wms_task_type <> 2 )

Line 413: AND NOT ( l_transaction_source_type_id <> inv_globals.g_sourcetype_salesorder

409: AND (l_transaction_action_id <> inv_globals.g_action_containersplit)
410: AND NOT (l_transaction_source_type_id <> inv_globals.g_sourcetype_intorder
411: OR (l_transaction_source_type_id = inv_globals.g_sourcetype_intorder
412: AND l_transaction_action_id = inv_globals.g_action_stgxfr ) )
413: AND NOT ( l_transaction_source_type_id <> inv_globals.g_sourcetype_salesorder
414: OR (l_transaction_source_type_id = inv_globals.g_sourcetype_salesorder
415: AND l_transaction_action_id = inv_globals.g_action_stgxfr ) )
416: AND ( l_transaction_action_id <> inv_globals.G_Action_Subxfr AND l_wms_task_type <> 2 )
417: ) -- End of first NOT

Line 414: OR (l_transaction_source_type_id = inv_globals.g_sourcetype_salesorder

410: AND NOT (l_transaction_source_type_id <> inv_globals.g_sourcetype_intorder
411: OR (l_transaction_source_type_id = inv_globals.g_sourcetype_intorder
412: AND l_transaction_action_id = inv_globals.g_action_stgxfr ) )
413: AND NOT ( l_transaction_source_type_id <> inv_globals.g_sourcetype_salesorder
414: OR (l_transaction_source_type_id = inv_globals.g_sourcetype_salesorder
415: AND l_transaction_action_id = inv_globals.g_action_stgxfr ) )
416: AND ( l_transaction_action_id <> inv_globals.G_Action_Subxfr AND l_wms_task_type <> 2 )
417: ) -- End of first NOT
418: AND NOT ( l_content_lpn_id IS NOT NULL AND l_transaction_action_id = inv_globals.G_Action_Subxfr AND l_wms_task_type in (4,5)) --4655988

Line 415: AND l_transaction_action_id = inv_globals.g_action_stgxfr ) )

411: OR (l_transaction_source_type_id = inv_globals.g_sourcetype_intorder
412: AND l_transaction_action_id = inv_globals.g_action_stgxfr ) )
413: AND NOT ( l_transaction_source_type_id <> inv_globals.g_sourcetype_salesorder
414: OR (l_transaction_source_type_id = inv_globals.g_sourcetype_salesorder
415: AND l_transaction_action_id = inv_globals.g_action_stgxfr ) )
416: AND ( l_transaction_action_id <> inv_globals.G_Action_Subxfr AND l_wms_task_type <> 2 )
417: ) -- End of first NOT
418: AND NOT ( l_content_lpn_id IS NOT NULL AND l_transaction_action_id = inv_globals.G_Action_Subxfr AND l_wms_task_type in (4,5)) --4655988
419: ) THEN

Line 416: AND ( l_transaction_action_id <> inv_globals.G_Action_Subxfr AND l_wms_task_type <> 2 )

412: AND l_transaction_action_id = inv_globals.g_action_stgxfr ) )
413: AND NOT ( l_transaction_source_type_id <> inv_globals.g_sourcetype_salesorder
414: OR (l_transaction_source_type_id = inv_globals.g_sourcetype_salesorder
415: AND l_transaction_action_id = inv_globals.g_action_stgxfr ) )
416: AND ( l_transaction_action_id <> inv_globals.G_Action_Subxfr AND l_wms_task_type <> 2 )
417: ) -- End of first NOT
418: AND NOT ( l_content_lpn_id IS NOT NULL AND l_transaction_action_id = inv_globals.G_Action_Subxfr AND l_wms_task_type in (4,5)) --4655988
419: ) THEN
420:

Line 418: AND NOT ( l_content_lpn_id IS NOT NULL AND l_transaction_action_id = inv_globals.G_Action_Subxfr AND l_wms_task_type in (4,5)) --4655988

414: OR (l_transaction_source_type_id = inv_globals.g_sourcetype_salesorder
415: AND l_transaction_action_id = inv_globals.g_action_stgxfr ) )
416: AND ( l_transaction_action_id <> inv_globals.G_Action_Subxfr AND l_wms_task_type <> 2 )
417: ) -- End of first NOT
418: AND NOT ( l_content_lpn_id IS NOT NULL AND l_transaction_action_id = inv_globals.G_Action_Subxfr AND l_wms_task_type in (4,5)) --4655988
419: ) THEN
420:
421: IF (l_debug=1) THEN
422: inv_trx_util_pub.TRACE(

Line 427: -- Bug 4494281, the condition l_transaction_action_id = inv_globals.G_Action_Subxfr, allows the updation

423: 'UPDATING '
424: || 'l_txn_action_id :' || l_transaction_action_id
425: || 'l_wms_task_type :' || l_wms_task_type );
426: END IF;
427: -- Bug 4494281, the condition l_transaction_action_id = inv_globals.G_Action_Subxfr, allows the updation
428: -- of locator capacity for dropping to consolidation locator, which is done by TM also. Should be <>
429: -- Update locator current capacity.
430: -- bug#2876849. Added the two new parameters from org id and from loc id.
431: -- previously they were being obtained from the LPN. but in case of

Line 467: --ELSIF (l_transaction_action_id = inv_globals.g_action_receipt) THEN

463: , p_transaction_uom_code => NULL
464: , p_quantity => l_primary_quantity
465: );
466: --Putaway Transaction (Transaction Action ID = 27)
467: --ELSIF (l_transaction_action_id = inv_globals.g_action_receipt) THEN
468: ELSE
469: /*Bug# 4046825. The following IF condition is added to prevent updating current
470: capacity in case the lpn is going to be exploded by TM.*/
471: IF (NOT( l_content_lpn_id IS NOT NULL

Line 472: AND (l_transaction_action_id <> inv_globals.g_action_containerpack)

468: ELSE
469: /*Bug# 4046825. The following IF condition is added to prevent updating current
470: capacity in case the lpn is going to be exploded by TM.*/
471: IF (NOT( l_content_lpn_id IS NOT NULL
472: AND (l_transaction_action_id <> inv_globals.g_action_containerpack)
473: AND (l_transaction_action_id <> inv_globals.g_action_containerunpack)
474: AND (l_transaction_action_id <> inv_globals.g_action_containersplit)
475: AND NOT(l_transaction_source_type_id <> inv_globals.g_sourcetype_intorder
476: OR (l_transaction_source_type_id = inv_globals.g_sourcetype_intorder

Line 473: AND (l_transaction_action_id <> inv_globals.g_action_containerunpack)

469: /*Bug# 4046825. The following IF condition is added to prevent updating current
470: capacity in case the lpn is going to be exploded by TM.*/
471: IF (NOT( l_content_lpn_id IS NOT NULL
472: AND (l_transaction_action_id <> inv_globals.g_action_containerpack)
473: AND (l_transaction_action_id <> inv_globals.g_action_containerunpack)
474: AND (l_transaction_action_id <> inv_globals.g_action_containersplit)
475: AND NOT(l_transaction_source_type_id <> inv_globals.g_sourcetype_intorder
476: OR (l_transaction_source_type_id = inv_globals.g_sourcetype_intorder
477: AND l_transaction_action_id = inv_globals.g_action_stgxfr ) )

Line 474: AND (l_transaction_action_id <> inv_globals.g_action_containersplit)

470: capacity in case the lpn is going to be exploded by TM.*/
471: IF (NOT( l_content_lpn_id IS NOT NULL
472: AND (l_transaction_action_id <> inv_globals.g_action_containerpack)
473: AND (l_transaction_action_id <> inv_globals.g_action_containerunpack)
474: AND (l_transaction_action_id <> inv_globals.g_action_containersplit)
475: AND NOT(l_transaction_source_type_id <> inv_globals.g_sourcetype_intorder
476: OR (l_transaction_source_type_id = inv_globals.g_sourcetype_intorder
477: AND l_transaction_action_id = inv_globals.g_action_stgxfr ) )
478: AND NOT( l_transaction_source_type_id <> inv_globals.g_sourcetype_salesorder

Line 475: AND NOT(l_transaction_source_type_id <> inv_globals.g_sourcetype_intorder

471: IF (NOT( l_content_lpn_id IS NOT NULL
472: AND (l_transaction_action_id <> inv_globals.g_action_containerpack)
473: AND (l_transaction_action_id <> inv_globals.g_action_containerunpack)
474: AND (l_transaction_action_id <> inv_globals.g_action_containersplit)
475: AND NOT(l_transaction_source_type_id <> inv_globals.g_sourcetype_intorder
476: OR (l_transaction_source_type_id = inv_globals.g_sourcetype_intorder
477: AND l_transaction_action_id = inv_globals.g_action_stgxfr ) )
478: AND NOT( l_transaction_source_type_id <> inv_globals.g_sourcetype_salesorder
479: OR (l_transaction_source_type_id = inv_globals.g_sourcetype_salesorder

Line 476: OR (l_transaction_source_type_id = inv_globals.g_sourcetype_intorder

472: AND (l_transaction_action_id <> inv_globals.g_action_containerpack)
473: AND (l_transaction_action_id <> inv_globals.g_action_containerunpack)
474: AND (l_transaction_action_id <> inv_globals.g_action_containersplit)
475: AND NOT(l_transaction_source_type_id <> inv_globals.g_sourcetype_intorder
476: OR (l_transaction_source_type_id = inv_globals.g_sourcetype_intorder
477: AND l_transaction_action_id = inv_globals.g_action_stgxfr ) )
478: AND NOT( l_transaction_source_type_id <> inv_globals.g_sourcetype_salesorder
479: OR (l_transaction_source_type_id = inv_globals.g_sourcetype_salesorder
480: AND l_transaction_action_id = inv_globals.g_action_stgxfr ) )

Line 477: AND l_transaction_action_id = inv_globals.g_action_stgxfr ) )

473: AND (l_transaction_action_id <> inv_globals.g_action_containerunpack)
474: AND (l_transaction_action_id <> inv_globals.g_action_containersplit)
475: AND NOT(l_transaction_source_type_id <> inv_globals.g_sourcetype_intorder
476: OR (l_transaction_source_type_id = inv_globals.g_sourcetype_intorder
477: AND l_transaction_action_id = inv_globals.g_action_stgxfr ) )
478: AND NOT( l_transaction_source_type_id <> inv_globals.g_sourcetype_salesorder
479: OR (l_transaction_source_type_id = inv_globals.g_sourcetype_salesorder
480: AND l_transaction_action_id = inv_globals.g_action_stgxfr ) )
481: ) -- End of First NOT

Line 478: AND NOT( l_transaction_source_type_id <> inv_globals.g_sourcetype_salesorder

474: AND (l_transaction_action_id <> inv_globals.g_action_containersplit)
475: AND NOT(l_transaction_source_type_id <> inv_globals.g_sourcetype_intorder
476: OR (l_transaction_source_type_id = inv_globals.g_sourcetype_intorder
477: AND l_transaction_action_id = inv_globals.g_action_stgxfr ) )
478: AND NOT( l_transaction_source_type_id <> inv_globals.g_sourcetype_salesorder
479: OR (l_transaction_source_type_id = inv_globals.g_sourcetype_salesorder
480: AND l_transaction_action_id = inv_globals.g_action_stgxfr ) )
481: ) -- End of First NOT
482: AND NOT (l_content_lpn_id IS NOT NULL AND l_transaction_action_id = inv_globals.G_Action_Issue AND l_wms_task_type = 6) -- MO Issue tasks

Line 479: OR (l_transaction_source_type_id = inv_globals.g_sourcetype_salesorder

475: AND NOT(l_transaction_source_type_id <> inv_globals.g_sourcetype_intorder
476: OR (l_transaction_source_type_id = inv_globals.g_sourcetype_intorder
477: AND l_transaction_action_id = inv_globals.g_action_stgxfr ) )
478: AND NOT( l_transaction_source_type_id <> inv_globals.g_sourcetype_salesorder
479: OR (l_transaction_source_type_id = inv_globals.g_sourcetype_salesorder
480: AND l_transaction_action_id = inv_globals.g_action_stgxfr ) )
481: ) -- End of First NOT
482: AND NOT (l_content_lpn_id IS NOT NULL AND l_transaction_action_id = inv_globals.G_Action_Issue AND l_wms_task_type = 6) -- MO Issue tasks
483: ) THEN

Line 480: AND l_transaction_action_id = inv_globals.g_action_stgxfr ) )

476: OR (l_transaction_source_type_id = inv_globals.g_sourcetype_intorder
477: AND l_transaction_action_id = inv_globals.g_action_stgxfr ) )
478: AND NOT( l_transaction_source_type_id <> inv_globals.g_sourcetype_salesorder
479: OR (l_transaction_source_type_id = inv_globals.g_sourcetype_salesorder
480: AND l_transaction_action_id = inv_globals.g_action_stgxfr ) )
481: ) -- End of First NOT
482: AND NOT (l_content_lpn_id IS NOT NULL AND l_transaction_action_id = inv_globals.G_Action_Issue AND l_wms_task_type = 6) -- MO Issue tasks
483: ) THEN
484:

Line 482: AND NOT (l_content_lpn_id IS NOT NULL AND l_transaction_action_id = inv_globals.G_Action_Issue AND l_wms_task_type = 6) -- MO Issue tasks

478: AND NOT( l_transaction_source_type_id <> inv_globals.g_sourcetype_salesorder
479: OR (l_transaction_source_type_id = inv_globals.g_sourcetype_salesorder
480: AND l_transaction_action_id = inv_globals.g_action_stgxfr ) )
481: ) -- End of First NOT
482: AND NOT (l_content_lpn_id IS NOT NULL AND l_transaction_action_id = inv_globals.G_Action_Issue AND l_wms_task_type = 6) -- MO Issue tasks
483: ) THEN
484:
485: --Update Locator Capacity.
486: -- added the two new parameters because for bulk pack, the transfer lpn