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.WMS_STRATEGY_UPGRADE_PVT dependencies on WMS_SELECTION_CRITERIA_TXN

Line 13: -- WMS_SELECTION_CRITERIA_TXN

9: --
10: -- API name : Upgrade Script for Strategy search order / Strategy Assignments
11: -- Type : Private
12: -- Function : Convert each strategy assignment record into a record in the new table
13: -- WMS_SELECTION_CRITERIA_TXN
14: --
15: --
16: --
17: --

Line 71: from wms_selection_criteria_txn;

67:
68:
69: Cursor C_wsct is
70: select count(sequence_number)
71: from wms_selection_criteria_txn;
72:
73:
74:
75: TYPE l_rec is RECORD

Line 107: l_stg_assignment_id wms_selection_criteria_txn.stg_assignment_id%type;

103:
104: ---local variables
105:
106:
107: l_stg_assignment_id wms_selection_criteria_txn.stg_assignment_id%type;
108: l_sequence_number wms_selection_criteria_txn.sequence_number%type;
109: l_rule_type_code wms_selection_criteria_txn.rule_type_code%type;
110: l_return_type_code wms_selection_criteria_txn.return_type_code%type;
111: l_return_type_id wms_selection_criteria_txn.return_type_id%type;

Line 108: l_sequence_number wms_selection_criteria_txn.sequence_number%type;

104: ---local variables
105:
106:
107: l_stg_assignment_id wms_selection_criteria_txn.stg_assignment_id%type;
108: l_sequence_number wms_selection_criteria_txn.sequence_number%type;
109: l_rule_type_code wms_selection_criteria_txn.rule_type_code%type;
110: l_return_type_code wms_selection_criteria_txn.return_type_code%type;
111: l_return_type_id wms_selection_criteria_txn.return_type_id%type;
112: l_enabled_flag wms_selection_criteria_txn.enabled_flag%type;

Line 109: l_rule_type_code wms_selection_criteria_txn.rule_type_code%type;

105:
106:
107: l_stg_assignment_id wms_selection_criteria_txn.stg_assignment_id%type;
108: l_sequence_number wms_selection_criteria_txn.sequence_number%type;
109: l_rule_type_code wms_selection_criteria_txn.rule_type_code%type;
110: l_return_type_code wms_selection_criteria_txn.return_type_code%type;
111: l_return_type_id wms_selection_criteria_txn.return_type_id%type;
112: l_enabled_flag wms_selection_criteria_txn.enabled_flag%type;
113: l_date_type_code wms_selection_criteria_txn.date_type_code%type;

Line 110: l_return_type_code wms_selection_criteria_txn.return_type_code%type;

106:
107: l_stg_assignment_id wms_selection_criteria_txn.stg_assignment_id%type;
108: l_sequence_number wms_selection_criteria_txn.sequence_number%type;
109: l_rule_type_code wms_selection_criteria_txn.rule_type_code%type;
110: l_return_type_code wms_selection_criteria_txn.return_type_code%type;
111: l_return_type_id wms_selection_criteria_txn.return_type_id%type;
112: l_enabled_flag wms_selection_criteria_txn.enabled_flag%type;
113: l_date_type_code wms_selection_criteria_txn.date_type_code%type;
114: l_date_type_from wms_selection_criteria_txn.date_type_from%type;

Line 111: l_return_type_id wms_selection_criteria_txn.return_type_id%type;

107: l_stg_assignment_id wms_selection_criteria_txn.stg_assignment_id%type;
108: l_sequence_number wms_selection_criteria_txn.sequence_number%type;
109: l_rule_type_code wms_selection_criteria_txn.rule_type_code%type;
110: l_return_type_code wms_selection_criteria_txn.return_type_code%type;
111: l_return_type_id wms_selection_criteria_txn.return_type_id%type;
112: l_enabled_flag wms_selection_criteria_txn.enabled_flag%type;
113: l_date_type_code wms_selection_criteria_txn.date_type_code%type;
114: l_date_type_from wms_selection_criteria_txn.date_type_from%type;
115: l_date_type_to wms_selection_criteria_txn.date_type_to%type;

Line 112: l_enabled_flag wms_selection_criteria_txn.enabled_flag%type;

108: l_sequence_number wms_selection_criteria_txn.sequence_number%type;
109: l_rule_type_code wms_selection_criteria_txn.rule_type_code%type;
110: l_return_type_code wms_selection_criteria_txn.return_type_code%type;
111: l_return_type_id wms_selection_criteria_txn.return_type_id%type;
112: l_enabled_flag wms_selection_criteria_txn.enabled_flag%type;
113: l_date_type_code wms_selection_criteria_txn.date_type_code%type;
114: l_date_type_from wms_selection_criteria_txn.date_type_from%type;
115: l_date_type_to wms_selection_criteria_txn.date_type_to%type;
116: l_date_type_lookup_type wms_selection_criteria_txn.date_type_lookup_type%type;

Line 113: l_date_type_code wms_selection_criteria_txn.date_type_code%type;

109: l_rule_type_code wms_selection_criteria_txn.rule_type_code%type;
110: l_return_type_code wms_selection_criteria_txn.return_type_code%type;
111: l_return_type_id wms_selection_criteria_txn.return_type_id%type;
112: l_enabled_flag wms_selection_criteria_txn.enabled_flag%type;
113: l_date_type_code wms_selection_criteria_txn.date_type_code%type;
114: l_date_type_from wms_selection_criteria_txn.date_type_from%type;
115: l_date_type_to wms_selection_criteria_txn.date_type_to%type;
116: l_date_type_lookup_type wms_selection_criteria_txn.date_type_lookup_type%type;
117: l_effective_from wms_selection_criteria_txn.effective_from%type;

Line 114: l_date_type_from wms_selection_criteria_txn.date_type_from%type;

110: l_return_type_code wms_selection_criteria_txn.return_type_code%type;
111: l_return_type_id wms_selection_criteria_txn.return_type_id%type;
112: l_enabled_flag wms_selection_criteria_txn.enabled_flag%type;
113: l_date_type_code wms_selection_criteria_txn.date_type_code%type;
114: l_date_type_from wms_selection_criteria_txn.date_type_from%type;
115: l_date_type_to wms_selection_criteria_txn.date_type_to%type;
116: l_date_type_lookup_type wms_selection_criteria_txn.date_type_lookup_type%type;
117: l_effective_from wms_selection_criteria_txn.effective_from%type;
118: l_effective_to wms_selection_criteria_txn.effective_to%type;

Line 115: l_date_type_to wms_selection_criteria_txn.date_type_to%type;

111: l_return_type_id wms_selection_criteria_txn.return_type_id%type;
112: l_enabled_flag wms_selection_criteria_txn.enabled_flag%type;
113: l_date_type_code wms_selection_criteria_txn.date_type_code%type;
114: l_date_type_from wms_selection_criteria_txn.date_type_from%type;
115: l_date_type_to wms_selection_criteria_txn.date_type_to%type;
116: l_date_type_lookup_type wms_selection_criteria_txn.date_type_lookup_type%type;
117: l_effective_from wms_selection_criteria_txn.effective_from%type;
118: l_effective_to wms_selection_criteria_txn.effective_to%type;
119: l_from_organization_id wms_selection_criteria_txn.from_organization_id%type;

Line 116: l_date_type_lookup_type wms_selection_criteria_txn.date_type_lookup_type%type;

112: l_enabled_flag wms_selection_criteria_txn.enabled_flag%type;
113: l_date_type_code wms_selection_criteria_txn.date_type_code%type;
114: l_date_type_from wms_selection_criteria_txn.date_type_from%type;
115: l_date_type_to wms_selection_criteria_txn.date_type_to%type;
116: l_date_type_lookup_type wms_selection_criteria_txn.date_type_lookup_type%type;
117: l_effective_from wms_selection_criteria_txn.effective_from%type;
118: l_effective_to wms_selection_criteria_txn.effective_to%type;
119: l_from_organization_id wms_selection_criteria_txn.from_organization_id%type;
120: l_from_subinventory_name wms_selection_criteria_txn.from_subinventory_name%type;

Line 117: l_effective_from wms_selection_criteria_txn.effective_from%type;

113: l_date_type_code wms_selection_criteria_txn.date_type_code%type;
114: l_date_type_from wms_selection_criteria_txn.date_type_from%type;
115: l_date_type_to wms_selection_criteria_txn.date_type_to%type;
116: l_date_type_lookup_type wms_selection_criteria_txn.date_type_lookup_type%type;
117: l_effective_from wms_selection_criteria_txn.effective_from%type;
118: l_effective_to wms_selection_criteria_txn.effective_to%type;
119: l_from_organization_id wms_selection_criteria_txn.from_organization_id%type;
120: l_from_subinventory_name wms_selection_criteria_txn.from_subinventory_name%type;
121: l_to_organization_id wms_selection_criteria_txn.to_organization_id%type;

Line 118: l_effective_to wms_selection_criteria_txn.effective_to%type;

114: l_date_type_from wms_selection_criteria_txn.date_type_from%type;
115: l_date_type_to wms_selection_criteria_txn.date_type_to%type;
116: l_date_type_lookup_type wms_selection_criteria_txn.date_type_lookup_type%type;
117: l_effective_from wms_selection_criteria_txn.effective_from%type;
118: l_effective_to wms_selection_criteria_txn.effective_to%type;
119: l_from_organization_id wms_selection_criteria_txn.from_organization_id%type;
120: l_from_subinventory_name wms_selection_criteria_txn.from_subinventory_name%type;
121: l_to_organization_id wms_selection_criteria_txn.to_organization_id%type;
122: l_to_subinventory_name wms_selection_criteria_txn.to_subinventory_name%type;

Line 119: l_from_organization_id wms_selection_criteria_txn.from_organization_id%type;

115: l_date_type_to wms_selection_criteria_txn.date_type_to%type;
116: l_date_type_lookup_type wms_selection_criteria_txn.date_type_lookup_type%type;
117: l_effective_from wms_selection_criteria_txn.effective_from%type;
118: l_effective_to wms_selection_criteria_txn.effective_to%type;
119: l_from_organization_id wms_selection_criteria_txn.from_organization_id%type;
120: l_from_subinventory_name wms_selection_criteria_txn.from_subinventory_name%type;
121: l_to_organization_id wms_selection_criteria_txn.to_organization_id%type;
122: l_to_subinventory_name wms_selection_criteria_txn.to_subinventory_name%type;
123: l_customer_id wms_selection_criteria_txn.customer_id%type;

Line 120: l_from_subinventory_name wms_selection_criteria_txn.from_subinventory_name%type;

116: l_date_type_lookup_type wms_selection_criteria_txn.date_type_lookup_type%type;
117: l_effective_from wms_selection_criteria_txn.effective_from%type;
118: l_effective_to wms_selection_criteria_txn.effective_to%type;
119: l_from_organization_id wms_selection_criteria_txn.from_organization_id%type;
120: l_from_subinventory_name wms_selection_criteria_txn.from_subinventory_name%type;
121: l_to_organization_id wms_selection_criteria_txn.to_organization_id%type;
122: l_to_subinventory_name wms_selection_criteria_txn.to_subinventory_name%type;
123: l_customer_id wms_selection_criteria_txn.customer_id%type;
124: l_freight_code wms_selection_criteria_txn.freight_code%type;

Line 121: l_to_organization_id wms_selection_criteria_txn.to_organization_id%type;

117: l_effective_from wms_selection_criteria_txn.effective_from%type;
118: l_effective_to wms_selection_criteria_txn.effective_to%type;
119: l_from_organization_id wms_selection_criteria_txn.from_organization_id%type;
120: l_from_subinventory_name wms_selection_criteria_txn.from_subinventory_name%type;
121: l_to_organization_id wms_selection_criteria_txn.to_organization_id%type;
122: l_to_subinventory_name wms_selection_criteria_txn.to_subinventory_name%type;
123: l_customer_id wms_selection_criteria_txn.customer_id%type;
124: l_freight_code wms_selection_criteria_txn.freight_code%type;
125: l_inventory_item_id wms_selection_criteria_txn.inventory_item_id%type;

Line 122: l_to_subinventory_name wms_selection_criteria_txn.to_subinventory_name%type;

118: l_effective_to wms_selection_criteria_txn.effective_to%type;
119: l_from_organization_id wms_selection_criteria_txn.from_organization_id%type;
120: l_from_subinventory_name wms_selection_criteria_txn.from_subinventory_name%type;
121: l_to_organization_id wms_selection_criteria_txn.to_organization_id%type;
122: l_to_subinventory_name wms_selection_criteria_txn.to_subinventory_name%type;
123: l_customer_id wms_selection_criteria_txn.customer_id%type;
124: l_freight_code wms_selection_criteria_txn.freight_code%type;
125: l_inventory_item_id wms_selection_criteria_txn.inventory_item_id%type;
126: l_item_type wms_selection_criteria_txn.item_type%type;

Line 123: l_customer_id wms_selection_criteria_txn.customer_id%type;

119: l_from_organization_id wms_selection_criteria_txn.from_organization_id%type;
120: l_from_subinventory_name wms_selection_criteria_txn.from_subinventory_name%type;
121: l_to_organization_id wms_selection_criteria_txn.to_organization_id%type;
122: l_to_subinventory_name wms_selection_criteria_txn.to_subinventory_name%type;
123: l_customer_id wms_selection_criteria_txn.customer_id%type;
124: l_freight_code wms_selection_criteria_txn.freight_code%type;
125: l_inventory_item_id wms_selection_criteria_txn.inventory_item_id%type;
126: l_item_type wms_selection_criteria_txn.item_type%type;
127: l_assignment_group_id wms_selection_criteria_txn.assignment_group_id%type;

Line 124: l_freight_code wms_selection_criteria_txn.freight_code%type;

120: l_from_subinventory_name wms_selection_criteria_txn.from_subinventory_name%type;
121: l_to_organization_id wms_selection_criteria_txn.to_organization_id%type;
122: l_to_subinventory_name wms_selection_criteria_txn.to_subinventory_name%type;
123: l_customer_id wms_selection_criteria_txn.customer_id%type;
124: l_freight_code wms_selection_criteria_txn.freight_code%type;
125: l_inventory_item_id wms_selection_criteria_txn.inventory_item_id%type;
126: l_item_type wms_selection_criteria_txn.item_type%type;
127: l_assignment_group_id wms_selection_criteria_txn.assignment_group_id%type;
128: l_abc_class_id wms_selection_criteria_txn.abc_class_id%type;

Line 125: l_inventory_item_id wms_selection_criteria_txn.inventory_item_id%type;

121: l_to_organization_id wms_selection_criteria_txn.to_organization_id%type;
122: l_to_subinventory_name wms_selection_criteria_txn.to_subinventory_name%type;
123: l_customer_id wms_selection_criteria_txn.customer_id%type;
124: l_freight_code wms_selection_criteria_txn.freight_code%type;
125: l_inventory_item_id wms_selection_criteria_txn.inventory_item_id%type;
126: l_item_type wms_selection_criteria_txn.item_type%type;
127: l_assignment_group_id wms_selection_criteria_txn.assignment_group_id%type;
128: l_abc_class_id wms_selection_criteria_txn.abc_class_id%type;
129: l_category_set_id wms_selection_criteria_txn.category_set_id%type;

Line 126: l_item_type wms_selection_criteria_txn.item_type%type;

122: l_to_subinventory_name wms_selection_criteria_txn.to_subinventory_name%type;
123: l_customer_id wms_selection_criteria_txn.customer_id%type;
124: l_freight_code wms_selection_criteria_txn.freight_code%type;
125: l_inventory_item_id wms_selection_criteria_txn.inventory_item_id%type;
126: l_item_type wms_selection_criteria_txn.item_type%type;
127: l_assignment_group_id wms_selection_criteria_txn.assignment_group_id%type;
128: l_abc_class_id wms_selection_criteria_txn.abc_class_id%type;
129: l_category_set_id wms_selection_criteria_txn.category_set_id%type;
130: l_category_id wms_selection_criteria_txn.category_id%type;

Line 127: l_assignment_group_id wms_selection_criteria_txn.assignment_group_id%type;

123: l_customer_id wms_selection_criteria_txn.customer_id%type;
124: l_freight_code wms_selection_criteria_txn.freight_code%type;
125: l_inventory_item_id wms_selection_criteria_txn.inventory_item_id%type;
126: l_item_type wms_selection_criteria_txn.item_type%type;
127: l_assignment_group_id wms_selection_criteria_txn.assignment_group_id%type;
128: l_abc_class_id wms_selection_criteria_txn.abc_class_id%type;
129: l_category_set_id wms_selection_criteria_txn.category_set_id%type;
130: l_category_id wms_selection_criteria_txn.category_id%type;
131: l_order_type_id wms_selection_criteria_txn.order_type_id%type;

Line 128: l_abc_class_id wms_selection_criteria_txn.abc_class_id%type;

124: l_freight_code wms_selection_criteria_txn.freight_code%type;
125: l_inventory_item_id wms_selection_criteria_txn.inventory_item_id%type;
126: l_item_type wms_selection_criteria_txn.item_type%type;
127: l_assignment_group_id wms_selection_criteria_txn.assignment_group_id%type;
128: l_abc_class_id wms_selection_criteria_txn.abc_class_id%type;
129: l_category_set_id wms_selection_criteria_txn.category_set_id%type;
130: l_category_id wms_selection_criteria_txn.category_id%type;
131: l_order_type_id wms_selection_criteria_txn.order_type_id%type;
132: l_vendor_id wms_selection_criteria_txn.vendor_id%type;

Line 129: l_category_set_id wms_selection_criteria_txn.category_set_id%type;

125: l_inventory_item_id wms_selection_criteria_txn.inventory_item_id%type;
126: l_item_type wms_selection_criteria_txn.item_type%type;
127: l_assignment_group_id wms_selection_criteria_txn.assignment_group_id%type;
128: l_abc_class_id wms_selection_criteria_txn.abc_class_id%type;
129: l_category_set_id wms_selection_criteria_txn.category_set_id%type;
130: l_category_id wms_selection_criteria_txn.category_id%type;
131: l_order_type_id wms_selection_criteria_txn.order_type_id%type;
132: l_vendor_id wms_selection_criteria_txn.vendor_id%type;
133: l_project_id wms_selection_criteria_txn.project_id%type;

Line 130: l_category_id wms_selection_criteria_txn.category_id%type;

126: l_item_type wms_selection_criteria_txn.item_type%type;
127: l_assignment_group_id wms_selection_criteria_txn.assignment_group_id%type;
128: l_abc_class_id wms_selection_criteria_txn.abc_class_id%type;
129: l_category_set_id wms_selection_criteria_txn.category_set_id%type;
130: l_category_id wms_selection_criteria_txn.category_id%type;
131: l_order_type_id wms_selection_criteria_txn.order_type_id%type;
132: l_vendor_id wms_selection_criteria_txn.vendor_id%type;
133: l_project_id wms_selection_criteria_txn.project_id%type;
134: l_task_id wms_selection_criteria_txn.task_id%type;

Line 131: l_order_type_id wms_selection_criteria_txn.order_type_id%type;

127: l_assignment_group_id wms_selection_criteria_txn.assignment_group_id%type;
128: l_abc_class_id wms_selection_criteria_txn.abc_class_id%type;
129: l_category_set_id wms_selection_criteria_txn.category_set_id%type;
130: l_category_id wms_selection_criteria_txn.category_id%type;
131: l_order_type_id wms_selection_criteria_txn.order_type_id%type;
132: l_vendor_id wms_selection_criteria_txn.vendor_id%type;
133: l_project_id wms_selection_criteria_txn.project_id%type;
134: l_task_id wms_selection_criteria_txn.task_id%type;
135: l_user_id wms_selection_criteria_txn.user_id%type;

Line 132: l_vendor_id wms_selection_criteria_txn.vendor_id%type;

128: l_abc_class_id wms_selection_criteria_txn.abc_class_id%type;
129: l_category_set_id wms_selection_criteria_txn.category_set_id%type;
130: l_category_id wms_selection_criteria_txn.category_id%type;
131: l_order_type_id wms_selection_criteria_txn.order_type_id%type;
132: l_vendor_id wms_selection_criteria_txn.vendor_id%type;
133: l_project_id wms_selection_criteria_txn.project_id%type;
134: l_task_id wms_selection_criteria_txn.task_id%type;
135: l_user_id wms_selection_criteria_txn.user_id%type;
136: l_transaction_action_id wms_selection_criteria_txn.transaction_action_id%type;

Line 133: l_project_id wms_selection_criteria_txn.project_id%type;

129: l_category_set_id wms_selection_criteria_txn.category_set_id%type;
130: l_category_id wms_selection_criteria_txn.category_id%type;
131: l_order_type_id wms_selection_criteria_txn.order_type_id%type;
132: l_vendor_id wms_selection_criteria_txn.vendor_id%type;
133: l_project_id wms_selection_criteria_txn.project_id%type;
134: l_task_id wms_selection_criteria_txn.task_id%type;
135: l_user_id wms_selection_criteria_txn.user_id%type;
136: l_transaction_action_id wms_selection_criteria_txn.transaction_action_id%type;
137: l_reason_id wms_selection_criteria_txn.reason_id%type;

Line 134: l_task_id wms_selection_criteria_txn.task_id%type;

130: l_category_id wms_selection_criteria_txn.category_id%type;
131: l_order_type_id wms_selection_criteria_txn.order_type_id%type;
132: l_vendor_id wms_selection_criteria_txn.vendor_id%type;
133: l_project_id wms_selection_criteria_txn.project_id%type;
134: l_task_id wms_selection_criteria_txn.task_id%type;
135: l_user_id wms_selection_criteria_txn.user_id%type;
136: l_transaction_action_id wms_selection_criteria_txn.transaction_action_id%type;
137: l_reason_id wms_selection_criteria_txn.reason_id%type;
138: l_transaction_source_type_id wms_selection_criteria_txn.transaction_source_type_id%type;

Line 135: l_user_id wms_selection_criteria_txn.user_id%type;

131: l_order_type_id wms_selection_criteria_txn.order_type_id%type;
132: l_vendor_id wms_selection_criteria_txn.vendor_id%type;
133: l_project_id wms_selection_criteria_txn.project_id%type;
134: l_task_id wms_selection_criteria_txn.task_id%type;
135: l_user_id wms_selection_criteria_txn.user_id%type;
136: l_transaction_action_id wms_selection_criteria_txn.transaction_action_id%type;
137: l_reason_id wms_selection_criteria_txn.reason_id%type;
138: l_transaction_source_type_id wms_selection_criteria_txn.transaction_source_type_id%type;
139: l_transaction_type_id wms_selection_criteria_txn.transaction_type_id%type;

Line 136: l_transaction_action_id wms_selection_criteria_txn.transaction_action_id%type;

132: l_vendor_id wms_selection_criteria_txn.vendor_id%type;
133: l_project_id wms_selection_criteria_txn.project_id%type;
134: l_task_id wms_selection_criteria_txn.task_id%type;
135: l_user_id wms_selection_criteria_txn.user_id%type;
136: l_transaction_action_id wms_selection_criteria_txn.transaction_action_id%type;
137: l_reason_id wms_selection_criteria_txn.reason_id%type;
138: l_transaction_source_type_id wms_selection_criteria_txn.transaction_source_type_id%type;
139: l_transaction_type_id wms_selection_criteria_txn.transaction_type_id%type;
140: l_uom_code wms_selection_criteria_txn.uom_code%type;

Line 137: l_reason_id wms_selection_criteria_txn.reason_id%type;

133: l_project_id wms_selection_criteria_txn.project_id%type;
134: l_task_id wms_selection_criteria_txn.task_id%type;
135: l_user_id wms_selection_criteria_txn.user_id%type;
136: l_transaction_action_id wms_selection_criteria_txn.transaction_action_id%type;
137: l_reason_id wms_selection_criteria_txn.reason_id%type;
138: l_transaction_source_type_id wms_selection_criteria_txn.transaction_source_type_id%type;
139: l_transaction_type_id wms_selection_criteria_txn.transaction_type_id%type;
140: l_uom_code wms_selection_criteria_txn.uom_code%type;
141: l_uom_class wms_selection_criteria_txn.uom_class%type;

Line 138: l_transaction_source_type_id wms_selection_criteria_txn.transaction_source_type_id%type;

134: l_task_id wms_selection_criteria_txn.task_id%type;
135: l_user_id wms_selection_criteria_txn.user_id%type;
136: l_transaction_action_id wms_selection_criteria_txn.transaction_action_id%type;
137: l_reason_id wms_selection_criteria_txn.reason_id%type;
138: l_transaction_source_type_id wms_selection_criteria_txn.transaction_source_type_id%type;
139: l_transaction_type_id wms_selection_criteria_txn.transaction_type_id%type;
140: l_uom_code wms_selection_criteria_txn.uom_code%type;
141: l_uom_class wms_selection_criteria_txn.uom_class%type;
142: l_last_updated_by wms_selection_criteria_txn.last_updated_by%type;

Line 139: l_transaction_type_id wms_selection_criteria_txn.transaction_type_id%type;

135: l_user_id wms_selection_criteria_txn.user_id%type;
136: l_transaction_action_id wms_selection_criteria_txn.transaction_action_id%type;
137: l_reason_id wms_selection_criteria_txn.reason_id%type;
138: l_transaction_source_type_id wms_selection_criteria_txn.transaction_source_type_id%type;
139: l_transaction_type_id wms_selection_criteria_txn.transaction_type_id%type;
140: l_uom_code wms_selection_criteria_txn.uom_code%type;
141: l_uom_class wms_selection_criteria_txn.uom_class%type;
142: l_last_updated_by wms_selection_criteria_txn.last_updated_by%type;
143: l_last_update_date wms_selection_criteria_txn.last_update_date%type;

Line 140: l_uom_code wms_selection_criteria_txn.uom_code%type;

136: l_transaction_action_id wms_selection_criteria_txn.transaction_action_id%type;
137: l_reason_id wms_selection_criteria_txn.reason_id%type;
138: l_transaction_source_type_id wms_selection_criteria_txn.transaction_source_type_id%type;
139: l_transaction_type_id wms_selection_criteria_txn.transaction_type_id%type;
140: l_uom_code wms_selection_criteria_txn.uom_code%type;
141: l_uom_class wms_selection_criteria_txn.uom_class%type;
142: l_last_updated_by wms_selection_criteria_txn.last_updated_by%type;
143: l_last_update_date wms_selection_criteria_txn.last_update_date%type;
144: l_created_by wms_selection_criteria_txn.created_by%type;

Line 141: l_uom_class wms_selection_criteria_txn.uom_class%type;

137: l_reason_id wms_selection_criteria_txn.reason_id%type;
138: l_transaction_source_type_id wms_selection_criteria_txn.transaction_source_type_id%type;
139: l_transaction_type_id wms_selection_criteria_txn.transaction_type_id%type;
140: l_uom_code wms_selection_criteria_txn.uom_code%type;
141: l_uom_class wms_selection_criteria_txn.uom_class%type;
142: l_last_updated_by wms_selection_criteria_txn.last_updated_by%type;
143: l_last_update_date wms_selection_criteria_txn.last_update_date%type;
144: l_created_by wms_selection_criteria_txn.created_by%type;
145: l_creation_date wms_selection_criteria_txn.creation_date%type;

Line 142: l_last_updated_by wms_selection_criteria_txn.last_updated_by%type;

138: l_transaction_source_type_id wms_selection_criteria_txn.transaction_source_type_id%type;
139: l_transaction_type_id wms_selection_criteria_txn.transaction_type_id%type;
140: l_uom_code wms_selection_criteria_txn.uom_code%type;
141: l_uom_class wms_selection_criteria_txn.uom_class%type;
142: l_last_updated_by wms_selection_criteria_txn.last_updated_by%type;
143: l_last_update_date wms_selection_criteria_txn.last_update_date%type;
144: l_created_by wms_selection_criteria_txn.created_by%type;
145: l_creation_date wms_selection_criteria_txn.creation_date%type;
146: l_last_update_login wms_selection_criteria_txn.last_update_login%type;

Line 143: l_last_update_date wms_selection_criteria_txn.last_update_date%type;

139: l_transaction_type_id wms_selection_criteria_txn.transaction_type_id%type;
140: l_uom_code wms_selection_criteria_txn.uom_code%type;
141: l_uom_class wms_selection_criteria_txn.uom_class%type;
142: l_last_updated_by wms_selection_criteria_txn.last_updated_by%type;
143: l_last_update_date wms_selection_criteria_txn.last_update_date%type;
144: l_created_by wms_selection_criteria_txn.created_by%type;
145: l_creation_date wms_selection_criteria_txn.creation_date%type;
146: l_last_update_login wms_selection_criteria_txn.last_update_login%type;
147:

Line 144: l_created_by wms_selection_criteria_txn.created_by%type;

140: l_uom_code wms_selection_criteria_txn.uom_code%type;
141: l_uom_class wms_selection_criteria_txn.uom_class%type;
142: l_last_updated_by wms_selection_criteria_txn.last_updated_by%type;
143: l_last_update_date wms_selection_criteria_txn.last_update_date%type;
144: l_created_by wms_selection_criteria_txn.created_by%type;
145: l_creation_date wms_selection_criteria_txn.creation_date%type;
146: l_last_update_login wms_selection_criteria_txn.last_update_login%type;
147:
148: --

Line 145: l_creation_date wms_selection_criteria_txn.creation_date%type;

141: l_uom_class wms_selection_criteria_txn.uom_class%type;
142: l_last_updated_by wms_selection_criteria_txn.last_updated_by%type;
143: l_last_update_date wms_selection_criteria_txn.last_update_date%type;
144: l_created_by wms_selection_criteria_txn.created_by%type;
145: l_creation_date wms_selection_criteria_txn.creation_date%type;
146: l_last_update_login wms_selection_criteria_txn.last_update_login%type;
147:
148: --
149:

Line 146: l_last_update_login wms_selection_criteria_txn.last_update_login%type;

142: l_last_updated_by wms_selection_criteria_txn.last_updated_by%type;
143: l_last_update_date wms_selection_criteria_txn.last_update_date%type;
144: l_created_by wms_selection_criteria_txn.created_by%type;
145: l_creation_date wms_selection_criteria_txn.creation_date%type;
146: l_last_update_login wms_selection_criteria_txn.last_update_login%type;
147:
148: --
149:
150: begin

Line 152: --- migrated into wms_selection_criteria_txn

148: --
149:
150: begin
151: --- Opening Cursor for Checkin if the data is already
152: --- migrated into wms_selection_criteria_txn
153:
154: open c_wsct;
155: fetch c_wsct into l_no_recs;
156: close c_wsct;

Line 162: --- and no data found in the target table "wms_selection_criteria_txn"

158: open c_stg;
159: fetch c_stg into l_stg_rec;
160:
161: --- Process each record, if data found in the source table "wms_strategy_assignments"
162: --- and no data found in the target table "wms_selection_criteria_txn"
163:
164: WHILE ( c_stg%found and l_no_recs = 0) LOOP
165:
166: --- Initilize the local variables for each record

Line 242: select wms_selection_criteria_txn_s.nextval

238: l_enabled_flag := 1;
239: l_sequence_number := l_seq;
240: l_from_organization_id := l_stg_rec.organization_id;
241:
242: select wms_selection_criteria_txn_s.nextval
243: into l_stg_assignment_id
244: from dual;
245:
246: --- Set the Pk1, Pk2, Pk3, Pk4 and Pk5 from the wms_strategy_assigenment table to the

Line 247: --- corresponding column in the wms_selection_criteria_txn table

243: into l_stg_assignment_id
244: from dual;
245:
246: --- Set the Pk1, Pk2, Pk3, Pk4 and Pk5 from the wms_strategy_assigenment table to the
247: --- corresponding column in the wms_selection_criteria_txn table
248:
249: if l_object_id = 3 then --- Source Organization
250: l_from_organization_id := l_stg_rec.pk1_value;
251: elsif l_object_id = 4 then --- Item

Line 400: cursor c is select stg_assignment_id from wms_selection_criteria_txn

396:
397: x_seq NUMBER;
398:
399:
400: cursor c is select stg_assignment_id from wms_selection_criteria_txn
401: where sequence_number = x_sequence_number
402: and rule_type_code = x_rule_type_code
403: and return_type_code = x_return_type_code
404: and return_type_id = x_return_type_id;

Line 409: insert into wms_selection_criteria_txn (

405:
406:
407: begin
408:
409: insert into wms_selection_criteria_txn (
410: stg_assignment_id
411: ,sequence_number
412: ,rule_type_code
413: ,return_type_code