[Home] [Help]
61: | 06/03/02 mannamra Bugfix: 2380273 - Replaced HZ_PARTY_RELATIONSHIPS
62: | with HZ_RELATIONSHIPS to improve query
63: | performance.
64: | 06/10/02 mannamra Bugfix: 2387181 - During cancel_order value for sold_to_contact is not
65: | available in oe_order_headers_all table for some orders,
66: | so using the value in last_updated_by column
67: | to identify the appropriate recipient of
68: | the cancel order notification.
69: | 06/18/02 mannamra Bugfix: 2417011 - Obsoleted getfirstname_for_quote API because
158: invaddr.state bill_to_state,
159: invaddr.postal_code bill_to_postal_code,
160: invaddr.country bill_to_country,
161: oh.transactional_curr_code
162: from oe_order_headers_all oh,
163: hz_parties sold_to_party,
164: hz_cust_accounts sold_to_account,
165: hz_locations shipaddr,
166: hz_party_sites shp_party_site,
282: AND owner_table_id = p_party_id;
283:
284: cursor c_order_curr_code(c_order_id number) is
285: select transactional_curr_code
286: from oe_order_headers_all
287: where header_id = c_order_id;
288: rec_order_curr_code c_order_curr_code%rowtype;
289:
290: cursor c_curr_symbol(p_currCode VARCHAR2) IS
2645: p.person_first_name,
2646: p.person_last_name,
2647: p.party_type,
2648: o.sold_to_contact_id
2649: from oe_order_headers_all o,
2650: hz_cust_Account_roles r,
2651: hz_relationships l,
2652: hz_parties p
2653: where o.header_id = c_order_id
2664: p.person_last_name,
2665: p.person_middle_name
2666:
2667: from hz_cust_accounts a,
2668: oe_order_headers_all o,
2669: hz_parties p
2670: where o.sold_to_org_id = a.cust_account_id
2671: and a.party_id = p.party_id
2672: and o.header_id = c_order_id;
2678: p.person_first_name ,
2679: p.person_middle_name,
2680: p.person_last_name
2681: from hz_parties p,
2682: oe_order_headers_all o,
2683: fnd_user f,
2684: hz_relationships r
2685: where o.last_updated_by = f.user_id
2686: and f.customer_id = r.party_id
2742: exit when c_b2c_contact%notfound;
2743: END LOOP;
2744:
2745: IF (l_party_type = 'ORGANIZATION') then --B2B user, determine party_id of type 'RELATIONSHIP'
2746: --sold_to_contact_id in oe_order_headers_all is the account_id
2747: --of the organization owning the order
2748: FOR rec_b2b_contact IN c_b2b_contact(p_order_id) LOOP
2749: ----DBMS_OUTPUT.PUT('Order id is: '||p_order_id);
2750: l_sold_to_contact := rec_b2b_contact.sold_to_contact_id;
2892:
2893:
2894: --select the order number here
2895: select order_number into l_order_num
2896: from oe_order_headers_all i
2897: where header_id = p_order_id;
2898:
2899:
2900: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
6522: l.party_id contact_party_id,
6523: p.person_first_name,
6524: p.person_last_name,
6525: p.party_type
6526: from oe_order_headers_all o,
6527: hz_cust_Account_roles r,
6528: hz_relationships l,
6529: hz_parties p
6530: where o.header_id = pOrder
8263: oe_totals_grp.Get_PayNow_Total(oh.header_id,null,'ALL') PayNow_order_total,
8264: oh.transactional_curr_code,
8265: oe_totals_grp.Get_Order_Total(oh.header_id,null,'ALL') order_total,
8266: oh.order_number
8267: from oe_order_headers_all oh
8268: where oh.header_id = c_order_id;
8269: g_macd_ord_rec c_macd_order_header%ROWTYPE;
8270: l_rec_charge_tbl OE_OE_TOTALS_SUMMARY.Rec_Charges_Tbl_Type;
8271:
9521: l.party_id contact_party_id,
9522: p.person_first_name,
9523: p.person_last_name,
9524: p.party_type
9525: from oe_order_headers_all o,
9526: hz_cust_Account_roles r,
9527: hz_relationships l,
9528: hz_parties p
9529: where o.header_id = c_order_id
9601: l.party_id contact_party_id,
9602: p.person_first_name,
9603: p.person_last_name,
9604: p.party_type
9605: from oe_order_headers_all o,
9606: hz_cust_Account_roles r,
9607: hz_relationships l,
9608: hz_parties p
9609: where o.header_id = c_Order_id
9683: p.person_first_name,
9684: p.person_last_name,
9685: p.party_type,
9686: p.person_title
9687: from oe_order_headers_all o,
9688: hz_cust_Account_roles r,
9689: hz_relationships l,
9690: hz_parties p
9691: where o.header_id = c_order_id