DBA Data[Home] [Help]

APPS.OKL_AM_CALC_QUOTE_STREAM_PVT dependencies on OKC_K_HEADERS_ALL_B

Line 793: , OKC_K_HEADERS_all_B CHR

789: SELECT l.contract_line_id contract_line_id,
790: l.stream_type_id stream_type_id,
791: SUM (l.amount_due_remaining) amount_due
792: FROM okl_bpd_ar_inv_lines_v l
793: , OKC_K_HEADERS_all_B CHR
794: ,okc_k_lines_b cle
795: WHERE l.contract_id = cp_chr_id
796: and l.contract_line_id = cle.id(+)
797: and ( cle.sts_code not in ('EXPIRED','TERMINATED','CANCELLED')