APPS.INV_PICK_RELEASE_PUB dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 360: FROM mtl_material_transactions_temp mmtt,mtl_txn_request_lines mol,wsh_inv_delivery_details_v wdd

356: , mmtt.project_id
357: , mmtt.task_id
358: , mmtt.inventory_item_id
359: , mmtt.revision
360: FROM mtl_material_transactions_temp mmtt,mtl_txn_request_lines mol,wsh_inv_delivery_details_v wdd
361: WHERE mmtt.move_order_line_id = mol.line_id
362: AND mol.header_id = p_move_order_header_id
363: AND wdd.move_order_line_id = mol.line_id
364: AND mmtt.pick_slip_number IS NULL;

Line 387: UPDATE mtl_material_transactions_temp

383: print_debug('calling from concurrent program ',
384: 'Inv_Pick_Release_PVT.assign_pick_slip_number');
385: END IF;
386: For mmtt_line in l_mold_crs_con LOOP
387: UPDATE mtl_material_transactions_temp
388: SET pick_slip_number = wsh_pick_slip_numbers_s.nextval
389: WHERE transaction_temp_id = mmtt_line.transaction_temp_id;
390: END LOOP;
391: ELSE

Line 441: UPDATE mtl_material_transactions_temp

437:
438: IF mmtt_line.parent_line_id is not null THEN -- parent line
439: -- assign a seperate pick slip number for parent task and call WMS's pick slip
440: -- report to print out
441: UPDATE mtl_material_transactions_temp
442: SET pick_slip_number = wsh_pick_slip_numbers_s.nextval
443: WHERE transaction_temp_id = mmtt_line.parent_line_id;
444: IF ( p_ps_mode <> 'I' ) THEN
445: WSH_INV_INTEGRATION_GRP.FIND_PRINTER

Line 565: -- Assign the pick slip number to the record in MTL_MATERIAL_TRANSACTIONS_TEMP

561: END IF;
562:
563: END IF ;
564: l_mso_header_id := inv_salesorder.get_salesorder_for_oeheader(mmtt_line.oe_header_id);
565: -- Assign the pick slip number to the record in MTL_MATERIAL_TRANSACTIONS_TEMP
566: UPDATE mtl_material_transactions_temp
567: SET pick_slip_number = l_pick_slip_number
568: , transaction_source_id = l_mso_header_id
569: , trx_source_line_id = mmtt_line.oe_line_id

Line 566: UPDATE mtl_material_transactions_temp

562:
563: END IF ;
564: l_mso_header_id := inv_salesorder.get_salesorder_for_oeheader(mmtt_line.oe_header_id);
565: -- Assign the pick slip number to the record in MTL_MATERIAL_TRANSACTIONS_TEMP
566: UPDATE mtl_material_transactions_temp
567: SET pick_slip_number = l_pick_slip_number
568: , transaction_source_id = l_mso_header_id
569: , trx_source_line_id = mmtt_line.oe_line_id
570: , demand_source_header_id = l_mso_header_id

Line 955: FROM mtl_material_transactions_temp

951: v_transaction_id INV_LABEL.transaction_id_rec_type;
952:
953: Cursor c_mmtt(p_move_order_line_id NUMBER)
954: IS SELECT transaction_temp_id
955: FROM mtl_material_transactions_temp
956: WHERE move_order_line_id = p_move_order_line_id;
957: --Bug 6696594
958:
959: BEGIN

Line 1789: --from mtl_material_transactions_Temp

1785: --quantity detailed - quantity delivered
1786:
1787: --select nvl(sum(transaction_quantity),0)
1788: --into l_transaction_quantity
1789: --from mtl_material_transactions_Temp
1790: --where move_order_line_id = l_mo_line.line_id;
1791:
1792: l_transaction_quantity := nvl(l_mo_line.quantity_detailed,0) -
1793: nvl(l_mo_line.quantity_delivered,0);

Line 3128: FROM mtl_material_transactions_temp mmtt, wms_user_task_type_attributes wutta

3124: FOR b in l_transaction_id.first..l_transaction_id.last
3125: LOOP
3126:
3127: SELECT count (*) into honor_case_pick_count
3128: FROM mtl_material_transactions_temp mmtt, wms_user_task_type_attributes wutta
3129: WHERE mmtt.standard_operation_id = wutta.user_task_type_id
3130: AND mmtt.organization_id = wutta.organization_id
3131: AND mmtt.transaction_temp_id = l_transaction_id(b)
3132: AND honor_case_pick_flag = 'Y';