APPS.ONT_OEXOECOD_XMLP_PKG dependencies on HZ_CUST_SITE_USES_ALL

Line 1293: HZ_CUST_SITE_USES_ALL SITE_USE,

1289: INTO L_END_CUSTOMER_ADDRESS1
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

Line 1387: HZ_CUST_SITE_USES_ALL SITE_USE,

1383: INTO L_END_CUSTOMER_COUNTRY
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

Line 1450: HZ_CUST_SITE_USES_ALL SITE_USE,

1446: INTO L_ADDRESS1
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

Line 1469: HZ_CUST_SITE_USES_ALL SITE_USE,

1465: INTO L_ADDRESS1
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

Line 1538: HZ_CUST_SITE_USES_ALL SITE_USE,

1534: INTO L_CITY,L_STATE,L_POSTAL_CODE,L_COUNTRY
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

Line 1577: HZ_CUST_SITE_USES_ALL SITE_USE,

1573: INTO L_CITY,L_STATE,L_POSTAL_CODE,L_COUNTRY
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

Line 1636: HZ_CUST_SITE_USES_ALL SITE_USE,

1632: INTO L_ADDRESS1
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

Line 1655: HZ_CUST_SITE_USES_ALL SITE_USE,

1651: INTO L_ADDRESS1
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

Line 1724: HZ_CUST_SITE_USES_ALL SITE_USE,

1720: INTO L_CITY,L_STATE,L_POSTAL_CODE,L_COUNTRY
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

Line 1763: HZ_CUST_SITE_USES_ALL SITE_USE,

1759: INTO L_CITY,L_STATE,L_POSTAL_CODE,L_COUNTRY
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