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 1363: SELECT 'x' FROM PO_VENDOR_SITES

1359: AND NVL(VENDOR_END_DATE_ACTIVE, SYSDATE + 1) > SYSDATE;
1360:
1361: CURSOR l_validate_supp_site_csr(p_supp_site_id IN NUMBER,
1362: p_supp_id IN NUMBER) IS
1363: SELECT 'x' FROM PO_VENDOR_SITES
1364: WHERE VENDOR_SITE_ID = p_supp_site_id
1365: AND VENDOR_ID = p_supp_id
1366: AND NVL(INACTIVE_DATE, SYSDATE + 1) > SYSDATE
1367: AND NVL(RFQ_ONLY_SITE_FLAG, G_NO_FLAG) = G_NO_FLAG

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

1365: AND VENDOR_ID = p_supp_id
1366: AND NVL(INACTIVE_DATE, SYSDATE + 1) > SYSDATE
1367: AND NVL(RFQ_ONLY_SITE_FLAG, G_NO_FLAG) = G_NO_FLAG
1368: AND PURCHASING_SITE_FLAG = G_YES_FLAG;
1369: -- NOTE: Organization filtering is done by the PO_VENDOR_SITES view itself
1370:
1371: -- Added by jaramana on May 27, 2005 for Inventory Service Order
1372: CURSOR l_validate_vendor_contact_csr(p_vendor_contact_id IN NUMBER,
1373: p_supp_site_id IN NUMBER) IS

Line 1736: SELECT invoice_currency_code INTO l_temp_v FROM po_vendor_sites

1732: -- If set either at Site or Supplier Level, no need to set.
1733: -- Else retrieve from Set-Of-Books and set explicitly
1734: BEGIN
1735: -- Check if currency is available at vendor site level
1736: SELECT invoice_currency_code INTO l_temp_v FROM po_vendor_sites
1737: WHERE vendor_site_id = p_po_header_rec.vendor_site_id AND
1738: vendor_id = p_po_header_rec.vendor_id;
1739: IF(l_temp_v IS NULL) THEN
1740: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN