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,
440: OKC_K_LINES_B CLE_MODEL,
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,
442: MTL_SYSTEM_ITEMS MTL,
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,
444: OKC_K_LINES_TL CLET_FIN,
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')
448: AND LSE_FIN.id = CLE_FIN.lse_id
449: AND LSE_FIN.lty_code = 'FREE_FORM1'
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,
526: OKC_K_LINES_B LNK_SRV_CLEB,
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
529: WHERE OKS_CHRB.scs_code = 'SERVICE'
530: AND OKS_CHRB.id = OKS_COV_PD_CLEB.dnz_chr_id
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
529: WHERE OKS_CHRB.scs_code = 'SERVICE'
530: AND OKS_CHRB.id = OKS_COV_PD_CLEB.dnz_chr_id
531: AND OKS_COV_PD_CLEB.lse_id = OKS_COV_PD_LSE.id
532: AND OKS_COV_PD_LSE.lty_code = 'COVER_PROD'
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,
556: OKC_K_LINES_B LNK_SRV_CLEB,
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,
559: OKL_TXL_QUOTE_LINES_B TQL
560: WHERE OKS_CHRB.scs_code = 'SERVICE'
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,
559: OKL_TXL_QUOTE_LINES_B TQL
560: WHERE OKS_CHRB.scs_code = 'SERVICE'
561: AND OKS_CHRB.id = OKS_COV_PD_CLEB.dnz_chr_id
562: AND OKS_COV_PD_CLEB.lse_id = OKS_COV_PD_LSE.id
785:
786: -- Get the asset details
787: CURSOR asset_dtls_csr ( p_id IN NUMBER) IS
788: SELECT CLE.dnz_chr_id
789: FROM OKC_K_LINES_B CLE
790: WHERE CLE.id = p_id;
791:
792: l_source VARCHAR2(100);
793: l_transaction_id VARCHAR2(100);