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_MATCH_V3_PUB dependencies on PV_LEAD_ASSIGNMENTS

Line 1987: partner exists in pv_lead_assignments until oppty is recycled by the partner

1983: REJECTED CURRENT OPPORTUNITY = 1
1984: PREFERRED OR INCUMBENT PARTNER FOR CURRENT OPPORTUNITY = 2
1985:
1986: 2. Most of the select statements assume that PT_APPROVED row for accepted
1987: partner exists in pv_lead_assignments until oppty is recycled by the partner
1988:
1989: 3. ISSUE : RECYCLED from_status does not have partner_id populated in
1990: pv_assignment_logs. So, rejected partner query may not give the correct result
1991:

Line 2100: FROM pv_lead_assignments pval

2096: ,'PT_REJECTED','Y'
2097: ,'PT_ABANDONED','Y'
2098: ,'PT_TIMEOUT','Y'
2099: ,'N')
2100: FROM pv_lead_assignments pval
2101: WHERE pval.lead_id = pc_lead_id
2102: AND pval.status in ('PT_REJECTED', 'PT_ABANDONED', 'PT_TIMEOUT')
2103: AND pval.partner_id = pc_partner_id;
2104:

Line 3340: FROM pv_lead_assignments pla,

3336: , pla.status
3337: , plw.routing_type
3338: , pla.wf_item_key
3339: , pla.assign_sequence
3340: FROM pv_lead_assignments pla,
3341: pv_lead_workflows plw
3342: WHERE plw.lead_id = pc_lead_id
3343: AND plw.wf_item_key = pla.wf_item_key
3344: AND plw.wf_item_type = pla.wf_item_type