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.OE_VALUE_TO_ID dependencies on HZ_CUST_ACCT_SITES

Line 457: , HZ_CUST_ACCT_SITES ADDR

453: SELECT /* MOAC_SQL_CHANGE */ CON.CONTACT_ID
454: INTO l_id
455: FROM OE_CONTACTS_V CON
456: , HZ_ROLE_RESPONSIBILITY ROL
457: , HZ_CUST_ACCT_SITES ADDR
458: , HZ_CUST_SITE_USES_ALL SU
459: WHERE CON.NAME = p_deliver_to_contact
460: AND CON.CONTACT_ID = ROL.CUST_ACCOUNT_ROLE_ID(+)
461: AND CON.CUSTOMER_ID = ADDR.CUST_ACCOUNT_ID

Line 1133: , HZ_CUST_ACCT_SITES ADDR

1129: SELECT /* MOAC_SQL_CHANGE */ CON.CONTACT_ID
1130: INTO l_id
1131: FROM OE_CONTACTS_V CON
1132: , HZ_ROLE_RESPONSIBILITY ROL
1133: , HZ_CUST_ACCT_SITES ADDR
1134: , HZ_CUST_SITE_USES_ALL SU
1135: WHERE CON.NAME = p_invoice_to_contact
1136: AND CON.CONTACT_ID = ROL.CUST_ACCOUNT_ROLE_ID(+)
1137: AND CON.CUSTOMER_ID = ADDR.CUST_ACCOUNT_ID

Line 1991: , HZ_CUST_ACCT_SITES ADDR

1987: SELECT /* MOAC_SQL_CHANGE */ CON.CONTACT_ID
1988: INTO l_id
1989: FROM OE_CONTACTS_V CON
1990: , HZ_ROLE_RESPONSIBILITY ROL
1991: , HZ_CUST_ACCT_SITES ADDR
1992: , HZ_CUST_SITE_USES_ALL SU
1993: WHERE CON.NAME = p_ship_to_contact
1994: AND CON.CONTACT_ID = ROL.CUST_ACCOUNT_ROLE_ID(+)
1995: AND CON.CUSTOMER_ID = ADDR.CUST_ACCOUNT_ID

Line 6139: HZ_CUST_ACCT_SITES_ALL ACCT_SITE

6135: FROM
6136: HZ_CUST_SITE_USES SITE,
6137: HZ_PARTY_SITES PARTY_SITE,
6138: HZ_LOCATIONS LOC,
6139: HZ_CUST_ACCT_SITES_ALL ACCT_SITE
6140: WHERE
6141: SITE.SITE_USE_CODE = 'SOLD_TO'
6142: AND SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
6143: AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID

Line 6440: hz_cust_acct_sites_all acct_site,

6436: CURSOR c_site_use_id(in_end_customer_id number,in_end_customer_site_use_code number) IS
6437: SELECT /* MOAC_SQL_CHANGE */ site_use.site_use_id
6438: FROM hz_locations loc,
6439: hz_party_sites site,
6440: hz_cust_acct_sites_all acct_site,
6441: hz_cust_site_uses site_use
6442: WHERE
6443: site_use.cust_acct_site_id=acct_site.cust_acct_site_id
6444: and acct_site.party_site_id=site.party_site_id

Line 6471: hz_cust_acct_sites_all acct_site,

6467: CURSOR c_site_use_id2(in_end_customer_id number,in_end_customer_site_use_code number) IS
6468: SELECT /* MOAC_SQL_CHANGE */ site_use.site_use_id
6469: FROM hz_locations loc,
6470: hz_party_sites site,
6471: hz_cust_acct_sites_all acct_site,
6472: hz_cust_site_uses site_use
6473: WHERE loc.ADDRESS1 = p_end_customer_site_address1
6474: AND nvl( loc.ADDRESS2, fnd_api.g_miss_char) =
6475: nvl( p_end_customer_site_address2, fnd_api.g_miss_char)