[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT Hdr.Mapping_Header_Id,
hdr.effective_start_date,
hdr.effective_end_date,
hdr.application_id,
hdr.event_class_code,
hdr.analytical_criterion_code
FROM Ja_Cn_Cfs_Item_Mapping_Hdrs Hdr
WHERE Hdr.Application_Id = nvl(l_Application_Id,Hdr.Application_Id)
AND Hdr.Event_Class_Code = nvl(l_Event_Class_Code,Hdr.Event_Class_Code)
AND Hdr.Analytical_Criterion_Code = nvl(l_Analyciatl_Criterion_Code,Hdr.Analytical_Criterion_Code)
AND Hdr.Chart_Of_Accounts_Id = l_Chart_Of_Accounts_Id;
SELECT Ac_Value,
Detailed_Cfs_Item,
Effective_Start_Date,
Effective_End_Date,
org_id
FROM ja_cn_cfs_item_mapping_lines Lin
WHERE Lin.Mapping_Header_Id = l_Mapping_Header_Id;
SELECT NAME
FROM Hr_All_Organization_Units_Tl
WHERE Organization_Id = l_org_id
AND LANGUAGE = USERENV('LANG');
select Application_Name
from FND_APPLICATION_TL
where Application_Id = l_Application_Id
and LANGUAGE = USERENV('LANG');
select name
FROM xla_event_classes_TL
where Event_Class_Code = l_Event_Class_Code
and LANGUAGE = USERENV('LANG');
SELECT Ffvt.Description DESCRIPTION
FROM Fnd_Flex_Values_Tl Ffvt,Ja_Cn_Cfs_Item_Mapping_Lines JCCIM
WHERE Ffvt.Flex_Value_Meaning=JCCIM.DETAILED_CFS_ITEM
AND JCCIM.MAPPING_HEADER_ID=l_Mapping_Header_Id
and JCCIM.DETAILED_CFS_ITEM=l_detailed_cfs_item
and Ffvt.LANGUAGE = USERENV('LANG');*/
SELECT DISTINCT FFVT.DESCRIPTION DESCRIPTION
FROM FND_FLEX_VALUE_SETS FFVS
,FND_FLEX_VALUES_TL FFVT
,FND_FLEX_VALUES FFV
,Ja_Cn_Cfs_Item_Mapping_Lines JCCIML
,JA_CN_CASH_VALUESETS_ALL JCCVA
WHERE FFVS.FLEX_VALUE_SET_ID = FFV.FLEX_VALUE_SET_ID
AND JCCVA.CHART_OF_ACCOUNTS_ID = l_Chart_Of_Accounts_Id
AND JCCVA.FLEX_VALUE_SET_ID = FFVS.FLEX_VALUE_SET_ID
AND FFVT.FLEX_VALUE_ID = FFV.FLEX_VALUE_ID
AND FFV.FLEX_VALUE = JCCIML.DETAILED_CFS_ITEM
AND JCCIML.MAPPING_HEADER_ID=l_Mapping_Header_Id
and JCCIML.DETAILED_CFS_ITEM=l_detailed_cfs_item
AND FFVT.LANGUAGE = USERENV('LANG');
SELECT St.Name
FROM Ja_Cn_Cfs_Item_Mapping_Hdrs Cim,
Xla_Analytical_Hdrs_Tl Ah,
Xla_Analytical_Dtls_Tl Ad,
Xla_Analytical_Dtls_b Adl,
Xla_Analytical_Sources Sur,
Xla_Sources_tl st,
Xla_Event_Classes_Tl Ev,
Fnd_Application_Tl App
WHERE Cim.Application_Id = Sur.Source_Application_Id
AND Cim.Amb_Context_Code = Ah.Amb_Context_Code
AND cim.analytical_criterion_code = ah.analytical_criterion_code
AND cim.analytical_criterion_type_code = ah.analytical_criterion_type_code
AND Ah.Amb_Context_Code = Ad.Amb_Context_Code
AND ah.analytical_criterion_code = ad.analytical_criterion_code
AND ah.analytical_criterion_type_code = ad.analytical_criterion_type_code
AND Ah.Amb_Context_Code = Adl.Amb_Context_Code
AND ah.analytical_criterion_code = adl.analytical_criterion_code
AND ah.analytical_criterion_type_code = adl.analytical_criterion_type_code
AND adl.grouping_order = 1
AND adl.analytical_detail_code = ad.analytical_detail_code
AND Ah.Analytical_Criterion_Code = Sur.Analytical_Criterion_Code
AND ah.amb_context_code = sur.amb_context_code
AND ah.analytical_criterion_type_code = sur.analytical_criterion_type_code
AND ad.analytical_detail_code = sur.analytical_detail_code
AND cim.application_id = sur.application_id
AND app.application_id = cim.application_id
AND st.Application_Id = App.Application_Id
AND st.Source_Code = Sur.Source_Code
AND st.Source_Type_Code = Sur.Source_Type_Code
AND sur.application_id = ev.application_id
AND sur.entity_code = ev.entity_code
AND sur.event_class_code = ev.event_class_code
AND App.LANGUAGE = Userenv('LANG')
AND Ev.LANGUAGE = Userenv('LANG')
AND Ah.LANGUAGE = Userenv('LANG')
AND Ad.LANGUAGE = Userenv('LANG')
AND st.language = Userenv('LANG')
AND Cim.Mapping_Header_Id= l_Mapping_Header_Id;
SELECT XMLELEMENT("P_APPLICATION_NAME",l_Application_Name) INTO l_xml_item FROM dual;
SELECT XMLELEMENT("P_SUPPORTING_REFERENCE_CODE",l_Analyciatl_Criterion_Code ) INTO l_xml_item FROM dual;
SELECT XMLCONCAT(l_xml_parameter,l_xml_item) INTO l_xml_parameter FROM dual;
SELECT XMLELEMENT("P_EVENT_CLASS_NAME",l_Event_Class_Name) INTO l_xml_item FROM dual;
SELECT XMLCONCAT(l_xml_parameter,l_xml_item) INTO l_xml_parameter FROM dual;
SELECT XMLCONCAT(l_xml_report,l_xml_parameter) INTO l_xml_report FROM dual;
SELECT XMLELEMENT("APPLICATION_NAME",l_Application_Name) INTO l_xml_item FROM dual;
SELECT XMLELEMENT("EVENT_CLASS_NAME",l_Event_Class_Name) INTO l_xml_item FROM dual;
SELECT XMLCONCAT(l_xml_head,l_xml_item) INTO l_xml_head FROM dual;
SELECT XMLELEMENT("SUPPORTING_REFERENCE_CODE",l_Analyciatl_Criterion_Code) INTO l_xml_item FROM dual;
SELECT XMLCONCAT(l_xml_head,l_xml_item) INTO l_xml_head FROM dual;
SELECT XMLELEMENT("SOURCE_NAME",l_source_name) INTO l_xml_item FROM dual;
SELECT XMLCONCAT(l_xml_head,l_xml_item) INTO l_xml_head FROM dual;
SELECT XMLELEMENT("H_EFFECTIVE_START_DATE",l_h_effective_start_date) INTO l_xml_item FROM dual;
SELECT XMLCONCAT(l_xml_head,l_xml_item) INTO l_xml_head FROM dual;
SELECT XMLELEMENT("H_EFFECTIVE_END_DATE",l_h_effective_end_date) INTO l_xml_item FROM dual;
SELECT XMLCONCAT(l_xml_head,l_xml_item) INTO l_xml_head FROM dual;
SELECT XMLCONCAT(l_xml_head_line,l_xml_head) INTO l_xml_head_line FROM dual;
SELECT XMLELEMENT("ORG_NAME",l_org_name) INTO l_xml_item FROM dual;
SELECT XMLELEMENT("AC_VALUE",l_ac_value) INTO l_xml_item FROM dual;
SELECT XMLCONCAT(l_xml_line,l_xml_item) INTO l_xml_line FROM dual;
SELECT XMLELEMENT("DETAILED_CFS_ITEM",l_detailed_cfs_item) INTO l_xml_item FROM dual;
SELECT XMLCONCAT(l_xml_line,l_xml_item) INTO l_xml_line FROM dual;
SELECT XMLELEMENT("DETAILED_ITEM_DESC",l_cash_flow_item_desc) INTO l_xml_item FROM dual;
SELECT XMLCONCAT(l_xml_line,l_xml_item) INTO l_xml_line FROM dual;
SELECT XMLELEMENT("EFFECTIVE_START_DATE",l_effective_start_date) INTO l_xml_item FROM dual;
SELECT XMLCONCAT(l_xml_line,l_xml_item) INTO l_xml_line FROM dual;
SELECT XMLELEMENT("EFFECTIVE_END_DATE",l_effective_end_date ) INTO l_xml_item FROM dual;
SELECT XMLCONCAT(l_xml_line,l_xml_item) INTO l_xml_line FROM dual;
SELECT XMLELEMENT("LINE",l_xml_line) INTO l_xml_line FROM dual;--line circulation
SELECT XMLCONCAT(l_xml_head_line,l_xml_line) INTO l_xml_head_line FROM dual;
SELECT XMLELEMENT("HEAD",l_xml_head_line) INTO l_xml_item FROM dual;--head circulation
SELECT XMLCONCAT(l_xml_report,l_xml_item) INTO l_xml_report FROM dual;
SELECT XMLELEMENT( "REPORT",l_xml_report) INTO l_xml_root FROM dual;--generate the whole report.