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 388: UPDATE mtl_material_transactions_temp

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

Line 451: UPDATE mtl_material_transactions_temp

447:
448: IF mmtt_line.parent_line_id is not null THEN -- parent line
449: -- assign a seperate pick slip number for parent task and call WMS's pick slip
450: -- report to print out
451: UPDATE mtl_material_transactions_temp
452: SET pick_slip_number = wsh_pick_slip_numbers_s.nextval
453: WHERE transaction_temp_id = mmtt_line.parent_line_id;
454: IF ( p_ps_mode <> 'I' ) THEN
455: WSH_INV_INTEGRATION_GRP.FIND_PRINTER

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

571: END IF;
572:
573: END IF ;
574: l_mso_header_id := inv_salesorder.get_salesorder_for_oeheader(mmtt_line.oe_header_id);
575: -- Assign the pick slip number to the record in MTL_MATERIAL_TRANSACTIONS_TEMP
576: UPDATE mtl_material_transactions_temp
577: SET pick_slip_number = l_pick_slip_number
578: , transaction_source_id = l_mso_header_id
579: , trx_source_line_id = mmtt_line.oe_line_id

Line 576: UPDATE mtl_material_transactions_temp

572:
573: END IF ;
574: l_mso_header_id := inv_salesorder.get_salesorder_for_oeheader(mmtt_line.oe_header_id);
575: -- Assign the pick slip number to the record in MTL_MATERIAL_TRANSACTIONS_TEMP
576: UPDATE mtl_material_transactions_temp
577: SET pick_slip_number = l_pick_slip_number
578: , transaction_source_id = l_mso_header_id
579: , trx_source_line_id = mmtt_line.oe_line_id
580: , demand_source_header_id = l_mso_header_id

Line 974: FROM mtl_material_transactions_temp mmtt

970: -- Cursor to fetch temp IDs for case pick labels
971: CURSOR c_wpr_casepick_labels (p_mo_hdr_id NUMBER) IS
972: -- Non-bulk tasks
973: SELECT mmtt.transaction_temp_id
974: FROM mtl_material_transactions_temp mmtt
975: WHERE mmtt.move_order_header_id = p_mo_hdr_id
976: AND mmtt.parent_line_id IS NULL
977: AND EXISTS
978: ( SELECT 'x'

Line 987: FROM mtl_material_transactions_temp mmtt

983: )
984: UNION ALL
985: -- Bulk pick parent tasks
986: SELECT mmtt.transaction_temp_id
987: FROM mtl_material_transactions_temp mmtt
988: WHERE mmtt.transaction_temp_id IN
989: ( SELECT DISTINCT mmtt2.parent_line_id
990: FROM mtl_material_transactions_temp mmtt2
991: WHERE mmtt2.move_order_header_id = p_mo_hdr_id

Line 990: FROM mtl_material_transactions_temp mmtt2

986: SELECT mmtt.transaction_temp_id
987: FROM mtl_material_transactions_temp mmtt
988: WHERE mmtt.transaction_temp_id IN
989: ( SELECT DISTINCT mmtt2.parent_line_id
990: FROM mtl_material_transactions_temp mmtt2
991: WHERE mmtt2.move_order_header_id = p_mo_hdr_id
992: AND mmtt2.parent_line_id IS NOT NULL
993: AND mmtt2.transaction_temp_id <> mmtt2.parent_line_id
994: )

Line 1838: --from mtl_material_transactions_Temp

1834: --quantity detailed - quantity delivered
1835:
1836: --select nvl(sum(transaction_quantity),0)
1837: --into l_transaction_quantity
1838: --from mtl_material_transactions_Temp
1839: --where move_order_line_id = l_mo_line.line_id;
1840:
1841: l_transaction_quantity := nvl(l_mo_line.quantity_detailed,0) -
1842: nvl(l_mo_line.quantity_delivered,0);

Line 3054: update mtl_material_transactions_temp

3050: IF is_debug THEN
3051: print_debug('Updating lock_flag of MMTT records','Inv_Pick_Release_Pub.Pick_Release');
3052: END IF;
3053: FORALL ii IN l_mol_id_tbl.FIRST..l_mol_id_tbl.LAST
3054: update mtl_material_transactions_temp
3055: set lock_flag = 'Y'
3056: where move_order_line_id =l_mol_id_tbl(ii);
3057: EXCEPTION
3058: WHEN OTHERS THEN

Line 3929: update mtl_material_transactions_temp

3925: 'Inv_Pick_Release_Pub.Pick_Release');
3926: End If;
3927:
3928: IF p_move_order_header_id <> -1 and p_move_order_header_id <> 0 and p_move_order_header_id IS NOT NULL THEN
3929: update mtl_material_transactions_temp
3930: set lock_flag = NULL
3931: where move_order_header_id = p_move_order_header_id
3932: and organization_id = p_org_id
3933: and lock_flag is not null;