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_REQUISITION_LINES_ALL

Line 65: from po_requisition_lines_all

61: value VARCHAR2(1000) := '';
62: begin
63: select count(distinct nvl(to_person_id,0))
64: into no_of_values
65: from po_requisition_lines_all
66: where requisition_header_id = req_header_id;
67:
68: if (no_of_values > 1) then
69: return 'MULTIPLE_VALUE';

Line 75: po_requisition_lines_all prl

71: select full_name
72: into value
73: from
74: per_all_people_f hre,
75: po_requisition_lines_all prl
76: where
77: sysdate between hre.effective_start_date AND hre.effective_end_date AND
78: prl.to_person_id = hre.person_id AND
79: prl.requisition_header_id = req_header_id AND

Line 113: from po_requisition_lines_all

109:
110: begin
111: select count(distinct nvl(deliver_to_location_id,0))
112: into no_of_values
113: from po_requisition_lines_all
114: where requisition_header_id = req_header_id;
115:
116: if (no_of_values > 1) then
117: return '';

Line 130: po_requisition_lines_all prl

126: select decode(hrtl.description,null,'',hrtl.description)
127: into value
128: from
129: hr_locations_all_tl hrtl,
130: po_requisition_lines_all prl
131: where
132: hrtl.location_id = prl.deliver_to_location_id AND
133: prl.requisition_header_id = req_header_id AND
134: hrtl.language = userenv('LANG') AND

Line 143: po_requisition_lines_all prl

139: select hrl.location_id
140: into l_location_id
141: from
142: hr_locations hrl,
143: po_requisition_lines_all prl
144: where
145: hrl.location_id = prl.deliver_to_location_id AND
146: prl.requisition_header_id = req_header_id AND
147: rownum = 1;

Line 243: po_requisition_lines_all prl

239: select nvl(SUM(decode(prl.matching_basis, 'AMOUNT', prl.amount,
240: prl.unit_price * (prl.quantity - nvl(prl.quantity_cancelled,0)))),0)
241: into value
242: from
243: po_requisition_lines_all prl
244: where
245: requisition_header_id = req_header_id
246: and nvl(modified_by_agent_flag, 'N') = 'N'
247: and nvl(cancel_flag, 'N') = 'N';

Line 261: from po_requisition_lines_all

257: value VARCHAR2(1000) := '';
258: begin
259: select note_to_agent
260: into value
261: from po_requisition_lines_all
262: where
263: requisition_header_id = req_header_id and
264: rownum = 1;
265:

Line 612: from PO_REQUISITION_LINES_ALL PRL,

608: l_total_count NUMBER;
609: begin
610: select to_char(OOH.ORDER_NUMBER), OOH.FLOW_STATUS_CODE, OOL.LINE_ID
611: INTO l_so_number, l_status_code, l_line_id
612: from PO_REQUISITION_LINES_ALL PRL,
613: PO_REQUISITION_HEADERS_ALL PRH,
614: OE_ORDER_HEADERS_ALL OOH,
615: OE_ORDER_LINES_ALL OOL,
616: PO_SYSTEM_PARAMETERS_ALL PSP

Line 671: FROM PO_REQUISITION_LINES_ALL PRL,

667: function get_supplier_name(req_header_id NUMBER) RETURN VARCHAR2 is
668:
669: CURSOR req_supplier_info (c_req_header_id NUMBER) IS
670: SELECT PRL.suggested_vendor_name, PRL.vendor_id
671: FROM PO_REQUISITION_LINES_ALL PRL,
672: po_line_types plt
673: where prl.requisition_header_id = c_req_header_id
674: and prl.source_type_code = 'VENDOR'
675: and prl.line_type_id = plt.line_type_id

Line 681: FROM PO_REQUISITION_LINES_ALL PRL,

677:
678:
679: CURSOR contractor_req_supplier_info (c_req_header_id NUMBER) IS
680: SELECT prl.suggested_vendor_name, prl.requisition_line_id
681: FROM PO_REQUISITION_LINES_ALL PRL,
682: po_line_types plt
683: where prl.requisition_header_id = c_req_header_id
684: and prl.source_type_code = 'VENDOR'
685: and prl.line_type_id = plt.line_type_id

Line 897: po_requisition_lines_all prl,

893: select plc_urg.displayed_field
894: into value
895: from
896: po_requisition_headers_all prh,
897: po_requisition_lines_all prl,
898: po_lookup_codes plc_urg
899: where
900: prh.requisition_header_id = req_header_id and
901: prl.requisition_header_id = prh.requisition_header_id and

Line 987: from po_requisition_lines_all

983: total NUMBER := 0;
984: begin
985: select nvl(cancel_flag, 'N')
986: into cancelled
987: from po_requisition_lines_all
988: where requisition_line_id = req_line_id;
989:
990: if (cancelled = 'Y') then
991: select to_char(0, fnd_currency.safe_get_format_mask(currency_code, 30))

Line 997: from po_requisition_lines_all prl

993: from sys.dual;
994: else
995: select prl.unit_price * (prl.quantity - nvl(prl.quantity_cancelled,0))
996: into total
997: from po_requisition_lines_all prl
998: where requisition_line_id = req_line_id;
999:
1000: select to_char(total, fnd_currency.safe_get_format_mask(currency_code, 30))
1001: into value

Line 1018: from po_requisition_lines_all

1014: begin
1015:
1016: select count(*)
1017: into num_line_modified
1018: from po_requisition_lines_all
1019: where requisition_header_id = reqHeaderId
1020: and MODIFIED_BY_AGENT_FLAG = 'Y';
1021:
1022: if num_line_modified > 0 then

Line 1129: FROM PO_REQUISITION_LINES_ALL PRL

1125: x_cancels NUMBER := 0;
1126: BEGIN
1127: SELECT COUNT(*)
1128: INTO X_CANCELS
1129: FROM PO_REQUISITION_LINES_ALL PRL
1130: WHERE PRL.REQUISITION_HEADER_ID = P_REQ_HEADER_ID
1131: AND NVL(CANCEL_FLAG, 'N') = 'N';
1132:
1133: IF ( X_CANCELS > 0 ) THEN

Line 1208: PO_REQUISITION_LINES_ALL PRL,

1204: CURSOR c_po_info (c_req_header_id NUMBER) IS
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

Line 1328: PO_REQUISITION_LINES_ALL PRL,

1324: nvl(PH.CLM_DOCUMENT_NUMBER,PH.SEGMENT1) ||DECODE(PR.RELEASE_NUM, NULL,'','-'||PR.RELEASE_NUM))),
1325: min(PRL.REQUISITION_LINE_ID)
1326: into no_of_po, req_line_id_po
1327: FROM
1328: PO_REQUISITION_LINES_ALL PRL,
1329: PO_REQUISITION_HEADERS_ALL PRH,
1330: PO_LINE_LOCATIONS_ALL PLL,
1331: PO_RELEASES_ALL PR,
1332: PO_HEADERS_ALL PH

Line 1353: PO_REQUISITION_LINES_ALL PRL,

1349: SELECT COUNT(DISTINCT(OOH.HEADER_ID)), min(PRL.REQUISITION_LINE_ID)
1350: into no_of_so, req_line_id_so
1351: FROM
1352: PO_REQUISITION_HEADERS PRH,
1353: PO_REQUISITION_LINES_ALL PRL,
1354: OE_ORDER_HEADERS_ALL OOH,
1355: OE_ORDER_LINES_ALL OOL,
1356: PO_SYSTEM_PARAMETERS PSP
1357: WHERE

Line 1411: PO_REQUISITION_LINES_ALL PRL,

1407: purchasing_org,
1408: placed_on_po_flag,
1409: order_status
1410: FROM
1411: PO_REQUISITION_LINES_ALL PRL,
1412: PO_LINE_LOCATIONS_ALL PLL,
1413: PO_RELEASES_ALL PR,
1414: PO_HEADERS_ALL PH,
1415: HR_ALL_ORGANIZATION_UNITS_VL HOU

Line 1444: PO_REQUISITION_LINES_ALL PRL,

1440: placed_on_po_flag,
1441: order_status
1442: FROM
1443: PO_REQUISITION_HEADERS PRH,
1444: PO_REQUISITION_LINES_ALL PRL,
1445: OE_ORDER_HEADERS_ALL OOH,
1446: OE_ORDER_LINES_ALL OOL,
1447: PO_SYSTEM_PARAMETERS PSP
1448: WHERE

Line 1478: PO_REQUISITION_LINES_ALL PRL,

1474: CURSOR c_purchasing_org (c_req_header_id NUMBER) IS
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