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_TRANSACTION_LOTS_TEMP

Line 27: origination_type MTL_TRANSACTION_LOTS_TEMP.origination_type%TYPE, -- Bug #4093379 INVCONV

23: item_shelf_life_days MTL_SYSTEM_ITEMS_KFV.shelf_life_days%TYPE,
24: allowed_units_lookup_code MTL_SYSTEM_ITEMS_KFV.allowed_units_lookup_code%TYPE,
25: lot_number MTL_LOT_NUMBERS.lot_number%TYPE,
26: parent_lot_number MTL_LOT_NUMBERS.parent_lot_number%TYPE, -- Bug #4093379 INVCONV
27: origination_type MTL_TRANSACTION_LOTS_TEMP.origination_type%TYPE, -- Bug #4093379 INVCONV
28: lot_expiration_date MTL_LOT_NUMBERS.expiration_date%TYPE,
29: expiration_action_date MTL_TRANSACTION_LOTS_TEMP.expiration_action_date%TYPE, -- Bug #4093379 INVCONV
30: expiration_action_code MTL_TRANSACTION_LOTS_TEMP.expiration_action_code%TYPE, -- Bug #4093379 INVCONV
31: hold_date MTL_TRANSACTION_LOTS_TEMP.hold_date%TYPE, -- Bug #4093379 INVCONV

Line 29: expiration_action_date MTL_TRANSACTION_LOTS_TEMP.expiration_action_date%TYPE, -- Bug #4093379 INVCONV

25: lot_number MTL_LOT_NUMBERS.lot_number%TYPE,
26: parent_lot_number MTL_LOT_NUMBERS.parent_lot_number%TYPE, -- Bug #4093379 INVCONV
27: origination_type MTL_TRANSACTION_LOTS_TEMP.origination_type%TYPE, -- Bug #4093379 INVCONV
28: lot_expiration_date MTL_LOT_NUMBERS.expiration_date%TYPE,
29: expiration_action_date MTL_TRANSACTION_LOTS_TEMP.expiration_action_date%TYPE, -- Bug #4093379 INVCONV
30: expiration_action_code MTL_TRANSACTION_LOTS_TEMP.expiration_action_code%TYPE, -- Bug #4093379 INVCONV
31: hold_date MTL_TRANSACTION_LOTS_TEMP.hold_date%TYPE, -- Bug #4093379 INVCONV
32: reason_id MTL_TRANSACTION_LOTS_TEMP.reason_id%TYPE, -- Bug #4093379 INVCONV
33: lpn_id WMS_LICENSE_PLATE_NUMBERS.lpn_id%TYPE,

Line 30: expiration_action_code MTL_TRANSACTION_LOTS_TEMP.expiration_action_code%TYPE, -- Bug #4093379 INVCONV

26: parent_lot_number MTL_LOT_NUMBERS.parent_lot_number%TYPE, -- Bug #4093379 INVCONV
27: origination_type MTL_TRANSACTION_LOTS_TEMP.origination_type%TYPE, -- Bug #4093379 INVCONV
28: lot_expiration_date MTL_LOT_NUMBERS.expiration_date%TYPE,
29: expiration_action_date MTL_TRANSACTION_LOTS_TEMP.expiration_action_date%TYPE, -- Bug #4093379 INVCONV
30: expiration_action_code MTL_TRANSACTION_LOTS_TEMP.expiration_action_code%TYPE, -- Bug #4093379 INVCONV
31: hold_date MTL_TRANSACTION_LOTS_TEMP.hold_date%TYPE, -- Bug #4093379 INVCONV
32: reason_id MTL_TRANSACTION_LOTS_TEMP.reason_id%TYPE, -- Bug #4093379 INVCONV
33: lpn_id WMS_LICENSE_PLATE_NUMBERS.lpn_id%TYPE,
34: lpn_number WMS_LICENSE_PLATE_NUMBERS.license_plate_number%TYPE,

Line 31: hold_date MTL_TRANSACTION_LOTS_TEMP.hold_date%TYPE, -- Bug #4093379 INVCONV

27: origination_type MTL_TRANSACTION_LOTS_TEMP.origination_type%TYPE, -- Bug #4093379 INVCONV
28: lot_expiration_date MTL_LOT_NUMBERS.expiration_date%TYPE,
29: expiration_action_date MTL_TRANSACTION_LOTS_TEMP.expiration_action_date%TYPE, -- Bug #4093379 INVCONV
30: expiration_action_code MTL_TRANSACTION_LOTS_TEMP.expiration_action_code%TYPE, -- Bug #4093379 INVCONV
31: hold_date MTL_TRANSACTION_LOTS_TEMP.hold_date%TYPE, -- Bug #4093379 INVCONV
32: reason_id MTL_TRANSACTION_LOTS_TEMP.reason_id%TYPE, -- Bug #4093379 INVCONV
33: lpn_id WMS_LICENSE_PLATE_NUMBERS.lpn_id%TYPE,
34: lpn_number WMS_LICENSE_PLATE_NUMBERS.license_plate_number%TYPE,
35: xfr_lpn_id WMS_LICENSE_PLATE_NUMBERS.lpn_id%TYPE,

Line 32: reason_id MTL_TRANSACTION_LOTS_TEMP.reason_id%TYPE, -- Bug #4093379 INVCONV

28: lot_expiration_date MTL_LOT_NUMBERS.expiration_date%TYPE,
29: expiration_action_date MTL_TRANSACTION_LOTS_TEMP.expiration_action_date%TYPE, -- Bug #4093379 INVCONV
30: expiration_action_code MTL_TRANSACTION_LOTS_TEMP.expiration_action_code%TYPE, -- Bug #4093379 INVCONV
31: hold_date MTL_TRANSACTION_LOTS_TEMP.hold_date%TYPE, -- Bug #4093379 INVCONV
32: reason_id MTL_TRANSACTION_LOTS_TEMP.reason_id%TYPE, -- Bug #4093379 INVCONV
33: lpn_id WMS_LICENSE_PLATE_NUMBERS.lpn_id%TYPE,
34: lpn_number WMS_LICENSE_PLATE_NUMBERS.license_plate_number%TYPE,
35: xfr_lpn_id WMS_LICENSE_PLATE_NUMBERS.lpn_id%TYPE,
36: cost_group_id MTL_MATERIAL_TRANSACTIONS_TEMP.cost_group_id%TYPE,

Line 235: p_origination_type IN MTL_TRANSACTION_LOTS_TEMP.origination_type%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV

231: p_n_attribute10 IN MTL_LOT_NUMBERS.N_ATTRIBUTE10%TYPE,
232: p_sec_transaction_quantity IN MTL_MATERIAL_TRANSACTIONS.secondary_transaction_quantity%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV
233: p_item_secondary_uom_code IN MTL_SYSTEM_ITEMS_KFV.secondary_uom_code%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV
234: p_parent_lot_number IN MTL_LOT_NUMBERS.parent_lot_number%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV
235: p_origination_type IN MTL_TRANSACTION_LOTS_TEMP.origination_type%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV
236: p_expiration_action_date IN MTL_TRANSACTION_LOTS_TEMP.expiration_action_date%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV
237: p_expiration_action_code IN MTL_TRANSACTION_LOTS_TEMP.expiration_action_code%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV
238: p_hold_date IN MTL_TRANSACTION_LOTS_TEMP.hold_date%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV
239: p_reason_id IN MTL_TRANSACTION_LOTS_TEMP.reason_id%TYPE DEFAULT NULL -- Bug #4093379 INVCONV

Line 236: p_expiration_action_date IN MTL_TRANSACTION_LOTS_TEMP.expiration_action_date%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV

232: p_sec_transaction_quantity IN MTL_MATERIAL_TRANSACTIONS.secondary_transaction_quantity%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV
233: p_item_secondary_uom_code IN MTL_SYSTEM_ITEMS_KFV.secondary_uom_code%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV
234: p_parent_lot_number IN MTL_LOT_NUMBERS.parent_lot_number%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV
235: p_origination_type IN MTL_TRANSACTION_LOTS_TEMP.origination_type%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV
236: p_expiration_action_date IN MTL_TRANSACTION_LOTS_TEMP.expiration_action_date%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV
237: p_expiration_action_code IN MTL_TRANSACTION_LOTS_TEMP.expiration_action_code%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV
238: p_hold_date IN MTL_TRANSACTION_LOTS_TEMP.hold_date%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV
239: p_reason_id IN MTL_TRANSACTION_LOTS_TEMP.reason_id%TYPE DEFAULT NULL -- Bug #4093379 INVCONV
240: );

Line 237: p_expiration_action_code IN MTL_TRANSACTION_LOTS_TEMP.expiration_action_code%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV

233: p_item_secondary_uom_code IN MTL_SYSTEM_ITEMS_KFV.secondary_uom_code%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV
234: p_parent_lot_number IN MTL_LOT_NUMBERS.parent_lot_number%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV
235: p_origination_type IN MTL_TRANSACTION_LOTS_TEMP.origination_type%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV
236: p_expiration_action_date IN MTL_TRANSACTION_LOTS_TEMP.expiration_action_date%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV
237: p_expiration_action_code IN MTL_TRANSACTION_LOTS_TEMP.expiration_action_code%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV
238: p_hold_date IN MTL_TRANSACTION_LOTS_TEMP.hold_date%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV
239: p_reason_id IN MTL_TRANSACTION_LOTS_TEMP.reason_id%TYPE DEFAULT NULL -- Bug #4093379 INVCONV
240: );
241: --

Line 238: p_hold_date IN MTL_TRANSACTION_LOTS_TEMP.hold_date%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV

234: p_parent_lot_number IN MTL_LOT_NUMBERS.parent_lot_number%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV
235: p_origination_type IN MTL_TRANSACTION_LOTS_TEMP.origination_type%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV
236: p_expiration_action_date IN MTL_TRANSACTION_LOTS_TEMP.expiration_action_date%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV
237: p_expiration_action_code IN MTL_TRANSACTION_LOTS_TEMP.expiration_action_code%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV
238: p_hold_date IN MTL_TRANSACTION_LOTS_TEMP.hold_date%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV
239: p_reason_id IN MTL_TRANSACTION_LOTS_TEMP.reason_id%TYPE DEFAULT NULL -- Bug #4093379 INVCONV
240: );
241: --
242: PROCEDURE insert_mmtt(p_total_qty IN NUMBER,

Line 239: p_reason_id IN MTL_TRANSACTION_LOTS_TEMP.reason_id%TYPE DEFAULT NULL -- Bug #4093379 INVCONV

235: p_origination_type IN MTL_TRANSACTION_LOTS_TEMP.origination_type%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV
236: p_expiration_action_date IN MTL_TRANSACTION_LOTS_TEMP.expiration_action_date%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV
237: p_expiration_action_code IN MTL_TRANSACTION_LOTS_TEMP.expiration_action_code%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV
238: p_hold_date IN MTL_TRANSACTION_LOTS_TEMP.hold_date%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV
239: p_reason_id IN MTL_TRANSACTION_LOTS_TEMP.reason_id%TYPE DEFAULT NULL -- Bug #4093379 INVCONV
240: );
241: --
242: PROCEDURE insert_mmtt(p_total_qty IN NUMBER,
243: p_transaction_type_id IN NUMBER,