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 473: okc_statuses_b st

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

Line 497: okc_statuses_b st

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

Line 520: okc_statuses_b st

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

Line 1331: okc_statuses_b st

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

Line 1845: okc_statuses_b st

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

Line 1909: okc_statuses_b st

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