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.INV_MWB_TREE1 dependencies on MTL_PARAMETERS

Line 1283: org_code mtl_parameters.organization_code%TYPE;

1279: query_str VARCHAR2(10000);
1280: query_hdl NUMBER;
1281: rows_processed NUMBER;
1282: org_id mtl_onhand_quantities.organization_id%TYPE;
1283: org_code mtl_parameters.organization_code%TYPE;
1284: i NUMBER := x_tbl_index;
1285: j NUMBER := x_node_value;
1286: table_required VARCHAR2(300);
1287: is_grade_t BOOLEAN DEFAULT FALSE ; -- NSRIVAST, INVCONV

Line 1345: inb_from_clause := inb_from_clause || ' mtl_supply ms , mtl_parameters mp ';

1341:
1342: /* Bug 8225619. Uncommented the below if condition */
1343: IF inv_mwb_globals.g_chk_inbound = 1 THEN
1344: -- AND l_inbound_qty IS NOT NULL THEN
1345: inb_from_clause := inb_from_clause || ' mtl_supply ms , mtl_parameters mp ';
1346: inb_where_clause := inb_where_clause ||' AND ms.to_organization_id = mp.organization_id ';
1347: inb_where_clause := inb_where_clause ||' AND ms.destination_type_code = ''INVENTORY'' ';
1348:
1349: IF inv_mwb_globals.g_po_header_id IS NOT NULL

Line 2187: query_str := query_str || 'from mtl_parameters mp where organization_id in ';

2183: THEN
2184: --End of ER Changes
2185:
2186: query_str := 'SELECT mp.organization_id, mp.organization_code ';
2187: query_str := query_str || 'from mtl_parameters mp where organization_id in ';
2188: query_str := query_str || '(select organization_id ';
2189: query_str := query_str || 'FROM wms_license_plate_numbers WHERE 1=1 ';
2190:
2191: IF inv_mwb_globals.g_tree_mat_loc_id = 2

Line 2241: query_str := ' SELECT mp.organization_id, mp.organization_code FROM mtl_parameters mp ';

2237: END IF;
2238:
2239: query_str := query_str || ') ORDER BY organization_code ';
2240: ELSE
2241: query_str := ' SELECT mp.organization_id, mp.organization_code FROM mtl_parameters mp ';
2242: query_str := query_str || ' WHERE exists ( ';
2243:
2244: -- Need to use MTL_ONHAND_TOTAL_V
2245: IF (

Line 4005: FROM mtl_parameters mp

4001:
4002: IF inv_mwb_globals.g_organization_id IS NOT NULL THEN
4003: SELECT mp.organization_id, mp.organization_code
4004: INTO org_id,org_code
4005: FROM mtl_parameters mp
4006: WHERE EXISTS (SELECT organization_id
4007: FROM mtl_onhand_total_mwb_v
4008: WHERE 1 = 1 AND organization_id = mp.organization_id)
4009: AND mp.organization_id = inv_mwb_globals.g_organization_id

Line 4094: query_str := query_str || 'from mtl_parameters mp where organization_id in ';

4090: AND inv_mwb_globals.g_qty_from IS NULL
4091: AND inv_mwb_globals.g_qty_to IS NULL THEN
4092: --End of ER Changes
4093: query_str := 'SELECT mp.organization_id, mp.organization_code ';
4094: query_str := query_str || 'from mtl_parameters mp where organization_id in ';
4095: query_str := query_str || '(select organization_id ';
4096: query_str := query_str || 'FROM wms_license_plate_numbers WHERE 1=1 ';
4097:
4098: IF inv_mwb_globals.g_tree_mat_loc_id = 2

Line 4148: query_str := ' SELECT mp.organization_id, mp.organization_code FROM mtl_parameters mp ';

4144: END IF;
4145:
4146: query_str := query_str || ') ORDER BY organization_code ';
4147: ELSE
4148: query_str := ' SELECT mp.organization_id, mp.organization_code FROM mtl_parameters mp ';
4149: query_str := query_str || ' WHERE exists ( ';
4150:
4151: -- Need to use MTL_ONHAND_TOTAL_V
4152: IF (

Line 5903: FROM mtl_parameters mp

5899:
5900: IF inv_mwb_globals.g_organization_id IS NOT NULL THEN
5901: SELECT mp.organization_id, mp.organization_code
5902: INTO org_id,org_code
5903: FROM mtl_parameters mp
5904: WHERE EXISTS (SELECT organization_id
5905: FROM mtl_onhand_total_mwb_v
5906: WHERE 1 = 1 AND organization_id = mp.organization_id)
5907: AND mp.organization_id = inv_mwb_globals.g_organization_id

Line 8955: stock_loc_code mtl_parameters.stock_locator_control_code%TYPE;

8951: query_hdl NUMBER;
8952: rows_processed NUMBER;
8953: loc_id mtl_item_locations_kfv.inventory_location_id%TYPE;
8954: loc_code mtl_item_locations_kfv.concatenated_segments%TYPE;
8955: stock_loc_code mtl_parameters.stock_locator_control_code%TYPE;
8956: loc_type NUMBER;
8957: i NUMBER := x_tbl_index;
8958: j NUMBER := x_node_value;
8959: table_required VARCHAR2(300);

Line 8994: FROM mtl_parameters

8990: IF inv_mwb_globals.g_organization_id IS NOT NULL
8991: OR inv_mwb_globals.g_tree_organization_id IS NOT NULL THEN
8992: SELECT stock_locator_control_code
8993: INTO stock_loc_code
8994: FROM mtl_parameters
8995: WHERE organization_id = NVL(inv_mwb_globals.g_tree_organization_id ,
8996: inv_mwb_globals.g_organization_id);
8997:
8998: IF stock_loc_code = 1 THEN

Line 21514: org_code mtl_parameters.organization_code%TYPE;

21510: query_str VARCHAR2(10000);
21511: query_hdl NUMBER;
21512: rows_processed NUMBER;
21513: org_id mtl_onhand_quantities.organization_id%TYPE;
21514: org_code mtl_parameters.organization_code%TYPE;
21515: i NUMBER := x_tbl_index;
21516: j NUMBER := x_node_value;
21517: grade_control mtl_system_items.GRADE_CONTROL_FLAG%TYPE ;
21518: table_required VARCHAR2(300);