[Home] [Help]
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
1248: ,OKC_K_ITEMS KIS
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
1353: ,OKC_K_ITEMS KIS
1354: ,OKC_K_PARTY_ROLES_B PARTY
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
1456: ,OKS_INSTANCE_TEMP tmp
1457: ,OKC_K_ITEMS KIS
1458: ,OKC_K_PARTY_ROLES_B PARTY
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
1556: ,OKC_K_ITEMS KIS
1557: ,OKC_K_PARTY_ROLES_B PARTY
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
1658: , OKS_INSTANCE_TEMP tmp
1659: ,OKC_K_ITEMS KIS
1660: ,OKC_K_PARTY_ROLES_B PARTY
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
1761: ,OKC_K_ITEMS KIS
1762: Where tmp.idc = 'Y'
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
1838: ,OKC_K_ITEMS KIS
1839: , OKS_K_LINES_B OKL
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
1919: ,OKC_K_ITEMS KIS
1920: , OKS_K_LINES_B OKL
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
2000: , OKC_K_ITEMS KIS
2001: , OKS_K_LINES_B OKL
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:
3140: Where
3141: KI.Jtot_Object1_code = 'OKX_CUSTPROD'
3142: AND KI.object1_id1 = to_char(p_instance_id)
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 )
3164: And KH.scs_code in ('WARRANTY','SERVICE','SUBSCRIPTION' )
3165: And KI.Cle_id = CL.id
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'
3193: AND KI.object1_id1 = to_char(temp.instance_id)
3194: And KH.scs_code in ('WARRANTY','SERVICE','SUBSCRIPTION' )
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:
3226: where KI.object1_id1 = to_char(CTRASC.COunter_id)
3227: And KI.jtot_object1_code = 'OKX_COUNTER'
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
3259: where KI.object1_id1 = to_char(CTRASC.COunter_id)
3260: And KI.jtot_object1_code = 'OKX_COUNTER'
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
3295: KI.Jtot_Object1_code = 'OKX_CUSTPROD'
3296: AND KI.object1_id1 = to_char(p_instance_id)
3297: And KI.dnz_chr_id = KH.ID