APPS.INV_MWB_TREE dependencies on MTL_PARAMETERS

Line 75: org_code mtl_parameters.organization_code%TYPE;

71: query_str VARCHAR2(10000);
72: query_hdl NUMBER;
73: rows_processed NUMBER;
74: org_id mtl_onhand_quantities.organization_id%TYPE;
75: org_code mtl_parameters.organization_code%TYPE;
76: i NUMBER := x_tbl_index;
77: j NUMBER := x_node_value;
78: table_required VARCHAR2(300);
79: is_grade_t BOOLEAN DEFAULT FALSE ; -- NSRIVAST, INVCONV

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

118: AND p_qty_from IS NULL
119: AND p_qty_to IS NULL THEN
120: --End of ER Changes
121: query_str := 'SELECT mp.organization_id, mp.organization_code ';
122: query_str := query_str || 'from mtl_parameters mp where organization_id in ';
123: query_str := query_str || '(select organization_id ';
124: query_str := query_str || 'FROM wms_license_plate_numbers WHERE 1=1 ';
125:
126: IF p_sub_type = 2 THEN

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

171: END IF;
172:
173: query_str := query_str || ') ORDER BY organization_code ';
174: ELSE
175: query_str := ' SELECT mp.organization_id, mp.organization_code FROM mtl_parameters mp ';
176: query_str := query_str || ' WHERE exists ( ';
177:
178: -- Need to use MTL_ONHAND_TOTAL_V
179: IF (

Line 3695: stock_loc_code mtl_parameters.stock_locator_control_code%TYPE;

3691: query_hdl NUMBER;
3692: rows_processed NUMBER;
3693: loc_id mtl_item_locations_kfv.inventory_location_id%TYPE;
3694: loc_code mtl_item_locations_kfv.concatenated_segments%TYPE;
3695: stock_loc_code mtl_parameters.stock_locator_control_code%TYPE;
3696: loc_type NUMBER;
3697: i NUMBER := x_tbl_index;
3698: j NUMBER := x_node_value;
3699: table_required VARCHAR2(300);

Line 3713: FROM mtl_parameters

3709: /* 1625119 Should check at the Org parameters first for Locator control */
3710: IF (p_organization_id IS NOT NULL) THEN
3711: SELECT stock_locator_control_code
3712: INTO stock_loc_code
3713: FROM mtl_parameters
3714: WHERE organization_id = p_organization_id;
3715:
3716: IF stock_loc_code = 1 THEN
3717: RETURN;

Line 11164: org_code mtl_parameters.organization_code%TYPE;

11160: query_str VARCHAR2(10000);
11161: query_hdl NUMBER;
11162: rows_processed NUMBER;
11163: org_id mtl_onhand_quantities.organization_id%TYPE;
11164: org_code mtl_parameters.organization_code%TYPE;
11165: i NUMBER := x_tbl_index;
11166: j NUMBER := x_node_value;
11167: grade_control mtl_system_items.GRADE_CONTROL_FLAG%TYPE ;
11168: table_required VARCHAR2(300);