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

Line 26146: FROM po_vendors

26142: l_proc_name VARCHAR2(35) := 'CREATE_LESSEE_AS_VENDOR';
26143: CURSOR vendor_csr (p_vendor_id NUMBER,
26144: p_vendor_name VARCHAR2) IS
26145: SELECT vendor_id
26146: FROM po_vendors
26147: WHERE ( (vendor_id = p_vendor_id
26148: AND
26149: p_vendor_id IS NOT NULL
26150: )

Line 26175: l_vendor_id po_vendors.vendor_id%TYPE;

26171: )
26172: and org_id = p_auth_org_id
26173: and vendor_id = p_vendor_id;
26174:
26175: l_vendor_id po_vendors.vendor_id%TYPE;
26176: l_vendor_site_id po_vendor_sites_all.vendor_site_id%TYPE;
26177: l_ppydv_rec ppydv_rec_type;
26178: x_ppydv_rec ppydv_rec_type;
26179:

Line 27169: FROM po_vendors

27165: x_srfvv_rec okl_subsidy_rfnd_dtls_pvt.srfvv_rec_type;
27166:
27167: CURSOR vendor_csr (p_name VARCHAR2) IS
27168: SELECT vendor_id
27169: FROM po_vendors
27170: WHERE vendor_name = p_name;
27171:
27172: CURSOR sub_id_csr (p_name okl_subsidies_b.name%TYPE,
27173: p_org NUMBER) IS