APPS.OKL_BILLING_CONTROLLER_PVT dependencies on OKL_TXD_AR_LN_DTLS_B

Line 796: FROM okl_txd_ar_ln_dtls_b tld,

792: SELECT khr.contract_number contract_number, khr.id khr_id
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

Line 832: FROM okl_txd_ar_ln_dtls_b tld

828: AND til.sty_id = sty.id
829: AND p_source = 'AR_PREPARE'
830: AND NOT EXISTS
831: (SELECT *
832: FROM okl_txd_ar_ln_dtls_b tld
833: WHERE tld.til_id_details = til.id
834: )
835: AND NOT EXISTS
836: (SELECT '1'

Line 852: --okl_txd_ar_ln_dtls_b tld,-- rmunjulu R12 fixes - commented

848: WHERE id in (
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

Line 1000: OKL_TXD_AR_LN_DTLS_B TLD,

996: SELECT
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,

Line 1037: FROM okl_txd_ar_ln_dtls_b tld

1033: AND OPP.OBJECT_TYPE = 'PREP_CONTRACT'
1034: AND p_source = 'AR_PREPARE'
1035: AND NOT EXISTS
1036: (SELECT *
1037: FROM okl_txd_ar_ln_dtls_b tld
1038: WHERE tld.til_id_details = til.id
1039: )
1040: GROUP BY CHR.CONTRACT_NUMBER
1041: --fmiao 5209209 end

Line 1052: --OKL_TXD_AR_LN_DTLS_B TLD, -- rmunjulu R12 fixes - commented

1048: COUNT(*) LINE_COUNT
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

Line 3849: okl_txd_ar_ln_dtls_b tld,

3845: FROM
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

Line 3913: okl_txd_ar_ln_dtls_b tld,

3909: FROM
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