APPS.ONT_OEXOECOD_XMLP_PKG dependencies on HZ_CUST_ACCT_SITES

Line 1294: HZ_CUST_ACCT_SITES_ALL ACCT_SITE

1290: FROM
1291: HZ_LOCATIONS LOC,
1292: HZ_PARTY_SITES SITE,
1293: HZ_CUST_SITE_USES_ALL SITE_USE,
1294: HZ_CUST_ACCT_SITES_ALL ACCT_SITE
1295: WHERE SITE_USE.SITE_USE_ID = END_CUSTOMER_SITE_USE_ID
1296: AND SITE_USE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
1297: AND ACCT_SITE.PARTY_SITE_ID = SITE.PARTY_SITE_ID
1298: AND SITE.LOCATION_ID = LOC.LOCATION_ID;

Line 1327: HZ_CUST_ACCT_SITES ACCT_SITE

1323: FROM
1324: HZ_LOCATIONS LOC,
1325: HZ_PARTY_SITES SITE,
1326: HZ_CUST_SITE_USES SITE_USE,
1327: HZ_CUST_ACCT_SITES ACCT_SITE
1328: WHERE SITE_USE.SITE_USE_ID = END_CUSTOMER_SITE_USE_ID
1329: AND SITE_USE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
1330: AND ACCT_SITE.PARTY_SITE_ID = SITE.PARTY_SITE_ID
1331: AND SITE.LOCATION_ID = LOC.LOCATION_ID;

Line 1388: HZ_CUST_ACCT_SITES_ALL ACCT_SITE

1384: FROM
1385: HZ_LOCATIONS LOC,
1386: HZ_PARTY_SITES SITE,
1387: HZ_CUST_SITE_USES_ALL SITE_USE,
1388: HZ_CUST_ACCT_SITES_ALL ACCT_SITE
1389: WHERE SITE_USE.SITE_USE_ID = END_CUSTOMER_SITE_USE_ID
1390: AND SITE_USE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
1391: AND ACCT_SITE.PARTY_SITE_ID = SITE.PARTY_SITE_ID
1392: AND SITE.LOCATION_ID = LOC.LOCATION_ID;

Line 1451: HZ_CUST_ACCT_SITES_ALL ACCT_SITE

1447: FROM
1448: HZ_LOCATIONS LOC,
1449: HZ_PARTY_SITES SITE,
1450: HZ_CUST_SITE_USES_ALL SITE_USE,
1451: HZ_CUST_ACCT_SITES_ALL ACCT_SITE
1452: WHERE SITE_USE.SITE_USE_ID = (
1453: SELECT
1454: SOLD_TO_SITE_USE_ID
1455: FROM

Line 1470: HZ_CUST_ACCT_SITES_ALL ACCT_SITE

1466: FROM
1467: HZ_LOCATIONS LOC,
1468: HZ_PARTY_SITES SITE,
1469: HZ_CUST_SITE_USES_ALL SITE_USE,
1470: HZ_CUST_ACCT_SITES_ALL ACCT_SITE
1471: WHERE SITE_USE.SITE_USE_ID = END_CUSTOMER_SITE_USE_ID
1472: AND SITE_USE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
1473: AND ACCT_SITE.PARTY_SITE_ID = SITE.PARTY_SITE_ID
1474: AND SITE.LOCATION_ID = LOC.LOCATION_ID;

Line 1539: HZ_CUST_ACCT_SITES_ALL ACCT_SITE

1535: FROM
1536: HZ_LOCATIONS LOC,
1537: HZ_PARTY_SITES SITE,
1538: HZ_CUST_SITE_USES_ALL SITE_USE,
1539: HZ_CUST_ACCT_SITES_ALL ACCT_SITE
1540: WHERE SITE_USE.SITE_USE_ID = (
1541: SELECT
1542: SOLD_TO_SITE_USE_ID
1543: FROM

Line 1578: HZ_CUST_ACCT_SITES_ALL ACCT_SITE

1574: FROM
1575: HZ_LOCATIONS LOC,
1576: HZ_PARTY_SITES SITE,
1577: HZ_CUST_SITE_USES_ALL SITE_USE,
1578: HZ_CUST_ACCT_SITES_ALL ACCT_SITE
1579: WHERE SITE_USE.SITE_USE_ID = END_CUSTOMER_SITE_USE_ID
1580: AND SITE_USE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
1581: AND ACCT_SITE.PARTY_SITE_ID = SITE.PARTY_SITE_ID
1582: AND SITE.LOCATION_ID = LOC.LOCATION_ID;

Line 1637: HZ_CUST_ACCT_SITES_ALL ACCT_SITE

1633: FROM
1634: HZ_LOCATIONS LOC,
1635: HZ_PARTY_SITES SITE,
1636: HZ_CUST_SITE_USES_ALL SITE_USE,
1637: HZ_CUST_ACCT_SITES_ALL ACCT_SITE
1638: WHERE SITE_USE.SITE_USE_ID = (
1639: SELECT
1640: SOLD_TO_SITE_USE_ID
1641: FROM

Line 1656: HZ_CUST_ACCT_SITES_ALL ACCT_SITE

1652: FROM
1653: HZ_LOCATIONS LOC,
1654: HZ_PARTY_SITES SITE,
1655: HZ_CUST_SITE_USES_ALL SITE_USE,
1656: HZ_CUST_ACCT_SITES_ALL ACCT_SITE
1657: WHERE SITE_USE.SITE_USE_ID = END_CUSTOMER_SITE_USE_ID
1658: AND SITE_USE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
1659: AND ACCT_SITE.PARTY_SITE_ID = SITE.PARTY_SITE_ID
1660: AND SITE.LOCATION_ID = LOC.LOCATION_ID;

Line 1725: HZ_CUST_ACCT_SITES_ALL ACCT_SITE

1721: FROM
1722: HZ_LOCATIONS LOC,
1723: HZ_PARTY_SITES SITE,
1724: HZ_CUST_SITE_USES_ALL SITE_USE,
1725: HZ_CUST_ACCT_SITES_ALL ACCT_SITE
1726: WHERE SITE_USE.SITE_USE_ID = (
1727: SELECT
1728: SOLD_TO_SITE_USE_ID
1729: FROM

Line 1764: HZ_CUST_ACCT_SITES_ALL ACCT_SITE

1760: FROM
1761: HZ_LOCATIONS LOC,
1762: HZ_PARTY_SITES SITE,
1763: HZ_CUST_SITE_USES_ALL SITE_USE,
1764: HZ_CUST_ACCT_SITES_ALL ACCT_SITE
1765: WHERE SITE_USE.SITE_USE_ID = END_CUSTOMER_SITE_USE_ID
1766: AND SITE_USE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
1767: AND ACCT_SITE.PARTY_SITE_ID = SITE.PARTY_SITE_ID
1768: AND SITE.LOCATION_ID = LOC.LOCATION_ID;