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_OPP_HEADER_PVT dependencies on AS_STATUSES_VL

Line 194: from as_statuses_vl

190: IS
191:
192: CURSOR status_name(c_status_code VARCHAR2) IS
193: select meaning
194: from as_statuses_vl
195: where STATUS_CODE = c_status_code;
196:
197: CURSOR stage_name(c_sales_stage_id NUMBER) IS
198: SELECT name

Line 1473: From as_statuses_vl status

1469:
1470: CURSOR c_get_status_flags (p_status_code VARCHAR2) IS
1471: Select status.win_loss_indicator,
1472: status.forecast_rollup_flag
1473: From as_statuses_vl status
1474: Where status.status_code = p_status_code;
1475:
1476: l_api_name CONSTANT VARCHAR2(30) := 'Update_opp_header';
1477: l_api_version_number CONSTANT NUMBER := 2.0;

Line 2084: From as_leads_all lead, as_statuses_vl status

2080: Select lead.win_probability, status.win_loss_indicator,
2081: status.forecast_rollup_flag
2082: Into l_win_probability, l_win_loss_indicator,
2083: l_forecast_rollup_flag
2084: From as_leads_all lead, as_statuses_vl status
2085: Where lead_id = l_Header_rec.LEAD_ID
2086: And lead.status = status.status_code(+);
2087:
2088: IF AS_OPP_SALES_CREDIT_PVT.Apply_Forecast_Defaults(