How the Datatype_id of attachments are populated for an Invoice

Hi Team,

We have used the following query for one of our requirement. And this script returned 0 rows for one invoice due to datatype_id = 1.

This script needs to returns a row. We will make changes to this code to handle for datatype_id = 1 also.

Here can you please explain how datatype_id is populated in FND tables and the order of the tables it will be populated.

How the datatype_id value will assign like 1,2,5,6 etc..

SELECT     fdst.long_text,     fdst.ROWID

    INTO       v_notes_long,      v_rowid_long

    FROM      fnd_documents_long_text fdst,      fnd_attached_docs_form_vl fadfv