DBA Data[Home] [Help]

APPS.WIP_WPS_COMMON dependencies on MTL_SALES_ORDERS

Line 1436: from mtl_reservations mr , mtl_sales_orders mso

1432: into ret
1433: from dual
1434: where exists (
1435: select 1
1436: from mtl_reservations mr , mtl_sales_orders mso
1437: where mso.sales_order_id = mr.demand_source_header_id
1438: and mr.demand_source_type_id = 2
1439: and mr.supply_source_type_id = 5
1440: and mso.segment1 like p_so_name

Line 1479: mtl_sales_orders mso

1475: select mso.segment1, cust_party.party_name
1476: into so_name, cust_name
1477: from mtl_reservations mr, oe_order_lines_all ool,
1478: hz_cust_accounts cust_accnt, hz_parties cust_party,
1479: mtl_sales_orders mso
1480: where mr.demand_source_line_id = ool.line_id
1481: and mr.demand_source_type_id = 2
1482: and mr.supply_source_type_id = 5
1483: and cust_accnt.cust_account_id = ool.sold_to_org_id