DBA Data[Home] [Help]

APPS.OKL_STREAMS_RECON_PVT dependencies on OKC_K_LINES_B

Line 158: okc_k_lines_b kle,

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

Line 191: okc_k_lines_b kle,

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

Line 225: okc_k_lines_b kle,

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)
229: AND khr.authoring_org_id = p_org_id

Line 260: okc_k_lines_b kle,

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)
264: AND khr.authoring_org_id = p_org_id

Line 296: okc_k_lines_b kle,

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)
300: AND khr.authoring_org_id = p_org_id

Line 338: okc_k_lines_b kle,

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)
342: AND khr.authoring_org_id = p_org_id

Line 386: okc_k_lines_b kle,

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

Line 422: okc_k_lines_b kle,

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)
426: AND khr.authoring_org_id = p_org_id

Line 458: okc_k_lines_b kle,

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)
462: AND khr.authoring_org_id = p_org_id

Line 496: okc_k_lines_b kle,

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)
500: AND khr.authoring_org_id = p_org_id

Line 1191: okc_k_lines_b kle,

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

Line 1224: okc_k_lines_b kle,

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

Line 1258: okc_k_lines_b kle,

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)
1262: AND khr.authoring_org_id = p_org_id

Line 1293: okc_k_lines_b kle,

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)
1297: AND khr.authoring_org_id = p_org_id

Line 1329: okc_k_lines_b kle,

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)
1333: AND khr.authoring_org_id = p_org_id

Line 1371: okc_k_lines_b kle,

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)
1375: AND khr.authoring_org_id = p_org_id

Line 1419: okc_k_lines_b kle,

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

Line 1455: okc_k_lines_b kle,

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)
1459: AND khr.authoring_org_id = p_org_id

Line 1491: okc_k_lines_b kle,

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)
1495: AND khr.authoring_org_id = p_org_id

Line 1529: okc_k_lines_b kle,

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)
1533: AND khr.authoring_org_id = p_org_id