DBA Data[Home] [Help]

APPS.WIP_WS_DL_UTIL dependencies on HZ_CUST_ACCOUNTS

Line 292: from HZ_CUST_ACCOUNTS cust_accnt, mtl_reservations mr,

288: is
289: cursor c_num_customers(p_org_id number, p_wip_entity_id number)
290: Is
291: select count(distinct ool.sold_to_org_id)
292: from HZ_CUST_ACCOUNTS cust_accnt, mtl_reservations mr,
293: mtl_sales_orders mso, oe_order_lines_all ool
294: , wip_discrete_jobs wdj
295: where mso.sales_order_id = mr.demand_source_header_id
296: and mr.demand_source_line_id = ool.line_id

Line 307: from HZ_CUST_ACCOUNTS cust_accnt, HZ_PARTIES cust_party,

303: and wdj.wip_entity_id = p_wip_entity_id;
304: cursor c_ustomers(p_org_id number, p_wip_entity_id number)
305: Is
306: select cust_party.party_name
307: from HZ_CUST_ACCOUNTS cust_accnt, HZ_PARTIES cust_party,
308: mtl_reservations mr, mtl_sales_orders mso, oe_order_lines_all ool,
309: wip_discrete_jobs wdj
310: where mso.sales_order_id = mr.demand_source_header_id
311: and mr.demand_source_line_id = ool.line_id