Answer / eldho

Hope this pice of code explains:

declare
v_query VARCHAR2 (200);
v_employee_name VARCHAR2 (50);
BEGIN
v_query := 'SELECT emp_name from employees where emp_id =
102';
EXECUTE IMMEDIATE v_query
INTO v_employee_name;
DBMS_OUTPUT.put_line ('Emp Name is ' || v_employee_name);
END;

Answer / m.n

declare
v_query VARCHAR2 (200);
v_inv_item_id VARCHAR2 (50);
BEGIN
v_query := 'SELECT inventory_item_id from
mtl_onhand_quantities_detail where inventory_item_id =107';
EXECUTE IMMEDIATE v_query
INTO v_inv_item_id;
DBMS_OUTPUT.put_line ('inventory_item_id ' ||
v_inv_item_id);
exception
when others then
DBMS_OUTPUT.put_line ('inventory_item_id ' ||
v_inv_item_id);
END;

WHAT IS CUSTOM VIEW AND CUSTOM COMPONENT?

0 Answers   Tech Mahindra,

---

What is profile and what is level of profile option and it's hierarchy

1 Answers   IBM,

---

Define MultiOrg Structure

5 Answers   Convergys,

---

What is MO operating units. Why it need to to set this and where .

2 Answers   IBM,

---

Define multi org structure with example(take any businees).

1 Answers   Oracle, Wipro,

---

in oracle workflow if i want to send a mail to the user after sending if the user didn't approve the mail after 10 mins it is automatimatically approved how we can approach?

2 Answers   Cap Gemini,

---

In interface how u find errors and how to solve. How to fix it?

3 Answers  

---

mention the interface tables for item open interface and open transaction interface and also their respective production tables.

1 Answers   Scan Steel,

---

How will you get the concurrent program output as email?

3 Answers   IBM, KPIT,

---

is UOM maintained at master level or organization level or both?

3 Answers   Scan Steel,

---

Can u define operating units inplace of inventory?

2 Answers  

---

where is chandra institute in hyderabad for oracle apps technical training ?

2 Answers  

---