eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.ENG_WEB_REF_DESIG_V

Source

View Text - Preformatted


SELECT brd.component_sequence_id, ml.meaning action, brd.component_reference_designator, brd.ref_designator_comment From mfg_lookups ml, bom_reference_designators brd, eng_revised_items eri, bom_inventory_components bic Where brd.component_sequence_id = bic.component_sequence_id And bic.revised_item_sequence_id = eri.revised_item_sequence_id And brd.change_notice = eri.change_notice And ml.lookup_code = brd.acd_type And ml.lookup_type = 'ENG_REF_DESIG_ACTION'

View Text - HTML Formatted

SELECT BRD.COMPONENT_SEQUENCE_ID
, ML.MEANING ACTION
, BRD.COMPONENT_REFERENCE_DESIGNATOR
, BRD.REF_DESIGNATOR_COMMENT
FROM MFG_LOOKUPS ML
, BOM_REFERENCE_DESIGNATORS BRD
, ENG_REVISED_ITEMS ERI
, BOM_INVENTORY_COMPONENTS BIC
WHERE BRD.COMPONENT_SEQUENCE_ID = BIC.COMPONENT_SEQUENCE_ID
AND BIC.REVISED_ITEM_SEQUENCE_ID = ERI.REVISED_ITEM_SEQUENCE_ID
AND BRD.CHANGE_NOTICE = ERI.CHANGE_NOTICE
AND ML.LOOKUP_CODE = BRD.ACD_TYPE
AND ML.LOOKUP_TYPE = 'ENG_REF_DESIG_ACTION'