[Home] [Help]
152: SELECT DISTINCT chrb.currency_code
153: FROM okl_strm_elements ele,
154: okl_streams stm,
155: okl_strm_type_b sty,
156: okl_k_headers khr,
157: okc_k_headers_b chrb,
158: okc_k_lines_b kle,
159: okc_statuses_b khs,
160: okc_statuses_b kls
185: SELECT SUM(ele.amount) amount
186: FROM okl_strm_elements ele,
187: okl_streams stm,
188: okl_strm_type_b sty,
189: okl_k_headers khr,
190: okc_k_headers_b chrb,
191: okc_k_lines_b kle,
192: okc_statuses_b khs,
193: okc_statuses_b kls
220: okl_strm_elements ste,
221: okl_streams stm,
222: okc_statuses_b khs,
223: okc_statuses_b kls,
224: okl_k_headers khl,
225: okc_k_lines_b kle,
226: okc_k_headers_b khr
227: WHERE khr.contract_number = NVL(p_contract_number,khr.contract_number)
228: AND khr.end_date <= NVL(p_end_date,khr.end_date)
255: okl_strm_elements ste,
256: okl_streams stm,
257: okc_statuses_b khs,
258: okc_statuses_b kls,
259: okl_k_headers khl,
260: okc_k_lines_b kle,
261: okc_k_headers_b khr
262: WHERE khr.contract_number = NVL(p_contract_number,khr.contract_number)
263: AND khr.end_date <= NVL(p_end_date,khr.end_date)
291: okl_strm_elements ste,
292: okl_streams stm,
293: okc_statuses_b khs,
294: okc_statuses_b kls,
295: okl_k_headers khl,
296: okc_k_lines_b kle,
297: okc_k_headers_b khr
298: WHERE khr.contract_number = NVL(p_contract_number,khr.contract_number)
299: AND khr.end_date <= NVL(p_end_date,khr.end_date)
333: okc_statuses_b khs,
334: okc_statuses_b kls,
335: okl_products pdt,
336: fnd_lookup_values fnd,
337: okl_k_headers khl,
338: okc_k_lines_b kle,
339: okc_k_headers_b khr
340: WHERE khr.contract_number = NVL(p_contract_number,khr.contract_number)
341: AND khr.end_date <= NVL(p_end_date,khr.end_date)
380: SUM(ele.amount) amount
381: FROM okl_strm_elements ele,
382: okl_streams stm,
383: okl_strm_type_b sty,
384: okl_k_headers khr,
385: okc_k_headers_b chrb,
386: okc_k_lines_b kle,
387: okc_statuses_b khs,
388: okc_statuses_b kls
417: okl_strm_elements ste,
418: okl_streams stm,
419: okc_statuses_b khs,
420: okc_statuses_b kls,
421: okl_k_headers khl,
422: okc_k_lines_b kle,
423: okc_k_headers_b khr
424: WHERE khr.contract_number = NVL(p_contract_number,khr.contract_number)
425: AND khr.end_date <= NVL(p_end_date,khr.end_date)
453: okl_strm_elements ste,
454: okl_streams stm,
455: okc_statuses_b khs,
456: okc_statuses_b kls,
457: okl_k_headers khl,
458: okc_k_lines_b kle,
459: okc_k_headers_b khr
460: WHERE khr.contract_number = NVL(p_contract_number,khr.contract_number)
461: AND khr.end_date <= NVL(p_end_date,khr.end_date)
491: okl_strm_elements ste,
492: okl_streams stm,
493: okc_statuses_b khs,
494: okc_statuses_b kls,
495: okl_k_headers khl,
496: okc_k_lines_b kle,
497: okc_k_headers_b khr
498: WHERE khr.contract_number = NVL(p_contract_number,khr.contract_number)
499: AND khr.end_date <= NVL(p_end_date,khr.end_date)
1185: SELECT DISTINCT chrb.currency_code
1186: FROM okl_strm_elements ele,
1187: okl_streams stm,
1188: okl_strm_type_b sty,
1189: okl_k_headers khr,
1190: okc_k_headers_b chrb,
1191: okc_k_lines_b kle,
1192: okc_statuses_b khs,
1193: okc_statuses_b kls
1218: SELECT SUM(ele.amount) amount
1219: FROM okl_strm_elements ele,
1220: okl_streams stm,
1221: okl_strm_type_b sty,
1222: okl_k_headers khr,
1223: okc_k_headers_b chrb,
1224: okc_k_lines_b kle,
1225: okc_statuses_b khs,
1226: okc_statuses_b kls
1253: okl_strm_elements ste,
1254: okl_streams stm,
1255: okc_statuses_b khs,
1256: okc_statuses_b kls,
1257: okl_k_headers khl,
1258: okc_k_lines_b kle,
1259: okc_k_headers_b khr
1260: WHERE khr.contract_number = NVL(p_contract_number,khr.contract_number)
1261: AND khr.end_date <= NVL(p_end_date,khr.end_date)
1288: okl_strm_elements ste,
1289: okl_streams stm,
1290: okc_statuses_b khs,
1291: okc_statuses_b kls,
1292: okl_k_headers khl,
1293: okc_k_lines_b kle,
1294: okc_k_headers_b khr
1295: WHERE khr.contract_number = NVL(p_contract_number,khr.contract_number)
1296: AND khr.end_date <= NVL(p_end_date,khr.end_date)
1324: okl_strm_elements ste,
1325: okl_streams stm,
1326: okc_statuses_b khs,
1327: okc_statuses_b kls,
1328: okl_k_headers khl,
1329: okc_k_lines_b kle,
1330: okc_k_headers_b khr
1331: WHERE khr.contract_number = NVL(p_contract_number,khr.contract_number)
1332: AND khr.end_date <= NVL(p_end_date,khr.end_date)
1366: okc_statuses_b khs,
1367: okc_statuses_b kls,
1368: okl_products pdt,
1369: fnd_lookup_values fnd,
1370: okl_k_headers khl,
1371: okc_k_lines_b kle,
1372: okc_k_headers_b khr
1373: WHERE khr.contract_number = NVL(p_contract_number,khr.contract_number)
1374: AND khr.end_date <= NVL(p_end_date,khr.end_date)
1413: SUM(ele.amount) amount
1414: FROM okl_strm_elements ele,
1415: okl_streams stm,
1416: okl_strm_type_b sty,
1417: okl_k_headers khr,
1418: okc_k_headers_b chrb,
1419: okc_k_lines_b kle,
1420: okc_statuses_b khs,
1421: okc_statuses_b kls
1450: okl_strm_elements ste,
1451: okl_streams stm,
1452: okc_statuses_b khs,
1453: okc_statuses_b kls,
1454: okl_k_headers khl,
1455: okc_k_lines_b kle,
1456: okc_k_headers_b khr
1457: WHERE khr.contract_number = NVL(p_contract_number,khr.contract_number)
1458: AND khr.end_date <= NVL(p_end_date,khr.end_date)
1486: okl_strm_elements ste,
1487: okl_streams stm,
1488: okc_statuses_b khs,
1489: okc_statuses_b kls,
1490: okl_k_headers khl,
1491: okc_k_lines_b kle,
1492: okc_k_headers_b khr
1493: WHERE khr.contract_number = NVL(p_contract_number,khr.contract_number)
1494: AND khr.end_date <= NVL(p_end_date,khr.end_date)
1524: okl_strm_elements ste,
1525: okl_streams stm,
1526: okc_statuses_b khs,
1527: okc_statuses_b kls,
1528: okl_k_headers khl,
1529: okc_k_lines_b kle,
1530: okc_k_headers_b khr
1531: WHERE khr.contract_number = NVL(p_contract_number,khr.contract_number)
1532: AND khr.end_date <= NVL(p_end_date,khr.end_date)