DBA Data[Home] [Help]

APPS.OKS_IBINT_PUB dependencies on OKS_K_LINES_B

Line 1243: ,OKS_K_LINES_B OKL

1239: From OKC_K_ITEMS KI
1240: ,OKC_K_HEADERS_ALL_B KH
1241: ,OKS_K_HEADERS_B KS
1242: ,OKC_K_LINES_V KL
1243: ,OKS_K_LINES_B OKL
1244: ,OKC_STATUSES_B ST
1245: ,OKC_K_PARTY_ROLES_B PARTY
1246: , OKC_K_LINES_B OL
1247: ,OKS_K_LINES_B KSL

Line 1247: ,OKS_K_LINES_B KSL

1243: ,OKS_K_LINES_B OKL
1244: ,OKC_STATUSES_B ST
1245: ,OKC_K_PARTY_ROLES_B PARTY
1246: , OKC_K_LINES_B OL
1247: ,OKS_K_LINES_B KSL
1248: ,OKC_K_ITEMS KIS
1249: , OKS_INSTANCE_TEMP tmp
1250:
1251: Where tmp.trf = 'Y'

Line 1839: , OKS_K_LINES_B OKL

1835: , OKC_STATUSES_B ST
1836: , OKS_INSTANCE_TEMP tmp
1837: , OKC_K_LINES_B TL
1838: ,OKC_K_ITEMS KIS
1839: , OKS_K_LINES_B OKL
1840: Where tmp.spl = 'Y'
1841: And nvl(tmp.trm,'N') = 'N'
1842: And KI.Object1_id1 = to_char(tmp.old_customer_product_id)
1843: And KI.Jtot_Object1_code = 'OKX_CUSTPROD'

Line 1920: , OKS_K_LINES_B OKL

1916: , OKC_STATUSES_B ST
1917: , OKS_INSTANCE_TEMP tmp
1918: , OKC_K_LINES_B TL
1919: ,OKC_K_ITEMS KIS
1920: , OKS_K_LINES_B OKL
1921:
1922: Where tmp.rpl = 'Y'
1923: And KI.Object1_id1 = to_char(tmp.old_customer_product_id)
1924: And KI.Jtot_Object1_code = 'OKX_CUSTPROD'

Line 2001: , OKS_K_LINES_B OKL

1997: , OKC_STATUSES_B ST
1998: , OKS_INSTANCE_TEMP tmp
1999: , OKC_K_LINES_B TL
2000: , OKC_K_ITEMS KIS
2001: , OKS_K_LINES_B OKL
2002: Where tmp.upd = 'Y'
2003: And Nvl(tmp.trm,'N') = 'N'
2004: And KI.Object1_id1 = to_char(tmp.old_customer_product_id)
2005: And KI.Jtot_Object1_code = 'OKX_CUSTPROD'

Line 2916: oks_k_lines_b ksl

2912: okc_statuses_v sts,
2913: okc_k_items sli,
2914: okc_line_styles_v lst,
2915: okc_line_styles_v tlst,
2916: oks_k_lines_b ksl
2917: where sl.id = p_covered_line_id
2918: and sl.sts_code=sts.code
2919: and sl.lse_id = lst.id
2920: and tl.lse_id = tlst.id