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 MTL_PARAMETERS

Line 280: FROM mtl_parameters

276: IF g_test_methods_table(i).test_kit_organization_id IS NOT NULL THEN --INVCONV
277: gme_debug.put_line('Retrieving test kit organization for test kit organization id:'
278: ||to_char(g_test_methods_table(i).test_kit_organization_id));
279: SELECT organization_code INTO g_test_methods_table(i).test_kit_organization_code
280: FROM mtl_parameters
281: WHERE organization_id = g_test_methods_table(i).test_kit_organization_id;
282: END IF;
283:
284: IF g_test_methods_table(i).test_kit_inv_item_id IS NOT NULL THEN --INVCONV

Line 1471: ||' mtl_parameters WHERE organization_code = :wip_vr_batch_orgn_code) )';

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:
1474: wip_vr_where_clause := wip_vr_where_clause||' AND wvr.batch_id IN'
1475: ||' (SELECT batch_id FROM gme_batch_header '

Line 1477: ||' mtl_parameters WHERE organization_code = :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;
1480:
1481: IF p_wip_vr_batch_no IS NOT NULL

Line 4836: ||',mtl_parameters mp';

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:
4838: main_where_clause:=' 1=:dummy AND se.receipt_id = rh.shipment_header_id(+)'
4839: ||' AND se.po_header_id = ph.po_header_id(+)'
4840: ||' AND se.inventory_item_id = im.inventory_item_id(+)'