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 1472: From as_statuses_vl status

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

Line 2083: From as_leads_all lead, as_statuses_vl status

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