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 100: from po_requisition_lines_all

96: l_address_info VARCHAR2(240);
97: begin
98: select count(distinct nvl(deliver_to_location_id,0))
99: into no_of_values
100: from po_requisition_lines_all
101: where requisition_header_id = req_header_id;
102:
103: if (no_of_values > 1) then
104: return '';

Line 117: po_requisition_lines_all prl

113: select decode(hrtl.description,null,'',hrtl.description)
114: into value
115: from
116: hr_locations_all_tl hrtl,
117: po_requisition_lines_all prl
118: where
119: hrtl.location_id = prl.deliver_to_location_id AND
120: prl.requisition_header_id = req_header_id AND
121: hrtl.language = userenv('LANG') AND

Line 130: po_requisition_lines_all prl

126: select hrl.location_id
127: into l_location_id
128: from
129: hr_locations hrl,
130: po_requisition_lines_all prl
131: where
132: hrl.location_id = prl.deliver_to_location_id AND
133: prl.requisition_header_id = req_header_id AND
134: rownum = 1;

Line 167: po_requisition_lines_all prl

163: select SUM(decode(prl.matching_basis, 'AMOUNT', prl.amount,
164: prl.unit_price * (prl.quantity - nvl(prl.quantity_cancelled,0))))
165: into value
166: from
167: po_requisition_lines_all prl
168: where
169: requisition_header_id = req_header_id
170: and nvl(modified_by_agent_flag, 'N') = 'N'
171: and nvl(cancel_flag, 'N') = 'N';

Line 185: from po_requisition_lines_all

181: value VARCHAR2(1000) := '';
182: begin
183: select note_to_agent
184: into value
185: from po_requisition_lines_all
186: where
187: requisition_header_id = req_header_id and
188: rownum = 1;
189:

Line 535: from PO_REQUISITION_LINES_ALL PRL,

531: l_total_count NUMBER;
532: begin
533: select to_char(OOH.ORDER_NUMBER), OOH.FLOW_STATUS_CODE, OOL.LINE_ID
534: INTO l_so_number, l_status_code, l_line_id
535: from PO_REQUISITION_LINES_ALL PRL,
536: PO_REQUISITION_HEADERS_ALL PRH,
537: OE_ORDER_HEADERS_ALL OOH,
538: OE_ORDER_LINES_ALL OOL,
539: PO_SYSTEM_PARAMETERS_ALL PSP

Line 593: FROM PO_REQUISITION_LINES_ALL PRL,

589: function get_supplier_name(req_header_id NUMBER) RETURN VARCHAR2 is
590:
591: CURSOR req_supplier_info (c_req_header_id NUMBER) IS
592: SELECT PRL.suggested_vendor_name, PRL.vendor_id
593: FROM PO_REQUISITION_LINES_ALL PRL,
594: po_line_types plt
595: where prl.requisition_header_id = c_req_header_id
596: and prl.source_type_code = 'VENDOR'
597: and prl.line_type_id = plt.line_type_id

Line 603: FROM PO_REQUISITION_LINES_ALL PRL,

599:
600:
601: CURSOR contractor_req_supplier_info (c_req_header_id NUMBER) IS
602: SELECT prl.suggested_vendor_name, prl.requisition_line_id
603: FROM PO_REQUISITION_LINES_ALL PRL,
604: po_line_types plt
605: where prl.requisition_header_id = c_req_header_id
606: and prl.source_type_code = 'VENDOR'
607: and prl.line_type_id = plt.line_type_id

Line 819: po_requisition_lines_all prl,

815: select plc_urg.displayed_field
816: into value
817: from
818: po_requisition_headers_all prh,
819: po_requisition_lines_all prl,
820: po_lookup_codes plc_urg
821: where
822: prh.requisition_header_id = req_header_id and
823: prl.requisition_header_id = prh.requisition_header_id and

Line 909: from po_requisition_lines_all

905: total NUMBER := 0;
906: begin
907: select nvl(cancel_flag, 'N')
908: into cancelled
909: from po_requisition_lines_all
910: where requisition_line_id = req_line_id;
911:
912: if (cancelled = 'Y') then
913: select to_char(0, fnd_currency.safe_get_format_mask(currency_code, 30))

Line 919: from po_requisition_lines_all prl

915: from sys.dual;
916: else
917: select prl.unit_price * (prl.quantity - nvl(prl.quantity_cancelled,0))
918: into total
919: from po_requisition_lines_all prl
920: where requisition_line_id = req_line_id;
921:
922: select to_char(total, fnd_currency.safe_get_format_mask(currency_code, 30))
923: into value

Line 940: from po_requisition_lines_all

936: begin
937:
938: select count(*)
939: into num_line_modified
940: from po_requisition_lines_all
941: where requisition_header_id = reqHeaderId
942: and MODIFIED_BY_AGENT_FLAG = 'Y';
943:
944: if num_line_modified > 0 then

Line 1051: FROM PO_REQUISITION_LINES_ALL PRL

1047: x_cancels NUMBER := 0;
1048: BEGIN
1049: SELECT COUNT(*)
1050: INTO X_CANCELS
1051: FROM PO_REQUISITION_LINES_ALL PRL
1052: WHERE PRL.REQUISITION_HEADER_ID = P_REQ_HEADER_ID
1053: AND NVL(CANCEL_FLAG, 'N') = 'N';
1054:
1055: IF ( X_CANCELS > 0 ) THEN

Line 1130: PO_REQUISITION_LINES_ALL PRL,

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

Line 1205: PO_REQUISITION_LINES_ALL PRL,

1201: PH.SEGMENT1 ||DECODE(PR.RELEASE_NUM, NULL,'','-'||PR.RELEASE_NUM))),
1202: min(PRL.REQUISITION_LINE_ID)
1203: into no_of_po, req_line_id_po
1204: FROM
1205: PO_REQUISITION_LINES_ALL PRL,
1206: PO_REQUISITION_HEADERS_ALL PRH,
1207: PO_LINE_LOCATIONS_ALL PLL,
1208: PO_RELEASES_ALL PR,
1209: PO_HEADERS_ALL PH

Line 1230: PO_REQUISITION_LINES_ALL PRL,

1226: SELECT COUNT(DISTINCT(OOH.HEADER_ID)), min(PRL.REQUISITION_LINE_ID)
1227: into no_of_so, req_line_id_so
1228: FROM
1229: PO_REQUISITION_HEADERS PRH,
1230: PO_REQUISITION_LINES_ALL PRL,
1231: OE_ORDER_HEADERS_ALL OOH,
1232: OE_ORDER_LINES_ALL OOL,
1233: PO_SYSTEM_PARAMETERS PSP
1234: WHERE

Line 1288: PO_REQUISITION_LINES_ALL PRL,

1284: purchasing_org,
1285: placed_on_po_flag,
1286: order_status
1287: FROM
1288: PO_REQUISITION_LINES_ALL PRL,
1289: PO_LINE_LOCATIONS_ALL PLL,
1290: PO_RELEASES_ALL PR,
1291: PO_HEADERS_ALL PH,
1292: HR_ALL_ORGANIZATION_UNITS_VL HOU

Line 1321: PO_REQUISITION_LINES_ALL PRL,

1317: placed_on_po_flag,
1318: order_status
1319: FROM
1320: PO_REQUISITION_HEADERS PRH,
1321: PO_REQUISITION_LINES_ALL PRL,
1322: OE_ORDER_HEADERS_ALL OOH,
1323: OE_ORDER_LINES_ALL OOL,
1324: PO_SYSTEM_PARAMETERS PSP
1325: WHERE

Line 1355: PO_REQUISITION_LINES_ALL PRL,

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