View: BOMBV_ENGINEERING_BOMS

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

View Text

SELECT BI.ALTERNATE_BOM_DESIGNATOR ALTERNATE_BOM_CODE
, PA.ORGANIZATION_CODE ORGANIZATION_CODE
, AL.NAME ORGANIZATION_NAME
, '_KF:INV:MSTK:SY' "_KF:BILL_ITEM_NAME"
, BI.SPECIFIC_ASSEMBLY_COMMENT DESCRIPTION
, BI.PENDING_FROM_ECN PENDING_FROM_ECO
, BI.ASSEMBLY_ITEM_ID
, BI.ORGANIZATION_ID
, BI.BILL_SEQUENCE_ID
, BI.COMMON_ASSEMBLY_ITEM_ID
, BI.COMMON_BILL_SEQUENCE_ID
, BI.COMMON_ORGANIZATION_ID
, BI.LAST_UPDATE_DATE
, BI.LAST_UPDATED_BY
, BI.CREATION_DATE
, BI.CREATED_BY
FROM HR_ALL_ORGANIZATION_UNITS AL
, MTL_PARAMETERS PA
, MTL_SYSTEM_ITEMS_B SY
, BOM_BILL_OF_MATERIALS BI
WHERE BI.ASSEMBLY_ITEM_ID = SY.INVENTORY_ITEM_ID
AND BI.ORGANIZATION_ID = SY.ORGANIZATION_ID
AND BI.ORGANIZATION_ID = PA.ORGANIZATION_ID
AND BI.ORGANIZATION_ID = AL.ORGANIZATION_ID
AND BI.ASSEMBLY_TYPE = 2
AND '_SEC:BI.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

Columns