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.GCS_DYN_TB_VIEW_PKG dependencies on AD_DDL

Line 96: -- Build one row of the comma or join list in ad_ddl.

92: --
93: -- Procedure
94: -- Build_Dimension_Row
95: -- Purpose
96: -- Build one row of the comma or join list in ad_ddl.
97: -- Arguments
98: -- p_item The item to write if the dimension is used
99: -- p_def_item The item to write if the dimension is unused
100: -- p_rownum The row number to use for ad_ddl

Line 100: -- p_rownum The row number to use for ad_ddl

96: -- Build one row of the comma or join list in ad_ddl.
97: -- Arguments
98: -- p_item The item to write if the dimension is used
99: -- p_def_item The item to write if the dimension is unused
100: -- p_rownum The row number to use for ad_ddl
101: -- p_dim_req Whether or not the dimension is required
102: -- Example
103: -- GCS_DYN_TB_VIEW_PKG.Build_Dimension_Row
104: -- Notes

Line 112: ad_ddl.build_statement(p_item, p_rownum);

108: p_rownum NUMBER,
109: p_dim_req VARCHAR2) IS
110: BEGIN
111: IF p_dim_req = 'Y' THEN
112: ad_ddl.build_statement(p_item, p_rownum);
113: ELSE
114: ad_ddl.build_statement(p_def_item, p_rownum);
115: END IF;
116: END Build_Dimension_Row;

Line 114: ad_ddl.build_statement(p_def_item, p_rownum);

110: BEGIN
111: IF p_dim_req = 'Y' THEN
112: ad_ddl.build_statement(p_item, p_rownum);
113: ELSE
114: ad_ddl.build_statement(p_def_item, p_rownum);
115: END IF;
116: END Build_Dimension_Row;
117:
118: --

Line 122: -- This will conditionally write a row to ad_ddl.

118: --
119: -- Procedure
120: -- Optional_Row
121: -- Purpose
122: -- This will conditionally write a row to ad_ddl.
123: -- Arguments
124: -- p_text The text to be written if the condition passes
125: -- p_dim_req The condition
126: -- p_row_counter The row number

Line 136: ad_ddl.build_statement(p_text, p_row_counter);

132: p_dim_req VARCHAR2,
133: p_row_counter IN OUT NOCOPY NUMBER) IS
134: BEGIN
135: IF p_dim_req = 'Y' THEN
136: ad_ddl.build_statement(p_text, p_row_counter);
137: p_row_counter := p_row_counter + 1;
138: END IF;
139: END Optional_Row;
140:

Line 200: -- Get APPLSYS information. Needed for ad_ddl

196: l_ud8_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM8_ID');
197: l_ud9_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM9_ID');
198: l_ud10_req := gcs_utility_pkg.get_fem_dim_required('USER_DIM10_ID');
199:
200: -- Get APPLSYS information. Needed for ad_ddl
201: IF NOT fnd_installation.get_app_info('FND', status, industry, appl) THEN
202: raise gcs_dyn_tb_applsys_not_found;
203: END IF;
204:

Line 208: ad_ddl.build_statement('CREATE OR REPLACE VIEW GCS_DYN_TB_V AS ', r); r:=r+1;

204:
205: r := 1;
206:
207: -- Create the package body
208: ad_ddl.build_statement('CREATE OR REPLACE VIEW GCS_DYN_TB_V AS ', r); r:=r+1;
209: ad_ddl.build_statement('SELECT ', r); r:=r+1;
210: ad_ddl.build_statement(' fb.dataset_code, ', r); r:=r+1;
211: ad_ddl.build_statement(' fb.cal_period_id, ', r); r:=r+1;
212: ad_ddl.build_statement(' fb.entity_id, ', r); r:=r+1;

Line 209: ad_ddl.build_statement('SELECT ', r); r:=r+1;

205: r := 1;
206:
207: -- Create the package body
208: ad_ddl.build_statement('CREATE OR REPLACE VIEW GCS_DYN_TB_V AS ', r); r:=r+1;
209: ad_ddl.build_statement('SELECT ', r); r:=r+1;
210: ad_ddl.build_statement(' fb.dataset_code, ', r); r:=r+1;
211: ad_ddl.build_statement(' fb.cal_period_id, ', r); r:=r+1;
212: ad_ddl.build_statement(' fb.entity_id, ', r); r:=r+1;
213: ad_ddl.build_statement(' fb.ledger_id, ', r); r:=r+1;

Line 210: ad_ddl.build_statement(' fb.dataset_code, ', r); r:=r+1;

206:
207: -- Create the package body
208: ad_ddl.build_statement('CREATE OR REPLACE VIEW GCS_DYN_TB_V AS ', r); r:=r+1;
209: ad_ddl.build_statement('SELECT ', r); r:=r+1;
210: ad_ddl.build_statement(' fb.dataset_code, ', r); r:=r+1;
211: ad_ddl.build_statement(' fb.cal_period_id, ', r); r:=r+1;
212: ad_ddl.build_statement(' fb.entity_id, ', r); r:=r+1;
213: ad_ddl.build_statement(' fb.ledger_id, ', r); r:=r+1;
214: ad_ddl.build_statement(' fb.currency_code, ', r); r:=r+1;

Line 211: ad_ddl.build_statement(' fb.cal_period_id, ', r); r:=r+1;

207: -- Create the package body
208: ad_ddl.build_statement('CREATE OR REPLACE VIEW GCS_DYN_TB_V AS ', r); r:=r+1;
209: ad_ddl.build_statement('SELECT ', r); r:=r+1;
210: ad_ddl.build_statement(' fb.dataset_code, ', r); r:=r+1;
211: ad_ddl.build_statement(' fb.cal_period_id, ', r); r:=r+1;
212: ad_ddl.build_statement(' fb.entity_id, ', r); r:=r+1;
213: ad_ddl.build_statement(' fb.ledger_id, ', r); r:=r+1;
214: ad_ddl.build_statement(' fb.currency_code, ', r); r:=r+1;
215: ad_ddl.build_statement(' fb.currency_type_code, ', r); r:=r+1;

Line 212: ad_ddl.build_statement(' fb.entity_id, ', r); r:=r+1;

208: ad_ddl.build_statement('CREATE OR REPLACE VIEW GCS_DYN_TB_V AS ', r); r:=r+1;
209: ad_ddl.build_statement('SELECT ', r); r:=r+1;
210: ad_ddl.build_statement(' fb.dataset_code, ', r); r:=r+1;
211: ad_ddl.build_statement(' fb.cal_period_id, ', r); r:=r+1;
212: ad_ddl.build_statement(' fb.entity_id, ', r); r:=r+1;
213: ad_ddl.build_statement(' fb.ledger_id, ', r); r:=r+1;
214: ad_ddl.build_statement(' fb.currency_code, ', r); r:=r+1;
215: ad_ddl.build_statement(' fb.currency_type_code, ', r); r:=r+1;
216: ad_ddl.build_statement(' fb.source_system_code, ', r); r:=r+1;

Line 213: ad_ddl.build_statement(' fb.ledger_id, ', r); r:=r+1;

209: ad_ddl.build_statement('SELECT ', r); r:=r+1;
210: ad_ddl.build_statement(' fb.dataset_code, ', r); r:=r+1;
211: ad_ddl.build_statement(' fb.cal_period_id, ', r); r:=r+1;
212: ad_ddl.build_statement(' fb.entity_id, ', r); r:=r+1;
213: ad_ddl.build_statement(' fb.ledger_id, ', r); r:=r+1;
214: ad_ddl.build_statement(' fb.currency_code, ', r); r:=r+1;
215: ad_ddl.build_statement(' fb.currency_type_code, ', r); r:=r+1;
216: ad_ddl.build_statement(' fb.source_system_code, ', r); r:=r+1;
217: ad_ddl.build_statement(' fb.company_cost_center_org_id, ', r); r:=r+1;

Line 214: ad_ddl.build_statement(' fb.currency_code, ', r); r:=r+1;

210: ad_ddl.build_statement(' fb.dataset_code, ', r); r:=r+1;
211: ad_ddl.build_statement(' fb.cal_period_id, ', r); r:=r+1;
212: ad_ddl.build_statement(' fb.entity_id, ', r); r:=r+1;
213: ad_ddl.build_statement(' fb.ledger_id, ', r); r:=r+1;
214: ad_ddl.build_statement(' fb.currency_code, ', r); r:=r+1;
215: ad_ddl.build_statement(' fb.currency_type_code, ', r); r:=r+1;
216: ad_ddl.build_statement(' fb.source_system_code, ', r); r:=r+1;
217: ad_ddl.build_statement(' fb.company_cost_center_org_id, ', r); r:=r+1;
218: ad_ddl.build_statement(' fb.intercompany_id, ', r); r:=r+1;

Line 215: ad_ddl.build_statement(' fb.currency_type_code, ', r); r:=r+1;

211: ad_ddl.build_statement(' fb.cal_period_id, ', r); r:=r+1;
212: ad_ddl.build_statement(' fb.entity_id, ', r); r:=r+1;
213: ad_ddl.build_statement(' fb.ledger_id, ', r); r:=r+1;
214: ad_ddl.build_statement(' fb.currency_code, ', r); r:=r+1;
215: ad_ddl.build_statement(' fb.currency_type_code, ', r); r:=r+1;
216: ad_ddl.build_statement(' fb.source_system_code, ', r); r:=r+1;
217: ad_ddl.build_statement(' fb.company_cost_center_org_id, ', r); r:=r+1;
218: ad_ddl.build_statement(' fb.intercompany_id, ', r); r:=r+1;
219: ad_ddl.build_statement(' fb.line_item_id, ', r); r:=r+1;

Line 216: ad_ddl.build_statement(' fb.source_system_code, ', r); r:=r+1;

212: ad_ddl.build_statement(' fb.entity_id, ', r); r:=r+1;
213: ad_ddl.build_statement(' fb.ledger_id, ', r); r:=r+1;
214: ad_ddl.build_statement(' fb.currency_code, ', r); r:=r+1;
215: ad_ddl.build_statement(' fb.currency_type_code, ', r); r:=r+1;
216: ad_ddl.build_statement(' fb.source_system_code, ', r); r:=r+1;
217: ad_ddl.build_statement(' fb.company_cost_center_org_id, ', r); r:=r+1;
218: ad_ddl.build_statement(' fb.intercompany_id, ', r); r:=r+1;
219: ad_ddl.build_statement(' fb.line_item_id, ', r); r:=r+1;
220: ad_ddl.build_statement(' fb.financial_elem_id, ', r); r:=r+1;

Line 217: ad_ddl.build_statement(' fb.company_cost_center_org_id, ', r); r:=r+1;

213: ad_ddl.build_statement(' fb.ledger_id, ', r); r:=r+1;
214: ad_ddl.build_statement(' fb.currency_code, ', r); r:=r+1;
215: ad_ddl.build_statement(' fb.currency_type_code, ', r); r:=r+1;
216: ad_ddl.build_statement(' fb.source_system_code, ', r); r:=r+1;
217: ad_ddl.build_statement(' fb.company_cost_center_org_id, ', r); r:=r+1;
218: ad_ddl.build_statement(' fb.intercompany_id, ', r); r:=r+1;
219: ad_ddl.build_statement(' fb.line_item_id, ', r); r:=r+1;
220: ad_ddl.build_statement(' fb.financial_elem_id, ', r); r:=r+1;
221: ad_ddl.build_statement(' fb.product_id, ', r); r:=r+1;

Line 218: ad_ddl.build_statement(' fb.intercompany_id, ', r); r:=r+1;

214: ad_ddl.build_statement(' fb.currency_code, ', r); r:=r+1;
215: ad_ddl.build_statement(' fb.currency_type_code, ', r); r:=r+1;
216: ad_ddl.build_statement(' fb.source_system_code, ', r); r:=r+1;
217: ad_ddl.build_statement(' fb.company_cost_center_org_id, ', r); r:=r+1;
218: ad_ddl.build_statement(' fb.intercompany_id, ', r); r:=r+1;
219: ad_ddl.build_statement(' fb.line_item_id, ', r); r:=r+1;
220: ad_ddl.build_statement(' fb.financial_elem_id, ', r); r:=r+1;
221: ad_ddl.build_statement(' fb.product_id, ', r); r:=r+1;
222: ad_ddl.build_statement(' fb.natural_account_id, ', r); r:=r+1;

Line 219: ad_ddl.build_statement(' fb.line_item_id, ', r); r:=r+1;

215: ad_ddl.build_statement(' fb.currency_type_code, ', r); r:=r+1;
216: ad_ddl.build_statement(' fb.source_system_code, ', r); r:=r+1;
217: ad_ddl.build_statement(' fb.company_cost_center_org_id, ', r); r:=r+1;
218: ad_ddl.build_statement(' fb.intercompany_id, ', r); r:=r+1;
219: ad_ddl.build_statement(' fb.line_item_id, ', r); r:=r+1;
220: ad_ddl.build_statement(' fb.financial_elem_id, ', r); r:=r+1;
221: ad_ddl.build_statement(' fb.product_id, ', r); r:=r+1;
222: ad_ddl.build_statement(' fb.natural_account_id, ', r); r:=r+1;
223: ad_ddl.build_statement(' fb.channel_id, ', r); r:=r+1;

Line 220: ad_ddl.build_statement(' fb.financial_elem_id, ', r); r:=r+1;

216: ad_ddl.build_statement(' fb.source_system_code, ', r); r:=r+1;
217: ad_ddl.build_statement(' fb.company_cost_center_org_id, ', r); r:=r+1;
218: ad_ddl.build_statement(' fb.intercompany_id, ', r); r:=r+1;
219: ad_ddl.build_statement(' fb.line_item_id, ', r); r:=r+1;
220: ad_ddl.build_statement(' fb.financial_elem_id, ', r); r:=r+1;
221: ad_ddl.build_statement(' fb.product_id, ', r); r:=r+1;
222: ad_ddl.build_statement(' fb.natural_account_id, ', r); r:=r+1;
223: ad_ddl.build_statement(' fb.channel_id, ', r); r:=r+1;
224: ad_ddl.build_statement(' fb.project_id, ', r); r:=r+1;

Line 221: ad_ddl.build_statement(' fb.product_id, ', r); r:=r+1;

217: ad_ddl.build_statement(' fb.company_cost_center_org_id, ', r); r:=r+1;
218: ad_ddl.build_statement(' fb.intercompany_id, ', r); r:=r+1;
219: ad_ddl.build_statement(' fb.line_item_id, ', r); r:=r+1;
220: ad_ddl.build_statement(' fb.financial_elem_id, ', r); r:=r+1;
221: ad_ddl.build_statement(' fb.product_id, ', r); r:=r+1;
222: ad_ddl.build_statement(' fb.natural_account_id, ', r); r:=r+1;
223: ad_ddl.build_statement(' fb.channel_id, ', r); r:=r+1;
224: ad_ddl.build_statement(' fb.project_id, ', r); r:=r+1;
225: ad_ddl.build_statement(' fb.customer_id, ', r); r:=r+1;

Line 222: ad_ddl.build_statement(' fb.natural_account_id, ', r); r:=r+1;

218: ad_ddl.build_statement(' fb.intercompany_id, ', r); r:=r+1;
219: ad_ddl.build_statement(' fb.line_item_id, ', r); r:=r+1;
220: ad_ddl.build_statement(' fb.financial_elem_id, ', r); r:=r+1;
221: ad_ddl.build_statement(' fb.product_id, ', r); r:=r+1;
222: ad_ddl.build_statement(' fb.natural_account_id, ', r); r:=r+1;
223: ad_ddl.build_statement(' fb.channel_id, ', r); r:=r+1;
224: ad_ddl.build_statement(' fb.project_id, ', r); r:=r+1;
225: ad_ddl.build_statement(' fb.customer_id, ', r); r:=r+1;
226: ad_ddl.build_statement(' fb.task_id, ', r); r:=r+1;

Line 223: ad_ddl.build_statement(' fb.channel_id, ', r); r:=r+1;

219: ad_ddl.build_statement(' fb.line_item_id, ', r); r:=r+1;
220: ad_ddl.build_statement(' fb.financial_elem_id, ', r); r:=r+1;
221: ad_ddl.build_statement(' fb.product_id, ', r); r:=r+1;
222: ad_ddl.build_statement(' fb.natural_account_id, ', r); r:=r+1;
223: ad_ddl.build_statement(' fb.channel_id, ', r); r:=r+1;
224: ad_ddl.build_statement(' fb.project_id, ', r); r:=r+1;
225: ad_ddl.build_statement(' fb.customer_id, ', r); r:=r+1;
226: ad_ddl.build_statement(' fb.task_id, ', r); r:=r+1;
227: ad_ddl.build_statement(' fb.user_dim1_id, ', r); r:=r+1;

Line 224: ad_ddl.build_statement(' fb.project_id, ', r); r:=r+1;

220: ad_ddl.build_statement(' fb.financial_elem_id, ', r); r:=r+1;
221: ad_ddl.build_statement(' fb.product_id, ', r); r:=r+1;
222: ad_ddl.build_statement(' fb.natural_account_id, ', r); r:=r+1;
223: ad_ddl.build_statement(' fb.channel_id, ', r); r:=r+1;
224: ad_ddl.build_statement(' fb.project_id, ', r); r:=r+1;
225: ad_ddl.build_statement(' fb.customer_id, ', r); r:=r+1;
226: ad_ddl.build_statement(' fb.task_id, ', r); r:=r+1;
227: ad_ddl.build_statement(' fb.user_dim1_id, ', r); r:=r+1;
228: ad_ddl.build_statement(' fb.user_dim2_id, ', r); r:=r+1;

Line 225: ad_ddl.build_statement(' fb.customer_id, ', r); r:=r+1;

221: ad_ddl.build_statement(' fb.product_id, ', r); r:=r+1;
222: ad_ddl.build_statement(' fb.natural_account_id, ', r); r:=r+1;
223: ad_ddl.build_statement(' fb.channel_id, ', r); r:=r+1;
224: ad_ddl.build_statement(' fb.project_id, ', r); r:=r+1;
225: ad_ddl.build_statement(' fb.customer_id, ', r); r:=r+1;
226: ad_ddl.build_statement(' fb.task_id, ', r); r:=r+1;
227: ad_ddl.build_statement(' fb.user_dim1_id, ', r); r:=r+1;
228: ad_ddl.build_statement(' fb.user_dim2_id, ', r); r:=r+1;
229: ad_ddl.build_statement(' fb.user_dim3_id, ', r); r:=r+1;

Line 226: ad_ddl.build_statement(' fb.task_id, ', r); r:=r+1;

222: ad_ddl.build_statement(' fb.natural_account_id, ', r); r:=r+1;
223: ad_ddl.build_statement(' fb.channel_id, ', r); r:=r+1;
224: ad_ddl.build_statement(' fb.project_id, ', r); r:=r+1;
225: ad_ddl.build_statement(' fb.customer_id, ', r); r:=r+1;
226: ad_ddl.build_statement(' fb.task_id, ', r); r:=r+1;
227: ad_ddl.build_statement(' fb.user_dim1_id, ', r); r:=r+1;
228: ad_ddl.build_statement(' fb.user_dim2_id, ', r); r:=r+1;
229: ad_ddl.build_statement(' fb.user_dim3_id, ', r); r:=r+1;
230: ad_ddl.build_statement(' fb.user_dim4_id, ', r); r:=r+1;

Line 227: ad_ddl.build_statement(' fb.user_dim1_id, ', r); r:=r+1;

223: ad_ddl.build_statement(' fb.channel_id, ', r); r:=r+1;
224: ad_ddl.build_statement(' fb.project_id, ', r); r:=r+1;
225: ad_ddl.build_statement(' fb.customer_id, ', r); r:=r+1;
226: ad_ddl.build_statement(' fb.task_id, ', r); r:=r+1;
227: ad_ddl.build_statement(' fb.user_dim1_id, ', r); r:=r+1;
228: ad_ddl.build_statement(' fb.user_dim2_id, ', r); r:=r+1;
229: ad_ddl.build_statement(' fb.user_dim3_id, ', r); r:=r+1;
230: ad_ddl.build_statement(' fb.user_dim4_id, ', r); r:=r+1;
231: ad_ddl.build_statement(' fb.user_dim5_id, ', r); r:=r+1;

Line 228: ad_ddl.build_statement(' fb.user_dim2_id, ', r); r:=r+1;

224: ad_ddl.build_statement(' fb.project_id, ', r); r:=r+1;
225: ad_ddl.build_statement(' fb.customer_id, ', r); r:=r+1;
226: ad_ddl.build_statement(' fb.task_id, ', r); r:=r+1;
227: ad_ddl.build_statement(' fb.user_dim1_id, ', r); r:=r+1;
228: ad_ddl.build_statement(' fb.user_dim2_id, ', r); r:=r+1;
229: ad_ddl.build_statement(' fb.user_dim3_id, ', r); r:=r+1;
230: ad_ddl.build_statement(' fb.user_dim4_id, ', r); r:=r+1;
231: ad_ddl.build_statement(' fb.user_dim5_id, ', r); r:=r+1;
232: ad_ddl.build_statement(' fb.user_dim6_id, ', r); r:=r+1;

Line 229: ad_ddl.build_statement(' fb.user_dim3_id, ', r); r:=r+1;

225: ad_ddl.build_statement(' fb.customer_id, ', r); r:=r+1;
226: ad_ddl.build_statement(' fb.task_id, ', r); r:=r+1;
227: ad_ddl.build_statement(' fb.user_dim1_id, ', r); r:=r+1;
228: ad_ddl.build_statement(' fb.user_dim2_id, ', r); r:=r+1;
229: ad_ddl.build_statement(' fb.user_dim3_id, ', r); r:=r+1;
230: ad_ddl.build_statement(' fb.user_dim4_id, ', r); r:=r+1;
231: ad_ddl.build_statement(' fb.user_dim5_id, ', r); r:=r+1;
232: ad_ddl.build_statement(' fb.user_dim6_id, ', r); r:=r+1;
233: ad_ddl.build_statement(' fb.user_dim7_id, ', r); r:=r+1;

Line 230: ad_ddl.build_statement(' fb.user_dim4_id, ', r); r:=r+1;

226: ad_ddl.build_statement(' fb.task_id, ', r); r:=r+1;
227: ad_ddl.build_statement(' fb.user_dim1_id, ', r); r:=r+1;
228: ad_ddl.build_statement(' fb.user_dim2_id, ', r); r:=r+1;
229: ad_ddl.build_statement(' fb.user_dim3_id, ', r); r:=r+1;
230: ad_ddl.build_statement(' fb.user_dim4_id, ', r); r:=r+1;
231: ad_ddl.build_statement(' fb.user_dim5_id, ', r); r:=r+1;
232: ad_ddl.build_statement(' fb.user_dim6_id, ', r); r:=r+1;
233: ad_ddl.build_statement(' fb.user_dim7_id, ', r); r:=r+1;
234: ad_ddl.build_statement(' fb.user_dim8_id, ', r); r:=r+1;

Line 231: ad_ddl.build_statement(' fb.user_dim5_id, ', r); r:=r+1;

227: ad_ddl.build_statement(' fb.user_dim1_id, ', r); r:=r+1;
228: ad_ddl.build_statement(' fb.user_dim2_id, ', r); r:=r+1;
229: ad_ddl.build_statement(' fb.user_dim3_id, ', r); r:=r+1;
230: ad_ddl.build_statement(' fb.user_dim4_id, ', r); r:=r+1;
231: ad_ddl.build_statement(' fb.user_dim5_id, ', r); r:=r+1;
232: ad_ddl.build_statement(' fb.user_dim6_id, ', r); r:=r+1;
233: ad_ddl.build_statement(' fb.user_dim7_id, ', r); r:=r+1;
234: ad_ddl.build_statement(' fb.user_dim8_id, ', r); r:=r+1;
235: ad_ddl.build_statement(' fb.user_dim9_id, ', r); r:=r+1;

Line 232: ad_ddl.build_statement(' fb.user_dim6_id, ', r); r:=r+1;

228: ad_ddl.build_statement(' fb.user_dim2_id, ', r); r:=r+1;
229: ad_ddl.build_statement(' fb.user_dim3_id, ', r); r:=r+1;
230: ad_ddl.build_statement(' fb.user_dim4_id, ', r); r:=r+1;
231: ad_ddl.build_statement(' fb.user_dim5_id, ', r); r:=r+1;
232: ad_ddl.build_statement(' fb.user_dim6_id, ', r); r:=r+1;
233: ad_ddl.build_statement(' fb.user_dim7_id, ', r); r:=r+1;
234: ad_ddl.build_statement(' fb.user_dim8_id, ', r); r:=r+1;
235: ad_ddl.build_statement(' fb.user_dim9_id, ', r); r:=r+1;
236: ad_ddl.build_statement(' fb.user_dim10_id, ', r); r:=r+1;

Line 233: ad_ddl.build_statement(' fb.user_dim7_id, ', r); r:=r+1;

229: ad_ddl.build_statement(' fb.user_dim3_id, ', r); r:=r+1;
230: ad_ddl.build_statement(' fb.user_dim4_id, ', r); r:=r+1;
231: ad_ddl.build_statement(' fb.user_dim5_id, ', r); r:=r+1;
232: ad_ddl.build_statement(' fb.user_dim6_id, ', r); r:=r+1;
233: ad_ddl.build_statement(' fb.user_dim7_id, ', r); r:=r+1;
234: ad_ddl.build_statement(' fb.user_dim8_id, ', r); r:=r+1;
235: ad_ddl.build_statement(' fb.user_dim9_id, ', r); r:=r+1;
236: ad_ddl.build_statement(' fb.user_dim10_id, ', r); r:=r+1;
237: ad_ddl.build_statement(' cotl.company_cost_center_org_name, ', r); r:=r+1;

Line 234: ad_ddl.build_statement(' fb.user_dim8_id, ', r); r:=r+1;

230: ad_ddl.build_statement(' fb.user_dim4_id, ', r); r:=r+1;
231: ad_ddl.build_statement(' fb.user_dim5_id, ', r); r:=r+1;
232: ad_ddl.build_statement(' fb.user_dim6_id, ', r); r:=r+1;
233: ad_ddl.build_statement(' fb.user_dim7_id, ', r); r:=r+1;
234: ad_ddl.build_statement(' fb.user_dim8_id, ', r); r:=r+1;
235: ad_ddl.build_statement(' fb.user_dim9_id, ', r); r:=r+1;
236: ad_ddl.build_statement(' fb.user_dim10_id, ', r); r:=r+1;
237: ad_ddl.build_statement(' cotl.company_cost_center_org_name, ', r); r:=r+1;
238: ad_ddl.build_statement(' ictl.company_cost_center_org_name intercompany_name, ', r); r:=r+1;

Line 235: ad_ddl.build_statement(' fb.user_dim9_id, ', r); r:=r+1;

231: ad_ddl.build_statement(' fb.user_dim5_id, ', r); r:=r+1;
232: ad_ddl.build_statement(' fb.user_dim6_id, ', r); r:=r+1;
233: ad_ddl.build_statement(' fb.user_dim7_id, ', r); r:=r+1;
234: ad_ddl.build_statement(' fb.user_dim8_id, ', r); r:=r+1;
235: ad_ddl.build_statement(' fb.user_dim9_id, ', r); r:=r+1;
236: ad_ddl.build_statement(' fb.user_dim10_id, ', r); r:=r+1;
237: ad_ddl.build_statement(' cotl.company_cost_center_org_name, ', r); r:=r+1;
238: ad_ddl.build_statement(' ictl.company_cost_center_org_name intercompany_name, ', r); r:=r+1;
239: ad_ddl.build_statement(' litl.line_item_name, ', r); r:=r+1;

Line 236: ad_ddl.build_statement(' fb.user_dim10_id, ', r); r:=r+1;

232: ad_ddl.build_statement(' fb.user_dim6_id, ', r); r:=r+1;
233: ad_ddl.build_statement(' fb.user_dim7_id, ', r); r:=r+1;
234: ad_ddl.build_statement(' fb.user_dim8_id, ', r); r:=r+1;
235: ad_ddl.build_statement(' fb.user_dim9_id, ', r); r:=r+1;
236: ad_ddl.build_statement(' fb.user_dim10_id, ', r); r:=r+1;
237: ad_ddl.build_statement(' cotl.company_cost_center_org_name, ', r); r:=r+1;
238: ad_ddl.build_statement(' ictl.company_cost_center_org_name intercompany_name, ', r); r:=r+1;
239: ad_ddl.build_statement(' litl.line_item_name, ', r); r:=r+1;
240: build_dimension_row(' fetl.financial_elem_name, ', ' null financial_elem_name, ', r, l_fe_req); r:=r+1;

Line 237: ad_ddl.build_statement(' cotl.company_cost_center_org_name, ', r); r:=r+1;

233: ad_ddl.build_statement(' fb.user_dim7_id, ', r); r:=r+1;
234: ad_ddl.build_statement(' fb.user_dim8_id, ', r); r:=r+1;
235: ad_ddl.build_statement(' fb.user_dim9_id, ', r); r:=r+1;
236: ad_ddl.build_statement(' fb.user_dim10_id, ', r); r:=r+1;
237: ad_ddl.build_statement(' cotl.company_cost_center_org_name, ', r); r:=r+1;
238: ad_ddl.build_statement(' ictl.company_cost_center_org_name intercompany_name, ', r); r:=r+1;
239: ad_ddl.build_statement(' litl.line_item_name, ', r); r:=r+1;
240: build_dimension_row(' fetl.financial_elem_name, ', ' null financial_elem_name, ', r, l_fe_req); r:=r+1;
241: build_dimension_row(' pdtl.product_name, ', ' null product_name, ', r, l_pd_req); r:=r+1;

Line 238: ad_ddl.build_statement(' ictl.company_cost_center_org_name intercompany_name, ', r); r:=r+1;

234: ad_ddl.build_statement(' fb.user_dim8_id, ', r); r:=r+1;
235: ad_ddl.build_statement(' fb.user_dim9_id, ', r); r:=r+1;
236: ad_ddl.build_statement(' fb.user_dim10_id, ', r); r:=r+1;
237: ad_ddl.build_statement(' cotl.company_cost_center_org_name, ', r); r:=r+1;
238: ad_ddl.build_statement(' ictl.company_cost_center_org_name intercompany_name, ', r); r:=r+1;
239: ad_ddl.build_statement(' litl.line_item_name, ', r); r:=r+1;
240: build_dimension_row(' fetl.financial_elem_name, ', ' null financial_elem_name, ', r, l_fe_req); r:=r+1;
241: build_dimension_row(' pdtl.product_name, ', ' null product_name, ', r, l_pd_req); r:=r+1;
242: build_dimension_row(' natl.natural_account_name, ', ' null natural_account_name, ', r, l_na_req); r:=r+1;

Line 239: ad_ddl.build_statement(' litl.line_item_name, ', r); r:=r+1;

235: ad_ddl.build_statement(' fb.user_dim9_id, ', r); r:=r+1;
236: ad_ddl.build_statement(' fb.user_dim10_id, ', r); r:=r+1;
237: ad_ddl.build_statement(' cotl.company_cost_center_org_name, ', r); r:=r+1;
238: ad_ddl.build_statement(' ictl.company_cost_center_org_name intercompany_name, ', r); r:=r+1;
239: ad_ddl.build_statement(' litl.line_item_name, ', r); r:=r+1;
240: build_dimension_row(' fetl.financial_elem_name, ', ' null financial_elem_name, ', r, l_fe_req); r:=r+1;
241: build_dimension_row(' pdtl.product_name, ', ' null product_name, ', r, l_pd_req); r:=r+1;
242: build_dimension_row(' natl.natural_account_name, ', ' null natural_account_name, ', r, l_na_req); r:=r+1;
243: build_dimension_row(' chtl.channel_name, ', ' null channel_name, ', r, l_ch_req); r:=r+1;

Line 257: ad_ddl.build_statement(' cotl.description company_cost_center_org_desc, ', r); r:=r+1;

253: build_dimension_row(' ud7tl.user_dim7_name, ', ' null user_dim7_name, ', r, l_ud7_req); r:=r+1;
254: build_dimension_row(' ud8tl.user_dim8_name, ', ' null user_dim8_name, ', r, l_ud8_req); r:=r+1;
255: build_dimension_row(' ud9tl.user_dim9_name, ', ' null user_dim9_name, ', r, l_ud9_req); r:=r+1;
256: build_dimension_row(' ud10tl.user_dim10_name, ', ' null user_dim10_name, ', r, l_ud10_req); r:=r+1;
257: ad_ddl.build_statement(' cotl.description company_cost_center_org_desc, ', r); r:=r+1;
258: ad_ddl.build_statement(' ictl.description intercompany_desc, ', r); r:=r+1;
259: ad_ddl.build_statement(' litl.description line_item_desc, ', r); r:=r+1;
260: build_dimension_row(' fetl.description financial_elem_desc, ', ' null financial_elem_desc, ', r, l_fe_req); r:=r+1;
261: build_dimension_row(' pdtl.description product_desc, ', ' null product_desc, ', r, l_pd_req); r:=r+1;

Line 258: ad_ddl.build_statement(' ictl.description intercompany_desc, ', r); r:=r+1;

254: build_dimension_row(' ud8tl.user_dim8_name, ', ' null user_dim8_name, ', r, l_ud8_req); r:=r+1;
255: build_dimension_row(' ud9tl.user_dim9_name, ', ' null user_dim9_name, ', r, l_ud9_req); r:=r+1;
256: build_dimension_row(' ud10tl.user_dim10_name, ', ' null user_dim10_name, ', r, l_ud10_req); r:=r+1;
257: ad_ddl.build_statement(' cotl.description company_cost_center_org_desc, ', r); r:=r+1;
258: ad_ddl.build_statement(' ictl.description intercompany_desc, ', r); r:=r+1;
259: ad_ddl.build_statement(' litl.description line_item_desc, ', r); r:=r+1;
260: build_dimension_row(' fetl.description financial_elem_desc, ', ' null financial_elem_desc, ', r, l_fe_req); r:=r+1;
261: build_dimension_row(' pdtl.description product_desc, ', ' null product_desc, ', r, l_pd_req); r:=r+1;
262: build_dimension_row(' natl.description natural_account_desc, ', ' null natural_account_desc, ', r, l_na_req); r:=r+1;

Line 259: ad_ddl.build_statement(' litl.description line_item_desc, ', r); r:=r+1;

255: build_dimension_row(' ud9tl.user_dim9_name, ', ' null user_dim9_name, ', r, l_ud9_req); r:=r+1;
256: build_dimension_row(' ud10tl.user_dim10_name, ', ' null user_dim10_name, ', r, l_ud10_req); r:=r+1;
257: ad_ddl.build_statement(' cotl.description company_cost_center_org_desc, ', r); r:=r+1;
258: ad_ddl.build_statement(' ictl.description intercompany_desc, ', r); r:=r+1;
259: ad_ddl.build_statement(' litl.description line_item_desc, ', r); r:=r+1;
260: build_dimension_row(' fetl.description financial_elem_desc, ', ' null financial_elem_desc, ', r, l_fe_req); r:=r+1;
261: build_dimension_row(' pdtl.description product_desc, ', ' null product_desc, ', r, l_pd_req); r:=r+1;
262: build_dimension_row(' natl.description natural_account_desc, ', ' null natural_account_desc, ', r, l_na_req); r:=r+1;
263: build_dimension_row(' chtl.description channel_desc, ', ' null channel_desc, ', r, l_ch_req); r:=r+1;

Line 277: ad_ddl.build_statement(' fb.xtd_balance_e, ', r); r:=r+1;

273: build_dimension_row(' ud7tl.description user_dim7_desc, ', ' null user_dim7_desc, ', r, l_ud7_req); r:=r+1;
274: build_dimension_row(' ud8tl.description user_dim8_desc, ', ' null user_dim8_desc, ', r, l_ud8_req); r:=r+1;
275: build_dimension_row(' ud9tl.description user_dim9_desc, ', ' null user_dim9_desc, ', r, l_ud9_req); r:=r+1;
276: build_dimension_row(' ud10tl.description user_dim10_desc, ', ' null user_dim10_desc, ', r, l_ud10_req); r:=r+1;
277: ad_ddl.build_statement(' fb.xtd_balance_e, ', r); r:=r+1;
278: ad_ddl.build_statement(' fb.xtd_balance_f, ', r); r:=r+1;
279: ad_ddl.build_statement(' fb.ytd_balance_e, ', r); r:=r+1;
280: ad_ddl.build_statement(' fb.ytd_balance_f ', r); r:=r+1;
281: ad_ddl.build_statement('FROM ', r); r:=r+1;

Line 278: ad_ddl.build_statement(' fb.xtd_balance_f, ', r); r:=r+1;

274: build_dimension_row(' ud8tl.description user_dim8_desc, ', ' null user_dim8_desc, ', r, l_ud8_req); r:=r+1;
275: build_dimension_row(' ud9tl.description user_dim9_desc, ', ' null user_dim9_desc, ', r, l_ud9_req); r:=r+1;
276: build_dimension_row(' ud10tl.description user_dim10_desc, ', ' null user_dim10_desc, ', r, l_ud10_req); r:=r+1;
277: ad_ddl.build_statement(' fb.xtd_balance_e, ', r); r:=r+1;
278: ad_ddl.build_statement(' fb.xtd_balance_f, ', r); r:=r+1;
279: ad_ddl.build_statement(' fb.ytd_balance_e, ', r); r:=r+1;
280: ad_ddl.build_statement(' fb.ytd_balance_f ', r); r:=r+1;
281: ad_ddl.build_statement('FROM ', r); r:=r+1;
282: ad_ddl.build_statement(' FEM_BALANCES fb, ', r); r:=r+1;

Line 279: ad_ddl.build_statement(' fb.ytd_balance_e, ', r); r:=r+1;

275: build_dimension_row(' ud9tl.description user_dim9_desc, ', ' null user_dim9_desc, ', r, l_ud9_req); r:=r+1;
276: build_dimension_row(' ud10tl.description user_dim10_desc, ', ' null user_dim10_desc, ', r, l_ud10_req); r:=r+1;
277: ad_ddl.build_statement(' fb.xtd_balance_e, ', r); r:=r+1;
278: ad_ddl.build_statement(' fb.xtd_balance_f, ', r); r:=r+1;
279: ad_ddl.build_statement(' fb.ytd_balance_e, ', r); r:=r+1;
280: ad_ddl.build_statement(' fb.ytd_balance_f ', r); r:=r+1;
281: ad_ddl.build_statement('FROM ', r); r:=r+1;
282: ad_ddl.build_statement(' FEM_BALANCES fb, ', r); r:=r+1;
283: ad_ddl.build_statement(' FEM_CCTR_ORGS_TL cotl, ', r); r:=r+1;

Line 280: ad_ddl.build_statement(' fb.ytd_balance_f ', r); r:=r+1;

276: build_dimension_row(' ud10tl.description user_dim10_desc, ', ' null user_dim10_desc, ', r, l_ud10_req); r:=r+1;
277: ad_ddl.build_statement(' fb.xtd_balance_e, ', r); r:=r+1;
278: ad_ddl.build_statement(' fb.xtd_balance_f, ', r); r:=r+1;
279: ad_ddl.build_statement(' fb.ytd_balance_e, ', r); r:=r+1;
280: ad_ddl.build_statement(' fb.ytd_balance_f ', r); r:=r+1;
281: ad_ddl.build_statement('FROM ', r); r:=r+1;
282: ad_ddl.build_statement(' FEM_BALANCES fb, ', r); r:=r+1;
283: ad_ddl.build_statement(' FEM_CCTR_ORGS_TL cotl, ', r); r:=r+1;
284: ad_ddl.build_statement(' FEM_CCTR_ORGS_TL ictl, ', r); r:=r+1;

Line 281: ad_ddl.build_statement('FROM ', r); r:=r+1;

277: ad_ddl.build_statement(' fb.xtd_balance_e, ', r); r:=r+1;
278: ad_ddl.build_statement(' fb.xtd_balance_f, ', r); r:=r+1;
279: ad_ddl.build_statement(' fb.ytd_balance_e, ', r); r:=r+1;
280: ad_ddl.build_statement(' fb.ytd_balance_f ', r); r:=r+1;
281: ad_ddl.build_statement('FROM ', r); r:=r+1;
282: ad_ddl.build_statement(' FEM_BALANCES fb, ', r); r:=r+1;
283: ad_ddl.build_statement(' FEM_CCTR_ORGS_TL cotl, ', r); r:=r+1;
284: ad_ddl.build_statement(' FEM_CCTR_ORGS_TL ictl, ', r); r:=r+1;
285: optional_row(' FEM_FIN_ELEMS_TL fetl, ', l_fe_req, r);

Line 282: ad_ddl.build_statement(' FEM_BALANCES fb, ', r); r:=r+1;

278: ad_ddl.build_statement(' fb.xtd_balance_f, ', r); r:=r+1;
279: ad_ddl.build_statement(' fb.ytd_balance_e, ', r); r:=r+1;
280: ad_ddl.build_statement(' fb.ytd_balance_f ', r); r:=r+1;
281: ad_ddl.build_statement('FROM ', r); r:=r+1;
282: ad_ddl.build_statement(' FEM_BALANCES fb, ', r); r:=r+1;
283: ad_ddl.build_statement(' FEM_CCTR_ORGS_TL cotl, ', r); r:=r+1;
284: ad_ddl.build_statement(' FEM_CCTR_ORGS_TL ictl, ', r); r:=r+1;
285: optional_row(' FEM_FIN_ELEMS_TL fetl, ', l_fe_req, r);
286: optional_row(' FEM_PRODUCTS_TL pdtl, ', l_pd_req, r);

Line 283: ad_ddl.build_statement(' FEM_CCTR_ORGS_TL cotl, ', r); r:=r+1;

279: ad_ddl.build_statement(' fb.ytd_balance_e, ', r); r:=r+1;
280: ad_ddl.build_statement(' fb.ytd_balance_f ', r); r:=r+1;
281: ad_ddl.build_statement('FROM ', r); r:=r+1;
282: ad_ddl.build_statement(' FEM_BALANCES fb, ', r); r:=r+1;
283: ad_ddl.build_statement(' FEM_CCTR_ORGS_TL cotl, ', r); r:=r+1;
284: ad_ddl.build_statement(' FEM_CCTR_ORGS_TL ictl, ', r); r:=r+1;
285: optional_row(' FEM_FIN_ELEMS_TL fetl, ', l_fe_req, r);
286: optional_row(' FEM_PRODUCTS_TL pdtl, ', l_pd_req, r);
287: optional_row(' FEM_NAT_ACCTS_TL natl, ', l_na_req, r);

Line 284: ad_ddl.build_statement(' FEM_CCTR_ORGS_TL ictl, ', r); r:=r+1;

280: ad_ddl.build_statement(' fb.ytd_balance_f ', r); r:=r+1;
281: ad_ddl.build_statement('FROM ', r); r:=r+1;
282: ad_ddl.build_statement(' FEM_BALANCES fb, ', r); r:=r+1;
283: ad_ddl.build_statement(' FEM_CCTR_ORGS_TL cotl, ', r); r:=r+1;
284: ad_ddl.build_statement(' FEM_CCTR_ORGS_TL ictl, ', r); r:=r+1;
285: optional_row(' FEM_FIN_ELEMS_TL fetl, ', l_fe_req, r);
286: optional_row(' FEM_PRODUCTS_TL pdtl, ', l_pd_req, r);
287: optional_row(' FEM_NAT_ACCTS_TL natl, ', l_na_req, r);
288: optional_row(' FEM_CHANNELS_TL chtl, ', l_ch_req, r);

Line 302: ad_ddl.build_statement(' FEM_LN_ITEMS_TL litl ', r); r:=r+1;

298: optional_row(' FEM_USER_DIM7_TL ud7tl, ', l_ud7_req, r);
299: optional_row(' FEM_USER_DIM8_TL ud8tl, ', l_ud8_req, r);
300: optional_row(' FEM_USER_DIM9_TL ud9tl, ', l_ud9_req, r);
301: optional_row(' FEM_USER_DIM10_TL ud10tl, ', l_ud10_req, r);
302: ad_ddl.build_statement(' FEM_LN_ITEMS_TL litl ', r); r:=r+1;
303: ad_ddl.build_statement('WHERE cotl.company_cost_center_org_id = fb.company_cost_center_org_id ', r); r:=r+1;
304: ad_ddl.build_statement('AND cotl.language = userenv(''LANG'') ', r); r:=r+1;
305: ad_ddl.build_statement('AND ictl.company_cost_center_org_id = fb.intercompany_id ', r); r:=r+1;
306: ad_ddl.build_statement('AND ictl.language = userenv(''LANG'') ', r); r:=r+1;

Line 303: ad_ddl.build_statement('WHERE cotl.company_cost_center_org_id = fb.company_cost_center_org_id ', r); r:=r+1;

299: optional_row(' FEM_USER_DIM8_TL ud8tl, ', l_ud8_req, r);
300: optional_row(' FEM_USER_DIM9_TL ud9tl, ', l_ud9_req, r);
301: optional_row(' FEM_USER_DIM10_TL ud10tl, ', l_ud10_req, r);
302: ad_ddl.build_statement(' FEM_LN_ITEMS_TL litl ', r); r:=r+1;
303: ad_ddl.build_statement('WHERE cotl.company_cost_center_org_id = fb.company_cost_center_org_id ', r); r:=r+1;
304: ad_ddl.build_statement('AND cotl.language = userenv(''LANG'') ', r); r:=r+1;
305: ad_ddl.build_statement('AND ictl.company_cost_center_org_id = fb.intercompany_id ', r); r:=r+1;
306: ad_ddl.build_statement('AND ictl.language = userenv(''LANG'') ', r); r:=r+1;
307: optional_row('AND fetl.financial_elem_id = fb.financial_elem_id ', l_fe_req, r);

Line 304: ad_ddl.build_statement('AND cotl.language = userenv(''LANG'') ', r); r:=r+1;

300: optional_row(' FEM_USER_DIM9_TL ud9tl, ', l_ud9_req, r);
301: optional_row(' FEM_USER_DIM10_TL ud10tl, ', l_ud10_req, r);
302: ad_ddl.build_statement(' FEM_LN_ITEMS_TL litl ', r); r:=r+1;
303: ad_ddl.build_statement('WHERE cotl.company_cost_center_org_id = fb.company_cost_center_org_id ', r); r:=r+1;
304: ad_ddl.build_statement('AND cotl.language = userenv(''LANG'') ', r); r:=r+1;
305: ad_ddl.build_statement('AND ictl.company_cost_center_org_id = fb.intercompany_id ', r); r:=r+1;
306: ad_ddl.build_statement('AND ictl.language = userenv(''LANG'') ', r); r:=r+1;
307: optional_row('AND fetl.financial_elem_id = fb.financial_elem_id ', l_fe_req, r);
308: optional_row('AND fetl.language = userenv(''LANG'') ', l_fe_req, r);

Line 305: ad_ddl.build_statement('AND ictl.company_cost_center_org_id = fb.intercompany_id ', r); r:=r+1;

301: optional_row(' FEM_USER_DIM10_TL ud10tl, ', l_ud10_req, r);
302: ad_ddl.build_statement(' FEM_LN_ITEMS_TL litl ', r); r:=r+1;
303: ad_ddl.build_statement('WHERE cotl.company_cost_center_org_id = fb.company_cost_center_org_id ', r); r:=r+1;
304: ad_ddl.build_statement('AND cotl.language = userenv(''LANG'') ', r); r:=r+1;
305: ad_ddl.build_statement('AND ictl.company_cost_center_org_id = fb.intercompany_id ', r); r:=r+1;
306: ad_ddl.build_statement('AND ictl.language = userenv(''LANG'') ', r); r:=r+1;
307: optional_row('AND fetl.financial_elem_id = fb.financial_elem_id ', l_fe_req, r);
308: optional_row('AND fetl.language = userenv(''LANG'') ', l_fe_req, r);
309: optional_row('AND pdtl.product_id = fb.product_id ', l_pd_req, r);

Line 306: ad_ddl.build_statement('AND ictl.language = userenv(''LANG'') ', r); r:=r+1;

302: ad_ddl.build_statement(' FEM_LN_ITEMS_TL litl ', r); r:=r+1;
303: ad_ddl.build_statement('WHERE cotl.company_cost_center_org_id = fb.company_cost_center_org_id ', r); r:=r+1;
304: ad_ddl.build_statement('AND cotl.language = userenv(''LANG'') ', r); r:=r+1;
305: ad_ddl.build_statement('AND ictl.company_cost_center_org_id = fb.intercompany_id ', r); r:=r+1;
306: ad_ddl.build_statement('AND ictl.language = userenv(''LANG'') ', r); r:=r+1;
307: optional_row('AND fetl.financial_elem_id = fb.financial_elem_id ', l_fe_req, r);
308: optional_row('AND fetl.language = userenv(''LANG'') ', l_fe_req, r);
309: optional_row('AND pdtl.product_id = fb.product_id ', l_pd_req, r);
310: optional_row('AND pdtl.language = userenv(''LANG'') ', l_pd_req, r);

Line 341: ad_ddl.build_statement('AND litl.line_item_id = fb.line_item_id ', r); r:=r+1;

337: optional_row('AND ud9tl.user_dim9_id = fb.user_dim9_id ', l_ud9_req, r);
338: optional_row('AND ud9tl.language = userenv(''LANG'') ', l_ud9_req, r);
339: optional_row('AND ud10tl.user_dim10_id = fb.user_dim10_id ', l_ud10_req, r);
340: optional_row('AND ud10tl.language = userenv(''LANG'') ', l_ud10_req, r);
341: ad_ddl.build_statement('AND litl.line_item_id = fb.line_item_id ', r); r:=r+1;
342: ad_ddl.build_statement('AND litl.language = userenv(''LANG'') ', r); r:=r+1;
343: ad_ddl.build_statement('AND fb.currency_type_code IN (''ENTERED'', ''TRANSLATED'') ', r);
344:
345: ad_ddl.do_array_ddl(appl, 'APPS', ad_ddl.create_view, 1, r, 'GCS_DYN_TB_V');

Line 342: ad_ddl.build_statement('AND litl.language = userenv(''LANG'') ', r); r:=r+1;

338: optional_row('AND ud9tl.language = userenv(''LANG'') ', l_ud9_req, r);
339: optional_row('AND ud10tl.user_dim10_id = fb.user_dim10_id ', l_ud10_req, r);
340: optional_row('AND ud10tl.language = userenv(''LANG'') ', l_ud10_req, r);
341: ad_ddl.build_statement('AND litl.line_item_id = fb.line_item_id ', r); r:=r+1;
342: ad_ddl.build_statement('AND litl.language = userenv(''LANG'') ', r); r:=r+1;
343: ad_ddl.build_statement('AND fb.currency_type_code IN (''ENTERED'', ''TRANSLATED'') ', r);
344:
345: ad_ddl.do_array_ddl(appl, 'APPS', ad_ddl.create_view, 1, r, 'GCS_DYN_TB_V');
346:

Line 343: ad_ddl.build_statement('AND fb.currency_type_code IN (''ENTERED'', ''TRANSLATED'') ', r);

339: optional_row('AND ud10tl.user_dim10_id = fb.user_dim10_id ', l_ud10_req, r);
340: optional_row('AND ud10tl.language = userenv(''LANG'') ', l_ud10_req, r);
341: ad_ddl.build_statement('AND litl.line_item_id = fb.line_item_id ', r); r:=r+1;
342: ad_ddl.build_statement('AND litl.language = userenv(''LANG'') ', r); r:=r+1;
343: ad_ddl.build_statement('AND fb.currency_type_code IN (''ENTERED'', ''TRANSLATED'') ', r);
344:
345: ad_ddl.do_array_ddl(appl, 'APPS', ad_ddl.create_view, 1, r, 'GCS_DYN_TB_V');
346:
347: module_log_write(module, g_module_success);

Line 345: ad_ddl.do_array_ddl(appl, 'APPS', ad_ddl.create_view, 1, r, 'GCS_DYN_TB_V');

341: ad_ddl.build_statement('AND litl.line_item_id = fb.line_item_id ', r); r:=r+1;
342: ad_ddl.build_statement('AND litl.language = userenv(''LANG'') ', r); r:=r+1;
343: ad_ddl.build_statement('AND fb.currency_type_code IN (''ENTERED'', ''TRANSLATED'') ', r);
344:
345: ad_ddl.do_array_ddl(appl, 'APPS', ad_ddl.create_view, 1, r, 'GCS_DYN_TB_V');
346:
347: module_log_write(module, g_module_success);
348: EXCEPTION
349: WHEN GCS_DYN_TB_APPLSYS_NOT_FOUND THEN