431: CSI.serial_number serial_number,
432: CSI.quantity asset_quantity
433: FROM CSI_ITEM_INSTANCES CSI,
434: OKC_K_ITEMS CIM_IB,
435: OKC_LINE_STYLES_B LSE_IB,
436: OKC_K_LINES_B CLE_IB,
437: OKC_LINE_STYLES_B LSE_INST,
438: OKC_K_LINES_B CLE_INST,
439: OKC_LINE_STYLES_B LSE_MODEL,
433: FROM CSI_ITEM_INSTANCES CSI,
434: OKC_K_ITEMS CIM_IB,
435: OKC_LINE_STYLES_B LSE_IB,
436: OKC_K_LINES_B CLE_IB,
437: OKC_LINE_STYLES_B LSE_INST,
438: OKC_K_LINES_B CLE_INST,
439: OKC_LINE_STYLES_B LSE_MODEL,
440: OKC_K_LINES_B CLE_MODEL,
441: OKC_K_ITEMS CIM_MODEL,
435: OKC_LINE_STYLES_B LSE_IB,
436: OKC_K_LINES_B CLE_IB,
437: OKC_LINE_STYLES_B LSE_INST,
438: OKC_K_LINES_B CLE_INST,
439: OKC_LINE_STYLES_B LSE_MODEL,
440: OKC_K_LINES_B CLE_MODEL,
441: OKC_K_ITEMS CIM_MODEL,
442: MTL_SYSTEM_ITEMS MTL,
443: OKC_LINE_STYLES_B LSE_FIN,
439: OKC_LINE_STYLES_B LSE_MODEL,
440: OKC_K_LINES_B CLE_MODEL,
441: OKC_K_ITEMS CIM_MODEL,
442: MTL_SYSTEM_ITEMS MTL,
443: OKC_LINE_STYLES_B LSE_FIN,
444: OKC_K_LINES_TL CLET_FIN,
445: OKC_K_LINES_B CLE_FIN
446: WHERE CLE_FIN.id = CLET_FIN.id
447: AND CLET_FIN.LANGUAGE = USERENV('LANG')
517: -- Get all serviced assets for the contract
518: CURSOR get_k_serviced_assets_csr (p_khr_id IN NUMBER) IS
519: SELECT DISTINCT LNK_SRV_CIM.object1_id1 asset_id
520: FROM OKC_K_HEADERS_B OKS_CHRB,
521: OKC_LINE_STYLES_B OKS_COV_PD_LSE,
522: OKC_K_LINES_B OKS_COV_PD_CLEB,
523: OKC_K_REL_OBJS KREL,
524: OKC_LINE_STYLES_B LNK_SRV_LSE,
525: OKC_STATUSES_B LNK_SRV_STS,
520: FROM OKC_K_HEADERS_B OKS_CHRB,
521: OKC_LINE_STYLES_B OKS_COV_PD_LSE,
522: OKC_K_LINES_B OKS_COV_PD_CLEB,
523: OKC_K_REL_OBJS KREL,
524: OKC_LINE_STYLES_B LNK_SRV_LSE,
525: OKC_STATUSES_B LNK_SRV_STS,
526: OKC_K_LINES_B LNK_SRV_CLEB,
527: OKC_K_ITEMS LNK_SRV_CIM,
528: OKC_K_LINES_B FIN_LINE
547: -- Get all serviced assets for the quote
548: CURSOR get_q_serviced_assets_csr (p_qte_id IN NUMBER) IS
549: SELECT DISTINCT LNK_SRV_CIM.object1_id1 asset_id
550: FROM OKC_K_HEADERS_B OKS_CHRB,
551: OKC_LINE_STYLES_B OKS_COV_PD_LSE,
552: OKC_K_LINES_B OKS_COV_PD_CLEB,
553: OKC_K_REL_OBJS KREL,
554: OKC_LINE_STYLES_B LNK_SRV_LSE,
555: OKC_STATUSES_B LNK_SRV_STS,
550: FROM OKC_K_HEADERS_B OKS_CHRB,
551: OKC_LINE_STYLES_B OKS_COV_PD_LSE,
552: OKC_K_LINES_B OKS_COV_PD_CLEB,
553: OKC_K_REL_OBJS KREL,
554: OKC_LINE_STYLES_B LNK_SRV_LSE,
555: OKC_STATUSES_B LNK_SRV_STS,
556: OKC_K_LINES_B LNK_SRV_CLEB,
557: OKC_K_ITEMS LNK_SRV_CIM,
558: OKC_K_LINES_B FIN_LINE,