[Home] [Help]
2920: in_cust_account_id in number) IS
2921: SELECT role.cust_account_role_id,
2922: role.cust_acct_site_id
2923: FROM hz_org_contacts org,
2924: hz_relationships rel,
2925: hz_cust_accounts acct,
2926: hz_cust_account_roles role
2927: WHERE org.org_Contact_id = in_org_contact_id
2928: AND org.party_relationship_id = rel.relationship_id
2946:
2947: CURSOR c_check_org_contact(in_party_id in number,in_org_contact_id in number) IS
2948: SELECT rel.party_id
2949: FROM hz_org_contacts org,
2950: hz_relationships rel
2951: WHERE org.org_contact_id = in_org_contact_id
2952: AND rel.status = 'A'
2953: AND rel.relationship_id = org.party_relationship_id
2954: AND (rel.object_id=in_party_id OR rel.subject_id=in_party_id)
2953: AND rel.relationship_id = org.party_relationship_id
2954: AND (rel.object_id=in_party_id OR rel.subject_id=in_party_id)
2955: AND rel.subject_table_name='HZ_PARTIES'
2956: AND rel.object_table_name='HZ_PARTIES';
2957: --AND org.status='A'; -- bug 3810361, TCA USAGE GUIDE SAYS THIS IS NOT SUPPORTED IN V2 API, We should instead look at hz_relationships.status
2958:
2959: l_party_id NUMBER := null;
2960: l_org_contact_id number := null;
2961: l_rel_party_id varchar2(100);
5737: in_party_id number)
5738: IS
5739: SELECT org_contact.org_contact_id
5740: FROM hz_parties party,
5741: hz_relationships rel,
5742: hz_org_contacts org_contact,
5743: ar_lookups arl
5744: WHERE rel.object_id=in_party_id
5745: AND rel.relationship_id=org_contact.party_relationship_id
5869: AND site.party_id in(
5870: SELECT in_sold_to_party_id FROM DUAL
5871: UNION
5872: SELECT object_ID
5873: FROM HZ_relationships rel
5874: WHERE rel.subject_id= in_sold_to_party_id
5875: and rel.status='A');
5876: */
5877: CURSOR c2 IS