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_PARTY_SITES

Line 731: HZ_PARTY_SITES PARTY_SITE,

727: FROM
728: OE_ORDER_LINES_ALL L,
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

Line 767: HZ_PARTY_SITES PARTY_SITE,

763: FROM
764: OE_ORDER_LINES_ALL L,
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

Line 803: HZ_PARTY_SITES PARTY_SITE,

799: FROM
800: OE_ORDER_LINES_ALL L,
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

Line 846: HZ_PARTY_SITES PARTY_SITE,

842: FROM
843: OE_ORDER_LINES_ALL L,
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

Line 896: HZ_PARTY_SITES PARTY_SITE,

892: FROM
893: OE_ORDER_LINES_ALL L,
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

Line 932: HZ_PARTY_SITES PARTY_SITE,

928: FROM
929: OE_ORDER_LINES_ALL L,
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

Line 968: HZ_PARTY_SITES PARTY_SITE,

964: FROM
965: OE_ORDER_LINES_ALL L,
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

Line 1011: HZ_PARTY_SITES PARTY_SITE,

1007: FROM
1008: OE_ORDER_LINES_ALL L,
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

Line 1063: HZ_PARTY_SITES PARTY_SITE,

1059: FROM
1060: OE_ORDER_LINES_ALL L,
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

Line 1099: HZ_PARTY_SITES PARTY_SITE,

1095: FROM
1096: OE_ORDER_LINES_ALL L,
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

Line 1135: HZ_PARTY_SITES PARTY_SITE,

1131: FROM
1132: OE_ORDER_LINES_ALL L,
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

Line 1178: HZ_PARTY_SITES PARTY_SITE,

1174: FROM
1175: OE_ORDER_LINES_ALL L,
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

Line 1228: HZ_PARTY_SITES PARTY_SITE,

1224: FROM
1225: OE_ORDER_LINES_ALL L,
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

Line 1264: HZ_PARTY_SITES PARTY_SITE,

1260: FROM
1261: OE_ORDER_LINES_ALL L,
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

Line 1300: HZ_PARTY_SITES PARTY_SITE,

1296: FROM
1297: OE_ORDER_LINES_ALL L,
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

Line 1343: HZ_PARTY_SITES PARTY_SITE,

1339: FROM
1340: OE_ORDER_LINES_ALL L,
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

Line 1703: HZ_PARTY_SITES PARTY_SITE,

1699: FROM
1700: OE_ORDER_LINES_ALL L,
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

Line 1739: HZ_PARTY_SITES PARTY_SITE,

1735: FROM
1736: OE_ORDER_LINES_ALL L,
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

Line 1775: HZ_PARTY_SITES PARTY_SITE,

1771: FROM
1772: OE_ORDER_LINES_ALL L,
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

Line 1818: HZ_PARTY_SITES PARTY_SITE,

1814: FROM
1815: OE_ORDER_LINES_ALL L,
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

Line 1868: HZ_PARTY_SITES PARTY_SITE,

1864: FROM
1865: OE_ORDER_LINES_ALL L,
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

Line 1904: HZ_PARTY_SITES PARTY_SITE,

1900: FROM
1901: OE_ORDER_LINES_ALL L,
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

Line 1940: HZ_PARTY_SITES PARTY_SITE,

1936: FROM
1937: OE_ORDER_LINES_ALL L,
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

Line 1983: HZ_PARTY_SITES PARTY_SITE,

1979: FROM
1980: OE_ORDER_LINES_ALL L,
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

Line 2035: HZ_PARTY_SITES PARTY_SITE,

2031: FROM
2032: OE_ORDER_LINES_ALL L,
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

Line 2071: HZ_PARTY_SITES PARTY_SITE,

2067: FROM
2068: OE_ORDER_LINES_ALL L,
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

Line 2107: HZ_PARTY_SITES PARTY_SITE,

2103: FROM
2104: OE_ORDER_LINES_ALL L,
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

Line 2150: HZ_PARTY_SITES PARTY_SITE,

2146: FROM
2147: OE_ORDER_LINES_ALL L,
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

Line 2200: HZ_PARTY_SITES PARTY_SITE,

2196: FROM
2197: OE_ORDER_LINES_ALL L,
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

Line 2236: HZ_PARTY_SITES PARTY_SITE,

2232: FROM
2233: OE_ORDER_LINES_ALL L,
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

Line 2272: HZ_PARTY_SITES PARTY_SITE,

2268: FROM
2269: OE_ORDER_LINES_ALL L,
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

Line 2315: HZ_PARTY_SITES PARTY_SITE,

2311: FROM
2312: OE_ORDER_LINES_ALL L,
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