VIEW: APPS.PAFV_RESOURCE_LIST_RESOURCES

Source

View Text - Preformatted

SELECT prlm.resource_list_member_id , prlm.alias , '_LA:prlm.enabled_flag:FND_LOOKUPS:YES_NO:MEANING' , '_LA:prlm.track_as_labor_flag:FND_LOOKUPS:YES_NO:MEANING' , prlm.parent_member_id , prlm.resource_id , pr.name , prlm.resource_list_id , prla.name, prt.name , prlm.LAST_UPDATE_DATE , prlm.LAST_UPDATED_BY , prlm.CREATION_DATE , prlm.CREATED_BY FROM pa_resource_list_members prlm , pa_resources pr, pa_resource_types prt , pa_resource_lists_all_bg prla WHERE prlm.resource_list_id = prla.resource_list_id and prlm.resource_id = pr.resource_id and pr.resource_type_id = prt.resource_type_id and prt.resource_type_code not in ('UNCATEGORIZED','UNCLASSIFIED') WITH READ ONLY

View Text - HTML Formatted

SELECT PRLM.RESOURCE_LIST_MEMBER_ID
, PRLM.ALIAS
, '_LA:PRLM.ENABLED_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:PRLM.TRACK_AS_LABOR_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, PRLM.PARENT_MEMBER_ID
, PRLM.RESOURCE_ID
, PR.NAME
, PRLM.RESOURCE_LIST_ID
, PRLA.NAME
, PRT.NAME
, PRLM.LAST_UPDATE_DATE
, PRLM.LAST_UPDATED_BY
, PRLM.CREATION_DATE
, PRLM.CREATED_BY
FROM PA_RESOURCE_LIST_MEMBERS PRLM
, PA_RESOURCES PR
, PA_RESOURCE_TYPES PRT
, PA_RESOURCE_LISTS_ALL_BG PRLA
WHERE PRLM.RESOURCE_LIST_ID = PRLA.RESOURCE_LIST_ID
AND PRLM.RESOURCE_ID = PR.RESOURCE_ID
AND PR.RESOURCE_TYPE_ID = PRT.RESOURCE_TYPE_ID
AND PRT.RESOURCE_TYPE_CODE NOT IN ('UNCATEGORIZED'
, 'UNCLASSIFIED') WITH READ ONLY