*********************
Project Details
********************
select
PPAB.segment1,
ptv.TASK_NUMBER,
ptv.DESCRIPTION,
ptv.CHARGEABLE_FLAG,
ptv.BILLABLE_FLAG,
ptv.LIMIT_TO_TXN_CONTROLS_FLAG,
ptv.ALLOW_CROSS_CHARGE_FLAG,
ptv.CC_PROCESS_LABOR_FLAG,
ptv.CC_PROCESS_NL_FLAG,
ptv.CAPITALIZABLE_FLAG
from
PJF_TASKS_V PTV,
PJF_PROJECTS_ALL_B PPAB
where
ppab.segment1 in ('TESTPRJ')
*******************************************
Project Team Members and Roles
********************************************
select distinct pp.PERSON_ID,
PPNF.FIRST_NAME,
PPNF.LAST_NAME,
pea.email_address,
ppab.project_id,
ppab.segment1,
to_char(PPP.START_DATE_ACTIVE,'dd/mm/yyyy') start_date,
ppp.PROJECT_ROLE_ID,
PPRT.NAME as project_role
from PER_PERSONS PP,
PER_PERSON_NAMES_F PPNF,
PER_EMAIL_ADDRESSES PEA,
PJF_PROJECTS_ALL_B PPAB,
PJF_PROJECT_PARTIES PPP,
PJT_PROJECT_ROLES_TL PPRT
where
PP.PERSON_ID = PPNF.PERSON_ID
and PP.PERSON_ID = PEA.PERSON_ID
and PPNF.NAME_TYPE = 'GLOBAL'
and PPAB.project_id = ppp.project_id
and ppp.RESOURCE_SOURCE_ID= PP.PERSON_ID
and pprt.PROJECT_ROLE_ID = ppp.PROJECT_ROLE_ID
and pprt.LANGUAGE = 'US'
and ppab.project_id in (<<Project IDs>>)
and (pea.email_address like '%xyz.com' or pea.email_address like '%abc.com')