[Home] [Help]
View: BOM_DEPENDENT_DESC_ELEMENTS_V
View Text
SELECT BDDE.ROWID ROW_ID
, BDDE.BILL_SEQUENCE_ID
, BDDE.ELEMENT_NAME
, MDE.DESCRIPTION
, BDDE.LAST_UPDATE_DATE
, BDDE.LAST_UPDATED_BY
, BDDE.CREATION_DATE
, BDDE.CREATED_BY
, BDDE.REQUEST_ID
, BDDE.PROGRAM_APPLICATION_ID
, BDDE.PROGRAM_ID
, BDDE.PROGRAM_UPDATE_DATE
, BDDE.LAST_UPDATE_LOGIN
FROM BOM_DEPENDENT_DESC_ELEMENTS BDDE
, MTL_DESCRIPTIVE_ELEMENTS MDE
WHERE BDDE.ELEMENT_NAME = MDE.ELEMENT_NAME
AND MDE.ROWID = (SELECT MIN(ROWID)
FROM MTL_DESCRIPTIVE_ELEMENTS MDE2
WHERE MDE2.ELEMENT_NAME = MDE.ELEMENT_NAME)
Columns
Name |
ROW_ID |
BILL_SEQUENCE_ID |
ELEMENT_NAME |
DESCRIPTION |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATION_DATE |
CREATED_BY |
REQUEST_ID |
PROGRAM_APPLICATION_ID |
PROGRAM_ID |
PROGRAM_UPDATE_DATE |
LAST_UPDATE_LOGIN |