APPS.WMS_WORKFLOW_WRAPPERS dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 481: FROM mtl_material_transactions_temp

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

Line 1525: FROM mtl_material_transactions_temp

1521: -- get data to call suggest_alternate_locatoin
1522:
1523: SELECT subinventory_code,locator_id, move_order_line_id
1524: INTO lp_sub_code,lp_locator_id, lp_line_num
1525: FROM mtl_material_transactions_temp
1526: WHERE transaction_temp_id=lp_mmtt_id;
1527: IF (l_debug = 1) THEN
1528: mdebug('before calling wms_txnrsn_actions_pub.suggest_alternate_location ');
1529: END IF;

Line 2332: FROM mtl_material_transactions_temp

2328: END IF;
2329:
2330: SELECT inventory_item_id, subinventory_code, transaction_uom, locator_id
2331: INTO l_inventory_item_id, l_subinventory_code, l_transaction_uom, l_locator_id
2332: FROM mtl_material_transactions_temp
2333: WHERE transaction_temp_id = l_transaction_temp_id;
2334:
2335: IF (l_debug = 1) THEN
2336: mdebug('l_transaction_uom: '|| l_transaction_uom);

Line 2567: FROM mtl_material_transactions_temp

2563: END IF;
2564:
2565: SELECT subinventory_code,locator_id, move_order_line_id
2566: INTO lp_sub_code,lp_locator_id, lp_line_num
2567: FROM mtl_material_transactions_temp
2568: WHERE transaction_temp_id=lp_mmtt_id;
2569:
2570: wms_txnrsn_actions_pub.suggest_alternate_location
2571: (p_api_version_number =>lp_api_version_number