APPS.POR_VIEW_REQS_PKG dependencies on PO_REQ_DISTRIBUTIONS_ALL

Line 281: from po_req_distributions_all

277: value VARCHAR2(1000) := '';
278: begin
279: select count(distinct nvl(code_combination_id,0))
280: into no_of_values
281: from po_req_distributions_all
282: where requisition_line_id = req_line_id;
283:
284: if (no_of_values > 1) then
285: return 'MULTIPLE_VALUE';

Line 290: po_req_distributions_all prd,

286: else
287: select concatenated_segments
288: into value
289: from
290: po_req_distributions_all prd,
291: gl_code_combinations_kfv cc,
292: gl_sets_of_books sob,
293: financials_system_params_all fsp
294: where

Line 316: from po_req_distributions_all

312: value VARCHAR2(1000) := '';
313: begin
314: select count(distinct nvl(project_id,0))
315: into no_of_values
316: from po_req_distributions_all
317: where requisition_line_id = req_line_id;
318:
319: if (no_of_values > 1) then
320: return 'MULTIPLE_VALUE';

Line 325: po_req_distributions_all prd,

321: else
322: select projects.segment1
323: into value
324: from
325: po_req_distributions_all prd,
326: pa_projects_all projects
327: where
328: prd.requisition_line_id = req_line_id and
329: projects.project_id = prd.project_id and

Line 346: from po_req_distributions_all

342: value VARCHAR2(1000) := '';
343: begin
344: select count(distinct nvl(task_id,0))
345: into no_of_values
346: from po_req_distributions_all
347: where requisition_line_id = req_line_id;
348:
349: if (no_of_values > 1) then
350: return 'MULTIPLE_VALUE';

Line 355: po_req_distributions_all prd,

351: else
352: select tasks.task_name
353: into value
354: from
355: po_req_distributions_all prd,
356: pa_tasks_expend_v tasks
357: where
358: prd.requisition_line_id = req_line_id and
359: tasks.task_id = prd.task_id and

Line 376: from po_req_distributions_all

372: value VARCHAR2(1000) := '';
373: begin
374: select count(distinct nvl(expenditure_type,''))
375: into no_of_values
376: from po_req_distributions_all
377: where requisition_line_id = req_line_id;
378:
379: if (no_of_values > 1) then
380: return 'MULTIPLE_VALUE';

Line 384: from po_req_distributions_all

380: return 'MULTIPLE_VALUE';
381: else
382: select expenditure_type
383: into value
384: from po_req_distributions_all
385: where
386: requisition_line_id = req_line_id and
387: rownum =1 ;
388:

Line 1209: PO_REQ_DISTRIBUTIONS_ALL PRD,

1205: SELECT
1206: PH.PO_HEADER_ID, PR.PO_RELEASE_ID
1207: FROM
1208: PO_REQUISITION_LINES_ALL PRL,
1209: PO_REQ_DISTRIBUTIONS_ALL PRD,
1210: PO_DISTRIBUTIONS_ALL PD,
1211: PO_RELEASES_ALL PR,
1212: PO_HEADERS_ALL PH
1213: WHERE

Line 1479: PO_REQ_DISTRIBUTIONS_ALL PRD,

1475: SELECT
1476: HOU.NAME ORG_NAME, PH.ORG_ID
1477: FROM
1478: PO_REQUISITION_LINES_ALL PRL,
1479: PO_REQ_DISTRIBUTIONS_ALL PRD,
1480: PO_DISTRIBUTIONS_ALL PD,
1481: PO_HEADERS_ALL PH,
1482: HR_ALL_ORGANIZATION_UNITS_VL HOU
1483: WHERE

Line 1524: PO_REQ_DISTRIBUTIONS_ALL PRD,

1520: CURSOR c_purchasing_org (c_req_line_id NUMBER) IS
1521: SELECT
1522: HOU.NAME ORG_NAME, PH.ORG_ID
1523: FROM
1524: PO_REQ_DISTRIBUTIONS_ALL PRD,
1525: PO_DISTRIBUTIONS_ALL PD,
1526: PO_HEADERS_ALL PH,
1527: HR_ALL_ORGANIZATION_UNITS_VL HOU
1528: WHERE