VIEW: APPS.BOMBV_BOM_REFERE_DESIGNATORS

Source

View Text - Preformatted

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' , 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 BOM_BILL_OF_MATERIALS BI , HR_ALL_ORGANIZATION_UNITS AL , MTL_PARAMETERS PA , MTL_SYSTEM_ITEMS_B SY2 , MTL_SYSTEM_ITEMS_B SY1 , BOM_INVENTORY_COMPONENTS 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

View Text - HTML Formatted

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'
, 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 BOM_BILL_OF_MATERIALS BI
, HR_ALL_ORGANIZATION_UNITS AL
, MTL_PARAMETERS PA
, MTL_SYSTEM_ITEMS_B SY2
, MTL_SYSTEM_ITEMS_B SY1
, BOM_INVENTORY_COMPONENTS 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