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.

explain p2p cycle? what are the tables used for this?

3 Answers   Accenture,

---

Write an SQL Query to Delete Duplicate records from a table using ROWID.

24 Answers   pspl, Satyam, Thinkways,

---

Can We Create a Synonym On Trigger?

7 Answers   Exeter, Oracle,

---

How to know the number of invoices generated for one PO from front end (navigation)?

1 Answers   Oracle,

---

What is implicity cursor . When it fires . For which statement it will fire(Insert/update/delte). What is the attribute of implicity and explicity cursor oracle 9i. What is the Rec cursor.

2 Answers   IBM,

---

---

In report we have to show two Layout? how it is and how we can see from where it?

3 Answers   IBM,

---

what is the defference between credit memo and debit memo

3 Answers   Wipro,

---

can we write multiple procedures in package with same name like A p1,p2(parameters) B p1,p2(same parameters)

4 Answers  

---

Oder of firing triggers in form

7 Answers   Oracle, Zensar,

---

what are the different types of parameters avialable in reports?

2 Answers   Oracle,

---

Hi All, I have one year experience in Oracle Apps.I want to know that what is value of oracle Apps in market?..I have doubt,here I need to learn Oracle Apps more..because I know the opportunities in market ... otherwise need to learn other technologies ?..... And In Oracle Apps ,which is impotant Functional or technical knowledge ?

2 Answers   Wipro,

---

what is the difference between credit memo and debit memo?...

2 Answers   Sony,

---