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 WMS_LICENSE_PLATE_NUMBERS

Line 31: p_lpn_id IN WMS_LICENSE_PLATE_NUMBERS.lpn_id%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,
35: p_costgroup_id IN WMS_LPN_CONTENTS.cost_group_id%TYPE,

Line 32: p_lpn_number IN WMS_LICENSE_PLATE_NUMBERS.license_plate_number%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,
35: p_costgroup_id IN WMS_LPN_CONTENTS.cost_group_id%TYPE,
36: p_project_id IN NUMBER,

Line 33: p_xfr_lpn_id IN WMS_LICENSE_PLATE_NUMBERS.lpn_id%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,
35: p_costgroup_id IN WMS_LPN_CONTENTS.cost_group_id%TYPE,
36: p_project_id IN NUMBER,
37: p_task_id IN NUMBER,

Line 848: FROM wms_license_plate_numbers

844: BEGIN
845: l_msg_data := 'select lpn';
846: SELECT lpn_id
847: INTO l_xfr_lpn_id
848: FROM wms_license_plate_numbers
849: WHERE license_plate_number = tab_input(ind).lpn_number
850: AND parent_lpn_id IS NULL
851: AND lpn_context IN (1,5); -- Bug No 3886482, Pick LPNS with status 'Defined But Not Used'
852: