[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PSB_WORKSHEET_CONTEXT |
|---|---|
| Object Type: | TABLE |
| Owner: | PSB |
| FND Design Data: |  PSB.PSB_WORKSHEET_CONTEXT
|
| Subobject Name: | |
| Status: | VALID |
PSB_WORKSHEET_CONTEXT stores context information necessary for querying worksheet lines.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| PSB_WORKSHEET_CONTEXT_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
 SESSION_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| SESSION_ID | NUMBER | Yes | User Session Identifier | |
| WORKSHEET_ID | NUMBER | Yes | Worksheet Identifier | |
| ACCOUNT_FLAG | VARCHAR2 | (1) | Account Flag | |
| YEAR1_ID | NUMBER | Year Identifier | ||
| YEAR2_ID | NUMBER | Year Identifier | ||
| YEAR3_ID | NUMBER | Year Identifier | ||
| YEAR4_ID | NUMBER | Year Identifier | ||
| YEAR5_ID | NUMBER | Year Identifier | ||
| YEAR6_ID | NUMBER | Year Identifier | ||
| YEAR7_ID | NUMBER | Year Identifier | ||
| YEAR8_ID | NUMBER | Year Identifier | ||
| YEAR9_ID | NUMBER | Year Identifier | ||
| YEAR10_ID | NUMBER | Year Identifier | ||
| YEAR11_ID | NUMBER | Year Identifier | ||
| YEAR12_ID | NUMBER | Year Identifier | ||
| AMOUNT1_TYPE | VARCHAR2 | (1) | Amount Type | |
| AMOUNT2_TYPE | VARCHAR2 | (1) | Amount Type | |
| AMOUNT3_TYPE | VARCHAR2 | (1) | Amount Type | |
| AMOUNT4_TYPE | VARCHAR2 | (1) | Amount Type | |
| AMOUNT5_TYPE | VARCHAR2 | (1) | Amount Type | |
| AMOUNT6_TYPE | VARCHAR2 | (1) | Amount Type | |
| AMOUNT7_TYPE | VARCHAR2 | (1) | Amount Type | |
| AMOUNT8_TYPE | VARCHAR2 | (1) | Amount Type | |
| AMOUNT9_TYPE | VARCHAR2 | (1) | Amount Type | |
| AMOUNT10_TYPE | VARCHAR2 | (1) | Amount Type | |
| AMOUNT11_TYPE | VARCHAR2 | (1) | Amount Type | |
| AMOUNT12_TYPE | VARCHAR2 | (1) | Amount Type | |
| STAGE | NUMBER | Stage Identifier | ||
| TOTAL_FLAG | VARCHAR2 | (1) | Total Flag |
Cut, paste (and edit) the following text to query this object:
SELECT SESSION_ID
, WORKSHEET_ID
, ACCOUNT_FLAG
, YEAR1_ID
, YEAR2_ID
, YEAR3_ID
, YEAR4_ID
, YEAR5_ID
, YEAR6_ID
, YEAR7_ID
, YEAR8_ID
, YEAR9_ID
, YEAR10_ID
, YEAR11_ID
, YEAR12_ID
, AMOUNT1_TYPE
, AMOUNT2_TYPE
, AMOUNT3_TYPE
, AMOUNT4_TYPE
, AMOUNT5_TYPE
, AMOUNT6_TYPE
, AMOUNT7_TYPE
, AMOUNT8_TYPE
, AMOUNT9_TYPE
, AMOUNT10_TYPE
, AMOUNT11_TYPE
, AMOUNT12_TYPE
, STAGE
, TOTAL_FLAG
FROM PSB.PSB_WORKSHEET_CONTEXT;
PSB.PSB_WORKSHEET_CONTEXT does not reference any database object
PSB.PSB_WORKSHEET_CONTEXT is referenced by following:
APPS
PSB_WORKSHEET_CONTEXT
|
|
|
|