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.JAI_CMN_MTAX_PKG dependencies on PO_VENDORS

Line 598: FROM Po_Vendors

594: */
595: --********* for REQUISITIONS
596: CURSOR c_vendor_name( p_vendor_id IN VARCHAR2) IS
597: SELECT vendor_name
598: FROM Po_Vendors
599: WHERE Vendor_Name = p_vendor_id;
600:
601: CURSOR c_vendor_site_code( p_vendor_site_id IN VARCHAR2) IS
602: SELECT Vendor_Site_Code

Line 608: FROM Po_Vendors

604: WHERE a.vendor_site_id = p_vendor_site_id;
605:
606: CURSOR c_vendor_id( p_sugg_vendor_name IN VARCHAR2) IS
607: SELECT Vendor_Id
608: FROM Po_Vendors
609: WHERE Vendor_Name = p_sugg_vendor_name;
610:
611: CURSOR c_vendor_site_id( p_sugg_vendor_loc IN VARCHAR2, p_vendor_id IN NUMBER, p_org_id IN NUMBER) IS
612: SELECT Vendor_Site_Id

Line 957: v_supplier_name PO_VENDORS.VENDOR_NAME%TYPE;

953: --*********** for REQUISITION
954: v_currency_code VARCHAR2(4);
955: v_unit_price NUMBER;
956: v_supplier_location PO_VENDOR_SITES_ALL.VENDOR_SITE_CODE%TYPE;
957: v_supplier_name PO_VENDORS.VENDOR_NAME%TYPE;
958:
959: j NUMBER; -- used as a temperory variable
960:
961: /* Bug 5243532. Added by Lakshmi Gopalsami