DBA Data[Home] [Help]

APPS.OE_CNCL_VALUE_TO_ID dependencies on HZ_CUST_SITE_USES_ALL

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