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 OKC_K_HEADERS_B

Line 33: okc_k_headers_b khr,

29: SELECT MIN(ste.stream_element_date)
30: FROM OKL_STRM_ELEMENTS ste,
31: OKL_STREAMS stm,
32: okl_strm_type_v sty,
33: okc_k_headers_b khr,
34: OKL_K_HEADERS khl,
35: okc_k_lines_b kle,
36: okc_statuses_b khs,
37: okc_statuses_b kls

Line 756: FROM okc_k_headers_b khr, -- rmunjulu R12 Forward Port missing on R12 (oklh bug 4728636)

752:
753: cursor chk_update_header_csr ( p_date date, orgId VARCHAr2 ) is -- rmunjulu R12 Forward Port missing on R12 (oklh bug 4728636)
754: -- -- bug# 5872306 (ssiruvol)
755: SELECT khr.contract_number contract_number, khr.id khr_id
756: FROM okc_k_headers_b khr, -- rmunjulu R12 Forward Port missing on R12 (oklh bug 4728636)
757: okl_k_control nbd -- rmunjulu R12 Forward Port missing on R12 (oklh bug 4728636)
758: WHERE ((p_contract_number is not null and KHR.CONTRACT_NUMBER=p_contract_number)
759: or (p_contract_number is null and KHR.CONTRACT_NUMBER=KHR.CONTRACT_NUMBER))
760: AND ((p_cust_acct_id is not null and KHR.CUST_ACCT_ID=p_cust_acct_id)

Line 781: FROM okc_k_headers_b khr

777: -- rmunjulu R12 fixes - comment out Prepare Recvbles
778: /* UNION
779: --3 levels
780: SELECT khr.contract_number contract_number, khr.id khr_id
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,

Line 788: okc_k_headers_b CHR

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'
790: AND tai.khr_id = CHR.id
791: AND til.tai_id = tai.id
792: AND tld.til_id_details = til.id

Line 806: FROM okc_k_headers_b khr

802:
803: UNION
804: -- 2 levels
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,

Line 812: okc_k_headers_b CHR

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'
814: AND tai.khr_id = CHR.id
815: AND til.tai_id = tai.id
816: AND til.sty_id = sty.id

Line 835: FROM okc_k_headers_b khr

831: */
832: -- rmunjulu R12 Fixes modify AR Transfer
833: UNION
834: SELECT khr.contract_number contract_number, khr.id khr_id
835: FROM okc_k_headers_b khr
836: WHERE id in (
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

Line 843: okc_k_headers_b chr-- 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
846: --AND xls.tld_id = tld.id -- rmunjulu R12 fixes - commented
847: --and tld.til_id_details = til.id -- rmunjulu R12 fixes - commented

Line 862: FROM okc_k_headers_b khr

858: -- rmunjulu R12 Fixes -- below select not needed as will be same as above select
859: /*
860: UNION
861: SELECT khr.contract_number contract_number, khr.id khr_id
862: FROM okc_k_headers_b khr
863: WHERE id in (
864: SELECT chr.id
865: FROM okl_ext_sell_invs_b xsi,
866: okl_xtl_sell_invs_b xls,

Line 869: okc_k_headers_b chr

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
872: AND xls.til_id = til.id
873: and til.tai_id = tai.id

Line 901: FROM okc_k_headers_b khr,

897: */
898: -- modified by zrehman for Bug#6788005 on 01-Feb-2008 start
899: UNION
900: SELECT khr.contract_number contract_number, khr.id khr_id
901: FROM okc_k_headers_b khr,
902: okl_k_control nbd,
903: okc_k_lines_b cle
904: WHERE ((p_contract_number is not null and KHR.CONTRACT_NUMBER=p_contract_number)
905: or (p_contract_number is null and KHR.CONTRACT_NUMBER=KHR.CONTRACT_NUMBER))

Line 966: OKC_K_HEADERS_B CHR,

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
969: WHERE tai.trx_status_code = 'SUBMITTED'
970: AND tai.khr_id = CHR.id

Line 987: OKC_K_HEADERS_B CHR,

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
990: WHERE tai.trx_status_code = 'SUBMITTED'
991: AND tai.khr_id = CHR.id

Line 1018: OKC_K_HEADERS_B KHR,

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
1021: TAI.TRX_STATUS_CODE = 'SUBMITTED' AND -- rmunjulu R12 fixes - changed to TAI and SUBMITTED
1022: --XSI.ID = XLS.XSI_ID_DETAILS AND -- rmunjulu R12 fixes - commented

Line 1043: OKC_K_HEADERS_B KHR,

1039: OKL_EXT_SELL_INVS_V XSI,
1040: OKL_XTL_SELL_INVS_V XLS,
1041: OKL_TXL_AR_INV_LNS_V TIL,
1042: OKL_TRX_AR_INVOICES_V TAI,
1043: OKC_K_HEADERS_B KHR,
1044: OKL_PARALLEL_PROCESSES OPP
1045: WHERE
1046: XSI.TRX_STATUS_CODE = 'WORKING' AND
1047: XSI.ID = XLS.XSI_ID_DETAILS AND

Line 3084: FROM OKC_K_HEADERS_B CHR,

3080: WHERE id = p_cle_id;
3081:
3082: CURSOR derive_top_line_id (p_lsm_id NUMBER) IS
3083: SELECT FA.ID
3084: FROM OKC_K_HEADERS_B CHR,
3085: OKC_K_LINES_B TOP_CLE,
3086: OKC_LINE_STYLES_b TOP_LSE,
3087: OKC_K_LINES_B SUB_CLE,
3088: OKC_LINE_STYLES_b SUB_LSE,

Line 3788: okc_k_headers_b chr,

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
3791: WHERE
3792: xsiB.TRX_STATUS_CODE = 'SUBMITTED' AND

Line 3852: okc_k_headers_b chr,

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
3855: xsib.TRX_STATUS_CODE = 'SUBMITTED' AND
3856: xls.xsi_id_details = xsib.id AND

Line 3916: okc_k_headers_b chr,

3912: okl_ext_sell_invs_v xsi,
3913: okl_xtl_sell_invs_v xls,
3914: okl_txl_ar_inv_lns_v til,
3915: okl_trx_ar_invoices_v tai,
3916: okc_k_headers_b chr,
3917: okl_invoice_formats_b inf, -- 5138822
3918: okl_parallel_processes pws
3919: WHERE
3920: xsi.TRX_STATUS_CODE = 'SUBMITTED' AND

Line 4049: FROM okc_k_headers_b

4045: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
4046:
4047: CURSOR cntrct_csr ( p_id NUMBER ) IS
4048: SELECT contract_number
4049: FROM okc_k_headers_b
4050: WHERE id = p_id;
4051:
4052: CURSOR strm_csr ( p_id NUMBER ) IS
4053: SELECT name

Line 4057: l_contract_number okc_k_headers_b.contract_number%TYPE;

4053: SELECT name
4054: FROM okl_strm_type_v
4055: WHERE id = p_id;
4056:
4057: l_contract_number okc_k_headers_b.contract_number%TYPE;
4058: l_stream_name1 okl_strm_type_v.name%TYPE;
4059:
4060:
4061: l_temp_khr_id NUMBER;