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_PVT4 dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 29: , p_input_param IN MTL_MATERIAL_TRANSACTIONS_TEMP%ROWTYPE

25: , x_return_status OUT NOCOPY VARCHAR2
26: , x_var_content IN LONG DEFAULT NULL
27: , p_label_type_info IN INV_LABEL.label_type_rec
28: , p_transaction_id IN NUMBER
29: , p_input_param IN MTL_MATERIAL_TRANSACTIONS_TEMP%ROWTYPE
30: , p_transaction_identifier IN NUMBER
31: ) IS
32:
33: p_organization_id MTL_PARAMETERS.ORGANIZATION_ID%TYPE := null;

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

32:
33: p_organization_id MTL_PARAMETERS.ORGANIZATION_ID%TYPE := null;
34: p_inventory_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE := null;
35: p_lot_number MTL_LOT_NUMBERS.LOT_NUMBER%TYPE :=null;
36: p_revision MTL_MATERIAL_TRANSACTIONS_TEMP.REVISION%TYPE := null;
37: p_qty MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSACTION_QUANTITY%TYPE := null;
38: p_uom MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSACTION_UOM%TYPE := null;
39: p_cost_group_id MTL_MATERIAL_TRANSACTIONS_TEMP.COST_GROUP_ID%TYPE := null;
40:

Line 37: p_qty MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSACTION_QUANTITY%TYPE := null;

33: p_organization_id MTL_PARAMETERS.ORGANIZATION_ID%TYPE := null;
34: p_inventory_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE := null;
35: p_lot_number MTL_LOT_NUMBERS.LOT_NUMBER%TYPE :=null;
36: p_revision MTL_MATERIAL_TRANSACTIONS_TEMP.REVISION%TYPE := null;
37: p_qty MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSACTION_QUANTITY%TYPE := null;
38: p_uom MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSACTION_UOM%TYPE := null;
39: p_cost_group_id MTL_MATERIAL_TRANSACTIONS_TEMP.COST_GROUP_ID%TYPE := null;
40:
41: l_subinventory_code MTL_MATERIAL_TRANSACTIONS_TEMP.SUBINVENTORY_CODE%TYPE := null;

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

34: p_inventory_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE := null;
35: p_lot_number MTL_LOT_NUMBERS.LOT_NUMBER%TYPE :=null;
36: p_revision MTL_MATERIAL_TRANSACTIONS_TEMP.REVISION%TYPE := null;
37: p_qty MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSACTION_QUANTITY%TYPE := null;
38: p_uom MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSACTION_UOM%TYPE := null;
39: p_cost_group_id MTL_MATERIAL_TRANSACTIONS_TEMP.COST_GROUP_ID%TYPE := null;
40:
41: l_subinventory_code MTL_MATERIAL_TRANSACTIONS_TEMP.SUBINVENTORY_CODE%TYPE := null;
42: l_locator_id MTL_MATERIAL_TRANSACTIONS_TEMP.LOCATOR_ID%TYPE :=null;

Line 39: p_cost_group_id MTL_MATERIAL_TRANSACTIONS_TEMP.COST_GROUP_ID%TYPE := null;

35: p_lot_number MTL_LOT_NUMBERS.LOT_NUMBER%TYPE :=null;
36: p_revision MTL_MATERIAL_TRANSACTIONS_TEMP.REVISION%TYPE := null;
37: p_qty MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSACTION_QUANTITY%TYPE := null;
38: p_uom MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSACTION_UOM%TYPE := null;
39: p_cost_group_id MTL_MATERIAL_TRANSACTIONS_TEMP.COST_GROUP_ID%TYPE := null;
40:
41: l_subinventory_code MTL_MATERIAL_TRANSACTIONS_TEMP.SUBINVENTORY_CODE%TYPE := null;
42: l_locator_id MTL_MATERIAL_TRANSACTIONS_TEMP.LOCATOR_ID%TYPE :=null;
43: l_locator VARCHAR2(204):=null;

Line 41: l_subinventory_code MTL_MATERIAL_TRANSACTIONS_TEMP.SUBINVENTORY_CODE%TYPE := null;

37: p_qty MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSACTION_QUANTITY%TYPE := null;
38: p_uom MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSACTION_UOM%TYPE := null;
39: p_cost_group_id MTL_MATERIAL_TRANSACTIONS_TEMP.COST_GROUP_ID%TYPE := null;
40:
41: l_subinventory_code MTL_MATERIAL_TRANSACTIONS_TEMP.SUBINVENTORY_CODE%TYPE := null;
42: l_locator_id MTL_MATERIAL_TRANSACTIONS_TEMP.LOCATOR_ID%TYPE :=null;
43: l_locator VARCHAR2(204):=null;
44: l_printer_sub VARCHAR2(30) := null;
45:

Line 42: l_locator_id MTL_MATERIAL_TRANSACTIONS_TEMP.LOCATOR_ID%TYPE :=null;

38: p_uom MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSACTION_UOM%TYPE := null;
39: p_cost_group_id MTL_MATERIAL_TRANSACTIONS_TEMP.COST_GROUP_ID%TYPE := null;
40:
41: l_subinventory_code MTL_MATERIAL_TRANSACTIONS_TEMP.SUBINVENTORY_CODE%TYPE := null;
42: l_locator_id MTL_MATERIAL_TRANSACTIONS_TEMP.LOCATOR_ID%TYPE :=null;
43: l_locator VARCHAR2(204):=null;
44: l_printer_sub VARCHAR2(30) := null;
45:
46: l_project_id NUMBER; --- bug 8430171

Line 456: FROM mtl_material_transactions_temp mmtt

452: mmtt.inventory_item_id,
453: mmtt.revision,
454: mmtt.subinventory_code,
455: mmtt.locator_id
456: FROM mtl_material_transactions_temp mmtt
457: WHERE mmtt.transaction_temp_id = p_transaction_id;
458:
459:
460: CURSOR c_mmtt_lpn_pick_load IS

Line 474: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt

470: , mmtt.subinventory_code /*from sub, to select printer*/
471: , abs(nvl(mtlt.secondary_quantity, -- invconv fabdi
472: mmtt.secondary_transaction_quantity)) secondary_quantity
473: , mmtt.secondary_uom_code -- invconv fabdi
474: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt
475: WHERE mtlt.transaction_temp_id(+) = mmtt.transaction_temp_id
476: AND mmtt.transaction_temp_id = p_transaction_id;
477:
478: CURSOR c_mmtt_pregen_lpn IS

Line 481: FROM mtl_material_transactions_temp

477:
478: CURSOR c_mmtt_pregen_lpn IS
479: SELECT lpn_id, subinventory_code, locator_id,--Conf Label ER - Adding organization_id,inventory_item_id,revision
480: organization_id,inventory_item_id,revision
481: FROM mtl_material_transactions_temp
482: WHERE transaction_temp_id = p_transaction_id;
483:
484:
485: CURSOR c_mmtt_get_cart_lpn IS

Line 487: FROM mtl_material_transactions_temp

483:
484:
485: CURSOR c_mmtt_get_cart_lpn IS
486: SELECT cartonization_id
487: FROM mtl_material_transactions_temp
488: WHERE transaction_temp_id = p_transaction_id;
489:
490: -- For business flow code of 33, the MMTT, MTI or MOL id is passed
491: -- Depending on the txn identifier being passed,one of the

Line 568: FROM mtl_material_transactions_temp

564: transaction_uom,
565: transfer_subinventory, transfer_to_location,
566: abs(secondary_transaction_quantity), secondary_uom_code, -- invconv fabdi
567: transaction_source_id -- Conf Label ER
568: FROM mtl_material_transactions_temp
569: WHERE transaction_temp_id = p_transaction_id;
570:
571: -- Bug 3836623
572: -- To prevent printing duplicate labels for cross docking for serialized item

Line 599: FROM mtl_material_transactions_temp mmtt

595: -- for WIP completion, lpn_id is used rather than transfer_lpn_id
596: -- Changed to use c_mmtt_lpn
597: /*CURSOR c_wip_lpn IS
598: SELECT transfer_lpn_id
599: FROM mtl_material_transactions_temp mmtt
600: WHERE mmtt.transaction_temp_id = p_transaction_id;*/
601:
602:
603: CURSOR c_wnd_lpn IS

Line 764: , mtl_material_transactions_temp mmtt

760: , mtlt.supplier_lot_number
761: FROM mtl_parameters mp
762: , mtl_system_items_kfv msik
763: , mtl_transaction_lots_temp mtlt
764: , mtl_material_transactions_temp mmtt
765: , po_hazard_classes poh
766: , mtl_material_statuses_vl mmsv
767: WHERE msik.inventory_item_id = p_item_id
768: AND msik.organization_id = p_org_id

Line 969: , mtl_material_transactions_temp mmtt

965: , mmtt.secondary_uom_code secondary_uom -- invconv fabdi
966: FROM wms_license_plate_numbers plpn
967: , cst_cost_groups ccg
968: , mtl_item_locations milkfv
969: , mtl_material_transactions_temp mmtt
970: -- Bug 4137707, Do not need to include this where clause,
971: -- This will be controlled when opening this cursor
972: --WHERE cartonization_flag = 0 -- non Cartonization Flow
973: WHERE plpn.lpn_id (+) = p_lpn_id

Line 1027: , mtl_material_transactions_temp mmtt

1023: , INV_PROJECT.GET_LOCSEGS(milkfv.inventory_location_id, milkfv.organization_id) locator
1024: , l_secondary_transaction_qty secondary_quantity -- invconv fabdi
1025: , l_secondary_uom_code secondary_uom -- invconv fabdi
1026: FROM wms_packaging_hist wpc
1027: , mtl_material_transactions_temp mmtt
1028: , mtl_system_items msi
1029: , cst_cost_groups ccg
1030: , mtl_item_locations milkfv
1031: -- Bug 4137707, Do not need to include this where clause,

Line 1265: FROM mtl_material_transactions_temp mmtt,

1261:
1262: CURSOR c_order_details IS
1263: SELECT oeol.header_id ,
1264: oeol.line_id
1265: FROM mtl_material_transactions_temp mmtt,
1266: oe_order_lines_all oeol
1267: WHERE oeol.line_id = mmtt.trx_source_line_id
1268: AND mmtt.transaction_temp_id = p_transaction_id ;
1269:

Line 1358: , mtl_material_transactions_temp mmtt

1354: , ppf.full_name requestor
1355: FROM mtl_cycle_count_headers mcch
1356: , mtl_cycle_count_entries mcce
1357: , per_people_f ppf
1358: , mtl_material_transactions_temp mmtt
1359: WHERE mmtt.transaction_temp_id= p_transaction_id
1360: AND mmtt.cycle_count_id = mcce.cycle_count_entry_id
1361: AND mcce.cycle_count_header_id = mcch.cycle_count_header_id
1362: AND ppf.person_id(+) = mcce.counted_by_employee_id_current

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

1471: l_cur_item_id number; -- Item id that is currently being processed in RCV flows
1472:
1473: --Bug# 3739739
1474: l_qty NUMBER;
1475: l_uom MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSACTION_UOM%TYPE := null;
1476:
1477: -- Variable for EPC Generation
1478: -- Added for 11.5.10+ RFID Compliance project
1479: -- Modified in R12

Line 2641: FROM mtl_material_transactions_temp WHERE lpn_id = l_lpn_id AND transaction_temp_id = p_transaction_id;

2637: --Added for bug 7001066 -- Start
2638: IF(p_label_type_info.business_flow_code in (27)) THEN
2639: BEGIN
2640: SELECT inventory_item_id INTO l_cur_item_id
2641: FROM mtl_material_transactions_temp WHERE lpn_id = l_lpn_id AND transaction_temp_id = p_transaction_id;
2642: IF (l_debug = 1) THEN
2643: TRACE('LPN ID :' || l_lpn_id || ' ' || 'Inventory item_id :' || l_cur_item_id);
2644: END IF;
2645: EXCEPTION

Line 2881: FROM mtl_material_transactions_temp mmtt

2877: SELECT mmtt.transaction_action_id , mmtt.subinventory_code ,
2878: mmtt.locator_id ,NVL(mmtt.lpn_id,mmtt.content_lpn_id) ,mmtt.organization_id
2879: INTO l_transaction_action_id , l_src_subinventory_code ,
2880: l_src_locator_id ,l_src_lpn_id , l_src_organization_id
2881: FROM mtl_material_transactions_temp mmtt
2882: WHERE transaction_temp_id = p_transaction_id;
2883: IF l_transaction_action_id IN (inv_globals.G_ACTION_SUBXFR,
2884: inv_globals.G_ACTION_ORGXFR,
2885: inv_globals.G_ACTION_STGXFR,

Line 4752: , p_input_param IN MTL_MATERIAL_TRANSACTIONS_TEMP%ROWTYPE

4748: , x_return_status OUT NOCOPY VARCHAR2
4749: , x_var_content IN LONG DEFAULT NULL
4750: , p_label_type_info IN INV_LABEL.label_type_rec
4751: , p_transaction_id IN NUMBER
4752: , p_input_param IN MTL_MATERIAL_TRANSACTIONS_TEMP%ROWTYPE
4753: , p_transaction_identifier IN NUMBER
4754: ) IS
4755: l_variable_data_tbl INV_LABEL.label_tbl_type;
4756: BEGIN