[Home] [Help]
VIEW: APPS.CR_RSRC_DTL_VW2
Source
View Text - Preformatted
SELECT rm.resources ,rm.resource_desc ,rm.delete_mark ,rd.orgn_code from cr_rsrc_dtl rd, cr_rsrc_mst rm where rm.resources = rd.resources and rd.resources = rd.group_resource and rd.delete_mark = 0
View Text - HTML Formatted
SELECT RM.RESOURCES
, RM.RESOURCE_DESC
, RM.DELETE_MARK
, RD.ORGN_CODE
FROM CR_RSRC_DTL RD
, CR_RSRC_MST RM
WHERE RM.RESOURCES = RD.RESOURCES
AND RD.RESOURCES = RD.GROUP_RESOURCE
AND RD.DELETE_MARK = 0