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 413: p_line_num po_lines_all.line_num%TYPE,

409: /*******/
410: /* pol */
411: /*******/
412: FUNCTION get_pol_row_from_num(
413: p_line_num po_lines_all.line_num%TYPE,
414: p_header_id po_lines_all.po_header_id%TYPE,
415: p_item_description po_lines_all.item_description%TYPE,
416: p_vendor_product_num po_lines_all.vendor_product_num%TYPE,
417: p_item_id po_lines_all.item_id%TYPE

Line 414: p_header_id po_lines_all.po_header_id%TYPE,

410: /* pol */
411: /*******/
412: FUNCTION get_pol_row_from_num(
413: p_line_num po_lines_all.line_num%TYPE,
414: p_header_id po_lines_all.po_header_id%TYPE,
415: p_item_description po_lines_all.item_description%TYPE,
416: p_vendor_product_num po_lines_all.vendor_product_num%TYPE,
417: p_item_id po_lines_all.item_id%TYPE
418: )

Line 415: p_item_description po_lines_all.item_description%TYPE,

411: /*******/
412: FUNCTION get_pol_row_from_num(
413: p_line_num po_lines_all.line_num%TYPE,
414: p_header_id po_lines_all.po_header_id%TYPE,
415: p_item_description po_lines_all.item_description%TYPE,
416: p_vendor_product_num po_lines_all.vendor_product_num%TYPE,
417: p_item_id po_lines_all.item_id%TYPE
418: )
419: RETURN po_lines_all%ROWTYPE IS

Line 416: p_vendor_product_num po_lines_all.vendor_product_num%TYPE,

412: FUNCTION get_pol_row_from_num(
413: p_line_num po_lines_all.line_num%TYPE,
414: p_header_id po_lines_all.po_header_id%TYPE,
415: p_item_description po_lines_all.item_description%TYPE,
416: p_vendor_product_num po_lines_all.vendor_product_num%TYPE,
417: p_item_id po_lines_all.item_id%TYPE
418: )
419: RETURN po_lines_all%ROWTYPE IS
420: x_line_num po_lines_all.line_num%TYPE;

Line 417: p_item_id po_lines_all.item_id%TYPE

413: p_line_num po_lines_all.line_num%TYPE,
414: p_header_id po_lines_all.po_header_id%TYPE,
415: p_item_description po_lines_all.item_description%TYPE,
416: p_vendor_product_num po_lines_all.vendor_product_num%TYPE,
417: p_item_id po_lines_all.item_id%TYPE
418: )
419: RETURN po_lines_all%ROWTYPE IS
420: x_line_num po_lines_all.line_num%TYPE;
421: x_item_id po_lines_all.item_id%TYPE;

Line 419: RETURN po_lines_all%ROWTYPE IS

415: p_item_description po_lines_all.item_description%TYPE,
416: p_vendor_product_num po_lines_all.vendor_product_num%TYPE,
417: p_item_id po_lines_all.item_id%TYPE
418: )
419: RETURN po_lines_all%ROWTYPE IS
420: x_line_num po_lines_all.line_num%TYPE;
421: x_item_id po_lines_all.item_id%TYPE;
422: x_item_description po_lines_all.item_description%TYPE;
423: x_vendor_product_num po_lines_all.vendor_product_num%TYPE;

Line 420: x_line_num po_lines_all.line_num%TYPE;

416: p_vendor_product_num po_lines_all.vendor_product_num%TYPE,
417: p_item_id po_lines_all.item_id%TYPE
418: )
419: RETURN po_lines_all%ROWTYPE IS
420: x_line_num po_lines_all.line_num%TYPE;
421: x_item_id po_lines_all.item_id%TYPE;
422: x_item_description po_lines_all.item_description%TYPE;
423: x_vendor_product_num po_lines_all.vendor_product_num%TYPE;
424: --Bug 7645326 Added the item_id to find the po line num along with the existing

Line 421: x_item_id po_lines_all.item_id%TYPE;

417: p_item_id po_lines_all.item_id%TYPE
418: )
419: RETURN po_lines_all%ROWTYPE IS
420: x_line_num po_lines_all.line_num%TYPE;
421: x_item_id po_lines_all.item_id%TYPE;
422: x_item_description po_lines_all.item_description%TYPE;
423: x_vendor_product_num po_lines_all.vendor_product_num%TYPE;
424: --Bug 7645326 Added the item_id to find the po line num along with the existing
425: -- input parameters and modified the statement accordingly.

Line 422: x_item_description po_lines_all.item_description%TYPE;

418: )
419: RETURN po_lines_all%ROWTYPE IS
420: x_line_num po_lines_all.line_num%TYPE;
421: x_item_id po_lines_all.item_id%TYPE;
422: x_item_description po_lines_all.item_description%TYPE;
423: x_vendor_product_num po_lines_all.vendor_product_num%TYPE;
424: --Bug 7645326 Added the item_id to find the po line num along with the existing
425: -- input parameters and modified the statement accordingly.
426: BEGIN

Line 423: x_vendor_product_num po_lines_all.vendor_product_num%TYPE;

419: RETURN po_lines_all%ROWTYPE IS
420: x_line_num po_lines_all.line_num%TYPE;
421: x_item_id po_lines_all.item_id%TYPE;
422: x_item_description po_lines_all.item_description%TYPE;
423: x_vendor_product_num po_lines_all.vendor_product_num%TYPE;
424: --Bug 7645326 Added the item_id to find the po line num along with the existing
425: -- input parameters and modified the statement accordingly.
426: BEGIN
427: IF ( ( p_line_num IS NULL

Line 470: FROM po_lines_all

466:
467: --first check if there is a singular match in the current OU
468: SELECT *
469: INTO g_pol_row
470: FROM po_lines_all
471: WHERE po_line_id IN(SELECT po_line_id
472: FROM po_lines
473: WHERE po_header_id = p_header_id
474: AND ( line_num = x_line_num

Line 489: FROM po_lines_all

485: WHEN NO_DATA_FOUND THEN --check if this exists in a different OU
486: BEGIN
487: SELECT *
488: INTO g_pol_row
489: FROM po_lines_all
490: WHERE po_header_id = p_header_id
491: AND ( line_num = x_line_num
492: OR x_line_num IS NULL)
493: AND ( item_id = x_item_id

Line 520: p_line_id IN po_lines_all.po_line_id%TYPE

516: RETURN NULL;
517: END get_pol_row_from_num;
518:
519: FUNCTION get_pol_row_from_id(
520: p_line_id IN po_lines_all.po_line_id%TYPE
521: )
522: RETURN po_lines_all%ROWTYPE IS
523: BEGIN
524: IF (p_line_id IS NULL) THEN

Line 522: RETURN po_lines_all%ROWTYPE IS

518:
519: FUNCTION get_pol_row_from_id(
520: p_line_id IN po_lines_all.po_line_id%TYPE
521: )
522: RETURN po_lines_all%ROWTYPE IS
523: BEGIN
524: IF (p_line_id IS NULL) THEN
525: RETURN NULL;
526: END IF;

Line 534: FROM po_lines_all

530: END IF;
531:
532: SELECT *
533: INTO g_pol_row
534: FROM po_lines_all
535: WHERE po_line_id = p_line_id;
536:
537: RETURN g_pol_row;
538: EXCEPTION