DBA Data[Home] [Help]

APPS.WIP_WPS_COMMON dependencies on HZ_CUST_ACCOUNTS

Line 1407: from HZ_CUST_ACCOUNTS cust_accnt, HZ_PARTIES cust_party,

1403: into ret
1404: from dual
1405: where exists (
1406: select 1
1407: from HZ_CUST_ACCOUNTS cust_accnt, HZ_PARTIES cust_party,
1408: mtl_reservations mr, oe_order_lines_all ool
1409: where mr.demand_source_line_id = ool.line_id
1410: and mr.demand_source_type_id = 2
1411: and mr.supply_source_type_id = 5

Line 1478: hz_cust_accounts cust_accnt, hz_parties cust_party,

1474: if ( cust_cnt >0 ) then -- so_cnt should >0 too
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