eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_FUNDING_PVT dependencies on OKC_K_PARTY_ROLES_B

Line 1313: okc_k_party_roles_b pty,

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

Line 2310: okc_k_party_roles_b cpl,

2306: select nvl(cle.AMOUNT,0),
2307: cle.id,
2308: nvl(cle.start_date,k.start_date)
2309: from OKL_K_LINES_FULL_V cle,
2310: okc_k_party_roles_b cpl,
2311: okc_line_styles_b ls,
2312: okc_k_headers_b k
2313: where k.id = cle.dnz_chr_id
2314: and cle.dnz_chr_id = p_contract_id

Line 2548: okc_k_party_roles_b cpl,

2544: select nvl(cle.AMOUNT,0),
2545: cle.id,
2546: nvl(cle.start_date,k.start_date)
2547: from OKL_K_LINES_FULL_V cle,
2548: okc_k_party_roles_b cpl,
2549: okc_line_styles_b ls,
2550: okc_k_headers_b k
2551: where k.id = cle.dnz_chr_id
2552: and cle.dnz_chr_id = p_contract_id

Line 6193: okc_k_party_roles_b cpl,

6189: a.cle_id,
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'

Line 7096: okc_k_party_roles_b cpl,

7092: p_vendor_id NUMBER
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: (

Line 7132: okc_k_party_roles_b cpl,

7128: -- end: okl.h: cklee -- add vendor_id as a parameter
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: (

Line 7170: okc_k_party_roles_b cpl,

7166: p_kle_id NUMBER
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: (

Line 7220: okc_k_party_roles_b cpl,

7216: p_khr_id NUMBER
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

Line 7292: FROM okc_k_party_roles_b cpl,

7288: and kle_k.re_lease_yn IS NULL -- re lease flag check
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

Line 8475: okc_k_party_roles_b cpl,

8471: select nvl(cle.AMOUNT,0),
8472: cle.id,
8473: nvl(cle.start_date,k.start_date)
8474: from OKL_K_LINES_FULL_V cle,
8475: okc_k_party_roles_b cpl,
8476: okc_line_styles_b ls,
8477: okc_k_headers_b k
8478: where k.id = cle.dnz_chr_id
8479: and cle.dnz_chr_id = p_contract_id