APPS.OKS_IBINT_PUB dependencies on OKC_STATUSES_B

Line 1264: ,OKC_STATUSES_B ST

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
1268: ,OKC_K_ITEMS KIS

Line 1370: , OKC_STATUSES_B ST

1366:
1367: From OKC_K_ITEMS KI
1368: , OKC_K_HEADERS_ALL_B KH
1369: , OKC_K_LINES_B KL
1370: , OKC_STATUSES_B ST
1371: , OKS_INSTANCE_TEMP tmp
1372: , OKC_K_LINES_B TL
1373: ,OKC_K_ITEMS KIS
1374: ,OKC_K_PARTY_ROLES_B PARTY

Line 1474: ,OKC_STATUSES_B ST

1470: From OKC_K_ITEMS KI
1471: ,OKC_K_HEADERS_ALL_B KH
1472: ,OKC_K_LINES_B KL
1473: ,OKC_K_LINES_B TL
1474: ,OKC_STATUSES_B ST
1475: ,csi_counter_associations CTRASC
1476: ,OKS_INSTANCE_TEMP tmp
1477: ,OKC_K_ITEMS KIS
1478: ,OKC_K_PARTY_ROLES_B PARTY

Line 1573: , OKC_STATUSES_B ST

1569: , Null
1570: From OKC_K_ITEMS KI
1571: , OKC_K_HEADERS_ALL_B KH
1572: , OKC_K_LINES_B KL
1573: , OKC_STATUSES_B ST
1574: , OKS_INSTANCE_TEMP tmp
1575: , OKC_K_LINES_B TL
1576: ,OKC_K_ITEMS KIS
1577: ,OKC_K_PARTY_ROLES_B PARTY

Line 1676: ,OKC_STATUSES_B ST

1672: From OKC_K_ITEMS KI
1673: ,OKC_K_HEADERS_ALL_B KH
1674: ,OKC_K_LINES_B KL
1675: ,OKC_K_LINES_B TL
1676: ,OKC_STATUSES_B ST
1677: ,csi_counter_associations CTRASC
1678: , OKS_INSTANCE_TEMP tmp
1679: ,OKC_K_ITEMS KIS
1680: ,OKC_K_PARTY_ROLES_B PARTY

Line 1778: , OKC_STATUSES_B ST

1774: , null
1775: From OKC_K_ITEMS KI
1776: , OKC_K_HEADERS_ALL_B KH
1777: , OKC_K_LINES_B KL
1778: , OKC_STATUSES_B ST
1779: , OKS_INSTANCE_TEMP tmp
1780: , OKC_K_LINES_B TL
1781: ,OKC_K_ITEMS KIS
1782: Where tmp.idc = 'Y'

Line 1855: , OKC_STATUSES_B ST

1851: , okl.toplvl_price_qty
1852: From OKC_K_ITEMS KI
1853: , OKC_K_HEADERS_ALL_B KH
1854: , OKC_K_LINES_v KL
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

Line 1936: , OKC_STATUSES_B ST

1932: , okl.toplvl_price_qty
1933: From OKC_K_ITEMS KI
1934: , OKC_K_HEADERS_ALL_B KH
1935: , OKC_K_LINES_v KL
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

Line 2017: , OKC_STATUSES_B ST

2013: , okl.toplvl_price_qty
2014: From OKC_K_ITEMS KI
2015: , OKC_K_HEADERS_ALL_B KH
2016: , OKC_K_LINES_B KL
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

Line 3170: ,OKC_STATUSES_b ST

3166: From OKC_K_ITEMS KI
3167: ,OKC_K_HEADERS_ALL_B KH
3168: ,OKC_K_LINES_B KL
3169: ,OKC_K_LINES_B CL
3170: ,OKC_STATUSES_b ST
3171:
3172: Where
3173: KI.Jtot_Object1_code = 'OKX_CUSTPROD'
3174: AND KI.object1_id1 = to_char(p_instance_id)

Line 3193: ,OKC_STATUSES_b ST

3189: Select CL.id
3190: From OKC_K_ITEMS KI
3191: ,OKC_K_HEADERS_ALL_B KH
3192: ,OKC_K_LINES_B CL
3193: ,OKC_STATUSES_b ST
3194: Where KI.Jtot_Object1_code = 'OKX_CUSTPROD'
3195: AND KI.object1_id1 = to_char(p_instance_id )
3196: And KH.scs_code in ('WARRANTY','SERVICE','SUBSCRIPTION' )
3197: And KI.Cle_id = CL.id

Line 3222: ,OKC_STATUSES_b ST

3218: Select CL.id
3219: From OKC_K_ITEMS KI
3220: ,OKC_K_HEADERS_ALL_B KH
3221: ,OKC_K_LINES_B CL
3222: ,OKC_STATUSES_b ST
3223: ,oks_instance_k_dtls_temp temp
3224: Where KI.Jtot_Object1_code = 'OKX_CUSTPROD'
3225: AND KI.object1_id1 = to_char(temp.instance_id)
3226: And KH.scs_code in ('WARRANTY','SERVICE','SUBSCRIPTION' )

Line 3255: ,OKC_STATUSES_B ST

3251: Select CL.id
3252: From OKC_K_ITEMS KI
3253: ,OKC_K_HEADERS_ALL_B KH
3254: ,OKC_K_LINES_B CL
3255: ,OKC_STATUSES_B ST
3256: ,csi_counter_associations CTRASC
3257:
3258: where KI.object1_id1 = to_char(CTRASC.COunter_id)
3259: And KI.jtot_object1_code = 'OKX_COUNTER'

Line 3288: ,OKC_STATUSES_B ST

3284: Select CL.id
3285: From OKC_K_ITEMS KI
3286: ,OKC_K_HEADERS_ALL_B KH
3287: ,OKC_K_LINES_B CL
3288: ,OKC_STATUSES_B ST
3289: ,csi_counter_associations CTRASC
3290: ,oks_instance_k_dtls_temp temp
3291: where KI.object1_id1 = to_char(CTRASC.COunter_id)
3292: And KI.jtot_object1_code = 'OKX_COUNTER'

Line 3325: ,OKC_STATUSES_b ST

3321: From OKC_K_ITEMS KI
3322: ,OKC_K_HEADERS_ALL_B KH
3323: ,OKC_K_LINES_B KL
3324: ,OKC_K_LINES_B CL
3325: ,OKC_STATUSES_b ST
3326: Where
3327: KI.Jtot_Object1_code = 'OKX_CUSTPROD'
3328: AND KI.object1_id1 = to_char(p_instance_id)
3329: And KI.dnz_chr_id = KH.ID

Line 3515: okc_statuses_b sts

3511: CURSOR chk_sts(p_chr_id NUMBER)
3512: IS
3513: SELECT sts.ste_code
3514: FROM okc_k_headers_all_b okc,
3515: okc_statuses_b sts
3516: WHERE okc.id = p_chr_id
3517: AND okc.sts_code = sts.code
3518: AND sts.ste_code ='ENTERED';
3519: