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.LOT_SPLIT_DATA_INSERT dependencies on MTL_MATERIAL_TRANSACTIONS

Line 16: p_transaction_quantity IN MTL_MATERIAL_TRANSACTIONS.transaction_quantity%TYPE,

12: p_revision IN MTL_ITEM_REVISIONS.revision%TYPE,
13: p_organization_id IN MTL_PARAMETERS.organization_id%TYPE,
14: p_subinventory_code IN MTL_SECONDARY_INVENTORIES.secondary_inventory_name%TYPE,
15: p_locator_id IN MTL_ITEM_LOCATIONS.inventory_location_id%TYPE,
16: p_transaction_quantity IN MTL_MATERIAL_TRANSACTIONS.transaction_quantity%TYPE,
17: p_primary_quantity IN MTL_MATERIAL_TRANSACTIONS.primary_quantity%TYPE,
18: p_transaction_uom IN MTL_UNITS_OF_MEASURE.uom_code%TYPE,
19: p_item_description IN MTL_SYSTEM_ITEMS_KFV.description%TYPE,
20: p_item_location_control_code IN MTL_SYSTEM_ITEMS_KFV.location_control_code%TYPE,

Line 17: p_primary_quantity IN MTL_MATERIAL_TRANSACTIONS.primary_quantity%TYPE,

13: p_organization_id IN MTL_PARAMETERS.organization_id%TYPE,
14: p_subinventory_code IN MTL_SECONDARY_INVENTORIES.secondary_inventory_name%TYPE,
15: p_locator_id IN MTL_ITEM_LOCATIONS.inventory_location_id%TYPE,
16: p_transaction_quantity IN MTL_MATERIAL_TRANSACTIONS.transaction_quantity%TYPE,
17: p_primary_quantity IN MTL_MATERIAL_TRANSACTIONS.primary_quantity%TYPE,
18: p_transaction_uom IN MTL_UNITS_OF_MEASURE.uom_code%TYPE,
19: p_item_description IN MTL_SYSTEM_ITEMS_KFV.description%TYPE,
20: p_item_location_control_code IN MTL_SYSTEM_ITEMS_KFV.location_control_code%TYPE,
21: p_item_restrict_subinv_code IN MTL_SYSTEM_ITEMS_KFV.restrict_subinventories_code%TYPE,

Line 30: p_total_qty IN MTL_MATERIAL_TRANSACTIONS.transaction_quantity%TYPE,

26: p_item_shelf_life_days IN MTL_SYSTEM_ITEMS_KFV.shelf_life_days%TYPE,
27: p_allowed_units_lookup_code IN MTL_SYSTEM_ITEMS_KFV.allowed_units_lookup_code%TYPE,
28: p_lot_number IN MTL_LOT_NUMBERS.lot_number%TYPE,
29: p_lot_expiration_date IN MTL_LOT_NUMBERS.expiration_date%TYPE,
30: p_total_qty IN MTL_MATERIAL_TRANSACTIONS.transaction_quantity%TYPE,
31: p_lpn_id IN WMS_LICENSE_PLATE_NUMBERS.lpn_id%TYPE,
32: p_lpn_number IN WMS_LICENSE_PLATE_NUMBERS.license_plate_number%TYPE,
33: p_xfr_lpn_id IN WMS_LICENSE_PLATE_NUMBERS.lpn_id%TYPE,
34: p_userid IN NUMBER,

Line 109: p_sec_transaction_quantity IN MTL_MATERIAL_TRANSACTIONS.secondary_transaction_quantity%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV

105: p_n_attribute7 IN MTL_LOT_NUMBERS.N_ATTRIBUTE7%TYPE,
106: p_n_attribute8 IN MTL_LOT_NUMBERS.N_ATTRIBUTE8%TYPE,
107: p_n_attribute9 IN MTL_LOT_NUMBERS.N_ATTRIBUTE9%TYPE,
108: p_n_attribute10 IN MTL_LOT_NUMBERS.N_ATTRIBUTE10%TYPE,
109: p_sec_transaction_quantity IN MTL_MATERIAL_TRANSACTIONS.secondary_transaction_quantity%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV
110: p_item_secondary_uom_code IN MTL_SYSTEM_ITEMS_KFV.secondary_uom_code%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV
111: p_parent_lot_number IN MTL_LOT_NUMBERS.parent_lot_number%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV
112: p_origination_type IN MTL_TRANSACTION_LOTS_TEMP.origination_type%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV
113: p_expiration_action_date IN MTL_TRANSACTION_LOTS_TEMP.expiration_action_date%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV

Line 361: l_msg_data := 'mtl_material_transactions_temp';

357: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
358: BEGIN
359: x_return_status := FND_API.G_RET_STS_SUCCESS;
360: BEGIN
361: l_msg_data := 'mtl_material_transactions_temp';
362: INSERT
363: INTO mtl_material_transactions_temp
364: (transaction_header_id
365: ,transaction_temp_id

Line 363: INTO mtl_material_transactions_temp

359: x_return_status := FND_API.G_RET_STS_SUCCESS;
360: BEGIN
361: l_msg_data := 'mtl_material_transactions_temp';
362: INSERT
363: INTO mtl_material_transactions_temp
364: (transaction_header_id
365: ,transaction_temp_id
366: ,transaction_mode
367: ,lock_flag

Line 708: SELECT mtl_material_transactions_s.NEXTVAL

704: END IF;
705: x_return_status := FND_API.G_RET_STS_SUCCESS;
706:
707: l_msg_data := 'select header_id from dual';
708: SELECT mtl_material_transactions_s.NEXTVAL
709: INTO l_header_id
710: FROM DUAL;
711: g_header_id := l_header_id;
712:

Line 714: SELECT mtl_material_transactions_s.NEXTVAL

710: FROM DUAL;
711: g_header_id := l_header_id;
712:
713: l_msg_data := 'select batch_id from dual';
714: SELECT mtl_material_transactions_s.NEXTVAL
715: INTO l_batch_id
716: FROM DUAL;
717:
718: l_msg_data := 'select acct_period_id from org_acct_periods';

Line 830: SELECT mtl_material_transactions_s.NEXTVAL

826: l_msg_data := 'FOR ind IN 1..tab_index';
827: FOR ind IN 1..tab_index
828: LOOP
829: l_msg_data := 'Next temp_id ';
830: SELECT mtl_material_transactions_s.NEXTVAL
831: INTO l_temp_id
832: FROM DUAL;
833:
834: tab_input(ind).transaction_temp_id := l_temp_id;

Line 958: SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL

954: END IF;
955:
956: IF (p_transaction_type_id = inv_globals.G_type_inv_lot_translate OR
957: p_transaction_type_id = inv_globals.G_type_inv_lot_split) THEN
958: SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL
959: INTO tab_input(ind).transaction_batch_seq
960: FROM DUAL;
961: END IF;
962:

Line 968: SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL

964:
965: IF ( p_transaction_type_id = inv_globals.G_type_inv_lot_merge) THEN
966: FOR ind IN REVERSE 1..tab_index
967: LOOP
968: SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL
969: INTO tab_input(ind).transaction_batch_seq
970: FROM DUAL;
971: END LOOP;
972: END IF;