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 1355: SELECT 'x' FROM PO_VENDORS_VIEW

1351: -- AND STATUS_CODE = G_OSP_SUBMITTED_STATUS
1352: FOR UPDATE OF PO_BATCH_ID, PO_REQUEST_ID; -- Lock Row
1353:
1354: CURSOR l_validate_supplier_csr(p_supplier_id IN NUMBER) IS
1355: SELECT 'x' FROM PO_VENDORS_VIEW
1356: WHERE VENDOR_ID = p_supplier_id
1357: AND ENABLED_FLAG = G_YES_FLAG
1358: AND NVL(VENDOR_START_DATE_ACTIVE, SYSDATE - 1) <= SYSDATE
1359: AND NVL(VENDOR_END_DATE_ACTIVE, SYSDATE + 1) > SYSDATE;

Line 1744: SELECT invoice_currency_code INTO l_temp_v FROM po_vendors

1740: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1741: 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);
1742: END IF;
1743: -- If not check if available at vendor level
1744: SELECT invoice_currency_code INTO l_temp_v FROM po_vendors
1745: WHERE vendor_id = p_po_header_rec.vendor_id;
1746: IF(l_temp_v IS NULL) THEN
1747: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1748: 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.');