DBA Data[Home] [Help]

APPS.PV_WORKFLOW_PUB dependencies on PV_OPPTY_ROUTING_LOGS

Line 3041: pv_oppty_routing_logs a,

3037: select
3038: nvl(h.name, e.party_name) organization
3039: from
3040: PV_LEAD_ASSIGNMENTS C,
3041: pv_oppty_routing_logs a,
3042: pv_partner_profiles d,
3043: hz_parties e,
3044: HR_ALL_ORGANIZATION_UNITS_TL h
3045: where

Line 3088: pv_oppty_routing_logs a,

3084: else (g.source_first_name || ' ' || g.source_last_name)
3085: end person_name
3086: from
3087: PV_LEAD_ASSIGNMENTS C,
3088: pv_oppty_routing_logs a,
3089: jtf_rs_resource_extns g
3090: where
3091: c.wf_item_type = 'PVASGNMT'
3092: and c.wf_item_key = (select substr(context,10,LENGTH(CONTEXT)-10)