This discussion is archived
2 Replies Latest reply: Aug 17, 2012 3:00 AM by 925599 RSS

EGP_SYSTEM_ITEMS_B

925599 Newbie
Currently Being Moderated
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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points