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_RECV_DTL

Line 42: v_line_id po_recv_dtl.line_id%TYPE;

38: v_recv_no po_recv_hdr.recv_no%TYPE;
39: v_created_by po_recv_hdr.created_by%TYPE;
40: v_last_updated_by po_recv_hdr.last_updated_by%TYPE;
41:
42: v_line_id po_recv_dtl.line_id%TYPE;
43: v_recv_qty1 po_recv_dtl.recv_qty1%TYPE;
44: v_recv_um1 po_recv_dtl.recv_um1%TYPE;
45: v_dtl_recv_date po_recv_dtl.recv_date%TYPE;
46:

Line 43: v_recv_qty1 po_recv_dtl.recv_qty1%TYPE;

39: v_created_by po_recv_hdr.created_by%TYPE;
40: v_last_updated_by po_recv_hdr.last_updated_by%TYPE;
41:
42: v_line_id po_recv_dtl.line_id%TYPE;
43: v_recv_qty1 po_recv_dtl.recv_qty1%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;

Line 44: v_recv_um1 po_recv_dtl.recv_um1%TYPE;

40: v_last_updated_by po_recv_hdr.last_updated_by%TYPE;
41:
42: v_line_id po_recv_dtl.line_id%TYPE;
43: v_recv_qty1 po_recv_dtl.recv_qty1%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;

Line 45: v_dtl_recv_date po_recv_dtl.recv_date%TYPE;

41:
42: v_line_id po_recv_dtl.line_id%TYPE;
43: v_recv_qty1 po_recv_dtl.recv_qty1%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;

Line 620: X_po_id po_recv_dtl.po_id%TYPE;

616:
617: adjust_err_ind NUMBER;
618:
619: X_interface_transaction_id rcv_transactions_interface.interface_transaction_id%TYPE;
620: X_po_id po_recv_dtl.po_id%TYPE;
621: X_poline_id po_recv_dtl.poline_id%TYPE;
622: X_opm_item_id po_recv_dtl.item_id%TYPE;
623: X_return_ind po_recv_dtl.return_ind%TYPE;
624: X_recv_status po_recv_dtl.recv_status%TYPE;

Line 621: X_poline_id po_recv_dtl.poline_id%TYPE;

617: adjust_err_ind NUMBER;
618:
619: X_interface_transaction_id rcv_transactions_interface.interface_transaction_id%TYPE;
620: X_po_id po_recv_dtl.po_id%TYPE;
621: X_poline_id po_recv_dtl.poline_id%TYPE;
622: X_opm_item_id po_recv_dtl.item_id%TYPE;
623: X_return_ind po_recv_dtl.return_ind%TYPE;
624: X_recv_status po_recv_dtl.recv_status%TYPE;
625: X_net_price po_recv_dtl.net_price%TYPE;

Line 622: X_opm_item_id po_recv_dtl.item_id%TYPE;

618:
619: X_interface_transaction_id rcv_transactions_interface.interface_transaction_id%TYPE;
620: X_po_id po_recv_dtl.po_id%TYPE;
621: X_poline_id po_recv_dtl.poline_id%TYPE;
622: X_opm_item_id po_recv_dtl.item_id%TYPE;
623: X_return_ind po_recv_dtl.return_ind%TYPE;
624: X_recv_status po_recv_dtl.recv_status%TYPE;
625: X_net_price po_recv_dtl.net_price%TYPE;
626:

Line 623: X_return_ind po_recv_dtl.return_ind%TYPE;

619: X_interface_transaction_id rcv_transactions_interface.interface_transaction_id%TYPE;
620: X_po_id po_recv_dtl.po_id%TYPE;
621: X_poline_id po_recv_dtl.poline_id%TYPE;
622: X_opm_item_id po_recv_dtl.item_id%TYPE;
623: X_return_ind po_recv_dtl.return_ind%TYPE;
624: X_recv_status po_recv_dtl.recv_status%TYPE;
625: X_net_price po_recv_dtl.net_price%TYPE;
626:
627: CURSOR adjust_error_cur IS

Line 624: X_recv_status po_recv_dtl.recv_status%TYPE;

620: X_po_id po_recv_dtl.po_id%TYPE;
621: X_poline_id po_recv_dtl.poline_id%TYPE;
622: X_opm_item_id po_recv_dtl.item_id%TYPE;
623: X_return_ind po_recv_dtl.return_ind%TYPE;
624: X_recv_status po_recv_dtl.recv_status%TYPE;
625: X_net_price po_recv_dtl.net_price%TYPE;
626:
627: CURSOR adjust_error_cur IS
628: select recv_id,

Line 625: X_net_price po_recv_dtl.net_price%TYPE;

621: X_poline_id po_recv_dtl.poline_id%TYPE;
622: X_opm_item_id po_recv_dtl.item_id%TYPE;
623: X_return_ind po_recv_dtl.return_ind%TYPE;
624: X_recv_status po_recv_dtl.recv_status%TYPE;
625: X_net_price po_recv_dtl.net_price%TYPE;
626:
627: CURSOR adjust_error_cur IS
628: select recv_id,
629: line_id,

Line 652: FROM po_recv_dtl

648: line_id = vc_line_id;
649:
650: CURSOR get_recv_dtl_cur(vc_recv_id NUMBER, vc_line_id NUMBER) IS
651: SELECT po_id, poline_id, item_id, recv_status, return_ind, net_price
652: FROM po_recv_dtl
653: WHERE recv_id = vc_recv_id AND
654: line_id = vc_line_id;
655:
656: BEGIN

Line 813: v_line_id po_recv_dtl.line_id%TYPE;

809: v_waybill_no po_recv_hdr.waybill_no%TYPE;
810: --v_of_vendor_id po_vend_mst.of_vendor_id%TYPE;
811: v_of_vendor_id po_headers_all.vendor_id%TYPE;
812:
813: v_line_id po_recv_dtl.line_id%TYPE;
814: v_recv_qty1 po_recv_dtl.recv_qty1%TYPE;
815: v_recv_um1 po_recv_dtl.recv_um1%TYPE;
816: v_dtl_recv_date po_recv_dtl.recv_date%TYPE;
817:

Line 814: v_recv_qty1 po_recv_dtl.recv_qty1%TYPE;

810: --v_of_vendor_id po_vend_mst.of_vendor_id%TYPE;
811: v_of_vendor_id po_headers_all.vendor_id%TYPE;
812:
813: v_line_id po_recv_dtl.line_id%TYPE;
814: v_recv_qty1 po_recv_dtl.recv_qty1%TYPE;
815: v_recv_um1 po_recv_dtl.recv_um1%TYPE;
816: v_dtl_recv_date po_recv_dtl.recv_date%TYPE;
817:
818: v_line_no po_ordr_dtl.line_no%TYPE;

Line 815: v_recv_um1 po_recv_dtl.recv_um1%TYPE;

811: v_of_vendor_id po_headers_all.vendor_id%TYPE;
812:
813: v_line_id po_recv_dtl.line_id%TYPE;
814: v_recv_qty1 po_recv_dtl.recv_qty1%TYPE;
815: v_recv_um1 po_recv_dtl.recv_um1%TYPE;
816: v_dtl_recv_date po_recv_dtl.recv_date%TYPE;
817:
818: v_line_no po_ordr_dtl.line_no%TYPE;
819: v_orgn_code po_ordr_hdr.orgn_code%TYPE;

Line 816: v_dtl_recv_date po_recv_dtl.recv_date%TYPE;

812:
813: v_line_id po_recv_dtl.line_id%TYPE;
814: v_recv_qty1 po_recv_dtl.recv_qty1%TYPE;
815: v_recv_um1 po_recv_dtl.recv_um1%TYPE;
816: v_dtl_recv_date po_recv_dtl.recv_date%TYPE;
817:
818: v_line_no po_ordr_dtl.line_no%TYPE;
819: v_orgn_code po_ordr_hdr.orgn_code%TYPE;
820: v_returned_qty po_rtrn_dtl.return_qty1%TYPE;