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

Line 1363: SELECT 'x' FROM PO_VENDORS_VIEW

1359: -- AND STATUS_CODE = G_OSP_SUBMITTED_STATUS
1360: FOR UPDATE OF PO_BATCH_ID, PO_REQUEST_ID; -- Lock Row
1361:
1362: CURSOR l_validate_supplier_csr(p_supplier_id IN NUMBER) IS
1363: SELECT 'x' FROM PO_VENDORS_VIEW
1364: WHERE VENDOR_ID = p_supplier_id
1365: AND ENABLED_FLAG = G_YES_FLAG
1366: AND NVL(VENDOR_START_DATE_ACTIVE, SYSDATE - 1) <= SYSDATE
1367: AND NVL(VENDOR_END_DATE_ACTIVE, SYSDATE + 1) > SYSDATE;

Line 1753: SELECT invoice_currency_code INTO l_temp_v FROM po_vendors

1749: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1750: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Could not get currency for Supplier ' || p_po_header_rec.vendor_id || ' Trying at Site ' || p_po_header_rec.vendor_site_id);
1751: END IF;
1752: -- If not check if available at vendor level
1753: SELECT invoice_currency_code INTO l_temp_v FROM po_vendors
1754: WHERE vendor_id = p_po_header_rec.vendor_id;
1755: IF(l_temp_v IS NULL) THEN
1756: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1757: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Could not get currency for Supplier ' || p_po_header_rec.vendor_id || ' and Site ' || p_po_header_rec.vendor_site_id || ', Trying from set of Books.');