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.RCV_TABLE_FUNCTIONS dependencies on PO_LINES_ALL

Line 10: g_pol_row po_lines_all%ROWTYPE;

6: g_rt_row rcv_transactions%ROWTYPE;
7: g_rsh_row rcv_shipment_headers%ROWTYPE;
8: g_rsl_row rcv_shipment_lines%ROWTYPE;
9: g_poh_row po_headers_all%ROWTYPE;
10: g_pol_row po_lines_all%ROWTYPE;
11: g_pll_row po_line_locations_all%ROWTYPE;
12: g_pod_row po_distributions_all%ROWTYPE;
13: g_oeh_row oe_order_headers_all%ROWTYPE;
14: g_oel_row oe_order_lines_all%ROWTYPE;

Line 425: p_line_num po_lines_all.line_num%TYPE,

421: /*******/
422: /* pol */
423: /*******/
424: FUNCTION get_pol_row_from_num(
425: p_line_num po_lines_all.line_num%TYPE,
426: p_header_id po_lines_all.po_header_id%TYPE,
427: p_item_description po_lines_all.item_description%TYPE,
428: p_vendor_product_num po_lines_all.vendor_product_num%TYPE,
429: p_item_id po_lines_all.item_id%TYPE

Line 426: p_header_id po_lines_all.po_header_id%TYPE,

422: /* pol */
423: /*******/
424: FUNCTION get_pol_row_from_num(
425: p_line_num po_lines_all.line_num%TYPE,
426: p_header_id po_lines_all.po_header_id%TYPE,
427: p_item_description po_lines_all.item_description%TYPE,
428: p_vendor_product_num po_lines_all.vendor_product_num%TYPE,
429: p_item_id po_lines_all.item_id%TYPE
430: )

Line 427: p_item_description po_lines_all.item_description%TYPE,

423: /*******/
424: FUNCTION get_pol_row_from_num(
425: p_line_num po_lines_all.line_num%TYPE,
426: p_header_id po_lines_all.po_header_id%TYPE,
427: p_item_description po_lines_all.item_description%TYPE,
428: p_vendor_product_num po_lines_all.vendor_product_num%TYPE,
429: p_item_id po_lines_all.item_id%TYPE
430: )
431: RETURN po_lines_all%ROWTYPE IS

Line 428: p_vendor_product_num po_lines_all.vendor_product_num%TYPE,

424: FUNCTION get_pol_row_from_num(
425: p_line_num po_lines_all.line_num%TYPE,
426: p_header_id po_lines_all.po_header_id%TYPE,
427: p_item_description po_lines_all.item_description%TYPE,
428: p_vendor_product_num po_lines_all.vendor_product_num%TYPE,
429: p_item_id po_lines_all.item_id%TYPE
430: )
431: RETURN po_lines_all%ROWTYPE IS
432: x_line_num po_lines_all.line_num%TYPE;

Line 429: p_item_id po_lines_all.item_id%TYPE

425: p_line_num po_lines_all.line_num%TYPE,
426: p_header_id po_lines_all.po_header_id%TYPE,
427: p_item_description po_lines_all.item_description%TYPE,
428: p_vendor_product_num po_lines_all.vendor_product_num%TYPE,
429: p_item_id po_lines_all.item_id%TYPE
430: )
431: RETURN po_lines_all%ROWTYPE IS
432: x_line_num po_lines_all.line_num%TYPE;
433: x_item_id po_lines_all.item_id%TYPE;

Line 431: RETURN po_lines_all%ROWTYPE IS

427: p_item_description po_lines_all.item_description%TYPE,
428: p_vendor_product_num po_lines_all.vendor_product_num%TYPE,
429: p_item_id po_lines_all.item_id%TYPE
430: )
431: RETURN po_lines_all%ROWTYPE IS
432: x_line_num po_lines_all.line_num%TYPE;
433: x_item_id po_lines_all.item_id%TYPE;
434: x_item_description po_lines_all.item_description%TYPE;
435: x_vendor_product_num po_lines_all.vendor_product_num%TYPE;

Line 432: x_line_num po_lines_all.line_num%TYPE;

428: p_vendor_product_num po_lines_all.vendor_product_num%TYPE,
429: p_item_id po_lines_all.item_id%TYPE
430: )
431: RETURN po_lines_all%ROWTYPE IS
432: x_line_num po_lines_all.line_num%TYPE;
433: x_item_id po_lines_all.item_id%TYPE;
434: x_item_description po_lines_all.item_description%TYPE;
435: x_vendor_product_num po_lines_all.vendor_product_num%TYPE;
436: --Bug 7645326 Added the item_id to find the po line num along with the existing

Line 433: x_item_id po_lines_all.item_id%TYPE;

429: p_item_id po_lines_all.item_id%TYPE
430: )
431: RETURN po_lines_all%ROWTYPE IS
432: x_line_num po_lines_all.line_num%TYPE;
433: x_item_id po_lines_all.item_id%TYPE;
434: x_item_description po_lines_all.item_description%TYPE;
435: x_vendor_product_num po_lines_all.vendor_product_num%TYPE;
436: --Bug 7645326 Added the item_id to find the po line num along with the existing
437: -- input parameters and modified the statement accordingly.

Line 434: x_item_description po_lines_all.item_description%TYPE;

430: )
431: RETURN po_lines_all%ROWTYPE IS
432: x_line_num po_lines_all.line_num%TYPE;
433: x_item_id po_lines_all.item_id%TYPE;
434: x_item_description po_lines_all.item_description%TYPE;
435: x_vendor_product_num po_lines_all.vendor_product_num%TYPE;
436: --Bug 7645326 Added the item_id to find the po line num along with the existing
437: -- input parameters and modified the statement accordingly.
438: BEGIN

Line 435: x_vendor_product_num po_lines_all.vendor_product_num%TYPE;

431: RETURN po_lines_all%ROWTYPE IS
432: x_line_num po_lines_all.line_num%TYPE;
433: x_item_id po_lines_all.item_id%TYPE;
434: x_item_description po_lines_all.item_description%TYPE;
435: x_vendor_product_num po_lines_all.vendor_product_num%TYPE;
436: --Bug 7645326 Added the item_id to find the po line num along with the existing
437: -- input parameters and modified the statement accordingly.
438: BEGIN
439: IF ( ( p_line_num IS NULL

Line 482: FROM po_lines_all

478:
479: --first check if there is a singular match in the current OU
480: SELECT *
481: INTO g_pol_row
482: FROM po_lines_all
483: WHERE po_line_id IN(SELECT po_line_id
484: FROM po_lines
485: WHERE po_header_id = p_header_id
486: AND ( line_num = x_line_num

Line 501: FROM po_lines_all

497: WHEN NO_DATA_FOUND THEN --check if this exists in a different OU
498: BEGIN
499: SELECT *
500: INTO g_pol_row
501: FROM po_lines_all
502: WHERE po_header_id = p_header_id
503: AND ( line_num = x_line_num
504: OR x_line_num IS NULL)
505: AND ( item_id = x_item_id

Line 543: p_line_id IN po_lines_all.po_line_id%TYPE

539:
540: END get_pol_row_from_num;
541:
542: FUNCTION get_pol_row_from_id(
543: p_line_id IN po_lines_all.po_line_id%TYPE
544: )
545: RETURN po_lines_all%ROWTYPE IS
546: BEGIN
547: IF (p_line_id IS NULL) THEN

Line 545: RETURN po_lines_all%ROWTYPE IS

541:
542: FUNCTION get_pol_row_from_id(
543: p_line_id IN po_lines_all.po_line_id%TYPE
544: )
545: RETURN po_lines_all%ROWTYPE IS
546: BEGIN
547: IF (p_line_id IS NULL) THEN
548: RETURN NULL;
549: END IF;

Line 557: FROM po_lines_all

553: END IF;
554:
555: SELECT *
556: INTO g_pol_row
557: FROM po_lines_all
558: WHERE po_line_id = p_line_id;
559:
560: RETURN g_pol_row;
561: EXCEPTION