View: BOMFV_ALTERNATE_BOM_CODES

Product:	BOM - Bills of Material
Description:	- Retrofitted
Implementation/DBA Data:	APPS.BOMFV_ALTERNATE_BOM_CODES

View Text

SELECT DE.ALTERNATE_DESIGNATOR_CODE ALTERNATE_DESIGNATOR_CODE
, PA.ORGANIZATION_CODE ORGANIZATION_CODE
, AL.NAME ORGANIZATION_NAME
, DE.DESCRIPTION DESCRIPTION
, DE.DISABLE_DATE INACTIVE_DATE
, '_DF:BOM:BOM_ALTERNATE_DESIGNATORS:DE'
, DE.ORGANIZATION_ID
, DE.LAST_UPDATE_DATE UPDATED_ON
, DE.LAST_UPDATED_BY UPDATED_BY
, DE.CREATION_DATE CREATED_ON
, DE.CREATED_BY
FROM MTL_PARAMETERS PA
, HR_ALL_ORGANIZATION_UNITS AL
, BOM_ALTERNATE_DESIGNATORS DE
WHERE DE.ORGANIZATION_ID = PA.ORGANIZATION_ID
AND DE.ORGANIZATION_ID = AL.ORGANIZATION_ID
AND '_SEC:DE.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

Columns