APPS.WMS_TASK_DISPATCH_PUT_AWAY dependencies on MTL_PARAMETERS

Line 1179: FROM mtl_parameters

1175: , pregen_putaway_tasks_flag
1176: INTO l_regeneration_interval
1177: , l_cdock_flag
1178: , l_pregen_putaway_tasks_flag
1179: FROM mtl_parameters
1180: WHERE organization_id = p_org_id;
1181:
1182: -- Bug# 2752119
1183: -- Only check for crossdocking if the input parameter is set to 'Y'

Line 2190: FROM mtl_parameters WHERE organization_id = p_org_id;

2186: Also added check in If statement to not refer to Wip_Lpn_Completions table for discrete Orgs.
2187: Also added the If statement to update transaction_source_id in MMTT for Process Orgs. */
2188:
2189: SELECT NVL(process_enabled_flag, 'N') INTO l_process_flag
2190: FROM mtl_parameters WHERE organization_id = p_org_id;
2191:
2192: -- Update MMTT for WIP
2193: IF (l_txn_source_type_id = 5 AND l_process_flag = 'N') THEN
2194: SELECT completion_transaction_id

Line 3092: from mtl_parameters

3088: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
3089: BEGIN
3090: select primary_cost_method
3091: into l_primary_cost_method
3092: from mtl_parameters
3093: where organization_id = p_org_id;
3094:
3095: IF (l_debug = 1) THEN
3096: mydebug('complete_putaway: cost method of org'||p_org_id||' is '||l_primary_cost_method);

Line 3630: FROM mtl_parameters WHERE organization_id = p_org_id;

3626:
3627: /*nsinghi GME-WMS Integration Start. Determine if Process Org*/
3628:
3629: SELECT NVL(process_enabled_flag, 'N') INTO l_process_flag
3630: FROM mtl_parameters WHERE organization_id = p_org_id;
3631:
3632: /*nsinghi GME-WMS Integration End. Determine if Process Org*/
3633:
3634: -- Bug# 2744170

Line 9118: FROM mtl_parameters

9114: /*
9115: -- Check to see if cross dock is enabled for the org
9116: SELECT NVL(crossdock_flag, 2)
9117: INTO l_cross_dock_flag
9118: FROM mtl_parameters
9119: WHERE organization_id = p_organization_id;
9120:
9121: IF (l_debug = 1) THEN
9122: mydebug('Cross Dock Flag: ' || l_cross_dock_flag);