[Home] [Help]
View: CR_RSRC_DTL_VW2
Product: | GMP - Process Manufacturing Process Planning |
Description: | Not currently used. |
Implementation/DBA Data: |
APPS.CR_RSRC_DTL_VW2
|
View Text
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
Columns
Name |
RESOURCES |
RESOURCE_DESC |
DELETE_MARK |
ORGN_CODE |