DBA Data[Home] [Help]

APPS.OKL_LA_ASSET_PVT dependencies on OKC_STATUSES_B

Line 593: OKC_STATUSES_B sts

589: (SELECT (1) */
590: FROM OKC_K_LINES_B cle,
591: OKC_K_ITEMS itm,
592: OKC_LINE_STYLES_B lse,
593: OKC_STATUSES_B sts
594: WHERE cle.dnz_chr_id = p_dnz_chr_id
595: AND itm.dnz_chr_id = cle.dnz_chr_id
596: AND itm.cle_id = cle.id
597: AND lse.id = cle.lse_id

Line 614: OKC_STATUSES_B sts

610: (SELECT (1) */
611: FROM OKC_K_LINES_B cle,
612: OKC_K_ITEMS itm,
613: OKC_LINE_STYLES_B lse,
614: OKC_STATUSES_B sts
615: WHERE cle.dnz_chr_id = p_dnz_chr_id
616: AND itm.dnz_chr_id = cle.dnz_chr_id
617: AND itm.cle_id = cle.id
618: AND lse.id = cle.lse_id

Line 635: OKC_STATUSES_B sts

631: (SELECT (1) */
632: FROM OKC_K_LINES_B cle,
633: OKC_K_ITEMS itm,
634: OKC_LINE_STYLES_B lse,
635: OKC_STATUSES_B sts
636: WHERE cle.dnz_chr_id = p_dnz_chr_id
637: AND itm.dnz_chr_id = cle.dnz_chr_id
638: AND itm.cle_id = cle.id
639: AND lse.id = cle.lse_id

Line 1115: okc_statuses_b st

1111: khr.deal_type
1112: -- FROM OKL_K_HEADERS_FULL_V chr,
1113: FROM okc_k_headers_b chr,
1114: okl_k_headers khr,
1115: okc_statuses_b st
1116: WHERE khr.id = chr.id
1117: and chr.id = p_chr_id
1118: and st.code = chr.sts_code;
1119:

Line 1128: OKC_STATUSES_B sts

1124: (SELECT (1)*/
1125: FROM OKC_K_LINES_B cle,
1126: OKC_K_ITEMS itm,
1127: OKC_LINE_STYLES_B lse,
1128: OKC_STATUSES_B sts
1129: WHERE cle.dnz_chr_id = p_dnz_chr_id
1130: AND itm.dnz_chr_id = cle.dnz_chr_id
1131: AND itm.cle_id = cle.id
1132: AND lse.id = cle.lse_id