DBA Data[Home] [Help]

VIEW: APPS.PABV_RESOURCE_LIST_ASGN

Source

View Text - Preformatted

SELECT prla.resource_list_assignment_id , prla.resource_list_id , prla.project_id , prla.LAST_UPDATE_DATE , prla.LAST_UPDATED_BY , prla.CREATION_DATE , prla.CREATED_BY FROM pa_resource_list_assignments prla , pa_projects_all ppa WHERE prla.project_id = ppa.project_id and '_SEC:ppa.org_id' is not null WITH READ ONLY
View Text - HTML Formatted

SELECT PRLA.RESOURCE_LIST_ASSIGNMENT_ID
, PRLA.RESOURCE_LIST_ID
, PRLA.PROJECT_ID
, PRLA.LAST_UPDATE_DATE
, PRLA.LAST_UPDATED_BY
, PRLA.CREATION_DATE
, PRLA.CREATED_BY
FROM PA_RESOURCE_LIST_ASSIGNMENTS PRLA
, PA_PROJECTS_ALL PPA
WHERE PRLA.PROJECT_ID = PPA.PROJECT_ID
AND '_SEC:PPA.ORG_ID' IS NOT NULL WITH READ ONLY