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.OKL_STREAMS_RECON_PVT dependencies on OKC_STATUSES_B

Line 159: okc_statuses_b khs,

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
161: WHERE chrb.contract_number = NVL(p_contract_number,chrb.contract_number)
162: AND chrb.end_date <= NVL(p_end_date,chrb.end_date)
163: AND chrb.authoring_org_id = p_org_id

Line 160: okc_statuses_b kls

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
161: WHERE chrb.contract_number = NVL(p_contract_number,chrb.contract_number)
162: AND chrb.end_date <= NVL(p_end_date,chrb.end_date)
163: AND chrb.authoring_org_id = p_org_id
164: AND chrb.id = stm.khr_id

Line 192: okc_statuses_b khs,

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
194: WHERE chrb.contract_number = NVL(p_contract_number,chrb.contract_number)
195: AND chrb.end_date <= NVL(p_end_date,chrb.end_date)
196: AND chrb.authoring_org_id = p_org_id

Line 193: okc_statuses_b kls

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
194: WHERE chrb.contract_number = NVL(p_contract_number,chrb.contract_number)
195: AND chrb.end_date <= NVL(p_end_date,chrb.end_date)
196: AND chrb.authoring_org_id = p_org_id
197: AND chrb.currency_code = p_curr_code

Line 222: okc_statuses_b khs,

218: SELECT SUM(ste.amount) amount
219: FROM okl_strm_type_v sty,
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

Line 223: okc_statuses_b kls,

219: FROM okl_strm_type_v sty,
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)

Line 257: okc_statuses_b khs,

253: SELECT SUM(ste.amount) amount
254: FROM okl_strm_type_v sty,
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

Line 258: okc_statuses_b kls,

254: FROM okl_strm_type_v sty,
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)

Line 293: okc_statuses_b khs,

289: SELECT SUM(ste.amount) amount
290: FROM okl_strm_type_v sty,
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

Line 294: okc_statuses_b kls,

290: FROM okl_strm_type_v sty,
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)

Line 333: okc_statuses_b khs,

329: SUM(ste.amount) amount
330: FROM okl_strm_type_v sty,
331: okl_strm_elements ste,
332: okl_streams stm,
333: okc_statuses_b khs,
334: okc_statuses_b kls,
335: okl_products pdt,
336: fnd_lookup_values fnd,
337: okl_k_headers khl,

Line 334: okc_statuses_b kls,

330: FROM okl_strm_type_v sty,
331: okl_strm_elements ste,
332: okl_streams stm,
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,

Line 387: okc_statuses_b khs,

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
389: WHERE chrb.contract_number = NVL(p_contract_number,chrb.contract_number)
390: AND chrb.end_date <= NVL(p_end_date,chrb.end_date)
391: AND chrb.authoring_org_id = p_org_id

Line 388: okc_statuses_b kls

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
389: WHERE chrb.contract_number = NVL(p_contract_number,chrb.contract_number)
390: AND chrb.end_date <= NVL(p_end_date,chrb.end_date)
391: AND chrb.authoring_org_id = p_org_id
392: AND chrb.id = stm.khr_id

Line 419: okc_statuses_b khs,

415: SUM(ste.amount) billed_streams
416: FROM okl_strm_type_v sty,
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

Line 420: okc_statuses_b kls,

416: FROM okl_strm_type_v sty,
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)

Line 455: okc_statuses_b khs,

451: SUM(ste.amount)
452: FROM okl_strm_type_v sty,
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

Line 456: okc_statuses_b kls,

452: FROM okl_strm_type_v sty,
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)

Line 493: okc_statuses_b khs,

489: SUM(ste.amount)
490: FROM okl_strm_type_v sty,
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

Line 494: okc_statuses_b kls,

490: FROM okl_strm_type_v sty,
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)

Line 1192: okc_statuses_b khs,

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
1194: WHERE chrb.contract_number = NVL(p_contract_number,chrb.contract_number)
1195: AND chrb.end_date <= NVL(p_end_date,chrb.end_date)
1196: AND chrb.authoring_org_id = p_org_id

Line 1193: okc_statuses_b kls

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
1194: WHERE chrb.contract_number = NVL(p_contract_number,chrb.contract_number)
1195: AND chrb.end_date <= NVL(p_end_date,chrb.end_date)
1196: AND chrb.authoring_org_id = p_org_id
1197: AND chrb.id = stm.khr_id

Line 1225: okc_statuses_b khs,

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
1227: WHERE chrb.contract_number = NVL(p_contract_number,chrb.contract_number)
1228: AND chrb.end_date <= NVL(p_end_date,chrb.end_date)
1229: AND chrb.authoring_org_id = p_org_id

Line 1226: okc_statuses_b kls

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
1227: WHERE chrb.contract_number = NVL(p_contract_number,chrb.contract_number)
1228: AND chrb.end_date <= NVL(p_end_date,chrb.end_date)
1229: AND chrb.authoring_org_id = p_org_id
1230: AND chrb.currency_code = p_curr_code

Line 1255: okc_statuses_b khs,

1251: SELECT SUM(ste.amount) amount
1252: FROM okl_strm_type_v sty,
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

Line 1256: okc_statuses_b kls,

1252: FROM okl_strm_type_v sty,
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)

Line 1290: okc_statuses_b khs,

1286: SELECT SUM(ste.amount) amount
1287: FROM okl_strm_type_v sty,
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

Line 1291: okc_statuses_b kls,

1287: FROM okl_strm_type_v sty,
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)

Line 1326: okc_statuses_b khs,

1322: SELECT SUM(ste.amount) amount
1323: FROM okl_strm_type_v sty,
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

Line 1327: okc_statuses_b kls,

1323: FROM okl_strm_type_v sty,
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)

Line 1366: okc_statuses_b khs,

1362: SUM(ste.amount) amount
1363: FROM okl_strm_type_v sty,
1364: okl_strm_elements ste,
1365: okl_streams stm,
1366: okc_statuses_b khs,
1367: okc_statuses_b kls,
1368: okl_products pdt,
1369: fnd_lookup_values fnd,
1370: okl_k_headers khl,

Line 1367: okc_statuses_b kls,

1363: FROM okl_strm_type_v sty,
1364: okl_strm_elements ste,
1365: okl_streams stm,
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,

Line 1420: okc_statuses_b khs,

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
1422: WHERE chrb.contract_number = NVL(p_contract_number,chrb.contract_number)
1423: AND chrb.end_date <= NVL(p_end_date,chrb.end_date)
1424: AND chrb.authoring_org_id = p_org_id

Line 1421: okc_statuses_b kls

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
1422: WHERE chrb.contract_number = NVL(p_contract_number,chrb.contract_number)
1423: AND chrb.end_date <= NVL(p_end_date,chrb.end_date)
1424: AND chrb.authoring_org_id = p_org_id
1425: AND chrb.id = stm.khr_id

Line 1452: okc_statuses_b khs,

1448: SUM(ste.amount) billed_streams
1449: FROM okl_strm_type_v sty,
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

Line 1453: okc_statuses_b kls,

1449: FROM okl_strm_type_v sty,
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)

Line 1488: okc_statuses_b khs,

1484: SUM(ste.amount)
1485: FROM okl_strm_type_v sty,
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

Line 1489: okc_statuses_b kls,

1485: FROM okl_strm_type_v sty,
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)

Line 1526: okc_statuses_b khs,

1522: SUM(ste.amount)
1523: FROM okl_strm_type_v sty,
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

Line 1527: okc_statuses_b kls,

1523: FROM okl_strm_type_v sty,
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)