APPS.OKL_CS_LC_CONTRACT_PVT dependencies on OKC_K_HEADERS_ALL_B

Line 342: where a.interface_line_attribute6=(select contract_number from okc_k_headers_all_b where id=p_contract_id)

338: (
339: select 'x' --distinct b.customer_trx_id
340: --select distinct b.customer_trx_id
341: from ra_customer_trx_all b, ra_customer_trx_lines_all a
342: where a.interface_line_attribute6=(select contract_number from okc_k_headers_all_b where id=p_contract_id)
343: and a.customer_trx_id=b.customer_trx_id
344: and a.customer_trx_id = app.customer_trx_id
345: )
346: ORDER BY receipt_date DESC;