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

Line 736: and EMP_TO_ORG.subject_table_name = 'HZ_PARTIES'

732: and PV_ASSIGN.wf_item_type = PV_LEAD_WF.wf_item_type
733: and PV_ASSIGN.wf_item_key = PV_LEAD_WF.wf_item_key
734: and PV_LEAD_WF.created_by = LEAD_SOURCE.user_id
735: and EMP_TO_ORG.party_id = LEAD_SOURCE.source_id
736: and EMP_TO_ORG.subject_table_name = 'HZ_PARTIES'
737: and EMP_TO_ORG.object_table_name = 'HZ_PARTIES'
738: and EMP_TO_ORG.directional_flag = 'F'
739: and EMP_TO_ORG.status in ('A', 'I')
740: and EMP_TO_ORG.relationship_code = 'EMPLOYEE_OF'

Line 737: and EMP_TO_ORG.object_table_name = 'HZ_PARTIES'

733: and PV_ASSIGN.wf_item_key = PV_LEAD_WF.wf_item_key
734: and PV_LEAD_WF.created_by = LEAD_SOURCE.user_id
735: and EMP_TO_ORG.party_id = LEAD_SOURCE.source_id
736: and EMP_TO_ORG.subject_table_name = 'HZ_PARTIES'
737: and EMP_TO_ORG.object_table_name = 'HZ_PARTIES'
738: and EMP_TO_ORG.directional_flag = 'F'
739: and EMP_TO_ORG.status in ('A', 'I')
740: and EMP_TO_ORG.relationship_code = 'EMPLOYEE_OF'
741: and EMP_TO_ORG.relationship_type = 'EMPLOYMENT'

Line 743: and ORG_TO_VEND.subject_table_name = 'HZ_PARTIES'

739: and EMP_TO_ORG.status in ('A', 'I')
740: and EMP_TO_ORG.relationship_code = 'EMPLOYEE_OF'
741: and EMP_TO_ORG.relationship_type = 'EMPLOYMENT'
742: and EMP_TO_ORG.object_id = ORG_TO_VEND.subject_id
743: and ORG_TO_VEND.subject_table_name = 'HZ_PARTIES'
744: and ORG_TO_VEND.object_table_name = 'HZ_PARTIES'
745: and ORG_TO_VEND.status in ('A', 'I')
746: and ORG_TO_VEND.relationship_type = 'PARTNER'
747: and ORG_TO_VEND.object_id = HZOP.party_id

Line 744: and ORG_TO_VEND.object_table_name = 'HZ_PARTIES'

740: and EMP_TO_ORG.relationship_code = 'EMPLOYEE_OF'
741: and EMP_TO_ORG.relationship_type = 'EMPLOYMENT'
742: and EMP_TO_ORG.object_id = ORG_TO_VEND.subject_id
743: and ORG_TO_VEND.subject_table_name = 'HZ_PARTIES'
744: and ORG_TO_VEND.object_table_name = 'HZ_PARTIES'
745: and ORG_TO_VEND.status in ('A', 'I')
746: and ORG_TO_VEND.relationship_type = 'PARTNER'
747: and ORG_TO_VEND.object_id = HZOP.party_id
748: and HZOP.internal_flag = 'Y'

Line 1254: b.subject_table_name = 'HZ_PARTIES' and

1250: la.partner_id = pc_partner_id and
1251: la.partner_id = pvpp.partner_id and
1252: pvpp.status in ('A', 'I') and
1253: pvpp.partner_party_id = b.object_id and
1254: b.subject_table_name = 'HZ_PARTIES' and
1255: b.object_table_name = 'HZ_PARTIES' and
1256: b.directional_flag = 'F' and
1257: b.relationship_code = 'EMPLOYEE_OF' and
1258: b.relationship_type = 'EMPLOYMENT' and

Line 1255: b.object_table_name = 'HZ_PARTIES' and

1251: la.partner_id = pvpp.partner_id and
1252: pvpp.status in ('A', 'I') and
1253: pvpp.partner_party_id = b.object_id and
1254: b.subject_table_name = 'HZ_PARTIES' and
1255: b.object_table_name = 'HZ_PARTIES' and
1256: b.directional_flag = 'F' and
1257: b.relationship_code = 'EMPLOYEE_OF' and
1258: b.relationship_type = 'EMPLOYMENT' and
1259: b.status in ('A', 'I') and

Line 1330: AND b.subject_table_name = 'HZ_PARTIES'

1326: AND la.wf_item_key = pc_itemkey
1327: AND la.partner_id = pvpp.partner_id
1328: AND pvpp.status in ('A', 'I')
1329: AND pvpp.partner_party_id = b.object_id
1330: AND b.subject_table_name = 'HZ_PARTIES'
1331: AND b.object_table_name = 'HZ_PARTIES'
1332: AND b.directional_flag = 'F'
1333: AND b.relationship_code = 'EMPLOYEE_OF'
1334: AND b.relationship_type = 'EMPLOYMENT'

Line 1331: AND b.object_table_name = 'HZ_PARTIES'

1327: AND la.partner_id = pvpp.partner_id
1328: AND pvpp.status in ('A', 'I')
1329: AND pvpp.partner_party_id = b.object_id
1330: AND b.subject_table_name = 'HZ_PARTIES'
1331: AND b.object_table_name = 'HZ_PARTIES'
1332: AND b.directional_flag = 'F'
1333: AND b.relationship_code = 'EMPLOYEE_OF'
1334: AND b.relationship_type = 'EMPLOYMENT'
1335: AND b.status in ('A', 'I')

Line 1718: 'hz_parties partner, hz_relationships hzrl, hz_organization_profiles hzop '||

1714: elsif p_timeoutType = pv_assignment_pub.g_offered_timeout then
1715:
1716: l_query := l_query || ' ( select hzl.country from '||
1717: 'hz_locations hzl, hz_party_sites hzps, pv_lead_assignments lead, '||
1718: 'hz_parties partner, hz_relationships hzrl, hz_organization_profiles hzop '||
1719: 'where hzl.location_id = hzps.location_id '||
1720: 'and hzps.party_id = partner.party_id '||
1721: 'and hzrl.party_id = lead.partner_id '||
1722: 'and hzrl.subject_id = partner.party_id '||

Line 1724: 'and hzrl.subject_table_name = ''HZ_PARTIES'' '||

1720: 'and hzps.party_id = partner.party_id '||
1721: 'and hzrl.party_id = lead.partner_id '||
1722: 'and hzrl.subject_id = partner.party_id '||
1723: 'and hzrl.object_id = hzop.party_id '||
1724: 'and hzrl.subject_table_name = ''HZ_PARTIES'' '||
1725: 'and hzrl.object_table_name = ''HZ_PARTIES'' '||
1726: 'and hzrl.status in (''A'',''I'') '||
1727: 'and hzop.internal_flag = ''Y'' '||
1728: 'and hzop.effective_end_date is null '||

Line 1725: 'and hzrl.object_table_name = ''HZ_PARTIES'' '||

1721: 'and hzrl.party_id = lead.partner_id '||
1722: 'and hzrl.subject_id = partner.party_id '||
1723: 'and hzrl.object_id = hzop.party_id '||
1724: 'and hzrl.subject_table_name = ''HZ_PARTIES'' '||
1725: 'and hzrl.object_table_name = ''HZ_PARTIES'' '||
1726: 'and hzrl.status in (''A'',''I'') '||
1727: 'and hzop.internal_flag = ''Y'' '||
1728: 'and hzop.effective_end_date is null '||
1729: 'and partner.status = ''A'' '||

Line 2100: hz_parties pt

2096: cursor lc_get_pt_org_name (pc_partner_id number) is
2097: select pt.party_name
2098: from hz_relationships pr,
2099: hz_organization_profiles op,
2100: hz_parties pt
2101: where pr.party_id = pc_partner_id
2102: and pr.subject_table_name = 'HZ_PARTIES'
2103: and pr.object_table_name = 'HZ_PARTIES'
2104: and pr.status in ('A', 'I')

Line 2102: and pr.subject_table_name = 'HZ_PARTIES'

2098: from hz_relationships pr,
2099: hz_organization_profiles op,
2100: hz_parties pt
2101: where pr.party_id = pc_partner_id
2102: and pr.subject_table_name = 'HZ_PARTIES'
2103: and pr.object_table_name = 'HZ_PARTIES'
2104: and pr.status in ('A', 'I')
2105: and pr.object_id = op.party_id
2106: and op.internal_flag = 'Y'

Line 2103: and pr.object_table_name = 'HZ_PARTIES'

2099: hz_organization_profiles op,
2100: hz_parties pt
2101: where pr.party_id = pc_partner_id
2102: and pr.subject_table_name = 'HZ_PARTIES'
2103: and pr.object_table_name = 'HZ_PARTIES'
2104: and pr.status in ('A', 'I')
2105: and pr.object_id = op.party_id
2106: and op.internal_flag = 'Y'
2107: and op.effective_end_date is null

Line 2593: hz_parties c

2589: FOR x IN (
2590: SELECT a.partner_id, c.party_name
2591: FROM pv_lead_assignments a,
2592: pv_partner_profiles b,
2593: hz_parties c
2594: WHERE a.wf_item_type = p_itemtype AND
2595: a.wf_item_key = p_itemkey AND
2596: a.status IN ('CM_APPROVED', 'CM_BYPASSED', 'CM_TIMEOUT') AND
2597: a.partner_id = b.partner_id AND

Line 3530: hz_parties pt

3526: cursor lc_get_pt_org_name (pc_partner_id number) is
3527: select pt.party_name
3528: from hz_relationships pr,
3529: hz_organization_profiles op,
3530: hz_parties pt
3531: where pr.party_id = pc_partner_id
3532: and pr.subject_table_name = 'HZ_PARTIES'
3533: and pr.object_table_name = 'HZ_PARTIES'
3534: and pr.status in ('A', 'I')

Line 3532: and pr.subject_table_name = 'HZ_PARTIES'

3528: from hz_relationships pr,
3529: hz_organization_profiles op,
3530: hz_parties pt
3531: where pr.party_id = pc_partner_id
3532: and pr.subject_table_name = 'HZ_PARTIES'
3533: and pr.object_table_name = 'HZ_PARTIES'
3534: and pr.status in ('A', 'I')
3535: and pr.object_id = op.party_id
3536: and op.internal_flag = 'Y'

Line 3533: and pr.object_table_name = 'HZ_PARTIES'

3529: hz_organization_profiles op,
3530: hz_parties pt
3531: where pr.party_id = pc_partner_id
3532: and pr.subject_table_name = 'HZ_PARTIES'
3533: and pr.object_table_name = 'HZ_PARTIES'
3534: and pr.status in ('A', 'I')
3535: and pr.object_id = op.party_id
3536: and op.internal_flag = 'Y'
3537: and op.effective_end_date is null