eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKS_IBINT_PUB dependencies on OKC_K_HEADERS_ALL_B

Line 553: Update Okc_k_headers_all_b

549: -- Vigandhi : 08-Dec-2005
550: --- Fix for Bug 4295015
551: IF nvl(fnd_profile.value('OKS_WARRANTY_CONSOLIDATION'), 'Y') = 'Y'
552: THEN
553: Update Okc_k_headers_all_b
554: Set last_updated_by = last_updated_by
555: Where id = -1;
556:
557: If SQL%ROWCOUNT < 1 Then

Line 1260: ,OKC_K_HEADERS_ALL_B KH

1256: ,ks.price_uom hdr_price_uom
1257: ,okl.toplvl_uom_code
1258: ,okl.toplvl_price_qty
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

Line 1368: , OKC_K_HEADERS_ALL_B KH

1364: , Null
1365: , Null
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

Line 1471: ,OKC_K_HEADERS_ALL_B KH

1467: , Null
1468:
1469:
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

Line 1571: , OKC_K_HEADERS_ALL_B KH

1567: , Null
1568: , Null
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

Line 1673: ,OKC_K_HEADERS_ALL_B KH

1669: , null
1670: , null
1671: , null
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

Line 1776: , OKC_K_HEADERS_ALL_B KH

1772: , null
1773: , null
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

Line 1853: , OKC_K_HEADERS_ALL_B KH

1849: , okl.price_uom
1850: , okl.toplvl_uom_code
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

Line 1934: , OKC_K_HEADERS_ALL_B KH

1930: , okl.price_uom
1931: , okl.toplvl_uom_code
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

Line 2015: , OKC_K_HEADERS_ALL_B KH

2011: , okl.price_uom
2012: , okl.toplvl_uom_code
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

Line 3167: ,OKC_K_HEADERS_ALL_B KH

3163:
3164: Select CL.id
3165:
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:

Line 3191: ,OKC_K_HEADERS_ALL_B KH

3187:
3188: cursor trm_trf_contracts IS
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 )

Line 3220: ,OKC_K_HEADERS_ALL_B KH

3216:
3217: cursor trm_trf_contracts1 IS
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'

Line 3253: ,OKC_K_HEADERS_ALL_B KH

3249:
3250: cursor trm_usages_contracts IS
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:

Line 3286: ,OKC_K_HEADERS_ALL_B KH

3282:
3283: cursor trm_usages_contracts1 IS
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

Line 3322: ,OKC_K_HEADERS_ALL_B KH

3318:
3319: cursor spl_upd_contracts IS
3320: Select CL.id
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

Line 3345: ,OKC_K_HEADERS_ALL_B KH

3341: spl_upd_contracts_rec spl_upd_contracts%rowtype;
3342: cursor rin_contracts IS
3343: Select cl.id
3344: From OKC_K_ITEMS KI
3345: ,OKC_K_HEADERS_ALL_B KH
3346: ,OKC_K_LINES_B CL
3347: Where
3348: KI.Jtot_Object1_code = 'OKX_CUSTPROD'
3349: AND KI.object1_id1 = to_char(p_instance_id)

Line 3514: FROM okc_k_headers_all_b okc,

3510:
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';

Line 3535: okc_k_headers_all_b okh

3531: FROM CSI_ITEM_INSTANCES CII,
3532: CSI_I_ORG_ASSIGNMENTS CIOA,
3533: OE_ORDER_LINES_ALL OOL,
3534: OKC_K_PARTY_ROLES_B k_party,
3535: okc_k_headers_all_b okh
3536: WHERE CII.last_oe_order_line_id = OOL.line_id( + )
3537: AND CII.instance_id = CIOA.instance_id( + )
3538: AND CIOA.relationship_type_code ( + ) = 'SOLD_FROM'
3539: AND k_party.chr_id=p_chr_id

Line 3589: OKC_K_HEADERS_ALL_B OKH

3585: IS
3586: SELECT 'Y'
3587: FROM CSI_ITEM_INSTANCES CII,
3588: MTL_SYSTEM_ITEMS_B_KFV IT,
3589: OKC_K_HEADERS_ALL_B OKH
3590: WHERE IT.inventory_item_id = CII.inventory_item_id
3591: AND IT.organization_id = OKH.inv_organization_id
3592: AND IT.serviceable_product_flag = 'Y'
3593: AND OKH.id = p_chr_id