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 169: , p_input_param IN MTL_MATERIAL_TRANSACTIONS_TEMP%ROWTYPE

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

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

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

Line 483: FROM mtl_material_transactions_temp mmtt

479: mmtt.transaction_type_id,
480: mmtt.transaction_action_id,
481: mmtt.transaction_uom --Bug# 3739739
482: -- Bug 2515486: Added transaction_type_id, transaction_action_id, inventory_item_id
483: FROM mtl_material_transactions_temp mmtt
484: WHERE mmtt.transaction_temp_id = p_transaction_id
485: AND rownum<2;
486:
487: CURSOR c_mmtt_lpn_pick_load IS

Line 500: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt

496: mmtt.transfer_subinventory, mmtt.transfer_to_location
497: , mmtt.subinventory_code /*from sub, to select printer*/
498: , abs(nvl(mtlt.secondary_quantity, mmtt.secondary_transaction_quantity)) secondary_quantity, -- invocnv changes
499: mmtt.secondary_uom_code -- invconv changes
500: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt
501: WHERE mtlt.transaction_temp_id(+) = mmtt.transaction_temp_id
502: AND mmtt.transaction_temp_id = p_transaction_id;
503:
504: CURSOR c_mmtt_cart_lpn IS

Line 519: FROM mtl_material_transactions_temp

515: SELECT transfer_lpn_id, organization_id, inventory_item_id,
516: lot_number, revision, abs(transaction_quantity), transaction_uom,
517: transfer_subinventory, transfer_to_location,
518: abs(secondary_transaction_quantity), secondary_uom_code -- invconv changes
519: FROM mtl_material_transactions_temp
520: WHERE transaction_temp_id = p_transaction_id;
521:
522: CURSOR c_mmtt_pregen_lpn IS
523: SELECT lpn_id, subinventory_code, locator_id

Line 524: FROM mtl_material_transactions_temp

520: WHERE transaction_temp_id = p_transaction_id;
521:
522: CURSOR c_mmtt_pregen_lpn IS
523: SELECT lpn_id, subinventory_code, locator_id
524: FROM mtl_material_transactions_temp
525: WHERE transaction_temp_id = p_transaction_id;
526:
527: -- Bug 3836623
528: -- To prevent printing duplicate labels for cross docking for serialized item

Line 563: FROM mtl_material_transactions_temp mmtt

559: -- for WIP completion, lpn_id is used rather than transfer_lpn_id
560: -- Changed to use c_mmtt_lpn
561: /*CURSOR c_wip_lpn IS
562: SELECT transfer_lpn_id
563: FROM mtl_material_transactions_temp mmtt
564: WHERE mmtt.transaction_temp_id = p_transaction_id;*/
565:
566:
567: -- For business flow code of 33, the MMTT, MTI or MOL id is passed

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

697:
698: p_organization_id NUMBER := null;
699: p_inventory_item_id NUMBER := null;
700: p_lot_number MTL_LOT_NUMBERS.LOT_NUMBER%TYPE :=null;
701: p_revision MTL_MATERIAL_TRANSACTIONS_TEMP.REVISION%TYPE := null;
702: p_qty NUMBER := null;
703: p_uom MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSACTION_UOM%TYPE := null;
704: p_cost_group_id NUMBER := null;
705:

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

699: p_inventory_item_id NUMBER := null;
700: p_lot_number MTL_LOT_NUMBERS.LOT_NUMBER%TYPE :=null;
701: p_revision MTL_MATERIAL_TRANSACTIONS_TEMP.REVISION%TYPE := null;
702: p_qty NUMBER := null;
703: p_uom MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSACTION_UOM%TYPE := null;
704: p_cost_group_id NUMBER := null;
705:
706: --Fix for 4891916
707: l_lot_number mtl_lot_numbers.lot_number%TYPE := NULL;

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

704: p_cost_group_id NUMBER := null;
705:
706: --Fix for 4891916
707: l_lot_number mtl_lot_numbers.lot_number%TYPE := NULL;
708: l_revision mtl_material_transactions_temp.revision%TYPE := NULL;
709: -- End of fix for 4891916
710:
711: l_subinventory_code VARCHAR2(10) := null;
712: l_locator_id NUMBER :=null;

Line 1005: , mtl_material_transactions_temp mmtt

1001: , ppf.full_name requestor
1002: FROM mtl_cycle_count_headers mcch
1003: , mtl_cycle_count_entries mcce
1004: , per_people_f ppf
1005: , mtl_material_transactions_temp mmtt
1006: WHERE mmtt.transaction_temp_id= p_transaction_id
1007: AND mmtt.cycle_count_id = mcce.cycle_count_entry_id
1008: AND mcce.cycle_count_header_id = mcch.cycle_count_header_id
1009: AND ppf.person_id(+) = mcce.counted_by_employee_id_current ;

Line 1102: , mtl_material_transactions_temp mmtt

1098: , l_secondary_quantity secondary_quantity -- invconv fabdi
1099: , l_secondary_uom secondary_uom -- invconv fabdi
1100:
1101: FROM wms_packaging_hist wpc
1102: , mtl_material_transactions_temp mmtt
1103: , mtl_system_items msi
1104: , cst_cost_groups ccg
1105: , mtl_item_locations milkfv
1106: -- Bug 4137707, Do not need to include this where clause,

Line 3954: , p_input_param IN MTL_MATERIAL_TRANSACTIONS_TEMP%ROWTYPE

3950: , x_msg_data OUT NOCOPY VARCHAR2
3951: , x_return_status OUT NOCOPY VARCHAR2
3952: , p_label_type_info IN INV_LABEL.label_type_rec
3953: , p_transaction_id IN NUMBER
3954: , p_input_param IN MTL_MATERIAL_TRANSACTIONS_TEMP%ROWTYPE
3955: , p_lpn_id IN NUMBER
3956: , p_transaction_identifier IN NUMBER
3957: ) IS
3958: l_variable_data_tbl INV_LABEL.label_tbl_type;