APPS.WMS_PICKING_PKG dependencies on MTL_PARAMETERS

Line 1151: FROM mtl_parameters

1147: ) THEN
1148:
1149: SELECT OVPK_TRANSFER_ORDERS_ENABLED
1150: INTO l_temp
1151: FROM mtl_parameters
1152: WHERE organization_id = l_org_id;
1153: l_check_overpick_passed := NVL(l_temp, 'Y');
1154:
1155: IF l_debug = 1 THEN

Line 1164: FROM mtl_parameters

1160: ELSIF (l_move_order_type = inv_globals.g_move_order_mfg_pick) THEN
1161:
1162: SELECT wip_overpick_enabled
1163: INTO l_temp
1164: FROM mtl_parameters
1165: WHERE organization_id = l_org_id;
1166: l_check_overpick_passed := NVL(l_temp, 'N');
1167:
1168: IF l_debug = 1 THEN

Line 1357: , mtl_parameters mp

1353: , NVL(mmtt.fulfillment_base, 'P') -- MUOM:SK (72)
1354: FROM wms_dispatched_tasks wdt
1355: , mtl_material_transactions_temp mmtt
1356: , mtl_system_items_vl msik /* Bug 5581528 */
1357: , mtl_parameters mp
1358: , mtl_txn_request_lines mtrl
1359: , mtl_secondary_inventories msi
1360: WHERE mmtt.transaction_temp_id = l_transaction_temp_id
1361: AND wdt.transaction_temp_id = mmtt.transaction_temp_id

Line 1479: , mtl_parameters mp

1475: /* end for LMS project */
1476: FROM wms_dispatched_tasks wdt
1477: , mtl_material_transactions_temp mmtt
1478: , mtl_system_items_vl msik /* Bug 5581528 */
1479: , mtl_parameters mp
1480: , mtl_txn_request_lines mtrl
1481: , mtl_secondary_inventories msi
1482: WHERE mmtt.transaction_temp_id = l_transaction_temp_id
1483: AND wdt.transaction_temp_id = mmtt.transaction_temp_id

Line 3850: FROM wms_skip_task_exceptions wste, mtl_parameters mp

3846: -- Delete from the skip tasks exceptions table
3847: DELETE FROM wms_skip_task_exceptions
3848: WHERE task_id = task_record.transaction_temp_id
3849: AND task_id IN (SELECT wste.task_id
3850: FROM wms_skip_task_exceptions wste, mtl_parameters mp
3851: WHERE ABS((SYSDATE - wste.creation_date) * 24 * 60) > mp.skip_task_waiting_minutes
3852: AND wste.task_id = task_record.transaction_temp_id
3853: AND wste.organization_id = mp.organization_id);
3854: