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;

What do you understand by concurrent programs?

1074

---

List of all the modules under Manufacturing, Finance and Distribution in oracle applications?

2198

---

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

1964

---

What is instead of trigger in where we will use?

1155

---

what are the balancing segments in AR?

2082

---

What is oracle soa suite and what are its different components?

1201

---

Explain oracle apps architecture.

1222

---

can we get profile values in report without using user exists is it possible how?

2867

---

If we have a repeated record in a table. But the repeated record how i can transfer from table to nested table?

2092

---

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

2643

---

what is pay run id ?

2182

---

q)what are the validations in sql*loader

2386

---

What are the different components you should consider while defining a responsibility in oracle apps?

1057

---

What are do's and dont's of Interface?

2405

---

Explain what are the tables of auto invoice?

1132

---