APPS.WMS_PICKING_PKG dependencies on MTL_PARAMETERS

Line 934: FROM mtl_parameters

930: ) THEN
931:
932: SELECT OVPK_TRANSFER_ORDERS_ENABLED
933: INTO l_temp
934: FROM mtl_parameters
935: WHERE organization_id = l_org_id;
936: l_check_overpick_passed := NVL(l_temp, 'Y');
937:
938: IF l_debug = 1 THEN

Line 947: FROM mtl_parameters

943: ELSIF (l_move_order_type = inv_globals.g_move_order_mfg_pick) THEN
944:
945: SELECT wip_overpick_enabled
946: INTO l_temp
947: FROM mtl_parameters
948: WHERE organization_id = l_org_id;
949: l_check_overpick_passed := NVL(l_temp, 'N');
950:
951: IF l_debug = 1 THEN

Line 1112: , mtl_parameters mp

1108:
1109: FROM wms_dispatched_tasks wdt
1110: , mtl_material_transactions_temp mmtt
1111: , mtl_system_items_vl msik /* Bug 5581528 */
1112: , mtl_parameters mp
1113: , mtl_txn_request_lines mtrl
1114: , mtl_secondary_inventories msi
1115: WHERE mmtt.transaction_temp_id = l_transaction_temp_id
1116: AND wdt.transaction_temp_id = mmtt.transaction_temp_id

Line 1219: , mtl_parameters mp

1215: /* end for LMS project */
1216: FROM wms_dispatched_tasks wdt
1217: , mtl_material_transactions_temp mmtt
1218: , mtl_system_items_vl msik /* Bug 5581528 */
1219: , mtl_parameters mp
1220: , mtl_txn_request_lines mtrl
1221: , mtl_secondary_inventories msi
1222: WHERE mmtt.transaction_temp_id = l_transaction_temp_id
1223: AND wdt.transaction_temp_id = mmtt.transaction_temp_id

Line 3422: FROM wms_skip_task_exceptions wste, mtl_parameters mp

3418: -- Delete from the skip tasks exceptions table
3419: DELETE FROM wms_skip_task_exceptions
3420: WHERE task_id = task_record.transaction_temp_id
3421: AND task_id IN (SELECT wste.task_id
3422: FROM wms_skip_task_exceptions wste, mtl_parameters mp
3423: WHERE ABS((SYSDATE - wste.creation_date) * 24 * 60) > mp.skip_task_waiting_minutes
3424: AND wste.task_id = task_record.transaction_temp_id
3425: AND wste.organization_id = mp.organization_id);
3426: