DBA Data[Home] [Help]

APPS.OKL_CNTRCT_FIN_EXTRACT_PVT dependencies on OKL_STRM_TYPE_B

Line 817: okl_strm_type_b sty

813: NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_amount_prefunded(chr.id, null),0) CONTRACT_PREFUNDED_AMOUNT,
814: -- null CONTRACT_BILLED_RENTS,
815: (select SUM(NVL(txd.amount,0))
816: from OKL_TXD_AR_LN_DTLS_B txd,
817: okl_strm_type_b sty
818: where txd.khr_id = khr.id
819: and txd.sty_id = sty.id
820: and sty.STREAM_TYPE_PURPOSE = 'RENT') CONTRACT_BILLED_RENTS,
821:

Line 1850: okl_strm_type_b sty

1846: NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_amount_prefunded(chr.id, null),0) CONTRACT_PREFUNDED_AMOUNT,
1847: -- null CONTRACT_BILLED_RENTS,
1848: (select SUM(NVL(txd.amount,0))
1849: from OKL_TXD_AR_LN_DTLS_B txd,
1850: okl_strm_type_b sty
1851: where txd.khr_id = khr.id
1852: and txd.sty_id = sty.id
1853: and sty.STREAM_TYPE_PURPOSE = 'RENT') CONTRACT_BILLED_RENTS,
1854: