DBA Data[Home] [Help]

APPS.ONT_OEXOECCH_XMLP_PKG dependencies on HZ_CUST_SITE_USES_ALL

Line 730: HZ_CUST_SITE_USES_ALL SU,

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,
734: HZ_CUST_ACCT_SITES_ALL ACCT_SITE

Line 766: HZ_CUST_SITE_USES_ALL SU,

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,
770: HZ_CUST_ACCT_SITES_ALL ACCT_SITE

Line 802: HZ_CUST_SITE_USES_ALL SU,

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,
806: HZ_CUST_ACCT_SITES_ALL ACCT_SITE

Line 845: HZ_CUST_SITE_USES_ALL SU,

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,
849: HZ_CUST_ACCT_SITES_ALL ACCT_SITE

Line 895: HZ_CUST_SITE_USES_ALL SU,

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,
899: HZ_CUST_ACCT_SITES_ALL ACCT_SITE

Line 931: HZ_CUST_SITE_USES_ALL SU,

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,
935: HZ_CUST_ACCT_SITES_ALL ACCT_SITE

Line 967: HZ_CUST_SITE_USES_ALL SU,

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,
971: HZ_CUST_ACCT_SITES_ALL ACCT_SITE

Line 1010: HZ_CUST_SITE_USES_ALL SU,

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,
1014: HZ_CUST_ACCT_SITES_ALL ACCT_SITE

Line 1062: HZ_CUST_SITE_USES_ALL SU,

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,
1066: HZ_CUST_ACCT_SITES_ALL ACCT_SITE

Line 1098: HZ_CUST_SITE_USES_ALL SU,

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,
1102: HZ_CUST_ACCT_SITES_ALL ACCT_SITE

Line 1134: HZ_CUST_SITE_USES_ALL SU,

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,
1138: HZ_CUST_ACCT_SITES_ALL ACCT_SITE

Line 1177: HZ_CUST_SITE_USES_ALL SU,

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,
1181: HZ_CUST_ACCT_SITES_ALL ACCT_SITE

Line 1227: HZ_CUST_SITE_USES_ALL SU,

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,
1231: HZ_CUST_ACCT_SITES_ALL ACCT_SITE

Line 1263: HZ_CUST_SITE_USES_ALL SU,

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,
1267: HZ_CUST_ACCT_SITES_ALL ACCT_SITE

Line 1299: HZ_CUST_SITE_USES_ALL SU,

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,
1303: HZ_CUST_ACCT_SITES_ALL ACCT_SITE

Line 1342: HZ_CUST_SITE_USES_ALL SU,

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,
1346: HZ_CUST_ACCT_SITES_ALL ACCT_SITE

Line 1702: HZ_CUST_SITE_USES_ALL SU,

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,
1706: HZ_CUST_ACCT_SITES_ALL ACCT_SITE

Line 1738: HZ_CUST_SITE_USES_ALL SU,

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,
1742: HZ_CUST_ACCT_SITES_ALL ACCT_SITE

Line 1774: HZ_CUST_SITE_USES_ALL SU,

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,
1778: HZ_CUST_ACCT_SITES_ALL ACCT_SITE

Line 1817: HZ_CUST_SITE_USES_ALL SU,

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,
1821: HZ_CUST_ACCT_SITES_ALL ACCT_SITE

Line 1867: HZ_CUST_SITE_USES_ALL SU,

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,
1871: HZ_CUST_ACCT_SITES_ALL ACCT_SITE

Line 1903: HZ_CUST_SITE_USES_ALL SU,

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,
1907: HZ_CUST_ACCT_SITES_ALL ACCT_SITE

Line 1939: HZ_CUST_SITE_USES_ALL SU,

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,
1943: HZ_CUST_ACCT_SITES_ALL ACCT_SITE

Line 1982: HZ_CUST_SITE_USES_ALL SU,

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,
1986: HZ_CUST_ACCT_SITES_ALL ACCT_SITE

Line 2034: HZ_CUST_SITE_USES_ALL SU,

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,
2038: HZ_CUST_ACCT_SITES_ALL ACCT_SITE

Line 2070: HZ_CUST_SITE_USES_ALL SU,

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,
2074: HZ_CUST_ACCT_SITES_ALL ACCT_SITE

Line 2106: HZ_CUST_SITE_USES_ALL SU,

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,
2110: HZ_CUST_ACCT_SITES_ALL ACCT_SITE

Line 2149: HZ_CUST_SITE_USES_ALL SU,

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,
2153: HZ_CUST_ACCT_SITES_ALL ACCT_SITE

Line 2199: HZ_CUST_SITE_USES_ALL SU,

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,
2203: HZ_CUST_ACCT_SITES_ALL ACCT_SITE

Line 2235: HZ_CUST_SITE_USES_ALL SU,

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,
2239: HZ_CUST_ACCT_SITES_ALL ACCT_SITE

Line 2271: HZ_CUST_SITE_USES_ALL SU,

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,
2275: HZ_CUST_ACCT_SITES_ALL ACCT_SITE

Line 2314: HZ_CUST_SITE_USES_ALL SU,

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,
2318: HZ_CUST_ACCT_SITES_ALL ACCT_SITE