Answer Posted / 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;

Pls tel me the best text book for Oracle Apps 11i Tech? & I want D2K Text book also?

2131

---

do you know is it possible to run the interface without using oracle apps?

1119

---

what is the differences between internal requisition and internal sales order?

2660

---

Is soa a part of oracle fusion middleware?

1090

---

What do you understand by soa and what are the benefits of using this architecture?

1088

---

how can i print random rows in plsql table

2499

---

please any one provide the oracle erp technical interview questions on modules(PO,AP,AR,INV,GL,OM)wise to my mail id..narendra_609@yahoo.co.in

3665

---

what are the balancing segments in AR?

2101

---

what are the prerequisites for costing transactions?

3144

---

What do you understand by concurrent programs?

1101

---

In hierarchical structure of a database? we have write query from where we should start?

2246

---

How can we import the data into a database using sql * loader?

1189

---

tell my any difficult situtation you solved in your experience in your company?

2319

---

Do you know what are user profiles in apps. Any examples you can give?

1097

---

List the various types of value set.

1082

---