[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT ART.ARS_CODE
FROM OKL_ASSET_RETURNS_B ART
WHERE ART.kle_id = p_kle_id
AND ART.ARS_CODE <> 'CANCELLED';
SELECT CLET_FIN.name asset_number,
MTL.description item_number,
CLET_FIN.item_description item_description ,
CSI.instance_number install_base_number,
CSI.serial_number serial_number,
CSI.quantity asset_quantity
FROM CSI_ITEM_INSTANCES CSI,
OKC_K_ITEMS CIM_IB,
OKC_LINE_STYLES_B LSE_IB,
OKC_K_LINES_B CLE_IB,
OKC_LINE_STYLES_B LSE_INST,
OKC_K_LINES_B CLE_INST,
OKC_LINE_STYLES_B LSE_MODEL,
OKC_K_LINES_B CLE_MODEL,
OKC_K_ITEMS CIM_MODEL,
MTL_SYSTEM_ITEMS MTL,
OKC_LINE_STYLES_B LSE_FIN,
OKC_K_LINES_TL CLET_FIN,
OKC_K_LINES_B CLE_FIN
WHERE CLE_FIN.id = CLET_FIN.id
AND CLET_FIN.LANGUAGE = USERENV('LANG')
AND LSE_FIN.id = CLE_FIN.lse_id
AND LSE_FIN.lty_code = 'FREE_FORM1'
AND CLE_INST.cle_id = CLE_FIN.id
AND CLE_INST.dnz_chr_id = CLE_FIN.dnz_chr_id
AND CLE_INST.lse_id = LSE_INST.id
AND LSE_INST.lty_code = 'FREE_FORM2'
AND CLE_IB.cle_id = CLE_INST.id
AND CLE_IB.dnz_chr_id = CLE_FIN.dnz_chr_id
AND CLE_IB.lse_id = LSE_IB.id
AND LSE_IB.lty_code = 'INST_ITEM'
AND CIM_IB.cle_id = CLE_IB.id
AND CIM_IB.dnz_chr_id = CLE_IB.dnz_chr_id
AND CIM_IB.object1_id1 = CSI.instance_id (+)
-- AND CIM_IB.object1_id2 = '#'
AND CIM_IB.jtot_object1_code = 'OKX_IB_ITEM'
AND CLE_FIN.id = CLE_MODEL.cle_id
AND CLE_MODEL.lse_id = LSE_MODEL.id
AND LSE_MODEL.lty_code = 'ITEM'
AND CLE_MODEL.id = CIM_MODEL.cle_id
AND CIM_MODEL.object1_id1 = MTL.inventory_item_id
AND CIM_MODEL.object1_id2 = TO_NUMBER(MTL.organization_id)
AND CLE_FIN.id = p_kle_id;
SELECT DISTINCT LNK_SRV_CIM.object1_id1 asset_id
FROM OKC_K_HEADERS_B OKS_CHRB,
OKC_LINE_STYLES_B OKS_COV_PD_LSE,
OKC_K_LINES_B OKS_COV_PD_CLEB,
OKC_K_REL_OBJS KREL,
OKC_LINE_STYLES_B LNK_SRV_LSE,
OKC_STATUSES_B LNK_SRV_STS,
OKC_K_LINES_B LNK_SRV_CLEB,
OKC_K_ITEMS LNK_SRV_CIM,
OKC_K_LINES_B FIN_LINE
WHERE OKS_CHRB.scs_code = 'SERVICE'
AND OKS_CHRB.id = OKS_COV_PD_CLEB.dnz_chr_id
AND OKS_COV_PD_CLEB.lse_id = OKS_COV_PD_LSE.id
AND OKS_COV_PD_LSE.lty_code = 'COVER_PROD'
AND '#' = KREL.object1_id2
AND OKS_COV_PD_CLEB.id = KREL.object1_id1
AND KREL.rty_code = 'OKLSRV'
AND KREL.cle_id = LNK_SRV_CLEB.id
AND LNK_SRV_CLEB.lse_id = LNK_SRV_LSE.id
AND LNK_SRV_LSE.lty_code = 'LINK_SERV_ASSET'
AND LNK_SRV_CLEB.sts_code = LNK_SRV_STS.code
AND LNK_SRV_CLEB.id = LNK_SRV_CIM.cle_id
AND LNK_SRV_CIM.jtot_object1_code = 'OKX_COVASST'
AND LNK_SRV_CIM.object1_id2 = '#'
AND LNK_SRV_CIM.object1_id1 = FIN_LINE.id
AND FIN_LINE.dnz_chr_id = p_khr_id;
SELECT DISTINCT LNK_SRV_CIM.object1_id1 asset_id
FROM OKC_K_HEADERS_B OKS_CHRB,
OKC_LINE_STYLES_B OKS_COV_PD_LSE,
OKC_K_LINES_B OKS_COV_PD_CLEB,
OKC_K_REL_OBJS KREL,
OKC_LINE_STYLES_B LNK_SRV_LSE,
OKC_STATUSES_B LNK_SRV_STS,
OKC_K_LINES_B LNK_SRV_CLEB,
OKC_K_ITEMS LNK_SRV_CIM,
OKC_K_LINES_B FIN_LINE,
OKL_TXL_QUOTE_LINES_B TQL
WHERE OKS_CHRB.scs_code = 'SERVICE'
AND OKS_CHRB.id = OKS_COV_PD_CLEB.dnz_chr_id
AND OKS_COV_PD_CLEB.lse_id = OKS_COV_PD_LSE.id
AND OKS_COV_PD_LSE.lty_code = 'COVER_PROD'
AND '#' = KREL.object1_id2
AND OKS_COV_PD_CLEB.id = KREL.object1_id1
AND KREL.rty_code = 'OKLSRV'
AND KREL.cle_id = LNK_SRV_CLEB.id
AND LNK_SRV_CLEB.lse_id = LNK_SRV_LSE.id
AND LNK_SRV_LSE.lty_code = 'LINK_SERV_ASSET'
AND LNK_SRV_CLEB.sts_code = LNK_SRV_STS.code
AND LNK_SRV_CLEB.id = LNK_SRV_CIM.cle_id
AND LNK_SRV_CIM.jtot_object1_code = 'OKX_COVASST'
AND LNK_SRV_CIM.object1_id2 = '#'
AND LNK_SRV_CIM.object1_id1 = FIN_LINE.id
AND FIN_LINE.id = TQL.kle_id
AND TQL.qlt_code = 'AMCFIA'
AND TQL.qte_id = p_qte_id;
p_oks_contract IN VARCHAR2 DEFAULT NULL, --RMUNJULU 23-DEC-03 SERVICE K UPDATES
p_transaction_date IN DATE) IS
l_parameter_list WF_PARAMETER_LIST_T;
SELECT okl_wf_item_s.nextval
FROM DUAL;
l_parameter_list.DELETE;
SELECT CHR.contract_number
FROM OKC_K_HEADERS_B CHR
WHERE CHR.id = p_okl_khr_id;
SELECT CHR.contract_number
FROM OKC_K_HEADERS_B CHR
WHERE CHR.id = p_oks_khr_id;
SELECT CLE.dnz_chr_id
FROM OKC_K_LINES_B CLE
WHERE CLE.id = p_id;