Join the OracleApps88 Telegram group @OracleApps88to get more information on Oracle EBS R12/Oracle Fusion applications.

If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.

Monday, May 8, 2017

Query To Get Project Chargeable Tasks

SELECT
B.segment1 PROJECT_NUMBER,
B.NAME,
B.project_status_code project_status,
task_number,
task_name,
service_type_code

FROM
PA_TASKS A,
PA_PROJECTS_ALL B

WHERE a.project_id = b.project_id
AND b.project_type IN ('Your Project Types')
--AND task_number LIKE 'Task Number%'
AND chargeable_flag = 'Y'

ORDER BY B.project_status_code, B.segment1, B.NAME, task_number

No comments:

Post a Comment

If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.
Best Blogger TipsGet Flower Effect