DBA Data[Home] [Help]

APPS.WMS_SEARCH_ORDER_GLOBALS_PVT dependencies on WMS_TRANSACTIONS_TEMP

Line 112: revision wms_transactions_temp.revision%TYPE,

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,

Line 113: quantity wms_transactions_temp.transaction_quantity%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,

Line 114: lot_number wms_transactions_temp.lot_number%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,

Line 115: lot_expiration_date wms_transactions_temp.lot_expiration_date%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,

Line 116: serial_number wms_transactions_temp.serial_number%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,

Line 117: subinventory_code wms_transactions_temp.from_subinventory_code%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),

Line 118: locator_id wms_transactions_temp.from_locator_id%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),
122: remaining_qty wms_transactions_temp.transaction_quantity%TYPE,

Line 119: lpn_id wms_transactions_temp.lpn_id%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,

Line 120: cost_group_id wms_transactions_temp.to_cost_group_id%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,

Line 122: remaining_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,

Line 123: ATT_qty wms_transactions_temp.transaction_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,

Line 124: suggested_qty wms_transactions_temp.transaction_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,

Line 126: secondary_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),

Line 127: secondary_remaining_qty wms_transactions_temp.secondary_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),
131: grade_code VARCHAR2(150),

Line 128: secondary_att_qty wms_transactions_temp.secondary_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),
132: -- End of LG convergence

Line 129: secondary_suggested_qty wms_transactions_temp.secondary_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
133: same_subinv_loc_flag VARCHAR2(1),