[Home] [Help]
View: GR_LABEL_PROD_CLASSES_V
Product: | GR - Process Manufacturing Regulatory Management |
Description: | Label production classes view |
Implementation/DBA Data: |
APPS.GR_LABEL_PROD_CLASSES_V
|
View Text
SELECT LPC.ROWID ROW_ID
, LPC.LABEL_CODE
, LPC.PRODUCT_CLASS
, PC.PRODUCT_CLASS_DESC
, LPC.CREATED_BY
, LPC.CREATION_DATE
, LPC.LAST_UPDATED_BY
, LPC.LAST_UPDATE_DATE
, LPC.LAST_UPDATE_LOGIN
FROM GR_PRODUCT_CLASSES PC
, GR_LABEL_PROD_CLASSES LPC
WHERE PC.PRODUCT_CLASS = LPC.PRODUCT_CLASS
Columns
Name |
ROW_ID |
LABEL_CODE |
PRODUCT_CLASS |
PRODUCT_CLASS_DESC |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |