DBA Data[Home] [Help]

APPS.OKL_SO_CREDIT_APP_WF dependencies on OKC_K_LINES_B

Line 1369: FROM OKC_K_LINES_B CLEB,OKL_K_LINES KLE, OKC_K_HEADERS_V CHR

1365: l_quote_number OKC_K_HEADERS_B.CONTRACT_number%TYPE;
1366:
1367: CURSOR contract_number_csr(p_contract_id NUMBER ) IS
1368: SELECT SUM(KLE.CAPITAL_AMOUNT) ,chr.contract_number
1369: FROM OKC_K_LINES_B CLEB,OKL_K_LINES KLE, OKC_K_HEADERS_V CHR
1370: WHERE chr.scs_code = 'QUOTE'
1371: AND chr.ID = l_quote_id
1372: AND CLEB.ID = KLE.ID
1373: AND CLEB.DNZ_CHR_ID = chr.ID