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.OKC_QUERY dependencies on OKC_K_HEADERS_ALL_B

Line 230: /nechatur 18-oct-2005 bug # 4666846 replacing okc_k_headers_b to okc_k_headers_all_b /

226: FUNCTION GetKid(p_notification_id IN NUMBER,
227: p_att_name IN VARCHAR2)
228: RETURN NUMBER
229: IS
230: /*nechatur 18-oct-2005 bug # 4666846 replacing okc_k_headers_b to okc_k_headers_all_b */
231: /* v_id okc_k_headers_b.id%TYPE; */
232: v_id okc_k_headers_all_b.id%TYPE;
233: -- end bug # 4666846
234: BEGIN

Line 232: v_id okc_k_headers_all_b.id%TYPE;

228: RETURN NUMBER
229: IS
230: /*nechatur 18-oct-2005 bug # 4666846 replacing okc_k_headers_b to okc_k_headers_all_b */
231: /* v_id okc_k_headers_b.id%TYPE; */
232: v_id okc_k_headers_all_b.id%TYPE;
233: -- end bug # 4666846
234: BEGIN
235:
236: v_id := wf_notification.getattrnumber(p_notification_id,

Line 263: /nechatur 18-oct-2005 bug # 4666846 replacing okc_k_headers_b to okc_k_headers_all_b /

259: RETURN VARCHAR2 is
260: CURSOR k_cur(x in number)
261: IS
262: select k.contract_number
263: /*nechatur 18-oct-2005 bug # 4666846 replacing okc_k_headers_b to okc_k_headers_all_b */
264: /* from okc_k_headers_b k */
265: from okc_k_headers_all_b k
266: --end bug # 4666846
267: where k.id = x;

Line 265: from okc_k_headers_all_b k

261: IS
262: select k.contract_number
263: /*nechatur 18-oct-2005 bug # 4666846 replacing okc_k_headers_b to okc_k_headers_all_b */
264: /* from okc_k_headers_b k */
265: from okc_k_headers_all_b k
266: --end bug # 4666846
267: where k.id = x;
268: k_rec k_cur%ROWTYPE;
269: /*nechatur 18-oct-2005 bug # 4666846 replacing okc_k_headers_b to okc_k_headers_all_b */

Line 269: /nechatur 18-oct-2005 bug # 4666846 replacing okc_k_headers_b to okc_k_headers_all_b /

265: from okc_k_headers_all_b k
266: --end bug # 4666846
267: where k.id = x;
268: k_rec k_cur%ROWTYPE;
269: /*nechatur 18-oct-2005 bug # 4666846 replacing okc_k_headers_b to okc_k_headers_all_b */
270: /* v_id okc_k_headers_b.id%TYPE;
271: x_knumber okc_k_headers_b.contract_number%TYPE; */
272: v_id okc_k_headers_all_b.id%TYPE;
273: x_knumber okc_k_headers_all_b.contract_number%TYPE;

Line 272: v_id okc_k_headers_all_b.id%TYPE;

268: k_rec k_cur%ROWTYPE;
269: /*nechatur 18-oct-2005 bug # 4666846 replacing okc_k_headers_b to okc_k_headers_all_b */
270: /* v_id okc_k_headers_b.id%TYPE;
271: x_knumber okc_k_headers_b.contract_number%TYPE; */
272: v_id okc_k_headers_all_b.id%TYPE;
273: x_knumber okc_k_headers_all_b.contract_number%TYPE;
274: --end bug # 4666846
275: BEGIN
276:

Line 273: x_knumber okc_k_headers_all_b.contract_number%TYPE;

269: /*nechatur 18-oct-2005 bug # 4666846 replacing okc_k_headers_b to okc_k_headers_all_b */
270: /* v_id okc_k_headers_b.id%TYPE;
271: x_knumber okc_k_headers_b.contract_number%TYPE; */
272: v_id okc_k_headers_all_b.id%TYPE;
273: x_knumber okc_k_headers_all_b.contract_number%TYPE;
274: --end bug # 4666846
275: BEGIN
276:
277: v_id := wf_notification.getattrnumber(p_notification_id,

Line 312: /nechatur 18-oct-2005 bug # 4666846 replacing okc_k_headers_b to okc_k_headers_all_b /

308: RETURN VARCHAR2 is
309: CURSOR k_cur(x in number)
310: IS
311: select k.contract_number_modifier
312: /*nechatur 18-oct-2005 bug # 4666846 replacing okc_k_headers_b to okc_k_headers_all_b */
313: /* from okc_k_headers_b k */
314: from okc_k_headers_all_b k
315: -- end bug # 4666846
316: where k.id = x;

Line 314: from okc_k_headers_all_b k

310: IS
311: select k.contract_number_modifier
312: /*nechatur 18-oct-2005 bug # 4666846 replacing okc_k_headers_b to okc_k_headers_all_b */
313: /* from okc_k_headers_b k */
314: from okc_k_headers_all_b k
315: -- end bug # 4666846
316: where k.id = x;
317: k_rec k_cur%ROWTYPE;
318: /*nechatur 18-oct-2005 bug # 4666846 replacing okc_k_headers_b to okc_k_headers_all_b */

Line 318: /nechatur 18-oct-2005 bug # 4666846 replacing okc_k_headers_b to okc_k_headers_all_b /

314: from okc_k_headers_all_b k
315: -- end bug # 4666846
316: where k.id = x;
317: k_rec k_cur%ROWTYPE;
318: /*nechatur 18-oct-2005 bug # 4666846 replacing okc_k_headers_b to okc_k_headers_all_b */
319: /* v_id okc_k_headers_b.id%TYPE;
320: x_knumber okc_k_headers_b.contract_number_modifier%TYPE; */
321: v_id okc_k_headers_all_b.id%TYPE;
322: x_knumber okc_k_headers_all_b.contract_number_modifier%TYPE;

Line 321: v_id okc_k_headers_all_b.id%TYPE;

317: k_rec k_cur%ROWTYPE;
318: /*nechatur 18-oct-2005 bug # 4666846 replacing okc_k_headers_b to okc_k_headers_all_b */
319: /* v_id okc_k_headers_b.id%TYPE;
320: x_knumber okc_k_headers_b.contract_number_modifier%TYPE; */
321: v_id okc_k_headers_all_b.id%TYPE;
322: x_knumber okc_k_headers_all_b.contract_number_modifier%TYPE;
323: -- end bug # 4666846
324: BEGIN
325:

Line 322: x_knumber okc_k_headers_all_b.contract_number_modifier%TYPE;

318: /*nechatur 18-oct-2005 bug # 4666846 replacing okc_k_headers_b to okc_k_headers_all_b */
319: /* v_id okc_k_headers_b.id%TYPE;
320: x_knumber okc_k_headers_b.contract_number_modifier%TYPE; */
321: v_id okc_k_headers_all_b.id%TYPE;
322: x_knumber okc_k_headers_all_b.contract_number_modifier%TYPE;
323: -- end bug # 4666846
324: BEGIN
325:
326: v_id := wf_notification.getattrnumber(p_notification_id,

Line 530: /* nechatur 18-oct-2005 bug # 4666846 replacing okc_k_headers_b to okc_k_headers_all_b */

526: /*
527: This function takes the resolved_timevalues ID as input and
528: returns the contract number.
529: */
530: /* nechatur 18-oct-2005 bug # 4666846 replacing okc_k_headers_b to okc_k_headers_all_b */
531: /* l_contract_number okc_k_headers_b.contract_number%TYPE;*/
532: l_contract_number okc_k_headers_all_b.contract_number%TYPE;
533: --end bug # 4666846
534:

Line 532: l_contract_number okc_k_headers_all_b.contract_number%TYPE;

528: returns the contract number.
529: */
530: /* nechatur 18-oct-2005 bug # 4666846 replacing okc_k_headers_b to okc_k_headers_all_b */
531: /* l_contract_number okc_k_headers_b.contract_number%TYPE;*/
532: l_contract_number okc_k_headers_all_b.contract_number%TYPE;
533: --end bug # 4666846
534:
535: CURSOR csr_k_no IS
536: SELECT k.contract_number

Line 539: /* nechatur 18-oct-2005 bug # 4666846 replacing okc_k_headers_b to okc_k_headers_all_b */

535: CURSOR csr_k_no IS
536: SELECT k.contract_number
537: FROM okc_resolved_timevalues_v rtv,
538: okc_timevalues tve,
539: /* nechatur 18-oct-2005 bug # 4666846 replacing okc_k_headers_b to okc_k_headers_all_b */
540: /* okc_k_headers_b k */
541: okc_k_headers_all_b k
542: -- end #4666846
543: WHERE rtv.tve_id = tve.id

Line 541: okc_k_headers_all_b k

537: FROM okc_resolved_timevalues_v rtv,
538: okc_timevalues tve,
539: /* nechatur 18-oct-2005 bug # 4666846 replacing okc_k_headers_b to okc_k_headers_all_b */
540: /* okc_k_headers_b k */
541: okc_k_headers_all_b k
542: -- end #4666846
543: WHERE rtv.tve_id = tve.id
544: AND tve.dnz_chr_id = k.id
545: AND rtv.id = p_rtv_id;