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;

List the various types of value set.

0 Answers  

---

how to get the on hand quantity of an item across all organizations? name the underlying tables.

2 Answers   Ranves IT Solutions, Scan Steel,

---

what are the error tables in AP?

6 Answers  

---

What is Formula Column?

4 Answers  

---

what are version control tools used in oracle apps?

1 Answers   Cap Gemini, Sony,

---

how can we return morethan one parameters in procedure?

2 Answers  

---

What is the Lookup's and what is the use of lookup's?

3 Answers   TCS,

---

Matrix Report: Simple, Group above, Nested

1 Answers  

---

Tell me where we find the status of order information?

0 Answers  

---

differentiate between intra & inter UOM class conversion with examples.

1 Answers   Scan Steel,

---

What is GLOBAL TEMPORARY TABLE and It's significance ?

3 Answers   KPIT,

---

Difference between set of books id and ledger id in r12 ?

1 Answers   TCS,

---