APPS.ONT_OEXOECOD_XMLP_PKG dependencies on HZ_PARTY_SITES

Line 1296: HZ_PARTY_SITES SITE,

1292: LOC.ADDRESS1
1293: INTO L_END_CUSTOMER_ADDRESS1
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

Line 1329: HZ_PARTY_SITES SITE,

1325: LOC.COUNTRY
1326: INTO L_END_CUSTOMER_CITY,L_END_CUSTOMER_STATE,L_END_CUSTOMER_POSTAL_CODE,L_END_CUSTOMER_COUNTRY
1327: FROM
1328: HZ_LOCATIONS LOC,
1329: HZ_PARTY_SITES SITE,
1330: HZ_CUST_SITE_USES SITE_USE,
1331: HZ_CUST_ACCT_SITES ACCT_SITE
1332: WHERE SITE_USE.SITE_USE_ID = END_CUSTOMER_SITE_USE_ID
1333: AND SITE_USE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID

Line 1390: HZ_PARTY_SITES SITE,

1386: LOC.COUNTRY
1387: INTO L_END_CUSTOMER_COUNTRY
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

Line 1453: HZ_PARTY_SITES SITE,

1449: LOC.ADDRESS1
1450: INTO L_ADDRESS1
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

Line 1472: HZ_PARTY_SITES SITE,

1468: LOC.ADDRESS1
1469: INTO L_ADDRESS1
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

Line 1541: HZ_PARTY_SITES SITE,

1537: LOC.COUNTRY
1538: INTO L_CITY,L_STATE,L_POSTAL_CODE,L_COUNTRY
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

Line 1580: HZ_PARTY_SITES SITE,

1576: LOC.COUNTRY
1577: INTO L_CITY,L_STATE,L_POSTAL_CODE,L_COUNTRY
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

Line 1639: HZ_PARTY_SITES SITE,

1635: LOC.ADDRESS1
1636: INTO L_ADDRESS1
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

Line 1658: HZ_PARTY_SITES SITE,

1654: LOC.ADDRESS1
1655: INTO L_ADDRESS1
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

Line 1727: HZ_PARTY_SITES SITE,

1723: LOC.COUNTRY
1724: INTO L_CITY,L_STATE,L_POSTAL_CODE,L_COUNTRY
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

Line 1766: HZ_PARTY_SITES SITE,

1762: LOC.COUNTRY
1763: INTO L_CITY,L_STATE,L_POSTAL_CODE,L_COUNTRY
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