APPS.PV_REFERRAL_GENERAL_PUB dependencies on ASO_QUOTE_RELATED_OBJECTS

Line 181: ASO_QUOTE_RELATED_OBJECTS B,

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
185: WHERE REF.entity_type IN ('LEAD') AND

Line 220: ASO_QUOTE_RELATED_OBJECTS f,

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
224: a.WF_ITEM_TYPE = 'PVASGNMT' AND -- indicates vendor routing