108: -- CG_comingle_flag Default NULL, Success - 'Y' Failure - 'N'
109:
110: TYPE pre_suggestions_record IS RECORD
111: (
112: revision wms_transactions_temp.revision%TYPE,
113: quantity wms_transactions_temp.transaction_quantity%TYPE,
114: lot_number wms_transactions_temp.lot_number%TYPE,
115: lot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE,
116: serial_number wms_transactions_temp.serial_number%TYPE,
109:
110: TYPE pre_suggestions_record IS RECORD
111: (
112: revision wms_transactions_temp.revision%TYPE,
113: quantity wms_transactions_temp.transaction_quantity%TYPE,
114: lot_number wms_transactions_temp.lot_number%TYPE,
115: lot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE,
116: serial_number wms_transactions_temp.serial_number%TYPE,
117: subinventory_code wms_transactions_temp.from_subinventory_code%TYPE,
110: TYPE pre_suggestions_record IS RECORD
111: (
112: revision wms_transactions_temp.revision%TYPE,
113: quantity wms_transactions_temp.transaction_quantity%TYPE,
114: lot_number wms_transactions_temp.lot_number%TYPE,
115: lot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE,
116: serial_number wms_transactions_temp.serial_number%TYPE,
117: subinventory_code wms_transactions_temp.from_subinventory_code%TYPE,
118: locator_id wms_transactions_temp.from_locator_id%TYPE,
111: (
112: revision wms_transactions_temp.revision%TYPE,
113: quantity wms_transactions_temp.transaction_quantity%TYPE,
114: lot_number wms_transactions_temp.lot_number%TYPE,
115: lot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE,
116: serial_number wms_transactions_temp.serial_number%TYPE,
117: subinventory_code wms_transactions_temp.from_subinventory_code%TYPE,
118: locator_id wms_transactions_temp.from_locator_id%TYPE,
119: lpn_id wms_transactions_temp.lpn_id%TYPE,
112: revision wms_transactions_temp.revision%TYPE,
113: quantity wms_transactions_temp.transaction_quantity%TYPE,
114: lot_number wms_transactions_temp.lot_number%TYPE,
115: lot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE,
116: serial_number wms_transactions_temp.serial_number%TYPE,
117: subinventory_code wms_transactions_temp.from_subinventory_code%TYPE,
118: locator_id wms_transactions_temp.from_locator_id%TYPE,
119: lpn_id wms_transactions_temp.lpn_id%TYPE,
120: cost_group_id wms_transactions_temp.to_cost_group_id%TYPE,
113: quantity wms_transactions_temp.transaction_quantity%TYPE,
114: lot_number wms_transactions_temp.lot_number%TYPE,
115: lot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE,
116: serial_number wms_transactions_temp.serial_number%TYPE,
117: subinventory_code wms_transactions_temp.from_subinventory_code%TYPE,
118: locator_id wms_transactions_temp.from_locator_id%TYPE,
119: lpn_id wms_transactions_temp.lpn_id%TYPE,
120: cost_group_id wms_transactions_temp.to_cost_group_id%TYPE,
121: uom_code VARCHAR2(3),
114: lot_number wms_transactions_temp.lot_number%TYPE,
115: lot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE,
116: serial_number wms_transactions_temp.serial_number%TYPE,
117: subinventory_code wms_transactions_temp.from_subinventory_code%TYPE,
118: locator_id wms_transactions_temp.from_locator_id%TYPE,
119: lpn_id wms_transactions_temp.lpn_id%TYPE,
120: cost_group_id wms_transactions_temp.to_cost_group_id%TYPE,
121: uom_code VARCHAR2(3),
122: remaining_qty wms_transactions_temp.transaction_quantity%TYPE,
115: lot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE,
116: serial_number wms_transactions_temp.serial_number%TYPE,
117: subinventory_code wms_transactions_temp.from_subinventory_code%TYPE,
118: locator_id wms_transactions_temp.from_locator_id%TYPE,
119: lpn_id wms_transactions_temp.lpn_id%TYPE,
120: cost_group_id wms_transactions_temp.to_cost_group_id%TYPE,
121: uom_code VARCHAR2(3),
122: remaining_qty wms_transactions_temp.transaction_quantity%TYPE,
123: ATT_qty wms_transactions_temp.transaction_quantity%TYPE,
116: serial_number wms_transactions_temp.serial_number%TYPE,
117: subinventory_code wms_transactions_temp.from_subinventory_code%TYPE,
118: locator_id wms_transactions_temp.from_locator_id%TYPE,
119: lpn_id wms_transactions_temp.lpn_id%TYPE,
120: cost_group_id wms_transactions_temp.to_cost_group_id%TYPE,
121: uom_code VARCHAR2(3),
122: remaining_qty wms_transactions_temp.transaction_quantity%TYPE,
123: ATT_qty wms_transactions_temp.transaction_quantity%TYPE,
124: suggested_qty wms_transactions_temp.transaction_quantity%TYPE,
118: locator_id wms_transactions_temp.from_locator_id%TYPE,
119: lpn_id wms_transactions_temp.lpn_id%TYPE,
120: cost_group_id wms_transactions_temp.to_cost_group_id%TYPE,
121: uom_code VARCHAR2(3),
122: remaining_qty wms_transactions_temp.transaction_quantity%TYPE,
123: ATT_qty wms_transactions_temp.transaction_quantity%TYPE,
124: suggested_qty wms_transactions_temp.transaction_quantity%TYPE,
125: -- LG convergence added
126: secondary_qty wms_transactions_temp.secondary_quantity%TYPE,
119: lpn_id wms_transactions_temp.lpn_id%TYPE,
120: cost_group_id wms_transactions_temp.to_cost_group_id%TYPE,
121: uom_code VARCHAR2(3),
122: remaining_qty wms_transactions_temp.transaction_quantity%TYPE,
123: ATT_qty wms_transactions_temp.transaction_quantity%TYPE,
124: suggested_qty wms_transactions_temp.transaction_quantity%TYPE,
125: -- LG convergence added
126: secondary_qty wms_transactions_temp.secondary_quantity%TYPE,
127: secondary_remaining_qty wms_transactions_temp.secondary_quantity%TYPE,
120: cost_group_id wms_transactions_temp.to_cost_group_id%TYPE,
121: uom_code VARCHAR2(3),
122: remaining_qty wms_transactions_temp.transaction_quantity%TYPE,
123: ATT_qty wms_transactions_temp.transaction_quantity%TYPE,
124: suggested_qty wms_transactions_temp.transaction_quantity%TYPE,
125: -- LG convergence added
126: secondary_qty wms_transactions_temp.secondary_quantity%TYPE,
127: secondary_remaining_qty wms_transactions_temp.secondary_quantity%TYPE,
128: secondary_att_qty wms_transactions_temp.secondary_quantity%TYPE,
122: remaining_qty wms_transactions_temp.transaction_quantity%TYPE,
123: ATT_qty wms_transactions_temp.transaction_quantity%TYPE,
124: suggested_qty wms_transactions_temp.transaction_quantity%TYPE,
125: -- LG convergence added
126: secondary_qty wms_transactions_temp.secondary_quantity%TYPE,
127: secondary_remaining_qty wms_transactions_temp.secondary_quantity%TYPE,
128: secondary_att_qty wms_transactions_temp.secondary_quantity%TYPE,
129: secondary_suggested_qty wms_transactions_temp.secondary_quantity%TYPE,
130: secondary_uom_code VARCHAR2(3),
123: ATT_qty wms_transactions_temp.transaction_quantity%TYPE,
124: suggested_qty wms_transactions_temp.transaction_quantity%TYPE,
125: -- LG convergence added
126: secondary_qty wms_transactions_temp.secondary_quantity%TYPE,
127: secondary_remaining_qty wms_transactions_temp.secondary_quantity%TYPE,
128: secondary_att_qty wms_transactions_temp.secondary_quantity%TYPE,
129: secondary_suggested_qty wms_transactions_temp.secondary_quantity%TYPE,
130: secondary_uom_code VARCHAR2(3),
131: grade_code VARCHAR2(150),
124: suggested_qty wms_transactions_temp.transaction_quantity%TYPE,
125: -- LG convergence added
126: secondary_qty wms_transactions_temp.secondary_quantity%TYPE,
127: secondary_remaining_qty wms_transactions_temp.secondary_quantity%TYPE,
128: secondary_att_qty wms_transactions_temp.secondary_quantity%TYPE,
129: secondary_suggested_qty wms_transactions_temp.secondary_quantity%TYPE,
130: secondary_uom_code VARCHAR2(3),
131: grade_code VARCHAR2(150),
132: -- End of LG convergence
125: -- LG convergence added
126: secondary_qty wms_transactions_temp.secondary_quantity%TYPE,
127: secondary_remaining_qty wms_transactions_temp.secondary_quantity%TYPE,
128: secondary_att_qty wms_transactions_temp.secondary_quantity%TYPE,
129: secondary_suggested_qty wms_transactions_temp.secondary_quantity%TYPE,
130: secondary_uom_code VARCHAR2(3),
131: grade_code VARCHAR2(150),
132: -- End of LG convergence
133: same_subinv_loc_flag VARCHAR2(1),