DBA Data[Home] [Help]

APPS.OKL_VERSION_PVT dependencies on OKC_K_ITEMS_V

Line 75: okc_k_items_v cim,

71: cim.object1_id2
72: FROM okc_subclass_top_line stl,
73: okc_line_styles_b lse2,
74: okc_line_styles_b lse1,
75: okc_k_items_v cim,
76: okc_k_lines_v cle
77: WHERE cle.dnz_chr_id = p_dnz_chr_id
78: AND cle.id = cim.cle_id
79: AND cim.dnz_chr_id = cle.dnz_chr_id

Line 87: CURSOR c_asset_info(p_object1_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE,

83: AND lse2.lty_code = G_FIN_LINE_LTY_CODE
84: AND lse2.id = stl.lse_id
85: AND stl.scs_code in (G_LEASE_SCS_CODE,G_LOAN_SCS_CODE);
86:
87: CURSOR c_asset_info(p_object1_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE,
88: p_object1_id2 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE)
89: IS
90: SELECT *
91: FROM OKX_ASSETS_V

Line 88: p_object1_id2 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE)

84: AND lse2.id = stl.lse_id
85: AND stl.scs_code in (G_LEASE_SCS_CODE,G_LOAN_SCS_CODE);
86:
87: CURSOR c_asset_info(p_object1_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE,
88: p_object1_id2 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE)
89: IS
90: SELECT *
91: FROM OKX_ASSETS_V
92: WHERE id1 = p_object1_id1

Line 301: okc_k_items_v cim,

297: FROM okc_subclass_top_line stl,
298: okc_line_styles_b lse3,
299: okc_line_styles_b lse2,
300: okc_line_styles_b lse1,
301: okc_k_items_v cim,
302: okc_k_lines_b cle
303: WHERE cle.lse_id = lse1.id
304: AND cle.id = cim.cle_id
305: AND cle.dnz_chr_id = cim.dnz_chr_id

Line 327: CURSOR c_ib_info(p_object1_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE,

323: AND lse2.id = stl.lse_id
324: AND stl.scs_code in (G_LEASE_SCS_CODE,G_LOAN_SCS_CODE));
325:
326:
327: CURSOR c_ib_info(p_object1_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE,
328: p_object1_id2 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE) IS
329: SELECT *
330: FROM OKX_INSTALL_ITEMS_V
331: WHERE id1 = p_object1_id1

Line 328: p_object1_id2 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE) IS

324: AND stl.scs_code in (G_LEASE_SCS_CODE,G_LOAN_SCS_CODE));
325:
326:
327: CURSOR c_ib_info(p_object1_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE,
328: p_object1_id2 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE) IS
329: SELECT *
330: FROM OKX_INSTALL_ITEMS_V
331: WHERE id1 = p_object1_id1
332: AND id2 = p_object1_id2;