[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | GHG_SEGMENT_MAPPINGS_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| Subobject Name: | |
| Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This view stores information about segment mappings
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ROW_ID | ROWID | (10) | Row Identifier | |
| MAP_ACCOUNTS_FLAG | VARCHAR2 | (1) | Yes | Mapping Accounts Flag |
| MAP_OPERATING_UNIT_FLAG | VARCHAR2 | (1) | Yes | Mapping Operating Unit Flag |
| MAP_PROJECTS_FLAG | VARCHAR2 | (1) | Yes | Mapping 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 |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, 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 APPS.GHG_SEGMENT_MAPPINGS_V;
APPS
GHG_SEGMENT_MAPPINGS
APPS
GHG_PO_EMISSIONS_PKG
- show dependent code
GHG_TRANSACTIONS_PKG
- show dependent code
GHG_UTILITIES_PKG
- show dependent code
|
|
|
|