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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 421: FROM mtl_material_transactions_temp mmtt

417: mmtt.transaction_type_id,
418: mmtt.transaction_action_id,
419: mmtt.transaction_uom --Bug# 3739739
420: -- Bug 2515486: Added transaction_type_id, transaction_action_id, inventory_item_id
421: FROM mtl_material_transactions_temp mmtt
422: WHERE mmtt.transaction_temp_id = p_transaction_id;
423:
424:
425: CURSOR c_mmtt_lpn_pick_load IS

Line 439: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt

435: , mmtt.subinventory_code /*from sub, to select printer*/
436: , abs(nvl(mtlt.secondary_quantity, -- invconv fabdi
437: mmtt.secondary_transaction_quantity)) secondary_quantity
438: , mmtt.secondary_uom_code -- invconv fabdi
439: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt
440: WHERE mtlt.transaction_temp_id(+) = mmtt.transaction_temp_id
441: AND mmtt.transaction_temp_id = p_transaction_id;
442:
443: CURSOR c_mmtt_pregen_lpn IS

Line 445: FROM mtl_material_transactions_temp

441: AND mmtt.transaction_temp_id = p_transaction_id;
442:
443: CURSOR c_mmtt_pregen_lpn IS
444: SELECT lpn_id, subinventory_code, locator_id
445: FROM mtl_material_transactions_temp
446: WHERE transaction_temp_id = p_transaction_id;
447:
448:
449: CURSOR c_mmtt_get_cart_lpn IS

Line 451: FROM mtl_material_transactions_temp

447:
448:
449: CURSOR c_mmtt_get_cart_lpn IS
450: SELECT cartonization_id
451: FROM mtl_material_transactions_temp
452: WHERE transaction_temp_id = p_transaction_id;
453:
454: -- For business flow code of 33, the MMTT, MTI or MOL id is passed
455: -- Depending on the txn identifier being passed,one of the

Line 515: FROM mtl_material_transactions_temp

511: lot_number, revision, abs(transaction_quantity),
512: transaction_uom,
513: transfer_subinventory, transfer_to_location,
514: abs(secondary_transaction_quantity), secondary_uom_code -- invconv fabdi
515: FROM mtl_material_transactions_temp
516: WHERE transaction_temp_id = p_transaction_id;
517:
518: -- Bug 3836623
519: -- To prevent printing duplicate labels for cross docking for serialized item

Line 546: FROM mtl_material_transactions_temp mmtt

542: -- for WIP completion, lpn_id is used rather than transfer_lpn_id
543: -- Changed to use c_mmtt_lpn
544: /*CURSOR c_wip_lpn IS
545: SELECT transfer_lpn_id
546: FROM mtl_material_transactions_temp mmtt
547: WHERE mmtt.transaction_temp_id = p_transaction_id;*/
548:
549:
550: CURSOR c_wnd_lpn IS

Line 800: , mtl_material_transactions_temp mmtt

796: , mmtt.secondary_uom_code secondary_uom -- invconv fabdi
797: FROM wms_license_plate_numbers plpn
798: , cst_cost_groups ccg
799: , mtl_item_locations milkfv
800: , mtl_material_transactions_temp mmtt
801: -- Bug 4137707, Do not need to include this where clause,
802: -- This will be controlled when opening this cursor
803: --WHERE cartonization_flag = 0 -- non Cartonization Flow
804: WHERE plpn.lpn_id (+) = p_lpn_id

Line 853: , mtl_material_transactions_temp mmtt

849: , INV_PROJECT.GET_LOCSEGS(milkfv.inventory_location_id, milkfv.organization_id) locator
850: , l_secondary_transaction_qty secondary_quantity -- invconv fabdi
851: , l_secondary_uom_code secondary_uom -- invconv fabdi
852: FROM wms_packaging_hist wpc
853: , mtl_material_transactions_temp mmtt
854: , mtl_system_items msi
855: , cst_cost_groups ccg
856: , mtl_item_locations milkfv
857: -- Bug 4137707, Do not need to include this where clause,

Line 1038: FROM mtl_material_transactions_temp mmtt,

1034:
1035: CURSOR c_order_details IS
1036: SELECT oeol.header_id ,
1037: oeol.line_id
1038: FROM mtl_material_transactions_temp mmtt,
1039: oe_order_lines_all oeol
1040: WHERE oeol.line_id = mmtt.trx_source_line_id
1041: AND mmtt.transaction_temp_id = p_transaction_id ;
1042:

Line 1130: , mtl_material_transactions_temp mmtt

1126: , ppf.full_name requestor
1127: FROM mtl_cycle_count_headers mcch
1128: , mtl_cycle_count_entries mcce
1129: , per_people_f ppf
1130: , mtl_material_transactions_temp mmtt
1131: WHERE mmtt.transaction_temp_id= p_transaction_id
1132: AND mmtt.cycle_count_id = mcce.cycle_count_entry_id
1133: AND mcce.cycle_count_header_id = mcch.cycle_count_header_id
1134: AND ppf.person_id(+) = mcce.counted_by_employee_id_current ;

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

1224: l_cur_item_id number; -- Item id that is currently being processed in RCV flows
1225:
1226: --Bug# 3739739
1227: l_qty NUMBER;
1228: l_uom MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSACTION_UOM%TYPE := null;
1229:
1230: -- Variable for EPC Generation
1231: -- Added for 11.5.10+ RFID Compliance project
1232: -- Modified in R12

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

1953: --Added for bug 7001066 -- Start
1954: IF(p_label_type_info.business_flow_code in (27)) THEN
1955: BEGIN
1956: SELECT inventory_item_id INTO l_cur_item_id
1957: FROM mtl_material_transactions_temp WHERE lpn_id = l_lpn_id AND transaction_temp_id = p_transaction_id;
1958: IF (l_debug = 1) THEN
1959: TRACE('LPN ID :' || l_lpn_id || ' ' || 'Inventory item_id :' || l_cur_item_id);
1960: END IF;
1961: EXCEPTION

Line 2144: FROM mtl_material_transactions_temp mmtt

2140: SELECT mmtt.transaction_action_id , mmtt.subinventory_code ,
2141: mmtt.locator_id ,NVL(mmtt.lpn_id,mmtt.content_lpn_id) ,mmtt.organization_id
2142: INTO l_transaction_action_id , l_src_subinventory_code ,
2143: l_src_locator_id ,l_src_lpn_id , l_src_organization_id
2144: FROM mtl_material_transactions_temp mmtt
2145: WHERE transaction_temp_id = p_transaction_id;
2146: IF l_transaction_action_id IN (inv_globals.G_ACTION_SUBXFR,
2147: inv_globals.G_ACTION_ORGXFR,
2148: inv_globals.G_ACTION_STGXFR,

Line 3741: , p_input_param IN MTL_MATERIAL_TRANSACTIONS_TEMP%ROWTYPE

3737: , x_return_status OUT NOCOPY VARCHAR2
3738: , x_var_content IN LONG DEFAULT NULL
3739: , p_label_type_info IN INV_LABEL.label_type_rec
3740: , p_transaction_id IN NUMBER
3741: , p_input_param IN MTL_MATERIAL_TRANSACTIONS_TEMP%ROWTYPE
3742: , p_transaction_identifier IN NUMBER
3743: ) IS
3744: l_variable_data_tbl INV_LABEL.label_tbl_type;
3745: BEGIN