APPS.ONT_OEXOECOD_XMLP_PKG dependencies on HZ_CUST_ACCT_SITES_ALL

Line 1298: HZ_CUST_ACCT_SITES_ALL ACCT_SITE

1294: FROM
1295: HZ_LOCATIONS LOC,
1296: HZ_PARTY_SITES SITE,
1297: HZ_CUST_SITE_USES_ALL SITE_USE,
1298: HZ_CUST_ACCT_SITES_ALL ACCT_SITE
1299: WHERE SITE_USE.SITE_USE_ID = END_CUSTOMER_SITE_USE_ID
1300: AND SITE_USE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
1301: AND ACCT_SITE.PARTY_SITE_ID = SITE.PARTY_SITE_ID
1302: AND SITE.LOCATION_ID = LOC.LOCATION_ID;

Line 1392: HZ_CUST_ACCT_SITES_ALL ACCT_SITE

1388: FROM
1389: HZ_LOCATIONS LOC,
1390: HZ_PARTY_SITES SITE,
1391: HZ_CUST_SITE_USES_ALL SITE_USE,
1392: HZ_CUST_ACCT_SITES_ALL ACCT_SITE
1393: WHERE SITE_USE.SITE_USE_ID = END_CUSTOMER_SITE_USE_ID
1394: AND SITE_USE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
1395: AND ACCT_SITE.PARTY_SITE_ID = SITE.PARTY_SITE_ID
1396: AND SITE.LOCATION_ID = LOC.LOCATION_ID;

Line 1455: HZ_CUST_ACCT_SITES_ALL ACCT_SITE

1451: FROM
1452: HZ_LOCATIONS LOC,
1453: HZ_PARTY_SITES SITE,
1454: HZ_CUST_SITE_USES_ALL SITE_USE,
1455: HZ_CUST_ACCT_SITES_ALL ACCT_SITE
1456: WHERE SITE_USE.SITE_USE_ID = (
1457: SELECT
1458: SOLD_TO_SITE_USE_ID
1459: FROM

Line 1474: HZ_CUST_ACCT_SITES_ALL ACCT_SITE

1470: FROM
1471: HZ_LOCATIONS LOC,
1472: HZ_PARTY_SITES SITE,
1473: HZ_CUST_SITE_USES_ALL SITE_USE,
1474: HZ_CUST_ACCT_SITES_ALL ACCT_SITE
1475: WHERE SITE_USE.SITE_USE_ID = END_CUSTOMER_SITE_USE_ID
1476: AND SITE_USE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
1477: AND ACCT_SITE.PARTY_SITE_ID = SITE.PARTY_SITE_ID
1478: AND SITE.LOCATION_ID = LOC.LOCATION_ID;

Line 1543: HZ_CUST_ACCT_SITES_ALL ACCT_SITE

1539: FROM
1540: HZ_LOCATIONS LOC,
1541: HZ_PARTY_SITES SITE,
1542: HZ_CUST_SITE_USES_ALL SITE_USE,
1543: HZ_CUST_ACCT_SITES_ALL ACCT_SITE
1544: WHERE SITE_USE.SITE_USE_ID = (
1545: SELECT
1546: SOLD_TO_SITE_USE_ID
1547: FROM

Line 1582: HZ_CUST_ACCT_SITES_ALL ACCT_SITE

1578: FROM
1579: HZ_LOCATIONS LOC,
1580: HZ_PARTY_SITES SITE,
1581: HZ_CUST_SITE_USES_ALL SITE_USE,
1582: HZ_CUST_ACCT_SITES_ALL ACCT_SITE
1583: WHERE SITE_USE.SITE_USE_ID = END_CUSTOMER_SITE_USE_ID
1584: AND SITE_USE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
1585: AND ACCT_SITE.PARTY_SITE_ID = SITE.PARTY_SITE_ID
1586: AND SITE.LOCATION_ID = LOC.LOCATION_ID;

Line 1641: HZ_CUST_ACCT_SITES_ALL ACCT_SITE

1637: FROM
1638: HZ_LOCATIONS LOC,
1639: HZ_PARTY_SITES SITE,
1640: HZ_CUST_SITE_USES_ALL SITE_USE,
1641: HZ_CUST_ACCT_SITES_ALL ACCT_SITE
1642: WHERE SITE_USE.SITE_USE_ID = (
1643: SELECT
1644: SOLD_TO_SITE_USE_ID
1645: FROM

Line 1660: HZ_CUST_ACCT_SITES_ALL ACCT_SITE

1656: FROM
1657: HZ_LOCATIONS LOC,
1658: HZ_PARTY_SITES SITE,
1659: HZ_CUST_SITE_USES_ALL SITE_USE,
1660: HZ_CUST_ACCT_SITES_ALL ACCT_SITE
1661: WHERE SITE_USE.SITE_USE_ID = END_CUSTOMER_SITE_USE_ID
1662: AND SITE_USE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
1663: AND ACCT_SITE.PARTY_SITE_ID = SITE.PARTY_SITE_ID
1664: AND SITE.LOCATION_ID = LOC.LOCATION_ID;

Line 1729: HZ_CUST_ACCT_SITES_ALL ACCT_SITE

1725: FROM
1726: HZ_LOCATIONS LOC,
1727: HZ_PARTY_SITES SITE,
1728: HZ_CUST_SITE_USES_ALL SITE_USE,
1729: HZ_CUST_ACCT_SITES_ALL ACCT_SITE
1730: WHERE SITE_USE.SITE_USE_ID = (
1731: SELECT
1732: SOLD_TO_SITE_USE_ID
1733: FROM

Line 1768: HZ_CUST_ACCT_SITES_ALL ACCT_SITE

1764: FROM
1765: HZ_LOCATIONS LOC,
1766: HZ_PARTY_SITES SITE,
1767: HZ_CUST_SITE_USES_ALL SITE_USE,
1768: HZ_CUST_ACCT_SITES_ALL ACCT_SITE
1769: WHERE SITE_USE.SITE_USE_ID = END_CUSTOMER_SITE_USE_ID
1770: AND SITE_USE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
1771: AND ACCT_SITE.PARTY_SITE_ID = SITE.PARTY_SITE_ID
1772: AND SITE.LOCATION_ID = LOC.LOCATION_ID;