This discussion is archived
0 Replies Latest reply: Nov 15, 2012 4:21 AM by user488418 RSS

getting correct task list for a project.

user488418 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points