getting correct task list for a project.
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
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
Tagged:
0