APPS.OE_CNCL_VALUE_TO_ID dependencies on HZ_CUST_SITE_USES

Line 257: , HZ_CUST_SITE_USES_ALL SITE

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
261: AND SITE.SITE_USE_ID = p_deliver_to_org_id;

Line 816: , HZ_CUST_SITE_USES_ALL SITE

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
820: AND SITE.SITE_USE_ID = p_invoice_to_org_id;

Line 1625: , HZ_CUST_SITE_USES_ALL SITE

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
1629: AND SITE.SITE_USE_ID = p_ship_to_org_id;

Line 2083: , HZ_CUST_SITE_USES_ALL SITE

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
2087: AND SITE.SITE_USE_ID = p_sold_to_org_id;

Line 5369: HZ_CUST_SITE_USES_ALL SITE,

5365:
5366: SELECT /* MOAC_SQL_CHANGE */ SITE.SITE_USE_ID
5367: INTO l_id
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

Line 5567: hz_cust_site_uses site_use

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
5571: and site.location_id=loc.location_id

Line 5597: hz_cust_site_uses site_use

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)
5601: AND nvl( loc.ADDRESS3, fnd_api.g_miss_char) =