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.MRP_CL_FUNCTION dependencies on PO_VENDOR_SITES_ALL

Line 1460: from PO_VENDOR_SITES_ALL

1456: from WSH_REGIONS;
1457:
1458: Cursor po_vendors_update(p_date DATE) is
1459: select vendor_site_id
1460: from PO_VENDOR_SITES_ALL
1461: where last_update_date >= p_date and creation_date < p_date;
1462:
1463: Cursor all_vendor_sites is
1464: select vendor_site_id,country,state,city,zip

Line 1465: from PO_VENDOR_SITES_ALL;

1461: where last_update_date >= p_date and creation_date < p_date;
1462:
1463: Cursor all_vendor_sites is
1464: select vendor_site_id,country,state,city,zip
1465: from PO_VENDOR_SITES_ALL;
1466:
1467: Cursor new_vendor_sites(p_date DATE) is
1468: select vendor_site_id,country,state,city,zip
1469: from PO_VENDOR_SITES_ALL

Line 1469: from PO_VENDOR_SITES_ALL

1465: from PO_VENDOR_SITES_ALL;
1466:
1467: Cursor new_vendor_sites(p_date DATE) is
1468: select vendor_site_id,country,state,city,zip
1469: from PO_VENDOR_SITES_ALL
1470: where last_update_date >= p_date;
1471:
1472: TYPE VendorSiteTblTyp IS TABLE OF PO_VENDOR_SITES_ALL.VENDOR_SITE_ID%TYPE;
1473: TYPE CountryTblTyp IS TABLE OF PO_VENDOR_SITES_ALL.COUNTRY%TYPE;

Line 1472: TYPE VendorSiteTblTyp IS TABLE OF PO_VENDOR_SITES_ALL.VENDOR_SITE_ID%TYPE;

1468: select vendor_site_id,country,state,city,zip
1469: from PO_VENDOR_SITES_ALL
1470: where last_update_date >= p_date;
1471:
1472: TYPE VendorSiteTblTyp IS TABLE OF PO_VENDOR_SITES_ALL.VENDOR_SITE_ID%TYPE;
1473: TYPE CountryTblTyp IS TABLE OF PO_VENDOR_SITES_ALL.COUNTRY%TYPE;
1474: TYPE StateTblTyp IS TABLE OF PO_VENDOR_SITES_ALL.STATE%TYPE;
1475: TYPE CityTblTyp IS TABLE OF PO_VENDOR_SITES_ALL.CITY%TYPE;
1476: TYPE ZipTblTyp IS TABLE OF PO_VENDOR_SITES_ALL.ZIP%TYPE;

Line 1473: TYPE CountryTblTyp IS TABLE OF PO_VENDOR_SITES_ALL.COUNTRY%TYPE;

1469: from PO_VENDOR_SITES_ALL
1470: where last_update_date >= p_date;
1471:
1472: TYPE VendorSiteTblTyp IS TABLE OF PO_VENDOR_SITES_ALL.VENDOR_SITE_ID%TYPE;
1473: TYPE CountryTblTyp IS TABLE OF PO_VENDOR_SITES_ALL.COUNTRY%TYPE;
1474: TYPE StateTblTyp IS TABLE OF PO_VENDOR_SITES_ALL.STATE%TYPE;
1475: TYPE CityTblTyp IS TABLE OF PO_VENDOR_SITES_ALL.CITY%TYPE;
1476: TYPE ZipTblTyp IS TABLE OF PO_VENDOR_SITES_ALL.ZIP%TYPE;
1477: TYPE NumTblTyp IS TABLE OF NUMBER;

Line 1474: TYPE StateTblTyp IS TABLE OF PO_VENDOR_SITES_ALL.STATE%TYPE;

1470: where last_update_date >= p_date;
1471:
1472: TYPE VendorSiteTblTyp IS TABLE OF PO_VENDOR_SITES_ALL.VENDOR_SITE_ID%TYPE;
1473: TYPE CountryTblTyp IS TABLE OF PO_VENDOR_SITES_ALL.COUNTRY%TYPE;
1474: TYPE StateTblTyp IS TABLE OF PO_VENDOR_SITES_ALL.STATE%TYPE;
1475: TYPE CityTblTyp IS TABLE OF PO_VENDOR_SITES_ALL.CITY%TYPE;
1476: TYPE ZipTblTyp IS TABLE OF PO_VENDOR_SITES_ALL.ZIP%TYPE;
1477: TYPE NumTblTyp IS TABLE OF NUMBER;
1478:

Line 1475: TYPE CityTblTyp IS TABLE OF PO_VENDOR_SITES_ALL.CITY%TYPE;

1471:
1472: TYPE VendorSiteTblTyp IS TABLE OF PO_VENDOR_SITES_ALL.VENDOR_SITE_ID%TYPE;
1473: TYPE CountryTblTyp IS TABLE OF PO_VENDOR_SITES_ALL.COUNTRY%TYPE;
1474: TYPE StateTblTyp IS TABLE OF PO_VENDOR_SITES_ALL.STATE%TYPE;
1475: TYPE CityTblTyp IS TABLE OF PO_VENDOR_SITES_ALL.CITY%TYPE;
1476: TYPE ZipTblTyp IS TABLE OF PO_VENDOR_SITES_ALL.ZIP%TYPE;
1477: TYPE NumTblTyp IS TABLE OF NUMBER;
1478:
1479: l_vendor_site_tab VendorSiteTblTyp ;

Line 1476: TYPE ZipTblTyp IS TABLE OF PO_VENDOR_SITES_ALL.ZIP%TYPE;

1472: TYPE VendorSiteTblTyp IS TABLE OF PO_VENDOR_SITES_ALL.VENDOR_SITE_ID%TYPE;
1473: TYPE CountryTblTyp IS TABLE OF PO_VENDOR_SITES_ALL.COUNTRY%TYPE;
1474: TYPE StateTblTyp IS TABLE OF PO_VENDOR_SITES_ALL.STATE%TYPE;
1475: TYPE CityTblTyp IS TABLE OF PO_VENDOR_SITES_ALL.CITY%TYPE;
1476: TYPE ZipTblTyp IS TABLE OF PO_VENDOR_SITES_ALL.ZIP%TYPE;
1477: TYPE NumTblTyp IS TABLE OF NUMBER;
1478:
1479: l_vendor_site_tab VendorSiteTblTyp ;
1480: l_vendor_site_tab1 VendorSiteTblTyp ;