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_REFERRAL_GENERAL_PUB dependencies on AS_STATUSES_B

Line 120: as_statuses_b STATUS

116: CURSOR c_closed_lost_oppty IS
117: SELECT REF.referral_id, REF.referral_name, REF.benefit_id, REF.partner_id
118: FROM pv_referrals_vl REF,
119: as_leads_all OPPTY,
120: as_statuses_b STATUS
121: WHERE REF.referral_status = 'APPROVED' AND
122: REF.entity_type IN ('LEAD') AND
123: REF.entity_id_linked_to = OPPTY.lead_id AND
124: OPPTY.status = STATUS.status_code AND

Line 133: as_statuses_b STATUS

129: CURSOR c_closed_oppty_won IS
130: SELECT REF.referral_id, REF.referral_name, REF.benefit_id, REF.partner_id
131: FROM pv_referrals_vl REF,
132: as_leads_all OPPTY,
133: as_statuses_b STATUS
134: WHERE REF.referral_status = 'APPROVED' AND
135: REF.entity_type IN ('LEAD') AND
136: REF.entity_id_linked_to = OPPTY.lead_id AND
137: OPPTY.status = STATUS.status_code AND

Line 180: AS_STATUSES_B AA,

176: C.QUOTE_HEADER_ID,
177: E.PARTY_NAME
178: FROM pv_referrals_b REF,
179: AS_LEADS_ALL A,
180: AS_STATUSES_B AA,
181: ASO_QUOTE_RELATED_OBJECTS B,
182: ASO_QUOTE_HEADERS_ALL C,
183: HZ_CUST_ACCOUNTS D,
184: HZ_PARTIES E

Line 219: AS_STATUSES_B e,

215: FROM pv_lead_workflows a,
216: pv_lead_assignments b,
217: as_leads_all c,
218: hz_parties d,
219: AS_STATUSES_B e,
220: ASO_QUOTE_RELATED_OBJECTS f,
221: ASO_QUOTE_HEADERS_ALL g
222: WHERE a.latest_routing_flag = 'Y' AND
223: a.routing_status = 'ACTIVE' AND