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

Line 794: -- Also check that the ID exists in PO_VENDOR_SITES_ALL table.

790:
791: -- ECO bug 5584556: Start: Add new messages
792: l_progress := '080';
793: -- SQL What: Bulk validate vendor_site_id. Check that it is not NULL or -2.
794: -- Also check that the ID exists in PO_VENDOR_SITES_ALL table.
795: -- Insert the error rows into GT table.
796: -- SQL Why : It will be used to mark the record in plsql table as error.
797: -- SQL Join: vendor_site_id
798: FORALL i IN 1 .. p_headers_rec.vendor_site_id.COUNT

Line 826: FROM PO_VENDOR_SITES_ALL PVSA

822: -- Handle invalid Supplier Site id for Create/update action
823: p_headers_rec.vendor_site_id(i) IS NOT NULL
824: AND p_headers_rec.vendor_site_id(i) <> g_NULL_COLUMN_VALUE
825: AND NOT EXISTS( SELECT 1
826: FROM PO_VENDOR_SITES_ALL PVSA
827: WHERE p_headers_rec.vendor_site_id(i) = PVSA.vendor_site_id)
828: )
829: );
830:

Line 892: FROM PO_VENDOR_SITES_ALL PVSA

888: -- So adding these additional where-clauses to skip those cases.
889: AND p_headers_rec.vendor_site_id(i) IS NOT NULL
890: AND p_headers_rec.vendor_site_id(i) <> g_NULL_COLUMN_VALUE
891: AND EXISTS(SELECT 1
892: FROM PO_VENDOR_SITES_ALL PVSA
893: WHERE p_headers_rec.vendor_site_id(i) = PVSA.vendor_site_id)
894: -- ECO bug 5584556: End
895: AND NOT EXISTS(SELECT 1
896: FROM PO_SUPPLIER_SITES_VAL_V PSSV