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.PO_RELGEN_PKG dependencies on PO_REQUISITION_LINES

Line 172: from po_requisition_lines

168: from po_requisition_headers
169: where requisition_header_id = po_req_lines.requisition_header_id;
170:
171: select line_num into x_req_line_num
172: from po_requisition_lines
173: where requisition_line_id = po_req_lines.requisition_line_id;
174:
175: IF ( po_req_lines.req_uom <> po_req_lines.po_uom ) AND
176: nvl(x_uom_convert,'Y') <> 'Y' THEN

Line 321: from po_requisition_lines

317: where requisition_header_id = old_po_req_line.requisition_header_id;
318:
319:
320: select line_num into x_req_line_num
321: from po_requisition_lines
322: where requisition_line_id = old_po_req_line.requisition_line_id;
323:
324:
325:

Line 582: from po_requisition_lines

578: where requisition_header_id = old_po_req_line.requisition_header_id;
579:
580:
581: select line_num into x_req_line_num
582: from po_requisition_lines
583: where requisition_line_id = old_po_req_line.requisition_line_id;
584:
585:
586: -- If the release fails any of the pre-approval checks, rollback

Line 857: l_quantity po_requisition_lines_all.quantity%TYPE := null;

853: --frkhan 1/12/99
854: x_country_of_origin_code varchar2(2);
855:
856: /* */
857: l_quantity po_requisition_lines_all.quantity%TYPE := null;
858: l_price_break_type varchar2(1) := null;
859: l_po_line_id po_lines_all.po_line_id%TYPE := null;
860: l_cumulative_flag boolean;
861: l_dest_org_id po_requisition_lines_all.destination_organization_id%TYPE := null;

Line 861: l_dest_org_id po_requisition_lines_all.destination_organization_id%TYPE := null;

857: l_quantity po_requisition_lines_all.quantity%TYPE := null;
858: l_price_break_type varchar2(1) := null;
859: l_po_line_id po_lines_all.po_line_id%TYPE := null;
860: l_cumulative_flag boolean;
861: l_dest_org_id po_requisition_lines_all.destination_organization_id%TYPE := null;
862: l_need_by_date po_requisition_lines_all.need_by_date%TYPE := null;
863: /* */
864:
865: --

Line 862: l_need_by_date po_requisition_lines_all.need_by_date%TYPE := null;

858: l_price_break_type varchar2(1) := null;
859: l_po_line_id po_lines_all.po_line_id%TYPE := null;
860: l_cumulative_flag boolean;
861: l_dest_org_id po_requisition_lines_all.destination_organization_id%TYPE := null;
862: l_need_by_date po_requisition_lines_all.need_by_date%TYPE := null;
863: /* */
864:
865: --
866: l_promised_date DATE := NULL;

Line 1266: UPDATE PO_REQUISITION_LINES

1262: l_matching_basis, --bug 4896950
1263: l_unit_meas_lookup_code --bug 4896950
1264: );
1265:
1266: UPDATE PO_REQUISITION_LINES
1267: SET line_location_id = x_line_location_id,
1268: reqs_in_pool_flag = NULL, --
1269: last_update_date = SYSDATE
1270: WHERE requisition_line_id = req_line.requisition_line_id;

Line 1552: PO_REQUISITION_LINES PRL,

1548: --added distribution_type for encumb. rewrite
1549: PLL.shipment_type,
1550: PH.Org_Id --
1551: FROM PO_REQ_DISTRIBUTIONS PRD,
1552: PO_REQUISITION_LINES PRL,
1553: PO_HEADERS PH,
1554: PO_LINE_LOCATIONS PLL
1555: WHERE PRD.REQUISITION_LINE_ID = req_line.requisition_line_id
1556: AND PRL.REQUISITION_LINE_ID = req_line.requisition_line_id

Line 1572: PO_REQUISITION_LINES PORL

1568:
1569: SELECT POLL.quantity
1570: INTO x_shipment_quantity
1571: FROM PO_LINE_LOCATIONS POLL,
1572: PO_REQUISITION_LINES PORL
1573: WHERE POLL.LINE_LOCATION_ID = PORL.LINE_LOCATION_ID
1574: AND PORL.REQUISITION_LINE_ID
1575: = req_line.requisition_line_id;
1576:

Line 1580: PO_REQUISITION_LINES PORL,

1576:
1577: SELECT SUM(POD.QUANTITY_ORDERED)
1578: INTO x_dist_quantity
1579: FROM PO_LINE_LOCATIONS POLL,
1580: PO_REQUISITION_LINES PORL,
1581: PO_DISTRIBUTIONS POD
1582: WHERE POLL.LINE_LOCATION_ID = PORL.LINE_LOCATION_ID
1583: AND PORL.REQUISITION_LINE_ID
1584: = req_line.requisition_line_id

Line 1597: PO_REQUISITION_LINES PORL

1593: WHERE POD.PO_DISTRIBUTION_ID =
1594: (SELECT POD2.PO_DISTRIBUTION_ID
1595: FROM PO_DISTRIBUTIONS POD2,
1596: PO_LINE_LOCATIONS POLL,
1597: PO_REQUISITION_LINES PORL
1598: WHERE POD2.LINE_LOCATION_ID
1599: = POLL.LINE_LOCATION_ID
1600: AND POLL.LINE_LOCATION_ID
1601: = PORL.LINE_LOCATION_ID

Line 2354: FROM po_requisition_lines

2350:
2351: BEGIN
2352: SELECT requisition_header_id
2353: INTO x_p_req_header_id
2354: FROM po_requisition_lines
2355: WHERE requisition_line_id = req_line.requisition_line_id;
2356: EXCEPTION
2357: WHEN NO_DATA_FOUND THEN raise;
2358: WHEN OTHERS THEN raise;

Line 2395: po_requisition_lines prl,

2391: SELECT prh.segment1, prl.line_num
2392: INTO x_req_num, x_req_line_num
2393: FROM po_distributions pod,
2394: po_req_distributions prd,
2395: po_requisition_lines prl,
2396: po_requisition_headers prh
2397: WHERE pod.po_distribution_id = p_po_distribution_id
2398: AND pod.req_distribution_id = prd.distribution_id
2399: AND prl.requisition_line_id = prd.requisition_line_id

Line 2522: FROM PO_REQUISITION_LINES PRL,

2518: SELECT min(PRL.unit_price),
2519: PRL.unit_meas_lookup_code,
2520: min(POL.line_num),
2521: min(POLL.shipment_num)
2522: FROM PO_REQUISITION_LINES PRL,
2523: PO_LINE_LOCATIONS POLL,
2524: PO_LINES POL
2525: WHERE PRL.line_location_id = POLL.line_location_id
2526: AND POLL.line_location_id = p_line_location_id

Line 2537: FROM PO_REQUISITION_LINES PRL,

2533: PRL.unit_meas_lookup_code,
2534: sum(PD.quantity_ordered),
2535: min(POL.line_num),
2536: min(POLL.shipment_num)
2537: FROM PO_REQUISITION_LINES PRL,
2538: PO_LINE_LOCATIONS POLL,
2539: PO_LINES POL,
2540: PO_DISTRIBUTIONS PD,
2541: PO_REQ_DISTRIBUTIONS PRD