[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT party_site_uses.country
FROM
OKC_K_LINES_B FREEFORM2_CLE,
OKC_LINE_STYLES_B FREEFORM2_LSE,
OKC_K_LINES_B INSTITEM_CLE,
OKC_LINE_STYLES_B INSTITEM_LSE,
OKL_TXL_ITM_INSTS OTITM ,
OKX_PARTY_SITE_USES_V PARTY_SITE_USES,
OKX_COUNTRIES_V OKX_COUNTRY
WHERE party_site_uses.country = okx_country.id1
AND party_site_uses.site_use_type = 'INSTALL_AT'
AND PARTY_SITE_USES.ID1 = OTITM.object_id1_new -- location
AND OTITM.OBJECT_ID2_NEW = PARTY_SITE_USES.ID2
AND OTITM.jtot_object_code_new = 'OKX_PARTSITE'
AND INSTITEM_CLE.ID = OTITM.KLE_ID
AND INSTITEM_CLE.CLE_ID = FREEFORM2_CLE.ID
AND INSTITEM_CLE.LSE_ID = INSTITEM_LSE.ID
AND INSTITEM_LSE.lty_code = 'INST_ITEM'
AND FREEFORM2_CLE.CLE_ID = p_k_financial_line
AND FREEFORM2_CLE.LSE_ID = FREEFORM2_LSE.ID
AND FREEFORM2_LSE.lty_code = 'FREE_FORM2' ;
select PARTY_SITES_USES.country
from
OKC_K_LINES_B instance_CLE,
OKC_LINE_STYLES_B instance_LS,
OKC_K_LINES_B IB_CLE,
OKC_LINE_STYLES_B IB_LS,
CSI_ITEM_INSTANCES INSTALL_BASE,
OKC_K_ITEMS INSTANCE_ITEM,
HZ_PARTY_SITES PARTY_SITES,
OKX_PARTY_SITE_USES_V PARTY_SITES_USES
WHERE
PARTY_SITES_USES.site_use_type = 'INSTALL_AT'
AND PARTY_SITES_USES.PARTY_SITE_ID = PARTY_SITES.PARTY_SITE_ID
AND PARTY_SITES.PARTY_SITE_ID = INSTALL_BASE.INSTALL_LOCATION_ID
AND INSTALL_BASE.INSTALL_LOCATION_TYPE_CODE = 'HZ_PARTY_SITES' -- Fix for Canon bug 3551010
AND INSTALL_BASE.instance_id = INSTANCE_ITEM.object1_id1 AND --Fix for 3837619
'#' = INSTANCE_ITEM.object1_id2 AND
INSTANCE_ITEM.CLE_ID = IB_CLE.ID
and IB_LS.LTY_CODE = 'INST_ITEM'
AND IB_LS.ID = IB_CLE.LSE_ID
AND IB_CLE.cle_id = instance_CLE.ID
AND instance_LS.LTY_CODE = 'FREE_FORM2'
AND instance_LS.ID = instance_CLE.LSE_ID
AND instance_CLE.cle_id = p_k_financial_line
union
select HZ_LOCATIONS.country
from
OKC_K_LINES_B instance_CLE,
OKC_LINE_STYLES_B instance_LS,
OKC_K_LINES_B IB_CLE,
OKC_LINE_STYLES_B IB_LS,
CSI_ITEM_INSTANCES INSTALL_BASE,
OKC_K_ITEMS INSTANCE_ITEM,
HZ_LOCATIONS HZ_LOCATIONS
WHERE
HZ_LOCATIONS.LOCATION_ID = INSTALL_BASE.INSTALL_LOCATION_ID
AND INSTALL_BASE.INSTALL_LOCATION_TYPE_CODE = 'HZ_LOCATIONS' -- Fix for Canon bug 3551010
AND INSTALL_BASE.instance_id = INSTANCE_ITEM.object1_id1 AND --Fix for Bug 3837619
'#' = INSTANCE_ITEM.object1_id2 AND
INSTANCE_ITEM.CLE_ID = IB_CLE.ID
and IB_LS.LTY_CODE = 'INST_ITEM'
AND IB_LS.ID = IB_CLE.LSE_ID
AND IB_CLE.cle_id = instance_CLE.ID
AND instance_LS.LTY_CODE = 'FREE_FORM2'
AND instance_LS.ID = instance_CLE.LSE_ID
AND instance_CLE.cle_id = p_k_financial_line ;
SELECT 'X'
FROM fnd_lookups fndlup
WHERE fndlup.lookup_type = p_lookup_type
AND fndlup.lookup_code = p_lookup_code
AND l_sysdate BETWEEN
NVL(fndlup.start_date_active,l_sysdate)
AND NVL(fndlup.end_date_active,l_sysdate);
l_select_result VARCHAR2(1) := '?';
SELECT 'S'
FROM hr_all_organization_units hou -- gboomina modified for Bug 6691305
WHERE hou.organization_id = TO_NUMBER(p_org_id)
AND l_sysdate BETWEEN NVL (hou.date_from, l_sysdate)
AND NVL (hou.date_to, l_sysdate);
FETCH C1 INTO l_select_result;
IF l_select_result ='?' THEN
l_result := Okl_Api.G_RET_STS_ERROR;
SELECT DECODE(c_table_name,'OKL_LEASE_QUOTES_B',LSEQTE_SEQ_PREFIX_TXT,'OKL_QUICK_QUOTES_B',QCKQTE_SEQ_PREFIX_TXT,'OKL_LEASE_OPPORTUNITIES_B',LSEOPP_SEQ_PREFIX_TXT,'OKL_LEASE_APPLICATIONS_B',LSEAPP_SEQ_PREFIX_TXT)
FROM okl_system_params;
l_seq_stmt := 'SELECT ' || p_seq_name || '.NEXTVAL FROM DUAL';
l_query_stmt := 'SELECT ' ||
p_col_name ||
' FROM ' ||
p_table_name ||
' WHERE '||
p_col_name || ' = :1 ';
SELECT DECODE(c_table_name,'OKL_LEASE_QUOTES_B',LSEQTE_SEQ_PREFIX_TXT,'OKL_QUICK_QUOTES_B',QCKQTE_SEQ_PREFIX_TXT,'OKL_LEASE_OPPORTUNITIES_B',LSEOPP_SEQ_PREFIX_TXT,'OKL_LEASE_APPLICATIONS_B',LSEAPP_SEQ_PREFIX_TXT)
FROM okl_system_params;
l_query_stmt := 'SELECT ' ||
p_col_name ||
' FROM ' ||
p_table_name ||
' WHERE '||
p_col_name || ' = :1 ';