[Home] [Help]
58: | any references to quote schema.
59: | Added a new procedure get_contact_details_for_order
60: |
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
840: CURSOR b2b_contact_info(p_party_id number) IS
841: SELECT p.person_first_name,
842: p.person_last_name,
843: p.party_id
844: FROM hz_relationships l,
845: hz_parties p
846: WHERE l.party_id = p_party_id
847: AND l.subject_id = p.party_id
848: AND l.subject_type = 'PERSON'
926: CURSOR c_b2b_contact_info(p_party_id number) IS
927: SELECT p.person_first_name,
928: p.person_last_name,
929: p.party_id
930: FROM hz_relationships l,
931: hz_parties p
932: WHERE l.party_id = p_party_id
933: AND l.subject_id = p.party_id
934: AND l.subject_type = 'PERSON'
1353: and rownum= 1 and application_id=671;
1354:
1355: Cursor C_get_org_num(c_party_id NUMBER) IS
1356: select b.party_number
1357: from hz_parties a,hz_parties b,hz_relationships c
1358: where a.party_id= c.party_id
1359: and b.party_id= c.object_id
1360: and c.subject_table_name = 'HZ_PARTIES'
1361: and c.object_table_name = 'HZ_PARTIES'
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
2654: and o.sold_to_contact_id = r.cust_account_role_id
2655: and r.party_id = l.party_id
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
2687: and r.subject_id = p.party_id
2688: and r.subject_type = 'PERSON'
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
6531: and o.sold_to_contact_id = r.cust_account_role_id
6532: and r.party_id = l.party_id
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
9530: and o.sold_to_contact_id = r.cust_account_role_id
9531: and r.party_id = l.party_id
9538: Select p.person_first_name,
9539: p.person_last_name,
9540: p.person_title,
9541: p.party_type
9542: from hz_relationships l,
9543: hz_parties p
9544: where l.party_id = pPartyId
9545: and l.subject_id = p.party_id
9546: and l.subject_type = 'PERSON'
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
9610: and o.sold_to_contact_id = r.cust_account_role_id
9611: and r.party_id = l.party_id
9618: Select p.person_first_name,
9619: p.person_last_name,
9620: p.person_title,
9621: p.party_type
9622: from hz_relationships l,
9623: hz_parties p
9624: where l.party_id = pPartyId
9625: and l.subject_id = p.party_id
9626: and l.subject_type = 'PERSON'
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
9692: and o.sold_to_contact_id = r.cust_account_role_id
9693: and r.party_id = l.party_id
9700: Select p.person_first_name,
9701: p.person_last_name,
9702: p.person_title,
9703: p.party_type
9704: from hz_relationships l,
9705: hz_parties p
9706: where l.party_id = pPartyId
9707: and l.subject_id = p.party_id
9708: and l.subject_type = 'PERSON'