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_RULE_PVT_EXT_PSETJ dependencies on WMS_OP_PLANS_B

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 266: wms_op_plans_b wop

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
270: --