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_ITEMS

Line 7095: FROM okc_k_items cim,

7091: p_kle_id NUMBER,
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

Line 7131: FROM okc_k_items cim,

7127: )
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!

Line 7169: FROM okc_k_items cim,

7165: p_khr_id NUMBER,
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

Line 7219: FROM okc_k_items cim,

7215: CURSOR c_no_line_and_vendor(
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