APPS.OKS_RENCON_PVT dependencies on OKC_STATUSES_B

Line 176: okc_statuses_b st

172: h.currency_code
173: FROM okc_K_Headers_all_b h, --mmadhavi MOAC - changed to _ALL_B for performance
174: okc_k_party_roles_b pr,
175: okc_k_party_roles_b pr1,
176: okc_statuses_b st
177: WHERE h.id = p_target_id
178: AND h.id = pr.dnz_chr_id AND pr.cle_id IS NULL
179: AND pr.rle_code = 'CUSTOMER'
180: AND h.id = pr1.dnz_chr_id AND pr1.cle_id IS NULL

Line 250: okc_statuses_b st

246: CURSOR get_correct_status(l_source_chr_id IN NUMBER, l_source_subline_id IN NUMBER) IS
247: SELECT h.id
248: FROM okc_K_Headers_all_b h, --mmadhavi MOAC - changed to _ALL_B for performance
249: okc_k_party_roles_b pr,
250: okc_statuses_b st
251: , okc_k_lines_b s
252: WHERE h.id = l_source_chr_id
253: AND h.scs_code IN ('WARRANTY', x_scs_code)
254: AND h.chr_type = x_chr_type

Line 472: okc_statuses_b st

468: h.currency_code
469: FROM okc_K_Headers_all_b h, --mmadhavi MOAC - changed to _ALL_B for performance
470: okc_k_party_roles_b pr,
471: okc_k_party_roles_b pr1,
472: okc_statuses_b st
473: WHERE h.id = p_target_id
474: AND h.id = pr.dnz_chr_id AND pr.cle_id IS NULL
475: AND pr.rle_code = 'CUSTOMER'
476: AND h.id = pr1.dnz_chr_id AND pr1.cle_id IS NULL

Line 496: okc_statuses_b st

492: SELECT
493: h.id
494: FROM okc_K_Headers_all_b h, --mmadhavi MOAC - changed to _ALL_B for performance
495: okc_k_party_roles_b pr,
496: okc_statuses_b st
497: WHERE h.scs_code IN ('WARRANTY', x_scs_code)
498: AND h.chr_type = x_chr_type
499: AND h.template_yn = x_template_yn
500: AND h.buy_or_sell = x_buy_or_sell

Line 519: okc_statuses_b st

515: SELECT
516: h.id
517: FROM okc_K_Headers_all_b h, --mmadhavi MOAC - changed to _ALL_B for performance
518: okc_k_party_roles_b pr,
519: okc_statuses_b st
520: WHERE h.scs_code IN ('WARRANTY', x_scs_code)
521: AND h.chr_type = x_chr_type
522: AND h.template_yn = x_template_yn
523: AND h.buy_or_sell = x_buy_or_sell

Line 1330: okc_statuses_b st

1326: 'X'
1327: FROM okc_K_Headers_all_b h,
1328: okc_k_party_roles_b pr,
1329: okc_k_party_roles_b pr1,
1330: okc_statuses_b st
1331: WHERE h.id = p_target_id
1332: AND h.id = pr.dnz_chr_id AND pr.cle_id IS NULL
1333: AND pr.rle_code = 'CUSTOMER'
1334: AND h.id = pr1.dnz_chr_id AND pr1.cle_id IS NULL

Line 1843: okc_statuses_b st

1839: chr.currency_code
1840: FROM okc_operation_lines b,
1841: okc_k_lines_b cle,
1842: okc_k_headers_all_b chr,
1843: okc_statuses_b st
1844: WHERE b.oie_id = p_oie_id
1845: and cle.id = b.object_cle_id
1846: and cle.cle_id is null
1847: and b.process_flag IN ('A','E')

Line 1907: okc_statuses_b st

1903: pr.object1_id1,
1904: h.currency_code
1905: FROM okc_K_Headers_all_b h,
1906: okc_k_party_roles_b pr,
1907: okc_statuses_b st
1908: WHERE
1909: h.id=pr.dnz_chr_id and pr.cle_id is null
1910: and pr.rle_code = 'CUSTOMER'
1911: and h.scs_code IN ('SERVICE','WARRANTY')