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_LOCATIONS

Line 733: HZ_LOCATIONS LOC,

729: OE_ORDER_HEADERS H,
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

Line 769: HZ_LOCATIONS LOC,

765: OE_ORDER_HEADERS H,
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

Line 805: HZ_LOCATIONS LOC,

801: OE_ORDER_HEADERS H,
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

Line 848: HZ_LOCATIONS LOC,

844: OE_ORDER_HEADERS H,
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

Line 898: HZ_LOCATIONS LOC,

894: OE_ORDER_HEADERS H,
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

Line 934: HZ_LOCATIONS LOC,

930: OE_ORDER_HEADERS H,
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

Line 970: HZ_LOCATIONS LOC,

966: OE_ORDER_HEADERS H,
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

Line 1013: HZ_LOCATIONS LOC,

1009: OE_ORDER_HEADERS H,
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

Line 1065: HZ_LOCATIONS LOC,

1061: OE_ORDER_HEADERS H,
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

Line 1101: HZ_LOCATIONS LOC,

1097: OE_ORDER_HEADERS H,
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

Line 1137: HZ_LOCATIONS LOC,

1133: OE_ORDER_HEADERS H,
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

Line 1180: HZ_LOCATIONS LOC,

1176: OE_ORDER_HEADERS H,
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

Line 1230: HZ_LOCATIONS LOC,

1226: OE_ORDER_HEADERS H,
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

Line 1266: HZ_LOCATIONS LOC,

1262: OE_ORDER_HEADERS H,
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

Line 1302: HZ_LOCATIONS LOC,

1298: OE_ORDER_HEADERS H,
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

Line 1345: HZ_LOCATIONS LOC,

1341: OE_ORDER_HEADERS H,
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

Line 1705: HZ_LOCATIONS LOC,

1701: OE_ORDER_HEADERS H,
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

Line 1741: HZ_LOCATIONS LOC,

1737: OE_ORDER_HEADERS H,
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

Line 1777: HZ_LOCATIONS LOC,

1773: OE_ORDER_HEADERS H,
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

Line 1820: HZ_LOCATIONS LOC,

1816: OE_ORDER_HEADERS H,
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

Line 1870: HZ_LOCATIONS LOC,

1866: OE_ORDER_HEADERS H,
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

Line 1906: HZ_LOCATIONS LOC,

1902: OE_ORDER_HEADERS H,
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

Line 1942: HZ_LOCATIONS LOC,

1938: OE_ORDER_HEADERS H,
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

Line 1985: HZ_LOCATIONS LOC,

1981: OE_ORDER_HEADERS H,
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

Line 2037: HZ_LOCATIONS LOC,

2033: OE_ORDER_HEADERS H,
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

Line 2073: HZ_LOCATIONS LOC,

2069: OE_ORDER_HEADERS H,
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

Line 2109: HZ_LOCATIONS LOC,

2105: OE_ORDER_HEADERS H,
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

Line 2152: HZ_LOCATIONS LOC,

2148: OE_ORDER_HEADERS H,
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

Line 2202: HZ_LOCATIONS LOC,

2198: OE_ORDER_HEADERS H,
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

Line 2238: HZ_LOCATIONS LOC,

2234: OE_ORDER_HEADERS H,
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

Line 2274: HZ_LOCATIONS LOC,

2270: OE_ORDER_HEADERS H,
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

Line 2317: HZ_LOCATIONS LOC,

2313: OE_ORDER_HEADERS H,
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