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 785: okl_txl_ar_inv_lns_b til,

781: FROM okc_k_headers_b khr
782: WHERE id IN (
783: SELECT CHR.id
784: FROM okl_txd_ar_ln_dtls_b tld,
785: okl_txl_ar_inv_lns_b til,
786: okl_trx_ar_invoices_b tai,
787: okl_strm_type_v sty,
788: okc_k_headers_b CHR
789: WHERE tai.trx_status_code = 'SUBMITTED'

Line 809: FROM okl_txl_ar_inv_lns_b til,

805: SELECT khr.contract_number contract_number, khr.id khr_id
806: FROM okc_k_headers_b khr
807: WHERE id IN (
808: SELECT CHR.id
809: FROM okl_txl_ar_inv_lns_b til,
810: okl_trx_ar_invoices_b tai,
811: okl_strm_type_v sty,
812: okc_k_headers_b CHR
813: WHERE tai.trx_status_code = 'SUBMITTED'

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

837: SELECT TAI.khr_id -- rmunjulu R12 fixes - changed to TAI
838: FROM --okl_ext_sell_invs_b xsi, -- rmunjulu R12 fixes - commented
839: --okl_xtl_sell_invs_b xls, -- rmunjulu R12 fixes - commented
840: --okl_txd_ar_ln_dtls_b tld,-- rmunjulu R12 fixes - commented
841: --okl_txl_ar_inv_lns_b til,-- rmunjulu R12 fixes - commented
842: okl_trx_ar_invoices_b tai,
843: okc_k_headers_b chr-- rmunjulu R12 fixes - commented
844: WHERE tai.TRX_STATUS_CODE = 'SUBMITTED' -- rmunjulu R12 fixes - changed to TAI + SUBMITTED
845: --AND XSI.ID = XLS.XSI_ID_DETAILS -- rmunjulu R12 fixes - commented

Line 867: okl_txl_ar_inv_lns_b til,

863: WHERE id in (
864: SELECT chr.id
865: FROM okl_ext_sell_invs_b xsi,
866: okl_xtl_sell_invs_b xls,
867: okl_txl_ar_inv_lns_b til,
868: okl_trx_ar_invoices_b tai,
869: okc_k_headers_b chr
870: WHERE XSI.TRX_STATUS_CODE = 'WORKING'
871: AND XSI.ID = XLS.XSI_ID_DETAILS

Line 964: OKL_TXL_AR_INV_LNS_B TIL,

960: CHR.CONTRACT_NUMBER CONTRACT_NUMBER,
961: COUNT(*) LINE_COUNT
962: FROM
963: OKL_TXD_AR_LN_DTLS_B TLD,
964: OKL_TXL_AR_INV_LNS_B TIL,
965: OKL_TRX_AR_INVOICES_B TAI,
966: OKC_K_HEADERS_B CHR,
967: OKL_STRM_TYPE_V STY,
968: OKL_PARALLEL_PROCESSES OPP

Line 985: OKL_TXL_AR_INV_LNS_B TIL,

981: SELECT
982: CHR.CONTRACT_NUMBER CONTRACT_NUMBER,
983: COUNT(*) LINE_COUNT
984: FROM
985: OKL_TXL_AR_INV_LNS_B TIL,
986: OKL_TRX_AR_INVOICES_B TAI,
987: OKC_K_HEADERS_B CHR,
988: OKL_STRM_TYPE_V STY,
989: OKL_PARALLEL_PROCESSES OPP

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

1012: FROM
1013: --OKL_EXT_SELL_INVS_B XSI, -- rmunjulu R12 fixes - commented
1014: --OKL_XTL_SELL_INVS_B XLS, -- rmunjulu R12 fixes - commented
1015: --OKL_TXD_AR_LN_DTLS_B TLD, -- rmunjulu R12 fixes - commented
1016: --OKL_TXL_AR_INV_LNS_B TIL, -- rmunjulu R12 fixes - commented
1017: OKL_TRX_AR_INVOICES_B TAI,
1018: OKC_K_HEADERS_B KHR,
1019: OKL_PARALLEL_PROCESSES OPP
1020: WHERE

Line 3786: okl_txl_ar_inv_lns_b til,

3782: okl_ext_sell_invs_b xsib,
3783: okl_ext_sell_invs_tl xsit,
3784: okl_xtl_sell_invs_b xls,
3785: okl_txd_ar_ln_dtls_b tld,
3786: okl_txl_ar_inv_lns_b til,
3787: okl_trx_ar_invoices_b tai,
3788: okc_k_headers_b chr,
3789: okl_invoice_formats_b inf, -- 5138822
3790: okl_parallel_processes pws

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: WHERE