APPS.OE_CREATE_ACCOUNT_INFO dependencies on HZ_PARTIES

Line 2930: AND rel.subject_table_name='HZ_PARTIES'

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

Line 2931: AND rel.object_table_name='HZ_PARTIES'

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

Line 2955: AND rel.subject_table_name='HZ_PARTIES'

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

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

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

Line 3579: from hz_parties

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

Line 3584: from hz_parties

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

Line 4073: from hz_parties

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

Line 4078: from hz_parties

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

Line 4609: from hz_parties

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

Line 5661: FROM hz_parties party

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

Line 5672: FROM HZ_PARTIES Party

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

Line 5740: FROM hz_parties party,

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

Line 6104: HZ_PARTIES Party

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