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_INLINE_CUSTOMER_PUB dependencies on HZ_PARTIES

Line 114: From hz_parties

110: Select party_id,
111: party_name
112: Into x_party_id,
113: x_party_name
114: From hz_parties
115: Where party_number = p_party_number
116: And party_type = p_party_type;
117:
118: IF l_debug_level > 0 THEN

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

576:
577: x_return_status := FND_API.G_RET_STS_SUCCESS;
578: l_contact_points_rec.contact_point_type := p_contact_point_type;
579: l_contact_points_rec.status := 'A';
580: l_contact_points_rec.owner_table_name := 'HZ_PARTIES';
581: l_contact_points_rec.owner_table_id := p_owner_table_id;
582: l_contact_points_rec.primary_flag := 'Y';
583: l_contact_points_rec.created_by_module := G_CREATED_BY_MODULE;
584: l_contact_points_rec.application_id := 660;

Line 2511: x_rel_party_number hz_parties.party_number%TYPE;

2507: l_return_status Varchar2(1);
2508:
2509: -- l_party_rel_rec HZ_RELATIONSHIP_V2PUB.relationship_rec_type;
2510: x_rel_party_id Number;
2511: x_rel_party_number hz_parties.party_number%TYPE;
2512: x_party_relationship_id Number;
2513:
2514: l_org_contact_rec HZ_PARTY_CONTACT_V2PUB.org_contact_rec_type;
2515: x_org_contact_id Number;

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

2935: l_org_contact_rec.party_rel_rec.object_id := l_customer_party_id;
2936: l_org_contact_rec.party_rel_rec.relationship_type := 'CONTACT';
2937: l_org_contact_rec.party_rel_rec.relationship_code := 'CONTACT_OF';
2938: l_org_contact_rec.party_rel_rec.start_date := sysdate;
2939: l_org_contact_rec.party_rel_rec.subject_table_name := 'HZ_PARTIES';
2940: l_org_contact_rec.party_rel_rec.object_table_name := 'HZ_PARTIES';
2941: l_org_contact_rec.party_rel_rec.created_by_module := G_CREATED_BY_MODULE;
2942: l_org_contact_rec.party_rel_rec.application_id := 660;
2943: l_org_contact_rec.party_rel_rec.subject_type := 'PERSON';

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

2936: l_org_contact_rec.party_rel_rec.relationship_type := 'CONTACT';
2937: l_org_contact_rec.party_rel_rec.relationship_code := 'CONTACT_OF';
2938: l_org_contact_rec.party_rel_rec.start_date := sysdate;
2939: l_org_contact_rec.party_rel_rec.subject_table_name := 'HZ_PARTIES';
2940: l_org_contact_rec.party_rel_rec.object_table_name := 'HZ_PARTIES';
2941: l_org_contact_rec.party_rel_rec.created_by_module := G_CREATED_BY_MODULE;
2942: l_org_contact_rec.party_rel_rec.application_id := 660;
2943: l_org_contact_rec.party_rel_rec.subject_type := 'PERSON';
2944: Select party_type

Line 2946: From HZ_PARTIES

2942: l_org_contact_rec.party_rel_rec.application_id := 660;
2943: l_org_contact_rec.party_rel_rec.subject_type := 'PERSON';
2944: Select party_type
2945: Into l_org_contact_rec.party_rel_rec.object_type
2946: From HZ_PARTIES
2947: Where party_id = l_customer_party_id;
2948:
2949: IF l_debug_level > 0 THEN
2950: oe_debug_pub.add( 'SUBJECT_ID:'||L_CONTACT_PARTY_ID||':OBJECT_ID:'||L_CUSTOMER_PARTY_ID||':OBJECT_TYPE'||L_ORG_CONTACT_REC.PARTY_REL_REC.OBJECT_TYPE ) ;

Line 3154: From hz_parties

3150:
3151: -- Let us select the Name to Pass back to calling api
3152: Select party_name
3153: Into x_contact_name
3154: From hz_parties
3155: Where party_id = l_contact_party_id;
3156: -- End of select to get name
3157:
3158: -- Now Update the table with the new values