DBA Data[Home] [Help]

APPS.LOT_SPLIT_DATA_INSERT dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 33: lpn_id WMS_LICENSE_PLATE_NUMBERS.lpn_id%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,
37: project_id NUMBER,

Line 34: lpn_number WMS_LICENSE_PLATE_NUMBERS.license_plate_number%TYPE,

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,
37: project_id NUMBER,
38: task_id NUMBER,

Line 35: xfr_lpn_id WMS_LICENSE_PLATE_NUMBERS.lpn_id%TYPE,

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,
37: project_id NUMBER,
38: task_id NUMBER,
39: transaction_temp_id MTL_MATERIAL_TRANSACTIONS_TEMP.transaction_temp_id%TYPE,

Line 154: p_lpn_id IN WMS_LICENSE_PLATE_NUMBERS.lpn_id%TYPE,

150: p_allowed_units_lookup_code IN MTL_SYSTEM_ITEMS_KFV.allowed_units_lookup_code%TYPE,
151: p_lot_number IN MTL_LOT_NUMBERS.lot_number%TYPE,
152: p_lot_expiration_date IN MTL_LOT_NUMBERS.expiration_date%TYPE,
153: p_total_qty IN MTL_MATERIAL_TRANSACTIONS.transaction_quantity%TYPE,
154: p_lpn_id IN WMS_LICENSE_PLATE_NUMBERS.lpn_id%TYPE,
155: p_lpn_number IN WMS_LICENSE_PLATE_NUMBERS.license_plate_number%TYPE,
156: p_xfr_lpn_id IN WMS_LICENSE_PLATE_NUMBERS.lpn_id%TYPE,
157: p_userid IN NUMBER,
158: p_costgroup_id IN WMS_LPN_CONTENTS.cost_group_id%TYPE,

Line 155: p_lpn_number IN WMS_LICENSE_PLATE_NUMBERS.license_plate_number%TYPE,

151: p_lot_number IN MTL_LOT_NUMBERS.lot_number%TYPE,
152: p_lot_expiration_date IN MTL_LOT_NUMBERS.expiration_date%TYPE,
153: p_total_qty IN MTL_MATERIAL_TRANSACTIONS.transaction_quantity%TYPE,
154: p_lpn_id IN WMS_LICENSE_PLATE_NUMBERS.lpn_id%TYPE,
155: p_lpn_number IN WMS_LICENSE_PLATE_NUMBERS.license_plate_number%TYPE,
156: p_xfr_lpn_id IN WMS_LICENSE_PLATE_NUMBERS.lpn_id%TYPE,
157: p_userid IN NUMBER,
158: p_costgroup_id IN WMS_LPN_CONTENTS.cost_group_id%TYPE,
159: p_project_id IN NUMBER,

Line 156: p_xfr_lpn_id IN WMS_LICENSE_PLATE_NUMBERS.lpn_id%TYPE,

152: p_lot_expiration_date IN MTL_LOT_NUMBERS.expiration_date%TYPE,
153: p_total_qty IN MTL_MATERIAL_TRANSACTIONS.transaction_quantity%TYPE,
154: p_lpn_id IN WMS_LICENSE_PLATE_NUMBERS.lpn_id%TYPE,
155: p_lpn_number IN WMS_LICENSE_PLATE_NUMBERS.license_plate_number%TYPE,
156: p_xfr_lpn_id IN WMS_LICENSE_PLATE_NUMBERS.lpn_id%TYPE,
157: p_userid IN NUMBER,
158: p_costgroup_id IN WMS_LPN_CONTENTS.cost_group_id%TYPE,
159: p_project_id IN NUMBER,
160: p_task_id IN NUMBER,