eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JA_CN_CFS_IMA_PKG dependencies on JA_CN_CFS_ITEM_MAPPING_LINES

Line 76: l_org_id ja_cn_cfs_item_mapping_lines.org_id%type;

72: l_h_effective_end_date Ja_Cn_Cfs_Item_Mapping_Hdrs.Effective_End_Date%type;
73: l_Application_Name FND_APPLICATION_TL.Application_Name%type;
74: l_Event_Class_Name xla_event_classes_TL.Name%type;
75: l_source_name Xla_Sources_tl.Name%type;
76: l_org_id ja_cn_cfs_item_mapping_lines.org_id%type;
77: l_org_name hr_all_organization_units_tl.name%type;
78: l_ac_value ja_cn_cfs_item_mapping_lines.ac_value%type;
79: l_detailed_cfs_item ja_cn_cfs_item_mapping_lines.detailed_cfs_item%type;
80: l_cash_flow_item_desc Fnd_Flex_Values_Tl.Description%type;

Line 78: l_ac_value ja_cn_cfs_item_mapping_lines.ac_value%type;

74: l_Event_Class_Name xla_event_classes_TL.Name%type;
75: l_source_name Xla_Sources_tl.Name%type;
76: l_org_id ja_cn_cfs_item_mapping_lines.org_id%type;
77: l_org_name hr_all_organization_units_tl.name%type;
78: l_ac_value ja_cn_cfs_item_mapping_lines.ac_value%type;
79: l_detailed_cfs_item ja_cn_cfs_item_mapping_lines.detailed_cfs_item%type;
80: l_cash_flow_item_desc Fnd_Flex_Values_Tl.Description%type;
81: l_effective_start_date Ja_Cn_Cfs_Item_Mapping_lines.Effective_Start_Date%type;
82: l_effective_end_date Ja_Cn_Cfs_Item_Mapping_lines.Effective_End_Date%type;

Line 79: l_detailed_cfs_item ja_cn_cfs_item_mapping_lines.detailed_cfs_item%type;

75: l_source_name Xla_Sources_tl.Name%type;
76: l_org_id ja_cn_cfs_item_mapping_lines.org_id%type;
77: l_org_name hr_all_organization_units_tl.name%type;
78: l_ac_value ja_cn_cfs_item_mapping_lines.ac_value%type;
79: l_detailed_cfs_item ja_cn_cfs_item_mapping_lines.detailed_cfs_item%type;
80: l_cash_flow_item_desc Fnd_Flex_Values_Tl.Description%type;
81: l_effective_start_date Ja_Cn_Cfs_Item_Mapping_lines.Effective_Start_Date%type;
82: l_effective_end_date Ja_Cn_Cfs_Item_Mapping_lines.Effective_End_Date%type;
83:

Line 81: l_effective_start_date Ja_Cn_Cfs_Item_Mapping_lines.Effective_Start_Date%type;

77: l_org_name hr_all_organization_units_tl.name%type;
78: l_ac_value ja_cn_cfs_item_mapping_lines.ac_value%type;
79: l_detailed_cfs_item ja_cn_cfs_item_mapping_lines.detailed_cfs_item%type;
80: l_cash_flow_item_desc Fnd_Flex_Values_Tl.Description%type;
81: l_effective_start_date Ja_Cn_Cfs_Item_Mapping_lines.Effective_Start_Date%type;
82: l_effective_end_date Ja_Cn_Cfs_Item_Mapping_lines.Effective_End_Date%type;
83:
84: l_varchar_test varchar2(4000);
85:

Line 82: l_effective_end_date Ja_Cn_Cfs_Item_Mapping_lines.Effective_End_Date%type;

78: l_ac_value ja_cn_cfs_item_mapping_lines.ac_value%type;
79: l_detailed_cfs_item ja_cn_cfs_item_mapping_lines.detailed_cfs_item%type;
80: l_cash_flow_item_desc Fnd_Flex_Values_Tl.Description%type;
81: l_effective_start_date Ja_Cn_Cfs_Item_Mapping_lines.Effective_Start_Date%type;
82: l_effective_end_date Ja_Cn_Cfs_Item_Mapping_lines.Effective_End_Date%type;
83:
84: l_varchar_test varchar2(4000);
85:
86:

Line 117: FROM ja_cn_cfs_item_mapping_lines Lin

113: Detailed_Cfs_Item,
114: Effective_Start_Date,
115: Effective_End_Date,
116: org_id
117: FROM ja_cn_cfs_item_mapping_lines Lin
118: WHERE Lin.Mapping_Header_Id = l_Mapping_Header_Id;
119:
120: --get organization name
121: CURSOR c_org_name is

Line 144: FROM Fnd_Flex_Values_Tl Ffvt,Ja_Cn_Cfs_Item_Mapping_Lines JCCIM

140:
141: --get cash flow item description
142: /* CURSOR c_cash_flow_item_desc is
143: SELECT Ffvt.Description DESCRIPTION
144: FROM Fnd_Flex_Values_Tl Ffvt,Ja_Cn_Cfs_Item_Mapping_Lines JCCIM
145: WHERE Ffvt.Flex_Value_Meaning=JCCIM.DETAILED_CFS_ITEM
146: AND JCCIM.MAPPING_HEADER_ID=l_Mapping_Header_Id
147: and JCCIM.DETAILED_CFS_ITEM=l_detailed_cfs_item
148: and Ffvt.LANGUAGE = USERENV('LANG');*/

Line 155: ,Ja_Cn_Cfs_Item_Mapping_Lines JCCIML

151: SELECT DISTINCT FFVT.DESCRIPTION DESCRIPTION
152: FROM FND_FLEX_VALUE_SETS FFVS
153: ,FND_FLEX_VALUES_TL FFVT
154: ,FND_FLEX_VALUES FFV
155: ,Ja_Cn_Cfs_Item_Mapping_Lines JCCIML
156: ,JA_CN_CASH_VALUESETS_ALL JCCVA
157: WHERE FFVS.FLEX_VALUE_SET_ID = FFV.FLEX_VALUE_SET_ID
158: AND JCCVA.CHART_OF_ACCOUNTS_ID = l_Chart_Of_Accounts_Id
159: AND JCCVA.FLEX_VALUE_SET_ID = FFVS.FLEX_VALUE_SET_ID