APPS.OKL_LA_ASSET_PVT dependencies on OKC_STATUSES_B

Line 566: OKC_STATUSES_B sts

562: (SELECT (1) */
563: FROM OKC_K_LINES_B cle,
564: OKC_K_ITEMS itm,
565: OKC_LINE_STYLES_B lse,
566: OKC_STATUSES_B sts
567: WHERE cle.dnz_chr_id = p_dnz_chr_id
568: AND itm.dnz_chr_id = cle.dnz_chr_id
569: AND itm.cle_id = cle.id
570: AND lse.id = cle.lse_id

Line 587: OKC_STATUSES_B sts

583: (SELECT (1) */
584: FROM OKC_K_LINES_B cle,
585: OKC_K_ITEMS itm,
586: OKC_LINE_STYLES_B lse,
587: OKC_STATUSES_B sts
588: WHERE cle.dnz_chr_id = p_dnz_chr_id
589: AND itm.dnz_chr_id = cle.dnz_chr_id
590: AND itm.cle_id = cle.id
591: AND lse.id = cle.lse_id

Line 608: OKC_STATUSES_B sts

604: (SELECT (1) */
605: FROM OKC_K_LINES_B cle,
606: OKC_K_ITEMS itm,
607: OKC_LINE_STYLES_B lse,
608: OKC_STATUSES_B sts
609: WHERE cle.dnz_chr_id = p_dnz_chr_id
610: AND itm.dnz_chr_id = cle.dnz_chr_id
611: AND itm.cle_id = cle.id
612: AND lse.id = cle.lse_id

Line 1087: okc_statuses_b st

1083: khr.deal_type
1084: -- FROM OKL_K_HEADERS_FULL_V chr,
1085: FROM okc_k_headers_b chr,
1086: okl_k_headers khr,
1087: okc_statuses_b st
1088: WHERE khr.id = chr.id
1089: and chr.id = p_chr_id
1090: and st.code = chr.sts_code;
1091:

Line 1100: OKC_STATUSES_B sts

1096: (SELECT (1)*/
1097: FROM OKC_K_LINES_B cle,
1098: OKC_K_ITEMS itm,
1099: OKC_LINE_STYLES_B lse,
1100: OKC_STATUSES_B sts
1101: WHERE cle.dnz_chr_id = p_dnz_chr_id
1102: AND itm.dnz_chr_id = cle.dnz_chr_id
1103: AND itm.cle_id = cle.id
1104: AND lse.id = cle.lse_id