[Home] [Help]
1309: Cursor salesP_csr( p_chr_id NUMBER) IS
1310: select ct.object1_id1
1311: from okc_contacts ct,
1312: okc_contact_sources csrc,
1313: okc_k_party_roles_b pty,
1314: okc_k_headers_b chr
1315: where ct.cpl_id = pty.id
1316: and ct.cro_code = csrc.cro_code
1317: and ct.jtot_object1_code = csrc.jtot_object_code
2333: select nvl(cle.AMOUNT,0),
2334: cle.id,
2335: nvl(cle.start_date,k.start_date)
2336: from OKL_K_LINES_FULL_V cle,
2337: okc_k_party_roles_b cpl,
2338: okc_line_styles_b ls,
2339: okc_k_headers_b k
2340: where k.id = cle.dnz_chr_id
2341: and cle.dnz_chr_id = p_contract_id
2612: select nvl(cle.AMOUNT,0),
2613: cle.id,
2614: nvl(cle.start_date,k.start_date)
2615: from OKL_K_LINES_FULL_V cle,
2616: okc_k_party_roles_b cpl,
2617: okc_line_styles_b ls,
2618: okc_k_headers_b k
2619: where k.id = cle.dnz_chr_id
2620: and cle.dnz_chr_id = p_contract_id
6346: a.cle_id,
6347: p_vendor_site_id
6348: ) kle_amt
6349: FROM okl_assets_lov_uv a,
6350: okc_k_party_roles_b cpl,
6351: okc_k_lines_b LN,
6352: okx_vendor_sites_v sites
6353: WHERE a.chr_id = p_khr_id
6354: AND cpl.rle_code = 'OKL_VENDOR'
7249: p_vendor_id NUMBER
7250: ) IS
7251: SELECT NVL(SUM(NVL(cle.price_unit, 0) * NVL(cim.number_of_items, 0)), 0)
7252: FROM okc_k_items cim,
7253: okc_k_party_roles_b cpl,
7254: okc_k_lines_b cle,
7255: --Bug# 15992711 : avsingh - New-Re-leased Asset Enhancement
7256: okl_k_lines kle_top
7257: --End Bug# Bug# 15992711 : New Re-leased Asset Enhancement
7297: -- end: okl.h: cklee -- add vendor_id as a parameter
7298: IS
7299: SELECT NVL(SUM(NVL(cle.price_unit, 0) * NVL(cim.number_of_items, 0)), 0)
7300: FROM okc_k_items cim,
7301: okc_k_party_roles_b cpl,
7302: okc_k_lines_b cle,
7303: --Bug# 15992711 : avsingh - New-Re-leased Asset Enhancement
7304: okl_k_lines kle_top
7305: --End Bug# Bug# 15992711 : New Re-leased Asset Enhancement
7345: p_kle_id NUMBER
7346: ) IS
7347: SELECT NVL(SUM(NVL(cle.price_unit, 0) * NVL(cim.number_of_items, 0)), 0)
7348: FROM okc_k_items cim,
7349: okc_k_party_roles_b cpl,
7350: okc_k_lines_b cle,
7351: --Bug# 15992711 : avsingh - New-Re-leased Asset Enhancement
7352: okl_k_lines kle_top
7353: --End Bug# Bug# 15992711 : New Re-leased Asset Enhancement
7412: p_khr_id NUMBER
7413: ) IS
7414: SELECT NVL(SUM(NVL(cle.price_unit, 0) * NVL(cim.number_of_items, 0)), 0)
7415: FROM okc_k_items cim,
7416: okc_k_party_roles_b cpl,
7417: okc_k_lines_b cle,
7418: --Bug# 15992711 : avsingh - New-Released asset ER
7419: okl_k_lines kle_top
7420: --End Bug# 15992711 : New-Released asset ER
7505: AND kle.sts_code <> 'ABANDONED'
7506: -- only asset lines associated with Lease Vendor (Supplier Invoice)
7507: and exists (
7508: SELECT 1
7509: FROM okc_k_party_roles_b cpl,
7510: okc_k_lines_b cle,
7511: okc_line_styles_b model_lse
7512: WHERE cpl.rle_code = 'OKL_VENDOR'
7513: AND cpl.chr_id IS NULL
8688: select nvl(cle.AMOUNT,0),
8689: cle.id,
8690: nvl(cle.start_date,k.start_date)
8691: from OKL_K_LINES_FULL_V cle,
8692: okc_k_party_roles_b cpl,
8693: okc_line_styles_b ls,
8694: okc_k_headers_b k
8695: where k.id = cle.dnz_chr_id
8696: and cle.dnz_chr_id = p_contract_id
9402: p_khr_id NUMBER
9403: ) IS
9404: SELECT NVL(SUM(NVL(cle.price_unit, 0) * NVL(cim.number_of_items, 0)), 0)
9405: FROM okc_k_items cim,
9406: okc_k_party_roles_b cpl,
9407: okc_k_lines_b cle,
9408: --Bug# 15992711 : avsingh - New-Released asset ER
9409: okl_k_lines kle_top
9410: --End Bug# 15992711 : New-Released asset ER
9477: AND kle.sts_code <> 'ABANDONED';
9478: -- only asset lines associated with Lease Vendor (Supplier Invoice)
9479: --and exists (
9480: --SELECT 1
9481: --FROM okc_k_party_roles_b cpl,
9482: --okc_k_lines_b cle,
9483: --okc_line_styles_b model_lse
9484: --WHERE cpl.rle_code = 'OKL_VENDOR'
9485: --AND cpl.chr_id IS NULL