View: BOM_DEPARTMENTS_V

Product:	BOM - Bills of Material
Description:	Departments
Implementation/DBA Data:	APPS.BOM_DEPARTMENTS_V

View Text

SELECT BD.ROWID ROW_ID
, BD.DEPARTMENT_ID
, BD.DEPARTMENT_CODE
, BD.ORGANIZATION_ID
, BD.LAST_UPDATE_DATE
, BD.LAST_UPDATED_BY
, BD.CREATION_DATE
, BD.CREATED_BY
, BD.LAST_UPDATE_LOGIN
, BD.DESCRIPTION
, BD.DISABLE_DATE
, BD.DEPARTMENT_CLASS_CODE
, BDC.DESCRIPTION CLASS_DESCRIPTION
, BD.LOCATION_ID
, HL.LOCATION_CODE
, HL.DESCRIPTION LOCATION_DESCRIPTION
, BD.PA_EXPENDITURE_ORG_ID
, HRAO.NAME PA_EXPENDITURE_ORG_NAME
, BD.ATTRIBUTE_CATEGORY
, BD.ATTRIBUTE1
, BD.ATTRIBUTE2
, BD.ATTRIBUTE3
, BD.ATTRIBUTE4
, BD.ATTRIBUTE5
, BD.ATTRIBUTE6
, BD.ATTRIBUTE7
, BD.ATTRIBUTE8
, BD.ATTRIBUTE9
, BD.ATTRIBUTE10
, BD.ATTRIBUTE11
, BD.ATTRIBUTE12
, BD.ATTRIBUTE13
, BD.ATTRIBUTE14
, BD.ATTRIBUTE15
, BD.REQUEST_ID
, BD.PROGRAM_APPLICATION_ID
, BD.PROGRAM_ID
, BD.PROGRAM_UPDATE_DATE
, BD.SCRAP_ACCOUNT
, BD.EST_ABSORPTION_ACCOUNT
, BD.MAINT_COST_CATEGORY
, ML.MEANING MAINT_COST_CATEGORY_VALUE
FROM BOM_DEPARTMENTS BD
, BOM_DEPARTMENT_CLASSES BDC
, HR_ALL_ORGANIZATION_UNITS HRAO
, HR_LOCATIONS HL
, MFG_LOOKUPS ML
WHERE BD.DEPARTMENT_CLASS_CODE = BDC.DEPARTMENT_CLASS_CODE(+)
AND BD.ORGANIZATION_ID = BDC.ORGANIZATION_ID (+)
AND BD.LOCATION_ID = HL.LOCATION_ID(+)
AND BD.PA_EXPENDITURE_ORG_ID = HRAO.ORGANIZATION_ID(+)
AND ML.LOOKUP_CODE(+) = TO_NUMBER(BD.MAINT_COST_CATEGORY )
AND ML.LOOKUP_TYPE(+) = 'BOM_EAM_COST_CATEGORY'

Columns