APPS.MSC_PERS_QUERIES dependencies on FND_GLOBAL

Line 72: l_who_cols varchar2(1000) := fnd_global.user_id||',sysdate,sysdate,'

68:
69: l_select_begin varchar2(1000) :=' select distinct '||to_char(p_query_id)
70: ||', nvl(plan_id,-1), nvl(organization_id,-1), nvl(sr_instance_id,-1), ';
71:
72: l_who_cols varchar2(1000) := fnd_global.user_id||',sysdate,sysdate,'
73: ||fnd_global.user_id||', null';
74: l_who_cols1 varchar2(1000);
75:
76: l_cp_context varchar2(200) := 'and ( COMPANY_ID= SYS_CONTEXT(''MSC'',''COMPANY_ID'') OR OWNING_COMPANY_ID= SYS_CONTEXT(''MSC'',''COMPANY_ID'') ) ';

Line 73: ||fnd_global.user_id||', null';

69: l_select_begin varchar2(1000) :=' select distinct '||to_char(p_query_id)
70: ||', nvl(plan_id,-1), nvl(organization_id,-1), nvl(sr_instance_id,-1), ';
71:
72: l_who_cols varchar2(1000) := fnd_global.user_id||',sysdate,sysdate,'
73: ||fnd_global.user_id||', null';
74: l_who_cols1 varchar2(1000);
75:
76: l_cp_context varchar2(200) := 'and ( COMPANY_ID= SYS_CONTEXT(''MSC'',''COMPANY_ID'') OR OWNING_COMPANY_ID= SYS_CONTEXT(''MSC'',''COMPANY_ID'') ) ';
77: l_view varchar2(100);

Line 391: fnd_global.user_id, sysdate,

387: INVENTORY_ITEM_ID, --groupby_supply_item,
388: CATEGORY_ID, PLANNER_CODE,
389: CUSTOMER_iD, SUPPLIER_ID,
390: CUSTOMER_SITE_ID, SUPPLIER_SITE_ID,
391: fnd_global.user_id, sysdate,
392: fnd_global.user_id, SYSDATE,
393: detail_query_id,PRIORITY
394: FROM MSC_PQ_RESULTS
395: WHERE query_id = l_temp_query_id

Line 392: fnd_global.user_id, SYSDATE,

388: CATEGORY_ID, PLANNER_CODE,
389: CUSTOMER_iD, SUPPLIER_ID,
390: CUSTOMER_SITE_ID, SUPPLIER_SITE_ID,
391: fnd_global.user_id, sysdate,
392: fnd_global.user_id, SYSDATE,
393: detail_query_id,PRIORITY
394: FROM MSC_PQ_RESULTS
395: WHERE query_id = l_temp_query_id
396: AND plan_id = p_plan_id

Line 567: fnd_global.user_id,

563: char2,
564: char3,
565: char4,
566: char5,
567: fnd_global.user_id,
568: sysdate,
569: fnd_global.user_id,
570: sysdate
571: FROM MSC_PQ_RESULTS

Line 569: fnd_global.user_id,

565: char4,
566: char5,
567: fnd_global.user_id,
568: sysdate,
569: fnd_global.user_id,
570: sysdate
571: FROM MSC_PQ_RESULTS
572: WHERE query_id = l_temp_query_id --p_query_id
573: and plan_id = p_plan_id

Line 1056: fnd_global.user_id||', SYSDATE, '||

1052: 'mpr1.sr_instance_id, mpr1.organization_id,'||
1053: 'sum(mpr1.exception_count) exception_count,'||
1054: 'MIN(mpr1.priority) priority,'||1||
1055: l_new_group_by_cols3||
1056: fnd_global.user_id||', SYSDATE, '||
1057: fnd_global.user_id||', SYSDATE'||
1058: ' from ( select mpr.query_id, mpr.plan_id,'||
1059: 'mpr.sr_instance_id, mpr.organization_id,'||
1060: 'nvl(mpr.exception_count,1) exception_count,'||

Line 1057: fnd_global.user_id||', SYSDATE'||

1053: 'sum(mpr1.exception_count) exception_count,'||
1054: 'MIN(mpr1.priority) priority,'||1||
1055: l_new_group_by_cols3||
1056: fnd_global.user_id||', SYSDATE, '||
1057: fnd_global.user_id||', SYSDATE'||
1058: ' from ( select mpr.query_id, mpr.plan_id,'||
1059: 'mpr.sr_instance_id, mpr.organization_id,'||
1060: 'nvl(mpr.exception_count,1) exception_count,'||
1061: 'mpr.priority'||