DBA Data[Home] [Help]

APPS.GML_RECV_TRANS_PKG dependencies on PO_VEND_MST

Line 810: --v_of_vendor_id po_vend_mst.of_vendor_id%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;
814: v_recv_qty1 po_recv_dtl.recv_qty1%TYPE;

Line 913: FROM po_vend_mst

909: WHERE recv_id = vc_recv_id;
910: /*
911: CURSOR opm_vendor_cur(vc_shipvend_id NUMBER) IS
912: SELECT of_vendor_id
913: FROM po_vend_mst
914: WHERE vendor_id = vc_shipvend_id;
915: */
916: CURSOR opm_vendor_cur(vc_po_id NUMBER) IS
917: SELECT of_vendor_id

Line 918: FROM po_vend_mst

914: WHERE vendor_id = vc_shipvend_id;
915: */
916: CURSOR opm_vendor_cur(vc_po_id NUMBER) IS
917: SELECT of_vendor_id
918: FROM po_vend_mst
919: WHERE vendor_id = (SELECT shipvend_id
920: FROM po_ordr_hdr
921: WHERE po_id = vc_po_id);
922: