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 464: AND spg.pick_method <>WMS_GLOBALS.PICK_METHOD_ORDER -- not order pciking

460: And mmtt.organization_id = p_organization_id
461: AND mmtt.allocated_lpn_id IS NULL -- if lpn allocated, no need to do consolidation
462: AND mmtt.move_order_header_id = moh.header_id
463: AND spg.pick_grouping_rule_id = moh.grouping_rule_id
464: AND spg.pick_method <>WMS_GLOBALS.PICK_METHOD_ORDER -- not order pciking
465: AND moh.move_order_type = INV_GLOBALS.g_move_order_pick_wave -- pick wave move order only
466: -- following is the logic for the input parameters
467: AND (mmtt.serial_allocated_flag <> 'Y' OR
468: mmtt.serial_allocated_flag IS NULL ) -- should not bulk those childs Bug3628747

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

490: And mmtt.organization_id = p_organization_id
491: AND mmtt.allocated_lpn_id IS NULL -- if lpn allocated, no need to do consolidation
492: AND mmtt.move_order_header_id = moh.header_id
493: AND spg.pick_grouping_rule_id = moh.grouping_rule_id
494: AND spg.pick_method <>WMS_GLOBALS.PICK_METHOD_ORDER -- not order pciking
495: AND (mmtt.serial_allocated_flag <> 'Y' OR
496: mmtt.serial_allocated_flag IS NULL ) -- should not bulk those lines
497: -- Bug3628747
498: AND moh.move_order_type = INV_GLOBALS.g_move_order_pick_wave -- pick wave move order only

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

537: And mmtt.organization_id = p_organization_id
538: AND mmtt.allocated_lpn_id IS NULL -- if lpn allocated, no need to do consolidation
539: AND mmtt.move_order_header_id = moh.header_id
540: AND spg.pick_grouping_rule_id = moh.grouping_rule_id
541: AND spg.pick_method <>WMS_GLOBALS.PICK_METHOD_ORDER -- not order pciking
542: AND (mmtt.serial_allocated_flag <> 'Y' OR
543: mmtt.serial_allocated_flag IS NULL ) -- should not bulk those lines
544: --Bug3628747
545: AND moh.move_order_type = INV_GLOBALS.g_move_order_pick_wave -- pick wave move order only

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

574: And mmtt.organization_id = p_organization_id
575: AND mmtt.allocated_lpn_id IS NULL -- if lpn allocated, no need to do consolidation
576: AND mmtt.move_order_header_id = moh.header_id
577: AND spg.pick_grouping_rule_id = moh.grouping_rule_id
578: AND spg.pick_method <>WMS_GLOBALS.PICK_METHOD_ORDER -- not order pciking
579: AND (mmtt.serial_allocated_flag <> 'Y' OR
580: mmtt.serial_allocated_flag IS NULL ) -- should not bulk those lines
581: --Bug3628747
582: AND moh.move_order_type = INV_GLOBALS.g_move_order_pick_wave -- pick wave move order only

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

649: select moh.header_id
650: from mtl_txn_request_headers moh,
651: wsh_pick_grouping_rules spg
652: where spg.pick_grouping_rule_id = moh.grouping_rule_id
653: AND spg.pick_method <>WMS_GLOBALS.PICK_METHOD_ORDER -- not order pciking
654: AND moh.move_order_type = INV_GLOBALS.g_move_order_pick_wave -- pick wave move order only
655: AND moh.request_number between nvl(p_input_for_bulk.start_mo_request_number,moh.request_number) and
656: nvl(p_input_for_bulk.end_mo_request_number,moh.request_number)
657: AND moh.creation_date between nvl(p_input_for_bulk.start_release_date,moh.creation_date) and