Unable to find table name for files uploaded on content server by partner
Summary:
My objective is to find Content_id of the file uploaded to content server, i have my vendor uploading text documents on my content server
and the external user/vendor has the role name Content Administrator and this part is successful.
i am trying to get content_id of the uploaded file, i am looking for seeded tables, which will allow me to query content recently uploaded based on the file name
SUPPLIER_NAME_YYYY_MM_DD
format.
i have tried searching with
select FT.TABLE_NAME , FC.COLUMN_NAME
from fnd_columns fc , fnd_tables ft where ft.table_id = fc.table_id and fc.column_name ='CONTENT_ID'
0