[Home] [Help]
553: -- Vigandhi : 08-Dec-2005
554: --- Fix for Bug 4295015
555: IF nvl(fnd_profile.value('OKS_WARRANTY_CONSOLIDATION'), 'Y') = 'Y'
556: THEN
557: Update Okc_k_headers_all_b
558: Set last_updated_by = last_updated_by
559: Where id = -1;
560:
561: If SQL%ROWCOUNT < 1 Then
1236: ,ks.price_uom hdr_price_uom
1237: ,okl.toplvl_uom_code
1238: ,okl.toplvl_price_qty
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
1344: , Null
1345: , Null
1346:
1347: From OKC_K_ITEMS KI
1348: , OKC_K_HEADERS_ALL_B KH
1349: , OKC_K_LINES_B KL
1350: , OKC_STATUSES_B ST
1351: , OKS_INSTANCE_TEMP tmp
1352: , OKC_K_LINES_B TL
1447: , Null
1448:
1449:
1450: From OKC_K_ITEMS KI
1451: ,OKC_K_HEADERS_ALL_B KH
1452: ,OKC_K_LINES_B KL
1453: ,OKC_K_LINES_B TL
1454: ,OKC_STATUSES_B ST
1455: ,csi_counter_associations CTRASC
1547: , Null
1548: , Null
1549: , Null
1550: From OKC_K_ITEMS KI
1551: , OKC_K_HEADERS_ALL_B KH
1552: , OKC_K_LINES_B KL
1553: , OKC_STATUSES_B ST
1554: , OKS_INSTANCE_TEMP tmp
1555: , OKC_K_LINES_B TL
1649: , null
1650: , null
1651: , null
1652: From OKC_K_ITEMS KI
1653: ,OKC_K_HEADERS_ALL_B KH
1654: ,OKC_K_LINES_B KL
1655: ,OKC_K_LINES_B TL
1656: ,OKC_STATUSES_B ST
1657: ,csi_counter_associations CTRASC
1752: , null
1753: , null
1754: , null
1755: From OKC_K_ITEMS KI
1756: , OKC_K_HEADERS_ALL_B KH
1757: , OKC_K_LINES_B KL
1758: , OKC_STATUSES_B ST
1759: , OKS_INSTANCE_TEMP tmp
1760: , OKC_K_LINES_B TL
1829: , okl.price_uom
1830: , okl.toplvl_uom_code
1831: , okl.toplvl_price_qty
1832: From OKC_K_ITEMS KI
1833: , OKC_K_HEADERS_ALL_B KH
1834: , OKC_K_LINES_v KL
1835: , OKC_STATUSES_B ST
1836: , OKS_INSTANCE_TEMP tmp
1837: , OKC_K_LINES_B TL
1910: , okl.price_uom
1911: , okl.toplvl_uom_code
1912: , okl.toplvl_price_qty
1913: From OKC_K_ITEMS KI
1914: , OKC_K_HEADERS_ALL_B KH
1915: , OKC_K_LINES_v KL
1916: , OKC_STATUSES_B ST
1917: , OKS_INSTANCE_TEMP tmp
1918: , OKC_K_LINES_B TL
1991: , okl.price_uom
1992: , okl.toplvl_uom_code
1993: , okl.toplvl_price_qty
1994: From OKC_K_ITEMS KI
1995: , OKC_K_HEADERS_ALL_B KH
1996: , OKC_K_LINES_B KL
1997: , OKC_STATUSES_B ST
1998: , OKS_INSTANCE_TEMP tmp
1999: , OKC_K_LINES_B TL
3131:
3132: Select CL.id
3133:
3134: From OKC_K_ITEMS KI
3135: ,OKC_K_HEADERS_ALL_B KH
3136: ,OKC_K_LINES_B KL
3137: ,OKC_K_LINES_B CL
3138: ,OKC_STATUSES_b ST
3139:
3155:
3156: cursor trm_trf_contracts IS
3157: Select CL.id
3158: From OKC_K_ITEMS KI
3159: ,OKC_K_HEADERS_ALL_B KH
3160: ,OKC_K_LINES_B CL
3161: ,OKC_STATUSES_b ST
3162: Where KI.Jtot_Object1_code = 'OKX_CUSTPROD'
3163: AND KI.object1_id1 = to_char(p_instance_id )
3184:
3185: cursor trm_trf_contracts1 IS
3186: Select CL.id
3187: From OKC_K_ITEMS KI
3188: ,OKC_K_HEADERS_ALL_B KH
3189: ,OKC_K_LINES_B CL
3190: ,OKC_STATUSES_b ST
3191: ,oks_instance_k_dtls_temp temp
3192: Where KI.Jtot_Object1_code = 'OKX_CUSTPROD'
3217:
3218: cursor trm_usages_contracts IS
3219: Select CL.id
3220: From OKC_K_ITEMS KI
3221: ,OKC_K_HEADERS_ALL_B KH
3222: ,OKC_K_LINES_B CL
3223: ,OKC_STATUSES_B ST
3224: ,csi_counter_associations CTRASC
3225:
3250:
3251: cursor trm_usages_contracts1 IS
3252: Select CL.id
3253: From OKC_K_ITEMS KI
3254: ,OKC_K_HEADERS_ALL_B KH
3255: ,OKC_K_LINES_B CL
3256: ,OKC_STATUSES_B ST
3257: ,csi_counter_associations CTRASC
3258: ,oks_instance_k_dtls_temp temp
3286:
3287: cursor spl_upd_contracts IS
3288: Select CL.id
3289: From OKC_K_ITEMS KI
3290: ,OKC_K_HEADERS_ALL_B KH
3291: ,OKC_K_LINES_B KL
3292: ,OKC_K_LINES_B CL
3293: ,OKC_STATUSES_b ST
3294: Where
3309: spl_upd_contracts_rec spl_upd_contracts%rowtype;
3310: cursor rin_contracts IS
3311: Select cl.id
3312: From OKC_K_ITEMS KI
3313: ,OKC_K_HEADERS_ALL_B KH
3314: ,OKC_K_LINES_B CL
3315: Where
3316: KI.Jtot_Object1_code = 'OKX_CUSTPROD'
3317: AND KI.object1_id1 = to_char(p_instance_id)