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.PV_ASSIGNMENT_PUB dependencies on HZ_PARTIES

Line 119: hz_parties pt

115: cursor lc_get_pt_org_name (pc_partner_id number) is
116: select pt.party_name
117: from hz_relationships pr,
118: hz_organization_profiles op,
119: hz_parties pt
120: where pr.party_id = pc_partner_id
121: and pr.subject_table_name = 'HZ_PARTIES'
122: and pr.object_table_name = 'HZ_PARTIES'
123: and pr.status in ('A', 'I')

Line 121: and pr.subject_table_name = 'HZ_PARTIES'

117: from hz_relationships pr,
118: hz_organization_profiles op,
119: hz_parties pt
120: where pr.party_id = pc_partner_id
121: and pr.subject_table_name = 'HZ_PARTIES'
122: and pr.object_table_name = 'HZ_PARTIES'
123: and pr.status in ('A', 'I')
124: and pr.object_id = op.party_id
125: and op.internal_flag = 'Y'

Line 122: and pr.object_table_name = 'HZ_PARTIES'

118: hz_organization_profiles op,
119: hz_parties pt
120: where pr.party_id = pc_partner_id
121: and pr.subject_table_name = 'HZ_PARTIES'
122: and pr.object_table_name = 'HZ_PARTIES'
123: and pr.status in ('A', 'I')
124: and pr.object_id = op.party_id
125: and op.internal_flag = 'Y'
126: and op.effective_end_date is null

Line 140: hz_parties pt,

136: ld.total_amount||' '||ld.currency_code,
137: pt.party_name,
138: lc.lead_contact_id
139: from as_leads_all ld,
140: hz_parties pt,
141: as_lead_contacts lc
142: where ld.lead_id = pc_lead_id
143: and ld.customer_id = pt.party_id (+)
144: and ld.lead_id = lc.lead_id (+) for update of ld.lead_id;

Line 171: hz_parties hp

167: hp.party_name,
168: prof.partner_id
169: from hz_relationships emp,
170: pv_partner_profiles prof,
171: hz_parties hp
172: where emp.party_id = pc_user_source_id
173: and emp.subject_table_name = 'HZ_PARTIES'
174: and emp.object_table_name = 'HZ_PARTIES'
175: and emp.directional_flag = 'F'

Line 173: and emp.subject_table_name = 'HZ_PARTIES'

169: from hz_relationships emp,
170: pv_partner_profiles prof,
171: hz_parties hp
172: where emp.party_id = pc_user_source_id
173: and emp.subject_table_name = 'HZ_PARTIES'
174: and emp.object_table_name = 'HZ_PARTIES'
175: and emp.directional_flag = 'F'
176: and emp.relationship_code = 'EMPLOYEE_OF'
177: and emp.relationship_type = 'EMPLOYMENT'

Line 174: and emp.object_table_name = 'HZ_PARTIES'

170: pv_partner_profiles prof,
171: hz_parties hp
172: where emp.party_id = pc_user_source_id
173: and emp.subject_table_name = 'HZ_PARTIES'
174: and emp.object_table_name = 'HZ_PARTIES'
175: and emp.directional_flag = 'F'
176: and emp.relationship_code = 'EMPLOYEE_OF'
177: and emp.relationship_type = 'EMPLOYMENT'
178: and emp.status in ('A', 'I')

Line 214: hz_parties PT_ORG

210: select PT_ORG.party_name
211: from
212: pv_partner_accesses PT_ACCESS,
213: pv_partner_profiles PT_PROF,
214: hz_parties PT_ORG
215: where
216: PT_ACCESS.partner_id = pc_partner_id
217: and PT_ACCESS.partner_id = PT_PROF.partner_id
218: and PT_PROF.status = 'A'

Line 1921: hz_parties pt

1917: cursor lc_get_pt_org_name (pc_partner_id number) is
1918: select pt.party_name
1919: from hz_relationships pr,
1920: hz_organization_profiles op,
1921: hz_parties pt
1922: where pr.party_id = pc_partner_id
1923: and pr.subject_table_name = 'HZ_PARTIES'
1924: and pr.object_table_name = 'HZ_PARTIES'
1925: and pr.status in ('A', 'I')

Line 1923: and pr.subject_table_name = 'HZ_PARTIES'

1919: from hz_relationships pr,
1920: hz_organization_profiles op,
1921: hz_parties pt
1922: where pr.party_id = pc_partner_id
1923: and pr.subject_table_name = 'HZ_PARTIES'
1924: and pr.object_table_name = 'HZ_PARTIES'
1925: and pr.status in ('A', 'I')
1926: and pr.object_id = op.party_id
1927: and op.internal_flag = 'Y'

Line 1924: and pr.object_table_name = 'HZ_PARTIES'

1920: hz_organization_profiles op,
1921: hz_parties pt
1922: where pr.party_id = pc_partner_id
1923: and pr.subject_table_name = 'HZ_PARTIES'
1924: and pr.object_table_name = 'HZ_PARTIES'
1925: and pr.status in ('A', 'I')
1926: and pr.object_id = op.party_id
1927: and op.internal_flag = 'Y'
1928: and op.effective_end_date is null

Line 2820: , hz_parties c

2816: b.total_amount||' '||b.currency_code,
2817: c.party_name
2818: from pv_lead_workflows a
2819: , as_leads_all b
2820: , hz_parties c
2821: where a.lead_id = pc_lead_id
2822: and b.customer_id = c.party_id
2823: and a.latest_routing_flag = 'Y'
2824: and a.lead_id = b.lead_id

Line 2887: from hz_relationships emp,hz_parties hp

2883:
2884: CURSOR lc_get_ven_pty_name(pc_source_id NUMBER)
2885: IS
2886: select hp.party_name
2887: from hz_relationships emp,hz_parties hp
2888: where emp.party_id = pc_source_id
2889: and emp.subject_table_name = 'HZ_PARTIES'
2890: and emp.object_table_name = 'HZ_PARTIES'
2891: and emp.directional_flag = 'F'

Line 2889: and emp.subject_table_name = 'HZ_PARTIES'

2885: IS
2886: select hp.party_name
2887: from hz_relationships emp,hz_parties hp
2888: where emp.party_id = pc_source_id
2889: and emp.subject_table_name = 'HZ_PARTIES'
2890: and emp.object_table_name = 'HZ_PARTIES'
2891: and emp.directional_flag = 'F'
2892: and emp.relationship_code = 'EMPLOYEE_OF'
2893: and emp.relationship_type = 'EMPLOYMENT'

Line 2890: and emp.object_table_name = 'HZ_PARTIES'

2886: select hp.party_name
2887: from hz_relationships emp,hz_parties hp
2888: where emp.party_id = pc_source_id
2889: and emp.subject_table_name = 'HZ_PARTIES'
2890: and emp.object_table_name = 'HZ_PARTIES'
2891: and emp.directional_flag = 'F'
2892: and emp.relationship_code = 'EMPLOYEE_OF'
2893: and emp.relationship_type = 'EMPLOYMENT'
2894: and emp.status in ('A', 'I')

Line 3457: and emp.subject_table_name = 'HZ_PARTIES'

3453: where fu.user_name = pc_user_name
3454: and fu.user_id = re.user_id
3455: and re.category = 'PARTY'
3456: and re.source_id = emp.party_id
3457: and emp.subject_table_name = 'HZ_PARTIES'
3458: and emp.object_table_name = 'HZ_PARTIES'
3459: and emp.directional_flag = 'F'
3460: and emp.relationship_code = 'EMPLOYEE_OF'
3461: and emp.relationship_type = 'EMPLOYMENT'

Line 3458: and emp.object_table_name = 'HZ_PARTIES'

3454: and fu.user_id = re.user_id
3455: and re.category = 'PARTY'
3456: and re.source_id = emp.party_id
3457: and emp.subject_table_name = 'HZ_PARTIES'
3458: and emp.object_table_name = 'HZ_PARTIES'
3459: and emp.directional_flag = 'F'
3460: and emp.relationship_code = 'EMPLOYEE_OF'
3461: and emp.relationship_type = 'EMPLOYMENT'
3462: and emp.status in ('A', 'I')

Line 3473: hz_parties pt

3469: cursor lc_get_pt_org_name (pc_partner_id number) is
3470: select pt.party_name
3471: from hz_relationships pr,
3472: hz_organization_profiles op,
3473: hz_parties pt
3474: where pr.party_id = pc_partner_id
3475: and pr.subject_table_name = 'HZ_PARTIES'
3476: and pr.object_table_name = 'HZ_PARTIES'
3477: and pr.status in ('A', 'I')

Line 3475: and pr.subject_table_name = 'HZ_PARTIES'

3471: from hz_relationships pr,
3472: hz_organization_profiles op,
3473: hz_parties pt
3474: where pr.party_id = pc_partner_id
3475: and pr.subject_table_name = 'HZ_PARTIES'
3476: and pr.object_table_name = 'HZ_PARTIES'
3477: and pr.status in ('A', 'I')
3478: and pr.object_id = op.party_id
3479: and op.internal_flag = 'Y'

Line 3476: and pr.object_table_name = 'HZ_PARTIES'

3472: hz_organization_profiles op,
3473: hz_parties pt
3474: where pr.party_id = pc_partner_id
3475: and pr.subject_table_name = 'HZ_PARTIES'
3476: and pr.object_table_name = 'HZ_PARTIES'
3477: and pr.status in ('A', 'I')
3478: and pr.object_id = op.party_id
3479: and op.internal_flag = 'Y'
3480: and op.effective_end_date is null

Line 3491: FROM as_leads_all a, hz_parties b

3487: , a.lead_number
3488: , a.description
3489: , a.total_amount||' '||a.currency_code
3490: , b.party_name
3491: FROM as_leads_all a, hz_parties b
3492: WHERE a.lead_id = pc_lead_id
3493: AND a.customer_id = b.party_id
3494: and b.status in ('A', 'I');
3495:

Line 3537: from hz_relationships emp,hz_parties hp

3533:
3534: CURSOR lc_get_ven_pty_name(pc_source_id NUMBER)
3535: IS
3536: select hp.party_name
3537: from hz_relationships emp,hz_parties hp
3538: where emp.party_id = pc_source_id
3539: and emp.subject_table_name = 'HZ_PARTIES'
3540: and emp.object_table_name = 'HZ_PARTIES'
3541: and emp.directional_flag = 'F'

Line 3539: and emp.subject_table_name = 'HZ_PARTIES'

3535: IS
3536: select hp.party_name
3537: from hz_relationships emp,hz_parties hp
3538: where emp.party_id = pc_source_id
3539: and emp.subject_table_name = 'HZ_PARTIES'
3540: and emp.object_table_name = 'HZ_PARTIES'
3541: and emp.directional_flag = 'F'
3542: and emp.relationship_code = 'EMPLOYEE_OF'
3543: and emp.relationship_type = 'EMPLOYMENT'

Line 3540: and emp.object_table_name = 'HZ_PARTIES'

3536: select hp.party_name
3537: from hz_relationships emp,hz_parties hp
3538: where emp.party_id = pc_source_id
3539: and emp.subject_table_name = 'HZ_PARTIES'
3540: and emp.object_table_name = 'HZ_PARTIES'
3541: and emp.directional_flag = 'F'
3542: and emp.relationship_code = 'EMPLOYEE_OF'
3543: and emp.relationship_type = 'EMPLOYMENT'
3544: and emp.status in ('A', 'I')