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 OKS_K_LINES_B

Line 486: ,OKS_K_LINES_B KSLINES

482: (NVL(OKS_BILLED_LINES.BILLED_AMOUNT,0) + NVL(OM_ORIGINATED_BILLED_LINES.BILLED_AMOUNT,0)) unbilled_amount
483:
484: FROM
485: OKC_K_LINES_B KLINES
486: ,OKS_K_LINES_B KSLINES
487:
488: ,
489: (
490: SELECT

Line 553: ,OKS_K_LINES_B KSLINES

549: (NVL(OKS_BILLED_LINES.BILLED_AMOUNT,0) + NVL(OM_ORIGINATED_BILLED_LINES.BILLED_AMOUNT,0)) unbilled_amount
550:
551: FROM
552: OKC_K_LINES_B KLINES
553: ,OKS_K_LINES_B KSLINES
554: ,
555: (
556: SELECT
557: NVL(SUM(btl.trx_amount), 0) BILLED_AMOUNT

Line 672: ,OKS_K_LINES_B KSLINES

668: NVL(KSLINES.SUPPRESSED_CREDIT, 0)
669: )
670: FROM
671: OKC_K_LINES_B KLINES
672: ,OKS_K_LINES_B KSLINES
673: WHERE
674: KLINES.CHR_ID = P_CHR_ID
675: AND KLINES.ID = KSLINES.CLE_ID
676: AND (KSLINES.USAGE_TYPE IS NULL OR KSLINES.USAGE_TYPE = 'NPR')

Line 684: ,OKS_K_LINES_B KSLINES

680: ( SELECT
681: NVL(SUM(BTL.TRX_AMOUNT),0) BILLED_AMOUNT
682: FROM
683: OKC_K_LINES_B LINE
684: ,OKS_K_LINES_B KSLINES
685: ,OKS_BILL_TRANSACTIONS BTR
686: ,OKS_BILL_TXN_LINES BTL
687: ,OKS_BILL_CONT_LINES BCL
688: WHERE