APPS.WMS_CARTNZN_PUB dependencies on MTL_TXN_REQUEST_HEADERS

Line 455: mtl_material_transactions_temp mmtt,mtl_txn_request_headers moh,

451:
452:
453: CURSOR c11_bulk_all(p_organization_id NUMBER) IS
454: SELECT mmtt.* FROM
455: mtl_material_transactions_temp mmtt,mtl_txn_request_headers moh,
456: wsh_pick_grouping_rules spg
457: WHERE mmtt.wms_task_status = 8 -- unreleased
458: And nvl(mmtt.lock_flag,'$') <> 'Y' --Bug#8546026
459: And mmtt.cartonization_id IS null -- not cartonized

Line 485: mtl_material_transactions_temp mmtt,mtl_txn_request_headers moh,

481: for update of mmtt.transaction_temp_id; -- to lock the records
482:
483: CURSOR c11_bulk_only_sub_item(p_organization_id NUMBER) IS
484: SELECT mmtt.* FROM
485: mtl_material_transactions_temp mmtt,mtl_txn_request_headers moh,
486: wsh_pick_grouping_rules spg
487: WHERE mmtt.wms_task_status = 8 -- unreleased
488: And nvl(mmtt.lock_flag,'$') <> 'Y' --Bug#8546026
489: And mmtt.cartonization_id IS null -- not cartonized

Line 527: wsh_trip_stops wts, mtl_material_transactions_temp mmtt,mtl_txn_request_headers moh,

523:
524: CURSOR c11_bulk_trip(p_organization_id NUMBER) IS
525: select mmtt.*
526: from wsh_delivery_legs wdl,wsh_delivery_details wdd, wsh_delivery_assignments_v wda,
527: wsh_trip_stops wts, mtl_material_transactions_temp mmtt,mtl_txn_request_headers moh,
528: wsh_pick_grouping_rules spg
529: where wts.trip_id = p_input_for_bulk.trip_id
530: and wdl.pick_up_stop_id = wts.stop_id
531: and wdl.delivery_id = wda.delivery_id

Line 564: wsh_trip_stops wts, mtl_material_transactions_temp mmtt,mtl_txn_request_headers moh,

560:
561: CURSOR c11_bulk_trip_sub_item(p_organization_id NUMBER) IS
562: select mmtt.*
563: from wsh_delivery_legs wdl,wsh_delivery_details wdd, wsh_delivery_assignments_v wda,
564: wsh_trip_stops wts, mtl_material_transactions_temp mmtt,mtl_txn_request_headers moh,
565: wsh_pick_grouping_rules spg
566: where wts.trip_id = p_input_for_bulk.trip_id
567: and wdl.pick_up_stop_id = wts.stop_id
568: and wdl.delivery_id = wda.delivery_id

Line 650: from mtl_txn_request_headers moh,

646: l_fast_possible := true;
647: insert into mtl_allocations_gtmp
648: (move_order_header_id)
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

Line 3538: FROM mtl_txn_request_headers

3534: , l_autocreate_delivery_flag
3535: FROM wsh_picking_batches
3536: WHERE batch_id =
3537: (SELECT request_number
3538: FROM mtl_txn_request_headers
3539: WHERE header_id = p_move_order_header_id
3540: AND move_order_type = inv_globals.G_MOVE_ORDER_PICK_WAVE);
3541:
3542: IF l_auto_pick_confirm_flag = 'Y' THEN

Line 3635: FROM mtl_txn_request_headers

3631: ELSE
3632: -- if (g_trace_on = 1) then log_event('PATCHSET J-- BULK PICKING '); end if;
3633: SELECT move_order_type
3634: INTO l_move_order_type
3635: FROM mtl_txn_request_headers
3636: WHERE header_id = p_move_order_header_id;
3637:
3638: if (g_trace_on = 1) then log_event('Move order type:'||l_move_order_type); end if;
3639: END IF;