DBA Data[Home] [Help]

VIEW: APPS.PA_PRJ_ACCUM_PERIODS_V

Source

View Text - Preformatted

SELECT pah.PROJECT_ID , pah.accum_period FROM pa_project_accum_headers pah WHERE pah.task_id = 0 and pah.resource_id = 0 and pah.resource_list_member_id = 0 and pah.resource_list_id = 0 and pah.resource_list_assignment_id = 0 WITH READ ONLY
View Text - HTML Formatted

SELECT PAH.PROJECT_ID
, PAH.ACCUM_PERIOD
FROM PA_PROJECT_ACCUM_HEADERS PAH
WHERE PAH.TASK_ID = 0
AND PAH.RESOURCE_ID = 0
AND PAH.RESOURCE_LIST_MEMBER_ID = 0
AND PAH.RESOURCE_LIST_ID = 0
AND PAH.RESOURCE_LIST_ASSIGNMENT_ID = 0 WITH READ ONLY