APPS.OKL_BILLING_CONTROLLER_PVT dependencies on OKL_TXD_AR_LN_DTLS_B

Line 784: FROM okl_txd_ar_ln_dtls_b tld,

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,
786: okl_trx_ar_invoices_b tai,
787: okl_strm_type_v sty,
788: okc_k_headers_b CHR

Line 820: FROM okl_txd_ar_ln_dtls_b tld

816: AND til.sty_id = sty.id
817: AND p_source = 'AR_PREPARE'
818: AND NOT EXISTS
819: (SELECT *
820: FROM okl_txd_ar_ln_dtls_b tld
821: WHERE tld.til_id_details = til.id
822: )
823: AND NOT EXISTS
824: (SELECT '1'

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

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

Line 963: OKL_TXD_AR_LN_DTLS_B TLD,

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

Line 1000: FROM okl_txd_ar_ln_dtls_b tld

996: AND OPP.OBJECT_TYPE = 'PREP_CONTRACT'
997: AND p_source = 'AR_PREPARE'
998: AND NOT EXISTS
999: (SELECT *
1000: FROM okl_txd_ar_ln_dtls_b tld
1001: WHERE tld.til_id_details = til.id
1002: )
1003: GROUP BY CHR.CONTRACT_NUMBER
1004: --fmiao 5209209 end

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

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

Line 3785: okl_txd_ar_ln_dtls_b tld,

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

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