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.GMD_OUTBOUND_APIS_PUB dependencies on FND_USER

Line 25: --* user_id is not in FND_USERS table. *

21: --* 18Dec03 Brenda Stone Bug 3124643 Fetch Sample Groups; Changed *
22: --* r.recipe_no to r.recipe_vers *
23: --* 26Dec03 Brenda Stone Bug 3133163; Default test method was not retrieved, *
24: --* Added wildcard (+) since the default test methods's *
25: --* user_id is not in FND_USERS table. *
26: --* 29Dec03 Brenda Stone Bug 3124620; Fetch_Sample_Groups, Changed where clause *
27: --* to validate the orgn_code * *
28: --* 29Dec03 Brenda Stone Bug 3124643; Fetch_Sample_Groups, Changed r.recipe_no*
29: --* to r.recipe_version *

Line 74: FROM fnd_user

70: l_user_id NUMBER;
71: BEGIN
72:
73: SELECT user_id INTO l_user_id
74: FROM fnd_user
75: WHERE user_name = UPPER(p_user_name)
76: AND SYSDATE BETWEEN start_date AND NVL(end_date,sysdate+1);
77:
78: FND_GLOBAL.apps_initialize(l_user_id, NULL, NULL, 0);

Line 166: table_list :='FROM gmd_test_methods gtm, fnd_user fu1, fnd_user fu2 ';

162: ||'gtm.attribute30, gtm.attribute_category, gtm.creation_date, '
163: ||'gtm.created_by, fu1.user_name, gtm.last_updated_by, fu2.user_name, '
164: ||'gtm.last_update_date, gtm.last_update_login) ';
165:
166: table_list :='FROM gmd_test_methods gtm, fnd_user fu1, fnd_user fu2 ';
167:
168:
169: -- We now have the first three strings built. Here comes the good bit: building the where and using
170: -- clauses and inserting the bind variables and values.

Line 174: -- since the default test methods's user_id is not in FND_USERS

170: -- clauses and inserting the bind variables and values.
171:
172:
173: -- Bug 3133163; Default test method was not retrieved, Added wildcard (+)
174: -- since the default test methods's user_id is not in FND_USERS
175: -- table.
176: where_clause := 'WHERE fu1.user_id (+) = gtm.created_by '||
177: ' AND fu2.user_id (+) = gtm.last_updated_by '||
178: 'AND 1=:dummy ';

Line 349: FROM gmd_qc_test_values gtv, fnd_user fu1, fnd_user fu2

345: , gtv.attribute27, gtv.attribute28, gtv.attribute29, gtv.attribute30, gtv.creation_date, gtv.created_by
346: , fu1.user_name, gtv.last_update_date, gtv.last_updated_by, fu2.user_name
347: , gtv.last_update_login
348: )
349: FROM gmd_qc_test_values gtv, fnd_user fu1, fnd_user fu2
350: WHERE gtv.test_id = p_test_id
351: AND fu1.user_id = gtv.created_by
352: AND fu2.user_id = gtv.last_updated_by;
353:

Line 360: FROM gmd_customer_tests gct, op_cust_mst ocm, fnd_user fu1, fnd_user fu2

356: ( gct.cust_id, ocm.cust_no, gct.report_precision, gct.cust_test_display, gct.text_code
357: , gct.creation_date, gct.created_by, fu1.user_name, gct.last_update_date
358: , gct.last_updated_by, fu2.user_name, gct.last_update_login
359: )
360: FROM gmd_customer_tests gct, op_cust_mst ocm, fnd_user fu1, fnd_user fu2
361: WHERE gct.test_id = p_test_id
362: AND gct.cust_id = ocm.cust_id
363: AND gct.created_by = fu1.user_id
364: AND gct.last_updated_by = fu2.user_id;

Line 410: table_list := ' FROM gmd_qc_tests gqt, gmd_test_methods gtm, fnd_user fu1, fnd_user fu2';

406: ||', fu2.user_name, gqt.last_update_login'
407: ||', system.gmd_qc_test_values_tab_type (NULL), system.gmd_customer_tests_tab_type(NULL)' -- 5284242
408: ||')';
409:
410: table_list := ' FROM gmd_qc_tests gqt, gmd_test_methods gtm, fnd_user fu1, fnd_user fu2';
411:
412: where_clause := ' WHERE gqt.test_method_id = gtm.test_method_id'
413: ||' AND fu1.user_id=gqt.created_by'
414: ||' AND fu2.user_id=gqt.last_updated_by'

Line 877: main_table_list := ' gmd_specifications gs, fnd_user fu1, fnd_user fu2, fnd_user fu3, gmd_status gstat';

873: ||', gs.attribute28, gs.attribute29, gs.attribute30, gs.creation_date'
874: ||', gs.created_by, fu1.user_name, gs.last_update_date'
875: ||', gs.last_updated_by, fu2.user_name, gs.last_update_login';
876:
877: main_table_list := ' gmd_specifications gs, fnd_user fu1, fnd_user fu2, fnd_user fu3, gmd_status gstat';
878:
879: main_where_clause := ' gs.created_by = fu1.user_id'
880: ||' AND gs.last_updated_by = fu2.user_id'
881: ||' AND gs.owner_id = fu3.user_id'

Line 919: spec_test_table_list := ' gmd_spec_tests gst, fnd_user fu4, fnd_user fu5, gmd_test_methods gtm, gmd_qc_tests gqt';

915: ||', gst.created_by, fu4.user_name, gst.last_update_date'
916: ||', gst.last_updated_by, fu5.user_name, gst.last_update_login'
917: ||')';
918:
919: spec_test_table_list := ' gmd_spec_tests gst, fnd_user fu4, fnd_user fu5, gmd_test_methods gtm, gmd_qc_tests gqt';
920:
921: spec_test_where_clause := ' gst.created_by = fu4.user_id AND gst.last_updated_by=fu5.user_id '
922: ||' AND gst.test_id = gqt.test_id AND gst.test_method_id=gtm.test_method_id'
923: ||' AND gst.spec_id = gs.spec_id AND 1=:dummy2 ';

Line 945: cust_vr_table_list := ' gmd_customer_spec_vrs cvr, fnd_user fu6, fnd_user fu7, oe_order_headers_all oeh';

941: ||', cvr.attribute26, cvr.attribute27, cvr.attribute28, cvr.attribute29, cvr.attribute30'
942: ||', cvr.creation_date, cvr.created_by, fu6.user_name, cvr.last_update_date'
943: ||', cvr.last_updated_by, fu7.user_name, cvr.last_update_login'
944: ||')';
945: cust_vr_table_list := ' gmd_customer_spec_vrs cvr, fnd_user fu6, fnd_user fu7, oe_order_headers_all oeh';
946:
947: cust_vr_where_clause := ' cvr.created_by = fu6.user_id AND cvr.last_updated_by = fu7.user_id'
948: ||' AND cvr.spec_id = gs.spec_id AND cvr.order_id = oeh.header_id(+) AND 1=:dummy3';
949:

Line 975: wip_vr_table_list := ' gmd_wip_spec_vrs wvr, fnd_user fu8, fnd_user fu9, gme_batch_header gbh';

971: ||', wvr.creation_date, wvr.created_by, fu8.user_name, wvr.last_update_date'
972: ||', wvr.last_updated_by, fu9.user_name, wvr.last_update_login'
973: ||')';
974:
975: wip_vr_table_list := ' gmd_wip_spec_vrs wvr, fnd_user fu8, fnd_user fu9, gme_batch_header gbh';
976:
977: wip_vr_where_clause := ' wvr.created_by = fu8.user_id AND wvr.last_updated_by = fu9.user_id'
978: ||' AND wvr.batch_id= gbh.batch_id(+) and gbh.batch_type(+) = 0'
979: ||' AND wvr.spec_id = gs.spec_id and 1=:dummy4';

Line 1005: supl_vr_table_list := ' gmd_supplier_spec_vrs svr, fnd_user fu10, fnd_user fu11, po_vendors v';

1001: ||', svr.created_by, fu10.user_name, svr.last_update_date, svr.last_updated_by'
1002: ||', fu11.user_name, svr.last_update_login'
1003: ||')';
1004:
1005: supl_vr_table_list := ' gmd_supplier_spec_vrs svr, fnd_user fu10, fnd_user fu11, po_vendors v';
1006:
1007: supl_vr_where_clause := ' svr.created_by = fu10.user_id AND svr.last_updated_by = fu11.user_id'
1008: ||' AND svr.spec_id = gs.spec_id AND v.vendor_id = svr.supplier_id AND 1=:dummy5';
1009: supl_vr_using_clause := '1';

Line 1034: inv_vr_table_list := ' gmd_inventory_spec_vrs ivr, fnd_user fu12, fnd_user fu13';

1030: ||', ivr.attribute28, ivr.attribute29, ivr.attribute30, ivr.creation_date'
1031: ||', ivr.created_by, fu12.user_name, ivr.last_update_date, ivr.last_updated_by'
1032: ||', fu13.user_name, ivr.last_update_login'
1033: ||')';
1034: inv_vr_table_list := ' gmd_inventory_spec_vrs ivr, fnd_user fu12, fnd_user fu13';
1035:
1036: inv_vr_where_clause := ' ivr.created_by = fu12.user_id AND ivr.last_updated_by = fu13.user_id'
1037: ||' AND ivr.spec_id = gs.spec_id AND 1=:dummy6';
1038: inv_vr_using_clause := '1';

Line 1057: mon_vr_table_list := ' gmd_monitoring_spec_vrs mvr, fnd_user fu14, fnd_user fu15';

1053: ||', mvr.attribute24, mvr.attribute25, mvr.attribute26, mvr.attribute27, mvr.attribute28'
1054: ||', mvr.attribute29, mvr.attribute30, mvr.creation_date, mvr.created_by'
1055: ||', mvr.last_updated_by, mvr.last_update_date, mvr.last_update_login'
1056: ||')';
1057: mon_vr_table_list := ' gmd_monitoring_spec_vrs mvr, fnd_user fu14, fnd_user fu15';
1058:
1059: mon_vr_where_clause := ' mvr.created_by = fu14.user_id AND mvr.last_updated_by = fu15.user_id'
1060: ||' AND mvr.spec_id = gs.spec_id AND 1=:dummy7';
1061: mon_vr_using_clause := '1';

Line 2841: ||'fnd_user fu1, fnd_user fu2 ';

2837:
2838:
2839: table_list := 'FROM gmd_results r, gmd_samples gs, gmd_qc_tests_b gt,'
2840: ||'gmd_spec_results gsr, gmd_event_spec_disp gesd,'
2841: ||'fnd_user fu1, fnd_user fu2 ';
2842:
2843:
2844: -- We now have the first three strings built. Here comes the good bit: building the where and us
2845: -- clauses and inserting the bind variables and values.

Line 2933: -- BUG 3078568 target fnd_user for tester

2929: where_clause := where_clause||'AND gsr.evaluation_ind = :evaluation_ind ';
2930: using_clause := using_clause||', gmd_outbound_apis_pub.g_evaluation_ind ';
2931: END IF;
2932:
2933: -- BUG 3078568 target fnd_user for tester
2934: IF p_tester IS NOT NULL
2935: THEN
2936: table_list := table_list ||', fnd_user fu3 ';
2937: where_clause := where_clause ||'AND r.tester_id = fu3.user_id ';

Line 2936: table_list := table_list ||', fnd_user fu3 ';

2932:
2933: -- BUG 3078568 target fnd_user for tester
2934: IF p_tester IS NOT NULL
2935: THEN
2936: table_list := table_list ||', fnd_user fu3 ';
2937: where_clause := where_clause ||'AND r.tester_id = fu3.user_id ';
2938:
2939: gmd_outbound_apis_pub.g_tester := p_tester;
2940: where_clause := where_clause||'AND fu3.user_name = :tester ';

Line 3082: gme_debug.put_line('select from fnd_user using user_id of '

3078:
3079: -- BUG 3078568 - populate tester from tester_id
3080: IF g_results_table(i).tester_id IS NOT NULL
3081: THEN
3082: gme_debug.put_line('select from fnd_user using user_id of '
3083: || g_results_table(i).tester_id);
3084: SELECT user_name
3085: INTO g_results_table(i).tester
3086: FROM fnd_user

Line 3086: FROM fnd_user

3082: gme_debug.put_line('select from fnd_user using user_id of '
3083: || g_results_table(i).tester_id);
3084: SELECT user_name
3085: INTO g_results_table(i).tester
3086: FROM fnd_user
3087: WHERE user_id = g_results_table(i).tester_id;
3088: END IF;
3089:
3090: END LOOP;

Line 3194: ||'fnd_user fu1, fnd_user fu2 ';

3190: ||'gcr.last_update_login, gcr.PARENT_COMPOSITE_RESULT_ID) '; -- 5346713
3191:
3192: table_list := 'FROM gmd_composite_results gcr, gmd_sampling_events gse, gmd_event_spec_disp gesd, '
3193: ||'gmd_composite_spec_disp gcsd, mtl_system_items_kfv msi, '
3194: ||'fnd_user fu1, fnd_user fu2 ';
3195:
3196:
3197: where_clause := 'WHERE gse.sampling_event_id = gesd.sampling_event_id '
3198: ||'AND gesd.event_spec_disp_id = gcsd.event_spec_disp_id '

Line 3227: ||'fnd_user fu1, fnd_user fu2 ';

3223: ||'gcr.last_update_login, gcr.PARENT_COMPOSITE_RESULT_ID) '; -- 5346713
3224:
3225: table_list := 'FROM gmd_composite_results gcr, gmd_sampling_events gse, gmd_event_spec_disp gesd, '
3226: ||'gmd_composite_spec_disp gcsd, mtl_system_items_kfv msi, '
3227: ||'fnd_user fu1, fnd_user fu2 ';
3228:
3229:
3230: where_clause := 'WHERE gse.sampling_event_id = gesd.sampling_event_id '
3231: ||'AND gesd.event_spec_disp_id = gcsd.event_spec_disp_id '

Line 3260: ||'fnd_user fu1, fnd_user fu2 ';

3256: ||'gcr.last_update_login, gcr.PARENT_COMPOSITE_RESULT_ID) '; -- 5347613
3257:
3258: table_list := 'FROM gmd_composite_results gcr, gmd_sampling_events gse, gmd_event_spec_disp gesd,'
3259: ||'gmd_composite_spec_disp gcsd, mtl_system_items_kfv msi, '
3260: ||'fnd_user fu1, fnd_user fu2 ';
3261:
3262:
3263: where_clause := 'WHERE gse.sampling_event_id = gesd.sampling_event_id '
3264: ||'AND gesd.event_spec_disp_id = gcsd.event_spec_disp_id '

Line 3294: ||'fnd_user fu1, fnd_user fu2 ';

3290:
3291:
3292: table_list := 'FROM gmd_composite_results gcr, gmd_sampling_events gse, gmd_event_spec_disp gesd, '
3293: ||'gmd_composite_spec_disp gcsd, '
3294: ||'fnd_user fu1, fnd_user fu2 ';
3295:
3296:
3297: where_clause := 'WHERE gse.sampling_event_id = gesd.sampling_event_id '
3298: ||'AND gesd.event_spec_disp_id = gcsd.event_spec_disp_id '

Line 3652: ||'fnd_user fu1, fnd_user fu2 ';

3648: ||'gs.last_update_date, gs.last_updated_by, fu2.user_name, '
3649: ||'gs.last_update_login, gs.retain_as, gs.remaining_qty, gs.lpn_id, null) '; -- 7027149
3650:
3651: table_list := 'FROM gmd_samples gs, gmd_event_spec_disp gesd,gmd_sample_spec_disp gssd, '
3652: ||'fnd_user fu1, fnd_user fu2 ';
3653:
3654:
3655: -- BUG 3077905 Retrieve sample_disposition from gmd_sample_spec_disp not gmd_samples
3656: where_clause := 'WHERE gs.sampling_event_id = gesd.sampling_event_id and '

Line 3909: table_list := table_list ||', fnd_user fu3 ';

3905: END IF;
3906:
3907: IF p_sampler IS NOT NULL
3908: THEN
3909: table_list := table_list ||', fnd_user fu3 ';
3910: where_clause := where_clause ||'AND gs.sampler_id = fu3.user_id ';
3911:
3912: gmd_outbound_apis_pub.g_sampler := p_sampler;
3913: where_clause := where_clause||'AND fu3.user_name = :sampler ';

Line 4596: --dbms_output.put_line('select from fnd_user using user_id of '|| g_samples_table(i).sampler_id);

4592: END IF;
4593:
4594: IF g_samples_table(i).sampler_id is not NULL
4595: THEN
4596: --dbms_output.put_line('select from fnd_user using user_id of '|| g_samples_table(i).sampler_id);
4597: select user_name into g_samples_table(i).sampler
4598: from fnd_user
4599: where user_id = g_samples_table(i).sampler_id;
4600: END IF;

Line 4598: from fnd_user

4594: IF g_samples_table(i).sampler_id is not NULL
4595: THEN
4596: --dbms_output.put_line('select from fnd_user using user_id of '|| g_samples_table(i).sampler_id);
4597: select user_name into g_samples_table(i).sampler
4598: from fnd_user
4599: where user_id = g_samples_table(i).sampler_id;
4600: END IF;
4601:
4602: IF g_samples_table(i).po_header_id is not NULL

Line 4881: ||',gme_batch_header bh, fnd_user fu1, fnd_user fu2, gmd_recipes_b r'

4877: ||', se.organization_id, se.resources, se.instance_id, se.time_point_id '
4878: ||', se.variant_id, se.archived_taken, se.reserved_taken ';
4879:
4880: main_table_list :=' gmd_sampling_events se, rcv_shipment_headers rh, po_headers_all ph'
4881: ||',gme_batch_header bh, fnd_user fu1, fnd_user fu2, gmd_recipes_b r'
4882: ||',fm_form_mst_b fh, oe_order_headers_all oh, mtl_system_items_b im'
4883: ||',po_lines_all pl, oe_order_lines_all ol, fm_matl_dtl fd'
4884: ||',mtl_parameters mp';
4885:

Line 4907: disp_table_list :=' gmd_event_spec_disp sd, gmd_specifications_b gs, fnd_user fu3, fnd_user fu4';

4903: ||',sd.SPEC_VR_ID, sd.DISPOSITION, sd.SPEC_USED_FOR_LOT_ATTRIB_IND'
4904: ||',sd.DELETE_MARK, sd.CREATION_DATE, sd.CREATED_BY, fu3.USER_NAME'
4905: ||',sd.LAST_UPDATE_DATE, sd.LAST_UPDATED_BY, fu4.USER_NAME, sd.LAST_UPDATE_LOGIN';
4906:
4907: disp_table_list :=' gmd_event_spec_disp sd, gmd_specifications_b gs, fnd_user fu3, fnd_user fu4';
4908:
4909: disp_where_clause:=' sd.spec_id = gs.spec_id(+) AND sd.created_by = fu3.user_id'
4910: ||' AND sd.last_updated_by = fu4.user_id'
4911: ||' AND sd.sampling_event_id = se.sampling_event_id'