[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
850: CURSOR b2b_contact_info(p_party_id number) IS
851: SELECT p.person_first_name,
852: p.person_last_name,
853: p.party_id
854: FROM hz_relationships l,
855: hz_parties p
856: WHERE l.party_id = p_party_id
857: AND l.subject_id = p.party_id
858: AND l.subject_type = 'PERSON'
936: CURSOR c_b2b_contact_info(p_party_id number) IS
937: SELECT p.person_first_name,
938: p.person_last_name,
939: p.party_id
940: FROM hz_relationships l,
941: hz_parties p
942: WHERE l.party_id = p_party_id
943: AND l.subject_id = p.party_id
944: AND l.subject_type = 'PERSON'
1363: and rownum= 1 and application_id=671;
1364:
1365: Cursor C_get_org_num(c_party_id NUMBER) IS
1366: select b.party_number
1367: from hz_parties a,hz_parties b,hz_relationships c
1368: where a.party_id= c.party_id
1369: and b.party_id= c.object_id
1370: and c.subject_table_name = 'HZ_PARTIES'
1371: and c.object_table_name = 'HZ_PARTIES'
2737: p.party_type,
2738: o.sold_to_contact_id
2739: from oe_order_headers_all o,
2740: hz_cust_Account_roles r,
2741: hz_relationships l,
2742: hz_parties p
2743: where o.header_id = c_order_id
2744: and o.sold_to_contact_id = r.cust_account_role_id
2745: and r.party_id = l.party_id
2770: p.person_last_name
2771: from hz_parties p,
2772: oe_order_headers_all o,
2773: fnd_user f,
2774: hz_relationships r
2775: where o.last_updated_by = f.user_id
2776: and f.customer_id = r.party_id
2777: and r.subject_id = p.party_id
2778: and r.subject_type = 'PERSON'
6619: p.person_last_name,
6620: p.party_type
6621: from oe_order_headers_all o,
6622: hz_cust_Account_roles r,
6623: hz_relationships l,
6624: hz_parties p
6625: where o.header_id = pOrder
6626: and o.sold_to_contact_id = r.cust_account_role_id
6627: and r.party_id = l.party_id
9618: p.person_last_name,
9619: p.party_type
9620: from oe_order_headers_all o,
9621: hz_cust_Account_roles r,
9622: hz_relationships l,
9623: hz_parties p
9624: where o.header_id = c_order_id
9625: and o.sold_to_contact_id = r.cust_account_role_id
9626: and r.party_id = l.party_id
9633: Select p.person_first_name,
9634: p.person_last_name,
9635: p.person_title,
9636: p.party_type
9637: from hz_relationships l,
9638: hz_parties p
9639: where l.party_id = pPartyId
9640: and l.subject_id = p.party_id
9641: and l.subject_type = 'PERSON'
9698: p.person_last_name,
9699: p.party_type
9700: from oe_order_headers_all o,
9701: hz_cust_Account_roles r,
9702: hz_relationships l,
9703: hz_parties p
9704: where o.header_id = c_Order_id
9705: and o.sold_to_contact_id = r.cust_account_role_id
9706: and r.party_id = l.party_id
9713: Select p.person_first_name,
9714: p.person_last_name,
9715: p.person_title,
9716: p.party_type
9717: from hz_relationships l,
9718: hz_parties p
9719: where l.party_id = pPartyId
9720: and l.subject_id = p.party_id
9721: and l.subject_type = 'PERSON'
9780: p.party_type,
9781: p.person_title
9782: from oe_order_headers_all o,
9783: hz_cust_Account_roles r,
9784: hz_relationships l,
9785: hz_parties p
9786: where o.header_id = c_order_id
9787: and o.sold_to_contact_id = r.cust_account_role_id
9788: and r.party_id = l.party_id
9795: Select p.person_first_name,
9796: p.person_last_name,
9797: p.person_title,
9798: p.party_type
9799: from hz_relationships l,
9800: hz_parties p
9801: where l.party_id = pPartyId
9802: and l.subject_id = p.party_id
9803: and l.subject_type = 'PERSON'