APPS.ONT_OEXOECOD_XMLP_PKG dependencies on HZ_CUST_SITE_USES_ALL

Line 1297: HZ_CUST_SITE_USES_ALL SITE_USE,

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
1301: AND ACCT_SITE.PARTY_SITE_ID = SITE.PARTY_SITE_ID

Line 1391: HZ_CUST_SITE_USES_ALL SITE_USE,

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
1395: AND ACCT_SITE.PARTY_SITE_ID = SITE.PARTY_SITE_ID

Line 1454: HZ_CUST_SITE_USES_ALL SITE_USE,

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
1458: SOLD_TO_SITE_USE_ID

Line 1473: HZ_CUST_SITE_USES_ALL SITE_USE,

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
1477: AND ACCT_SITE.PARTY_SITE_ID = SITE.PARTY_SITE_ID

Line 1542: HZ_CUST_SITE_USES_ALL SITE_USE,

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
1546: SOLD_TO_SITE_USE_ID

Line 1581: HZ_CUST_SITE_USES_ALL SITE_USE,

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
1585: AND ACCT_SITE.PARTY_SITE_ID = SITE.PARTY_SITE_ID

Line 1640: HZ_CUST_SITE_USES_ALL SITE_USE,

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
1644: SOLD_TO_SITE_USE_ID

Line 1659: HZ_CUST_SITE_USES_ALL SITE_USE,

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
1663: AND ACCT_SITE.PARTY_SITE_ID = SITE.PARTY_SITE_ID

Line 1728: HZ_CUST_SITE_USES_ALL SITE_USE,

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
1732: SOLD_TO_SITE_USE_ID

Line 1767: HZ_CUST_SITE_USES_ALL SITE_USE,

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
1771: AND ACCT_SITE.PARTY_SITE_ID = SITE.PARTY_SITE_ID