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 173: from po_requisition_lines

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

Line 322: from po_requisition_lines

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

Line 583: from po_requisition_lines

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

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

859: --frkhan 1/12/99
860: x_country_of_origin_code varchar2(2);
861:
862: /* */
863: l_quantity po_requisition_lines_all.quantity%TYPE := null;
864: l_price_break_type varchar2(1) := null;
865: l_po_line_id po_lines_all.po_line_id%TYPE := null;
866: l_cumulative_flag boolean;
867: l_dest_org_id po_requisition_lines_all.destination_organization_id%TYPE := null;

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

863: l_quantity po_requisition_lines_all.quantity%TYPE := null;
864: l_price_break_type varchar2(1) := null;
865: l_po_line_id po_lines_all.po_line_id%TYPE := null;
866: l_cumulative_flag boolean;
867: l_dest_org_id po_requisition_lines_all.destination_organization_id%TYPE := null;
868: l_need_by_date po_requisition_lines_all.need_by_date%TYPE := null;
869: /* */
870:
871: --

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

864: l_price_break_type varchar2(1) := null;
865: l_po_line_id po_lines_all.po_line_id%TYPE := null;
866: l_cumulative_flag boolean;
867: l_dest_org_id po_requisition_lines_all.destination_organization_id%TYPE := null;
868: l_need_by_date po_requisition_lines_all.need_by_date%TYPE := null;
869: /* */
870:
871: --
872: l_promised_date DATE := NULL;

Line 1275: UPDATE PO_REQUISITION_LINES

1271: l_matching_basis, --bug 4896950
1272: l_unit_meas_lookup_code --bug 4896950
1273: );
1274:
1275: UPDATE PO_REQUISITION_LINES
1276: SET line_location_id = x_line_location_id,
1277: reqs_in_pool_flag = NULL, --
1278: last_update_date = SYSDATE
1279: WHERE requisition_line_id = req_line.requisition_line_id;

Line 1568: PO_REQUISITION_LINES PRL,

1564: --added distribution_type for encumb. rewrite
1565: PLL.shipment_type,
1566: PH.Org_Id --
1567: FROM PO_REQ_DISTRIBUTIONS PRD,
1568: PO_REQUISITION_LINES PRL,
1569: PO_HEADERS PH,
1570: PO_LINE_LOCATIONS PLL
1571: WHERE PRD.REQUISITION_LINE_ID = req_line.requisition_line_id
1572: AND PRL.REQUISITION_LINE_ID = req_line.requisition_line_id

Line 1588: PO_REQUISITION_LINES PORL

1584:
1585: SELECT POLL.quantity
1586: INTO x_shipment_quantity
1587: FROM PO_LINE_LOCATIONS POLL,
1588: PO_REQUISITION_LINES PORL
1589: WHERE POLL.LINE_LOCATION_ID = PORL.LINE_LOCATION_ID
1590: AND PORL.REQUISITION_LINE_ID
1591: = req_line.requisition_line_id;
1592:

Line 1596: PO_REQUISITION_LINES PORL,

1592:
1593: SELECT SUM(POD.QUANTITY_ORDERED)
1594: INTO x_dist_quantity
1595: FROM PO_LINE_LOCATIONS POLL,
1596: PO_REQUISITION_LINES PORL,
1597: PO_DISTRIBUTIONS POD
1598: WHERE POLL.LINE_LOCATION_ID = PORL.LINE_LOCATION_ID
1599: AND PORL.REQUISITION_LINE_ID
1600: = req_line.requisition_line_id

Line 1613: PO_REQUISITION_LINES PORL

1609: WHERE POD.PO_DISTRIBUTION_ID =
1610: (SELECT POD2.PO_DISTRIBUTION_ID
1611: FROM PO_DISTRIBUTIONS POD2,
1612: PO_LINE_LOCATIONS POLL,
1613: PO_REQUISITION_LINES PORL
1614: WHERE POD2.LINE_LOCATION_ID
1615: = POLL.LINE_LOCATION_ID
1616: AND POLL.LINE_LOCATION_ID
1617: = PORL.LINE_LOCATION_ID

Line 2379: FROM po_requisition_lines

2375:
2376: BEGIN
2377: SELECT requisition_header_id
2378: INTO x_p_req_header_id
2379: FROM po_requisition_lines
2380: WHERE requisition_line_id = req_line.requisition_line_id;
2381: EXCEPTION
2382: WHEN NO_DATA_FOUND THEN raise;
2383: WHEN OTHERS THEN raise;

Line 2420: po_requisition_lines prl,

2416: SELECT prh.segment1, prl.line_num
2417: INTO x_req_num, x_req_line_num
2418: FROM po_distributions pod,
2419: po_req_distributions prd,
2420: po_requisition_lines prl,
2421: po_requisition_headers prh
2422: WHERE pod.po_distribution_id = p_po_distribution_id
2423: AND pod.req_distribution_id = prd.distribution_id
2424: AND prl.requisition_line_id = prd.requisition_line_id

Line 2547: FROM PO_REQUISITION_LINES PRL,

2543: SELECT min(PRL.unit_price),
2544: PRL.unit_meas_lookup_code,
2545: min(POL.line_num),
2546: min(POLL.shipment_num)
2547: FROM PO_REQUISITION_LINES PRL,
2548: PO_LINE_LOCATIONS POLL,
2549: PO_LINES POL
2550: WHERE PRL.line_location_id = POLL.line_location_id
2551: AND POLL.line_location_id = p_line_location_id

Line 2562: FROM PO_REQUISITION_LINES PRL,

2558: PRL.unit_meas_lookup_code,
2559: sum(PD.quantity_ordered),
2560: min(POL.line_num),
2561: min(POLL.shipment_num)
2562: FROM PO_REQUISITION_LINES PRL,
2563: PO_LINE_LOCATIONS POLL,
2564: PO_LINES POL,
2565: PO_DISTRIBUTIONS PD,
2566: PO_REQ_DISTRIBUTIONS PRD

Line 3622: FUNCTION get_asl_id( p_item_id IN po_requisition_lines_all.item_id%TYPE,

3618: For each of the above
3619: Local ASL will be preferred over global asl
3620: Valid Vendor site will be preferred than vendor_site being null
3621: */
3622: FUNCTION get_asl_id( p_item_id IN po_requisition_lines_all.item_id%TYPE,
3623: p_category_id IN po_requisition_lines_all.category_id%TYPE,
3624: p_destination_organization_id IN po_requisition_lines_all.destination_organization_id%TYPE,
3625: p_vendor_id IN po_headers_all.vendor_id%TYPE,
3626: p_vendor_site_id IN po_headers_all.vendor_site_id%TYPE )

Line 3623: p_category_id IN po_requisition_lines_all.category_id%TYPE,

3619: Local ASL will be preferred over global asl
3620: Valid Vendor site will be preferred than vendor_site being null
3621: */
3622: FUNCTION get_asl_id( p_item_id IN po_requisition_lines_all.item_id%TYPE,
3623: p_category_id IN po_requisition_lines_all.category_id%TYPE,
3624: p_destination_organization_id IN po_requisition_lines_all.destination_organization_id%TYPE,
3625: p_vendor_id IN po_headers_all.vendor_id%TYPE,
3626: p_vendor_site_id IN po_headers_all.vendor_site_id%TYPE )
3627: return number

Line 3624: p_destination_organization_id IN po_requisition_lines_all.destination_organization_id%TYPE,

3620: Valid Vendor site will be preferred than vendor_site being null
3621: */
3622: FUNCTION get_asl_id( p_item_id IN po_requisition_lines_all.item_id%TYPE,
3623: p_category_id IN po_requisition_lines_all.category_id%TYPE,
3624: p_destination_organization_id IN po_requisition_lines_all.destination_organization_id%TYPE,
3625: p_vendor_id IN po_headers_all.vendor_id%TYPE,
3626: p_vendor_site_id IN po_headers_all.vendor_site_id%TYPE )
3627: return number
3628: as