DBA Data[Home] [Help]

APPS.WMS_SHIPPING_LOVS dependencies on MTL_SECONDARY_INVENTORIES

Line 180: mtl_secondary_inventories sub

176: AND x_utt_res2.resource_id = x_eqp_r.resource_id
177: ) utt_eqp
178: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)
179: ) v ,
180: mtl_secondary_inventories sub
181: WHERE mmtt.organization_id = p_organization_id
182: AND oeh.order_number LIKE (p_order_number)
183: AND mmtt.transaction_source_id = mso.sales_order_id
184: AND mso.segment1 = oeh.order_number

Line 239: mtl_secondary_inventories sub

235: AND x_utt_res2.resource_id = x_eqp_r.resource_id
236: ) utt_eqp
237: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)
238: ) v ,
239: mtl_secondary_inventories sub
240: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
241: AND mmtt.organization_id = p_organization_id
242: AND mmtt.standard_operation_id = v.standard_operation_id -- join task to resource view, check if user defined task type match
243: AND mmtt.subinventory_code = NVL(p_zone, mmtt.subinventory_code)