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.IGI_STP_TABLE_HANDLER_PKG dependencies on AP_SUPPLIER_SITES

Line 735: CURSOR C IS SELECT rowid FROM ap_supplier_sites

731: l_vendor_site_id AP_SUPPLIERS.VENDOR_ID%TYPE;
732: l_party_site_id HZ_PARTY_SITES.party_site_id %TYPE;
733: l_location_id HZ_LOCATIONS.location_id%type;
734:
735: CURSOR C IS SELECT rowid FROM ap_supplier_sites
736: WHERE vendor_site_id = l_vendor_site_id;
737:
738: v_rowid VARCHAR2(25);
739:

Line 857: cursor c_loc is select LOC.LOCATION_ID from HZ_PARTY_SITES PS, HZ_LOCATIONS LOC,AP_SUPPLIER_SITES_ALL AP

853:
854:
855: l_location_rec hz_location_v2pub.location_rec_type;
856: l_object_version_number number;
857: cursor c_loc is select LOC.LOCATION_ID from HZ_PARTY_SITES PS, HZ_LOCATIONS LOC,AP_SUPPLIER_SITES_ALL AP
858: WHERE PS.PARTY_SITE_ID = AP.PARTY_SITE_ID
859: AND LOC.LOCATION_ID = PS.LOCATION_ID
860: AND LOC.LOCATION_ID = AP.LOCATION_ID
861: AND AP.vendor_site_id = X_vendor_site_id

Line 872: cursor c_party is select PS.party_site_id from HZ_PARTY_SITES PS, HZ_LOCATIONS LOC, AP_SUPPLIER_SITES_ALL AP

868:
869:
870:
871: l_party_site_rec hz_party_site_v2pub.party_site_rec_type;
872: cursor c_party is select PS.party_site_id from HZ_PARTY_SITES PS, HZ_LOCATIONS LOC, AP_SUPPLIER_SITES_ALL AP
873: WHERE PS.PARTY_SITE_ID = AP.PARTY_SITE_ID
874: AND AP.vendor_site_id = X_vendor_site_id
875: AND AP.ORG_ID = X_org_id;
876:

Line 1052: FROM ap_supplier_sites_all

1048: X_bank_charge_bearer VARCHAR2,
1049: X_ece_tp_location_code VARCHAR2) IS
1050: CURSOR C IS
1051: SELECT *
1052: FROM ap_supplier_sites_all
1053: WHERE vendor_site_id = X_vendor_site_id
1054: and org_id = x_org_id
1055: FOR UPDATE OF vendor_site_id NOWAIT;
1056: