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_BILLING_CONTROLLER_PVT dependencies on OKL_TXL_AR_INV_LNS_B

Line 797: okl_txl_ar_inv_lns_b til,

793: FROM okc_k_headers_b khr
794: WHERE id IN (
795: SELECT CHR.id
796: FROM okl_txd_ar_ln_dtls_b tld,
797: okl_txl_ar_inv_lns_b til,
798: okl_trx_ar_invoices_b tai,
799: okl_strm_type_v sty,
800: okc_k_headers_b CHR
801: WHERE tai.trx_status_code = 'SUBMITTED'

Line 821: FROM okl_txl_ar_inv_lns_b til,

817: SELECT khr.contract_number contract_number, khr.id khr_id
818: FROM okc_k_headers_b khr
819: WHERE id IN (
820: SELECT CHR.id
821: FROM okl_txl_ar_inv_lns_b til,
822: okl_trx_ar_invoices_b tai,
823: okl_strm_type_v sty,
824: okc_k_headers_b CHR
825: WHERE tai.trx_status_code = 'SUBMITTED'

Line 853: --okl_txl_ar_inv_lns_b til,-- rmunjulu R12 fixes - commented

849: SELECT TAI.khr_id -- rmunjulu R12 fixes - changed to TAI
850: FROM --okl_ext_sell_invs_b xsi, -- rmunjulu R12 fixes - commented
851: --okl_xtl_sell_invs_b xls, -- rmunjulu R12 fixes - commented
852: --okl_txd_ar_ln_dtls_b tld,-- rmunjulu R12 fixes - commented
853: --okl_txl_ar_inv_lns_b til,-- rmunjulu R12 fixes - commented
854: okl_trx_ar_invoices_b tai,
855: okc_k_headers_b chr-- rmunjulu R12 fixes - commented
856: WHERE tai.TRX_STATUS_CODE = 'SUBMITTED' -- rmunjulu R12 fixes - changed to TAI + SUBMITTED
857: --AND XSI.ID = XLS.XSI_ID_DETAILS -- rmunjulu R12 fixes - commented

Line 879: okl_txl_ar_inv_lns_b til,

875: WHERE id in (
876: SELECT chr.id
877: FROM okl_ext_sell_invs_b xsi,
878: okl_xtl_sell_invs_b xls,
879: okl_txl_ar_inv_lns_b til,
880: okl_trx_ar_invoices_b tai,
881: okc_k_headers_b chr
882: WHERE XSI.TRX_STATUS_CODE = 'WORKING'
883: AND XSI.ID = XLS.XSI_ID_DETAILS

Line 1001: OKL_TXL_AR_INV_LNS_B TIL,

997: CHR.CONTRACT_NUMBER CONTRACT_NUMBER,
998: COUNT(*) LINE_COUNT
999: FROM
1000: OKL_TXD_AR_LN_DTLS_B TLD,
1001: OKL_TXL_AR_INV_LNS_B TIL,
1002: OKL_TRX_AR_INVOICES_B TAI,
1003: OKC_K_HEADERS_B CHR,
1004: OKL_STRM_TYPE_V STY,
1005: OKL_PARALLEL_PROCESSES OPP

Line 1022: OKL_TXL_AR_INV_LNS_B TIL,

1018: SELECT
1019: CHR.CONTRACT_NUMBER CONTRACT_NUMBER,
1020: COUNT(*) LINE_COUNT
1021: FROM
1022: OKL_TXL_AR_INV_LNS_B TIL,
1023: OKL_TRX_AR_INVOICES_B TAI,
1024: OKC_K_HEADERS_B CHR,
1025: OKL_STRM_TYPE_V STY,
1026: OKL_PARALLEL_PROCESSES OPP

Line 1053: --OKL_TXL_AR_INV_LNS_B TIL, -- rmunjulu R12 fixes - commented

1049: FROM
1050: --OKL_EXT_SELL_INVS_B XSI, -- rmunjulu R12 fixes - commented
1051: --OKL_XTL_SELL_INVS_B XLS, -- rmunjulu R12 fixes - commented
1052: --OKL_TXD_AR_LN_DTLS_B TLD, -- rmunjulu R12 fixes - commented
1053: --OKL_TXL_AR_INV_LNS_B TIL, -- rmunjulu R12 fixes - commented
1054: OKL_TRX_AR_INVOICES_B TAI,
1055: OKC_K_HEADERS_B KHR,
1056: OKL_PARALLEL_PROCESSES OPP
1057: WHERE

Line 3850: okl_txl_ar_inv_lns_b til,

3846: okl_ext_sell_invs_b xsib,
3847: okl_ext_sell_invs_tl xsit,
3848: okl_xtl_sell_invs_b xls,
3849: okl_txd_ar_ln_dtls_b tld,
3850: okl_txl_ar_inv_lns_b til,
3851: okl_trx_ar_invoices_b tai,
3852: okc_k_headers_b chr,
3853: okl_invoice_formats_b inf, -- 5138822
3854: okl_parallel_processes pws

Line 3914: okl_txl_ar_inv_lns_b til,

3910: okl_ext_sell_invs_b xsib,
3911: okl_ext_sell_invs_tl xsit,
3912: okl_xtl_sell_invs_b xls,
3913: okl_txd_ar_ln_dtls_b tld,
3914: okl_txl_ar_inv_lns_b til,
3915: okl_trx_ar_invoices_b tai,
3916: okc_k_headers_b chr,
3917: okl_invoice_formats_b inf -- 5138822
3918: WHERE