Answer / 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.

Answer / roshan

view is a virtual object,After creating a table in a schema
and then creating view then grant to apps.we use views as
to display data in reports.

hope the answer.

roshan

Answer / viswa

view is one of the object, it is like as a table ,it will
created based on table,it has no data,using this we can
retrieve particular organization information

syntax
create view<view name> as select *from <table name> where
org_id=userenv('client_info')

Answer / sreekanth reddy.b

View is a database object, views are created for security purpose and reduce complexity. A View is based on more than one table.

In developer Reports::there are 3 parameters.can you pass the paramter1+paratmeter2 value to the third parameter??

1 Answers  

---

what is repeting frame?

3 Answers   TCS,

---

In a Standard form a DFF is disable?How we can Enable it?

5 Answers   Caritor, TCS,

---

what is meant by Table space?

2 Answers  

---

what is the difference between character mode,bitmap mode

2 Answers   IBM, Sierra Atlantica,

---

what is the use of format trigger?a

3 Answers  

---

Are you familiar with internet architecture of oracle apps 11i?

0 Answers  

---

how many layout sections are tehre in layout editor?

1 Answers  

---

in interface and conversion if 10 records are error out we can't load the records?if >10 we have to insert,if we not insert we need to gernerate error how u can achieve?

1 Answers   Oracle,

---

what is mean by confine mode and flexi mode?

2 Answers  

---

Could any one tell me the steps of conversions and what kind of validations and exceptions do we use during this conversion? Please do answer in detail. what program do we write in user exit in reports?

3 Answers   iGate,

---

what are the mandatory parameters in suppler Conversion?

1 Answers   Tech Mahindra,

---