APPS.OKC_PHI_PVT dependencies on OKC_K_LINES_V

Line 97: FROM okc_k_lines_v cle

93: start_date,
94: end_date,
95: price_list_id,
96: date_terminated
97: FROM okc_k_lines_v cle
98: WHERE cle.dnz_chr_id=b_chr_id
99: AND cle.cle_id is null
100: AND cle.lse_id=61 -- Price Hold Line style.
101: AND nvl(cle.end_date,sysdate+1) > Sysdate

Line 124: FROM okc_k_lines_v cle,

120: jtot_object1_code,
121: object1_id1,
122: object1_id2,
123: uom_code
124: FROM okc_k_lines_v cle,
125: okc_k_items_v cim
126: WHERE cle.cle_id=b_cle_id
127: AND cle.id=cim.cle_id
128: ORDER BY line_number;

Line 1155: ,p_cle_id IN OKC_K_LINES_V.id%TYPE -- Price Hold Topline Id

1151: */
1152:
1153: PROCEDURE extend_price_hold(p_api_version IN NUMBER
1154: ,p_init_msg_list IN VARCHAR2
1155: ,p_cle_id IN OKC_K_LINES_V.id%TYPE -- Price Hold Topline Id
1156: ,x_return_status OUT NOCOPY VARCHAR2
1157: ,x_msg_count OUT NOCOPY NUMBER
1158: ,x_msg_data OUT NOCOPY VARCHAR2
1159: ) IS

Line 1164: okc_k_lines_V cle

1160:
1161: Cursor c_k_header(b_cle_id Number) IS
1162: SELECT chr.id ID
1163: FROM okc_k_headers_V chr,
1164: okc_k_lines_V cle
1165: WHERE cle.id=b_cle_id
1166: AND chr.id=cle.dnz_chr_id
1167: AND chr.application_id in (510,871)
1168: AND chr.buy_or_sell='S'

Line 1182: FROM okc_k_lines_v cle

1178: ph_qp_reference_id,
1179: ph_integrated_with_qp,
1180: start_date,
1181: end_date
1182: FROM okc_k_lines_v cle
1183: WHERE cle.id=b_cle_id
1184: AND cle.cle_id is null
1185: AND cle.lse_id=61 -- Price Hold Line style.
1186: AND cle.date_terminated IS NULL

Line 1199: FROM okc_k_lines_v cle

1195: ph_qp_reference_id,
1196: ph_integrated_with_qp,
1197: start_date,
1198: end_date
1199: FROM okc_k_lines_v cle
1200: WHERE cle.cle_id=b_cle_id
1201: AND cle.ph_qp_reference_id is not null
1202: ORDER BY line_number;
1203:

Line 1470: from okc_k_lines_v

1466: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1467:
1468: CURSOR c_cur_ph_lines(p_par_id NUMBER) IS
1469: select id
1470: from okc_k_lines_v
1471: where cle_id = p_par_id;
1472:
1473: CURSOR c_top_lines(p_chr_id NUMBER) IS
1474: select id

Line 1475: from okc_k_lines_v

1471: where cle_id = p_par_id;
1472:
1473: CURSOR c_top_lines(p_chr_id NUMBER) IS
1474: select id
1475: from okc_k_lines_v
1476: where chr_id=p_chr_id and item_to_price_yn='Y'
1477: order by DISPLAY_SEQUENCE;
1478:
1479: CURSOR c_top_ph_line(p_cle_id NUMBER) IS

Line 1484: from okc_k_lines_v

1480: select
1481: PRICE_LIST_ID,
1482: PH_PRICING_TYPE,
1483: PH_ADJUSTMENT
1484: from okc_k_lines_v
1485: where id=p_cle_id;
1486:
1487: x_clev_rec OKC_CONTRACT_PUB.clev_rec_type;
1488: n_clev_rec OKC_CONTRACT_PUB.clev_rec_type;

Line 1573: FROM OKC_K_LINES_V

1569: PH_QP_REFERENCE_ID,
1570: PH_VALUE,
1571: PH_ENFORCE_PRICE_LIST_YN,
1572: PH_INTEGRATED_WITH_QP
1573: FROM OKC_K_LINES_V
1574: WHERE id = p_cle_id;
1575:
1576: CURSOR c_cimv_rec(p_cle_id NUMBER) IS
1577: SELECT ID,

Line 1616: from okc_k_lines_v

1612: CLOSE c_top_ph_line;
1613:
1614: select Greatest(Nvl(Max(DISPLAY_SEQUENCE),0),Nvl(Max(LINE_NUMBER),0))
1615: INTO m_cnt
1616: from okc_k_lines_v
1617: where cle_id = top_line_id;
1618:
1619: FOR crec IN c_top_lines( p_chr_id ) LOOP
1620: x_clev_rec := n_clev_rec;