April 22, 2010

Fnd client package

Use fnd client before u select rows from views.

Fnd_client_info.set_org_context('500');

This will enable data from the org you want to retrive.
at
Labels:

No comments:

Post a Comment

Thanks for your comments submitted.,will review and Post soon! by admin.

Subscribe to: Post Comments (Atom)

COALESCE-SQL

Coalesce- return the null values from the expression. It works similar to a case statement where if expression 1 is false then goes to expr...

  • FND_CANONICAL
    In HRMS we do use date with timestamp for EIT ans SIT segments. To change the format od the date we can use fnd_date . canonical_to_date ...
  • Number into word
    This is easily done with the following command: select to_char(to_date('56789','J'),'JSP') from dual / TO_CHAR...
  • FORMS 3
     Creating LOVs 1. Start a new module by clicking on File - New - Form. 2. Change Module’s name to TEST_LOV. 3. Set up DEPT and EMP...