DBA Data[Home] [Help]

APPS.OKS_BCL_PVT dependencies on OKC_K_LINES_V

Line 370: from OKC_K_LINES_V

366: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
367: l_dummy_var VARCHAR2(1) := '?';
368: Cursor l_cle_Csr Is
369: select 'x'
370: from OKC_K_LINES_V
371: where id = P_cle_id;
372:
373: Begin
374: If p_cle_id = OKC_API.G_MISS_NUM OR

Line 2194: FROM Okc_K_Lines_V

2190: PRICE_TYPE,
2191: --UOM_CODE,
2192: CURRENCY_CODE,
2193: LAST_UPDATE_LOGIN
2194: FROM Okc_K_Lines_V
2195: WHERE okc_k_lines_v.id = p_id;
2196: l_okc_clev_pk okc_clev_pk_csr%ROWTYPE;
2197: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2198: l_row_notfound BOOLEAN := TRUE;

Line 2195: WHERE okc_k_lines_v.id = p_id;

2191: --UOM_CODE,
2192: CURRENCY_CODE,
2193: LAST_UPDATE_LOGIN
2194: FROM Okc_K_Lines_V
2195: WHERE okc_k_lines_v.id = p_id;
2196: l_okc_clev_pk okc_clev_pk_csr%ROWTYPE;
2197: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2198: l_row_notfound BOOLEAN := TRUE;
2199: BEGIN