Answer Posted / kumar

In apps you will find n number of views

During the creation of view based on the Base table in the
where clause ,below condition will be mentioned.
So that it will take the value of profile MO:Operating Unit
and display the values of corresponding Org_id.

WHERE NVL (org_id,
NVL (TO_NUMBER (DECODE (SUBSTRB (USERENV
('CLIENT_INFO'),
1,
1
),
' ', NULL,
SUBSTRB (USERENV
('CLIENT_INFO'),
1,
10
)
)),
-99)) =
NVL (TO_NUMBER (DECODE (SUBSTRB (USERENV
('CLIENT_INFO'),
1,
1
),
' ', NULL,
SUBSTRB (USERENV
('CLIENT_INFO'),
1,
10
)
)),
-99);


if you simply select from the view without setting the apps
environment , no output will be displayed.

To set the apps environment,
The following block of code has to be executed.

BEGIN
DBMS_APPLICTION_INFO.SET_CLIENT_INFO('ORG_ID');
END;

OR

BEGIN
FND_CLIENT_INFO.SET_ORG_CONTEXT('ORG_ID');
END;

THE VALUES OF ORG_ID DEPENDS ON YOUR REQUIREMENTS.

what is global tempory table?

7121

---

Can u give the Documentation of Custom.pll in oracle apps

3419

---

What are file in oracle.

2179

---

In which tables receopt application form Appliy to field Value will come. I know one table i.e, ra_customer_trx.trx_number. Could U please any one tell me other than this except(ra_customer_trx and ar_payment_schedules_all tables). plz mentioned tables_name.Column_name.

2970

---

Which oracle applications pl/sql standard apis you are familiar, have you used most of them?

1061

---

Hi  Friends this is preetham, i am  searching for job on oracle apps(technical) i put 3 years fake exp, so any one  please could you help me for realtime interview  questions and 9739782164 this is my no srpsrp777@gmail.Com please guys please provide your no for contact i have a doubts i want to clarify

2005

---

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

1032

---

What does appl_top directory contain?

1075

---

What is count(*) from po_vendors(any table)?

1034

---

In support project one ticket alloted which steps follows manualy tell me ?

2610

---

Can you differentiate between mediator and osb?

1088

---

WHAT IS CUSTOM VIEW AND CUSTOM COMPONENT?

3004

---

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

1925

---

what are the different transaction clauses in AR?

2052

---

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

2070

---