DBA Data[Home] [Help]

APPS.WMS_RULE_PVT_EXT_PSETJ dependencies on MTL_PARAMETERS

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