APPS.OKS_QA_DATA_INTEGRITY dependencies on OKC_LINE_STYLES_B

Line 1271: OKC_LINE_STYLES_B lse,

1267: , cim.jtot_object1_code
1268: , cim.object1_id1
1269: , cim.object1_id2
1270: FROM OKC_K_ITEMS cim,
1271: OKC_LINE_STYLES_B lse,
1272: OKC_K_LINES_V cle
1273: WHERE cim.cle_id = cle.id
1274: and lse.id = cle.lse_id
1275: and cle.chr_id = p_chr_id

Line 1294: OKC_LINE_STYLES_B lse,

1290: , cim.object1_id1
1291: , cim.object1_id2
1292: , cle.date_terminated
1293: FROM OKC_K_ITEMS cim,
1294: OKC_LINE_STYLES_B lse,
1295: OKC_K_LINES_V cle
1296: WHERE cim.cle_id = cle.id
1297: AND lse.LTY_CODE IN
1298: ('COVER_CUST', 'COVER_ITEM', 'COVER_PROD',

Line 1624: OKC_LINE_STYLES_B lse,

1620: SELECT cle.id, lse.lty_code, cle.name, cle.lse_id,
1621: cle.start_date, cle.end_date,
1622: cim.jtot_object1_code, cim.object1_id1, cim.object1_id2
1623: FROM OKC_K_ITEMS cim,
1624: OKC_LINE_STYLES_B lse,
1625: OKC_K_LINES_V cle
1626: WHERE cim.cle_id = cle.id
1627: AND lse.id = cle.lse_id
1628: AND cle.chr_id = p_chr_id

Line 1639: OKC_LINE_STYLES_B lse,

1635: SELECT cle.id, cle.PRICE_NEGOTIATED, cle.name, cle.lse_id,
1636: cle.start_date, cle.end_date, lse.lty_code,
1637: cim.jtot_object1_code, cim.object1_id1, cim.object1_id2
1638: FROM OKC_K_ITEMS cim,
1639: OKC_LINE_STYLES_B lse,
1640: OKC_K_LINES_V cle
1641: WHERE cim.cle_id = cle.id
1642: AND lse.LTY_CODE IN
1643: ('COVER_CUST', 'COVER_ITEM', 'COVER_PROD',

Line 1653: FROM OKC_LINE_STYLES_B lse,

1649: l_cve_rec l_cve_csr%ROWTYPE;
1650:
1651: CURSOR l_cva_csr (p_cle_id NUMBER) IS
1652: SELECT COUNT( * )
1653: FROM OKC_LINE_STYLES_B lse,
1654: OKC_K_LINES_B cle
1655: WHERE lse.lty_code = 'COVERAGE'
1656: AND lse.id = cle.lse_id
1657: AND cle.cle_id = p_cle_id