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_HDR

Line 15: | on shipvend_id from po_ordr_hdr instead of po_recv_hdr.

11: | |
12: | MODIFICATION HISTORY |
13: | 10-MAR-99 Tony Ricci Created. |
14: | 03-NOV-99 NC Modified the opm_vendor_cur to get of_vendor_id based|
15: | on shipvend_id from po_ordr_hdr instead of po_recv_hdr.
16: | The original code was populating the rcv_headers_interface
17: | table with blank vendor_id and causing the Receipt |
18: | Transaction Processor to fail. |
19: | 31-MAY-00 NC Added code to create deliveries on apps side. |

Line 37: v_recv_id po_recv_hdr.recv_id%TYPE;

33:
34: v_po_id po_ordr_hdr.po_id%TYPE;
35: v_poline_id po_ordr_dtl.line_id%TYPE;
36:
37: v_recv_id po_recv_hdr.recv_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:

Line 38: v_recv_no po_recv_hdr.recv_no%TYPE;

34: v_po_id po_ordr_hdr.po_id%TYPE;
35: v_poline_id po_ordr_dtl.line_id%TYPE;
36:
37: v_recv_id po_recv_hdr.recv_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;

Line 39: v_created_by po_recv_hdr.created_by%TYPE;

35: v_poline_id po_ordr_dtl.line_id%TYPE;
36:
37: v_recv_id po_recv_hdr.recv_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;

Line 40: v_last_updated_by po_recv_hdr.last_updated_by%TYPE;

36:
37: v_recv_id po_recv_hdr.recv_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;

Line 73: v_rcv_receipt_num po_recv_hdr.recv_no%TYPE;

69: CURSOR RCV_INT_GROUPS_CUR IS
70: SELECT RCV_INTERFACE_GROUPS_S.nextval
71: FROM sys.dual;
72:
73: v_rcv_receipt_num po_recv_hdr.recv_no%TYPE;
74: v_recv_exists VARCHAR2(100);
75:
76: CURSOR opm_oragems_cur(vc_po_id NUMBER, vc_poline_id NUMBER) IS
77: SELECT po_header_id, po_line_id, po_line_location_id

Line 774: Added waybill_no to the rcv_header_interface from po_recv_hdr

770: 10-DEC-01 Uday Phadtare Bug#2007945 Added parameter p_dtl_recv_date to procedure
771: gml_new_rcv_trans_insert so that transaction_date in rcv_transactions_interface
772: is populated with this date.
773: 26-JUL-02 Pushkar Upakare Bug 2458366
774: Added waybill_no to the rcv_header_interface from po_recv_hdr
775: +========================================================================*/
776:
777: PROCEDURE gml_new_rcv_trans_insert(p_recv_id IN NUMBER,
778: p_line_id IN NUMBER,

Line 792: p_rcv_receipt_num IN po_recv_hdr.recv_no%TYPE,

788: p_destination_type_code IN VARCHAR2,
789:
790: p_header_interface_id IN NUMBER,
791: p_group_id IN NUMBER,
792: p_rcv_receipt_num IN po_recv_hdr.recv_no%TYPE,
793: p_header_flag IN NUMBER,
794: p_dtl_recv_date IN DATE DEFAULT SYSDATE) AS
795: v_po_id po_ordr_hdr.po_id%TYPE;
796: v_poline_id po_ordr_dtl.line_id%TYPE;

Line 797: v_recv_id po_recv_hdr.recv_id%TYPE;

793: p_header_flag IN NUMBER,
794: p_dtl_recv_date IN DATE DEFAULT SYSDATE) AS
795: v_po_id po_ordr_hdr.po_id%TYPE;
796: v_poline_id po_ordr_dtl.line_id%TYPE;
797: v_recv_id po_recv_hdr.recv_id%TYPE;
798: v_recv_no po_recv_hdr.recv_no%TYPE;
799: v_shipvend_id po_recv_hdr.shipvend_id%TYPE;
800: v_created_by po_recv_hdr.created_by%TYPE;
801: v_last_updated_by po_recv_hdr.last_updated_by%TYPE;

Line 798: v_recv_no po_recv_hdr.recv_no%TYPE;

794: p_dtl_recv_date IN DATE DEFAULT SYSDATE) AS
795: v_po_id po_ordr_hdr.po_id%TYPE;
796: v_poline_id po_ordr_dtl.line_id%TYPE;
797: v_recv_id po_recv_hdr.recv_id%TYPE;
798: v_recv_no po_recv_hdr.recv_no%TYPE;
799: v_shipvend_id po_recv_hdr.shipvend_id%TYPE;
800: v_created_by po_recv_hdr.created_by%TYPE;
801: v_last_updated_by po_recv_hdr.last_updated_by%TYPE;
802: v_to_whse po_recv_hdr.to_whse%TYPE;

Line 799: v_shipvend_id po_recv_hdr.shipvend_id%TYPE;

795: v_po_id po_ordr_hdr.po_id%TYPE;
796: v_poline_id po_ordr_dtl.line_id%TYPE;
797: v_recv_id po_recv_hdr.recv_id%TYPE;
798: v_recv_no po_recv_hdr.recv_no%TYPE;
799: v_shipvend_id po_recv_hdr.shipvend_id%TYPE;
800: v_created_by po_recv_hdr.created_by%TYPE;
801: v_last_updated_by po_recv_hdr.last_updated_by%TYPE;
802: v_to_whse po_recv_hdr.to_whse%TYPE;
803: v_recv_date po_recv_hdr.recv_date%TYPE;

Line 800: v_created_by po_recv_hdr.created_by%TYPE;

796: v_poline_id po_ordr_dtl.line_id%TYPE;
797: v_recv_id po_recv_hdr.recv_id%TYPE;
798: v_recv_no po_recv_hdr.recv_no%TYPE;
799: v_shipvend_id po_recv_hdr.shipvend_id%TYPE;
800: v_created_by po_recv_hdr.created_by%TYPE;
801: v_last_updated_by po_recv_hdr.last_updated_by%TYPE;
802: v_to_whse po_recv_hdr.to_whse%TYPE;
803: v_recv_date po_recv_hdr.recv_date%TYPE;
804: v_gross_wt po_recv_hdr.gross_wt%TYPE;

Line 801: v_last_updated_by po_recv_hdr.last_updated_by%TYPE;

797: v_recv_id po_recv_hdr.recv_id%TYPE;
798: v_recv_no po_recv_hdr.recv_no%TYPE;
799: v_shipvend_id po_recv_hdr.shipvend_id%TYPE;
800: v_created_by po_recv_hdr.created_by%TYPE;
801: v_last_updated_by po_recv_hdr.last_updated_by%TYPE;
802: v_to_whse po_recv_hdr.to_whse%TYPE;
803: v_recv_date po_recv_hdr.recv_date%TYPE;
804: v_gross_wt po_recv_hdr.gross_wt%TYPE;
805: v_net_wt po_recv_hdr.net_wt%TYPE;

Line 802: v_to_whse po_recv_hdr.to_whse%TYPE;

798: v_recv_no po_recv_hdr.recv_no%TYPE;
799: v_shipvend_id po_recv_hdr.shipvend_id%TYPE;
800: v_created_by po_recv_hdr.created_by%TYPE;
801: v_last_updated_by po_recv_hdr.last_updated_by%TYPE;
802: v_to_whse po_recv_hdr.to_whse%TYPE;
803: v_recv_date po_recv_hdr.recv_date%TYPE;
804: v_gross_wt po_recv_hdr.gross_wt%TYPE;
805: v_net_wt po_recv_hdr.net_wt%TYPE;
806: v_tare_wt po_recv_hdr.tare_wt%TYPE;

Line 803: v_recv_date po_recv_hdr.recv_date%TYPE;

799: v_shipvend_id po_recv_hdr.shipvend_id%TYPE;
800: v_created_by po_recv_hdr.created_by%TYPE;
801: v_last_updated_by po_recv_hdr.last_updated_by%TYPE;
802: v_to_whse po_recv_hdr.to_whse%TYPE;
803: v_recv_date po_recv_hdr.recv_date%TYPE;
804: v_gross_wt po_recv_hdr.gross_wt%TYPE;
805: v_net_wt po_recv_hdr.net_wt%TYPE;
806: v_tare_wt po_recv_hdr.tare_wt%TYPE;
807: v_bol_um po_recv_hdr.bol_um%TYPE;

Line 804: v_gross_wt po_recv_hdr.gross_wt%TYPE;

800: v_created_by po_recv_hdr.created_by%TYPE;
801: v_last_updated_by po_recv_hdr.last_updated_by%TYPE;
802: v_to_whse po_recv_hdr.to_whse%TYPE;
803: v_recv_date po_recv_hdr.recv_date%TYPE;
804: v_gross_wt po_recv_hdr.gross_wt%TYPE;
805: v_net_wt po_recv_hdr.net_wt%TYPE;
806: v_tare_wt po_recv_hdr.tare_wt%TYPE;
807: v_bol_um po_recv_hdr.bol_um%TYPE;
808: v_billing_currency po_recv_hdr.billing_currency%TYPE;

Line 805: v_net_wt po_recv_hdr.net_wt%TYPE;

801: v_last_updated_by po_recv_hdr.last_updated_by%TYPE;
802: v_to_whse po_recv_hdr.to_whse%TYPE;
803: v_recv_date po_recv_hdr.recv_date%TYPE;
804: v_gross_wt po_recv_hdr.gross_wt%TYPE;
805: v_net_wt po_recv_hdr.net_wt%TYPE;
806: v_tare_wt po_recv_hdr.tare_wt%TYPE;
807: v_bol_um po_recv_hdr.bol_um%TYPE;
808: v_billing_currency po_recv_hdr.billing_currency%TYPE;
809: v_waybill_no po_recv_hdr.waybill_no%TYPE;

Line 806: v_tare_wt po_recv_hdr.tare_wt%TYPE;

802: v_to_whse po_recv_hdr.to_whse%TYPE;
803: v_recv_date po_recv_hdr.recv_date%TYPE;
804: v_gross_wt po_recv_hdr.gross_wt%TYPE;
805: v_net_wt po_recv_hdr.net_wt%TYPE;
806: v_tare_wt po_recv_hdr.tare_wt%TYPE;
807: v_bol_um po_recv_hdr.bol_um%TYPE;
808: v_billing_currency po_recv_hdr.billing_currency%TYPE;
809: v_waybill_no po_recv_hdr.waybill_no%TYPE;
810: --v_of_vendor_id po_vend_mst.of_vendor_id%TYPE;

Line 807: v_bol_um po_recv_hdr.bol_um%TYPE;

803: v_recv_date po_recv_hdr.recv_date%TYPE;
804: v_gross_wt po_recv_hdr.gross_wt%TYPE;
805: v_net_wt po_recv_hdr.net_wt%TYPE;
806: v_tare_wt po_recv_hdr.tare_wt%TYPE;
807: v_bol_um po_recv_hdr.bol_um%TYPE;
808: v_billing_currency po_recv_hdr.billing_currency%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;

Line 808: v_billing_currency po_recv_hdr.billing_currency%TYPE;

804: v_gross_wt po_recv_hdr.gross_wt%TYPE;
805: v_net_wt po_recv_hdr.net_wt%TYPE;
806: v_tare_wt po_recv_hdr.tare_wt%TYPE;
807: v_bol_um po_recv_hdr.bol_um%TYPE;
808: v_billing_currency po_recv_hdr.billing_currency%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:

Line 809: v_waybill_no po_recv_hdr.waybill_no%TYPE;

805: v_net_wt po_recv_hdr.net_wt%TYPE;
806: v_tare_wt po_recv_hdr.tare_wt%TYPE;
807: v_bol_um po_recv_hdr.bol_um%TYPE;
808: v_billing_currency po_recv_hdr.billing_currency%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;

Line 908: FROM po_recv_hdr

904:
905: CURSOR opm_recv_no_cur(vc_recv_id NUMBER) IS
906: SELECT recv_no, shipvend_id,to_whse,recv_date,gross_wt,net_wt,tare_wt, substrb(waybill_no, 1, 20), /* Bug 2458366 - added waybill_no*/
907: bol_um,billing_currency
908: FROM po_recv_hdr
909: WHERE recv_id = vc_recv_id;
910: /*
911: CURSOR opm_vendor_cur(vc_shipvend_id NUMBER) IS
912: SELECT of_vendor_id