APPS.ONT_OEXOECOD_XMLP_PKG dependencies on HZ_PARTY_SITES

Line 1292: HZ_PARTY_SITES SITE,

1288: LOC.ADDRESS1
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

Line 1325: HZ_PARTY_SITES SITE,

1321: LOC.COUNTRY
1322: INTO L_END_CUSTOMER_CITY,L_END_CUSTOMER_STATE,L_END_CUSTOMER_POSTAL_CODE,L_END_CUSTOMER_COUNTRY
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

Line 1386: HZ_PARTY_SITES SITE,

1382: LOC.COUNTRY
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

Line 1449: HZ_PARTY_SITES SITE,

1445: LOC.ADDRESS1
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

Line 1468: HZ_PARTY_SITES SITE,

1464: LOC.ADDRESS1
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

Line 1537: HZ_PARTY_SITES SITE,

1533: LOC.COUNTRY
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

Line 1576: HZ_PARTY_SITES SITE,

1572: LOC.COUNTRY
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

Line 1635: HZ_PARTY_SITES SITE,

1631: LOC.ADDRESS1
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

Line 1654: HZ_PARTY_SITES SITE,

1650: LOC.ADDRESS1
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

Line 1723: HZ_PARTY_SITES SITE,

1719: LOC.COUNTRY
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

Line 1762: HZ_PARTY_SITES SITE,

1758: LOC.COUNTRY
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