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 1004: org_code mtl_parameters.organization_code%TYPE;

1000: query_str VARCHAR2(10000);
1001: query_hdl NUMBER;
1002: rows_processed NUMBER;
1003: org_id mtl_onhand_quantities.organization_id%TYPE;
1004: org_code mtl_parameters.organization_code%TYPE;
1005: i NUMBER := x_tbl_index;
1006: j NUMBER := x_node_value;
1007: table_required VARCHAR2(300);
1008: is_grade_t BOOLEAN DEFAULT FALSE ; -- NSRIVAST, INVCONV

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

1061: END;
1062:
1063: -- IF inv_mwb_globals.g_chk_inbound = 1 THEN
1064: -- AND l_inbound_qty IS NOT NULL THEN
1065: inb_from_clause := inb_from_clause || ' mtl_supply ms , mtl_parameters mp ';
1066: inb_where_clause := inb_where_clause ||' AND ms.to_organization_id = mp.organization_id ';
1067: inb_where_clause := inb_where_clause ||' AND ms.destination_type_code = ''INVENTORY'' ';
1068:
1069: IF inv_mwb_globals.g_po_header_id IS NOT NULL

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

1699: THEN
1700: --End of ER Changes
1701:
1702: query_str := 'SELECT mp.organization_id, mp.organization_code ';
1703: query_str := query_str || 'from mtl_parameters mp where organization_id in ';
1704: query_str := query_str || '(select organization_id ';
1705: query_str := query_str || 'FROM wms_license_plate_numbers WHERE 1=1 ';
1706:
1707: IF inv_mwb_globals.g_tree_mat_loc_id = 2

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

1753: END IF;
1754:
1755: query_str := query_str || ') ORDER BY organization_code ';
1756: ELSE
1757: query_str := ' SELECT mp.organization_id, mp.organization_code FROM mtl_parameters mp ';
1758: query_str := query_str || ' WHERE exists ( ';
1759:
1760: -- Need to use MTL_ONHAND_TOTAL_V
1761: IF (

Line 3275: FROM mtl_parameters mp

3271:
3272: IF inv_mwb_globals.g_organization_id IS NOT NULL THEN
3273: SELECT mp.organization_id, mp.organization_code
3274: INTO org_id,org_code
3275: FROM mtl_parameters mp
3276: WHERE EXISTS (SELECT organization_id
3277: FROM mtl_onhand_total_mwb_v
3278: WHERE 1 = 1 AND organization_id = mp.organization_id)
3279: AND mp.organization_id = inv_mwb_globals.g_organization_id

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

3355: AND inv_mwb_globals.g_qty_from IS NULL
3356: AND inv_mwb_globals.g_qty_to IS NULL THEN
3357: --End of ER Changes
3358: query_str := 'SELECT mp.organization_id, mp.organization_code ';
3359: query_str := query_str || 'from mtl_parameters mp where organization_id in ';
3360: query_str := query_str || '(select organization_id ';
3361: query_str := query_str || 'FROM wms_license_plate_numbers WHERE 1=1 ';
3362:
3363: IF inv_mwb_globals.g_tree_mat_loc_id = 2

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

3409: END IF;
3410:
3411: query_str := query_str || ') ORDER BY organization_code ';
3412: ELSE
3413: query_str := ' SELECT mp.organization_id, mp.organization_code FROM mtl_parameters mp ';
3414: query_str := query_str || ' WHERE exists ( ';
3415:
3416: -- Need to use MTL_ONHAND_TOTAL_V
3417: IF (

Line 4925: FROM mtl_parameters mp

4921:
4922: IF inv_mwb_globals.g_organization_id IS NOT NULL THEN
4923: SELECT mp.organization_id, mp.organization_code
4924: INTO org_id,org_code
4925: FROM mtl_parameters mp
4926: WHERE EXISTS (SELECT organization_id
4927: FROM mtl_onhand_total_mwb_v
4928: WHERE 1 = 1 AND organization_id = mp.organization_id)
4929: AND mp.organization_id = inv_mwb_globals.g_organization_id

Line 7520: stock_loc_code mtl_parameters.stock_locator_control_code%TYPE;

7516: query_hdl NUMBER;
7517: rows_processed NUMBER;
7518: loc_id mtl_item_locations_kfv.inventory_location_id%TYPE;
7519: loc_code mtl_item_locations_kfv.concatenated_segments%TYPE;
7520: stock_loc_code mtl_parameters.stock_locator_control_code%TYPE;
7521: loc_type NUMBER;
7522: i NUMBER := x_tbl_index;
7523: j NUMBER := x_node_value;
7524: table_required VARCHAR2(300);

Line 7559: FROM mtl_parameters

7555: IF inv_mwb_globals.g_organization_id IS NOT NULL
7556: OR inv_mwb_globals.g_tree_organization_id IS NOT NULL THEN
7557: SELECT stock_locator_control_code
7558: INTO stock_loc_code
7559: FROM mtl_parameters
7560: WHERE organization_id = NVL(inv_mwb_globals.g_tree_organization_id ,
7561: inv_mwb_globals.g_organization_id);
7562:
7563: IF stock_loc_code = 1 THEN

Line 18023: org_code mtl_parameters.organization_code%TYPE;

18019: query_str VARCHAR2(10000);
18020: query_hdl NUMBER;
18021: rows_processed NUMBER;
18022: org_id mtl_onhand_quantities.organization_id%TYPE;
18023: org_code mtl_parameters.organization_code%TYPE;
18024: i NUMBER := x_tbl_index;
18025: j NUMBER := x_node_value;
18026: grade_control mtl_system_items.GRADE_CONTROL_FLAG%TYPE ;
18027: table_required VARCHAR2(300);