DBA Data[Home] [Help] [Dependency Information]


TABLE: GHG.GHG_SEGMENT_MAPPINGS_ALL

Object Details
Object Name: GHG_SEGMENT_MAPPINGS_ALL
Object Type: TABLE
Owner: GHG
FND Design Data: TableGHG.GHG_SEGMENT_MAPPINGS_ALL
Subobject Name:
Status: VALID


This table stores the segment mappings


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
MAP_ACCOUNTS_FLAG VARCHAR2 (1) Yes Map Accounts Flag
MAP_OPERATING_UNIT_FLAG VARCHAR2 (1) Yes Map Operating Unit Flag
MAP_PROJECTS_FLAG VARCHAR2 (1) Yes Map Projects Flag
MAP_SEGMENT1_FLAG VARCHAR2 (1) Yes Mapping Segment1 Flag
MAP_SEGMENT2_FLAG VARCHAR2 (1) Yes Mapping Segment2 Flag
MAP_SEGMENT3_FLAG VARCHAR2 (1) Yes Mapping Segment3 Flag
MAP_SEGMENT4_FLAG VARCHAR2 (1) Yes Mapping Segment4 Flag
MAP_SEGMENT5_FLAG VARCHAR2 (1) Yes Mapping Segment5 Flag
MAP_SEGMENT6_FLAG VARCHAR2 (1) Yes Mapping Segment6 Flag
MAP_SEGMENT7_FLAG VARCHAR2 (1) Yes Mapping Segment7 Flag
MAP_SEGMENT8_FLAG VARCHAR2 (1) Yes Mapping Segment8 Flag
MAP_SEGMENT9_FLAG VARCHAR2 (1) Yes Mapping Segment9 Flag
MAP_SEGMENT10_FLAG VARCHAR2 (1) Yes Mapping Segment10 Flag
MAP_SEGMENT11_FLAG VARCHAR2 (1) Yes Mapping Segment11 Flag
MAP_SEGMENT12_FLAG VARCHAR2 (1) Yes Mapping Segment12 Flag
MAP_SEGMENT13_FLAG VARCHAR2 (1) Yes Mapping Segment13 Flag
MAP_SEGMENT14_FLAG VARCHAR2 (1) Yes Mapping Segment14 Flag
MAP_SEGMENT15_FLAG VARCHAR2 (1) Yes Mapping Segment15 Flag
MAP_SEGMENT16_FLAG VARCHAR2 (1) Yes Mapping Segment16 Flag
MAP_SEGMENT17_FLAG VARCHAR2 (1) Yes Mapping Segment17 Flag
MAP_SEGMENT18_FLAG VARCHAR2 (1) Yes Mapping Segment18 Flag
MAP_SEGMENT19_FLAG VARCHAR2 (1) Yes Mapping Segment19 Flag
MAP_SEGMENT20_FLAG VARCHAR2 (1) Yes Mapping Segment20 Flag
MAP_SEGMENT21_FLAG VARCHAR2 (1) Yes Mapping Segment21 Flag
MAP_SEGMENT22_FLAG VARCHAR2 (1) Yes Mapping Segment22 Flag
MAP_SEGMENT23_FLAG VARCHAR2 (1) Yes Mapping Segment23 Flag
MAP_SEGMENT24_FLAG VARCHAR2 (1) Yes Mapping Segment24 Flag
MAP_SEGMENT25_FLAG VARCHAR2 (1) Yes Mapping Segment25 Flag
MAP_SEGMENT26_FLAG VARCHAR2 (1) Yes Mapping Segment26 Flag
MAP_SEGMENT27_FLAG VARCHAR2 (1) Yes Mapping Segment27 Flag
MAP_SEGMENT28_FLAG VARCHAR2 (1) Yes Mapping Segment28 Flag
MAP_SEGMENT29_FLAG VARCHAR2 (1) Yes Mapping Segment29 Flag
MAP_SEGMENT30_FLAG VARCHAR2 (1) Yes Mapping Segment30 Flag
ORG_ID NUMBER (15) Yes Organization Identifier
SET_OF_BOOKS_ID NUMBER (15) Yes Set Of Books Identifier
CREATED_BY NUMBER (15)
Standard Who Column
CREATION_DATE DATE

Standard Who Column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who Column
LAST_UPDATE_DATE DATE
Yes Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT MAP_ACCOUNTS_FLAG
,      MAP_OPERATING_UNIT_FLAG
,      MAP_PROJECTS_FLAG
,      MAP_SEGMENT1_FLAG
,      MAP_SEGMENT2_FLAG
,      MAP_SEGMENT3_FLAG
,      MAP_SEGMENT4_FLAG
,      MAP_SEGMENT5_FLAG
,      MAP_SEGMENT6_FLAG
,      MAP_SEGMENT7_FLAG
,      MAP_SEGMENT8_FLAG
,      MAP_SEGMENT9_FLAG
,      MAP_SEGMENT10_FLAG
,      MAP_SEGMENT11_FLAG
,      MAP_SEGMENT12_FLAG
,      MAP_SEGMENT13_FLAG
,      MAP_SEGMENT14_FLAG
,      MAP_SEGMENT15_FLAG
,      MAP_SEGMENT16_FLAG
,      MAP_SEGMENT17_FLAG
,      MAP_SEGMENT18_FLAG
,      MAP_SEGMENT19_FLAG
,      MAP_SEGMENT20_FLAG
,      MAP_SEGMENT21_FLAG
,      MAP_SEGMENT22_FLAG
,      MAP_SEGMENT23_FLAG
,      MAP_SEGMENT24_FLAG
,      MAP_SEGMENT25_FLAG
,      MAP_SEGMENT26_FLAG
,      MAP_SEGMENT27_FLAG
,      MAP_SEGMENT28_FLAG
,      MAP_SEGMENT29_FLAG
,      MAP_SEGMENT30_FLAG
,      ORG_ID
,      SET_OF_BOOKS_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM GHG.GHG_SEGMENT_MAPPINGS_ALL;

Dependencies

[top of page]

GHG.GHG_SEGMENT_MAPPINGS_ALL does not reference any database object

GHG.GHG_SEGMENT_MAPPINGS_ALL is referenced by following:

SchemaGHG
ViewGHG_SEGMENT_MAPPINGS_ALL#