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.AS_SALES_LEAD_ASSIGN_PVT dependencies on AS_STATUSES_B

Line 3863: FROM as_statuses_b sta, as_sales_leads sl, as_sales_lead_ranks_b rk

3859: -- Get lead_rank_score and lead creation_date
3860: CURSOR c_get_open_status_flag(c_sales_lead_id NUMBER) IS
3861: SELECT DECODE(sta.opp_open_status_flag, 'Y', 'Y', 'N', NULL),
3862: NVL(rk.min_score, 0), sl.creation_date
3863: FROM as_statuses_b sta, as_sales_leads sl, as_sales_lead_ranks_b rk
3864: WHERE sl.sales_lead_id = c_sales_lead_id
3865: AND sl.status_code = sta.status_code
3866: AND sl.lead_rank_id = rk.rank_id(+);
3867: BEGIN

Line 4164: FROM as_statuses_b sta, as_sales_leads sl, as_sales_lead_ranks_b rk

4160: -- Get lead_rank_score and lead creation_date
4161: CURSOR c_get_open_status_flag(c_sales_lead_id NUMBER) IS
4162: SELECT DECODE(sta.opp_open_status_flag, 'Y', 'Y', 'N', NULL),
4163: NVL(rk.min_score, 0), sl.creation_date
4164: FROM as_statuses_b sta, as_sales_leads sl, as_sales_lead_ranks_b rk
4165: WHERE sl.sales_lead_id = c_sales_lead_id
4166: AND sl.status_code = sta.status_code
4167: AND sl.lead_rank_id = rk.rank_id(+);
4168:

Line 4379: FROM as_statuses_b sta, as_sales_leads sl, as_sales_lead_ranks_b rk

4375: -- Get lead_rank_score and lead creation_date
4376: CURSOR c_get_open_status_flag(c_sales_lead_id NUMBER) IS
4377: SELECT DECODE(sta.opp_open_status_flag, 'Y', 'Y', 'N', NULL),
4378: NVL(rk.min_score, 0), sl.creation_date
4379: FROM as_statuses_b sta, as_sales_leads sl, as_sales_lead_ranks_b rk
4380: WHERE sl.sales_lead_id = c_sales_lead_id
4381: AND sl.status_code = sta.status_code
4382: AND sl.lead_rank_id = rk.rank_id(+);
4383:

Line 4772: FROM as_statuses_b sta, as_sales_leads sl, as_sales_lead_ranks_b rk

4768: -- Get lead_rank_score and lead creation_date
4769: CURSOR c_get_open_status_flag(c_sales_lead_id NUMBER) IS
4770: SELECT DECODE(sta.opp_open_status_flag, 'Y', 'Y', 'N', NULL),
4771: NVL(rk.min_score, 0), sl.creation_date
4772: FROM as_statuses_b sta, as_sales_leads sl, as_sales_lead_ranks_b rk
4773: WHERE sl.sales_lead_id = c_sales_lead_id
4774: AND sl.status_code = sta.status_code
4775: AND sl.lead_rank_id = rk.rank_id(+);
4776: BEGIN

Line 5073: FROM as_statuses_b sta, as_sales_leads sl, as_sales_lead_ranks_b rk

5069: -- Get lead_rank_score and lead creation_date
5070: CURSOR c_get_open_status_flag(c_sales_lead_id NUMBER) IS
5071: SELECT DECODE(sta.opp_open_status_flag, 'Y', 'Y', 'N', NULL),
5072: NVL(rk.min_score, 0), sl.creation_date
5073: FROM as_statuses_b sta, as_sales_leads sl, as_sales_lead_ranks_b rk
5074: WHERE sl.sales_lead_id = c_sales_lead_id
5075: AND sl.status_code = sta.status_code
5076: AND sl.lead_rank_id = rk.rank_id(+);
5077:

Line 5938: FROM as_statuses_b sta, as_sales_leads sl, as_sales_lead_ranks_b rk

5934: -- Get lead_rank_score and lead creation_date
5935: CURSOR c_get_open_status_flag(c_sales_lead_id NUMBER) IS
5936: SELECT DECODE(sta.opp_open_status_flag, 'Y', 'Y', 'N', NULL),
5937: NVL(rk.min_score, 0), sl.creation_date
5938: FROM as_statuses_b sta, as_sales_leads sl, as_sales_lead_ranks_b rk
5939: WHERE sl.sales_lead_id = c_sales_lead_id
5940: AND sl.status_code = sta.status_code
5941: AND sl.lead_rank_id = rk.rank_id(+);
5942: BEGIN