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.OTA_OM_UPD_API dependencies on HZ_PARTY_SITES

Line 1166: from HZ_LOCATIONS loc,HZ_CUST_ACCT_SITES acct_site,HZ_PARTY_SITES party_site

1162: from (select LOC.address1 ADDRESS1,LOC.address2 ADDRESS2,LOC.address3 ADDRESS3,LOC.address4 ADDRESS4,
1163: LOC.city CITY,LOC.state STATE,LOC.province PROVINCE,LOC.county COUNTY,LOC.postal_code POSTAL_CODE,
1164: LOC.country COUNTRY,ACCT_SITE.cust_acct_site_id ADDRESS_ID,ACCT_SITE.status STATUS,
1165: ACCT_SITE.cust_account_id CUSTOMER_ID
1166: from HZ_LOCATIONS loc,HZ_CUST_ACCT_SITES acct_site,HZ_PARTY_SITES party_site
1167: where PARTY_SITE.location_id = LOC.location_id
1168: and ACCT_SITE.party_site_id = PARTY_SITE.party_site_id)adr
1169: where adr.status = 'A' and
1170: adr.customer_id=P_SOLD_TO_ORG_ID and

Line 1184: from HZ_LOCATIONS loc,HZ_CUST_ACCT_SITES acct_site,HZ_PARTY_SITES party_site

1180: from (select LOC.address1 ADDRESS1,LOC.address2 ADDRESS2,LOC.address3 ADDRESS3,LOC.address4 ADDRESS4,
1181: LOC.city CITY,LOC.state STATE,LOC.province PROVINCE,LOC.county COUNTY,LOC.postal_code POSTAL_CODE,
1182: LOC.country COUNTRY,ACCT_SITE.cust_acct_site_id ADDRESS_ID,ACCT_SITE.status STATUS,
1183: ACCT_SITE.cust_account_id CUSTOMER_ID
1184: from HZ_LOCATIONS loc,HZ_CUST_ACCT_SITES acct_site,HZ_PARTY_SITES party_site
1185: where PARTY_SITE.location_id = LOC.location_id
1186: and ACCT_SITE.party_site_id = PARTY_SITE.party_site_id)adr
1187: where adr.status = 'A' and
1188: adr.customer_id = L_SHIP_TO_ORG_ID and

Line 1218: from HZ_LOCATIONS loc,HZ_CUST_ACCT_SITES acct_site,HZ_PARTY_SITES party_site

1214: from (select LOC.address1 ADDRESS1,LOC.address2 ADDRESS2,LOC.address3 ADDRESS3,LOC.address4 ADDRESS4,
1215: LOC.city CITY,LOC.state STATE,LOC.province PROVINCE,LOC.county COUNTY,LOC.postal_code POSTAL_CODE,
1216: LOC.country COUNTRY,ACCT_SITE.cust_acct_site_id ADDRESS_ID,ACCT_SITE.status STATUS,
1217: ACCT_SITE.cust_account_id CUSTOMER_ID
1218: from HZ_LOCATIONS loc,HZ_CUST_ACCT_SITES acct_site,HZ_PARTY_SITES party_site
1219: where PARTY_SITE.location_id = LOC.location_id
1220: and ACCT_SITE.party_site_id = PARTY_SITE.party_site_id)adr
1221: where adr.status = 'A' and
1222: adr.customer_id = P_SOLD_TO_ORG_ID and

Line 1234: from HZ_LOCATIONS loc,HZ_CUST_ACCT_SITES acct_site,HZ_PARTY_SITES party_site

1230: from (select LOC.address1 ADDRESS1,LOC.address2 ADDRESS2,LOC.address3 ADDRESS3,LOC.address4 ADDRESS4,
1231: LOC.city CITY,LOC.state STATE,LOC.province PROVINCE,LOC.county COUNTY,LOC.postal_code POSTAL_CODE,
1232: LOC.country COUNTRY,ACCT_SITE.cust_acct_site_id ADDRESS_ID,
1233: ACCT_SITE.status STATUS,ACCT_SITE.cust_account_id CUSTOMER_ID
1234: from HZ_LOCATIONS loc,HZ_CUST_ACCT_SITES acct_site,HZ_PARTY_SITES party_site
1235: where PARTY_SITE.location_id = LOC.location_id
1236: and ACCT_SITE.party_site_id = PARTY_SITE.party_site_id)rad,
1237: (Select cust_acct_site_id address_id,site_use_id,status
1238: From hz_cust_site_uses)rsu