DBA Data[Home] [Help]

APPS.ASN_MIG_SALES_CREDITS_PVT dependencies on AS_STATUSES_VL

Line 2200: FROM as_leads_all lead, as_statuses_vl status

2196: CURSOR c_lead(p_lead_id NUMBER) IS
2197: SELECT lead.description, lead.customer_id, lead.address_id, lead.owner_salesforce_id,
2198: lead.owner_sales_group_id, lead.status ,lead.win_probability, status.win_loss_indicator,
2199: status.forecast_rollup_flag ,status.OPP_OPEN_STATUS_FLAG
2200: FROM as_leads_all lead, as_statuses_vl status
2201: WHERE lead_id = p_lead_id
2202: AND lead.status = status.status_code(+);
2203:
2204: -- Ordering by preferred candidates for owner in Sales Team