[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT count(*)
FROM OKL_ASSET_RETURNS_V
WHERE ID= c_art_id;
SELECT count(*)
FROM OKL_ASSET_RETURNS_V OARV,
OKL_AM_REMARKET_TEAMS_UV ORTU
WHERE OARV.ID= c_art_id
AND OARV.RMR_ID = ORTU.ORIG_SYSTEM_ID;
/* SELECT OAR.LAST_UPDATED_BY, AD.CHR_ID CHR_ID,
AD.ITEM_DESCRIPTION ASSET_DESCRIPTION,
AD.CONTRACT_NUMBER CONTRACT_NUMBER, AD.NAME ASSET_NUMBER,
AD.SERIAL_NUMBER SERIAL_NUMBER, AD.MODEL_NUMBER MODEL_NUMBER,
OAR.DATE_REPOSSESSION_ACTUAL DATE_RETURNED, AD.ID KLE_ID,
OAR.COMMENTS COMMENTS
FROM
OKL_AM_ASSET_DETAILS_UV AD,
OKL_ASSET_RETURNS_V OAR
WHERE
AD.ID = OAR.KLE_ID
AND oar.id = c_art_id; */
SELECT
OAR.LAST_UPDATED_BY ,
CLEV.CHR_ID CHR_ID ,
CLEV.ITEM_DESCRIPTION ASSET_DESCRIPTION ,
OKHV.CONTRACT_NUMBER CONTRACT_NUMBER ,
CLEV.NAME ASSET_NUMBER ,
OALV.SERIAL_NUMBER SERIAL_NUMBER ,
OALV.MODEL_NUMBER MODEL_NUMBER ,
OAR.DATE_REPOSSESSION_ACTUAL DATE_RETURNED ,
CLEV.ID KLE_ID ,
OAR.RMR_ID RMR_ID,
OAR.COMMENTS COMMENTS
FROM OKC_K_LINES_V CLEV
,OKX_ASSET_LINES_V OALV
,OKC_K_HEADERS_ALL_B OKHV ,
OKL_ASSET_RETURNS_V OAR
WHERE CLEV.ID = OAR.KLE_ID
AND CLEV.ID = OALV.PARENT_LINE_ID(+)
AND CLEV.CHR_ID = OKHV.ID
AND CLEV.STS_CODE <> 'ABANDONED'
AND OAR.ID = c_art_id;
, p_user_id => l_asset_return.last_updated_by
, x_name => l_user
, x_description => l_name);
avalue => to_char(l_asset_return.last_updated_by));
SELECT OAR.LAST_UPDATED_BY, KLE.CHR_ID CHR_ID,
OKC.CONTRACT_NUMBER CONTRACT_NUMBER, KLE.NAME ASSET_NUMBER,
OAR.DATE_RETURNED DATE_RETURNED, KLE.ID KLE_ID, OAR.RNA_ID AGENT_ID
FROM OKL_K_LINES_FULL_V KLE,
OKC_K_HEADERS_B OKC,
OKL_ASSET_RETURNS_B OAR
WHERE OKC.ID = KLE.CHR_ID
AND OAR.KLE_ID = KLE.ID
AND oar.id = c_art_id
AND ART1_CODE ='REPOS_REQUEST';
SELECT *
FROM OKX_VENDORS_V
WHERE ID1 = c_agent_id;
SELECT hzp.email_address email
FROM hz_parties hzp
WHERE hzp.party_id = p_recipient_id;
SELECT nvl(ppf.email_address , fu.email_address) email
FROM fnd_user fu,
per_people_f ppf
WHERE fu.employee_id = ppf.person_id (+)
AND fu.user_id = c_agent_id;
, p_user_id => l_asset_return.last_updated_by
, x_name => l_user
, x_description => l_name);
avalue => to_char(l_asset_return.LAST_UPDATED_BY));
OPEN c_agent_csr(l_asset_return.last_updated_by);
SELECT OAR.LAST_UPDATED_BY,
OAR.DATE_REPOSSESSION_ACTUAL DATE_RETURNED,
OAR.RMR_ID RMR_ID,
OAR.COMMENTS COMMENTS,
OAR.KLE_ID KLE_ID
FROM OKL_ASSET_RETURNS_V OAR
WHERE OAR.ID = c_art_id;
SELECT AD.CHR_ID CHR_ID,
AD.ITEM_DESCRIPTION ASSET_DESCRIPTION,
AD.CONTRACT_NUMBER CONTRACT_NUMBER, AD.NAME ASSET_NUMBER,
AD.SERIAL_NUMBER SERIAL_NUMBER, AD.MODEL_NUMBER MODEL_NUMBER,
AD.ID KLE_ID
FROM OKL_AM_ASSET_DETAILS_UV AD
WHERE AD.ID = c_kle_id;
SELECT count(*)
FROM jtf_rs_teams_vl t,
jtf_rs_role_relations_vl jtfr,
jtf_rs_Resource_extns a,
jtf_rs_Team_Members b,
jtf_rs_Groups_b d,
jtf_rs_resource_extns re,
wf_users wu
WHERE t.team_id = c_team_id
AND nvl (t.start_date_active, sysdate - 1) <= sysdate
AND nvl (t.end_date_active, sysdate + 1) >= sysdate
AND jtfr.role_code = 'REMARKETER'
AND role_resource_type = 'RS_TEAM'
AND jtfr.role_resource_id = t.team_id
AND t.team_id = b.Team_Id
AND (DECODE(b.Resource_Type,'INDIVIDUAL',a.Resource_Number,
d.Group_Number)) = re.resource_number
AND b.Team_Resource_Id = a.Resource_Id (+)
AND b.Team_Resource_Id = d.Group_Id (+)
AND re.source_id = wu.orig_system_id
AND re.user_name = wu.name; -- mdokal : Bug 3562321
avalue => to_char(l_asset_return.LAST_UPDATED_BY));
SELECT wu.name, wu.display_name
FROM jtf_rs_teams_vl t,
jtf_rs_role_relations_vl jtfr,
jtf_rs_Resource_extns a,
jtf_rs_Team_Members b,
jtf_rs_Groups_b d,
jtf_rs_resource_extns re,
wf_users WU
WHERE t.team_id = c_team_id
AND nvl (t.start_date_active, sysdate - 1) <= sysdate
AND nvl (t.end_date_active, sysdate + 1) >= sysdate
AND jtfr.role_code = 'REMARKETER'
AND role_resource_type = 'RS_TEAM'
AND jtfr.role_resource_id = t.team_id
AND t.team_id = b.Team_Id
AND (DECODE(b.Resource_Type,'INDIVIDUAL',a.Resource_Number,
d.Group_Number)) = re.resource_number
AND re.source_id = wu.orig_system_id
AND re.user_name = wu.name
AND b.Team_Resource_Id = a.Resource_Id (+)
AND b.Team_Resource_Id = d.Group_Id (+)
AND ROWNUM < c_current_user
AND wu.name > nvl(c_name, '0')
order by 1 asc;
SELECT ARS_CODE
FROM OKL_ASSET_RETURNS_V
WHERE ID= c_art_id
AND ARS_CODE IN ('REPOSSESSED', 'UNSUCCESS_REPO')
AND ART1_CODE = 'REPOS_REQUEST';
SELECT count(*)
FROM OKL_ASSET_RETURNS_V
WHERE ID= c_art_id
AND ART1_CODE = 'REPOS_REQUEST';
SELECT OAR.KLE_ID KLE_ID, KLE.CHR_ID CHR_ID, OAR.LAST_UPDATED_BY LAST_UPDATED_BY
FROM okl_asset_returns_b OAR, OKL_K_LINES_FULL_V KLE
WHERE OAR.KLE_ID = KLE.ID
AND OAR.ID= c_art_id;
SELECT hzp.email_address email
FROM hz_parties hzp
WHERE hzp.party_id = p_recipient_id;
SELECT nvl(ppf.email_address , fu.email_address) email
FROM fnd_user fu,
per_people_f ppf
WHERE fu.employee_id = ppf.person_id (+)
AND fu.user_id = c_agent_id;
avalue => l_art_rec.LAST_UPDATED_BY);
OPEN c_agent_csr(l_art_rec.last_updated_by);
SELECT ra.last_updated_by, cp.contact_party_id pac_id, contact_party_name
FROM okl_asset_returns_b ar
,okl_relocate_assets_b ra
,okl_am_contact_points_uv cp
,okl_am_contacts_uv c
WHERE ar.id = c_art_id
AND ar.id = ra.art_id
AND pac_id = cp.contact_contact_point_id
AND cp.contact_party_id = c.contact_party_id
AND ist_id IS NOT NULL;
SELECT hzp.email_address email
FROM hz_parties hzp
WHERE hzp.party_id = p_recipient_id;
SELECT nvl(ppf.email_address , fu.email_address) email
FROM fnd_user fu,
per_people_f ppf
WHERE fu.employee_id = ppf.person_id (+)
AND fu.user_id = c_agent_id;
, p_user_id => l_csr_rec.last_updated_by
, x_name => l_user_name
, x_description => l_name);
avalue => l_csr_rec.last_updated_by);
OPEN c_agent_csr(l_csr_rec.last_updated_by);
SELECT count(*)
FROM OKL_ASSET_CNDTNS ACD, OKL_ASSET_CNDTN_LNS_V ACN
WHERE ACD.ID = c_id
AND ACD.ID = ACN.ACD_ID
AND upper(nvl(ACN.APPROVED_YN, 'N')) <> 'Y'
AND ACN.ACS_CODE = 'WAITING_FOR_APPROVAL';
SELECT ACN.ID id
FROM OKL_ASSET_CNDTNS ACD,
OKL_ASSET_CNDTN_LNS_V ACN
WHERE ACD.ID = C_ID
AND ACD.ID = ACN.ACD_ID
AND nvl(UPPER(ACN.APPROVED_YN), 'N') <> 'Y'
AND ACN.ACS_CODE = 'WAITING_FOR_APPROVAL';
okl_acn_pvt.update_row( p_api_version => l_api_version,
p_init_msg_list => l_init_msg_list,
x_return_status => l_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_acnv_rec => l_acnv_rec,
x_acnv_rec => x_acnv_rec);
/* SELECT ACN.LAST_UPDATED_BY LAST_UPDATED_BY,
AD.ASSET_NUMBER ASSET_NUMBER,
AD.ITEM_DESCRIPTION ASSET_DESCRIPTION,
AD.CONTRACT_NUMBER CONTRACT_NUMBER,
ACN.PART_NAME PART_NAME,
ACN.RECOMMENDED_REPAIR DETAILS,
FND1.MEANING CONDITION_TYPE,
FND2.MEANING DAMAGE_TYPE
FROM OKL_AM_ASSET_RETURNS_UV AD,
OKL_ASSET_CNDTNS ACD,
OKL_ASSET_CNDTN_LNS_V ACN,
FND_LOOKUPS FND1,
FND_LOOKUPS FND2
WHERE ACD.KLE_ID = AD.KLE_ID
AND ACD.ID = C_ID
AND ACD.ID = ACN.ACD_ID
AND upper(nvl(ACN.APPROVED_YN, 'N')) <> 'Y'
AND ACN.ACS_CODE = 'WAITING_FOR_APPROVAL'
AND FND1.LOOKUP_TYPE = 'OKL_ASSET_CONDITION'
AND FND1.LOOKUP_CODE = ACN.CDN_CODE
AND FND2.LOOKUP_TYPE = 'OKL_DAMAGE_TYPE'
AND FND2.LOOKUP_CODE = ACN.DTY_CODE;*/
SELECT ACNB.LAST_UPDATED_BY LAST_UPDATED_BY,
KLE.NAME ASSET_NUMBER,
KLE.ITEM_DESCRIPTION ASSET_DESCRIPTION,
OKC.CONTRACT_NUMBER CONTRACT_NUMBER,
ACNT.PART_NAME PART_NAME,
ACNT.RECOMMENDED_REPAIR DETAILS,
FND1.MEANING CONDITION_TYPE,
FND2.MEANING DAMAGE_TYPE
FROM OKL_ASSET_RETURNS_B OAR,
OKC_K_HEADERS_ALL_B OKC,
OKC_K_LINES_V KLE,
OKL_ASSET_CNDTNS_ALL ACD,
OKL_AST_CNDTN_LNS_ALL_B ACNB,
OKL_ASSET_CNDTN_LNS_TL ACNT,
FND_LOOKUPS FND1,
FND_LOOKUPS FND2
WHERE OKC.ID = KLE.CHR_ID
AND OAR.KLE_ID = KLE.ID
AND ACD.KLE_ID = OAR.KLE_ID
AND ACD.ID = c_id
AND ACNB.ID = ACNT.ID
AND ACNT.LANGUAGE = USERENV('LANG')
AND ACD.ID = ACNB.ACD_ID
AND UPPER(NVL(ACNB.APPROVED_YN, 'N')) <> 'Y'
AND ACNB.ACS_CODE = 'WAITING_FOR_APPROVAL'
AND FND1.LOOKUP_TYPE = 'OKL_ASSET_CONDITION'
AND FND1.LOOKUP_CODE = ACNB.CDN_CODE
AND FND2.LOOKUP_TYPE = 'OKL_DAMAGE_TYPE'
AND FND2.LOOKUP_CODE = ACNB.DTY_CODE;
l_updated_by NUMBER;
l_updated_by := l_asset_repair_rec.last_updated_by;
, p_user_id => l_updated_by
, x_name => l_user
, x_description => l_name);
/* SELECT OAR.LAST_UPDATED_BY LAST_UPDATED_BY,
AD.ITEM_DESCRIPTION ASSET_DESCRIPTION,
AD.NAME ASSET_NUMBER,
AD.CONTRACT_NUMBER CONTRACT_NUMBER,
AD.SERIAL_NUMBER SERIAL_NUMBER,
AD.MODEL_NUMBER MODEL_NUMBER,
OAR.COMMENTS COMMENTS
FROM OKL_AM_ASSET_DETAILS_UV AD, OKL_ASSET_RETURNS_V OAR
WHERE AD.ID = OAR.KLE_ID
AND OAR.ID = c_art_id;
SELECT OAR.LAST_UPDATED_BY LAST_UPDATED_BY,
AD.ITEM_DESCRIPTION ASSET_DESCRIPTION,
AD.NAME ASSET_NUMBER,
AD.CONTRACT_NUMBER CONTRACT_NUMBER,
AD.SERIAL_NUMBER SERIAL_NUMBER,
AD.MODEL_NUMBER MODEL_NUMBER,
OAR.COMMENTS COMMENTS,
C.CONTACT_PARTY_NAME CONTACT_NAME,
CP.CONTACT_DETAILS CONTACT_DETAILS
FROM OKL_AM_ASSET_DETAILS_UV AD,
OKL_ASSET_RETURNS_V OAR,
OKL_RELOCATE_ASSETS_V ORA,
OKL_AM_CONTACT_POINTS_UV CP,
OKL_AM_CONTACTS_UV C
WHERE AD.ID = OAR.KLE_ID
AND OAR.ID = c_art_id
AND OAR.ID = ORA.ART_ID
AND ORA.PAC_ID = CP.CONTACT_CONTACT_POINT_ID
AND CP.CONTACT_PARTY_ID = C.CONTACT_PARTY_ID;
p_user_id => l_asset_return.last_updated_by,
x_name => l_requester,
x_description => l_name);
SELECT count(1)
FROM OKL_PRTFL_CNTRCTS_B PFC
WHERE PFC.KHR_ID = c_id;
SELECT TEAM_NAME ASSIGNMENT_GROUP,
AD.CONTRACT_NUMBER CONTRACT_NUMBER,
FND.MEANING STRATEGY,
PFCL.BUDGET_AMOUNT BUDGET,
PFCL.DATE_STRATEGY_EXECUTION_DUE EXECUTION_DATE,
PFC.LAST_UPDATED_BY LAST_UPDATED_BY
FROM OKL_PRTFL_CNTRCTS_B PFC,
OKL_PRTFL_LINES_V PFCL,
OKC_K_HEADERS_V AD,
FND_LOOKUPS FND,
JTF_RS_TEAMS_VL T
WHERE PFC.KHR_ID = c_id
AND PFC.ID = PFCL.PFC_ID
AND AD.ID = PFC.KHR_ID
AND ASSET_TRACK_STRATEGY_CODE = FND.LOOKUP_CODE
AND FND.LOOKUP_TYPE = 'OKL_ASSET_TRACK_STRATEGIES'
AND TMB_ID = T.TEAM_ID;
, p_user_id => l_pfc_rec.last_updated_by
, x_name => l_user_name
, x_description => l_name);
SELECT PFCL.ID ID
FROM OKL_PRTFL_LINES_B PFCL,
OKL_PRTFL_CNTRCTS_B PFC
WHERE PFC.KHR_ID = c_id
AND PFC.ID = PFCL.PFC_ID;
okl_prtfl_lines_pub.update_prtfl_lines(
p_api_version => l_api_version,
p_init_msg_list => l_init_msg_list,
x_return_status => l_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_pflv_rec => l_pflv_rec,
x_pflv_rec => x_pflv_rec);
SELECT TMB_ID,
AD.CONTRACT_NUMBER CONTRACT_NUMBER,
FND.MEANING STRATEGY,
PFCL.BUDGET_AMOUNT BUDGET,
PFCL.DATE_STRATEGY_EXECUTION_DUE EXECUTION_DATE,
PFC.LAST_UPDATED_BY LAST_UPDATED_BY
FROM OKL_PRTFL_CNTRCTS_B PFC,
OKL_PRTFL_LINES_V PFCL,
OKC_K_HEADERS_V AD,
FND_LOOKUPS FND
WHERE PFC.KHR_ID = c_id
AND PFC.ID = PFCL.PFC_ID
AND AD.ID = PFC.KHR_ID
AND ASSET_TRACK_STRATEGY_CODE = FND.LOOKUP_CODE
AND FND.LOOKUP_TYPE = 'OKL_ASSET_TRACK_STRATEGIES';
SELECT count(1)
FROM jtf_rs_teams_b t,
jtf_rs_role_relations_vl jtfr,
jtf_rs_Resource_extns a,
jtf_rs_Team_Members b,
jtf_rs_Groups_b d,
jtf_rs_resource_extns re,
wf_users WU
WHERE
t.team_id = c_team_id
AND nvl (t.start_date_active, sysdate - 1) <= sysdate
AND nvl (t.end_date_active, sysdate + 1) >= sysdate
AND jtfr.role_code = 'PORTFOLIO_GROUP'
AND role_resource_type = 'RS_TEAM'
AND jtfr.role_resource_id = t.team_id
AND t.team_id = b.Team_Id
AND (DECODE(b.Resource_Type,'INDIVIDUAL',a.Resource_Number,
d.Group_Number)) = re.resource_number
AND b.Team_Resource_Id = a.Resource_Id (+)
AND b.Team_Resource_Id = d.Group_Id (+)
AND re.user_name = wu.name
AND re.source_id = wu.orig_system_id;
,p_user_id => l_pfc_rec.last_updated_by
,x_name => l_user_name
,x_description => l_name);
SELECT wu.name, wu.display_name
FROM jtf_rs_teams_vl t,
jtf_rs_role_relations_vl jtfr,
jtf_rs_Resource_extns a,
jtf_rs_Team_Members b,
jtf_rs_Groups_b d,
jtf_rs_resource_extns re,
wf_users WU
WHERE t.team_id = c_team_id
AND nvl (t.start_date_active, sysdate - 1) <= sysdate
AND nvl (t.end_date_active, sysdate + 1) >= sysdate
AND jtfr.role_code = 'PORTFOLIO_GROUP'
AND role_resource_type = 'RS_TEAM'
AND jtfr.role_resource_id = t.team_id
AND t.team_id = b.Team_Id
AND (DECODE(b.Resource_Type,'INDIVIDUAL',a.Resource_Number,
d.Group_Number)) = re.resource_number
AND b.Team_Resource_Id = a.Resource_Id (+)
AND b.Team_Resource_Id = d.Group_Id (+)
AND re.source_id = wu.orig_system_id
AND re.user_name = wu.name
AND ROWNUM < c_current_user
AND wu.name > nvl(c_name, '0')
order by 1 asc;
l_last_updated_by NUMBER;
SELECT last_updated_by
FROM OKL_ASSET_RETURNS_V
WHERE ID= c_art_id;
FETCH okl_check_req_csr INTO l_last_updated_by;
p_user_id => l_last_updated_by,
x_name => l_requester,
x_description => l_description);
IF l_last_updated_by IS NULL THEN
resultout := 'COMPLETE:INVALID_RETURN';
select count(*)
from WF_USER_ROLES WUR
where WUR.ROLE_NAME = p_value;