DBA Data[Home] [Help]

APPS.PV_OPPTY_ROUTING_LOG dependencies on HZ_PARTIES

Line 61: hz_parties party,

57: FROM
58: pv_lead_assignments assgn,
59: pv_lead_workflows ldwf,
60: pv_partner_profiles partprof,
61: hz_parties party,
62: pv_oppty_routing_logs logs,
63: pv_lookups plkp1
64: WHERE
65: logs.oppty_routing_log_id= pc_oppty_routing_log_id

Line 82: hz_parties party

78: party.party_name
79: FROM
80: pv_lead_assignments assgn,
81: pv_partner_profiles partprof,
82: hz_parties party
83: WHERE
84: assgn.lead_assignment_id = pc_lead_assignment_id --10569
85: and assgn.partner_id = partprof.partner_id
86: and partprof.partner_party_id = party.party_id

Line 95: hz_parties party

91: party.party_name
92: FROM
93: pv_lead_assignments assgn,
94: pv_partner_profiles partprof,
95: hz_parties party
96: WHERE
97: assgn.lead_assignment_id = pc_lead_assignment_id --10569
98: and assgn.partner_id = partprof.partner_id
99: and partprof.partner_party_id = party.party_id

Line 108: hz_parties party

104: party.party_name
105: FROM
106: pv_lead_assignments assgn,
107: pv_partner_profiles partprof,
108: hz_parties party
109: WHERE
110: assgn.lead_assignment_id = pc_lead_assignment_id --10569
111: and assgn.partner_id = partprof.partner_id
112: and partprof.partner_party_id = party.party_id

Line 121: hz_parties party

117: party.party_name
118: FROM
119: pv_lead_assignments assgn,
120: pv_partner_profiles partprof,
121: hz_parties party
122: WHERE
123: assgn.lead_assignment_id = pc_lead_assignment_id --10569
124: and assgn.partner_id = partprof.partner_id
125: and partprof.partner_party_id = party.party_id