0 Replies Latest reply: Nov 15, 2012 6:21 AM by user488418 RSS

    getting correct task list for a project.

    user488418
      Hi,

      When I am executing following query
      SELECT PT.PROJECT_ID, PT.TASK_ID, PT.TASK_NUMBER, PT.TASK_NAME, PT.BILLABLE_FLAG FROM Apps.PA_TASKS pt WHERE PROJECT_ID = 443;

      it is giving following result

      443     28989     1     Bench     N
      443     28990     1.1     Bench Time     N
      443     28991     1.2     Billing, PRF awaited     N
      443     28992     2     Leave     N
      443     28993     2.1     Vacation     N
      443     28994     2.2     Statutory Holiday     N
      443     28995     2.3     Other Leave     N
      443     28996     2.4     Leave Without Pay     N
      443     28997     2.5     Sick Leave/ Time Off     N
      443     28998     3     Non-Billable Exps     N
      443     270397     4     Delinquent-Don't Use     N

      but when access oracle e-business suite from web browser it is showing all entry apart from 443     28992     2     Leave     N.

      Please suggest me which query or function to show all enrty aprart from 443     28992     2     Leave     N

      Thanks in advance