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_PERS_QUERIES dependencies on FND_GLOBAL

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

58:
59: l_select_begin varchar2(1000) :=' select distinct '||to_char(p_query_id)
60: ||', nvl(plan_id,-1), nvl(organization_id,-1), nvl(sr_instance_id,-1), ';
61:
62: l_who_cols varchar2(1000) := fnd_global.user_id||',sysdate,sysdate,'
63: ||fnd_global.user_id||', null';
64: l_who_cols1 varchar2(1000);
65:
66: l_cp_context varchar2(200) := 'and ( COMPANY_ID= SYS_CONTEXT(''MSC'',''COMPANY_ID'') OR OWNING_COMPANY_ID= SYS_CONTEXT(''MSC'',''COMPANY_ID'') ) ';

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

59: l_select_begin varchar2(1000) :=' select distinct '||to_char(p_query_id)
60: ||', nvl(plan_id,-1), nvl(organization_id,-1), nvl(sr_instance_id,-1), ';
61:
62: l_who_cols varchar2(1000) := fnd_global.user_id||',sysdate,sysdate,'
63: ||fnd_global.user_id||', null';
64: l_who_cols1 varchar2(1000);
65:
66: l_cp_context varchar2(200) := 'and ( COMPANY_ID= SYS_CONTEXT(''MSC'',''COMPANY_ID'') OR OWNING_COMPANY_ID= SYS_CONTEXT(''MSC'',''COMPANY_ID'') ) ';
67: l_view varchar2(100);

Line 334: fnd_global.user_id, sysdate,

330: INVENTORY_ITEM_ID, --groupby_supply_item,
331: CATEGORY_ID, PLANNER_CODE,
332: CUSTOMER_iD, SUPPLIER_ID,
333: CUSTOMER_SITE_ID, SUPPLIER_SITE_ID,
334: fnd_global.user_id, sysdate,
335: fnd_global.user_id, SYSDATE,
336: detail_query_id,PRIORITY
337: FROM MSC_PQ_RESULTS
338: WHERE query_id = l_temp_query_id

Line 335: fnd_global.user_id, SYSDATE,

331: CATEGORY_ID, PLANNER_CODE,
332: CUSTOMER_iD, SUPPLIER_ID,
333: CUSTOMER_SITE_ID, SUPPLIER_SITE_ID,
334: fnd_global.user_id, sysdate,
335: fnd_global.user_id, SYSDATE,
336: detail_query_id,PRIORITY
337: FROM MSC_PQ_RESULTS
338: WHERE query_id = l_temp_query_id
339: AND plan_id = p_plan_id

Line 507: fnd_global.user_id,

503: char2,
504: char3,
505: char4,
506: char5,
507: fnd_global.user_id,
508: sysdate,
509: fnd_global.user_id,
510: sysdate
511: FROM MSC_PQ_RESULTS

Line 509: fnd_global.user_id,

505: char4,
506: char5,
507: fnd_global.user_id,
508: sysdate,
509: fnd_global.user_id,
510: sysdate
511: FROM MSC_PQ_RESULTS
512: WHERE query_id = l_temp_query_id --p_query_id
513: and plan_id = p_plan_id