APPS.WMS_TASK_DISPATCH_PUT_AWAY dependencies on MTL_PARAMETERS

Line 1324: FROM mtl_parameters

1320: , pregen_putaway_tasks_flag
1321: INTO l_regeneration_interval
1322: , l_cdock_flag
1323: , l_pregen_putaway_tasks_flag
1324: FROM mtl_parameters
1325: WHERE organization_id = p_org_id;
1326:
1327: -- Bug# 2752119
1328: -- Only check for crossdocking if the input parameter is set to 'Y'

Line 2362: FROM mtl_parameters WHERE organization_id = p_org_id;

2358: Also added check in If statement to not refer to Wip_Lpn_Completions table for discrete Orgs.
2359: Also added the If statement to update transaction_source_id in MMTT for Process Orgs. */
2360:
2361: SELECT NVL(process_enabled_flag, 'N') INTO l_process_flag
2362: FROM mtl_parameters WHERE organization_id = p_org_id;
2363:
2364: -- Update MMTT for WIP
2365: IF (l_txn_source_type_id = 5 AND l_process_flag = 'N') THEN
2366: SELECT completion_transaction_id

Line 3296: from mtl_parameters

3292: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
3293: BEGIN
3294: select primary_cost_method
3295: into l_primary_cost_method
3296: from mtl_parameters
3297: where organization_id = p_org_id;
3298:
3299: IF (l_debug = 1) THEN
3300: mydebug('complete_putaway: cost method of org'||p_org_id||' is '||l_primary_cost_method);

Line 3835: FROM mtl_parameters WHERE organization_id = p_org_id;

3831:
3832: /*nsinghi GME-WMS Integration Start. Determine if Process Org*/
3833:
3834: SELECT NVL(process_enabled_flag, 'N') INTO l_process_flag
3835: FROM mtl_parameters WHERE organization_id = p_org_id;
3836:
3837: /*nsinghi GME-WMS Integration End. Determine if Process Org*/
3838:
3839: -- Bug# 2744170

Line 9475: FROM mtl_parameters

9471: /*
9472: -- Check to see if cross dock is enabled for the org
9473: SELECT NVL(crossdock_flag, 2)
9474: INTO l_cross_dock_flag
9475: FROM mtl_parameters
9476: WHERE organization_id = p_organization_id;
9477:
9478: IF (l_debug = 1) THEN
9479: mydebug('Cross Dock Flag: ' || l_cross_dock_flag);