VIEW: APPS.BOM_DEPARTMENTS_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'