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 OE_ORDER_HEADERS

Line 729: OE_ORDER_HEADERS H,

725: ,0)
726: INTO L_TOTAL1_CREDIT
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,

Line 765: OE_ORDER_HEADERS H,

761: ,0)
762: INTO L_TOTAL3_CREDIT
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,

Line 801: OE_ORDER_HEADERS H,

797: ,0)
798: INTO L_TOTAL1_CREDIT
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,

Line 844: OE_ORDER_HEADERS H,

840: ,0)
841: INTO L_TOTAL3_CREDIT
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,

Line 894: OE_ORDER_HEADERS H,

890: ,0)
891: INTO L_TOTAL1_CREDIT
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,

Line 930: OE_ORDER_HEADERS H,

926: ,0)
927: INTO L_TOTAL3_CREDIT
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,

Line 966: OE_ORDER_HEADERS H,

962: ,0)
963: INTO L_TOTAL1_CREDIT
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,

Line 1009: OE_ORDER_HEADERS H,

1005: ,0)
1006: INTO L_TOTAL3_CREDIT
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,

Line 1061: OE_ORDER_HEADERS H,

1057: ,0)
1058: INTO L_TOTAL1_SHIP
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,

Line 1097: OE_ORDER_HEADERS H,

1093: ,0)
1094: INTO L_TOTAL3_SHIP
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,

Line 1133: OE_ORDER_HEADERS H,

1129: ,0)
1130: INTO L_TOTAL1_SHIP
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,

Line 1176: OE_ORDER_HEADERS H,

1172: ,0)
1173: INTO L_TOTAL3_SHIP
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,

Line 1226: OE_ORDER_HEADERS H,

1222: ,0)
1223: INTO L_TOTAL1_SHIP
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,

Line 1262: OE_ORDER_HEADERS H,

1258: ,0)
1259: INTO L_TOTAL3_SHIP
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,

Line 1298: OE_ORDER_HEADERS H,

1294: ,0)
1295: INTO L_TOTAL1_SHIP
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,

Line 1341: OE_ORDER_HEADERS H,

1337: ,0)
1338: INTO L_TOTAL3_SHIP
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,

Line 1701: OE_ORDER_HEADERS H,

1697: ,0)
1698: INTO L_TOTAL1_PICK
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,

Line 1737: OE_ORDER_HEADERS H,

1733: ,0)
1734: INTO L_TOTAL3_PICK
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,

Line 1773: OE_ORDER_HEADERS H,

1769: ,0)
1770: INTO L_TOTAL1_PICK
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,

Line 1816: OE_ORDER_HEADERS H,

1812: ,0)
1813: INTO L_TOTAL3_PICK
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,

Line 1866: OE_ORDER_HEADERS H,

1862: ,0)
1863: INTO L_TOTAL1_PICK
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,

Line 1902: OE_ORDER_HEADERS H,

1898: ,0)
1899: INTO L_TOTAL3_PICK
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,

Line 1938: OE_ORDER_HEADERS H,

1934: ,0)
1935: INTO L_TOTAL1_PICK
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,

Line 1981: OE_ORDER_HEADERS H,

1977: ,0)
1978: INTO L_TOTAL3_PICK
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,

Line 2033: OE_ORDER_HEADERS H,

2029: ,0)
2030: INTO L_TOTAL1_PACK
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,

Line 2069: OE_ORDER_HEADERS H,

2065: ,0)
2066: INTO L_TOTAL3_PACK
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,

Line 2105: OE_ORDER_HEADERS H,

2101: ,0)
2102: INTO L_TOTAL1_PACK
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,

Line 2148: OE_ORDER_HEADERS H,

2144: ,0)
2145: INTO L_TOTAL3_PACK
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,

Line 2198: OE_ORDER_HEADERS H,

2194: ,0)
2195: INTO L_TOTAL1_PACK
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,

Line 2234: OE_ORDER_HEADERS H,

2230: ,0)
2231: INTO L_TOTAL3_PACK
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,

Line 2270: OE_ORDER_HEADERS H,

2266: ,0)
2267: INTO L_TOTAL1_PACK
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,

Line 2313: OE_ORDER_HEADERS H,

2309: ,0)
2310: INTO L_TOTAL3_PACK
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,