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 GME_BATCH_HEADER

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 1469: ||' (SELECT batch_id FROM gme_batch_header '

1465: IF p_wip_vr_batch_orgn_code IS NOT NULL
1466: THEN
1467: gmd_outbound_apis_pub.g_wip_vr_batch_orgn_code := p_wip_vr_batch_orgn_code;
1468: main_where_clause := main_where_clause||' AND mwvr.batch_id IN'
1469: ||' (SELECT batch_id FROM gme_batch_header '
1470: ||' WHERE organization_id = (SELECT organization_id FROM'
1471: ||' mtl_parameters WHERE organization_code = :wip_vr_batch_orgn_code) )';
1472: main_using_clause := main_using_clause||', gmd_outbound_apis_pub.g_wip_vr_batch_orgn_code';
1473:

Line 1475: ||' (SELECT batch_id FROM gme_batch_header '

1471: ||' mtl_parameters WHERE organization_code = :wip_vr_batch_orgn_code) )';
1472: main_using_clause := main_using_clause||', gmd_outbound_apis_pub.g_wip_vr_batch_orgn_code';
1473:
1474: wip_vr_where_clause := wip_vr_where_clause||' AND wvr.batch_id IN'
1475: ||' (SELECT batch_id FROM gme_batch_header '
1476: ||' WHERE organization_id = (SELECT organization_id FROM'
1477: ||' mtl_parameters WHERE organization_code = :wip_vr_batch_orgn_code) )';
1478: wip_vr_using_clause := wip_vr_using_clause||', gmd_outbound_apis_pub.g_wip_vr_batch_orgn_code';
1479: END IF;

Line 1485: ||' (SELECT batch_id FROM gme_batch_header '

1481: IF p_wip_vr_batch_no IS NOT NULL
1482: THEN
1483: gmd_outbound_apis_pub.g_wip_vr_batch_no := p_wip_vr_batch_no;
1484: main_where_clause := main_where_clause||' AND mwvr.batch_id IN'
1485: ||' (SELECT batch_id FROM gme_batch_header '
1486: ||' WHERE batch_no = :wip_vr_batch_no '
1487: ||' AND batch_type = 0)';
1488: main_using_clause := main_using_clause||', gmd_outbound_apis_pub.g_wip_vr_batch_no';
1489:

Line 1491: ||' (SELECT batch_id FROM gme_batch_header '

1487: ||' AND batch_type = 0)';
1488: main_using_clause := main_using_clause||', gmd_outbound_apis_pub.g_wip_vr_batch_no';
1489:
1490: wip_vr_where_clause := wip_vr_where_clause||' AND wvr.batch_id IN'
1491: ||' (SELECT batch_id FROM gme_batch_header '
1492: ||' WHERE batch_no = :wip_vr_batch_no '
1493: ||' AND batch_type = 0)';
1494: wip_vr_using_clause := wip_vr_using_clause||', gmd_outbound_apis_pub.g_wip_vr_batch_no';
1495: END IF;

Line 3950: table_list := table_list ||', gme_batch_header gbh ';

3946: */
3947:
3948: IF (p_wip_plant_code IS NOT NULL or p_wip_batch_no IS NOT NULL)
3949: THEN
3950: table_list := table_list ||', gme_batch_header gbh ';
3951: where_clause := where_clause ||'AND gs.batch_id = gbh.batch_id ';
3952: IF p_wip_plant_code IS NOT NULL
3953: THEN
3954: gmd_outbound_apis_pub.g_wip_plant_code := p_wip_plant_code;

Line 4470: -- dbms_output.put_line('select from gme_batch_header with batch_id of '|| g_samples_table(i).batch_id);

4466: END IF;
4467:
4468: IF g_samples_table(i).batch_id is not NULL
4469: THEN
4470: -- dbms_output.put_line('select from gme_batch_header with batch_id of '|| g_samples_table(i).batch_id);
4471: select plant_code, batch_no into g_samples_table(i).plant_code,g_samples_table(i).batch_no
4472: from gme_batch_header
4473: where batch_id = g_samples_table(i).batch_id;
4474: END IF;

Line 4472: from gme_batch_header

4468: IF g_samples_table(i).batch_id is not NULL
4469: THEN
4470: -- dbms_output.put_line('select from gme_batch_header with batch_id of '|| g_samples_table(i).batch_id);
4471: select plant_code, batch_no into g_samples_table(i).plant_code,g_samples_table(i).batch_no
4472: from gme_batch_header
4473: where batch_id = g_samples_table(i).batch_id;
4474: END IF;
4475:
4476: IF g_samples_table(i).recipe_id is not NULL

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

4829: ||', se.organization_id, se.resources, se.instance_id, se.time_point_id '
4830: ||', se.variant_id, se.archived_taken, se.reserved_taken ';
4831:
4832: main_table_list :=' gmd_sampling_events se, rcv_shipment_headers rh, po_headers_all ph'
4833: ||',gme_batch_header bh, fnd_user fu1, fnd_user fu2, gmd_recipes_b r'
4834: ||',fm_form_mst_b fh, oe_order_headers_all oh, mtl_system_items_b im'
4835: ||',po_lines_all pl, oe_order_lines_all ol, fm_matl_dtl fd'
4836: ||',mtl_parameters mp';
4837: