[Home] [Help]
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
736: AND ACCT_SITE.CUST_ACCOUNT_ID = CUSTOMER_ID
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
772: AND ACCT_SITE.CUST_ACCT_SITE_ID = SU.CUST_ACCT_SITE_ID
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
808: AND ACCT_SITE.CUST_ACCT_SITE_ID = SU.CUST_ACCT_SITE_ID
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
851: AND ACCT_SITE.CUST_ACCT_SITE_ID = SU.CUST_ACCT_SITE_ID
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
901: AND SU.SITE_USE_ID = C_COMPUTE_AMOUNTSFORMULA.SITE_USE_ID
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
937: AND ACCT_SITE.CUST_ACCT_SITE_ID = SU.CUST_ACCT_SITE_ID
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
973: AND ACCT_SITE.CUST_ACCT_SITE_ID = SU.CUST_ACCT_SITE_ID
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
1016: AND ACCT_SITE.CUST_ACCT_SITE_ID = SU.CUST_ACCT_SITE_ID
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
1068: AND ACCT_SITE.CUST_ACCT_SITE_ID = SU.CUST_ACCT_SITE_ID
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
1104: AND ACCT_SITE.CUST_ACCT_SITE_ID = SU.CUST_ACCT_SITE_ID
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
1140: AND ACCT_SITE.CUST_ACCT_SITE_ID = SU.CUST_ACCT_SITE_ID
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
1183: AND ACCT_SITE.CUST_ACCT_SITE_ID = SU.CUST_ACCT_SITE_ID
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
1233: AND SU.SITE_USE_ID = C_COMPUTE_AMOUNTSFORMULA.SITE_USE_ID
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
1269: AND ACCT_SITE.CUST_ACCT_SITE_ID = SU.CUST_ACCT_SITE_ID
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
1305: AND ACCT_SITE.CUST_ACCT_SITE_ID = SU.CUST_ACCT_SITE_ID
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
1348: AND ACCT_SITE.CUST_ACCT_SITE_ID = SU.CUST_ACCT_SITE_ID
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
1708: AND ACCT_SITE.CUST_ACCT_SITE_ID = SU.CUST_ACCT_SITE_ID
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
1744: AND ACCT_SITE.CUST_ACCT_SITE_ID = SU.CUST_ACCT_SITE_ID
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
1780: AND ACCT_SITE.CUST_ACCT_SITE_ID = SU.CUST_ACCT_SITE_ID
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
1823: AND ACCT_SITE.CUST_ACCT_SITE_ID = SU.CUST_ACCT_SITE_ID
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
1873: AND SU.SITE_USE_ID = C_COMPUTE_AMOUNTSFORMULA.SITE_USE_ID
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
1909: AND ACCT_SITE.CUST_ACCT_SITE_ID = SU.CUST_ACCT_SITE_ID
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
1945: AND ACCT_SITE.CUST_ACCT_SITE_ID = SU.CUST_ACCT_SITE_ID
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
1988: AND ACCT_SITE.CUST_ACCT_SITE_ID = SU.CUST_ACCT_SITE_ID
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
2040: AND ACCT_SITE.CUST_ACCT_SITE_ID = SU.CUST_ACCT_SITE_ID
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
2076: AND ACCT_SITE.CUST_ACCT_SITE_ID = SU.CUST_ACCT_SITE_ID
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
2112: AND ACCT_SITE.CUST_ACCT_SITE_ID = SU.CUST_ACCT_SITE_ID
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
2155: AND ACCT_SITE.CUST_ACCT_SITE_ID = SU.CUST_ACCT_SITE_ID
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
2205: AND SU.SITE_USE_ID = C_COMPUTE_AMOUNTSFORMULA.SITE_USE_ID
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
2241: AND ACCT_SITE.CUST_ACCT_SITE_ID = SU.CUST_ACCT_SITE_ID
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
2277: AND ACCT_SITE.CUST_ACCT_SITE_ID = SU.CUST_ACCT_SITE_ID
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
2320: AND ACCT_SITE.CUST_ACCT_SITE_ID = SU.CUST_ACCT_SITE_ID