APPS.OKS_QA_DATA_INTEGRITY dependencies on OKC_LINE_STYLES_B

Line 1208: OKC_LINE_STYLES_B lse,

1204: , cim.jtot_object1_code
1205: , cim.object1_id1
1206: , cim.object1_id2
1207: FROM OKC_K_ITEMS cim,
1208: OKC_LINE_STYLES_B lse,
1209: OKC_K_LINES_V cle
1210: WHERE cim.cle_id = cle.id
1211: and lse.id = cle.lse_id
1212: and cle.chr_id = p_chr_id

Line 1231: OKC_LINE_STYLES_B lse,

1227: , cim.object1_id1
1228: , cim.object1_id2
1229: , cle.date_terminated
1230: FROM OKC_K_ITEMS cim,
1231: OKC_LINE_STYLES_B lse,
1232: OKC_K_LINES_V cle
1233: WHERE cim.cle_id = cle.id
1234: AND lse.LTY_CODE IN
1235: ('COVER_CUST', 'COVER_ITEM', 'COVER_PROD',

Line 1555: OKC_LINE_STYLES_B lse,

1551: SELECT cle.id, lse.lty_code, cle.name, cle.lse_id,
1552: cle.start_date, cle.end_date,
1553: cim.jtot_object1_code, cim.object1_id1, cim.object1_id2
1554: FROM OKC_K_ITEMS cim,
1555: OKC_LINE_STYLES_B lse,
1556: OKC_K_LINES_V cle
1557: WHERE cim.cle_id = cle.id
1558: AND lse.id = cle.lse_id
1559: AND cle.chr_id = p_chr_id

Line 1570: OKC_LINE_STYLES_B lse,

1566: SELECT cle.id, cle.PRICE_NEGOTIATED, cle.name, cle.lse_id,
1567: cle.start_date, cle.end_date, lse.lty_code,
1568: cim.jtot_object1_code, cim.object1_id1, cim.object1_id2
1569: FROM OKC_K_ITEMS cim,
1570: OKC_LINE_STYLES_B lse,
1571: OKC_K_LINES_V cle
1572: WHERE cim.cle_id = cle.id
1573: AND lse.LTY_CODE IN
1574: ('COVER_CUST', 'COVER_ITEM', 'COVER_PROD',

Line 1584: FROM OKC_LINE_STYLES_B lse,

1580: l_cve_rec l_cve_csr%ROWTYPE;
1581:
1582: CURSOR l_cva_csr (p_cle_id NUMBER) IS
1583: SELECT COUNT( * )
1584: FROM OKC_LINE_STYLES_B lse,
1585: OKC_K_LINES_B cle
1586: WHERE lse.lty_code = 'COVERAGE'
1587: AND lse.id = cle.lse_id
1588: AND cle.cle_id = p_cle_id