APPS.WMS_WORKFLOW_WRAPPERS dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 483: FROM mtl_material_transactions_temp

479: l_transaction_quantity, l_transaction_uom,
480: l_transaction_header_id, l_transaction_action_id, l_transaction_source_type_id,
481: l_transaction_source,
482: l_reservation_id, l_mo_line_id, l_allocated_lpn_id
483: FROM mtl_material_transactions_temp
484: WHERE transaction_temp_id = l_transaction_temp_id;
485:
486: IF (l_debug = 1) THEN
487: mdebug('after select from mmtt ');

Line 1533: FROM mtl_material_transactions_temp

1529: -- get data to call suggest_alternate_locatoin
1530:
1531: SELECT subinventory_code,locator_id, move_order_line_id
1532: INTO lp_sub_code,lp_locator_id, lp_line_num
1533: FROM mtl_material_transactions_temp
1534: WHERE transaction_temp_id=lp_mmtt_id;
1535: IF (l_debug = 1) THEN
1536: mdebug('before calling wms_txnrsn_actions_pub.suggest_alternate_location ');
1537: END IF;

Line 2366: FROM mtl_material_transactions_temp

2362: END IF;
2363:
2364: SELECT inventory_item_id, subinventory_code, transaction_uom, locator_id
2365: INTO l_inventory_item_id, l_subinventory_code, l_transaction_uom, l_locator_id
2366: FROM mtl_material_transactions_temp
2367: WHERE transaction_temp_id = l_transaction_temp_id;
2368:
2369: IF (l_debug = 1) THEN
2370: mdebug('l_transaction_uom: '|| l_transaction_uom);

Line 2601: FROM mtl_material_transactions_temp

2597: END IF;
2598:
2599: SELECT subinventory_code,locator_id, move_order_line_id
2600: INTO lp_sub_code,lp_locator_id, lp_line_num
2601: FROM mtl_material_transactions_temp
2602: WHERE transaction_temp_id=lp_mmtt_id;
2603:
2604: wms_txnrsn_actions_pub.suggest_alternate_location
2605: (p_api_version_number =>lp_api_version_number