eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_LABEL_PVT5 dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 171: , p_input_param IN MTL_MATERIAL_TRANSACTIONS_TEMP%ROWTYPE

167: , x_msg_data OUT NOCOPY VARCHAR2
168: , x_return_status OUT NOCOPY VARCHAR2
169: , p_label_type_info IN INV_LABEL.label_type_rec
170: , p_transaction_id IN NUMBER
171: , p_input_param IN MTL_MATERIAL_TRANSACTIONS_TEMP%ROWTYPE
172: , p_lpn_id IN NUMBER
173: , p_transaction_identifier IN NUMBER
174: ) IS
175:

Line 194: l_uom MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSACTION_UOM%TYPE := null;

190: l_location_id NUMBER;
191:
192: --Bug# 3739739
193: l_qty NUMBER;
194: l_uom MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSACTION_UOM%TYPE := null;
195:
196:
197: -- Added vendor_id and vendor_site_id to the cursor for Bug 2748297
198: CURSOR c_rti_lpn IS

Line 493: FROM mtl_material_transactions_temp mmtt

489: mmtt.inventory_item_id,
490: mmtt.revision,
491: mmtt.subinventory_code,
492: mmtt.locator_id
493: FROM mtl_material_transactions_temp mmtt
494: WHERE mmtt.transaction_temp_id = p_transaction_id
495: AND rownum<2;
496:
497: CURSOR c_mmtt_lpn_pick_load IS

Line 511: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt

507: mmtt.subinventory_code, mmtt.locator_id --Bug 8528146
508: , mmtt.subinventory_code /*from sub, to select printer*/
509: , abs(nvl(mtlt.secondary_quantity, mmtt.secondary_transaction_quantity)) secondary_quantity, -- invocnv changes
510: mmtt.secondary_uom_code -- invconv changes
511: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt
512: WHERE mtlt.transaction_temp_id(+) = mmtt.transaction_temp_id
513: AND mmtt.transaction_temp_id = p_transaction_id;
514:
515: CURSOR c_mmtt_cart_lpn IS

Line 531: FROM mtl_material_transactions_temp

527: lot_number, revision, abs(transaction_quantity), transaction_uom,
528: transfer_subinventory, transfer_to_location,
529: abs(secondary_transaction_quantity), secondary_uom_code, -- invconv changes
530: transaction_source_id -- Conf Label ER
531: FROM mtl_material_transactions_temp
532: WHERE transaction_temp_id = p_transaction_id;
533:
534: CURSOR c_mmtt_pregen_lpn IS
535: SELECT lpn_id, subinventory_code, locator_id, abs(transaction_quantity) quantity,--Conf Label ER - Adding organization_id,inventory_item_id,revision

Line 537: FROM mtl_material_transactions_temp

533:
534: CURSOR c_mmtt_pregen_lpn IS
535: SELECT lpn_id, subinventory_code, locator_id, abs(transaction_quantity) quantity,--Conf Label ER - Adding organization_id,inventory_item_id,revision
536: organization_id,inventory_item_id,revision
537: FROM mtl_material_transactions_temp
538: WHERE transaction_temp_id = p_transaction_id;
539:
540: -- Bug 3836623
541: -- To prevent printing duplicate labels for cross docking for serialized item

Line 576: FROM mtl_material_transactions_temp mmtt

572: -- for WIP completion, lpn_id is used rather than transfer_lpn_id
573: -- Changed to use c_mmtt_lpn
574: /*CURSOR c_wip_lpn IS
575: SELECT transfer_lpn_id
576: FROM mtl_material_transactions_temp mmtt
577: WHERE mmtt.transaction_temp_id = p_transaction_id;*/
578:
579:
580: -- For business flow code of 33, the MMTT, MTI or MOL id is passed

Line 730: p_revision MTL_MATERIAL_TRANSACTIONS_TEMP.REVISION%TYPE := null;

726:
727: p_organization_id NUMBER := null;
728: p_inventory_item_id NUMBER := null;
729: p_lot_number MTL_LOT_NUMBERS.LOT_NUMBER%TYPE :=null;
730: p_revision MTL_MATERIAL_TRANSACTIONS_TEMP.REVISION%TYPE := null;
731: p_qty NUMBER := null;
732: p_uom MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSACTION_UOM%TYPE := null;
733: p_cost_group_id NUMBER := null;
734:

Line 732: p_uom MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSACTION_UOM%TYPE := null;

728: p_inventory_item_id NUMBER := null;
729: p_lot_number MTL_LOT_NUMBERS.LOT_NUMBER%TYPE :=null;
730: p_revision MTL_MATERIAL_TRANSACTIONS_TEMP.REVISION%TYPE := null;
731: p_qty NUMBER := null;
732: p_uom MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSACTION_UOM%TYPE := null;
733: p_cost_group_id NUMBER := null;
734:
735: --Fix for 4891916
736: l_lot_number mtl_lot_numbers.lot_number%TYPE := NULL;

Line 737: l_revision mtl_material_transactions_temp.revision%TYPE := NULL;

733: p_cost_group_id NUMBER := null;
734:
735: --Fix for 4891916
736: l_lot_number mtl_lot_numbers.lot_number%TYPE := NULL;
737: l_revision mtl_material_transactions_temp.revision%TYPE := NULL;
738: -- End of fix for 4891916
739:
740: l_subinventory_code VARCHAR2(10) := null;
741: l_locator_id NUMBER :=null;

Line 911: , mtl_material_transactions_temp mmtt

907: , mtlt.supplier_lot_number
908: FROM mtl_parameters mp
909: , mtl_system_items_kfv msik
910: , mtl_transaction_lots_temp mtlt
911: , mtl_material_transactions_temp mmtt
912: , po_hazard_classes poh
913: , mtl_material_statuses_vl mmsv
914: WHERE msik.inventory_item_id = p_item_id
915: AND msik.organization_id = p_org_id

Line 1150: , mtl_material_transactions_temp mmtt

1146: , ppf.full_name requestor
1147: FROM mtl_cycle_count_headers mcch
1148: , mtl_cycle_count_entries mcce
1149: , per_people_f ppf
1150: , mtl_material_transactions_temp mmtt
1151: WHERE mmtt.transaction_temp_id= p_transaction_id
1152: AND mmtt.cycle_count_id = mcce.cycle_count_entry_id
1153: AND mcce.cycle_count_header_id = mcch.cycle_count_header_id
1154: AND ppf.person_id(+) = mcce.counted_by_employee_id_current ;

Line 1250: , mtl_material_transactions_temp mmtt

1246: , l_secondary_quantity secondary_quantity -- invconv fabdi
1247: , l_secondary_uom secondary_uom -- invconv fabdi
1248:
1249: FROM wms_packaging_hist wpc
1250: , mtl_material_transactions_temp mmtt
1251: , mtl_system_items msi
1252: , cst_cost_groups ccg
1253: , mtl_item_locations milkfv
1254: -- Bug 4137707, Do not need to include this where clause,

Line 4591: , p_input_param IN MTL_MATERIAL_TRANSACTIONS_TEMP%ROWTYPE

4587: , x_msg_data OUT NOCOPY VARCHAR2
4588: , x_return_status OUT NOCOPY VARCHAR2
4589: , p_label_type_info IN INV_LABEL.label_type_rec
4590: , p_transaction_id IN NUMBER
4591: , p_input_param IN MTL_MATERIAL_TRANSACTIONS_TEMP%ROWTYPE
4592: , p_lpn_id IN NUMBER
4593: , p_transaction_identifier IN NUMBER
4594: ) IS
4595: l_variable_data_tbl INV_LABEL.label_tbl_type;