APPS.OE_CREATE_ACCOUNT_INFO dependencies on HZ_PARTIES

Line 2928: AND rel.subject_table_name='HZ_PARTIES'

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
2927: AND rel.object_id=acct.party_id
2928: AND rel.subject_table_name='HZ_PARTIES'
2929: AND rel.object_table_name='HZ_PARTIES'
2930: AND acct.cust_account_id = in_cust_account_id
2931: and role.cust_account_id = acct.cust_account_id
2932: and role.role_type ='CONTACT'

Line 2929: AND rel.object_table_name='HZ_PARTIES'

2925: WHERE org.org_Contact_id = in_org_contact_id
2926: AND org.party_relationship_id = rel.relationship_id
2927: AND rel.object_id=acct.party_id
2928: AND rel.subject_table_name='HZ_PARTIES'
2929: AND rel.object_table_name='HZ_PARTIES'
2930: AND acct.cust_account_id = in_cust_account_id
2931: and role.cust_account_id = acct.cust_account_id
2932: and role.role_type ='CONTACT'
2933: and role.party_id = rel.party_id

Line 2953: AND rel.subject_table_name='HZ_PARTIES'

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)
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;

Line 2954: AND rel.object_table_name='HZ_PARTIES';

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)
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;

Line 3577: from hz_parties

3573: and status = 'A';
3574:
3575: CURSOR party_rec(l_party_id in number) IS
3576: select party_type
3577: from hz_parties
3578: where party_id = l_party_id;
3579:
3580: CURSOR party_number_rec IS
3581: select party_id,party_type

Line 3582: from hz_parties

3578: where party_id = l_party_id;
3579:
3580: CURSOR party_number_rec IS
3581: select party_id,party_type
3582: from hz_parties
3583: where party_id = p_party_number;
3584:
3585:
3586: l_cust_account_id NUMBER := NULL;

Line 4071: from hz_parties

4067: and status = 'A';
4068:
4069: CURSOR party_rec(l_party_id in number) IS
4070: select party_type
4071: from hz_parties
4072: where party_id = l_party_id;
4073:
4074: CURSOR party_number_rec IS
4075: select party_id,party_type

Line 4076: from hz_parties

4072: where party_id = l_party_id;
4073:
4074: CURSOR party_number_rec IS
4075: select party_id,party_type
4076: from hz_parties
4077: where party_id = p_party_number;
4078:
4079: l_party_type VARCHAR2(30);
4080: l_party_id NUMBER;

Line 4607: from hz_parties

4603:
4604: begin
4605: select party_id
4606: into p_party_id
4607: from hz_parties
4608: where party_number=p_party_number;
4609:
4610: EXCEPTION
4611:

Line 5659: FROM hz_parties party

5655: END IF;
5656:
5657: SELECT party_id
5658: INTO l_id
5659: FROM hz_parties party
5660: WHERE party.party_number = p_party_number
5661: and status='A';
5662:
5663: ELSE

Line 5670: FROM HZ_PARTIES Party

5666: END IF;
5667:
5668: SELECT party.party_id
5669: INTO l_id
5670: FROM HZ_PARTIES Party
5671: WHERE party.party_name = p_party_name
5672: and status='A';
5673:
5674: END IF;

Line 5738: FROM hz_parties party,

5734: CURSOR c_org_contact_id(in_org_contact_name in varchar2,
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

Line 6102: HZ_PARTIES Party

6098: ELSE
6099: Select Cust_Acct.Cust_account_id
6100: into l_id
6101: from HZ_CUST_ACCOUNTS Cust_Acct,
6102: HZ_PARTIES Party
6103: where Cust_Acct.Party_id = Party.party_id
6104: and cust_acct.status='A'
6105: and Party.Party_name = p_sold_to_org;
6106: