[Home] [Help]
2918: in_cust_account_id in number) IS
2919: SELECT role.cust_account_role_id,
2920: role.cust_acct_site_id
2921: FROM hz_org_contacts org,
2922: hz_relationships rel,
2923: hz_cust_accounts acct,
2924: hz_cust_account_roles role
2925: WHERE org.org_Contact_id = in_org_contact_id
2926: AND org.party_relationship_id = rel.relationship_id
2944:
2945: CURSOR c_check_org_contact(in_party_id in number,in_org_contact_id in number) IS
2946: SELECT rel.party_id
2947: FROM hz_org_contacts org,
2948: hz_relationships rel
2949: WHERE org.org_contact_id = in_org_contact_id
2950: AND rel.status = 'A'
2951: AND rel.relationship_id = org.party_relationship_id
2952: AND (rel.object_id=in_party_id OR rel.subject_id=in_party_id)
2951: AND rel.relationship_id = org.party_relationship_id
2952: AND (rel.object_id=in_party_id OR rel.subject_id=in_party_id)
2953: AND rel.subject_table_name='HZ_PARTIES'
2954: AND rel.object_table_name='HZ_PARTIES';
2955: --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
2956:
2957: l_party_id NUMBER := null;
2958: l_org_contact_id number := null;
2959: l_rel_party_id varchar2(100);
5735: in_party_id number)
5736: IS
5737: SELECT org_contact.org_contact_id
5738: FROM hz_parties party,
5739: hz_relationships rel,
5740: hz_org_contacts org_contact,
5741: ar_lookups arl
5742: WHERE rel.object_id=in_party_id
5743: AND rel.relationship_id=org_contact.party_relationship_id
5867: AND site.party_id in(
5868: SELECT in_sold_to_party_id FROM DUAL
5869: UNION
5870: SELECT object_ID
5871: FROM HZ_relationships rel
5872: WHERE rel.subject_id= in_sold_to_party_id
5873: and rel.status='A');
5874: */
5875: CURSOR c2 IS