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_LINES_ALL

Line 728: OE_ORDER_LINES_ALL L,

724: ,0))
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,

Line 764: OE_ORDER_LINES_ALL L,

760: ,0)))
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,

Line 800: OE_ORDER_LINES_ALL L,

796: ,0))
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,

Line 843: OE_ORDER_LINES_ALL L,

839: ,0)))
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,

Line 893: OE_ORDER_LINES_ALL L,

889: ,0))
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,

Line 929: OE_ORDER_LINES_ALL L,

925: ,0)))
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,

Line 965: OE_ORDER_LINES_ALL L,

961: ,0))
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,

Line 1008: OE_ORDER_LINES_ALL L,

1004: ,0)))
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,

Line 1060: OE_ORDER_LINES_ALL L,

1056: ,0))
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,

Line 1096: OE_ORDER_LINES_ALL L,

1092: ,0)))
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,

Line 1132: OE_ORDER_LINES_ALL L,

1128: ,0))
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,

Line 1175: OE_ORDER_LINES_ALL L,

1171: ,0)))
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,

Line 1225: OE_ORDER_LINES_ALL L,

1221: ,0))
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,

Line 1261: OE_ORDER_LINES_ALL L,

1257: ,0)))
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,

Line 1297: OE_ORDER_LINES_ALL L,

1293: ,0))
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,

Line 1340: OE_ORDER_LINES_ALL L,

1336: ,0)))
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,

Line 1700: OE_ORDER_LINES_ALL L,

1696: ,0))
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,

Line 1736: OE_ORDER_LINES_ALL L,

1732: ,0)))
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,

Line 1772: OE_ORDER_LINES_ALL L,

1768: ,0))
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,

Line 1815: OE_ORDER_LINES_ALL L,

1811: ,0)))
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,

Line 1865: OE_ORDER_LINES_ALL L,

1861: ,0))
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,

Line 1901: OE_ORDER_LINES_ALL L,

1897: ,0)))
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,

Line 1937: OE_ORDER_LINES_ALL L,

1933: ,0))
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,

Line 1980: OE_ORDER_LINES_ALL L,

1976: ,0)))
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,

Line 2032: OE_ORDER_LINES_ALL L,

2028: ,0))
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,

Line 2068: OE_ORDER_LINES_ALL L,

2064: ,0)))
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,

Line 2104: OE_ORDER_LINES_ALL L,

2100: ,0))
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,

Line 2147: OE_ORDER_LINES_ALL L,

2143: ,0)))
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,

Line 2197: OE_ORDER_LINES_ALL L,

2193: ,0))
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,

Line 2233: OE_ORDER_LINES_ALL L,

2229: ,0)))
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,

Line 2269: OE_ORDER_LINES_ALL L,

2265: ,0))
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,

Line 2312: OE_ORDER_LINES_ALL L,

2308: ,0)))
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,