2 Replies Latest reply: Aug 17, 2012 5:00 AM by 925599 RSS

    EGP_SYSTEM_ITEMS_B

    925599
      Hello All,

      Has anyone seen a list of column names for the EGP_SYSTEM_ITEMS_B table? On Metalink I found a pdf document (Model_FUSION_PIM.pdf) that provides a diagram at a high level of how the item tables relate but I have not found a detailed table description with column names.

      Thanks and Regards,

      Jim S
        • 1. Re: EGP_SYSTEM_ITEMS_B
          rond
          Jim,
          I did not find a list but I was able to use TOAD to see all the Columns. If you have access to Toad and the DB, you can query that list.
          Ron
          • 2. Re: EGP_SYSTEM_ITEMS_B
            925599
            All,

            Via another forum I got the answer.
            Oracle has published a version of Oracle Enterprise Repository for Fusion Applications

            https://fusionappsoer.oracle.com/oer/index.jsp

            OER contains a searchable index that makes it easy to find any FUSION Apps tables.

            Good Luck,

            Jim S