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

Line 671: SELECT 1 FROM po_vendors pv, po_vendor_sites pvs

667:
668:
669: --Added cursor for Bug 14757221 to check if both vendor and vendor site is active
670: CURSOR csr_active_vendor(cv_vendor_id IN NUMBER, cv_vendor_site_id IN NUMBER) IS
671: SELECT 1 FROM po_vendors pv, po_vendor_sites pvs
672: WHERE pv.vendor_id = pvs.vendor_id
673: AND (sysdate between nvl(pv.start_date_active, sysdate-1) and nvl(pv.end_date_active, sysdate+1))
674: AND (pvs.inactive_date is null or pvs.inactive_date > trunc(sysdate))
675: AND pv.vendor_id = cv_vendor_id