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_VENDOR_SITES

Line 1371: SELECT 'x' FROM PO_VENDOR_SITES

1367: AND NVL(VENDOR_END_DATE_ACTIVE, SYSDATE + 1) > SYSDATE;
1368:
1369: CURSOR l_validate_supp_site_csr(p_supp_site_id IN NUMBER,
1370: p_supp_id IN NUMBER) IS
1371: SELECT 'x' FROM PO_VENDOR_SITES
1372: WHERE VENDOR_SITE_ID = p_supp_site_id
1373: AND VENDOR_ID = p_supp_id
1374: AND NVL(INACTIVE_DATE, SYSDATE + 1) > SYSDATE
1375: AND NVL(RFQ_ONLY_SITE_FLAG, G_NO_FLAG) = G_NO_FLAG

Line 1377: -- NOTE: Organization filtering is done by the PO_VENDOR_SITES view itself

1373: AND VENDOR_ID = p_supp_id
1374: AND NVL(INACTIVE_DATE, SYSDATE + 1) > SYSDATE
1375: AND NVL(RFQ_ONLY_SITE_FLAG, G_NO_FLAG) = G_NO_FLAG
1376: AND PURCHASING_SITE_FLAG = G_YES_FLAG;
1377: -- NOTE: Organization filtering is done by the PO_VENDOR_SITES view itself
1378:
1379: -- Added by jaramana on May 27, 2005 for Inventory Service Order
1380: CURSOR l_validate_vendor_contact_csr(p_vendor_contact_id IN NUMBER,
1381: p_supp_site_id IN NUMBER) IS

Line 1745: SELECT invoice_currency_code INTO l_temp_v FROM po_vendor_sites

1741: -- If set either at Site or Supplier Level, no need to set.
1742: -- Else retrieve from Set-Of-Books and set explicitly
1743: BEGIN
1744: -- Check if currency is available at vendor site level
1745: SELECT invoice_currency_code INTO l_temp_v FROM po_vendor_sites
1746: WHERE vendor_site_id = p_po_header_rec.vendor_site_id AND
1747: vendor_id = p_po_header_rec.vendor_id;
1748: IF(l_temp_v IS NULL) THEN
1749: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN