eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ONT_OEXOECCH_XMLP_PKG dependencies on HZ_CUST_ACCT_SITES_ALL

Line 734: HZ_CUST_ACCT_SITES_ALL ACCT_SITE

730: HZ_CUST_SITE_USES_ALL SU,
731: HZ_PARTY_SITES PARTY_SITE,
732: HZ_LOC_ASSIGNMENTS LOC_ASSIGN,
733: HZ_LOCATIONS LOC,
734: HZ_CUST_ACCT_SITES_ALL ACCT_SITE
735: WHERE H.INVOICE_TO_ORG_ID = SU.SITE_USE_ID
736: AND ACCT_SITE.CUST_ACCOUNT_ID = CUSTOMER_ID
737: AND ACCT_SITE.CUST_ACCT_SITE_ID = SU.CUST_ACCT_SITE_ID
738: AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID

Line 770: HZ_CUST_ACCT_SITES_ALL ACCT_SITE

766: HZ_CUST_SITE_USES_ALL SU,
767: HZ_PARTY_SITES PARTY_SITE,
768: HZ_LOC_ASSIGNMENTS LOC_ASSIGN,
769: HZ_LOCATIONS LOC,
770: HZ_CUST_ACCT_SITES_ALL ACCT_SITE
771: WHERE ACCT_SITE.CUST_ACCOUNT_ID = CUSTOMER_ID
772: AND ACCT_SITE.CUST_ACCT_SITE_ID = SU.CUST_ACCT_SITE_ID
773: AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID
774: AND LOC.LOCATION_ID = PARTY_SITE.LOCATION_ID

Line 806: HZ_CUST_ACCT_SITES_ALL ACCT_SITE

802: HZ_CUST_SITE_USES_ALL SU,
803: HZ_PARTY_SITES PARTY_SITE,
804: HZ_LOC_ASSIGNMENTS LOC_ASSIGN,
805: HZ_LOCATIONS LOC,
806: HZ_CUST_ACCT_SITES_ALL ACCT_SITE
807: WHERE ACCT_SITE.CUST_ACCOUNT_ID = CUSTOMER_ID
808: AND ACCT_SITE.CUST_ACCT_SITE_ID = SU.CUST_ACCT_SITE_ID
809: AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID
810: AND LOC.LOCATION_ID = PARTY_SITE.LOCATION_ID

Line 849: HZ_CUST_ACCT_SITES_ALL ACCT_SITE

845: HZ_CUST_SITE_USES_ALL SU,
846: HZ_PARTY_SITES PARTY_SITE,
847: HZ_LOC_ASSIGNMENTS LOC_ASSIGN,
848: HZ_LOCATIONS LOC,
849: HZ_CUST_ACCT_SITES_ALL ACCT_SITE
850: WHERE ACCT_SITE.CUST_ACCOUNT_ID = CUSTOMER_ID
851: AND ACCT_SITE.CUST_ACCT_SITE_ID = SU.CUST_ACCT_SITE_ID
852: AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID
853: AND LOC.LOCATION_ID = PARTY_SITE.LOCATION_ID

Line 899: HZ_CUST_ACCT_SITES_ALL ACCT_SITE

895: HZ_CUST_SITE_USES_ALL SU,
896: HZ_PARTY_SITES PARTY_SITE,
897: HZ_LOC_ASSIGNMENTS LOC_ASSIGN,
898: HZ_LOCATIONS LOC,
899: HZ_CUST_ACCT_SITES_ALL ACCT_SITE
900: WHERE H.INVOICE_TO_ORG_ID = SU.SITE_USE_ID
901: AND SU.SITE_USE_ID = C_COMPUTE_AMOUNTSFORMULA.SITE_USE_ID
902: AND ACCT_SITE.CUST_ACCT_SITE_ID = SU.CUST_ACCT_SITE_ID
903: AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID

Line 935: HZ_CUST_ACCT_SITES_ALL ACCT_SITE

931: HZ_CUST_SITE_USES_ALL SU,
932: HZ_PARTY_SITES PARTY_SITE,
933: HZ_LOC_ASSIGNMENTS LOC_ASSIGN,
934: HZ_LOCATIONS LOC,
935: HZ_CUST_ACCT_SITES_ALL ACCT_SITE
936: WHERE SU.SITE_USE_ID = C_COMPUTE_AMOUNTSFORMULA.SITE_USE_ID
937: AND ACCT_SITE.CUST_ACCT_SITE_ID = SU.CUST_ACCT_SITE_ID
938: AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID
939: AND LOC.LOCATION_ID = PARTY_SITE.LOCATION_ID

Line 971: HZ_CUST_ACCT_SITES_ALL ACCT_SITE

967: HZ_CUST_SITE_USES_ALL SU,
968: HZ_PARTY_SITES PARTY_SITE,
969: HZ_LOC_ASSIGNMENTS LOC_ASSIGN,
970: HZ_LOCATIONS LOC,
971: HZ_CUST_ACCT_SITES_ALL ACCT_SITE
972: WHERE SU.SITE_USE_ID = C_COMPUTE_AMOUNTSFORMULA.SITE_USE_ID
973: AND ACCT_SITE.CUST_ACCT_SITE_ID = SU.CUST_ACCT_SITE_ID
974: AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID
975: AND LOC.LOCATION_ID = PARTY_SITE.LOCATION_ID

Line 1014: HZ_CUST_ACCT_SITES_ALL ACCT_SITE

1010: HZ_CUST_SITE_USES_ALL SU,
1011: HZ_PARTY_SITES PARTY_SITE,
1012: HZ_LOC_ASSIGNMENTS LOC_ASSIGN,
1013: HZ_LOCATIONS LOC,
1014: HZ_CUST_ACCT_SITES_ALL ACCT_SITE
1015: WHERE SU.SITE_USE_ID = C_COMPUTE_AMOUNTSFORMULA.SITE_USE_ID
1016: AND ACCT_SITE.CUST_ACCT_SITE_ID = SU.CUST_ACCT_SITE_ID
1017: AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID
1018: AND LOC.LOCATION_ID = PARTY_SITE.LOCATION_ID

Line 1066: HZ_CUST_ACCT_SITES_ALL ACCT_SITE

1062: HZ_CUST_SITE_USES_ALL SU,
1063: HZ_PARTY_SITES PARTY_SITE,
1064: HZ_LOC_ASSIGNMENTS LOC_ASSIGN,
1065: HZ_LOCATIONS LOC,
1066: HZ_CUST_ACCT_SITES_ALL ACCT_SITE
1067: WHERE ACCT_SITE.CUST_ACCOUNT_ID = CUSTOMER_ID
1068: AND ACCT_SITE.CUST_ACCT_SITE_ID = SU.CUST_ACCT_SITE_ID
1069: AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID
1070: AND LOC.LOCATION_ID = PARTY_SITE.LOCATION_ID

Line 1102: HZ_CUST_ACCT_SITES_ALL ACCT_SITE

1098: HZ_CUST_SITE_USES_ALL SU,
1099: HZ_PARTY_SITES PARTY_SITE,
1100: HZ_LOC_ASSIGNMENTS LOC_ASSIGN,
1101: HZ_LOCATIONS LOC,
1102: HZ_CUST_ACCT_SITES_ALL ACCT_SITE
1103: WHERE ACCT_SITE.CUST_ACCOUNT_ID = CUSTOMER_ID
1104: AND ACCT_SITE.CUST_ACCT_SITE_ID = SU.CUST_ACCT_SITE_ID
1105: AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID
1106: AND LOC.LOCATION_ID = PARTY_SITE.LOCATION_ID

Line 1138: HZ_CUST_ACCT_SITES_ALL ACCT_SITE

1134: HZ_CUST_SITE_USES_ALL SU,
1135: HZ_PARTY_SITES PARTY_SITE,
1136: HZ_LOC_ASSIGNMENTS LOC_ASSIGN,
1137: HZ_LOCATIONS LOC,
1138: HZ_CUST_ACCT_SITES_ALL ACCT_SITE
1139: WHERE ACCT_SITE.CUST_ACCOUNT_ID = CUSTOMER_ID
1140: AND ACCT_SITE.CUST_ACCT_SITE_ID = SU.CUST_ACCT_SITE_ID
1141: AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID
1142: AND LOC.LOCATION_ID = PARTY_SITE.LOCATION_ID

Line 1181: HZ_CUST_ACCT_SITES_ALL ACCT_SITE

1177: HZ_CUST_SITE_USES_ALL SU,
1178: HZ_PARTY_SITES PARTY_SITE,
1179: HZ_LOC_ASSIGNMENTS LOC_ASSIGN,
1180: HZ_LOCATIONS LOC,
1181: HZ_CUST_ACCT_SITES_ALL ACCT_SITE
1182: WHERE ACCT_SITE.CUST_ACCOUNT_ID = CUSTOMER_ID
1183: AND ACCT_SITE.CUST_ACCT_SITE_ID = SU.CUST_ACCT_SITE_ID
1184: AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID
1185: AND LOC.LOCATION_ID = PARTY_SITE.LOCATION_ID

Line 1231: HZ_CUST_ACCT_SITES_ALL ACCT_SITE

1227: HZ_CUST_SITE_USES_ALL SU,
1228: HZ_PARTY_SITES PARTY_SITE,
1229: HZ_LOC_ASSIGNMENTS LOC_ASSIGN,
1230: HZ_LOCATIONS LOC,
1231: HZ_CUST_ACCT_SITES_ALL ACCT_SITE
1232: WHERE H.INVOICE_TO_ORG_ID = SU.SITE_USE_ID
1233: AND SU.SITE_USE_ID = C_COMPUTE_AMOUNTSFORMULA.SITE_USE_ID
1234: AND ACCT_SITE.CUST_ACCT_SITE_ID = SU.CUST_ACCT_SITE_ID
1235: AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID

Line 1267: HZ_CUST_ACCT_SITES_ALL ACCT_SITE

1263: HZ_CUST_SITE_USES_ALL SU,
1264: HZ_PARTY_SITES PARTY_SITE,
1265: HZ_LOC_ASSIGNMENTS LOC_ASSIGN,
1266: HZ_LOCATIONS LOC,
1267: HZ_CUST_ACCT_SITES_ALL ACCT_SITE
1268: WHERE SU.SITE_USE_ID = C_COMPUTE_AMOUNTSFORMULA.SITE_USE_ID
1269: AND ACCT_SITE.CUST_ACCT_SITE_ID = SU.CUST_ACCT_SITE_ID
1270: AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID
1271: AND LOC.LOCATION_ID = PARTY_SITE.LOCATION_ID

Line 1303: HZ_CUST_ACCT_SITES_ALL ACCT_SITE

1299: HZ_CUST_SITE_USES_ALL SU,
1300: HZ_PARTY_SITES PARTY_SITE,
1301: HZ_LOC_ASSIGNMENTS LOC_ASSIGN,
1302: HZ_LOCATIONS LOC,
1303: HZ_CUST_ACCT_SITES_ALL ACCT_SITE
1304: WHERE SU.SITE_USE_ID = C_COMPUTE_AMOUNTSFORMULA.SITE_USE_ID
1305: AND ACCT_SITE.CUST_ACCT_SITE_ID = SU.CUST_ACCT_SITE_ID
1306: AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID
1307: AND LOC.LOCATION_ID = PARTY_SITE.LOCATION_ID

Line 1346: HZ_CUST_ACCT_SITES_ALL ACCT_SITE

1342: HZ_CUST_SITE_USES_ALL SU,
1343: HZ_PARTY_SITES PARTY_SITE,
1344: HZ_LOC_ASSIGNMENTS LOC_ASSIGN,
1345: HZ_LOCATIONS LOC,
1346: HZ_CUST_ACCT_SITES_ALL ACCT_SITE
1347: WHERE SU.SITE_USE_ID = C_COMPUTE_AMOUNTSFORMULA.SITE_USE_ID
1348: AND ACCT_SITE.CUST_ACCT_SITE_ID = SU.CUST_ACCT_SITE_ID
1349: AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID
1350: AND LOC.LOCATION_ID = PARTY_SITE.LOCATION_ID

Line 1706: HZ_CUST_ACCT_SITES_ALL ACCT_SITE

1702: HZ_CUST_SITE_USES_ALL SU,
1703: HZ_PARTY_SITES PARTY_SITE,
1704: HZ_LOC_ASSIGNMENTS LOC_ASSIGN,
1705: HZ_LOCATIONS LOC,
1706: HZ_CUST_ACCT_SITES_ALL ACCT_SITE
1707: WHERE ACCT_SITE.CUST_ACCOUNT_ID = CUSTOMER_ID
1708: AND ACCT_SITE.CUST_ACCT_SITE_ID = SU.CUST_ACCT_SITE_ID
1709: AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID
1710: AND LOC.LOCATION_ID = PARTY_SITE.LOCATION_ID

Line 1742: HZ_CUST_ACCT_SITES_ALL ACCT_SITE

1738: HZ_CUST_SITE_USES_ALL SU,
1739: HZ_PARTY_SITES PARTY_SITE,
1740: HZ_LOC_ASSIGNMENTS LOC_ASSIGN,
1741: HZ_LOCATIONS LOC,
1742: HZ_CUST_ACCT_SITES_ALL ACCT_SITE
1743: WHERE ACCT_SITE.CUST_ACCOUNT_ID = CUSTOMER_ID
1744: AND ACCT_SITE.CUST_ACCT_SITE_ID = SU.CUST_ACCT_SITE_ID
1745: AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID
1746: AND LOC.LOCATION_ID = PARTY_SITE.LOCATION_ID

Line 1778: HZ_CUST_ACCT_SITES_ALL ACCT_SITE

1774: HZ_CUST_SITE_USES_ALL SU,
1775: HZ_PARTY_SITES PARTY_SITE,
1776: HZ_LOC_ASSIGNMENTS LOC_ASSIGN,
1777: HZ_LOCATIONS LOC,
1778: HZ_CUST_ACCT_SITES_ALL ACCT_SITE
1779: WHERE ACCT_SITE.CUST_ACCOUNT_ID = CUSTOMER_ID
1780: AND ACCT_SITE.CUST_ACCT_SITE_ID = SU.CUST_ACCT_SITE_ID
1781: AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID
1782: AND LOC.LOCATION_ID = PARTY_SITE.LOCATION_ID

Line 1821: HZ_CUST_ACCT_SITES_ALL ACCT_SITE

1817: HZ_CUST_SITE_USES_ALL SU,
1818: HZ_PARTY_SITES PARTY_SITE,
1819: HZ_LOC_ASSIGNMENTS LOC_ASSIGN,
1820: HZ_LOCATIONS LOC,
1821: HZ_CUST_ACCT_SITES_ALL ACCT_SITE
1822: WHERE ACCT_SITE.CUST_ACCOUNT_ID = CUSTOMER_ID
1823: AND ACCT_SITE.CUST_ACCT_SITE_ID = SU.CUST_ACCT_SITE_ID
1824: AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID
1825: AND LOC.LOCATION_ID = PARTY_SITE.LOCATION_ID

Line 1871: HZ_CUST_ACCT_SITES_ALL ACCT_SITE

1867: HZ_CUST_SITE_USES_ALL SU,
1868: HZ_PARTY_SITES PARTY_SITE,
1869: HZ_LOC_ASSIGNMENTS LOC_ASSIGN,
1870: HZ_LOCATIONS LOC,
1871: HZ_CUST_ACCT_SITES_ALL ACCT_SITE
1872: WHERE H.INVOICE_TO_ORG_ID = SU.SITE_USE_ID
1873: AND SU.SITE_USE_ID = C_COMPUTE_AMOUNTSFORMULA.SITE_USE_ID
1874: AND ACCT_SITE.CUST_ACCT_SITE_ID = SU.CUST_ACCT_SITE_ID
1875: AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID

Line 1907: HZ_CUST_ACCT_SITES_ALL ACCT_SITE

1903: HZ_CUST_SITE_USES_ALL SU,
1904: HZ_PARTY_SITES PARTY_SITE,
1905: HZ_LOC_ASSIGNMENTS LOC_ASSIGN,
1906: HZ_LOCATIONS LOC,
1907: HZ_CUST_ACCT_SITES_ALL ACCT_SITE
1908: WHERE SU.SITE_USE_ID = C_COMPUTE_AMOUNTSFORMULA.SITE_USE_ID
1909: AND ACCT_SITE.CUST_ACCT_SITE_ID = SU.CUST_ACCT_SITE_ID
1910: AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID
1911: AND LOC.LOCATION_ID = PARTY_SITE.LOCATION_ID

Line 1943: HZ_CUST_ACCT_SITES_ALL ACCT_SITE

1939: HZ_CUST_SITE_USES_ALL SU,
1940: HZ_PARTY_SITES PARTY_SITE,
1941: HZ_LOC_ASSIGNMENTS LOC_ASSIGN,
1942: HZ_LOCATIONS LOC,
1943: HZ_CUST_ACCT_SITES_ALL ACCT_SITE
1944: WHERE SU.SITE_USE_ID = C_COMPUTE_AMOUNTSFORMULA.SITE_USE_ID
1945: AND ACCT_SITE.CUST_ACCT_SITE_ID = SU.CUST_ACCT_SITE_ID
1946: AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID
1947: AND LOC.LOCATION_ID = PARTY_SITE.LOCATION_ID

Line 1986: HZ_CUST_ACCT_SITES_ALL ACCT_SITE

1982: HZ_CUST_SITE_USES_ALL SU,
1983: HZ_PARTY_SITES PARTY_SITE,
1984: HZ_LOC_ASSIGNMENTS LOC_ASSIGN,
1985: HZ_LOCATIONS LOC,
1986: HZ_CUST_ACCT_SITES_ALL ACCT_SITE
1987: WHERE SU.SITE_USE_ID = C_COMPUTE_AMOUNTSFORMULA.SITE_USE_ID
1988: AND ACCT_SITE.CUST_ACCT_SITE_ID = SU.CUST_ACCT_SITE_ID
1989: AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID
1990: AND LOC.LOCATION_ID = PARTY_SITE.LOCATION_ID

Line 2038: HZ_CUST_ACCT_SITES_ALL ACCT_SITE

2034: HZ_CUST_SITE_USES_ALL SU,
2035: HZ_PARTY_SITES PARTY_SITE,
2036: HZ_LOC_ASSIGNMENTS LOC_ASSIGN,
2037: HZ_LOCATIONS LOC,
2038: HZ_CUST_ACCT_SITES_ALL ACCT_SITE
2039: WHERE ACCT_SITE.CUST_ACCOUNT_ID = CUSTOMER_ID
2040: AND ACCT_SITE.CUST_ACCT_SITE_ID = SU.CUST_ACCT_SITE_ID
2041: AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID
2042: AND LOC.LOCATION_ID = PARTY_SITE.LOCATION_ID

Line 2074: HZ_CUST_ACCT_SITES_ALL ACCT_SITE

2070: HZ_CUST_SITE_USES_ALL SU,
2071: HZ_PARTY_SITES PARTY_SITE,
2072: HZ_LOC_ASSIGNMENTS LOC_ASSIGN,
2073: HZ_LOCATIONS LOC,
2074: HZ_CUST_ACCT_SITES_ALL ACCT_SITE
2075: WHERE ACCT_SITE.CUST_ACCOUNT_ID = CUSTOMER_ID
2076: AND ACCT_SITE.CUST_ACCT_SITE_ID = SU.CUST_ACCT_SITE_ID
2077: AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID
2078: AND LOC.LOCATION_ID = PARTY_SITE.LOCATION_ID

Line 2110: HZ_CUST_ACCT_SITES_ALL ACCT_SITE

2106: HZ_CUST_SITE_USES_ALL SU,
2107: HZ_PARTY_SITES PARTY_SITE,
2108: HZ_LOC_ASSIGNMENTS LOC_ASSIGN,
2109: HZ_LOCATIONS LOC,
2110: HZ_CUST_ACCT_SITES_ALL ACCT_SITE
2111: WHERE ACCT_SITE.CUST_ACCOUNT_ID = CUSTOMER_ID
2112: AND ACCT_SITE.CUST_ACCT_SITE_ID = SU.CUST_ACCT_SITE_ID
2113: AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID
2114: AND LOC.LOCATION_ID = PARTY_SITE.LOCATION_ID

Line 2153: HZ_CUST_ACCT_SITES_ALL ACCT_SITE

2149: HZ_CUST_SITE_USES_ALL SU,
2150: HZ_PARTY_SITES PARTY_SITE,
2151: HZ_LOC_ASSIGNMENTS LOC_ASSIGN,
2152: HZ_LOCATIONS LOC,
2153: HZ_CUST_ACCT_SITES_ALL ACCT_SITE
2154: WHERE ACCT_SITE.CUST_ACCOUNT_ID = CUSTOMER_ID
2155: AND ACCT_SITE.CUST_ACCT_SITE_ID = SU.CUST_ACCT_SITE_ID
2156: AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID
2157: AND LOC.LOCATION_ID = PARTY_SITE.LOCATION_ID

Line 2203: HZ_CUST_ACCT_SITES_ALL ACCT_SITE

2199: HZ_CUST_SITE_USES_ALL SU,
2200: HZ_PARTY_SITES PARTY_SITE,
2201: HZ_LOC_ASSIGNMENTS LOC_ASSIGN,
2202: HZ_LOCATIONS LOC,
2203: HZ_CUST_ACCT_SITES_ALL ACCT_SITE
2204: WHERE H.INVOICE_TO_ORG_ID = SU.SITE_USE_ID
2205: AND SU.SITE_USE_ID = C_COMPUTE_AMOUNTSFORMULA.SITE_USE_ID
2206: AND ACCT_SITE.CUST_ACCT_SITE_ID = SU.CUST_ACCT_SITE_ID
2207: AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID

Line 2239: HZ_CUST_ACCT_SITES_ALL ACCT_SITE

2235: HZ_CUST_SITE_USES_ALL SU,
2236: HZ_PARTY_SITES PARTY_SITE,
2237: HZ_LOC_ASSIGNMENTS LOC_ASSIGN,
2238: HZ_LOCATIONS LOC,
2239: HZ_CUST_ACCT_SITES_ALL ACCT_SITE
2240: WHERE SU.SITE_USE_ID = C_COMPUTE_AMOUNTSFORMULA.SITE_USE_ID
2241: AND ACCT_SITE.CUST_ACCT_SITE_ID = SU.CUST_ACCT_SITE_ID
2242: AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID
2243: AND LOC.LOCATION_ID = PARTY_SITE.LOCATION_ID

Line 2275: HZ_CUST_ACCT_SITES_ALL ACCT_SITE

2271: HZ_CUST_SITE_USES_ALL SU,
2272: HZ_PARTY_SITES PARTY_SITE,
2273: HZ_LOC_ASSIGNMENTS LOC_ASSIGN,
2274: HZ_LOCATIONS LOC,
2275: HZ_CUST_ACCT_SITES_ALL ACCT_SITE
2276: WHERE SU.SITE_USE_ID = C_COMPUTE_AMOUNTSFORMULA.SITE_USE_ID
2277: AND ACCT_SITE.CUST_ACCT_SITE_ID = SU.CUST_ACCT_SITE_ID
2278: AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID
2279: AND LOC.LOCATION_ID = PARTY_SITE.LOCATION_ID

Line 2318: HZ_CUST_ACCT_SITES_ALL ACCT_SITE

2314: HZ_CUST_SITE_USES_ALL SU,
2315: HZ_PARTY_SITES PARTY_SITE,
2316: HZ_LOC_ASSIGNMENTS LOC_ASSIGN,
2317: HZ_LOCATIONS LOC,
2318: HZ_CUST_ACCT_SITES_ALL ACCT_SITE
2319: WHERE SU.SITE_USE_ID = C_COMPUTE_AMOUNTSFORMULA.SITE_USE_ID
2320: AND ACCT_SITE.CUST_ACCT_SITE_ID = SU.CUST_ACCT_SITE_ID
2321: AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID
2322: AND LOC.LOCATION_ID = PARTY_SITE.LOCATION_ID