APPS.OKL_FUNDING_PVT dependencies on OKC_K_LINES_B

Line 6194: okc_k_lines_b LN,

6190: p_vendor_site_id
6191: ) kle_amt
6192: FROM okl_assets_lov_uv a,
6193: okc_k_party_roles_b cpl,
6194: okc_k_lines_b LN,
6195: okx_vendor_sites_v sites
6196: WHERE a.chr_id = p_khr_id
6197: AND cpl.rle_code = 'OKL_VENDOR'
6198: AND cpl.chr_id IS NULL

Line 7097: okc_k_lines_b cle

7093: ) IS
7094: SELECT NVL(SUM(NVL(cle.price_unit, 0) * NVL(cim.number_of_items, 0)), 0)
7095: FROM okc_k_items cim,
7096: okc_k_party_roles_b cpl,
7097: okc_k_lines_b cle
7098: WHERE
7099: --for model lines of vendor
7100: (
7101: cim.cle_id = cle.ID

Line 7133: okc_k_lines_b cle

7129: IS
7130: SELECT NVL(SUM(NVL(cle.price_unit, 0) * NVL(cim.number_of_items, 0)), 0)
7131: FROM okc_k_items cim,
7132: okc_k_party_roles_b cpl,
7133: okc_k_lines_b cle
7134: WHERE
7135: --for add on lines: don't care the vendor association, but care if it has vendor association!
7136: (
7137: cim.cle_id = cle.ID

Line 7152: FROM okc_k_lines_b mdl_parent

7148: FROM okc_line_styles_b adon_lse
7149: WHERE adon_lse.ID = cle.lse_id AND adon_lse.lty_code = 'ADD_ITEM'
7150: -- ADD_ITEM has one parent ITEM only
7151: AND EXISTS(SELECT NULL
7152: FROM okc_k_lines_b mdl_parent
7153: WHERE mdl_parent.ID = cle.cle_id AND mdl_parent.cle_id = p_kle_id))
7154: ) -- end of add on lines
7155: -- re lease flag check
7156: AND EXISTS(SELECT NULL

Line 7171: okc_k_lines_b cle

7167: ) IS
7168: SELECT NVL(SUM(NVL(cle.price_unit, 0) * NVL(cim.number_of_items, 0)), 0)
7169: FROM okc_k_items cim,
7170: okc_k_party_roles_b cpl,
7171: okc_k_lines_b cle
7172: WHERE
7173: --for model lines of vendor
7174: (
7175: cim.cle_id = cle.ID

Line 7203: FROM okc_k_lines_b mdl_parent

7199: FROM okc_line_styles_b adon_lse
7200: WHERE adon_lse.ID = cle.lse_id AND adon_lse.lty_code = 'ADD_ITEM'
7201: -- ADD_ITEM has one parent ITEM only
7202: AND EXISTS(SELECT NULL
7203: FROM okc_k_lines_b mdl_parent
7204: WHERE mdl_parent.ID = cle.cle_id AND mdl_parent.cle_id = p_kle_id))
7205: ) -- end of add on lines
7206: -- re lease flag check
7207: AND EXISTS(SELECT NULL

Line 7221: okc_k_lines_b cle

7217: ) IS
7218: SELECT NVL(SUM(NVL(cle.price_unit, 0) * NVL(cim.number_of_items, 0)), 0)
7219: FROM okc_k_items cim,
7220: okc_k_party_roles_b cpl,
7221: okc_k_lines_b cle
7222: WHERE (
7223: cim.cle_id = cle.ID
7224: AND cim.dnz_chr_id = p_khr_id
7225: AND cpl.cle_id = cle.ID

Line 7246: FROM okc_k_lines_b mdl_parent

7242: FROM okc_line_styles_b adon_lse
7243: WHERE adon_lse.ID = cle.lse_id
7244: AND adon_lse.lty_code = 'ADD_ITEM'
7245: AND EXISTS(SELECT NULL
7246: FROM okc_k_lines_b mdl_parent
7247: WHERE mdl_parent.ID = cle.cle_id))
7248: )
7249: AND EXISTS(SELECT NULL
7250: FROM okl_k_lines lkl

Line 7285: okc_k_lines_b kle

7281: ) IS
7282: SELECT kle_k.id kle_id,
7283: kle_k.down_payment_receiver_code downpymnt_recvr
7284: FROM okl_k_lines kle_k,
7285: okc_k_lines_b kle
7286: where kle_k.id = kle.id
7287: and kle.dnz_chr_id = p_khr_id
7288: and kle_k.re_lease_yn IS NULL -- re lease flag check
7289: -- only asset lines associated with Lease Vendor (Supplier Invoice)

Line 7293: okc_k_lines_b cle,

7289: -- only asset lines associated with Lease Vendor (Supplier Invoice)
7290: and exists (
7291: SELECT 1
7292: FROM okc_k_party_roles_b cpl,
7293: okc_k_lines_b cle,
7294: okc_line_styles_b model_lse
7295: WHERE cpl.rle_code = 'OKL_VENDOR'
7296: AND cpl.chr_id IS NULL
7297: and model_lse.ID = cle.lse_id