DBA Data[Home] [Help]

APPS.WMS_RULE_PVT_EXT_PSETJ dependencies on MTL_TXN_REQUEST_LINES

Line 214: mtl_txn_request_lines mtrl -- new tables added

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
218: and rules.organization_id in (mmtt.organization_id, -1)

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