[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT msite_id, msite_root_section_id FROM jtf_msites_b
WHERE UPPER(master_msite_flag) = 'Y';
Is Select msite_id,msite_root_section_id
From jtf_msites_b
Where access_name = p_access_name
-- And store_id > 0
And master_msite_flag = 'N'
And sysdate BETWEEN start_date_active
And NVL(end_date_active,sysdate) ;
Is Select msite_root_section_id
From jtf_msites_b
Where msite_id = l_c_msite_id
-- And store_id > 0
And master_msite_flag = 'N'
And sysdate BETWEEN start_date_active
And NVL(end_date_active,sysdate) ;
OPEN x_minisite_cur FOR SELECT msite_id,default_language_code,
default_currency_code,default_org_id,
walkin_allowed_flag,msite_root_section_id,
master_msite_flag,atp_check_flag ,
default_date_format,profile_id,
access_name, resp_access_flag, party_access_code,
attribute1,attribute2,attribute3,attribute4,
attribute5,attribute6,attribute7,attribute8,
attribute9,attribute10,attribute11,attribute12,
attribute13,attribute14,attribute15
FROM jtf_msites_b
WHERE msite_id = l_msite_id;
OPEN x_name_cur FOR SELECT a.language_code,
b.msite_name, b.msite_description
FROM jtf_msite_languages a, jtf_msites_tl b
WHERE a.language_code = b.language
AND b.msite_id = a.msite_id
AND b.msite_id = l_msite_id;
OPEN x_lang_cur FOR SELECT language_code from jtf_msite_languages l
WHERE l.msite_id = l_msite_id;
OPEN x_currency_cur FOR SELECT currency_code, bizpartner_prc_listid,
registered_prc_listid, walkin_prc_listid, orderable_limit
FROM jtf_msite_currencies c
WHERE c.msite_id = l_msite_id;
OPEN x_sections_cur FOR 'SELECT child_section_id '
|| 'FROM jtf_dsp_msite_sct_sects '
|| 'WHERE mini_site_id = :master_mini_site_id AND '
|| 'sysdate BETWEEN start_date_active AND NVL(end_date_active,sysdate) '
|| 'AND child_section_id NOT IN '
|| '(SELECT child_section_id FROM jtf_dsp_msite_sct_sects '
|| 'WHERE mini_site_id = :msite_id) '
|| 'START WITH child_section_id = :root_section_id '
|| 'AND mini_site_id = :master_mini_site_id '
|| 'CONNECT BY PRIOR child_section_id = parent_section_id '
|| 'AND mini_site_id = :master_mini_site_id '
|| 'AND PRIOR mini_site_id = :master_mini_site_id '
USING x_master_msite_id, l_msite_id, l_root_section_id,
x_master_msite_id, x_master_msite_id, x_master_msite_id;
OPEN x_items_cur FOR 'SELECT inventory_item_id '
|| 'FROM jtf_dsp_section_items '
|| 'WHERE section_item_id IN '
|| '(SELECT section_item_id FROM jtf_dsp_section_items '
|| 'WHERE section_id IN '
|| '(SELECT child_section_id FROM jtf_dsp_msite_sct_sects '
|| 'WHERE mini_site_id = :master_mini_site_id '
|| 'AND child_section_id NOT IN '
|| '(SELECT child_section_id FROM jtf_dsp_msite_sct_sects '
|| 'WHERE mini_site_id = :msite_id) '
|| 'START WITH child_section_id = :root_section_id '
|| 'AND mini_site_id = :master_mini_site_id '
|| 'CONNECT BY PRIOR child_section_id = parent_section_id '
|| 'AND PRIOR mini_site_id = :master_mini_site_id '
|| 'AND mini_site_id = :master_mini_site_id) '
|| 'OR (section_id IN '
|| '(SELECT child_section_id FROM jtf_dsp_msite_sct_sects '
|| 'WHERE mini_site_id = :msite_id) '
|| 'AND section_item_id NOT IN '
|| '(SELECT section_item_id FROM jtf_dsp_msite_sct_items '
|| 'WHERE mini_site_id = :msite_id))) '
USING x_master_msite_id, l_msite_id, l_root_section_id,
x_master_msite_id, x_master_msite_id, x_master_msite_id,
l_msite_id, l_msite_id;
OPEN x_items_cur FOR select 0 from dual where sysdate < sysdate - 1;
OPEN x_sections_cur FOR select 0 from dual where sysdate < sysdate - 1;
OPEN x_msite_resps_cur FOR Select respb.msite_resp_id,
respb.responsibility_id ,
respb.application_id,
respt.language,
respt.display_name
From jtf_msite_resps_b respb ,
jtf_msite_resps_tl respt ,
jtf_msite_languages lang
Where respb.msite_id = l_msite_id
And respb.msite_resp_id = respt.msite_resp_id
And lang.msite_id = respb.msite_id
And lang.language_code = respt.language
And sysdate Between respb.start_date_Active
And NVL(respb.end_date_active,sysdate)
ORDER BY respb.msite_resp_id;
Open x_party_access_cur FOR Select Party_id
From jtf_msite_prty_accss accss
Where accss.msite_id = l_msite_id
And sysdate Between accss.start_date_Active
And NVL(accss.end_date_active,sysdate);
IS SELECT child_section_id
FROM jtf_dsp_msite_sct_sects
WHERE mini_site_id = l_c_master_msite_id AND
sysdate BETWEEN start_date_active AND NVL(end_date_active,sysdate)
AND child_section_id NOT IN
(SELECT child_section_id FROM jtf_dsp_msite_sct_sects
WHERE mini_site_id = l_c_msite_id)
START WITH child_section_id =
(SELECT msite_root_section_id FROM jtf_msites_b
WHERE msite_id = l_c_msite_id)
AND mini_site_id = l_c_master_msite_id
CONNECT BY PRIOR child_section_id = parent_section_id
AND mini_site_id = l_c_master_msite_id
AND PRIOR mini_site_id = l_c_master_msite_id;
IS SELECT inventory_item_id
FROM jtf_dsp_section_items
WHERE section_item_id IN
(SELECT section_item_id FROM jtf_dsp_section_items
WHERE section_id IN
(SELECT child_section_id FROM jtf_dsp_msite_sct_sects
WHERE mini_site_id = l_c_master_msite_id
AND child_section_id NOT IN
(SELECT child_section_id FROM jtf_dsp_msite_sct_sects
WHERE mini_site_id = l_c_msite_id)
START WITH child_section_id =
(SELECT msite_root_section_id FROM jtf_msites_b
WHERE msite_id = l_c_msite_id)
AND mini_site_id = l_c_master_msite_id
CONNECT BY PRIOR child_section_id = parent_section_id
AND PRIOR mini_site_id = l_c_master_msite_id
AND mini_site_id = l_c_master_msite_id)
OR (section_id IN
(SELECT child_section_id FROM jtf_dsp_msite_sct_sects
WHERE mini_site_id = l_c_msite_id)
AND section_item_id NOT IN
(SELECT section_item_id FROM jtf_dsp_msite_sct_items
WHERE mini_site_id = l_c_msite_id)));
IS SELECT msite_id FROM jtf_msites_b
WHERE sysdate BETWEEN start_date_active AND NVL(end_date_active, sysdate)
AND master_msite_flag = 'N';
OPEN x_minisite_cur FOR 'SELECT msite_id, default_language_code, '
|| 'default_currency_code, default_org_id, walkin_allowed_flag, '
|| 'msite_root_section_id, master_msite_flag, atp_check_flag, '
|| 'default_date_format, profile_id, access_name, resp_access_flag, '
|| 'party_access_code, attribute1, attribute2, attribute3, attribute4, '
|| 'attribute5, attribute6, attribute7, attribute8, attribute9, '
|| 'attribute10, attribute11, attribute12, attribute13, attribute14, '
|| 'attribute15 '
|| 'FROM jtf_msites_b MM WHERE '
|| l_tmp_str
|| 'ORDER BY msite_id';
OPEN x_name_cur FOR 'SELECT MM.msite_id, L.language_code, TL.msite_name, '
|| 'TL.msite_description '
|| 'FROM jtf_msite_languages L, jtf_msites_tl TL, jtf_msites_b MM WHERE '
|| 'L.language_code = TL.language AND '
|| 'L.msite_id = MM.msite_id AND '
|| 'TL.msite_id = MM.msite_id AND '
|| l_tmp_str
|| 'ORDER BY MM.msite_id';
OPEN x_lang_cur FOR 'SELECT MM.msite_id, L.language_code '
|| 'FROM jtf_msite_languages L, jtf_msites_b MM WHERE '
|| 'MM.msite_id = L.msite_id AND '
|| l_tmp_str
|| 'ORDER BY MM.msite_id';
OPEN x_currency_cur FOR 'SELECT MM.msite_id, C.currency_code, '
|| 'C.bizpartner_prc_listid,C.registered_prc_listid, C.walkin_prc_listid, '
|| 'C.orderable_limit '
|| 'FROM jtf_msite_currencies C, jtf_msites_b MM WHERE '
|| 'MM.msite_id = C.msite_id AND '
|| l_tmp_str
|| 'ORDER BY MM.msite_id';
OPEN x_msite_resps_cur FOR 'SELECT MM.msite_id, MRB.msite_resp_id, '
|| 'MRB.responsibility_id, MRB.application_id, MRTL.language, '
|| 'MRTL.display_name '
|| 'FROM jtf_msite_resps_b MRB, jtf_msite_resps_tl MRTL, '
|| 'jtf_msites_b MM WHERE '
|| 'MM.msite_id = MRB.msite_id AND '
|| 'MRB.msite_resp_id = MRTL.msite_resp_id AND '
|| 'sysdate BETWEEN MRB.start_date_active AND NVL(MRB.end_date_active,sysdate) AND '
|| l_tmp_str
|| 'ORDER BY MM.msite_id, MRB.msite_resp_id';
OPEN x_party_access_cur FOR 'SELECT MM.msite_id, party_id '
|| 'FROM jtf_msite_prty_accss MP, jtf_msites_b MM WHERE '
|| 'MM.msite_id = MP.msite_id AND '
|| 'sysdate BETWEEN MP.start_date_Active AND NVL(MP.end_date_active,sysdate) AND '
|| l_tmp_str
|| 'ORDER BY MM.msite_id';