DBA Data[Home] [Help]

VIEW: APPS.GR_LABEL_PROD_CLASSES_V

Source

View Text - Preformatted

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
View Text - HTML Formatted

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