eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_OE_INLINE_ADDRESS dependencies on HZ_PARTIES

Line 129: x_rel_party_number hz_parties.party_number%TYPE;

125: x_party_number varchar2(50);
126: x_profile_id number;
127:
128: x_rel_party_id number;
129: x_rel_party_number hz_parties.party_number%TYPE;
130: x_party_relationship_id number;
131:
132: l_org_contact_rec hz_party_contact_v2pub.org_contact_rec_type;
133: x_org_contact_id number;

Line 191: l_org_contact_rec.party_rel_rec.subject_table_name := 'HZ_PARTIES';

187: l_org_contact_rec.party_rel_rec.object_id := p_party_id;
188: l_org_contact_rec.party_rel_rec.relationship_type := 'CONTACT';
189: l_org_contact_rec.party_rel_rec.relationship_code := 'CONTACT_OF';
190: l_org_contact_rec.party_rel_rec.start_date := sysdate;
191: l_org_contact_rec.party_rel_rec.subject_table_name := 'HZ_PARTIES';
192: l_org_contact_rec.party_rel_rec.object_table_name := 'HZ_PARTIES';
193: l_org_contact_rec.party_rel_rec.created_by_module := G_CREATED_BY_MODULE;
194: l_org_contact_rec.party_rel_rec.subject_type := 'PERSON';
195:

Line 192: l_org_contact_rec.party_rel_rec.object_table_name := 'HZ_PARTIES';

188: l_org_contact_rec.party_rel_rec.relationship_type := 'CONTACT';
189: l_org_contact_rec.party_rel_rec.relationship_code := 'CONTACT_OF';
190: l_org_contact_rec.party_rel_rec.start_date := sysdate;
191: l_org_contact_rec.party_rel_rec.subject_table_name := 'HZ_PARTIES';
192: l_org_contact_rec.party_rel_rec.object_table_name := 'HZ_PARTIES';
193: l_org_contact_rec.party_rel_rec.created_by_module := G_CREATED_BY_MODULE;
194: l_org_contact_rec.party_rel_rec.subject_type := 'PERSON';
195:
196: Select party_type

Line 198: From HZ_PARTIES

194: l_org_contact_rec.party_rel_rec.subject_type := 'PERSON';
195:
196: Select party_type
197: Into l_org_contact_rec.party_rel_rec.object_type
198: From HZ_PARTIES
199: Where party_id = p_party_id;
200:
201: if l_gen_contact_number = 'N' then
202:

Line 333: from hz_parties

329: end if;
330:
331: select party_name
332: into x_contact_name
333: from hz_parties
334: where party_id = x_party_id;
335:
336: x_contact_id := x_cust_account_role_id;
337:

Line 411: AND owner_table_name = 'HZ_PARTIES'

407: /*CURSOR c_email IS
408: SELECT email_address
409: FROM hz_contact_points
410: WHERE owner_table_id = p_contact_party_id
411: AND owner_table_name = 'HZ_PARTIES'
412: AND contact_point_type = 'EMAIL'
413: AND primary_flag = 'Y'
414: AND status = 'A'; */
415:

Line 418: fROM hz_parties

414: AND status = 'A'; */
415:
416: CURSOR c_email IS
417: SELECT email_address
418: fROM hz_parties
419: where party_id = p_contact_party_id;
420:
421: l_email hz_parties.email_address%TYPE;
422: l_create_email boolean := FALSE;

Line 421: l_email hz_parties.email_address%TYPE;

417: SELECT email_address
418: fROM hz_parties
419: where party_id = p_contact_party_id;
420:
421: l_email hz_parties.email_address%TYPE;
422: l_create_email boolean := FALSE;
423:
424: --
425: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 620: l_contact_points_rec.owner_table_name := 'HZ_PARTIES';

616: BEGIN
617:
618: l_contact_points_rec.contact_point_type := in_contact_point_type;
619: l_contact_points_rec.status := 'A';
620: l_contact_points_rec.owner_table_name := 'HZ_PARTIES';
621: l_contact_points_rec.owner_table_id := in_owner_table_id;
622: l_contact_points_rec.primary_flag := 'Y';
623: l_contact_points_rec.created_by_module := G_CREATED_BY_MODULE;
624:

Line 1541: x_party_number hz_parties.party_number%TYPE;

1537:
1538: ) IS
1539:
1540: x_party_id number;
1541: x_party_number hz_parties.party_number%TYPE;
1542:
1543: --
1544: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1545: --

Line 1959: from hz_parties

1955:
1956:
1957: select party_name
1958: into out_cust_name
1959: from hz_parties
1960: where party_id = x_party_id;
1961:
1962: else
1963: out_cust_id := in_cust_account_id;

Line 1976: hz_parties party

1972: out_cust_name,
1973: out_cust_number,
1974: out_party_number
1975: from hz_cust_accounts acct,
1976: hz_parties party
1977: where acct.cust_account_id = in_cust_account_id
1978: and party.party_id = acct.party_id;
1979:
1980: