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_CUST_ACCT_SITES

Line 1053: l_contact_address_id HZ_CUST_ACCT_SITES.cust_acct_site_id%TYPE := NULL; --changed

1049: l_booking_priority ota_delegate_bookings.booking_priority%TYPE := NULL;
1050: l_delegate_contact_phone varchar2(80);
1051: l_delegate_contact_fax varchar2(80);
1052: l_delegate_contact_email HZ_PARTIES.email_address%TYPE; ---changed
1053: l_contact_address_id HZ_CUST_ACCT_SITES.cust_acct_site_id%TYPE := NULL; --changed
1054: l_correspondent varchar2(1) := 'C';
1055: l_student_address_id varchar2(1) := NULL;
1056: l_control_contact_address_id ota_customer_contacts_v.address_id%TYPE := NULL;
1057: l_control_student_address_id ota_customer_contacts_v.address_id%TYPE := NULL;

Line 1073: l_third_address_id HZ_CUST_ACCT_SITES.cust_acct_site_id%TYPE := NULL; --changed

1069: --Third party info --
1070: l_third_contact_phone varchar2(80);
1071: l_third_contact_fax varchar2(80);
1072: l_third_contact_email HZ_PARTIES.email_address%TYPE; --changed
1073: l_third_address_id HZ_CUST_ACCT_SITES.cust_acct_site_id%TYPE := NULL; --changed
1074: l_control_third_address_id ota_customer_contacts_v.address_id%TYPE := NULL;
1075: l_third_contact_id number;
1076:
1077:

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