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.POR_VIEW_REQS_PKG dependencies on PO_REQ_DISTRIBUTIONS

Line 205: from po_req_distributions_all

201: value VARCHAR2(1000) := '';
202: begin
203: select count(distinct nvl(code_combination_id,0))
204: into no_of_values
205: from po_req_distributions_all
206: where requisition_line_id = req_line_id;
207:
208: if (no_of_values > 1) then
209: return 'MULTIPLE_VALUE';

Line 214: po_req_distributions_all prd,

210: else
211: select concatenated_segments
212: into value
213: from
214: po_req_distributions_all prd,
215: gl_code_combinations_kfv cc,
216: gl_sets_of_books sob,
217: financials_system_params_all fsp
218: where

Line 240: from po_req_distributions_all

236: value VARCHAR2(1000) := '';
237: begin
238: select count(distinct nvl(project_id,0))
239: into no_of_values
240: from po_req_distributions_all
241: where requisition_line_id = req_line_id;
242:
243: if (no_of_values > 1) then
244: return 'MULTIPLE_VALUE';

Line 249: po_req_distributions_all prd,

245: else
246: select projects.segment1
247: into value
248: from
249: po_req_distributions_all prd,
250: pa_projects_all projects
251: where
252: prd.requisition_line_id = req_line_id and
253: projects.project_id = prd.project_id and

Line 270: from po_req_distributions_all

266: value VARCHAR2(1000) := '';
267: begin
268: select count(distinct nvl(task_id,0))
269: into no_of_values
270: from po_req_distributions_all
271: where requisition_line_id = req_line_id;
272:
273: if (no_of_values > 1) then
274: return 'MULTIPLE_VALUE';

Line 279: po_req_distributions_all prd,

275: else
276: select tasks.task_name
277: into value
278: from
279: po_req_distributions_all prd,
280: pa_tasks tasks
281: where
282: prd.requisition_line_id = req_line_id and
283: tasks.task_id = prd.task_id and

Line 300: from po_req_distributions_all

296: value VARCHAR2(1000) := '';
297: begin
298: select count(distinct nvl(expenditure_type,''))
299: into no_of_values
300: from po_req_distributions_all
301: where requisition_line_id = req_line_id;
302:
303: if (no_of_values > 1) then
304: return 'MULTIPLE_VALUE';

Line 308: from po_req_distributions_all

304: return 'MULTIPLE_VALUE';
305: else
306: select expenditure_type
307: into value
308: from po_req_distributions_all
309: where
310: requisition_line_id = req_line_id and
311: rownum =1 ;
312:

Line 857: po_req_distributions prd

853: to_char(prd.expenditure_item_date, date_format)
854: into project_id, task_id, expenditure_type,
855: expenditure_org_id, expenditure_item_date
856: from
857: po_req_distributions prd
858: where prd.requisition_line_id = req_line_id and
859: rownum = 1;
860:
861: if (project_id is not null) then

Line 865: po_req_distributions prd,

861: if (project_id is not null) then
862: select projects.segment1
863: into project_number
864: from
865: po_req_distributions prd,
866: pa_projects projects
867: where
868: prd.requisition_line_id = req_line_id and
869: projects.project_id = prd.project_id and

Line 877: po_req_distributions prd,

873: if (task_id is not null) then
874: select tasks.task_number
875: into task_number
876: from
877: po_req_distributions prd,
878: pa_tasks tasks
879: where
880: prd.requisition_line_id = req_line_id and
881: tasks.task_id = prd.task_id and rownum = 1 ;

Line 888: po_req_distributions prd,

884: if (expenditure_org_id is not null) then
885: select orgs.name
886: into expenditure_org
887: from
888: po_req_distributions prd,
889: pa_organizations_expend_v orgs
890: where
891: prd.requisition_line_id = req_line_id and
892: prd.expenditure_organization_id = orgs.organization_id and

Line 983: po_req_distributions prd,

979:
980: SELECT sum(nvl(prd.nonrecoverable_tax,0))
981: INTO total
982: FROM
983: po_req_distributions prd,
984: po_requisition_lines prl
985: WHERE
986: prd.requisition_line_id = prl.requisition_line_id and
987: prl.requisition_header_id= ReqHeaderId and

Line 1006: po_req_distributions prd,

1002: BEGIN
1003: SELECT sum(nvl(prd.nonrecoverable_tax,0))
1004: INTO total
1005: FROM
1006: po_req_distributions prd,
1007: po_requisition_lines prl
1008: WHERE
1009: prd.requisition_line_id = ReqLineId AND
1010: prd.requisition_line_id = prl.requisition_line_id AND

Line 1030: po_req_distributions prd,

1026: BEGIN
1027: SELECT sum(nvl(prd.recoverable_tax,0))
1028: INTO total
1029: FROM
1030: po_req_distributions prd,
1031: po_requisition_lines prl
1032: WHERE
1033: prd.requisition_line_id = ReqLineId AND
1034: prd.requisition_line_id = prl.requisition_line_id AND

Line 1131: PO_REQ_DISTRIBUTIONS_ALL PRD,

1127: SELECT
1128: PH.PO_HEADER_ID, PR.PO_RELEASE_ID
1129: FROM
1130: PO_REQUISITION_LINES_ALL PRL,
1131: PO_REQ_DISTRIBUTIONS_ALL PRD,
1132: PO_DISTRIBUTIONS_ALL PD,
1133: PO_RELEASES_ALL PR,
1134: PO_HEADERS_ALL PH
1135: WHERE

Line 1356: PO_REQ_DISTRIBUTIONS_ALL PRD,

1352: SELECT
1353: HOU.NAME ORG_NAME, PH.ORG_ID
1354: FROM
1355: PO_REQUISITION_LINES_ALL PRL,
1356: PO_REQ_DISTRIBUTIONS_ALL PRD,
1357: PO_DISTRIBUTIONS_ALL PD,
1358: PO_HEADERS_ALL PH,
1359: HR_ALL_ORGANIZATION_UNITS_VL HOU
1360: WHERE

Line 1401: PO_REQ_DISTRIBUTIONS_ALL PRD,

1397: CURSOR c_purchasing_org (c_req_line_id NUMBER) IS
1398: SELECT
1399: HOU.NAME ORG_NAME, PH.ORG_ID
1400: FROM
1401: PO_REQ_DISTRIBUTIONS_ALL PRD,
1402: PO_DISTRIBUTIONS_ALL PD,
1403: PO_HEADERS_ALL PH,
1404: HR_ALL_ORGANIZATION_UNITS_VL HOU
1405: WHERE