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 2119: ((p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_salesorder

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 */
2118: ELSIF (
2119: ((p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_salesorder
2120: OR p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_intorder)
2121: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_stgxfr))
2122: OR /*Bug 6499833:For move order sub transfers,trying to get the costgroup from content_lpn_id.*/
2123: (( p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_moveorder)

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

2116: /* Bug 4628878: For staging transfers, when whole LPN is being transfered, cost group should
2117: * be obtained from content_lpn_id */
2118: ELSIF (
2119: ((p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_salesorder
2120: OR p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_intorder)
2121: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_stgxfr))
2122: OR /*Bug 6499833:For move order sub transfers,trying to get the costgroup from content_lpn_id.*/
2123: (( p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_moveorder)
2124: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_subxfr))

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

2117: * be obtained from content_lpn_id */
2118: ELSIF (
2119: ((p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_salesorder
2120: OR p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_intorder)
2121: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_stgxfr))
2122: OR /*Bug 6499833:For move order sub transfers,trying to get the costgroup from content_lpn_id.*/
2123: (( p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_moveorder)
2124: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_subxfr))
2125: )

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

2119: ((p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_salesorder
2120: OR p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_intorder)
2121: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_stgxfr))
2122: OR /*Bug 6499833:For move order sub transfers,trying to get the costgroup from content_lpn_id.*/
2123: (( p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_moveorder)
2124: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_subxfr))
2125: )
2126: -- AND (p_mmtt_rec.lpn_id IS NULL) Bug#6770593
2127: AND (p_mmtt_rec.content_lpn_id IS NOT NULL)

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

2120: OR p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_intorder)
2121: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_stgxfr))
2122: OR /*Bug 6499833:For move order sub transfers,trying to get the costgroup from content_lpn_id.*/
2123: (( p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_moveorder)
2124: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_subxfr))
2125: )
2126: -- AND (p_mmtt_rec.lpn_id IS NULL) Bug#6770593
2127: AND (p_mmtt_rec.content_lpn_id IS NOT NULL)
2128: AND (p_mmtt_rec.inventory_item_id <> -1)

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

2287:
2288: l_onhand_exists := TRUE;
2289:
2290: -- Adjustment transactions
2291: IF p_mmtt_rec.transaction_action_id IN (inv_globals.g_type_cycle_count_adj,
2292: inv_globals.g_type_physical_count_adj,
2293: inv_globals.g_action_deliveryadj)
2294: THEN
2295: IF p_mmtt_rec.transaction_action_id = inv_globals.g_type_physical_count_adj THEN

Line 2292: inv_globals.g_type_physical_count_adj,

2288: l_onhand_exists := TRUE;
2289:
2290: -- Adjustment transactions
2291: IF p_mmtt_rec.transaction_action_id IN (inv_globals.g_type_cycle_count_adj,
2292: inv_globals.g_type_physical_count_adj,
2293: inv_globals.g_action_deliveryadj)
2294: THEN
2295: IF p_mmtt_rec.transaction_action_id = inv_globals.g_type_physical_count_adj THEN
2296: IF p_mmtt_rec.lpn_id IS NOT NULL THEN

Line 2293: inv_globals.g_action_deliveryadj)

2289:
2290: -- Adjustment transactions
2291: IF p_mmtt_rec.transaction_action_id IN (inv_globals.g_type_cycle_count_adj,
2292: inv_globals.g_type_physical_count_adj,
2293: inv_globals.g_action_deliveryadj)
2294: THEN
2295: IF p_mmtt_rec.transaction_action_id = inv_globals.g_type_physical_count_adj THEN
2296: IF p_mmtt_rec.lpn_id IS NOT NULL THEN
2297: l_lpn_id := p_mmtt_rec.lpn_id;

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

2291: IF p_mmtt_rec.transaction_action_id IN (inv_globals.g_type_cycle_count_adj,
2292: inv_globals.g_type_physical_count_adj,
2293: inv_globals.g_action_deliveryadj)
2294: THEN
2295: IF p_mmtt_rec.transaction_action_id = inv_globals.g_type_physical_count_adj THEN
2296: IF p_mmtt_rec.lpn_id IS NOT NULL THEN
2297: l_lpn_id := p_mmtt_rec.lpn_id;
2298: ELSIF p_mmtt_rec.content_lpn_id IS NOT NULL THEN
2299: l_lpn_id := p_mmtt_rec.content_lpn_id;

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

2299: l_lpn_id := p_mmtt_rec.content_lpn_id;
2300: ELSIF p_mmtt_rec.transfer_lpn_id IS NOT NULL THEN
2301: l_lpn_id := p_mmtt_rec.transfer_lpn_id;
2302: END IF;
2303: ELSIF p_mmtt_rec.transaction_action_id = inv_globals.g_action_deliveryadj THEN
2304: l_lpn_id := p_mmtt_rec.transfer_lpn_id;
2305: ELSIF p_mmtt_rec.transaction_action_id = inv_globals.g_type_cycle_count_adj THEN
2306: l_lpn_id := p_mmtt_rec.transfer_lpn_id;
2307: END IF;

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

2301: l_lpn_id := p_mmtt_rec.transfer_lpn_id;
2302: END IF;
2303: ELSIF p_mmtt_rec.transaction_action_id = inv_globals.g_action_deliveryadj THEN
2304: l_lpn_id := p_mmtt_rec.transfer_lpn_id;
2305: ELSIF p_mmtt_rec.transaction_action_id = inv_globals.g_type_cycle_count_adj THEN
2306: l_lpn_id := p_mmtt_rec.transfer_lpn_id;
2307: END IF;
2308:
2309: l_onhand_exists :=

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

2344: END IF;
2345: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2346: END IF;
2347: END IF;
2348: ELSIF (p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_salesorder
2349: OR p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_intorder)
2350: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_issue
2351: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_subxfr
2352: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_orgxfr

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

2345: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2346: END IF;
2347: END IF;
2348: ELSIF (p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_salesorder
2349: OR p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_intorder)
2350: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_issue
2351: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_subxfr
2352: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_orgxfr
2353: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_intransitshipment)

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

2346: END IF;
2347: END IF;
2348: ELSIF (p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_salesorder
2349: OR p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_intorder)
2350: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_issue
2351: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_subxfr
2352: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_orgxfr
2353: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_intransitshipment)
2354: THEN -- For a ship confirm transaction, get the cost group from the content lpn ID

Line 2351: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_subxfr

2347: END IF;
2348: ELSIF (p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_salesorder
2349: OR p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_intorder)
2350: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_issue
2351: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_subxfr
2352: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_orgxfr
2353: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_intransitshipment)
2354: THEN -- For a ship confirm transaction, get the cost group from the content lpn ID
2355: l_lpn_id := p_mmtt_rec.content_lpn_id;

Line 2352: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_orgxfr

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

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

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

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

2355: l_lpn_id := p_mmtt_rec.content_lpn_id;
2356: /* Bug 4628878: For staging transfers, when whole LPN is being transfered, cost group should
2357: * be obtained from content_lpn_id */
2358: ELSIF (
2359: ((p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_salesorder
2360: OR p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_intorder)
2361: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_stgxfr))
2362: OR/*Bug 6499833:For move order sub transfers,trying to get the costgroup from content_lpn_id.*/
2363: (( p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_moveorder)

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

2356: /* Bug 4628878: For staging transfers, when whole LPN is being transfered, cost group should
2357: * be obtained from content_lpn_id */
2358: ELSIF (
2359: ((p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_salesorder
2360: OR p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_intorder)
2361: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_stgxfr))
2362: OR/*Bug 6499833:For move order sub transfers,trying to get the costgroup from content_lpn_id.*/
2363: (( p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_moveorder)
2364: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_subxfr))

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

2357: * be obtained from content_lpn_id */
2358: ELSIF (
2359: ((p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_salesorder
2360: OR p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_intorder)
2361: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_stgxfr))
2362: OR/*Bug 6499833:For move order sub transfers,trying to get the costgroup from content_lpn_id.*/
2363: (( p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_moveorder)
2364: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_subxfr))
2365: )

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

2359: ((p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_salesorder
2360: OR p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_intorder)
2361: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_stgxfr))
2362: OR/*Bug 6499833:For move order sub transfers,trying to get the costgroup from content_lpn_id.*/
2363: (( p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_moveorder)
2364: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_subxfr))
2365: )
2366: -- AND (p_mmtt_rec.lpn_id IS NULL) Bug#6770593
2367: AND (p_mmtt_rec.content_lpn_id IS NOT NULL)

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

2360: OR p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_intorder)
2361: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_stgxfr))
2362: OR/*Bug 6499833:For move order sub transfers,trying to get the costgroup from content_lpn_id.*/
2363: (( p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_moveorder)
2364: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_subxfr))
2365: )
2366: -- AND (p_mmtt_rec.lpn_id IS NULL) Bug#6770593
2367: AND (p_mmtt_rec.content_lpn_id IS NOT NULL)
2368: AND (p_mmtt_rec.inventory_item_id <> -1)

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

2759: END IF;
2760: l_onhand_exists := TRUE;
2761:
2762: -- Adjustment transactions
2763: IF p_mmtt_rec.transaction_action_id IN (inv_globals.g_type_cycle_count_adj,
2764: inv_globals.g_type_physical_count_adj,
2765: inv_globals.g_action_deliveryadj)
2766: THEN
2767:

Line 2764: inv_globals.g_type_physical_count_adj,

2760: l_onhand_exists := TRUE;
2761:
2762: -- Adjustment transactions
2763: IF p_mmtt_rec.transaction_action_id IN (inv_globals.g_type_cycle_count_adj,
2764: inv_globals.g_type_physical_count_adj,
2765: inv_globals.g_action_deliveryadj)
2766: THEN
2767:
2768: IF p_mmtt_rec.transaction_action_id = inv_globals.g_type_physical_count_adj THEN

Line 2765: inv_globals.g_action_deliveryadj)

2761:
2762: -- Adjustment transactions
2763: IF p_mmtt_rec.transaction_action_id IN (inv_globals.g_type_cycle_count_adj,
2764: inv_globals.g_type_physical_count_adj,
2765: inv_globals.g_action_deliveryadj)
2766: THEN
2767:
2768: IF p_mmtt_rec.transaction_action_id = inv_globals.g_type_physical_count_adj THEN
2769: IF p_mmtt_rec.lpn_id IS NOT NULL THEN

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

2764: inv_globals.g_type_physical_count_adj,
2765: inv_globals.g_action_deliveryadj)
2766: THEN
2767:
2768: IF p_mmtt_rec.transaction_action_id = inv_globals.g_type_physical_count_adj THEN
2769: IF p_mmtt_rec.lpn_id IS NOT NULL THEN
2770: l_lpn_id := p_mmtt_rec.lpn_id;
2771: ELSIF p_mmtt_rec.content_lpn_id IS NOT NULL THEN
2772: l_lpn_id := p_mmtt_rec.content_lpn_id;

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

2772: l_lpn_id := p_mmtt_rec.content_lpn_id;
2773: ELSIF p_mmtt_rec.transfer_lpn_id IS NOT NULL THEN
2774: l_lpn_id := p_mmtt_rec.transfer_lpn_id;
2775: END IF;
2776: ELSIF p_mmtt_rec.transaction_action_id = inv_globals.g_action_deliveryadj THEN
2777: l_lpn_id := p_mmtt_rec.transfer_lpn_id;
2778: ELSIF p_mmtt_rec.transaction_action_id = inv_globals.g_type_cycle_count_adj THEN
2779: l_lpn_id := p_mmtt_rec.transfer_lpn_id;
2780: END IF;

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

2774: l_lpn_id := p_mmtt_rec.transfer_lpn_id;
2775: END IF;
2776: ELSIF p_mmtt_rec.transaction_action_id = inv_globals.g_action_deliveryadj THEN
2777: l_lpn_id := p_mmtt_rec.transfer_lpn_id;
2778: ELSIF p_mmtt_rec.transaction_action_id = inv_globals.g_type_cycle_count_adj THEN
2779: l_lpn_id := p_mmtt_rec.transfer_lpn_id;
2780: END IF;
2781:
2782: l_onhand_exists :=

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

2817: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2818: END IF;
2819:
2820: END IF;
2821: ELSIF (p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_salesorder
2822: OR p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_intorder)
2823: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_issue
2824: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_subxfr
2825: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_orgxfr

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

2818: END IF;
2819:
2820: END IF;
2821: ELSIF (p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_salesorder
2822: OR p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_intorder)
2823: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_issue
2824: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_subxfr
2825: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_orgxfr
2826: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_intransitshipment)

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

2819:
2820: END IF;
2821: ELSIF (p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_salesorder
2822: OR p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_intorder)
2823: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_issue
2824: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_subxfr
2825: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_orgxfr
2826: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_intransitshipment)
2827: THEN -- For a ship confirm transaction, get the cost group from the content lpn ID

Line 2824: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_subxfr

2820: END IF;
2821: ELSIF (p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_salesorder
2822: OR p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_intorder)
2823: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_issue
2824: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_subxfr
2825: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_orgxfr
2826: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_intransitshipment)
2827: THEN -- For a ship confirm transaction, get the cost group from the content lpn ID
2828: l_lpn_id := p_mmtt_rec.content_lpn_id;

Line 2825: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_orgxfr

2821: ELSIF (p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_salesorder
2822: OR p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_intorder)
2823: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_issue
2824: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_subxfr
2825: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_orgxfr
2826: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_intransitshipment)
2827: THEN -- For a ship confirm transaction, get the cost group from the content lpn ID
2828: l_lpn_id := p_mmtt_rec.content_lpn_id;
2829: /* Bug 4628878: For staging transfers, when whole LPN is being transfered, cost group should

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

2822: OR p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_intorder)
2823: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_issue
2824: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_subxfr
2825: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_orgxfr
2826: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_intransitshipment)
2827: THEN -- For a ship confirm transaction, get the cost group from the content lpn ID
2828: l_lpn_id := p_mmtt_rec.content_lpn_id;
2829: /* Bug 4628878: For staging transfers, when whole LPN is being transfered, cost group should
2830: * be obtained from content_lpn_id */

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

2828: l_lpn_id := p_mmtt_rec.content_lpn_id;
2829: /* Bug 4628878: For staging transfers, when whole LPN is being transfered, cost group should
2830: * be obtained from content_lpn_id */
2831: ELSIF (
2832: ((p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_salesorder
2833: OR p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_intorder)
2834: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_stgxfr))
2835: OR/*Bug 6499833:For move order sub transfers,trying to get the costgroup from content_lpn_id.*/
2836: (( p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_moveorder)

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

2829: /* Bug 4628878: For staging transfers, when whole LPN is being transfered, cost group should
2830: * be obtained from content_lpn_id */
2831: ELSIF (
2832: ((p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_salesorder
2833: OR p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_intorder)
2834: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_stgxfr))
2835: OR/*Bug 6499833:For move order sub transfers,trying to get the costgroup from content_lpn_id.*/
2836: (( p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_moveorder)
2837: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_subxfr))

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

2830: * be obtained from content_lpn_id */
2831: ELSIF (
2832: ((p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_salesorder
2833: OR p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_intorder)
2834: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_stgxfr))
2835: OR/*Bug 6499833:For move order sub transfers,trying to get the costgroup from content_lpn_id.*/
2836: (( p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_moveorder)
2837: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_subxfr))
2838: )

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

2832: ((p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_salesorder
2833: OR p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_intorder)
2834: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_stgxfr))
2835: OR/*Bug 6499833:For move order sub transfers,trying to get the costgroup from content_lpn_id.*/
2836: (( p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_moveorder)
2837: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_subxfr))
2838: )
2839: -- AND (p_mmtt_rec.lpn_id IS NULL) Bug#6770593
2840: AND (p_mmtt_rec.content_lpn_id IS NOT NULL)

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

2833: OR p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_intorder)
2834: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_stgxfr))
2835: OR/*Bug 6499833:For move order sub transfers,trying to get the costgroup from content_lpn_id.*/
2836: (( p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_moveorder)
2837: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_subxfr))
2838: )
2839: -- AND (p_mmtt_rec.lpn_id IS NULL) Bug#6770593
2840: AND (p_mmtt_rec.content_lpn_id IS NOT NULL)
2841: AND (p_mmtt_rec.inventory_item_id <> -1)

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

3313: END IF;
3314: l_onhand_exists := TRUE;
3315:
3316: -- Adjustment transactions
3317: IF p_mmtt_rec.transaction_action_id IN (inv_globals.g_type_cycle_count_adj,
3318: inv_globals.g_type_physical_count_adj,
3319: inv_globals.g_action_deliveryadj)
3320: THEN
3321: IF p_mmtt_rec.transaction_action_id = inv_globals.g_type_physical_count_adj THEN

Line 3318: inv_globals.g_type_physical_count_adj,

3314: l_onhand_exists := TRUE;
3315:
3316: -- Adjustment transactions
3317: IF p_mmtt_rec.transaction_action_id IN (inv_globals.g_type_cycle_count_adj,
3318: inv_globals.g_type_physical_count_adj,
3319: inv_globals.g_action_deliveryadj)
3320: THEN
3321: IF p_mmtt_rec.transaction_action_id = inv_globals.g_type_physical_count_adj THEN
3322: IF p_mmtt_rec.lpn_id IS NOT NULL THEN

Line 3319: inv_globals.g_action_deliveryadj)

3315:
3316: -- Adjustment transactions
3317: IF p_mmtt_rec.transaction_action_id IN (inv_globals.g_type_cycle_count_adj,
3318: inv_globals.g_type_physical_count_adj,
3319: inv_globals.g_action_deliveryadj)
3320: THEN
3321: IF p_mmtt_rec.transaction_action_id = inv_globals.g_type_physical_count_adj THEN
3322: IF p_mmtt_rec.lpn_id IS NOT NULL THEN
3323: l_lpn_id := p_mmtt_rec.lpn_id;

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

3317: IF p_mmtt_rec.transaction_action_id IN (inv_globals.g_type_cycle_count_adj,
3318: inv_globals.g_type_physical_count_adj,
3319: inv_globals.g_action_deliveryadj)
3320: THEN
3321: IF p_mmtt_rec.transaction_action_id = inv_globals.g_type_physical_count_adj THEN
3322: IF p_mmtt_rec.lpn_id IS NOT NULL THEN
3323: l_lpn_id := p_mmtt_rec.lpn_id;
3324: ELSIF p_mmtt_rec.content_lpn_id IS NOT NULL THEN
3325: l_lpn_id := p_mmtt_rec.content_lpn_id;

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

3325: l_lpn_id := p_mmtt_rec.content_lpn_id;
3326: ELSIF p_mmtt_rec.transfer_lpn_id IS NOT NULL THEN
3327: l_lpn_id := p_mmtt_rec.transfer_lpn_id;
3328: END IF;
3329: ELSIF p_mmtt_rec.transaction_action_id = inv_globals.g_action_deliveryadj THEN
3330: l_lpn_id := p_mmtt_rec.transfer_lpn_id;
3331: ELSIF p_mmtt_rec.transaction_action_id = inv_globals.g_type_cycle_count_adj THEN
3332: l_lpn_id := p_mmtt_rec.transfer_lpn_id;
3333: END IF;

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

3327: l_lpn_id := p_mmtt_rec.transfer_lpn_id;
3328: END IF;
3329: ELSIF p_mmtt_rec.transaction_action_id = inv_globals.g_action_deliveryadj THEN
3330: l_lpn_id := p_mmtt_rec.transfer_lpn_id;
3331: ELSIF p_mmtt_rec.transaction_action_id = inv_globals.g_type_cycle_count_adj THEN
3332: l_lpn_id := p_mmtt_rec.transfer_lpn_id;
3333: END IF;
3334:
3335: l_onhand_exists :=

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

3370: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3371: END IF;
3372:
3373: END IF;
3374: ELSIF (p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_salesorder
3375: OR p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_intorder)
3376: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_issue
3377: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_subxfr
3378: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_orgxfr

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

3371: END IF;
3372:
3373: END IF;
3374: ELSIF (p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_salesorder
3375: OR p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_intorder)
3376: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_issue
3377: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_subxfr
3378: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_orgxfr
3379: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_intransitshipment)

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

3372:
3373: END IF;
3374: ELSIF (p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_salesorder
3375: OR p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_intorder)
3376: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_issue
3377: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_subxfr
3378: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_orgxfr
3379: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_intransitshipment)
3380: THEN -- For a ship confirm transaction, get the cost group from the content lpn ID

Line 3377: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_subxfr

3373: END IF;
3374: ELSIF (p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_salesorder
3375: OR p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_intorder)
3376: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_issue
3377: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_subxfr
3378: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_orgxfr
3379: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_intransitshipment)
3380: THEN -- For a ship confirm transaction, get the cost group from the content lpn ID
3381: l_lpn_id := p_mmtt_rec.content_lpn_id;

Line 3378: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_orgxfr

3374: ELSIF (p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_salesorder
3375: OR p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_intorder)
3376: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_issue
3377: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_subxfr
3378: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_orgxfr
3379: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_intransitshipment)
3380: THEN -- For a ship confirm transaction, get the cost group from the content lpn ID
3381: l_lpn_id := p_mmtt_rec.content_lpn_id;
3382:

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

3375: OR p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_intorder)
3376: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_issue
3377: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_subxfr
3378: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_orgxfr
3379: OR p_mmtt_rec.transaction_action_id = inv_globals.g_action_intransitshipment)
3380: THEN -- For a ship confirm transaction, get the cost group from the content lpn ID
3381: l_lpn_id := p_mmtt_rec.content_lpn_id;
3382:
3383: --Bug 2631651 fix. For sales order issue transactions,if the serial control is set at

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

3408: --Bug 2631651 fix
3409: /* Bug 4628878: For staging transfers, when whole LPN is being transfered, cost group should
3410: * be obtained from content_lpn_id */
3411: ELSIF (
3412: ((p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_salesorder
3413: OR p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_intorder)
3414: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_stgxfr))
3415: OR/*Bug 6499833:For move order sub transfers,trying to get the costgroup from content_lpn_id.*/
3416: (( p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_moveorder)

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

3409: /* Bug 4628878: For staging transfers, when whole LPN is being transfered, cost group should
3410: * be obtained from content_lpn_id */
3411: ELSIF (
3412: ((p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_salesorder
3413: OR p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_intorder)
3414: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_stgxfr))
3415: OR/*Bug 6499833:For move order sub transfers,trying to get the costgroup from content_lpn_id.*/
3416: (( p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_moveorder)
3417: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_subxfr))

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

3410: * be obtained from content_lpn_id */
3411: ELSIF (
3412: ((p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_salesorder
3413: OR p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_intorder)
3414: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_stgxfr))
3415: OR/*Bug 6499833:For move order sub transfers,trying to get the costgroup from content_lpn_id.*/
3416: (( p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_moveorder)
3417: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_subxfr))
3418: )

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

3412: ((p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_salesorder
3413: OR p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_intorder)
3414: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_stgxfr))
3415: OR/*Bug 6499833:For move order sub transfers,trying to get the costgroup from content_lpn_id.*/
3416: (( p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_moveorder)
3417: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_subxfr))
3418: )
3419: -- AND (p_mmtt_rec.lpn_id IS NULL) Bug#6770593
3420: AND (p_mmtt_rec.content_lpn_id IS NOT NULL)

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

3413: OR p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_intorder)
3414: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_stgxfr))
3415: OR/*Bug 6499833:For move order sub transfers,trying to get the costgroup from content_lpn_id.*/
3416: (( p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_moveorder)
3417: AND (p_mmtt_rec.transaction_action_id = inv_globals.g_action_subxfr))
3418: )
3419: -- AND (p_mmtt_rec.lpn_id IS NULL) Bug#6770593
3420: AND (p_mmtt_rec.content_lpn_id IS NOT NULL)
3421: AND (p_mmtt_rec.inventory_item_id <> -1)

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

3914: l_cost_group_id := l_mmtt_rec.cost_group_id;
3915: l_transfer_cost_group_id := l_mmtt_rec.transfer_cost_group_id;
3916:
3917: IF l_transfer_cost_group_id IS NULL AND p_transfer_wms_org AND
3918: ((l_mmtt_rec.transaction_action_id = inv_globals.g_action_orgxfr) OR
3919: (l_mmtt_rec.transaction_action_id = inv_globals.g_action_intransitshipment
3920: AND p_fob_point = 1)
3921: OR (l_mmtt_rec.transaction_action_id = inv_globals.g_action_intransitreceipt)
3922: )

Line 3919: (l_mmtt_rec.transaction_action_id = inv_globals.g_action_intransitshipment

3915: l_transfer_cost_group_id := l_mmtt_rec.transfer_cost_group_id;
3916:
3917: IF l_transfer_cost_group_id IS NULL AND p_transfer_wms_org AND
3918: ((l_mmtt_rec.transaction_action_id = inv_globals.g_action_orgxfr) OR
3919: (l_mmtt_rec.transaction_action_id = inv_globals.g_action_intransitshipment
3920: AND p_fob_point = 1)
3921: OR (l_mmtt_rec.transaction_action_id = inv_globals.g_action_intransitreceipt)
3922: )
3923: THEN

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

3917: IF l_transfer_cost_group_id IS NULL AND p_transfer_wms_org AND
3918: ((l_mmtt_rec.transaction_action_id = inv_globals.g_action_orgxfr) OR
3919: (l_mmtt_rec.transaction_action_id = inv_globals.g_action_intransitshipment
3920: AND p_fob_point = 1)
3921: OR (l_mmtt_rec.transaction_action_id = inv_globals.g_action_intransitreceipt)
3922: )
3923: THEN
3924: IF (l_debug = 1) THEN
3925: print_debug('Getting transfer cost group id from rules engine...: ');

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

3970: ELSE
3971: RETURN;
3972: END IF;
3973:
3974: IF inv_globals.is_issue_xfr_transaction(l_mmtt_rec.transaction_action_id) THEN
3975: IF l_mmtt_rec.transfer_cost_group_id IS NOT NULL
3976: AND l_mmtt_rec.cost_group_id IS NOT NULL THEN
3977: RETURN;
3978: ELSIF l_mmtt_rec.cost_group_id IS NOT NULL AND

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

4074: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4075: END;
4076: END IF;
4077:
4078: IF l_mmtt_rec.transaction_action_id IN (inv_globals.g_type_cycle_count_adj,
4079: inv_globals.g_type_physical_count_adj,
4080: inv_globals.g_action_deliveryadj)
4081: THEN
4082: IF l_mmtt_rec.transaction_action_id IN (inv_globals.g_type_physical_count_adj,

Line 4079: inv_globals.g_type_physical_count_adj,

4075: END;
4076: END IF;
4077:
4078: IF l_mmtt_rec.transaction_action_id IN (inv_globals.g_type_cycle_count_adj,
4079: inv_globals.g_type_physical_count_adj,
4080: inv_globals.g_action_deliveryadj)
4081: THEN
4082: IF l_mmtt_rec.transaction_action_id IN (inv_globals.g_type_physical_count_adj,
4083: inv_globals.g_action_deliveryadj) THEN

Line 4080: inv_globals.g_action_deliveryadj)

4076: END IF;
4077:
4078: IF l_mmtt_rec.transaction_action_id IN (inv_globals.g_type_cycle_count_adj,
4079: inv_globals.g_type_physical_count_adj,
4080: inv_globals.g_action_deliveryadj)
4081: THEN
4082: IF l_mmtt_rec.transaction_action_id IN (inv_globals.g_type_physical_count_adj,
4083: inv_globals.g_action_deliveryadj) THEN
4084: IF l_mmtt_rec.lpn_id IS NOT NULL THEN

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

4078: IF l_mmtt_rec.transaction_action_id IN (inv_globals.g_type_cycle_count_adj,
4079: inv_globals.g_type_physical_count_adj,
4080: inv_globals.g_action_deliveryadj)
4081: THEN
4082: IF l_mmtt_rec.transaction_action_id IN (inv_globals.g_type_physical_count_adj,
4083: inv_globals.g_action_deliveryadj) THEN
4084: IF l_mmtt_rec.lpn_id IS NOT NULL THEN
4085: l_lpn_id := l_mmtt_rec.lpn_id;
4086: ELSIF l_mmtt_rec.content_lpn_id IS NOT NULL THEN

Line 4083: inv_globals.g_action_deliveryadj) THEN

4079: inv_globals.g_type_physical_count_adj,
4080: inv_globals.g_action_deliveryadj)
4081: THEN
4082: IF l_mmtt_rec.transaction_action_id IN (inv_globals.g_type_physical_count_adj,
4083: inv_globals.g_action_deliveryadj) THEN
4084: IF l_mmtt_rec.lpn_id IS NOT NULL THEN
4085: l_lpn_id := l_mmtt_rec.lpn_id;
4086: ELSIF l_mmtt_rec.content_lpn_id IS NOT NULL THEN
4087: l_lpn_id := l_mmtt_rec.content_lpn_id;

Line 4091: ELSIF l_mmtt_rec.transaction_action_id = inv_globals.g_type_cycle_count_adj

4087: l_lpn_id := l_mmtt_rec.content_lpn_id;
4088: ELSIF l_mmtt_rec.transfer_lpn_id IS NOT NULL THEN
4089: l_lpn_id := l_mmtt_rec.transfer_lpn_id;
4090: END IF;
4091: ELSIF l_mmtt_rec.transaction_action_id = inv_globals.g_type_cycle_count_adj
4092: THEN
4093: l_lpn_id := l_mmtt_rec.transfer_lpn_id;
4094: END IF;
4095: