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.OKS_MISC_UTIL_WEB dependencies on OKC_K_REL_OBJS

Line 329: from okc_k_rel_objs rel,

325: select /*+ no_merge */ distinct rel.object1_id1, subline.cle_id id,
326: bcl.bill_action,
327: bcl.date_billed_from bill_from_date,
328: bcl.date_billed_to bill_to_date
329: from okc_k_rel_objs rel,
330: okc_k_lines_b subline,
331: oks_bill_cont_lines bcl
332: where subline.cle_id = l_line_id
333: and subline.lse_id in (9,18,25)

Line 387: okc_k_rel_objs rel,

383: ral.customer_trx_id,
384: rank() over (partition by ral.customer_trx_line_id order by ratax.customer_trx_line_id) r
385: from
386: okc_k_lines_b subline,
387: okc_k_rel_objs rel,
388: oe_order_lines_all oel,
389: oe_order_headers_all oe,
390: ra_customer_trx_lines_all ral,
391: ra_customer_trx_all ra,

Line 511: from okc_k_rel_objs rel,

507: (
508: select NVL(SUM(ral.extended_amount), 0) BILLED_AMOUNT
509: from (
510: select /*+ no_merge */ distinct rel.object1_id1
511: from okc_k_rel_objs rel,
512: okc_k_lines_b subline,
513: oks_bill_cont_lines bcl
514: where subline.cle_id = l_line_id
515: and subline.lse_id in (9,18,25)

Line 581: ,okc_k_rel_objs rel

577: ra_customer_trx_lines_all ral
578: ,oks_bill_cont_lines bcl
579: ,oe_order_headers_all oe
580: ,oe_order_lines_all oel
581: ,okc_k_rel_objs rel
582: ,okc_k_lines_b subline
583: WHERE
584: subline.id = l_line_id
585: AND subline.lse_id in (9,18,25)

Line 705: FROM OKC_K_REL_OBJS REL,

701: SELECT
702: NVL(SUM(RAL.EXTENDED_AMOUNT), 0) BILLED_AMOUNT
703: FROM (
704: SELECT /*+ NO_MERGE */ DISTINCT REL.OBJECT1_ID1, SUBLINE.CHR_ID
705: FROM OKC_K_REL_OBJS REL,
706: OKC_K_LINES_B SUBLINE,
707: OKS_BILL_CONT_LINES BCL
708: WHERE
709: SUBLINE.DNZ_CHR_ID = P_CHR_ID

Line 816: FROM OKC_K_REL_OBJS REL,

812: SUBLINE.DNZ_CHR_ID CHR_ID,
813: BCL.BILL_ACTION,
814: BCL.DATE_BILLED_FROM BILL_FROM_DATE,
815: BCL.DATE_BILLED_TO BILL_TO_DATE
816: FROM OKC_K_REL_OBJS REL,
817: OKC_K_LINES_B SUBLINE,
818: OKS_BILL_CONT_LINES BCL
819: WHERE
820: SUBLINE.DNZ_CHR_ID = P_CHR_ID

Line 1170: FROM okc_k_rel_objs rel

1166: ,oe_order_lines_all oel
1167: ,oe_order_lines_all oel1
1168: ,(SELECT rel.object1_id1,
1169: rel.cle_id
1170: FROM okc_k_rel_objs rel
1171: WHERE rel.cle_id = l_line_id
1172: AND rel.jtot_object1_code = 'OKX_ORDERLINE' ) x
1173: WHERE itm.cle_id = x.cle_id
1174: AND itm.object1_id1 = csi.instance_id