Monday, 19 November 2012

How to Find Document Entities


SELECT fde.document_entity_id, fde.data_object_code,
          fde.table_name, fde.application_id, fatl.application_name,
          tl.user_entity_name, tl.user_entity_prompt, fde.creation_date,
          fde.created_by, fde.last_update_date, fde.last_updated_by,
          fde.last_update_login, fde.pk1_column, fde.pk2_column,
          fde.pk3_column, fde.pk4_column, fde.pk5_column
     FROM fnd_application_tl fatl,
          fnd_document_entities_tl tl,
          fnd_document_entities fde
    WHERE fde.data_object_code = tl.data_object_code
      AND tl.LANGUAGE = USERENV ('LANG')
      AND fde.application_id = fatl.application_id
      AND fatl.LANGUAGE = USERENV ('LANG');

No comments:

Post a Comment