APPS.OKS_OC_INT_KTO_PVT dependencies on OKC_STATUSES_B

Line 75: FROM okc_statuses_b kst,

71: kh.ESTIMATED_AMOUNT ,
72: ks.cls_code ,
73: ks.meaning ,
74: kst.ste_code
75: FROM okc_statuses_b kst,
76: okc_k_headers_b kh,
77: okc_subclasses_v ks
78: WHERE kh.id = p_chr_id
79: AND ks.code = kh.scs_code

Line 113: ,status_code okc_statuses_b.ste_code%TYPE

109: line_id okc_k_lines_v.id%TYPE
110: ,cle_id okc_k_lines_v.cle_id%TYPE
111: ,lse_id okc_k_lines_v.lse_id%TYPE
112: ,line_number okc_k_lines_v.line_number%TYPE
113: ,status_code okc_statuses_b.ste_code%TYPE
114: ,qty okc_k_items.number_of_items%TYPE
115: ,uom_code okc_k_items.uom_code%TYPE
116: ,customer_order_enabled_flag VARCHAR2(1)
117: ,item_name okc_k_lines_v.name%TYPE

Line 636: okc_statuses_b sts

632: FROM
633: okc_k_lines_v cle,
634: okc_k_items cim,
635: okc_line_styles_b lse,
636: okc_statuses_b sts
637: WHERE
638: cim.cle_id = cle.id
639: AND lse.id = cle.lse_id
640: AND sts.code = cle.sts_code

Line 1377: okc_statuses_b sts

1373: sub.end_date,
1374: sub.om_interface_date
1375: from oks_subscr_elements sub ,
1376: okc_k_lines_b line,
1377: okc_statuses_b sts
1378: where sub.dnz_chr_id = nvl(p_contract_id ,sub.dnz_chr_id)
1379: and sub.dnz_chr_id between nvl(nvl(p_contract_id,p_contract_hdr_id_lo),sub.dnz_chr_id)
1380: and nvl(nvl(p_contract_id,p_contract_hdr_id_hi),sub.dnz_chr_id)
1381: and sub.order_header_id is null

Line 1403: okc_statuses_b st

1399: hdr.contract_number
1400: from oks_subscr_elements sub,
1401: okc_k_headers_b hdr,
1402: okc_k_party_roles_b pr,
1403: okc_statuses_b st
1404: where sub.dnz_chr_id = nvl(p_contract_id ,sub.dnz_chr_id)
1405: --== and sub.dnz_chr_id between nvl(nvl(p_contract_id,p_contract_hdr_id_lo),sub.dnz_chr_id)
1406: --== and nvl(nvl(p_contract_id,p_contract_hdr_id_hi),sub.dnz_chr_id)
1407: and hdr.id = sub.dnz_chr_id