APPS.WMS_RULE_PVT_EXT_PSETJ dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 87: update mtl_material_transactions_temp mmtt

83: trace( ' p_task_id => ' || p_task_id
84: ||' p_operation_plan_id => ' || p_operation_plan_id, 4);
85: end if;
86:
87: update mtl_material_transactions_temp mmtt
88: set mmtt.operation_plan_id = p_operation_plan_id
89: where mmtt.transaction_temp_id = p_task_id;
90:
91: if (l_debug =1) then

Line 126: -- mtl_material_transactions_temp. Operation plan is implemeted by WMS rules.

122: --
123: -- Notes :
124: --
125: -- This procedure assign user defined operation plan to a specific task in
126: -- mtl_material_transactions_temp. Operation plan is implemeted by WMS rules.
127: -- This procedure calls the rule package created for operation plan rules to check
128: -- which operation plan rule actually matches the task in question.
129: -- Date Modification Author
130: -- ------------ ------------ ------------------

Line 182: -- @@@ from wms_rules_b rules, wms_op_plans_b wop, mtl_material_transactions_temp mmtt

178: -- ### will be selected
179: -- ### Rules are ordered by rule weight and creation date
180: -- @@@CURSOR c_rules_atf_outbound_pseti IS
181: -- @@@ select rules.rule_id, mmtt.organization_id, mmtt.wms_task_type, rules.type_hdr_id
182: -- @@@ from wms_rules_b rules, wms_op_plans_b wop, mtl_material_transactions_temp mmtt
183: -- @@@ where rules.type_code = 7
184: -- @@@ and rules.enabled_flag = 'Y'
185: -- @@@ and rules.type_hdr_id = wop.operation_plan_id
186: -- @@@ and wop.system_task_type = NVL(mmtt.wms_task_type, wop.system_task_type)

Line 196: from wms_rules_b rules, wms_op_plans_b wop, mtl_material_transactions_temp mmtt

192:
193: -- ### Added in patchset'J'
194: CURSOR c_rules_atf_outbound_psetj IS
195: select rules.rule_id, mmtt.organization_id, mmtt.wms_task_type, rules.type_hdr_id
196: from wms_rules_b rules, wms_op_plans_b wop, mtl_material_transactions_temp mmtt
197: where rules.type_code = 7
198: and rules.enabled_flag = 'Y'
199: and rules.type_hdr_id = wop.operation_plan_id
200: and wop.system_task_type = NVL(mmtt.wms_task_type, wop.system_task_type)

Line 213: from wms_rules_b rules, wms_op_plans_b wop, mtl_material_transactions_temp mmtt,

209: -- ### Added in Patchset 'J'
210: CURSOR c_rules_atf_inbound IS
211: select rules.rule_id, mmtt.organization_id, mmtt.wms_task_type, rules.type_hdr_id,
212: wop.plan_type_id -- new column added
213: from wms_rules_b rules, wms_op_plans_b wop, mtl_material_transactions_temp mmtt,
214: mtl_txn_request_lines mtrl -- new tables added
215: where rules.type_code = 7
216: and rules.enabled_flag = 'Y'
217: and rules.type_hdr_id = wop.operation_plan_id

Line 265: from mtl_material_transactions_temp mmtt, mtl_txn_request_lines mtrl,

261: -- ### 6 Put Away (Inbound)
262: -- ### Cursor used to derive the default operation plan for Inbound.
263: CURSOR c_default_op_plan_inbound IS
264: select wop.plan_type_id, wop.operation_plan_id
265: from mtl_material_transactions_temp mmtt, mtl_txn_request_lines mtrl,
266: wms_op_plans_b wop
267: where mmtt.transaction_temp_id = p_task_id
268: and mtrl.line_id = mmtt.move_order_line_id
269: and wop.activity_type_id= 1

Line 303: from mtl_parameters mp, mtl_material_transactions_temp mmtt

299:
300: -- ### This cursor has been modified by adding the MMTT table and joining the mtl_paramters to the MMTT.
301: CURSOR c_default_op_plan_outbound IS
302: select Nvl(default_pick_op_plan_id,1)
303: from mtl_parameters mp, mtl_material_transactions_temp mmtt
304: where mp.organization_id = mmtt.organization_id
305: and mmtt.transaction_temp_id = p_task_id
306: AND mmtt.transaction_source_type_id IN (2, 8); ----restrict to sales order and internal order mmtts only
307: -- @@@ organization_id = p_organization_id