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.WMS_CARTNZN_PUB dependencies on WMS_GLOBALS

Line 562: AND spg.pick_method <>WMS_GLOBALS.PICK_METHOD_ORDER -- not order pciking

558: And mmtt.organization_id = p_organization_id
559: AND mmtt.allocated_lpn_id IS NULL -- if lpn allocated, no need to do consolidation
560: AND mmtt.move_order_header_id = moh.header_id
561: AND spg.pick_grouping_rule_id = moh.grouping_rule_id
562: AND spg.pick_method <>WMS_GLOBALS.PICK_METHOD_ORDER -- not order pciking
563: AND moh.move_order_type = INV_GLOBALS.g_move_order_pick_wave -- pick wave move order only
564: -- following is the logic for the input parameters
565: AND (mmtt.serial_allocated_flag <> 'Y' OR
566: mmtt.serial_allocated_flag IS NULL ) -- should not bulk those childs Bug3628747

Line 591: AND spg.pick_method <>WMS_GLOBALS.PICK_METHOD_ORDER -- not order pciking

587: And mmtt.organization_id = p_organization_id
588: AND mmtt.allocated_lpn_id IS NULL -- if lpn allocated, no need to do consolidation
589: AND mmtt.move_order_header_id = moh.header_id
590: AND spg.pick_grouping_rule_id = moh.grouping_rule_id
591: AND spg.pick_method <>WMS_GLOBALS.PICK_METHOD_ORDER -- not order pciking
592: AND (mmtt.serial_allocated_flag <> 'Y' OR
593: mmtt.serial_allocated_flag IS NULL ) -- should not bulk those lines
594: -- Bug3628747
595: AND moh.move_order_type = INV_GLOBALS.g_move_order_pick_wave -- pick wave move order only

Line 637: AND spg.pick_method <>WMS_GLOBALS.PICK_METHOD_ORDER -- not order pciking

633: And mmtt.organization_id = p_organization_id
634: AND mmtt.allocated_lpn_id IS NULL -- if lpn allocated, no need to do consolidation
635: AND mmtt.move_order_header_id = moh.header_id
636: AND spg.pick_grouping_rule_id = moh.grouping_rule_id
637: AND spg.pick_method <>WMS_GLOBALS.PICK_METHOD_ORDER -- not order pciking
638: AND (mmtt.serial_allocated_flag <> 'Y' OR
639: mmtt.serial_allocated_flag IS NULL ) -- should not bulk those lines
640: --Bug3628747
641: AND moh.move_order_type = INV_GLOBALS.g_move_order_pick_wave -- pick wave move order only

Line 673: AND spg.pick_method <>WMS_GLOBALS.PICK_METHOD_ORDER -- not order pciking

669: And mmtt.organization_id = p_organization_id
670: AND mmtt.allocated_lpn_id IS NULL -- if lpn allocated, no need to do consolidation
671: AND mmtt.move_order_header_id = moh.header_id
672: AND spg.pick_grouping_rule_id = moh.grouping_rule_id
673: AND spg.pick_method <>WMS_GLOBALS.PICK_METHOD_ORDER -- not order pciking
674: AND (mmtt.serial_allocated_flag <> 'Y' OR
675: mmtt.serial_allocated_flag IS NULL ) -- should not bulk those lines
676: --Bug3628747
677: AND moh.move_order_type = INV_GLOBALS.g_move_order_pick_wave -- pick wave move order only

Line 748: AND spg.pick_method <>WMS_GLOBALS.PICK_METHOD_ORDER -- not order pciking

744: select moh.header_id
745: from mtl_txn_request_headers moh,
746: wsh_pick_grouping_rules spg
747: where spg.pick_grouping_rule_id = moh.grouping_rule_id
748: AND spg.pick_method <>WMS_GLOBALS.PICK_METHOD_ORDER -- not order pciking
749: AND moh.move_order_type = INV_GLOBALS.g_move_order_pick_wave -- pick wave move order only
750: AND moh.request_number between nvl(p_input_for_bulk.start_mo_request_number,moh.request_number) and
751: nvl(p_input_for_bulk.end_mo_request_number,moh.request_number)
752: AND moh.creation_date between nvl(p_input_for_bulk.start_release_date,moh.creation_date) and