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

Line 48: v_apps_po_line_id po_lines_all.po_line_id%TYPE;

44: v_recv_um1 po_recv_dtl.recv_um1%TYPE;
45: v_dtl_recv_date po_recv_dtl.recv_date%TYPE;
46:
47: v_apps_po_header_id po_headers_all.po_header_id%TYPE;
48: v_apps_po_line_id po_lines_all.po_line_id%TYPE;
49: v_apps_po_line_location_id po_line_locations_all.line_location_id%TYPE;
50: v_ship_to_organization_id po_line_locations_all.ship_to_organization_id%TYPE;
51:
52: new_header_interface_id rcv_headers_interface.header_interface_id%TYPE;

Line 833: v_apps_po_line_id po_lines_all.po_line_id%TYPE;

829: v_rate_type po_headers_all.rate_type%TYPE;
830: v_rate_date po_headers_all.rate_date%TYPE;
831: v_rate po_headers_all.rate%TYPE;
832: v_po_revision_num po_headers_all.revision_num%TYPE;
833: v_apps_po_line_id po_lines_all.po_line_id%TYPE;
834: v_item_rev po_lines_all.item_revision%TYPE;
835: v_org_id po_lines_all.org_id%TYPE;
836: v_unit_price po_lines_all.unit_price%TYPE;
837:

Line 834: v_item_rev po_lines_all.item_revision%TYPE;

830: v_rate_date po_headers_all.rate_date%TYPE;
831: v_rate po_headers_all.rate%TYPE;
832: v_po_revision_num po_headers_all.revision_num%TYPE;
833: v_apps_po_line_id po_lines_all.po_line_id%TYPE;
834: v_item_rev po_lines_all.item_revision%TYPE;
835: v_org_id po_lines_all.org_id%TYPE;
836: v_unit_price po_lines_all.unit_price%TYPE;
837:
838: v_apps_po_line_location_id po_line_locations_all.line_location_id%TYPE;

Line 835: v_org_id po_lines_all.org_id%TYPE;

831: v_rate po_headers_all.rate%TYPE;
832: v_po_revision_num po_headers_all.revision_num%TYPE;
833: v_apps_po_line_id po_lines_all.po_line_id%TYPE;
834: v_item_rev po_lines_all.item_revision%TYPE;
835: v_org_id po_lines_all.org_id%TYPE;
836: v_unit_price po_lines_all.unit_price%TYPE;
837:
838: v_apps_po_line_location_id po_line_locations_all.line_location_id%TYPE;
839: v_ship_to_location_id po_line_locations_all.ship_to_location_id%TYPE;

Line 836: v_unit_price po_lines_all.unit_price%TYPE;

832: v_po_revision_num po_headers_all.revision_num%TYPE;
833: v_apps_po_line_id po_lines_all.po_line_id%TYPE;
834: v_item_rev po_lines_all.item_revision%TYPE;
835: v_org_id po_lines_all.org_id%TYPE;
836: v_unit_price po_lines_all.unit_price%TYPE;
837:
838: v_apps_po_line_location_id po_line_locations_all.line_location_id%TYPE;
839: v_ship_to_location_id po_line_locations_all.ship_to_location_id%TYPE;
840: v_ship_to_organization_id po_line_locations_all.ship_to_organization_id%TYPE;

Line 958: FROM po_lines_all

954: /* Uday Phadtare B1785880 removed unit_price from select */
955: CURSOR app_po_line_cur(vc_apps_po_header_id NUMBER,
956: vc_apps_po_line_id NUMBER) IS
957: SELECT item_revision,org_id
958: FROM po_lines_all
959: WHERE po_header_id = vc_apps_po_header_id AND
960: po_line_id = vc_apps_po_line_id;
961:
962: /* Uday Phadtare B1785880 select price_override from po_line_locations_all */

Line 1030: from po_headers_all po, po_lines_all lines, po_line_locations_all shipments

1026: CURSOR doc_nums_cur(vc_apps_po_header_id NUMBER,
1027: vc_apps_po_line_id NUMBER,
1028: vc_apps_po_line_location_id NUMBER) IS
1029: select po.segment1, lines.line_num, shipments.shipment_num
1030: from po_headers_all po, po_lines_all lines, po_line_locations_all shipments
1031: where po.po_header_id = vc_apps_po_header_id
1032: and lines.po_header_id = po.po_header_id
1033: and lines.po_line_id = vc_apps_po_line_id
1034: and shipments.po_header_id = po.po_header_id