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.AST_UWQ_WRAPPER_PKG dependencies on AST_LOCATIONS_V

Line 215: FROM ast_locations_v

211: WHERE party_id = x_party_id;
212:
213: CURSOR c_get_address_id (x_party_id NUMBER, x_location_id NUMBER) IS
214: SELECT party_site_id
215: FROM ast_locations_v
216: WHERE party_id = x_party_id
217: AND location_id = x_location_id;
218:
219: CURSOR c_phone_id(x_owner_table_id number) IS

Line 883: FROM ast_locations_v

879: AND status = 'A';
880:
881: CURSOR c_get_address_id (x_party_id NUMBER, x_location_id NUMBER) IS
882: SELECT party_site_id
883: FROM ast_locations_v
884: WHERE party_id = x_party_id
885: AND location_id = x_location_id;
886:
887:

Line 1124: FROM ast_locations_v

1120: AND status = 'A';
1121:
1122: CURSOR c_get_address_id (x_party_id NUMBER, x_location_id NUMBER) IS
1123: SELECT party_site_id
1124: FROM ast_locations_v
1125: WHERE party_id = x_party_id
1126: AND location_id = x_location_id;
1127:
1128: