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.PA_PROJECT_REQUEST_PVT dependencies on AS_LEADS

Line 161: FROM as_leads a, as_statuses_tl s

157: v_prq prq%ROWTYPE;
158:
159: CURSOR asl IS
160: SELECT a.lead_number, s.meaning, a.description
161: FROM as_leads a, as_statuses_tl s
162: WHERE a.status = s.status_code
163: AND a.lead_id = p_object_id1
164: AND s.LANGUAGE = userenv('LANG'); -- added for Bug 4099490
165:

Line 212: ELSIF p_object_type = 'AS_LEADS' THEN

208: x_status_name := v_prq.project_status_name;
209: x_description := v_prq.description;
210: END IF;
211:
212: ELSIF p_object_type = 'AS_LEADS' THEN
213: OPEN asl;
214: FETCH asl INTO v_asl;
215: IF asl%NOTFOUND THEN
216: RETURN;

Line 514: l_lead_number AS_LEADS_ALL.lead_number%TYPE;

510: -- added for Bug Fix: 4537865
511: l_person_role_type_tab PA_PLSQL_DATATYPES.Char250TabTyp;
512: l_key_member_tab PA_PLSQL_DATATYPES.Char250TabTyp;
513:
514: l_lead_number AS_LEADS_ALL.lead_number%TYPE;
515: l_lead_description AS_LEADS_ALL.description%TYPE;
516: l_request_type_meaning FND_LOOKUPS.meaning%TYPE;
517:
518: -- Cursor to get the source lead_id for the passed in project request.

Line 515: l_lead_description AS_LEADS_ALL.description%TYPE;

511: l_person_role_type_tab PA_PLSQL_DATATYPES.Char250TabTyp;
512: l_key_member_tab PA_PLSQL_DATATYPES.Char250TabTyp;
513:
514: l_lead_number AS_LEADS_ALL.lead_number%TYPE;
515: l_lead_description AS_LEADS_ALL.description%TYPE;
516: l_request_type_meaning FND_LOOKUPS.meaning%TYPE;
517:
518: -- Cursor to get the source lead_id for the passed in project request.
519:

Line 527: AND object_type_to = 'AS_LEADS';

523: WHERE relationship_type = 'A'
524: AND relationship_subtype = 'PROJECT_REQUEST'
525: AND object_type_from = 'PA_PROJECT_REQUESTS'
526: AND object_id_from1 = p_request_id
527: AND object_type_to = 'AS_LEADS';
528:
529: -- Cursor to get the probability value for a opportunity
530: -- 2418549: Should not default quick entry is the probability is disabled.
531: CURSOR cur_probability (p_lead_id NUMBER ) IS

Line 534: FROM as_leads_all l, as_forecast_prob_all_vl p

530: -- 2418549: Should not default quick entry is the probability is disabled.
531: CURSOR cur_probability (p_lead_id NUMBER ) IS
532: SELECT
533: l.win_probability
534: FROM as_leads_all l, as_forecast_prob_all_vl p
535: WHERE l.lead_id = p_lead_id
536: AND l.win_probability = p.probability_value
537: AND (p.end_date_active IS NULL OR p.end_date_active >= SYSDATE);
538:

Line 597: FROM as_leads_all

593:
594: -- Cursor to get lead number and description for an opportunity
595: CURSOR cur_get_lead_info (p_lead_id NUMBER) IS
596: SELECT lead_number, description
597: FROM as_leads_all
598: WHERE lead_id = p_lead_id;
599:
600: BEGIN
601: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1147: stmt_class2 := ' FROM as_leads l, as_interests i, pa_lookups lookups'

1143: || 'l.lead_id lead_id,'
1144: || 'l.org_id source_org_id,'
1145: || 'null as category ' ; /* removed h.category for bug 3744823 */
1146:
1147: stmt_class2 := ' FROM as_leads l, as_interests i, pa_lookups lookups'
1148: || ' WHERE '
1149: || 'lookups.lookup_type = ''PROJECT_REQUEST_TYPE'' '
1150: || ' AND lookups.lookup_code = :1'
1151: || ' AND ('

Line 1193: ||' FROM as_leads l,'

1189:
1190: --Modified stmt_Class5 for bug 5728842. Added o.object_type_to = 'PA_PROJECT_REQUESTS' condition.
1191: stmt_class5 :='AND l.lead_id NOT IN'
1192: ||' (SELECT l.lead_id'
1193: ||' FROM as_leads l,'
1194: ||' pa_object_relationships o,'
1195: ||' pa_project_requests r'
1196: ||' WHERE l.lead_id = o.object_id_from1'
1197: ||' AND o.object_id_to1 = r.request_id'

Line 1202: ||' AND object_type_from = ''AS_LEADS'')';

1198: ||' AND o.object_type_to = ''PA_PROJECT_REQUESTS'''
1199: ||' AND r.request_type = :13 '
1200: ||' AND o.relationship_type=''A'''
1201: ||' AND o.relationship_subtype =''PROJECT_REQUEST'''
1202: ||' AND object_type_from = ''AS_LEADS'')';
1203:
1204:
1205: stmt_categ1 := 'SELECT DISTINCT lookups.meaning || '' '' || nvl(l.lead_number,'''') request_name,'
1206: ||' l.description description ,'

Line 1217: stmt_categ2 := ' FROM as_leads l'

1213: ||' l.lead_id lead_id,'
1214: ||' l.org_id source_org_id,'
1215: ||' null as category ';
1216:
1217: stmt_categ2 := ' FROM as_leads l'
1218: ||' , as_lead_lines_all ll'
1219: ||' , pa_lead_categories_v h'
1220: ||' , pa_lookups lookups '
1221: ||' WHERE '

Line 1262: ||' FROM as_leads l,'

1258: ||' ) ';
1259:
1260: stmt_categ5 :=' AND l.lead_id NOT IN'
1261: ||' (SELECT l.lead_id'
1262: ||' FROM as_leads l,'
1263: ||' pa_object_relationships o,'
1264: ||' pa_project_requests r'
1265: ||' WHERE l.lead_id = o.object_id_from1'
1266: ||' AND o.object_id_to1 = r.request_id'

Line 1270: ||' AND object_type_from = ''AS_LEADS'')';

1266: ||' AND o.object_id_to1 = r.request_id'
1267: ||' AND r.request_type =:11 '
1268: ||' AND o.relationship_type=''A'' '
1269: ||' AND o.relationship_subtype =''PROJECT_REQUEST'' '
1270: ||' AND object_type_from = ''AS_LEADS'')';
1271:
1272: x_return_status := FND_API.G_RET_STS_SUCCESS;
1273:
1274:

Line 1477: p_source_object =>'AS_LEADS',

1473: p_source_type =>'ORACLE_APPLICATION',
1474: p_application_id =>p_source_application_id,
1475: p_source_reference =>cur_sel_opportunities_rec.source_reference,
1476: p_source_id =>cur_sel_opportunities_rec.lead_id,
1477: p_source_object =>'AS_LEADS',
1478: p_value =>cur_sel_opportunities_rec.value,
1479: p_currency_code =>cur_sel_opportunities_rec.currency_code,
1480: p_cust_party_id =>cur_sel_opportunities_rec.cust_party_id,
1481: p_cust_party_name => null,

Line 1773: stmt_class2 := ' FROM as_leads l, as_interests i, pa_project_requests r, pa_object_relationships o,pa_project_statuses s '

1769: || 'r.request_id request_id,'
1770: || 'l.lead_id lead_id,'
1771: || 'null as category ' ;
1772:
1773: stmt_class2 := ' FROM as_leads l, as_interests i, pa_project_requests r, pa_object_relationships o,pa_project_statuses s '
1774: || ' WHERE '
1775: || ' (l.win_probability >= nvl(:1, 0) OR'
1776: || ' (l.win_probability IS NULL AND :1 IS NULL)'
1777: ||' ) '

Line 1820: ||' AND o.object_type_from = ''AS_LEADS'' '

1816: ||' AND s.project_system_status_code =''PROJ_REQ_CLOSED'' '
1817: ||' AND r.request_type =:12'
1818: ||' AND o.relationship_type=''A'' '
1819: ||' AND o.relationship_subtype =''PROJECT_REQUEST'' '
1820: ||' AND o.object_type_from = ''AS_LEADS'' '
1821: ||' AND o.object_type_to = ''PA_PROJECT_REQUESTS'' ';
1822:
1823: stmt_categ1 := 'SELECT l.total_amount value, '
1824: || 'l.currency_code currency_code,'

Line 1831: stmt_categ2 := ' FROM as_leads l,as_lead_lines ll,pa_lead_categories_v h,pa_project_requests r, pa_object_relationships o,pa_project_statuses s '

1827: || ' r.request_id request_id,'
1828: || 'l.lead_id lead_id,'
1829: || 'h.category category ' ;
1830:
1831: stmt_categ2 := ' FROM as_leads l,as_lead_lines ll,pa_lead_categories_v h,pa_project_requests r, pa_object_relationships o,pa_project_statuses s '
1832: || ' WHERE '
1833: || 'll.product_category_id = h.category_id '
1834: || ' AND l.lead_id = ll.lead_id '
1835: || ' AND ('

Line 1871: ||' AND o.object_type_from = ''AS_LEADS'' '

1867: ||' AND s.project_system_status_code =''PROJ_REQ_CLOSED'' '
1868: ||' AND r.request_type =:10'
1869: ||' AND o.relationship_type=''A'' '
1870: ||' AND o.relationship_subtype =''PROJECT_REQUEST'' '
1871: ||' AND o.object_type_from = ''AS_LEADS'' '
1872: ||' AND o.object_type_to = ''PA_PROJECT_REQUESTS'' ';
1873:
1874:
1875: --Generate group_id for each run of update projects.