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.INV_COST_GROUP_UPDATE dependencies on INV_GLOBALS

Line 74: IF p_transaction_action_id IN (inv_globals.g_action_subxfr,

70: print_debug('in proc_update_mmtt .. p_transfer_organization : '|| p_transfer_organization );
71: END IF;
72: x_return_status := fnd_api.g_ret_sts_success;
73:
74: IF p_transaction_action_id IN (inv_globals.g_action_subxfr,
75: inv_globals.g_action_stgxfr,
76: inv_globals.g_action_ownxfr)
77: -- Subtransfer, staging transfer
78: THEN

Line 75: inv_globals.g_action_stgxfr,

71: END IF;
72: x_return_status := fnd_api.g_ret_sts_success;
73:
74: IF p_transaction_action_id IN (inv_globals.g_action_subxfr,
75: inv_globals.g_action_stgxfr,
76: inv_globals.g_action_ownxfr)
77: -- Subtransfer, staging transfer
78: THEN
79: l_transfer_cost_group_id := p_cost_group_id;

Line 76: inv_globals.g_action_ownxfr)

72: x_return_status := fnd_api.g_ret_sts_success;
73:
74: IF p_transaction_action_id IN (inv_globals.g_action_subxfr,
75: inv_globals.g_action_stgxfr,
76: inv_globals.g_action_ownxfr)
77: -- Subtransfer, staging transfer
78: THEN
79: l_transfer_cost_group_id := p_cost_group_id;
80: ELSE

Line 84: IF p_transaction_Action_id = inv_globals.g_action_intransitshipment THEN

80: ELSE
81: l_transfer_cost_group_id := p_transfer_cost_group_id;
82: END IF;
83:
84: IF p_transaction_Action_id = inv_globals.g_action_intransitshipment THEN
85: IF NOT p_transfer_wms_org AND p_fob_point = 1 THEN -- shipment
86: -- We don't care about the costing method of the org
87: l_transfer_cost_group_id := p_tfr_org_cost_group_id;
88: IF (l_debug = 1) THEN

Line 98: p_transaction_action_id IN (inv_globals.g_action_subxfr,

94: END IF;
95:
96: IF(p_from_project_id IS NULL AND
97: p_to_project_id IS NOT NULL AND
98: p_transaction_action_id IN (inv_globals.g_action_subxfr,
99: inv_globals.g_action_stgxfr,
100: inv_globals.G_Action_Receipt)) then
101:
102: IF (l_debug = 1) THEN

Line 99: inv_globals.g_action_stgxfr,

95:
96: IF(p_from_project_id IS NULL AND
97: p_to_project_id IS NOT NULL AND
98: p_transaction_action_id IN (inv_globals.g_action_subxfr,
99: inv_globals.g_action_stgxfr,
100: inv_globals.G_Action_Receipt)) then
101:
102: IF (l_debug = 1) THEN
103: print_debug('updating the transfer_cost_group to null as the dest'|| 'locator is proj enabled');

Line 100: inv_globals.G_Action_Receipt)) then

96: IF(p_from_project_id IS NULL AND
97: p_to_project_id IS NOT NULL AND
98: p_transaction_action_id IN (inv_globals.g_action_subxfr,
99: inv_globals.g_action_stgxfr,
100: inv_globals.G_Action_Receipt)) then
101:
102: IF (l_debug = 1) THEN
103: print_debug('updating the transfer_cost_group to null as the dest'|| 'locator is proj enabled');
104: END IF;

Line 562: AND mmtt.transaction_action_id IN (inv_globals.g_action_subxfr,

558: AND mmtt.transfer_subinventory = p_subinventory_code
559: AND Nvl(mmtt.transfer_to_location, -1) = Nvl(p_locator_id, -1)
560: AND mmtt.inventory_item_id = p_inventory_item_id
561: AND Nvl(mmtt.lpn_id, -1) = Nvl(p_lpn_id, -1)
562: AND mmtt.transaction_action_id IN (inv_globals.g_action_subxfr,
563: inv_globals.g_action_orgxfr,
564: inv_globals.g_action_stgxfr)
565:
566: UNION

Line 563: inv_globals.g_action_orgxfr,

559: AND Nvl(mmtt.transfer_to_location, -1) = Nvl(p_locator_id, -1)
560: AND mmtt.inventory_item_id = p_inventory_item_id
561: AND Nvl(mmtt.lpn_id, -1) = Nvl(p_lpn_id, -1)
562: AND mmtt.transaction_action_id IN (inv_globals.g_action_subxfr,
563: inv_globals.g_action_orgxfr,
564: inv_globals.g_action_stgxfr)
565:
566: UNION
567:

Line 564: inv_globals.g_action_stgxfr)

560: AND mmtt.inventory_item_id = p_inventory_item_id
561: AND Nvl(mmtt.lpn_id, -1) = Nvl(p_lpn_id, -1)
562: AND mmtt.transaction_action_id IN (inv_globals.g_action_subxfr,
563: inv_globals.g_action_orgxfr,
564: inv_globals.g_action_stgxfr)
565:
566: UNION
567:
568: -- No control

Line 577: AND mmtt.transaction_action_id IN (inv_globals.g_action_cyclecountadj,

573: AND mmtt.subinventory_code = p_subinventory_code
574: AND Nvl(mmtt.locator_id, -1) = Nvl(p_locator_id, -1)
575: AND mmtt.inventory_item_id = p_inventory_item_id
576: AND Nvl(mmtt.lpn_id, -1) = Nvl(p_lpn_id, -1)
577: AND mmtt.transaction_action_id IN (inv_globals.g_action_cyclecountadj,
578: inv_globals.g_action_physicalcountadj,
579: inv_globals.g_action_intransitreceipt,
580: inv_globals.g_action_receipt,
581: inv_globals.g_action_assycomplete,

Line 578: inv_globals.g_action_physicalcountadj,

574: AND Nvl(mmtt.locator_id, -1) = Nvl(p_locator_id, -1)
575: AND mmtt.inventory_item_id = p_inventory_item_id
576: AND Nvl(mmtt.lpn_id, -1) = Nvl(p_lpn_id, -1)
577: AND mmtt.transaction_action_id IN (inv_globals.g_action_cyclecountadj,
578: inv_globals.g_action_physicalcountadj,
579: inv_globals.g_action_intransitreceipt,
580: inv_globals.g_action_receipt,
581: inv_globals.g_action_assycomplete,
582: /*3199679inv_globals.g_action_assyreturn,*/

Line 579: inv_globals.g_action_intransitreceipt,

575: AND mmtt.inventory_item_id = p_inventory_item_id
576: AND Nvl(mmtt.lpn_id, -1) = Nvl(p_lpn_id, -1)
577: AND mmtt.transaction_action_id IN (inv_globals.g_action_cyclecountadj,
578: inv_globals.g_action_physicalcountadj,
579: inv_globals.g_action_intransitreceipt,
580: inv_globals.g_action_receipt,
581: inv_globals.g_action_assycomplete,
582: /*3199679inv_globals.g_action_assyreturn,*/
583: inv_globals.g_action_inv_lot_split,

Line 580: inv_globals.g_action_receipt,

576: AND Nvl(mmtt.lpn_id, -1) = Nvl(p_lpn_id, -1)
577: AND mmtt.transaction_action_id IN (inv_globals.g_action_cyclecountadj,
578: inv_globals.g_action_physicalcountadj,
579: inv_globals.g_action_intransitreceipt,
580: inv_globals.g_action_receipt,
581: inv_globals.g_action_assycomplete,
582: /*3199679inv_globals.g_action_assyreturn,*/
583: inv_globals.g_action_inv_lot_split,
584: inv_globals.g_action_inv_lot_merge,

Line 581: inv_globals.g_action_assycomplete,

577: AND mmtt.transaction_action_id IN (inv_globals.g_action_cyclecountadj,
578: inv_globals.g_action_physicalcountadj,
579: inv_globals.g_action_intransitreceipt,
580: inv_globals.g_action_receipt,
581: inv_globals.g_action_assycomplete,
582: /*3199679inv_globals.g_action_assyreturn,*/
583: inv_globals.g_action_inv_lot_split,
584: inv_globals.g_action_inv_lot_merge,
585: inv_globals.g_action_inv_lot_translate))

Line 582: /3199679inv_globals.g_action_assyreturn,/

578: inv_globals.g_action_physicalcountadj,
579: inv_globals.g_action_intransitreceipt,
580: inv_globals.g_action_receipt,
581: inv_globals.g_action_assycomplete,
582: /*3199679inv_globals.g_action_assyreturn,*/
583: inv_globals.g_action_inv_lot_split,
584: inv_globals.g_action_inv_lot_merge,
585: inv_globals.g_action_inv_lot_translate))
586: WHERE ROWNUM = 1;

Line 583: inv_globals.g_action_inv_lot_split,

579: inv_globals.g_action_intransitreceipt,
580: inv_globals.g_action_receipt,
581: inv_globals.g_action_assycomplete,
582: /*3199679inv_globals.g_action_assyreturn,*/
583: inv_globals.g_action_inv_lot_split,
584: inv_globals.g_action_inv_lot_merge,
585: inv_globals.g_action_inv_lot_translate))
586: WHERE ROWNUM = 1;
587:

Line 584: inv_globals.g_action_inv_lot_merge,

580: inv_globals.g_action_receipt,
581: inv_globals.g_action_assycomplete,
582: /*3199679inv_globals.g_action_assyreturn,*/
583: inv_globals.g_action_inv_lot_split,
584: inv_globals.g_action_inv_lot_merge,
585: inv_globals.g_action_inv_lot_translate))
586: WHERE ROWNUM = 1;
587:
588: ELSE

Line 585: inv_globals.g_action_inv_lot_translate))

581: inv_globals.g_action_assycomplete,
582: /*3199679inv_globals.g_action_assyreturn,*/
583: inv_globals.g_action_inv_lot_split,
584: inv_globals.g_action_inv_lot_merge,
585: inv_globals.g_action_inv_lot_translate))
586: WHERE ROWNUM = 1;
587:
588: ELSE
589: IF (l_debug = 1) THEN

Line 602: AND mmtt.transaction_action_id IN (inv_globals.g_action_subxfr,

598: AND mmtt.transfer_subinventory = p_subinventory_code
599: AND Nvl(mmtt.transfer_to_location, -1) = Nvl(p_locator_id, -1)
600: AND mmtt.inventory_item_id = p_inventory_item_id
601: AND Nvl(mmtt.lpn_id, -1) = Nvl(p_lpn_id, -1)
602: AND mmtt.transaction_action_id IN (inv_globals.g_action_subxfr,
603: inv_globals.g_action_orgxfr,
604: inv_globals.g_action_stgxfr)
605: AND mmtt.transaction_temp_id = mtlt.transaction_temp_id
606: AND mtlt.lot_number = p_lot_number

Line 603: inv_globals.g_action_orgxfr,

599: AND Nvl(mmtt.transfer_to_location, -1) = Nvl(p_locator_id, -1)
600: AND mmtt.inventory_item_id = p_inventory_item_id
601: AND Nvl(mmtt.lpn_id, -1) = Nvl(p_lpn_id, -1)
602: AND mmtt.transaction_action_id IN (inv_globals.g_action_subxfr,
603: inv_globals.g_action_orgxfr,
604: inv_globals.g_action_stgxfr)
605: AND mmtt.transaction_temp_id = mtlt.transaction_temp_id
606: AND mtlt.lot_number = p_lot_number
607:

Line 604: inv_globals.g_action_stgxfr)

600: AND mmtt.inventory_item_id = p_inventory_item_id
601: AND Nvl(mmtt.lpn_id, -1) = Nvl(p_lpn_id, -1)
602: AND mmtt.transaction_action_id IN (inv_globals.g_action_subxfr,
603: inv_globals.g_action_orgxfr,
604: inv_globals.g_action_stgxfr)
605: AND mmtt.transaction_temp_id = mtlt.transaction_temp_id
606: AND mtlt.lot_number = p_lot_number
607:
608: UNION

Line 618: AND mmtt.transaction_action_id IN (inv_globals.g_action_cyclecountadj,

614: AND mmtt.subinventory_code = p_subinventory_code
615: AND Nvl(mmtt.locator_id, -1) = Nvl(p_locator_id, -1)
616: AND mmtt.inventory_item_id = p_inventory_item_id
617: AND Nvl(mmtt.lpn_id, -1) = Nvl(p_lpn_id, -1)
618: AND mmtt.transaction_action_id IN (inv_globals.g_action_cyclecountadj,
619: inv_globals.g_action_physicalcountadj,
620: inv_globals.g_action_intransitreceipt,
621: inv_globals.g_action_receipt,
622: inv_globals.g_action_assycomplete,

Line 619: inv_globals.g_action_physicalcountadj,

615: AND Nvl(mmtt.locator_id, -1) = Nvl(p_locator_id, -1)
616: AND mmtt.inventory_item_id = p_inventory_item_id
617: AND Nvl(mmtt.lpn_id, -1) = Nvl(p_lpn_id, -1)
618: AND mmtt.transaction_action_id IN (inv_globals.g_action_cyclecountadj,
619: inv_globals.g_action_physicalcountadj,
620: inv_globals.g_action_intransitreceipt,
621: inv_globals.g_action_receipt,
622: inv_globals.g_action_assycomplete,
623: /*3199679 inv_globals.g_action_assyreturn,*/

Line 620: inv_globals.g_action_intransitreceipt,

616: AND mmtt.inventory_item_id = p_inventory_item_id
617: AND Nvl(mmtt.lpn_id, -1) = Nvl(p_lpn_id, -1)
618: AND mmtt.transaction_action_id IN (inv_globals.g_action_cyclecountadj,
619: inv_globals.g_action_physicalcountadj,
620: inv_globals.g_action_intransitreceipt,
621: inv_globals.g_action_receipt,
622: inv_globals.g_action_assycomplete,
623: /*3199679 inv_globals.g_action_assyreturn,*/
624: inv_globals.g_action_inv_lot_split,

Line 621: inv_globals.g_action_receipt,

617: AND Nvl(mmtt.lpn_id, -1) = Nvl(p_lpn_id, -1)
618: AND mmtt.transaction_action_id IN (inv_globals.g_action_cyclecountadj,
619: inv_globals.g_action_physicalcountadj,
620: inv_globals.g_action_intransitreceipt,
621: inv_globals.g_action_receipt,
622: inv_globals.g_action_assycomplete,
623: /*3199679 inv_globals.g_action_assyreturn,*/
624: inv_globals.g_action_inv_lot_split,
625: inv_globals.g_action_inv_lot_merge,

Line 622: inv_globals.g_action_assycomplete,

618: AND mmtt.transaction_action_id IN (inv_globals.g_action_cyclecountadj,
619: inv_globals.g_action_physicalcountadj,
620: inv_globals.g_action_intransitreceipt,
621: inv_globals.g_action_receipt,
622: inv_globals.g_action_assycomplete,
623: /*3199679 inv_globals.g_action_assyreturn,*/
624: inv_globals.g_action_inv_lot_split,
625: inv_globals.g_action_inv_lot_merge,
626: inv_globals.g_action_inv_lot_translate)

Line 623: /3199679 inv_globals.g_action_assyreturn,/

619: inv_globals.g_action_physicalcountadj,
620: inv_globals.g_action_intransitreceipt,
621: inv_globals.g_action_receipt,
622: inv_globals.g_action_assycomplete,
623: /*3199679 inv_globals.g_action_assyreturn,*/
624: inv_globals.g_action_inv_lot_split,
625: inv_globals.g_action_inv_lot_merge,
626: inv_globals.g_action_inv_lot_translate)
627: AND mmtt.transaction_temp_id = mtlt.transaction_temp_id

Line 624: inv_globals.g_action_inv_lot_split,

620: inv_globals.g_action_intransitreceipt,
621: inv_globals.g_action_receipt,
622: inv_globals.g_action_assycomplete,
623: /*3199679 inv_globals.g_action_assyreturn,*/
624: inv_globals.g_action_inv_lot_split,
625: inv_globals.g_action_inv_lot_merge,
626: inv_globals.g_action_inv_lot_translate)
627: AND mmtt.transaction_temp_id = mtlt.transaction_temp_id
628: AND mtlt.lot_number = p_lot_number)

Line 625: inv_globals.g_action_inv_lot_merge,

621: inv_globals.g_action_receipt,
622: inv_globals.g_action_assycomplete,
623: /*3199679 inv_globals.g_action_assyreturn,*/
624: inv_globals.g_action_inv_lot_split,
625: inv_globals.g_action_inv_lot_merge,
626: inv_globals.g_action_inv_lot_translate)
627: AND mmtt.transaction_temp_id = mtlt.transaction_temp_id
628: AND mtlt.lot_number = p_lot_number)
629: WHERE ROWNUM = 1;

Line 626: inv_globals.g_action_inv_lot_translate)

622: inv_globals.g_action_assycomplete,
623: /*3199679 inv_globals.g_action_assyreturn,*/
624: inv_globals.g_action_inv_lot_split,
625: inv_globals.g_action_inv_lot_merge,
626: inv_globals.g_action_inv_lot_translate)
627: AND mmtt.transaction_temp_id = mtlt.transaction_temp_id
628: AND mtlt.lot_number = p_lot_number)
629: WHERE ROWNUM = 1;
630:

Line 652: AND mmtt.transaction_action_id IN (inv_globals.g_action_subxfr,

648: AND mmtt.transfer_subinventory = p_subinventory_code
649: AND Nvl(mmtt.transfer_to_location, -1) = Nvl(p_locator_id, -1)
650: AND mmtt.inventory_item_id = p_inventory_item_id
651: AND Nvl(mmtt.lpn_id, -1) = Nvl(p_lpn_id, -1)
652: AND mmtt.transaction_action_id IN (inv_globals.g_action_subxfr,
653: inv_globals.g_action_orgxfr,
654: inv_globals.g_action_stgxfr)
655: AND mmtt.transaction_temp_id = msnt.transaction_temp_id
656: AND msnt.fm_serial_number <= p_serial_number

Line 653: inv_globals.g_action_orgxfr,

649: AND Nvl(mmtt.transfer_to_location, -1) = Nvl(p_locator_id, -1)
650: AND mmtt.inventory_item_id = p_inventory_item_id
651: AND Nvl(mmtt.lpn_id, -1) = Nvl(p_lpn_id, -1)
652: AND mmtt.transaction_action_id IN (inv_globals.g_action_subxfr,
653: inv_globals.g_action_orgxfr,
654: inv_globals.g_action_stgxfr)
655: AND mmtt.transaction_temp_id = msnt.transaction_temp_id
656: AND msnt.fm_serial_number <= p_serial_number
657: AND msnt.to_serial_number >= p_serial_number

Line 654: inv_globals.g_action_stgxfr)

650: AND mmtt.inventory_item_id = p_inventory_item_id
651: AND Nvl(mmtt.lpn_id, -1) = Nvl(p_lpn_id, -1)
652: AND mmtt.transaction_action_id IN (inv_globals.g_action_subxfr,
653: inv_globals.g_action_orgxfr,
654: inv_globals.g_action_stgxfr)
655: AND mmtt.transaction_temp_id = msnt.transaction_temp_id
656: AND msnt.fm_serial_number <= p_serial_number
657: AND msnt.to_serial_number >= p_serial_number
658:

Line 669: AND mmtt.transaction_action_id IN (inv_globals.g_action_cyclecountadj,

665: AND mmtt.subinventory_code = p_subinventory_code
666: AND Nvl(mmtt.locator_id, -1) = Nvl(p_locator_id, -1)
667: AND mmtt.inventory_item_id = p_inventory_item_id
668: AND Nvl(mmtt.lpn_id, -1) = Nvl(p_lpn_id, -1)
669: AND mmtt.transaction_action_id IN (inv_globals.g_action_cyclecountadj,
670: inv_globals.g_action_physicalcountadj,
671: inv_globals.g_action_intransitreceipt,
672: inv_globals.g_action_receipt,
673: inv_globals.g_action_assycomplete,

Line 670: inv_globals.g_action_physicalcountadj,

666: AND Nvl(mmtt.locator_id, -1) = Nvl(p_locator_id, -1)
667: AND mmtt.inventory_item_id = p_inventory_item_id
668: AND Nvl(mmtt.lpn_id, -1) = Nvl(p_lpn_id, -1)
669: AND mmtt.transaction_action_id IN (inv_globals.g_action_cyclecountadj,
670: inv_globals.g_action_physicalcountadj,
671: inv_globals.g_action_intransitreceipt,
672: inv_globals.g_action_receipt,
673: inv_globals.g_action_assycomplete,
674: /*3199679inv_globals.g_action_assyreturn,*/

Line 671: inv_globals.g_action_intransitreceipt,

667: AND mmtt.inventory_item_id = p_inventory_item_id
668: AND Nvl(mmtt.lpn_id, -1) = Nvl(p_lpn_id, -1)
669: AND mmtt.transaction_action_id IN (inv_globals.g_action_cyclecountadj,
670: inv_globals.g_action_physicalcountadj,
671: inv_globals.g_action_intransitreceipt,
672: inv_globals.g_action_receipt,
673: inv_globals.g_action_assycomplete,
674: /*3199679inv_globals.g_action_assyreturn,*/
675: inv_globals.g_action_inv_lot_split,

Line 672: inv_globals.g_action_receipt,

668: AND Nvl(mmtt.lpn_id, -1) = Nvl(p_lpn_id, -1)
669: AND mmtt.transaction_action_id IN (inv_globals.g_action_cyclecountadj,
670: inv_globals.g_action_physicalcountadj,
671: inv_globals.g_action_intransitreceipt,
672: inv_globals.g_action_receipt,
673: inv_globals.g_action_assycomplete,
674: /*3199679inv_globals.g_action_assyreturn,*/
675: inv_globals.g_action_inv_lot_split,
676: inv_globals.g_action_inv_lot_merge,

Line 673: inv_globals.g_action_assycomplete,

669: AND mmtt.transaction_action_id IN (inv_globals.g_action_cyclecountadj,
670: inv_globals.g_action_physicalcountadj,
671: inv_globals.g_action_intransitreceipt,
672: inv_globals.g_action_receipt,
673: inv_globals.g_action_assycomplete,
674: /*3199679inv_globals.g_action_assyreturn,*/
675: inv_globals.g_action_inv_lot_split,
676: inv_globals.g_action_inv_lot_merge,
677: inv_globals.g_action_inv_lot_translate)

Line 674: /3199679inv_globals.g_action_assyreturn,/

670: inv_globals.g_action_physicalcountadj,
671: inv_globals.g_action_intransitreceipt,
672: inv_globals.g_action_receipt,
673: inv_globals.g_action_assycomplete,
674: /*3199679inv_globals.g_action_assyreturn,*/
675: inv_globals.g_action_inv_lot_split,
676: inv_globals.g_action_inv_lot_merge,
677: inv_globals.g_action_inv_lot_translate)
678: AND mmtt.transaction_temp_id = msnt.transaction_temp_id

Line 675: inv_globals.g_action_inv_lot_split,

671: inv_globals.g_action_intransitreceipt,
672: inv_globals.g_action_receipt,
673: inv_globals.g_action_assycomplete,
674: /*3199679inv_globals.g_action_assyreturn,*/
675: inv_globals.g_action_inv_lot_split,
676: inv_globals.g_action_inv_lot_merge,
677: inv_globals.g_action_inv_lot_translate)
678: AND mmtt.transaction_temp_id = msnt.transaction_temp_id
679: AND msnt.fm_serial_number <= p_serial_number

Line 676: inv_globals.g_action_inv_lot_merge,

672: inv_globals.g_action_receipt,
673: inv_globals.g_action_assycomplete,
674: /*3199679inv_globals.g_action_assyreturn,*/
675: inv_globals.g_action_inv_lot_split,
676: inv_globals.g_action_inv_lot_merge,
677: inv_globals.g_action_inv_lot_translate)
678: AND mmtt.transaction_temp_id = msnt.transaction_temp_id
679: AND msnt.fm_serial_number <= p_serial_number
680: AND msnt.to_serial_number >= p_serial_number)

Line 677: inv_globals.g_action_inv_lot_translate)

673: inv_globals.g_action_assycomplete,
674: /*3199679inv_globals.g_action_assyreturn,*/
675: inv_globals.g_action_inv_lot_split,
676: inv_globals.g_action_inv_lot_merge,
677: inv_globals.g_action_inv_lot_translate)
678: AND mmtt.transaction_temp_id = msnt.transaction_temp_id
679: AND msnt.fm_serial_number <= p_serial_number
680: AND msnt.to_serial_number >= p_serial_number)
681: WHERE ROWNUM = 1;

Line 698: AND mmtt.transaction_action_id IN (inv_globals.g_action_subxfr,

694: AND mmtt.transfer_subinventory = p_subinventory_code
695: AND Nvl(mmtt.transfer_to_location, -1) = Nvl(p_locator_id, -1)
696: AND mmtt.inventory_item_id = p_inventory_item_id
697: AND Nvl(mmtt.lpn_id, -1) = Nvl(p_lpn_id, -1)
698: AND mmtt.transaction_action_id IN (inv_globals.g_action_subxfr,
699: inv_globals.g_action_orgxfr,
700: inv_globals.g_action_stgxfr)
701: AND mmtt.transaction_temp_id = mtlt.transaction_temp_id
702: AND mtlt.lot_number = p_lot_number

Line 699: inv_globals.g_action_orgxfr,

695: AND Nvl(mmtt.transfer_to_location, -1) = Nvl(p_locator_id, -1)
696: AND mmtt.inventory_item_id = p_inventory_item_id
697: AND Nvl(mmtt.lpn_id, -1) = Nvl(p_lpn_id, -1)
698: AND mmtt.transaction_action_id IN (inv_globals.g_action_subxfr,
699: inv_globals.g_action_orgxfr,
700: inv_globals.g_action_stgxfr)
701: AND mmtt.transaction_temp_id = mtlt.transaction_temp_id
702: AND mtlt.lot_number = p_lot_number
703: AND mtlt.transaction_temp_id = msnt.transaction_temp_id

Line 700: inv_globals.g_action_stgxfr)

696: AND mmtt.inventory_item_id = p_inventory_item_id
697: AND Nvl(mmtt.lpn_id, -1) = Nvl(p_lpn_id, -1)
698: AND mmtt.transaction_action_id IN (inv_globals.g_action_subxfr,
699: inv_globals.g_action_orgxfr,
700: inv_globals.g_action_stgxfr)
701: AND mmtt.transaction_temp_id = mtlt.transaction_temp_id
702: AND mtlt.lot_number = p_lot_number
703: AND mtlt.transaction_temp_id = msnt.transaction_temp_id
704: AND msnt.fm_serial_number <= p_serial_number

Line 718: AND mmtt.transaction_action_id IN (inv_globals.g_action_cyclecountadj,

714: AND mmtt.subinventory_code = p_subinventory_code
715: AND Nvl(mmtt.locator_id, -1) = Nvl(p_locator_id, -1)
716: AND mmtt.inventory_item_id = p_inventory_item_id
717: AND Nvl(mmtt.lpn_id, -1) = Nvl(p_lpn_id, -1)
718: AND mmtt.transaction_action_id IN (inv_globals.g_action_cyclecountadj,
719: inv_globals.g_action_physicalcountadj,
720: inv_globals.g_action_intransitreceipt,
721: inv_globals.g_action_receipt,
722: inv_globals.g_action_assycomplete,

Line 719: inv_globals.g_action_physicalcountadj,

715: AND Nvl(mmtt.locator_id, -1) = Nvl(p_locator_id, -1)
716: AND mmtt.inventory_item_id = p_inventory_item_id
717: AND Nvl(mmtt.lpn_id, -1) = Nvl(p_lpn_id, -1)
718: AND mmtt.transaction_action_id IN (inv_globals.g_action_cyclecountadj,
719: inv_globals.g_action_physicalcountadj,
720: inv_globals.g_action_intransitreceipt,
721: inv_globals.g_action_receipt,
722: inv_globals.g_action_assycomplete,
723: /*3199679inv_globals.g_action_assyreturn,*/

Line 720: inv_globals.g_action_intransitreceipt,

716: AND mmtt.inventory_item_id = p_inventory_item_id
717: AND Nvl(mmtt.lpn_id, -1) = Nvl(p_lpn_id, -1)
718: AND mmtt.transaction_action_id IN (inv_globals.g_action_cyclecountadj,
719: inv_globals.g_action_physicalcountadj,
720: inv_globals.g_action_intransitreceipt,
721: inv_globals.g_action_receipt,
722: inv_globals.g_action_assycomplete,
723: /*3199679inv_globals.g_action_assyreturn,*/
724: inv_globals.g_action_inv_lot_split,

Line 721: inv_globals.g_action_receipt,

717: AND Nvl(mmtt.lpn_id, -1) = Nvl(p_lpn_id, -1)
718: AND mmtt.transaction_action_id IN (inv_globals.g_action_cyclecountadj,
719: inv_globals.g_action_physicalcountadj,
720: inv_globals.g_action_intransitreceipt,
721: inv_globals.g_action_receipt,
722: inv_globals.g_action_assycomplete,
723: /*3199679inv_globals.g_action_assyreturn,*/
724: inv_globals.g_action_inv_lot_split,
725: inv_globals.g_action_inv_lot_merge,

Line 722: inv_globals.g_action_assycomplete,

718: AND mmtt.transaction_action_id IN (inv_globals.g_action_cyclecountadj,
719: inv_globals.g_action_physicalcountadj,
720: inv_globals.g_action_intransitreceipt,
721: inv_globals.g_action_receipt,
722: inv_globals.g_action_assycomplete,
723: /*3199679inv_globals.g_action_assyreturn,*/
724: inv_globals.g_action_inv_lot_split,
725: inv_globals.g_action_inv_lot_merge,
726: inv_globals.g_action_inv_lot_translate)

Line 723: /3199679inv_globals.g_action_assyreturn,/

719: inv_globals.g_action_physicalcountadj,
720: inv_globals.g_action_intransitreceipt,
721: inv_globals.g_action_receipt,
722: inv_globals.g_action_assycomplete,
723: /*3199679inv_globals.g_action_assyreturn,*/
724: inv_globals.g_action_inv_lot_split,
725: inv_globals.g_action_inv_lot_merge,
726: inv_globals.g_action_inv_lot_translate)
727: AND mmtt.transaction_temp_id = mtlt.transaction_temp_id

Line 724: inv_globals.g_action_inv_lot_split,

720: inv_globals.g_action_intransitreceipt,
721: inv_globals.g_action_receipt,
722: inv_globals.g_action_assycomplete,
723: /*3199679inv_globals.g_action_assyreturn,*/
724: inv_globals.g_action_inv_lot_split,
725: inv_globals.g_action_inv_lot_merge,
726: inv_globals.g_action_inv_lot_translate)
727: AND mmtt.transaction_temp_id = mtlt.transaction_temp_id
728: AND mtlt.lot_number = p_lot_number

Line 725: inv_globals.g_action_inv_lot_merge,

721: inv_globals.g_action_receipt,
722: inv_globals.g_action_assycomplete,
723: /*3199679inv_globals.g_action_assyreturn,*/
724: inv_globals.g_action_inv_lot_split,
725: inv_globals.g_action_inv_lot_merge,
726: inv_globals.g_action_inv_lot_translate)
727: AND mmtt.transaction_temp_id = mtlt.transaction_temp_id
728: AND mtlt.lot_number = p_lot_number
729: AND mtlt.transaction_temp_id = msnt.transaction_temp_id

Line 726: inv_globals.g_action_inv_lot_translate)

722: inv_globals.g_action_assycomplete,
723: /*3199679inv_globals.g_action_assyreturn,*/
724: inv_globals.g_action_inv_lot_split,
725: inv_globals.g_action_inv_lot_merge,
726: inv_globals.g_action_inv_lot_translate)
727: AND mmtt.transaction_temp_id = mtlt.transaction_temp_id
728: AND mtlt.lot_number = p_lot_number
729: AND mtlt.transaction_temp_id = msnt.transaction_temp_id
730: AND msnt.fm_serial_number <= p_serial_number

Line 1473: IF p_mmtt_rec.transaction_action_id IN (inv_globals.G_Action_Subxfr,

1469: IF (l_debug = 1) THEN
1470: print_debug( 'Begin proc_insert_mmtt: action_id: ' || p_mmtt_rec.transaction_action_id );
1471: END IF;
1472: SAVEPOINT sp_proc_insert_mmtt;
1473: IF p_mmtt_rec.transaction_action_id IN (inv_globals.G_Action_Subxfr,
1474: inv_globals.g_action_stgxfr,
1475: inv_globals.g_action_ownxfr)
1476: -- Subtransfer, staging transfer
1477: THEN

Line 1474: inv_globals.g_action_stgxfr,

1470: print_debug( 'Begin proc_insert_mmtt: action_id: ' || p_mmtt_rec.transaction_action_id );
1471: END IF;
1472: SAVEPOINT sp_proc_insert_mmtt;
1473: IF p_mmtt_rec.transaction_action_id IN (inv_globals.G_Action_Subxfr,
1474: inv_globals.g_action_stgxfr,
1475: inv_globals.g_action_ownxfr)
1476: -- Subtransfer, staging transfer
1477: THEN
1478: l_transfer_cost_group_id := p_cost_group_id;

Line 1475: inv_globals.g_action_ownxfr)

1471: END IF;
1472: SAVEPOINT sp_proc_insert_mmtt;
1473: IF p_mmtt_rec.transaction_action_id IN (inv_globals.G_Action_Subxfr,
1474: inv_globals.g_action_stgxfr,
1475: inv_globals.g_action_ownxfr)
1476: -- Subtransfer, staging transfer
1477: THEN
1478: l_transfer_cost_group_id := p_cost_group_id;
1479: ELSE

Line 1483: IF p_mmtt_rec.transaction_Action_id = inv_globals.g_action_intransitshipment THEN

1479: ELSE
1480: l_transfer_cost_group_id := p_transfer_cost_group_id;
1481: END IF;
1482:
1483: IF p_mmtt_rec.transaction_Action_id = inv_globals.g_action_intransitshipment THEN
1484: IF NOT p_transfer_wms_org AND p_fob_point = 1 THEN -- shipment
1485: -- We don't care about the costing method of the org
1486: l_transfer_cost_group_id := p_tfr_org_cost_group_id;
1487: IF (l_debug = 1) THEN

Line 1498: p_mmtt_rec.transaction_action_id IN (inv_globals.g_action_subxfr,

1494: END IF;
1495:
1496: IF(p_from_project_id IS NULL AND
1497: p_to_project_id IS NOT NULL AND
1498: p_mmtt_rec.transaction_action_id IN (inv_globals.g_action_subxfr,
1499: inv_globals.g_action_stgxfr,
1500: inv_globals.G_Action_Receipt)) then
1501:
1502: IF (l_debug = 1) THEN

Line 1499: inv_globals.g_action_stgxfr,

1495:
1496: IF(p_from_project_id IS NULL AND
1497: p_to_project_id IS NOT NULL AND
1498: p_mmtt_rec.transaction_action_id IN (inv_globals.g_action_subxfr,
1499: inv_globals.g_action_stgxfr,
1500: inv_globals.G_Action_Receipt)) then
1501:
1502: IF (l_debug = 1) THEN
1503: print_debug('inserting the transfer_cost_group to null as the dest'||

Line 1500: inv_globals.G_Action_Receipt)) then

1496: IF(p_from_project_id IS NULL AND
1497: p_to_project_id IS NOT NULL AND
1498: p_mmtt_rec.transaction_action_id IN (inv_globals.g_action_subxfr,
1499: inv_globals.g_action_stgxfr,
1500: inv_globals.G_Action_Receipt)) then
1501:
1502: IF (l_debug = 1) THEN
1503: print_debug('inserting the transfer_cost_group to null as the dest'||
1504: 'locator is proj enabled');

Line 2051: IF p_mmtt_rec.transaction_action_id IN (inv_globals.g_type_cycle_count_adj,

2047: print_debug( '4: '||p_mmtt_rec.locator_id || ':');
2048: print_debug( '5: '||p_mmtt_rec.revision || ':');
2049: END IF;
2050:
2051: IF p_mmtt_rec.transaction_action_id IN (inv_globals.g_type_cycle_count_adj,
2052: inv_globals.g_type_physical_count_adj,
2053: inv_globals.g_action_deliveryadj)
2054: THEN
2055: IF p_mmtt_rec.transaction_action_id = inv_globals.g_type_physical_count_adj THEN

Line 2052: inv_globals.g_type_physical_count_adj,

2048: print_debug( '5: '||p_mmtt_rec.revision || ':');
2049: END IF;
2050:
2051: IF p_mmtt_rec.transaction_action_id IN (inv_globals.g_type_cycle_count_adj,
2052: inv_globals.g_type_physical_count_adj,
2053: inv_globals.g_action_deliveryadj)
2054: THEN
2055: IF p_mmtt_rec.transaction_action_id = inv_globals.g_type_physical_count_adj THEN
2056: IF p_mmtt_rec.lpn_id IS NOT NULL THEN

Line 2053: inv_globals.g_action_deliveryadj)

2049: END IF;
2050:
2051: IF p_mmtt_rec.transaction_action_id IN (inv_globals.g_type_cycle_count_adj,
2052: inv_globals.g_type_physical_count_adj,
2053: inv_globals.g_action_deliveryadj)
2054: THEN
2055: IF p_mmtt_rec.transaction_action_id = inv_globals.g_type_physical_count_adj THEN
2056: IF p_mmtt_rec.lpn_id IS NOT NULL THEN
2057: l_lpn_id := p_mmtt_rec.lpn_id;

Line 2055: IF p_mmtt_rec.transaction_action_id = inv_globals.g_type_physical_count_adj THEN

2051: IF p_mmtt_rec.transaction_action_id IN (inv_globals.g_type_cycle_count_adj,
2052: inv_globals.g_type_physical_count_adj,
2053: inv_globals.g_action_deliveryadj)
2054: THEN
2055: IF p_mmtt_rec.transaction_action_id = inv_globals.g_type_physical_count_adj THEN
2056: IF p_mmtt_rec.lpn_id IS NOT NULL THEN
2057: l_lpn_id := p_mmtt_rec.lpn_id;
2058: ELSIF p_mmtt_rec.content_lpn_id IS NOT NULL THEN
2059: l_lpn_id := p_mmtt_rec.content_lpn_id;

Line 2063: ELSIF p_mmtt_rec.transaction_action_id = inv_globals.g_action_deliveryadj THEN

2059: l_lpn_id := p_mmtt_rec.content_lpn_id;
2060: ELSIF p_mmtt_rec.transfer_lpn_id IS NOT NULL THEN
2061: l_lpn_id := p_mmtt_rec.transfer_lpn_id;
2062: END IF;
2063: ELSIF p_mmtt_rec.transaction_action_id = inv_globals.g_action_deliveryadj THEN
2064: l_lpn_id := p_mmtt_rec.transfer_lpn_id;
2065: ELSIF p_mmtt_rec.transaction_action_id = inv_globals.g_type_cycle_count_adj THEN
2066: l_lpn_id := p_mmtt_rec.transfer_lpn_id;
2067: END IF;

Line 2065: ELSIF p_mmtt_rec.transaction_action_id = inv_globals.g_type_cycle_count_adj THEN

2061: l_lpn_id := p_mmtt_rec.transfer_lpn_id;
2062: END IF;
2063: ELSIF p_mmtt_rec.transaction_action_id = inv_globals.g_action_deliveryadj THEN
2064: l_lpn_id := p_mmtt_rec.transfer_lpn_id;
2065: ELSIF p_mmtt_rec.transaction_action_id = inv_globals.g_type_cycle_count_adj THEN
2066: l_lpn_id := p_mmtt_rec.transfer_lpn_id;
2067: END IF;
2068:
2069: l_onhand_exists :=

Line 2108: ELSIF (p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_salesorder

2104: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2105: END IF;
2106:
2107: END IF;
2108: ELSIF (p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_salesorder
2109: OR p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_intorder)
2110: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_issue
2111: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_subxfr
2112: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_orgxfr

Line 2109: OR p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_intorder)

2105: END IF;
2106:
2107: END IF;
2108: ELSIF (p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_salesorder
2109: OR p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_intorder)
2110: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_issue
2111: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_subxfr
2112: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_orgxfr
2113: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_intransitshipment)

Line 2110: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_issue

2106:
2107: END IF;
2108: ELSIF (p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_salesorder
2109: OR p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_intorder)
2110: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_issue
2111: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_subxfr
2112: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_orgxfr
2113: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_intransitshipment)
2114: THEN -- For a ship confirm transaction, get the cost group from the content lpn ID

Line 2111: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_subxfr

2107: END IF;
2108: ELSIF (p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_salesorder
2109: OR p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_intorder)
2110: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_issue
2111: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_subxfr
2112: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_orgxfr
2113: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_intransitshipment)
2114: THEN -- For a ship confirm transaction, get the cost group from the content lpn ID
2115: l_lpn_id := p_mmtt_rec.content_lpn_id;

Line 2112: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_orgxfr

2108: ELSIF (p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_salesorder
2109: OR p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_intorder)
2110: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_issue
2111: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_subxfr
2112: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_orgxfr
2113: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_intransitshipment)
2114: THEN -- For a ship confirm transaction, get the cost group from the content lpn ID
2115: l_lpn_id := p_mmtt_rec.content_lpn_id;
2116: /* Bug 4628878: For staging transfers, when whole LPN is being transfered, cost group should

Line 2113: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_intransitshipment)

2109: OR p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_intorder)
2110: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_issue
2111: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_subxfr
2112: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_orgxfr
2113: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_intransitshipment)
2114: THEN -- For a ship confirm transaction, get the cost group from the content lpn ID
2115: l_lpn_id := p_mmtt_rec.content_lpn_id;
2116: /* Bug 4628878: For staging transfers, when whole LPN is being transfered, cost group should
2117: * be obtained from content_lpn_id */

Line 2120: IF (l_lpn_id IS NULL AND p_mmtt_rec.transaction_action_id = inv_globals.g_action_issue) THEN

2116: /* Bug 4628878: For staging transfers, when whole LPN is being transfered, cost group should
2117: * be obtained from content_lpn_id */
2118:
2119: /*8650417 Added the following IF to handle Bill only WF from OM*/
2120: IF (l_lpn_id IS NULL AND p_mmtt_rec.transaction_action_id = inv_globals.g_action_issue) THEN
2121: l_lpn_id := p_mmtt_rec.lpn_id;
2122: END IF;
2123:
2124: ELSIF (

Line 2125: ((p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_salesorder

2121: l_lpn_id := p_mmtt_rec.lpn_id;
2122: END IF;
2123:
2124: ELSIF (
2125: ((p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_salesorder
2126: OR p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_intorder)
2127: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_stgxfr))
2128: OR /*Bug 6499833:For move order sub transfers,trying to get the costgroup from content_lpn_id.*/
2129: (( p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_moveorder)

Line 2126: OR p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_intorder)

2122: END IF;
2123:
2124: ELSIF (
2125: ((p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_salesorder
2126: OR p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_intorder)
2127: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_stgxfr))
2128: OR /*Bug 6499833:For move order sub transfers,trying to get the costgroup from content_lpn_id.*/
2129: (( p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_moveorder)
2130: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_subxfr))

Line 2127: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_stgxfr))

2123:
2124: ELSIF (
2125: ((p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_salesorder
2126: OR p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_intorder)
2127: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_stgxfr))
2128: OR /*Bug 6499833:For move order sub transfers,trying to get the costgroup from content_lpn_id.*/
2129: (( p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_moveorder)
2130: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_subxfr))
2131: )

Line 2129: (( p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_moveorder)

2125: ((p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_salesorder
2126: OR p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_intorder)
2127: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_stgxfr))
2128: OR /*Bug 6499833:For move order sub transfers,trying to get the costgroup from content_lpn_id.*/
2129: (( p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_moveorder)
2130: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_subxfr))
2131: )
2132: -- AND (p_mmtt_rec.lpn_id IS NULL) Bug#6770593
2133: AND (p_mmtt_rec.content_lpn_id IS NOT NULL)

Line 2130: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_subxfr))

2126: OR p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_intorder)
2127: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_stgxfr))
2128: OR /*Bug 6499833:For move order sub transfers,trying to get the costgroup from content_lpn_id.*/
2129: (( p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_moveorder)
2130: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_subxfr))
2131: )
2132: -- AND (p_mmtt_rec.lpn_id IS NULL) Bug#6770593
2133: AND (p_mmtt_rec.content_lpn_id IS NOT NULL)
2134: AND (p_mmtt_rec.inventory_item_id <> -1)

Line 2297: IF p_mmtt_rec.transaction_action_id IN (inv_globals.g_type_cycle_count_adj,

2293:
2294: l_onhand_exists := TRUE;
2295:
2296: -- Adjustment transactions
2297: IF p_mmtt_rec.transaction_action_id IN (inv_globals.g_type_cycle_count_adj,
2298: inv_globals.g_type_physical_count_adj,
2299: inv_globals.g_action_deliveryadj)
2300: THEN
2301: IF p_mmtt_rec.transaction_action_id = inv_globals.g_type_physical_count_adj THEN

Line 2298: inv_globals.g_type_physical_count_adj,

2294: l_onhand_exists := TRUE;
2295:
2296: -- Adjustment transactions
2297: IF p_mmtt_rec.transaction_action_id IN (inv_globals.g_type_cycle_count_adj,
2298: inv_globals.g_type_physical_count_adj,
2299: inv_globals.g_action_deliveryadj)
2300: THEN
2301: IF p_mmtt_rec.transaction_action_id = inv_globals.g_type_physical_count_adj THEN
2302: IF p_mmtt_rec.lpn_id IS NOT NULL THEN

Line 2299: inv_globals.g_action_deliveryadj)

2295:
2296: -- Adjustment transactions
2297: IF p_mmtt_rec.transaction_action_id IN (inv_globals.g_type_cycle_count_adj,
2298: inv_globals.g_type_physical_count_adj,
2299: inv_globals.g_action_deliveryadj)
2300: THEN
2301: IF p_mmtt_rec.transaction_action_id = inv_globals.g_type_physical_count_adj THEN
2302: IF p_mmtt_rec.lpn_id IS NOT NULL THEN
2303: l_lpn_id := p_mmtt_rec.lpn_id;

Line 2301: IF p_mmtt_rec.transaction_action_id = inv_globals.g_type_physical_count_adj THEN

2297: IF p_mmtt_rec.transaction_action_id IN (inv_globals.g_type_cycle_count_adj,
2298: inv_globals.g_type_physical_count_adj,
2299: inv_globals.g_action_deliveryadj)
2300: THEN
2301: IF p_mmtt_rec.transaction_action_id = inv_globals.g_type_physical_count_adj THEN
2302: IF p_mmtt_rec.lpn_id IS NOT NULL THEN
2303: l_lpn_id := p_mmtt_rec.lpn_id;
2304: ELSIF p_mmtt_rec.content_lpn_id IS NOT NULL THEN
2305: l_lpn_id := p_mmtt_rec.content_lpn_id;

Line 2309: ELSIF p_mmtt_rec.transaction_action_id = inv_globals.g_action_deliveryadj THEN

2305: l_lpn_id := p_mmtt_rec.content_lpn_id;
2306: ELSIF p_mmtt_rec.transfer_lpn_id IS NOT NULL THEN
2307: l_lpn_id := p_mmtt_rec.transfer_lpn_id;
2308: END IF;
2309: ELSIF p_mmtt_rec.transaction_action_id = inv_globals.g_action_deliveryadj THEN
2310: l_lpn_id := p_mmtt_rec.transfer_lpn_id;
2311: ELSIF p_mmtt_rec.transaction_action_id = inv_globals.g_type_cycle_count_adj THEN
2312: l_lpn_id := p_mmtt_rec.transfer_lpn_id;
2313: END IF;

Line 2311: ELSIF p_mmtt_rec.transaction_action_id = inv_globals.g_type_cycle_count_adj THEN

2307: l_lpn_id := p_mmtt_rec.transfer_lpn_id;
2308: END IF;
2309: ELSIF p_mmtt_rec.transaction_action_id = inv_globals.g_action_deliveryadj THEN
2310: l_lpn_id := p_mmtt_rec.transfer_lpn_id;
2311: ELSIF p_mmtt_rec.transaction_action_id = inv_globals.g_type_cycle_count_adj THEN
2312: l_lpn_id := p_mmtt_rec.transfer_lpn_id;
2313: END IF;
2314:
2315: l_onhand_exists :=

Line 2354: ELSIF (p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_salesorder

2350: END IF;
2351: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2352: END IF;
2353: END IF;
2354: ELSIF (p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_salesorder
2355: OR p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_intorder)
2356: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_issue
2357: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_subxfr
2358: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_orgxfr

Line 2355: OR p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_intorder)

2351: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2352: END IF;
2353: END IF;
2354: ELSIF (p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_salesorder
2355: OR p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_intorder)
2356: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_issue
2357: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_subxfr
2358: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_orgxfr
2359: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_intransitshipment)

Line 2356: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_issue

2352: END IF;
2353: END IF;
2354: ELSIF (p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_salesorder
2355: OR p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_intorder)
2356: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_issue
2357: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_subxfr
2358: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_orgxfr
2359: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_intransitshipment)
2360: THEN -- For a ship confirm transaction, get the cost group from the content lpn ID

Line 2357: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_subxfr

2353: END IF;
2354: ELSIF (p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_salesorder
2355: OR p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_intorder)
2356: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_issue
2357: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_subxfr
2358: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_orgxfr
2359: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_intransitshipment)
2360: THEN -- For a ship confirm transaction, get the cost group from the content lpn ID
2361: l_lpn_id := p_mmtt_rec.content_lpn_id;

Line 2358: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_orgxfr

2354: ELSIF (p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_salesorder
2355: OR p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_intorder)
2356: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_issue
2357: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_subxfr
2358: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_orgxfr
2359: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_intransitshipment)
2360: THEN -- For a ship confirm transaction, get the cost group from the content lpn ID
2361: l_lpn_id := p_mmtt_rec.content_lpn_id;
2362: /* Bug 4628878: For staging transfers, when whole LPN is being transfered, cost group should

Line 2359: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_intransitshipment)

2355: OR p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_intorder)
2356: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_issue
2357: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_subxfr
2358: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_orgxfr
2359: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_intransitshipment)
2360: THEN -- For a ship confirm transaction, get the cost group from the content lpn ID
2361: l_lpn_id := p_mmtt_rec.content_lpn_id;
2362: /* Bug 4628878: For staging transfers, when whole LPN is being transfered, cost group should
2363: * be obtained from content_lpn_id */

Line 2366: IF (l_lpn_id IS NULL AND p_mmtt_rec.transaction_action_id = inv_globals.g_action_issue) THEN

2362: /* Bug 4628878: For staging transfers, when whole LPN is being transfered, cost group should
2363: * be obtained from content_lpn_id */
2364:
2365: /*8650417 Added the following IF to handle Bill only WF from OM*/
2366: IF (l_lpn_id IS NULL AND p_mmtt_rec.transaction_action_id = inv_globals.g_action_issue) THEN
2367: l_lpn_id := p_mmtt_rec.lpn_id;
2368: END IF;
2369:
2370: ELSIF (

Line 2371: ((p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_salesorder

2367: l_lpn_id := p_mmtt_rec.lpn_id;
2368: END IF;
2369:
2370: ELSIF (
2371: ((p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_salesorder
2372: OR p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_intorder)
2373: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_stgxfr))
2374: OR/*Bug 6499833:For move order sub transfers,trying to get the costgroup from content_lpn_id.*/
2375: (( p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_moveorder)

Line 2372: OR p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_intorder)

2368: END IF;
2369:
2370: ELSIF (
2371: ((p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_salesorder
2372: OR p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_intorder)
2373: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_stgxfr))
2374: OR/*Bug 6499833:For move order sub transfers,trying to get the costgroup from content_lpn_id.*/
2375: (( p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_moveorder)
2376: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_subxfr))

Line 2373: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_stgxfr))

2369:
2370: ELSIF (
2371: ((p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_salesorder
2372: OR p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_intorder)
2373: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_stgxfr))
2374: OR/*Bug 6499833:For move order sub transfers,trying to get the costgroup from content_lpn_id.*/
2375: (( p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_moveorder)
2376: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_subxfr))
2377: )

Line 2375: (( p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_moveorder)

2371: ((p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_salesorder
2372: OR p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_intorder)
2373: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_stgxfr))
2374: OR/*Bug 6499833:For move order sub transfers,trying to get the costgroup from content_lpn_id.*/
2375: (( p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_moveorder)
2376: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_subxfr))
2377: )
2378: -- AND (p_mmtt_rec.lpn_id IS NULL) Bug#6770593
2379: AND (p_mmtt_rec.content_lpn_id IS NOT NULL)

Line 2376: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_subxfr))

2372: OR p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_intorder)
2373: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_stgxfr))
2374: OR/*Bug 6499833:For move order sub transfers,trying to get the costgroup from content_lpn_id.*/
2375: (( p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_moveorder)
2376: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_subxfr))
2377: )
2378: -- AND (p_mmtt_rec.lpn_id IS NULL) Bug#6770593
2379: AND (p_mmtt_rec.content_lpn_id IS NOT NULL)
2380: AND (p_mmtt_rec.inventory_item_id <> -1)

Line 2775: IF p_mmtt_rec.transaction_action_id IN (inv_globals.g_type_cycle_count_adj,

2771: END IF;
2772: l_onhand_exists := TRUE;
2773:
2774: -- Adjustment transactions
2775: IF p_mmtt_rec.transaction_action_id IN (inv_globals.g_type_cycle_count_adj,
2776: inv_globals.g_type_physical_count_adj,
2777: inv_globals.g_action_deliveryadj)
2778: THEN
2779:

Line 2776: inv_globals.g_type_physical_count_adj,

2772: l_onhand_exists := TRUE;
2773:
2774: -- Adjustment transactions
2775: IF p_mmtt_rec.transaction_action_id IN (inv_globals.g_type_cycle_count_adj,
2776: inv_globals.g_type_physical_count_adj,
2777: inv_globals.g_action_deliveryadj)
2778: THEN
2779:
2780: IF p_mmtt_rec.transaction_action_id = inv_globals.g_type_physical_count_adj THEN

Line 2777: inv_globals.g_action_deliveryadj)

2773:
2774: -- Adjustment transactions
2775: IF p_mmtt_rec.transaction_action_id IN (inv_globals.g_type_cycle_count_adj,
2776: inv_globals.g_type_physical_count_adj,
2777: inv_globals.g_action_deliveryadj)
2778: THEN
2779:
2780: IF p_mmtt_rec.transaction_action_id = inv_globals.g_type_physical_count_adj THEN
2781: IF p_mmtt_rec.lpn_id IS NOT NULL THEN

Line 2780: IF p_mmtt_rec.transaction_action_id = inv_globals.g_type_physical_count_adj THEN

2776: inv_globals.g_type_physical_count_adj,
2777: inv_globals.g_action_deliveryadj)
2778: THEN
2779:
2780: IF p_mmtt_rec.transaction_action_id = inv_globals.g_type_physical_count_adj THEN
2781: IF p_mmtt_rec.lpn_id IS NOT NULL THEN
2782: l_lpn_id := p_mmtt_rec.lpn_id;
2783: ELSIF p_mmtt_rec.content_lpn_id IS NOT NULL THEN
2784: l_lpn_id := p_mmtt_rec.content_lpn_id;

Line 2788: ELSIF p_mmtt_rec.transaction_action_id = inv_globals.g_action_deliveryadj THEN

2784: l_lpn_id := p_mmtt_rec.content_lpn_id;
2785: ELSIF p_mmtt_rec.transfer_lpn_id IS NOT NULL THEN
2786: l_lpn_id := p_mmtt_rec.transfer_lpn_id;
2787: END IF;
2788: ELSIF p_mmtt_rec.transaction_action_id = inv_globals.g_action_deliveryadj THEN
2789: l_lpn_id := p_mmtt_rec.transfer_lpn_id;
2790: ELSIF p_mmtt_rec.transaction_action_id = inv_globals.g_type_cycle_count_adj THEN
2791: l_lpn_id := p_mmtt_rec.transfer_lpn_id;
2792: END IF;

Line 2790: ELSIF p_mmtt_rec.transaction_action_id = inv_globals.g_type_cycle_count_adj THEN

2786: l_lpn_id := p_mmtt_rec.transfer_lpn_id;
2787: END IF;
2788: ELSIF p_mmtt_rec.transaction_action_id = inv_globals.g_action_deliveryadj THEN
2789: l_lpn_id := p_mmtt_rec.transfer_lpn_id;
2790: ELSIF p_mmtt_rec.transaction_action_id = inv_globals.g_type_cycle_count_adj THEN
2791: l_lpn_id := p_mmtt_rec.transfer_lpn_id;
2792: END IF;
2793:
2794: l_onhand_exists :=

Line 2833: ELSIF (p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_salesorder

2829: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2830: END IF;
2831:
2832: END IF;
2833: ELSIF (p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_salesorder
2834: OR p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_intorder)
2835: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_issue
2836: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_subxfr
2837: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_orgxfr

Line 2834: OR p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_intorder)

2830: END IF;
2831:
2832: END IF;
2833: ELSIF (p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_salesorder
2834: OR p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_intorder)
2835: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_issue
2836: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_subxfr
2837: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_orgxfr
2838: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_intransitshipment)

Line 2835: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_issue

2831:
2832: END IF;
2833: ELSIF (p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_salesorder
2834: OR p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_intorder)
2835: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_issue
2836: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_subxfr
2837: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_orgxfr
2838: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_intransitshipment)
2839: THEN -- For a ship confirm transaction, get the cost group from the content lpn ID

Line 2836: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_subxfr

2832: END IF;
2833: ELSIF (p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_salesorder
2834: OR p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_intorder)
2835: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_issue
2836: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_subxfr
2837: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_orgxfr
2838: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_intransitshipment)
2839: THEN -- For a ship confirm transaction, get the cost group from the content lpn ID
2840: l_lpn_id := p_mmtt_rec.content_lpn_id;

Line 2837: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_orgxfr

2833: ELSIF (p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_salesorder
2834: OR p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_intorder)
2835: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_issue
2836: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_subxfr
2837: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_orgxfr
2838: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_intransitshipment)
2839: THEN -- For a ship confirm transaction, get the cost group from the content lpn ID
2840: l_lpn_id := p_mmtt_rec.content_lpn_id;
2841: /* Bug 4628878: For staging transfers, when whole LPN is being transfered, cost group should

Line 2838: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_intransitshipment)

2834: OR p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_intorder)
2835: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_issue
2836: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_subxfr
2837: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_orgxfr
2838: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_intransitshipment)
2839: THEN -- For a ship confirm transaction, get the cost group from the content lpn ID
2840: l_lpn_id := p_mmtt_rec.content_lpn_id;
2841: /* Bug 4628878: For staging transfers, when whole LPN is being transfered, cost group should
2842: * be obtained from content_lpn_id */

Line 2844: ((p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_salesorder

2840: l_lpn_id := p_mmtt_rec.content_lpn_id;
2841: /* Bug 4628878: For staging transfers, when whole LPN is being transfered, cost group should
2842: * be obtained from content_lpn_id */
2843: ELSIF (
2844: ((p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_salesorder
2845: OR p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_intorder)
2846: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_stgxfr))
2847: OR/*Bug 6499833:For move order sub transfers,trying to get the costgroup from content_lpn_id.*/
2848: (( p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_moveorder)

Line 2845: OR p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_intorder)

2841: /* Bug 4628878: For staging transfers, when whole LPN is being transfered, cost group should
2842: * be obtained from content_lpn_id */
2843: ELSIF (
2844: ((p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_salesorder
2845: OR p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_intorder)
2846: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_stgxfr))
2847: OR/*Bug 6499833:For move order sub transfers,trying to get the costgroup from content_lpn_id.*/
2848: (( p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_moveorder)
2849: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_subxfr))

Line 2846: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_stgxfr))

2842: * be obtained from content_lpn_id */
2843: ELSIF (
2844: ((p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_salesorder
2845: OR p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_intorder)
2846: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_stgxfr))
2847: OR/*Bug 6499833:For move order sub transfers,trying to get the costgroup from content_lpn_id.*/
2848: (( p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_moveorder)
2849: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_subxfr))
2850: )

Line 2848: (( p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_moveorder)

2844: ((p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_salesorder
2845: OR p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_intorder)
2846: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_stgxfr))
2847: OR/*Bug 6499833:For move order sub transfers,trying to get the costgroup from content_lpn_id.*/
2848: (( p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_moveorder)
2849: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_subxfr))
2850: )
2851: -- AND (p_mmtt_rec.lpn_id IS NULL) Bug#6770593
2852: AND (p_mmtt_rec.content_lpn_id IS NOT NULL)

Line 2849: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_subxfr))

2845: OR p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_intorder)
2846: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_stgxfr))
2847: OR/*Bug 6499833:For move order sub transfers,trying to get the costgroup from content_lpn_id.*/
2848: (( p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_moveorder)
2849: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_subxfr))
2850: )
2851: -- AND (p_mmtt_rec.lpn_id IS NULL) Bug#6770593
2852: AND (p_mmtt_rec.content_lpn_id IS NOT NULL)
2853: AND (p_mmtt_rec.inventory_item_id <> -1)

Line 3329: IF p_mmtt_rec.transaction_action_id IN (inv_globals.g_type_cycle_count_adj,

3325: END IF;
3326: l_onhand_exists := TRUE;
3327:
3328: -- Adjustment transactions
3329: IF p_mmtt_rec.transaction_action_id IN (inv_globals.g_type_cycle_count_adj,
3330: inv_globals.g_type_physical_count_adj,
3331: inv_globals.g_action_deliveryadj)
3332: THEN
3333: IF p_mmtt_rec.transaction_action_id = inv_globals.g_type_physical_count_adj THEN

Line 3330: inv_globals.g_type_physical_count_adj,

3326: l_onhand_exists := TRUE;
3327:
3328: -- Adjustment transactions
3329: IF p_mmtt_rec.transaction_action_id IN (inv_globals.g_type_cycle_count_adj,
3330: inv_globals.g_type_physical_count_adj,
3331: inv_globals.g_action_deliveryadj)
3332: THEN
3333: IF p_mmtt_rec.transaction_action_id = inv_globals.g_type_physical_count_adj THEN
3334: IF p_mmtt_rec.lpn_id IS NOT NULL THEN

Line 3331: inv_globals.g_action_deliveryadj)

3327:
3328: -- Adjustment transactions
3329: IF p_mmtt_rec.transaction_action_id IN (inv_globals.g_type_cycle_count_adj,
3330: inv_globals.g_type_physical_count_adj,
3331: inv_globals.g_action_deliveryadj)
3332: THEN
3333: IF p_mmtt_rec.transaction_action_id = inv_globals.g_type_physical_count_adj THEN
3334: IF p_mmtt_rec.lpn_id IS NOT NULL THEN
3335: l_lpn_id := p_mmtt_rec.lpn_id;

Line 3333: IF p_mmtt_rec.transaction_action_id = inv_globals.g_type_physical_count_adj THEN

3329: IF p_mmtt_rec.transaction_action_id IN (inv_globals.g_type_cycle_count_adj,
3330: inv_globals.g_type_physical_count_adj,
3331: inv_globals.g_action_deliveryadj)
3332: THEN
3333: IF p_mmtt_rec.transaction_action_id = inv_globals.g_type_physical_count_adj THEN
3334: IF p_mmtt_rec.lpn_id IS NOT NULL THEN
3335: l_lpn_id := p_mmtt_rec.lpn_id;
3336: ELSIF p_mmtt_rec.content_lpn_id IS NOT NULL THEN
3337: l_lpn_id := p_mmtt_rec.content_lpn_id;

Line 3341: ELSIF p_mmtt_rec.transaction_action_id = inv_globals.g_action_deliveryadj THEN

3337: l_lpn_id := p_mmtt_rec.content_lpn_id;
3338: ELSIF p_mmtt_rec.transfer_lpn_id IS NOT NULL THEN
3339: l_lpn_id := p_mmtt_rec.transfer_lpn_id;
3340: END IF;
3341: ELSIF p_mmtt_rec.transaction_action_id = inv_globals.g_action_deliveryadj THEN
3342: l_lpn_id := p_mmtt_rec.transfer_lpn_id;
3343: ELSIF p_mmtt_rec.transaction_action_id = inv_globals.g_type_cycle_count_adj THEN
3344: l_lpn_id := p_mmtt_rec.transfer_lpn_id;
3345: END IF;

Line 3343: ELSIF p_mmtt_rec.transaction_action_id = inv_globals.g_type_cycle_count_adj THEN

3339: l_lpn_id := p_mmtt_rec.transfer_lpn_id;
3340: END IF;
3341: ELSIF p_mmtt_rec.transaction_action_id = inv_globals.g_action_deliveryadj THEN
3342: l_lpn_id := p_mmtt_rec.transfer_lpn_id;
3343: ELSIF p_mmtt_rec.transaction_action_id = inv_globals.g_type_cycle_count_adj THEN
3344: l_lpn_id := p_mmtt_rec.transfer_lpn_id;
3345: END IF;
3346:
3347: l_onhand_exists :=

Line 3386: ELSIF (p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_salesorder

3382: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3383: END IF;
3384:
3385: END IF;
3386: ELSIF (p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_salesorder
3387: OR p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_intorder)
3388: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_issue
3389: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_subxfr
3390: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_orgxfr

Line 3387: OR p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_intorder)

3383: END IF;
3384:
3385: END IF;
3386: ELSIF (p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_salesorder
3387: OR p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_intorder)
3388: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_issue
3389: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_subxfr
3390: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_orgxfr
3391: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_intransitshipment)

Line 3388: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_issue

3384:
3385: END IF;
3386: ELSIF (p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_salesorder
3387: OR p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_intorder)
3388: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_issue
3389: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_subxfr
3390: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_orgxfr
3391: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_intransitshipment)
3392: THEN -- For a ship confirm transaction, get the cost group from the content lpn ID

Line 3389: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_subxfr

3385: END IF;
3386: ELSIF (p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_salesorder
3387: OR p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_intorder)
3388: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_issue
3389: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_subxfr
3390: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_orgxfr
3391: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_intransitshipment)
3392: THEN -- For a ship confirm transaction, get the cost group from the content lpn ID
3393: l_lpn_id := p_mmtt_rec.content_lpn_id;

Line 3390: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_orgxfr

3386: ELSIF (p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_salesorder
3387: OR p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_intorder)
3388: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_issue
3389: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_subxfr
3390: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_orgxfr
3391: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_intransitshipment)
3392: THEN -- For a ship confirm transaction, get the cost group from the content lpn ID
3393: l_lpn_id := p_mmtt_rec.content_lpn_id;
3394:

Line 3391: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_intransitshipment)

3387: OR p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_intorder)
3388: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_issue
3389: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_subxfr
3390: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_orgxfr
3391: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_intransitshipment)
3392: THEN -- For a ship confirm transaction, get the cost group from the content lpn ID
3393: l_lpn_id := p_mmtt_rec.content_lpn_id;
3394:
3395: --Bug 2631651 fix. For sales order issue transactions,if the serial control is set at

Line 3424: ((p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_salesorder

3420: --Bug 2631651 fix
3421: /* Bug 4628878: For staging transfers, when whole LPN is being transfered, cost group should
3422: * be obtained from content_lpn_id */
3423: ELSIF (
3424: ((p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_salesorder
3425: OR p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_intorder)
3426: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_stgxfr))
3427: OR/*Bug 6499833:For move order sub transfers,trying to get the costgroup from content_lpn_id.*/
3428: (( p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_moveorder)

Line 3425: OR p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_intorder)

3421: /* Bug 4628878: For staging transfers, when whole LPN is being transfered, cost group should
3422: * be obtained from content_lpn_id */
3423: ELSIF (
3424: ((p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_salesorder
3425: OR p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_intorder)
3426: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_stgxfr))
3427: OR/*Bug 6499833:For move order sub transfers,trying to get the costgroup from content_lpn_id.*/
3428: (( p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_moveorder)
3429: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_subxfr))

Line 3426: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_stgxfr))

3422: * be obtained from content_lpn_id */
3423: ELSIF (
3424: ((p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_salesorder
3425: OR p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_intorder)
3426: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_stgxfr))
3427: OR/*Bug 6499833:For move order sub transfers,trying to get the costgroup from content_lpn_id.*/
3428: (( p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_moveorder)
3429: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_subxfr))
3430: )

Line 3428: (( p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_moveorder)

3424: ((p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_salesorder
3425: OR p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_intorder)
3426: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_stgxfr))
3427: OR/*Bug 6499833:For move order sub transfers,trying to get the costgroup from content_lpn_id.*/
3428: (( p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_moveorder)
3429: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_subxfr))
3430: )
3431: -- AND (p_mmtt_rec.lpn_id IS NULL) Bug#6770593
3432: AND (p_mmtt_rec.content_lpn_id IS NOT NULL)

Line 3429: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_subxfr))

3425: OR p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_intorder)
3426: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_stgxfr))
3427: OR/*Bug 6499833:For move order sub transfers,trying to get the costgroup from content_lpn_id.*/
3428: (( p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_moveorder)
3429: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_subxfr))
3430: )
3431: -- AND (p_mmtt_rec.lpn_id IS NULL) Bug#6770593
3432: AND (p_mmtt_rec.content_lpn_id IS NOT NULL)
3433: AND (p_mmtt_rec.inventory_item_id <> -1)

Line 3930: ((l_mmtt_rec.transaction_action_id = inv_globals.g_action_orgxfr) OR

3926: l_cost_group_id := l_mmtt_rec.cost_group_id;
3927: l_transfer_cost_group_id := l_mmtt_rec.transfer_cost_group_id;
3928:
3929: IF l_transfer_cost_group_id IS NULL AND p_transfer_wms_org AND
3930: ((l_mmtt_rec.transaction_action_id = inv_globals.g_action_orgxfr) OR
3931: (l_mmtt_rec.transaction_action_id = inv_globals.g_action_intransitshipment
3932: AND p_fob_point = 1)
3933: OR (l_mmtt_rec.transaction_action_id = inv_globals.g_action_intransitreceipt)
3934: )

Line 3931: (l_mmtt_rec.transaction_action_id = inv_globals.g_action_intransitshipment

3927: l_transfer_cost_group_id := l_mmtt_rec.transfer_cost_group_id;
3928:
3929: IF l_transfer_cost_group_id IS NULL AND p_transfer_wms_org AND
3930: ((l_mmtt_rec.transaction_action_id = inv_globals.g_action_orgxfr) OR
3931: (l_mmtt_rec.transaction_action_id = inv_globals.g_action_intransitshipment
3932: AND p_fob_point = 1)
3933: OR (l_mmtt_rec.transaction_action_id = inv_globals.g_action_intransitreceipt)
3934: )
3935: THEN

Line 3933: OR (l_mmtt_rec.transaction_action_id = inv_globals.g_action_intransitreceipt)

3929: IF l_transfer_cost_group_id IS NULL AND p_transfer_wms_org AND
3930: ((l_mmtt_rec.transaction_action_id = inv_globals.g_action_orgxfr) OR
3931: (l_mmtt_rec.transaction_action_id = inv_globals.g_action_intransitshipment
3932: AND p_fob_point = 1)
3933: OR (l_mmtt_rec.transaction_action_id = inv_globals.g_action_intransitreceipt)
3934: )
3935: THEN
3936: IF (l_debug = 1) THEN
3937: print_debug('Getting transfer cost group id from rules engine...: ');

Line 3986: IF inv_globals.is_issue_xfr_transaction(l_mmtt_rec.transaction_action_id) THEN

3982: ELSE
3983: RETURN;
3984: END IF;
3985:
3986: IF inv_globals.is_issue_xfr_transaction(l_mmtt_rec.transaction_action_id) THEN
3987: IF l_mmtt_rec.transfer_cost_group_id IS NOT NULL
3988: AND l_mmtt_rec.cost_group_id IS NOT NULL THEN
3989: RETURN;
3990: ELSIF l_mmtt_rec.cost_group_id IS NOT NULL AND

Line 4090: IF l_mmtt_rec.transaction_action_id IN (inv_globals.g_type_cycle_count_adj,

4086: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4087: END;
4088: END IF;
4089:
4090: IF l_mmtt_rec.transaction_action_id IN (inv_globals.g_type_cycle_count_adj,
4091: inv_globals.g_type_physical_count_adj,
4092: inv_globals.g_action_deliveryadj)
4093: THEN
4094: IF l_mmtt_rec.transaction_action_id IN (inv_globals.g_type_physical_count_adj,

Line 4091: inv_globals.g_type_physical_count_adj,

4087: END;
4088: END IF;
4089:
4090: IF l_mmtt_rec.transaction_action_id IN (inv_globals.g_type_cycle_count_adj,
4091: inv_globals.g_type_physical_count_adj,
4092: inv_globals.g_action_deliveryadj)
4093: THEN
4094: IF l_mmtt_rec.transaction_action_id IN (inv_globals.g_type_physical_count_adj,
4095: inv_globals.g_action_deliveryadj) THEN

Line 4092: inv_globals.g_action_deliveryadj)

4088: END IF;
4089:
4090: IF l_mmtt_rec.transaction_action_id IN (inv_globals.g_type_cycle_count_adj,
4091: inv_globals.g_type_physical_count_adj,
4092: inv_globals.g_action_deliveryadj)
4093: THEN
4094: IF l_mmtt_rec.transaction_action_id IN (inv_globals.g_type_physical_count_adj,
4095: inv_globals.g_action_deliveryadj) THEN
4096: IF l_mmtt_rec.lpn_id IS NOT NULL THEN

Line 4094: IF l_mmtt_rec.transaction_action_id IN (inv_globals.g_type_physical_count_adj,

4090: IF l_mmtt_rec.transaction_action_id IN (inv_globals.g_type_cycle_count_adj,
4091: inv_globals.g_type_physical_count_adj,
4092: inv_globals.g_action_deliveryadj)
4093: THEN
4094: IF l_mmtt_rec.transaction_action_id IN (inv_globals.g_type_physical_count_adj,
4095: inv_globals.g_action_deliveryadj) THEN
4096: IF l_mmtt_rec.lpn_id IS NOT NULL THEN
4097: l_lpn_id := l_mmtt_rec.lpn_id;
4098: ELSIF l_mmtt_rec.content_lpn_id IS NOT NULL THEN

Line 4095: inv_globals.g_action_deliveryadj) THEN

4091: inv_globals.g_type_physical_count_adj,
4092: inv_globals.g_action_deliveryadj)
4093: THEN
4094: IF l_mmtt_rec.transaction_action_id IN (inv_globals.g_type_physical_count_adj,
4095: inv_globals.g_action_deliveryadj) THEN
4096: IF l_mmtt_rec.lpn_id IS NOT NULL THEN
4097: l_lpn_id := l_mmtt_rec.lpn_id;
4098: ELSIF l_mmtt_rec.content_lpn_id IS NOT NULL THEN
4099: l_lpn_id := l_mmtt_rec.content_lpn_id;

Line 4103: ELSIF l_mmtt_rec.transaction_action_id = inv_globals.g_type_cycle_count_adj

4099: l_lpn_id := l_mmtt_rec.content_lpn_id;
4100: ELSIF l_mmtt_rec.transfer_lpn_id IS NOT NULL THEN
4101: l_lpn_id := l_mmtt_rec.transfer_lpn_id;
4102: END IF;
4103: ELSIF l_mmtt_rec.transaction_action_id = inv_globals.g_type_cycle_count_adj
4104: THEN
4105: l_lpn_id := l_mmtt_rec.transfer_lpn_id;
4106: END IF;
4107: