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.MSC_DEMANTRA_PKG dependencies on FND_GLOBAL

Line 188: ' fnd_global.user_id, sysdate,'||LF||

184: ' program_application_id, request_id)'||LF||
185: ' select'||LF||
186: ' t_ep_item.ebs_item_dest_key,'||LF||
187: ' '||list_result('select ''cast(''||gtable||''.''||cust_code_field||'' as varchar2(200))'' from ('||l_sql||') where gtable<>''t_ep_item''', ','||LF)||
188: ' fnd_global.user_id, sysdate,'||LF||
189: ' sysdate, fnd_global.user_id, fnd_global.login_id,'||LF||
190: ' fnd_global.conc_program_id, fnd_global.conc_login_id,'||LF||
191: ' fnd_global.prog_appl_id, fnd_global.conc_request_id'||LF||
192: ' from'||LF||

Line 189: ' sysdate, fnd_global.user_id, fnd_global.login_id,'||LF||

185: ' select'||LF||
186: ' t_ep_item.ebs_item_dest_key,'||LF||
187: ' '||list_result('select ''cast(''||gtable||''.''||cust_code_field||'' as varchar2(200))'' from ('||l_sql||') where gtable<>''t_ep_item''', ','||LF)||
188: ' fnd_global.user_id, sysdate,'||LF||
189: ' sysdate, fnd_global.user_id, fnd_global.login_id,'||LF||
190: ' fnd_global.conc_program_id, fnd_global.conc_login_id,'||LF||
191: ' fnd_global.prog_appl_id, fnd_global.conc_request_id'||LF||
192: ' from'||LF||
193: ' '||list_result('select '''||g_demantra_schema||'.''||gtable from ('||l_sql||') where gtable is not null', ', ')||' dual'||LF||

Line 190: ' fnd_global.conc_program_id, fnd_global.conc_login_id,'||LF||

186: ' t_ep_item.ebs_item_dest_key,'||LF||
187: ' '||list_result('select ''cast(''||gtable||''.''||cust_code_field||'' as varchar2(200))'' from ('||l_sql||') where gtable<>''t_ep_item''', ','||LF)||
188: ' fnd_global.user_id, sysdate,'||LF||
189: ' sysdate, fnd_global.user_id, fnd_global.login_id,'||LF||
190: ' fnd_global.conc_program_id, fnd_global.conc_login_id,'||LF||
191: ' fnd_global.prog_appl_id, fnd_global.conc_request_id'||LF||
192: ' from'||LF||
193: ' '||list_result('select '''||g_demantra_schema||'.''||gtable from ('||l_sql||') where gtable is not null', ', ')||' dual'||LF||
194: ' where'||LF||

Line 191: ' fnd_global.prog_appl_id, fnd_global.conc_request_id'||LF||

187: ' '||list_result('select ''cast(''||gtable||''.''||cust_code_field||'' as varchar2(200))'' from ('||l_sql||') where gtable<>''t_ep_item''', ','||LF)||
188: ' fnd_global.user_id, sysdate,'||LF||
189: ' sysdate, fnd_global.user_id, fnd_global.login_id,'||LF||
190: ' fnd_global.conc_program_id, fnd_global.conc_login_id,'||LF||
191: ' fnd_global.prog_appl_id, fnd_global.conc_request_id'||LF||
192: ' from'||LF||
193: ' '||list_result('select '''||g_demantra_schema||'.''||gtable from ('||l_sql||') where gtable is not null', ', ')||' dual'||LF||
194: ' where'||LF||
195: ' '||list_result('select gtable||''.''||id_field2||''=''||gtable2||''.''||id_field2 from ('||l_sql||') where gtable2 is not null', ' and '||LF)||

Line 245: fnd_global.user_id, sysdate,

241: program_id, program_login_id,
242: program_application_id, request_id)
243: values (
244: f.fact_type, f.column_name, null, null, null,
245: fnd_global.user_id, sysdate,
246: sysdate, fnd_global.user_id, fnd_global.login_id,
247: fnd_global.conc_program_id, fnd_global.conc_login_id,
248: fnd_global.prog_appl_id, fnd_global.conc_request_id);
249: msc_phub_util.log('msc_demantra_pkg.init_cust_measures_table: merge into msc_apcc_custom_measures: '||sql%rowcount);

Line 246: sysdate, fnd_global.user_id, fnd_global.login_id,

242: program_application_id, request_id)
243: values (
244: f.fact_type, f.column_name, null, null, null,
245: fnd_global.user_id, sysdate,
246: sysdate, fnd_global.user_id, fnd_global.login_id,
247: fnd_global.conc_program_id, fnd_global.conc_login_id,
248: fnd_global.prog_appl_id, fnd_global.conc_request_id);
249: msc_phub_util.log('msc_demantra_pkg.init_cust_measures_table: merge into msc_apcc_custom_measures: '||sql%rowcount);
250: commit;

Line 247: fnd_global.conc_program_id, fnd_global.conc_login_id,

243: values (
244: f.fact_type, f.column_name, null, null, null,
245: fnd_global.user_id, sysdate,
246: sysdate, fnd_global.user_id, fnd_global.login_id,
247: fnd_global.conc_program_id, fnd_global.conc_login_id,
248: fnd_global.prog_appl_id, fnd_global.conc_request_id);
249: msc_phub_util.log('msc_demantra_pkg.init_cust_measures_table: merge into msc_apcc_custom_measures: '||sql%rowcount);
250: commit;
251:

Line 248: fnd_global.prog_appl_id, fnd_global.conc_request_id);

244: f.fact_type, f.column_name, null, null, null,
245: fnd_global.user_id, sysdate,
246: sysdate, fnd_global.user_id, fnd_global.login_id,
247: fnd_global.conc_program_id, fnd_global.conc_login_id,
248: fnd_global.prog_appl_id, fnd_global.conc_request_id);
249: msc_phub_util.log('msc_demantra_pkg.init_cust_measures_table: merge into msc_apcc_custom_measures: '||sql%rowcount);
250: commit;
251:
252: delete from msc_apcc_custom_measures b

Line 330: fnd_global.user_id, sysdate,

326: fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate,0))
327: consensus_fcst_value2,
328: t.consensus_fcst_cum,
329: t.priority,
330: fnd_global.user_id, sysdate,
331: sysdate, fnd_global.user_id, fnd_global.login_id,
332: fnd_global.conc_program_id, fnd_global.conc_login_id,
333: fnd_global.prog_appl_id, fnd_global.conc_request_id
334: from (

Line 331: sysdate, fnd_global.user_id, fnd_global.login_id,

327: consensus_fcst_value2,
328: t.consensus_fcst_cum,
329: t.priority,
330: fnd_global.user_id, sysdate,
331: sysdate, fnd_global.user_id, fnd_global.login_id,
332: fnd_global.conc_program_id, fnd_global.conc_login_id,
333: fnd_global.prog_appl_id, fnd_global.conc_request_id
334: from (
335: select

Line 332: fnd_global.conc_program_id, fnd_global.conc_login_id,

328: t.consensus_fcst_cum,
329: t.priority,
330: fnd_global.user_id, sysdate,
331: sysdate, fnd_global.user_id, fnd_global.login_id,
332: fnd_global.conc_program_id, fnd_global.conc_login_id,
333: fnd_global.prog_appl_id, fnd_global.conc_request_id
334: from (
335: select
336: k.scenario_id,

Line 333: fnd_global.prog_appl_id, fnd_global.conc_request_id

329: t.priority,
330: fnd_global.user_id, sysdate,
331: sysdate, fnd_global.user_id, fnd_global.login_id,
332: fnd_global.conc_program_id, fnd_global.conc_login_id,
333: fnd_global.prog_appl_id, fnd_global.conc_request_id
334: from (
335: select
336: k.scenario_id,
337: k.sr_instance_id,

Line 449: ' fnd_global.user_id, sysdate,'||LF||

445: ' created_by, creation_date,'||LF||
446: ' last_update_date, last_updated_by, last_update_login)'||LF||
447: ' select'||LF||
448: ' '||l_qid_wf||', schema_id, to_lob(schema_data),'||LF||
449: ' fnd_global.user_id, sysdate,'||LF||
450: ' sysdate, fnd_global.user_id, fnd_global.login_id'||LF||
451: ' from '||g_demantra_schema||'.wf_schemas';
452:
453: msc_phub_util.log_sql(l_sql);

Line 450: ' sysdate, fnd_global.user_id, fnd_global.login_id'||LF||

446: ' last_update_date, last_updated_by, last_update_login)'||LF||
447: ' select'||LF||
448: ' '||l_qid_wf||', schema_id, to_lob(schema_data),'||LF||
449: ' fnd_global.user_id, sysdate,'||LF||
450: ' sysdate, fnd_global.user_id, fnd_global.login_id'||LF||
451: ' from '||g_demantra_schema||'.wf_schemas';
452:
453: msc_phub_util.log_sql(l_sql);
454: execute immediate l_sql;

Line 509: last_updated_by=fnd_global.user_id,

505: set source_column_name=null,
506: column_title=null,
507: aggregation_method=null,
508: last_update_date=sysdate,
509: last_updated_by=fnd_global.user_id,
510: last_update_login=fnd_global.login_id,
511: program_id=fnd_global.conc_program_id,
512: program_login_id=fnd_global.conc_login_id,
513: program_application_id=fnd_global.prog_appl_id,

Line 510: last_update_login=fnd_global.login_id,

506: column_title=null,
507: aggregation_method=null,
508: last_update_date=sysdate,
509: last_updated_by=fnd_global.user_id,
510: last_update_login=fnd_global.login_id,
511: program_id=fnd_global.conc_program_id,
512: program_login_id=fnd_global.conc_login_id,
513: program_application_id=fnd_global.prog_appl_id,
514: request_id=fnd_global.conc_request_id

Line 511: program_id=fnd_global.conc_program_id,

507: aggregation_method=null,
508: last_update_date=sysdate,
509: last_updated_by=fnd_global.user_id,
510: last_update_login=fnd_global.login_id,
511: program_id=fnd_global.conc_program_id,
512: program_login_id=fnd_global.conc_login_id,
513: program_application_id=fnd_global.prog_appl_id,
514: request_id=fnd_global.conc_request_id
515: where fact_type=l_fact_type and source_column_name=l_source_column_name;

Line 512: program_login_id=fnd_global.conc_login_id,

508: last_update_date=sysdate,
509: last_updated_by=fnd_global.user_id,
510: last_update_login=fnd_global.login_id,
511: program_id=fnd_global.conc_program_id,
512: program_login_id=fnd_global.conc_login_id,
513: program_application_id=fnd_global.prog_appl_id,
514: request_id=fnd_global.conc_request_id
515: where fact_type=l_fact_type and source_column_name=l_source_column_name;
516: commit;

Line 513: program_application_id=fnd_global.prog_appl_id,

509: last_updated_by=fnd_global.user_id,
510: last_update_login=fnd_global.login_id,
511: program_id=fnd_global.conc_program_id,
512: program_login_id=fnd_global.conc_login_id,
513: program_application_id=fnd_global.prog_appl_id,
514: request_id=fnd_global.conc_request_id
515: where fact_type=l_fact_type and source_column_name=l_source_column_name;
516: commit;
517:

Line 514: request_id=fnd_global.conc_request_id

510: last_update_login=fnd_global.login_id,
511: program_id=fnd_global.conc_program_id,
512: program_login_id=fnd_global.conc_login_id,
513: program_application_id=fnd_global.prog_appl_id,
514: request_id=fnd_global.conc_request_id
515: where fact_type=l_fact_type and source_column_name=l_source_column_name;
516: commit;
517:
518: when l_op='I' then

Line 529: last_updated_by=fnd_global.user_id,

525: set source_column_name=l_source_column_name,
526: column_title=l_column_title,
527: aggregation_method=l_aggregation_method,
528: last_update_date=sysdate,
529: last_updated_by=fnd_global.user_id,
530: last_update_login=fnd_global.login_id,
531: program_id=fnd_global.conc_program_id,
532: program_login_id=fnd_global.conc_login_id,
533: program_application_id=fnd_global.prog_appl_id,

Line 530: last_update_login=fnd_global.login_id,

526: column_title=l_column_title,
527: aggregation_method=l_aggregation_method,
528: last_update_date=sysdate,
529: last_updated_by=fnd_global.user_id,
530: last_update_login=fnd_global.login_id,
531: program_id=fnd_global.conc_program_id,
532: program_login_id=fnd_global.conc_login_id,
533: program_application_id=fnd_global.prog_appl_id,
534: request_id=fnd_global.conc_request_id

Line 531: program_id=fnd_global.conc_program_id,

527: aggregation_method=l_aggregation_method,
528: last_update_date=sysdate,
529: last_updated_by=fnd_global.user_id,
530: last_update_login=fnd_global.login_id,
531: program_id=fnd_global.conc_program_id,
532: program_login_id=fnd_global.conc_login_id,
533: program_application_id=fnd_global.prog_appl_id,
534: request_id=fnd_global.conc_request_id
535: where fact_type=l_fact_type and column_name=l_column_name;

Line 532: program_login_id=fnd_global.conc_login_id,

528: last_update_date=sysdate,
529: last_updated_by=fnd_global.user_id,
530: last_update_login=fnd_global.login_id,
531: program_id=fnd_global.conc_program_id,
532: program_login_id=fnd_global.conc_login_id,
533: program_application_id=fnd_global.prog_appl_id,
534: request_id=fnd_global.conc_request_id
535: where fact_type=l_fact_type and column_name=l_column_name;
536: commit;

Line 533: program_application_id=fnd_global.prog_appl_id,

529: last_updated_by=fnd_global.user_id,
530: last_update_login=fnd_global.login_id,
531: program_id=fnd_global.conc_program_id,
532: program_login_id=fnd_global.conc_login_id,
533: program_application_id=fnd_global.prog_appl_id,
534: request_id=fnd_global.conc_request_id
535: where fact_type=l_fact_type and column_name=l_column_name;
536: commit;
537:

Line 534: request_id=fnd_global.conc_request_id

530: last_update_login=fnd_global.login_id,
531: program_id=fnd_global.conc_program_id,
532: program_login_id=fnd_global.conc_login_id,
533: program_application_id=fnd_global.prog_appl_id,
534: request_id=fnd_global.conc_request_id
535: where fact_type=l_fact_type and column_name=l_column_name;
536: commit;
537:
538: when l_op='U' then

Line 541: last_updated_by=fnd_global.user_id,

537:
538: when l_op='U' then
539: update msc_apcc_custom_measures
540: set last_update_date=sysdate,
541: last_updated_by=fnd_global.user_id,
542: last_update_login=fnd_global.login_id,
543: program_id=fnd_global.conc_program_id,
544: program_login_id=fnd_global.conc_login_id,
545: program_application_id=fnd_global.prog_appl_id,

Line 542: last_update_login=fnd_global.login_id,

538: when l_op='U' then
539: update msc_apcc_custom_measures
540: set last_update_date=sysdate,
541: last_updated_by=fnd_global.user_id,
542: last_update_login=fnd_global.login_id,
543: program_id=fnd_global.conc_program_id,
544: program_login_id=fnd_global.conc_login_id,
545: program_application_id=fnd_global.prog_appl_id,
546: request_id=fnd_global.conc_request_id

Line 543: program_id=fnd_global.conc_program_id,

539: update msc_apcc_custom_measures
540: set last_update_date=sysdate,
541: last_updated_by=fnd_global.user_id,
542: last_update_login=fnd_global.login_id,
543: program_id=fnd_global.conc_program_id,
544: program_login_id=fnd_global.conc_login_id,
545: program_application_id=fnd_global.prog_appl_id,
546: request_id=fnd_global.conc_request_id
547: where fact_type=l_fact_type and source_column_name=l_source_column_name;

Line 544: program_login_id=fnd_global.conc_login_id,

540: set last_update_date=sysdate,
541: last_updated_by=fnd_global.user_id,
542: last_update_login=fnd_global.login_id,
543: program_id=fnd_global.conc_program_id,
544: program_login_id=fnd_global.conc_login_id,
545: program_application_id=fnd_global.prog_appl_id,
546: request_id=fnd_global.conc_request_id
547: where fact_type=l_fact_type and source_column_name=l_source_column_name;
548: commit;

Line 545: program_application_id=fnd_global.prog_appl_id,

541: last_updated_by=fnd_global.user_id,
542: last_update_login=fnd_global.login_id,
543: program_id=fnd_global.conc_program_id,
544: program_login_id=fnd_global.conc_login_id,
545: program_application_id=fnd_global.prog_appl_id,
546: request_id=fnd_global.conc_request_id
547: where fact_type=l_fact_type and source_column_name=l_source_column_name;
548: commit;
549:

Line 546: request_id=fnd_global.conc_request_id

542: last_update_login=fnd_global.login_id,
543: program_id=fnd_global.conc_program_id,
544: program_login_id=fnd_global.conc_login_id,
545: program_application_id=fnd_global.prog_appl_id,
546: request_id=fnd_global.conc_request_id
547: where fact_type=l_fact_type and source_column_name=l_source_column_name;
548: commit;
549:
550: end case;

Line 861: ' fnd_global.user_id, sysdate,'||LF||

857: ' to_number(42) aggr_type,'||LF||
858: ' '||l_category_set_id1||' category_set_id,'||LF||
859: ' nvl(q.sr_category_id, -23453),'||LF||
860: ' '||list_measures(5, 'f', p_fact_type, null)||LF||
861: ' fnd_global.user_id, sysdate,'||LF||
862: ' sysdate, fnd_global.user_id, fnd_global.login_id,'||LF||
863: ' fnd_global.conc_program_id, fnd_global.conc_login_id,'||LF||
864: ' fnd_global.prog_appl_id, fnd_global.conc_request_id'||LF||
865: ' from'||LF||

Line 862: ' sysdate, fnd_global.user_id, fnd_global.login_id,'||LF||

858: ' '||l_category_set_id1||' category_set_id,'||LF||
859: ' nvl(q.sr_category_id, -23453),'||LF||
860: ' '||list_measures(5, 'f', p_fact_type, null)||LF||
861: ' fnd_global.user_id, sysdate,'||LF||
862: ' sysdate, fnd_global.user_id, fnd_global.login_id,'||LF||
863: ' fnd_global.conc_program_id, fnd_global.conc_login_id,'||LF||
864: ' fnd_global.prog_appl_id, fnd_global.conc_request_id'||LF||
865: ' from'||LF||
866: ' msc_demantra_f f,'||LF||

Line 863: ' fnd_global.conc_program_id, fnd_global.conc_login_id,'||LF||

859: ' nvl(q.sr_category_id, -23453),'||LF||
860: ' '||list_measures(5, 'f', p_fact_type, null)||LF||
861: ' fnd_global.user_id, sysdate,'||LF||
862: ' sysdate, fnd_global.user_id, fnd_global.login_id,'||LF||
863: ' fnd_global.conc_program_id, fnd_global.conc_login_id,'||LF||
864: ' fnd_global.prog_appl_id, fnd_global.conc_request_id'||LF||
865: ' from'||LF||
866: ' msc_demantra_f f,'||LF||
867: ' msc_phub_item_categories_mv q'||LF||

Line 864: ' fnd_global.prog_appl_id, fnd_global.conc_request_id'||LF||

860: ' '||list_measures(5, 'f', p_fact_type, null)||LF||
861: ' fnd_global.user_id, sysdate,'||LF||
862: ' sysdate, fnd_global.user_id, fnd_global.login_id,'||LF||
863: ' fnd_global.conc_program_id, fnd_global.conc_login_id,'||LF||
864: ' fnd_global.prog_appl_id, fnd_global.conc_request_id'||LF||
865: ' from'||LF||
866: ' msc_demantra_f f,'||LF||
867: ' msc_phub_item_categories_mv q'||LF||
868: ' where f.plan_id='||p_plan_id||' and f.plan_run_id='||p_plan_run_id||LF||

Line 943: ' fnd_global.user_id, sysdate,'||LF||

939: ' nvl(t.demand_class, -''23453''),'||LF||
940: ' '||LF||
941: ' '||list_measures(6, 't', p_fact_type, null)||LF||
942: ' '||LF||
943: ' fnd_global.user_id, sysdate,'||LF||
944: ' sysdate, fnd_global.user_id, fnd_global.login_id,'||LF||
945: ' fnd_global.conc_program_id, fnd_global.conc_login_id,'||LF||
946: ' fnd_global.prog_appl_id, fnd_global.conc_request_id'||LF||
947: ' from '||l_staging_table||' t'||LF||

Line 944: ' sysdate, fnd_global.user_id, fnd_global.login_id,'||LF||

940: ' '||LF||
941: ' '||list_measures(6, 't', p_fact_type, null)||LF||
942: ' '||LF||
943: ' fnd_global.user_id, sysdate,'||LF||
944: ' sysdate, fnd_global.user_id, fnd_global.login_id,'||LF||
945: ' fnd_global.conc_program_id, fnd_global.conc_login_id,'||LF||
946: ' fnd_global.prog_appl_id, fnd_global.conc_request_id'||LF||
947: ' from '||l_staging_table||' t'||LF||
948: ' where st_transaction_id='||p_st_transaction_id||' and error_code=0';

Line 945: ' fnd_global.conc_program_id, fnd_global.conc_login_id,'||LF||

941: ' '||list_measures(6, 't', p_fact_type, null)||LF||
942: ' '||LF||
943: ' fnd_global.user_id, sysdate,'||LF||
944: ' sysdate, fnd_global.user_id, fnd_global.login_id,'||LF||
945: ' fnd_global.conc_program_id, fnd_global.conc_login_id,'||LF||
946: ' fnd_global.prog_appl_id, fnd_global.conc_request_id'||LF||
947: ' from '||l_staging_table||' t'||LF||
948: ' where st_transaction_id='||p_st_transaction_id||' and error_code=0';
949:

Line 946: ' fnd_global.prog_appl_id, fnd_global.conc_request_id'||LF||

942: ' '||LF||
943: ' fnd_global.user_id, sysdate,'||LF||
944: ' sysdate, fnd_global.user_id, fnd_global.login_id,'||LF||
945: ' fnd_global.conc_program_id, fnd_global.conc_login_id,'||LF||
946: ' fnd_global.prog_appl_id, fnd_global.conc_request_id'||LF||
947: ' from '||l_staging_table||' t'||LF||
948: ' where st_transaction_id='||p_st_transaction_id||' and error_code=0';
949:
950: msc_phub_util.log_sql(l_sql);

Line 1063: ' fnd_global.user_id, sysdate,'||LF||

1059: ' t.demand_class,'||LF||
1060: ' '||LF||
1061: ' '||list_measures(3, 't', p_fact_type, p_publisher)||LF||
1062: ' '||LF||
1063: ' fnd_global.user_id, sysdate,'||LF||
1064: ' sysdate, fnd_global.user_id, fnd_global.login_id,'||LF||
1065: ' fnd_global.conc_program_id, fnd_global.conc_login_id,'||LF||
1066: ' fnd_global.prog_appl_id, fnd_global.conc_request_id'||LF||
1067: ' from'||LF||

Line 1064: ' sysdate, fnd_global.user_id, fnd_global.login_id,'||LF||

1060: ' '||LF||
1061: ' '||list_measures(3, 't', p_fact_type, p_publisher)||LF||
1062: ' '||LF||
1063: ' fnd_global.user_id, sysdate,'||LF||
1064: ' sysdate, fnd_global.user_id, fnd_global.login_id,'||LF||
1065: ' fnd_global.conc_program_id, fnd_global.conc_login_id,'||LF||
1066: ' fnd_global.prog_appl_id, fnd_global.conc_request_id'||LF||
1067: ' from'||LF||
1068: ' (select'||LF||

Line 1065: ' fnd_global.conc_program_id, fnd_global.conc_login_id,'||LF||

1061: ' '||list_measures(3, 't', p_fact_type, p_publisher)||LF||
1062: ' '||LF||
1063: ' fnd_global.user_id, sysdate,'||LF||
1064: ' sysdate, fnd_global.user_id, fnd_global.login_id,'||LF||
1065: ' fnd_global.conc_program_id, fnd_global.conc_login_id,'||LF||
1066: ' fnd_global.prog_appl_id, fnd_global.conc_request_id'||LF||
1067: ' from'||LF||
1068: ' (select'||LF||
1069: ' t.sr_instance_id,'||LF||

Line 1066: ' fnd_global.prog_appl_id, fnd_global.conc_request_id'||LF||

1062: ' '||LF||
1063: ' fnd_global.user_id, sysdate,'||LF||
1064: ' sysdate, fnd_global.user_id, fnd_global.login_id,'||LF||
1065: ' fnd_global.conc_program_id, fnd_global.conc_login_id,'||LF||
1066: ' fnd_global.prog_appl_id, fnd_global.conc_request_id'||LF||
1067: ' from'||LF||
1068: ' (select'||LF||
1069: ' t.sr_instance_id,'||LF||
1070: ' t.organization_id,'||LF||

Line 1488: ' fnd_global.user_id, sysdate,'||

1484: ' f.attribute7,'||
1485: ' f.attribute8,'||
1486: ' f.attribute9,'||
1487: ' f.attribute10,'||
1488: ' fnd_global.user_id, sysdate,'||
1489: ' fnd_global.user_id, sysdate, fnd_global.login_id'||
1490: ' from'||
1491: ' '||l_apps_schema||'.msc_demantra_f'||l_suffix||' f,'||
1492: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp,'||

Line 1489: ' fnd_global.user_id, sysdate, fnd_global.login_id'||

1485: ' f.attribute8,'||
1486: ' f.attribute9,'||
1487: ' f.attribute10,'||
1488: ' fnd_global.user_id, sysdate,'||
1489: ' fnd_global.user_id, sysdate, fnd_global.login_id'||
1490: ' from'||
1491: ' '||l_apps_schema||'.msc_demantra_f'||l_suffix||' f,'||
1492: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp,'||
1493: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp2,'||

Line 1615: ' fnd_global.user_id, sysdate,'||

1611: ' sum(f.shipment_fcst),'||
1612: ' sum(f.shipment_fcst_cum),'||
1613: ' sum(f.shipment_fcst_value),'||
1614: ' sum(f.shipment_fcst_value2),'||
1615: ' fnd_global.user_id, sysdate,'||
1616: ' fnd_global.user_id, sysdate, fnd_global.login_id'||
1617: ' from'||
1618: ' (select'||
1619: ' sr_instance_id,'||

Line 1616: ' fnd_global.user_id, sysdate, fnd_global.login_id'||

1612: ' sum(f.shipment_fcst_cum),'||
1613: ' sum(f.shipment_fcst_value),'||
1614: ' sum(f.shipment_fcst_value2),'||
1615: ' fnd_global.user_id, sysdate,'||
1616: ' fnd_global.user_id, sysdate, fnd_global.login_id'||
1617: ' from'||
1618: ' (select'||
1619: ' sr_instance_id,'||
1620: ' organization_id,'||

Line 1856: ' fnd_global.user_id, sysdate,'||

1852: ' f.booking_history_rd_value,'||
1853: ' f.booking_history_rd_value2,';
1854: end if;
1855: l_sql := l_sql||
1856: ' fnd_global.user_id, sysdate,'||
1857: ' fnd_global.user_id, sysdate, fnd_global.login_id'||
1858: ' from'||
1859: ' '||l_apps_schema||'.msc_demantra_ods_f'||l_suffix||' f,'||
1860: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp,';

Line 1857: ' fnd_global.user_id, sysdate, fnd_global.login_id'||

1853: ' f.booking_history_rd_value2,';
1854: end if;
1855: l_sql := l_sql||
1856: ' fnd_global.user_id, sysdate,'||
1857: ' fnd_global.user_id, sysdate, fnd_global.login_id'||
1858: ' from'||
1859: ' '||l_apps_schema||'.msc_demantra_ods_f'||l_suffix||' f,'||
1860: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp,';
1861: if (p_source_version > '11.5.10') then l_sql := l_sql||