Human Capital Management - EBS (MOSC)

MOSC Banner

getting correct task list for a project.

edited Nov 22, 2012 2:35AM in Human Capital Management - EBS (MOSC) 4 commentsAnswered
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
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center