View: BOMFV_BOM_REFERE_DESIGNATORS

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

View Text

SELECT RE.COMPONENT_REFERENCE_DESIGNATOR REFERENCE_DESIGNATOR_NAME
, CO.EFFECTIVITY_DATE START_EFFECTIVITY_DATE
, CO.OPERATION_SEQ_NUM OPERATION_SEQUENCE_NUMBER
, BI.ALTERNATE_BOM_DESIGNATOR ALTERNATE_BOM_CODE
, '_KF:INV:MSTK:SY1' "_KF:BILL_ITEM_NAME"
, '_KF:INV:MTLL:SY2' "_KF:COMPONENT_ITEM_NAME"
, PA.ORGANIZATION_CODE ORGANIZATION_CODE
, AL.NAME ORGANIZATION_NAME
, RE.REF_DESIGNATOR_COMMENT "COMMENT"
, '_LA:RE.ACD_TYPE:MFG_LOOKUPS:ECG_ACTION:MEANING'
, '_DF:BOM:BOM_REFERENCE_DESIGNATORS:RE'
, RE.COMPONENT_SEQUENCE_ID
, BI.ORGANIZATION_ID
, RE.CHANGE_NOTICE
, RE.LAST_UPDATE_DATE UPDATED_ON
, RE.LAST_UPDATED_BY UPDATED_BY
, RE.CREATION_DATE CREATED_ON
, RE.CREATED_BY
FROM HR_ALL_ORGANIZATION_UNITS AL
, BOM_STRUCTURES_B BI
, MTL_PARAMETERS PA
, MTL_SYSTEM_ITEMS_B SY2
, MTL_SYSTEM_ITEMS_B SY1
, BOM_COMPONENTS_B CO
, BOM_REFERENCE_DESIGNATORS RE
WHERE BI.ORGANIZATION_ID = PA.ORGANIZATION_ID
AND BI.ORGANIZATION_ID = AL.ORGANIZATION_ID
AND CO.COMPONENT_ITEM_ID = SY2.INVENTORY_ITEM_ID
AND BI.ORGANIZATION_ID = SY2.ORGANIZATION_ID
AND BI.ASSEMBLY_ITEM_ID = SY1.INVENTORY_ITEM_ID
AND BI.ORGANIZATION_ID = SY1.ORGANIZATION_ID
AND CO.BILL_SEQUENCE_ID = BI.BILL_SEQUENCE_ID
AND RE.COMPONENT_SEQUENCE_ID = CO.COMPONENT_SEQUENCE_ID
AND '_SEC:BI.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

Columns