DBA Data[Home] [Help]

APPS.WMS_TASK_LOAD dependencies on STANDARD

Line 2123: --When calculating based on UOM conversion if Lot Specific conversion exists then that will be used else the standard conversion would get used.

2119: END IF;
2120:
2121: --For secondary based fulfillment if entire secondary onhand in LPN is consumed then, consume entire primary from the onhand.
2122: --Else for picking from loose or picking from LPN but entire onhand is not consumed then use UOM conversion. Ct Wt entry would correct the primary qty.
2123: --When calculating based on UOM conversion if Lot Specific conversion exists then that will be used else the standard conversion would get used.
2124: IF(l_sqoh = l_lot_sec_qty) THEN
2125: l_lot_prim_qty := l_qoh;
2126: mydebug ('For fulfillment_base S for lot :'||l_lot_number||' entire secondary is consumed so consuming entire primary qty ' || l_lot_prim_qty);
2127: ELSE

Line 2803: ,STANDARD_OPERATION_ID

2799: ,COMMON_ROUTING_SEQ_ID
2800: ,ORG_COST_GROUP_ID
2801: ,COST_TYPE_ID
2802: ,TRANSACTION_STATUS
2803: ,STANDARD_OPERATION_ID
2804: ,TASK_PRIORITY
2805: ,WMS_TASK_TYPE
2806: ,PARENT_LINE_ID
2807: ,LPN_ID

Line 3039: ,STANDARD_OPERATION_ID

3035: ,COMMON_ROUTING_SEQ_ID
3036: ,ORG_COST_GROUP_ID
3037: ,COST_TYPE_ID
3038: ,TRANSACTION_STATUS
3039: ,STANDARD_OPERATION_ID
3040: ,TASK_PRIORITY
3041: ,WMS_TASK_TYPE
3042: ,DECODE(PARENT_LINE_ID, NULL,NULL,l_new_transaction_temp_id) -- Take care of BULK parent
3043: ,NVL(p_lpn_id,p_parent_lpn_id) -- process the nesting

Line 12709: ' AND mmtt.standard_operation_id = wutta.user_task_type_id '||

12705: --Bug7120019
12706: IF wms_control.g_current_release_level >= 120001 THEN
12707: l_CursorStmt := 'SELECT count (*) FROM mtl_material_transactions_temp mmtt, wms_user_task_type_attributes wutta '||
12708: 'WHERE mmtt.transaction_temp_id = :x_temp_id ' ||
12709: ' AND mmtt.standard_operation_id = wutta.user_task_type_id '||
12710: ' AND mmtt.organization_id = wutta.organization_id '||
12711: ' AND wutta.honor_case_pick_flag = ''Y'' '; --Added for Bug#7584906
12712: l_CursorID := DBMS_SQL.OPEN_CURSOR;
12713: DBMS_SQL.PARSE(l_CursorID, l_CursorStmt, DBMS_SQL.V7);

Line 13063: -- Standard call to check for call compatibility

13059: mydebug('validate_pick_to_lpn: Start Validate_pick_to_lpn.');
13060: END IF;
13061:
13062: --
13063: -- Standard call to check for call compatibility
13064: --
13065: IF NOT fnd_api.compatible_api_call(l_api_version_number, p_api_version_number, l_api_name, g_pkg_name) THEN
13066: fnd_message.set_name('WMS', 'WMS_CONT_INCOMPATIBLE_API_CALL');
13067: fnd_msg_pub.ADD;