3 Replies Latest reply on Feb 20, 2019 3:21 AM by Kanda-Oracle

    Oracle EBIZ user - designs, manufactures and sells electrical and electronic products for non-residential and residential construction, industrial and utility applications. Requirement - retreive all of the ECO attachments from Oracle EBIZ version 11i

    3851087

      ·         Oracle EBIZ user - designs, manufactures and sells electrical and electronic products for non-residential and residential construction, industrial and utility applications.

      ·         Requirement - retrieve all of the ECO attachments from Oracle EBIZ version 11i

      How can I identify the total size of all ECO attachments/documents in the FND_ATTACHED_DOCS_FORM_VL - the SQL select statement is: select DISTINCT FILE_NAME from FND_ATTACHED_DOCS_FORM_VL WHERE ENTITY_NAME = 'ENG_ENGINEERING_CHANGES'