I Want To Retrieve Data From View

[miro_feps]

[يسار][/يسار]Dear All
I WANT TO KNOW HOW TO RETRIEVE DATA FROM THE VIEW ON SQLPLUS OR ANY TOOL
AS LONG AS I KNOW THAT I MUST RUN THIS API ""exec mo_global.SET_POLICY_CONTEXT('S',204); "" & IT WORKS WITH ANY OTHER VIEW BUT IT DOESNOT WORK WITH THE HRMS VIEWS LIKE ""PER_PEOPLE_V"" BUT IT RETRIEVES DATA FOR OTHER VIEWS


NEED FAST REPLY

THANKS ALOT

تم تعديل 23 سبتمبر 2008 بواسطة miro_feps

[Qaraqesho]

[يسار][/يسار]Sallam Alikom
Ramadan Kareem 4 all
try this command


BEGIN

FND_GLOBAL.APPS_INITIALIZE(0,0,0);

END;

Sallam