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_TRX_AR_INVOICES_B

Line 798: okl_trx_ar_invoices_b tai,

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'
802: AND tai.khr_id = CHR.id

Line 822: okl_trx_ar_invoices_b tai,

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'
826: AND tai.khr_id = CHR.id

Line 854: okl_trx_ar_invoices_b 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
858: --AND xls.tld_id = tld.id -- rmunjulu R12 fixes - commented

Line 880: okl_trx_ar_invoices_b tai,

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
884: AND xls.til_id = til.id

Line 1002: OKL_TRX_AR_INVOICES_B TAI,

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
1006: WHERE tai.trx_status_code = 'SUBMITTED'

Line 1023: OKL_TRX_AR_INVOICES_B TAI,

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
1027: WHERE tai.trx_status_code = 'SUBMITTED'

Line 1054: OKL_TRX_AR_INVOICES_B TAI,

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
1058: TAI.TRX_STATUS_CODE = 'SUBMITTED' AND -- rmunjulu R12 fixes - changed to TAI and SUBMITTED

Line 3851: okl_trx_ar_invoices_b tai,

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

Line 3915: okl_trx_ar_invoices_b tai,

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
3919: xsib.TRX_STATUS_CODE = 'SUBMITTED' AND