Product: | BOM - Bills of Material |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.BOMFV_MFG_DEPARTMENTS |
SELECT DE.DEPARTMENT_CODE DEPARTMENT_CODE
, PA.ORGANIZATION_CODE ORGANIZATION_CODE
, AL.NAME ORGANIZATION_NAME
, DE.DISABLE_DATE INACTIVE_DATE
, DE.DESCRIPTION DESCRIPTION
, PA2.ORGANIZATION_CODE EXPENDITURE_ORGANIZATION_CODE
, AL2.NAME EXPENDITURE_ORGANIZATION_NAME
, LO.LOCATION_CODE LOCATION_NAME
, '_DF:BOM:BOM_DEPARTMENTS:DE'
, DE.DEPARTMENT_ID
, DE.DEPARTMENT_CLASS_CODE
, DE.ORGANIZATION_ID
, DE.LOCATION_ID
, DE.PA_EXPENDITURE_ORG_ID
, DE.LAST_UPDATE_DATE UPDATED_ON
, DE.LAST_UPDATED_BY UPDATED_BY
, DE.CREATION_DATE CREATED_ON
, DE.CREATED_BY CREATED_BY
FROM HR_ALL_ORGANIZATION_UNITS AL2
, HR_ALL_ORGANIZATION_UNITS AL
, MTL_PARAMETERS PA2
, HR_LOCATIONS_ALL LO
, MTL_PARAMETERS PA
, BOM_DEPARTMENTS DE
WHERE DE.ORGANIZATION_ID = PA.ORGANIZATION_ID
AND DE.ORGANIZATION_ID = AL.ORGANIZATION_ID
AND DE.LOCATION_ID = LO.LOCATION_ID(+)
AND DE.PA_EXPENDITURE_ORG_ID = PA2.ORGANIZATION_ID(+)
AND DE.PA_EXPENDITURE_ORG_ID = AL2.ORGANIZATION_ID(+)
AND '_SEC:DE.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY