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_CNCL_VALUE_TO_ID dependencies on HZ_CUST_ACCT_SITES

Line 256: , HZ_CUST_ACCT_SITES ACCT_SITE

252:
253: SELECT /* MOAC_SQL_CHANGE */ CON.CONTACT_ID
254: INTO l_id
255: FROM OE_CONTACTS_V CON
256: , HZ_CUST_ACCT_SITES ACCT_SITE
257: , HZ_CUST_SITE_USES_ALL SITE
258: WHERE CON.NAME = p_deliver_to_contact
259: AND CON.CUSTOMER_ID = ACCT_SITE.CUST_ACCOUNT_ID
260: AND ACCT_SITE.CUST_ACCT_SITE_ID = SITE.CUST_ACCT_SITE_ID

Line 815: , HZ_CUST_ACCT_SITES ACCT_SITE

811:
812: SELECT /* MOAC_SQL_CHANGE */ CON.CONTACT_ID
813: INTO l_id
814: FROM OE_CONTACTS_V CON
815: , HZ_CUST_ACCT_SITES ACCT_SITE
816: , HZ_CUST_SITE_USES_ALL SITE
817: WHERE CON.NAME = p_invoice_to_contact
818: AND CON.CUSTOMER_ID = ACCT_SITE.CUST_ACCOUNT_ID
819: AND ACCT_SITE.CUST_ACCT_SITE_ID = SITE.CUST_ACCT_SITE_ID

Line 1624: , HZ_CUST_ACCT_SITES ACCT_SITE

1620:
1621: SELECT /* MOAC_SQL_CHANGE */ CON.CONTACT_ID
1622: INTO l_id
1623: FROM OE_CONTACTS_V CON
1624: , HZ_CUST_ACCT_SITES ACCT_SITE
1625: , HZ_CUST_SITE_USES_ALL SITE
1626: WHERE CON.NAME = p_ship_to_contact
1627: AND CON.CUSTOMER_ID = ACCT_SITE.CUST_ACCOUNT_ID
1628: AND ACCT_SITE.CUST_ACCT_SITE_ID = SITE.CUST_ACCT_SITE_ID

Line 2082: , HZ_CUST_ACCT_SITES ACCT_SITE

2078:
2079: SELECT /* MOAC_SQL_CHANGE */ CON.CONTACT_ID
2080: INTO l_id
2081: FROM OE_CONTACTS_V CON
2082: , HZ_CUST_ACCT_SITES ACCT_SITE
2083: , HZ_CUST_SITE_USES_ALL SITE
2084: WHERE CON.NAME = p_sold_to_contact
2085: AND CON.CUSTOMER_ID = ACCT_SITE.CUST_ACCOUNT_ID
2086: AND ACCT_SITE.CUST_ACCT_SITE_ID = SITE.CUST_ACCT_SITE_ID

Line 5372: HZ_CUST_ACCT_SITES ACCT_SITE

5368: FROM
5369: HZ_CUST_SITE_USES_ALL SITE,
5370: HZ_PARTY_SITES PARTY_SITE,
5371: HZ_LOCATIONS LOC,
5372: HZ_CUST_ACCT_SITES ACCT_SITE
5373: WHERE
5374: SITE.SITE_USE_CODE = 'SOLD_TO'
5375: AND SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
5376: AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID

Line 5566: hz_cust_acct_sites acct_site,

5562: CURSOR c_site_use_id(in_end_customer_id number,in_end_customer_site_use_code varchar2) IS
5563: SELECT site_use.site_use_id
5564: FROM hz_locations loc,
5565: hz_party_sites site,
5566: hz_cust_acct_sites acct_site,
5567: hz_cust_site_uses site_use
5568: WHERE
5569: site_use.cust_acct_site_id=acct_site.cust_acct_site_id
5570: and acct_site.party_site_id=site.party_site_id

Line 5596: hz_cust_acct_sites acct_site,

5592: CURSOR c_site_use_id2(in_end_customer_id number,in_end_customer_site_use_code varchar2) IS
5593: SELECT site_use.site_use_id
5594: FROM hz_locations loc,
5595: hz_party_sites site,
5596: hz_cust_acct_sites acct_site,
5597: hz_cust_site_uses site_use
5598: WHERE loc.ADDRESS1 = p_end_customer_site_address1
5599: AND nvl( loc.ADDRESS2, fnd_api.g_miss_char) =
5600: nvl( p_end_customer_site_address2, fnd_api.g_miss_char)