APPS.WMS_TASK_UTILS_PVT dependencies on MTL_PARAMETERS

Line 347: FROM mtl_parameters mp, mtl_material_transactions_temp mmtt

343: AND mmtt.transaction_temp_id = p_temp_id;
344:
345: SELECT nvl(mp.allocate_serial_flag,'N') /*Bug#4003553.Added NVL function*/
346: INTO v_allocate_serial_flag
347: FROM mtl_parameters mp, mtl_material_transactions_temp mmtt
348: WHERE mp.organization_id = mmtt.organization_id
349: AND mmtt.transaction_temp_id = p_temp_id;
350:
351: IF l_wms_task_types IN(wms_globals.g_wms_task_type_stg_move) THEN

Line 1188: FROM mtl_parameters

1184: END IF;
1185:
1186: SELECT allocate_serial_flag
1187: INTO v_allocate_serial_flag
1188: FROM mtl_parameters
1189: WHERE organization_id = l_org_id;
1190:
1191: /*****LOT controlled only **********/
1192: cnt := 1;

Line 1868: FROM mtl_parameters

1864: END IF;
1865:
1866: SELECT allocate_serial_flag
1867: INTO v_allocate_serial_flag
1868: FROM mtl_parameters
1869: WHERE organization_id = mmtt_table(cnt).organization_id;
1870:
1871: IF v_allocate_serial_flag = 'Y' THEN
1872: l_alloc_ser := 'Y';