DBA Data[Home] [Help]

APPS.OKS_IBINT_PUB dependencies on OKS_K_LINES_B

Line 1263: ,OKS_K_LINES_B OKL

1259: From OKC_K_ITEMS KI
1260: ,OKC_K_HEADERS_ALL_B KH
1261: ,OKS_K_HEADERS_B KS
1262: ,OKC_K_LINES_V KL
1263: ,OKS_K_LINES_B OKL
1264: ,OKC_STATUSES_B ST
1265: ,OKC_K_PARTY_ROLES_B PARTY
1266: , OKC_K_LINES_B OL
1267: ,OKS_K_LINES_B KSL

Line 1267: ,OKS_K_LINES_B KSL

1263: ,OKS_K_LINES_B OKL
1264: ,OKC_STATUSES_B ST
1265: ,OKC_K_PARTY_ROLES_B PARTY
1266: , OKC_K_LINES_B OL
1267: ,OKS_K_LINES_B KSL
1268: ,OKC_K_ITEMS KIS
1269: , OKS_INSTANCE_TEMP tmp
1270:
1271: Where tmp.trf = 'Y'

Line 1859: , OKS_K_LINES_B OKL

1855: , OKC_STATUSES_B ST
1856: , OKS_INSTANCE_TEMP tmp
1857: , OKC_K_LINES_B TL
1858: ,OKC_K_ITEMS KIS
1859: , OKS_K_LINES_B OKL
1860: Where tmp.spl = 'Y'
1861: And nvl(tmp.trm,'N') = 'N'
1862: And KI.Object1_id1 = to_char(tmp.old_customer_product_id)
1863: And KI.Jtot_Object1_code = 'OKX_CUSTPROD'

Line 1940: , OKS_K_LINES_B OKL

1936: , OKC_STATUSES_B ST
1937: , OKS_INSTANCE_TEMP tmp
1938: , OKC_K_LINES_B TL
1939: ,OKC_K_ITEMS KIS
1940: , OKS_K_LINES_B OKL
1941:
1942: Where tmp.rpl = 'Y'
1943: And KI.Object1_id1 = to_char(tmp.old_customer_product_id)
1944: And KI.Jtot_Object1_code = 'OKX_CUSTPROD'

Line 2021: , OKS_K_LINES_B OKL

2017: , OKC_STATUSES_B ST
2018: , OKS_INSTANCE_TEMP tmp
2019: , OKC_K_LINES_B TL
2020: , OKC_K_ITEMS KIS
2021: , OKS_K_LINES_B OKL
2022: Where tmp.upd = 'Y'
2023: And Nvl(tmp.trm,'N') = 'N'
2024: And KI.Object1_id1 = to_char(tmp.old_customer_product_id)
2025: And KI.Jtot_Object1_code = 'OKX_CUSTPROD'

Line 2937: oks_k_lines_b ksl

2933: okc_statuses_v sts,
2934: okc_k_items sli,
2935: okc_line_styles_v lst,
2936: okc_line_styles_v tlst,
2937: oks_k_lines_b ksl
2938: where sl.id = p_covered_line_id
2939: and sl.sts_code=sts.code
2940: and sl.lse_id = lst.id
2941: and tl.lse_id = tlst.id