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

TABLE: PSB.PSB_WS_LINE_BALANCES_I

Object Details
Object Name: PSB_WS_LINE_BALANCES_I
Object Type: TABLE
Owner: PSB
FND Design Data: TablePSB.PSB_WS_LINE_BALANCES_I
Subobject Name:
Status: VALID


PSB_WS_LINE_BALANCES_I is used as an interface table to export and import
account lines to and from worksheets. Based on the the user profile
defined, the balances from the PSB_WS_ACCOUNT_LINES are copied to this
interface prior to exporting to a spreadsheet. When data needs to be
imported back to worksheets, they are copied from the spreadsheet to
this table, validated, and then transferred to PSB_WS_ACCOUNT_LINES.


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PSB_WS_LINE_BALANCES_I_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnCODE_COMBINATION_ID
ColumnEXPORT_ID
ColumnEXPORT_WORKSHEET_TYPE
ColumnSERVICE_PACKAGE_ID
ColumnTEMPLATE_ID
PSB_WS_LINE_BALANCES_I_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnEXPORT_ID
ColumnEXPORT_WORKSHEET_TYPE
ColumnPOSITION_LINE_ID
ColumnPAY_ELEMENT_SET_ID
ColumnCODE_COMBINATION_ID
ColumnSERVICE_PACKAGE_ID
ColumnTEMPLATE_ID
Columns
Name Datatype Length Mandatory Comments
EXPORT_ID NUMBER
Yes Unique identifier assigned to every export of a worksheet to the spreadsheet interface
EXPORT_WORKSHEET_TYPE VARCHAR2 (1) Yes Export worksheet type is A (Account) or P (Position)
CODE_COMBINATION_ID NUMBER

General Ledger code combination identifier
CONCATENATED_ACCOUNT VARCHAR2 (1000)
Concatenated accounting flexfield segment values
ACCOUNT_TYPE VARCHAR2 (1)
General Ledger account type is A (Asset), L (Liability), O (Equity), R (Revenue) or E (Expense)
ACCOUNT_DESCRIPTION VARCHAR2 (1000)
Concatenated account flexfield segment description
BUDGET_GROUP_ID NUMBER

Budget Group identifier
CURRENCY_CODE VARCHAR2 (15)
Functional currency of the General Ledger Set of Books or STAT for statistical currency. Indicates the currency of the amounts.
TEMPLATE_ID NUMBER

General Ledger template unique identifier for summary account lines
SERVICE_PACKAGE_ID NUMBER

Unique identifier of service package to which this line is assigned
SERVICE_PACKAGE_NAME VARCHAR2 (30)
Name of the service package to which this line is assigned
POSITION_LINE_ID NUMBER

Position line identifier
POSITION_ID NUMBER

Position identifier
POSITION_SEGMENTS VARCHAR2 (1000)
Concatenated position flexfield segment values
POSITION_NAME VARCHAR2 (240)
Position name
EMPLOYEE_ID NUMBER

Employee identifier
EMPLOYEE_NUMBER VARCHAR2 (30)
Unique number assigned to employee
EMPLOYEE_NAME VARCHAR2 (240)
Employee name
JOB_NAME VARCHAR2 (1000)
Job name
PAY_ELEMENT_SET_ID NUMBER

Pay element set identifier
PAY_ELEMENT_ID NUMBER

Pay element identifier
PAY_ELEMENT_NAME VARCHAR2 (30)
Pay element name
SALARY_ACCOUNT_LINE VARCHAR2 (1)
Indicates if salary is charged to this account line
FOLLOW_SALARY VARCHAR2 (1)
Flag indicates if this element follows salary distribution
POSITION_ACCOUNT_FLAG VARCHAR2 (1)
Indicates if this is a position account
MODIFIED_FLAG VARCHAR2 (1)
Indicates if this record was modified
PERCENT_OF_SALARY_FLAG VARCHAR2 (1)
Indicates if this element is specified as a percentage of salary
VALUE_TYPE VARCHAR2 (1)
Value type is A (Amount) or P (Percent).
AMOUNT1 NUMBER

Budget amounts
AMOUNT2 NUMBER

Budget amounts
AMOUNT3 NUMBER

Budget amounts
AMOUNT4 NUMBER

Budget amounts
AMOUNT5 NUMBER

Budget amounts
AMOUNT6 NUMBER

Budget amounts
AMOUNT7 NUMBER

Budget amounts
AMOUNT8 NUMBER

Budget amounts
AMOUNT9 NUMBER

Budget amounts
AMOUNT10 NUMBER

Budget amounts
AMOUNT11 NUMBER

Budget amounts
AMOUNT12 NUMBER

Budget amounts
AMOUNT13 NUMBER

Budget amounts
AMOUNT14 NUMBER

Budget amounts
AMOUNT15 NUMBER

Budget amounts
AMOUNT16 NUMBER

Budget amounts
AMOUNT17 NUMBER

Budget amounts
AMOUNT18 NUMBER

Budget amounts
AMOUNT19 NUMBER

Budget amounts
AMOUNT20 NUMBER

Budget amounts
AMOUNT21 NUMBER

Budget amounts
AMOUNT22 NUMBER

Budget amounts
AMOUNT23 NUMBER

Budget amounts
AMOUNT24 NUMBER

Budget amounts
AMOUNT25 NUMBER

Budget amounts
AMOUNT26 NUMBER

Budget amounts
AMOUNT27 NUMBER

Budget amounts
AMOUNT28 NUMBER

Budget amounts
AMOUNT29 NUMBER

Budget amounts
AMOUNT30 NUMBER

Budget amounts
AMOUNT31 NUMBER

Budget amounts
AMOUNT32 NUMBER

Budget amounts
AMOUNT33 NUMBER

Budget amounts
AMOUNT34 NUMBER

Budget amounts
AMOUNT35 NUMBER

Budget amounts
AMOUNT36 NUMBER

Budget amounts
AMOUNT37 NUMBER

Budget amounts
AMOUNT38 NUMBER

Budget amounts
AMOUNT39 NUMBER

Budget amounts
AMOUNT40 NUMBER

Budget amounts
AMOUNT41 NUMBER

Budget amounts
AMOUNT42 NUMBER

Budget amounts
AMOUNT43 NUMBER

Budget amounts
AMOUNT44 NUMBER

Budget amounts
AMOUNT45 NUMBER

Budget amounts
AMOUNT46 NUMBER

Budget amounts
AMOUNT47 NUMBER

Budget amounts
AMOUNT48 NUMBER

Budget amounts
AMOUNT49 NUMBER

Budget amounts
AMOUNT50 NUMBER

Budget amounts
AMOUNT51 NUMBER

Budget amounts
AMOUNT52 NUMBER

Budget amounts
AMOUNT53 NUMBER

Budget amounts
AMOUNT54 NUMBER

Budget amounts
AMOUNT55 NUMBER

Budget amounts
AMOUNT56 NUMBER

Budget amounts
AMOUNT57 NUMBER

Budget amounts
AMOUNT58 NUMBER

Budget amounts
AMOUNT59 NUMBER

Budget amounts
AMOUNT60 NUMBER

Budget amounts
AMOUNT61 NUMBER

Budget amounts
AMOUNT62 NUMBER

Budget amounts
AMOUNT63 NUMBER

Budget amounts
AMOUNT64 NUMBER

Budget amounts
AMOUNT65 NUMBER

Budget amounts
AMOUNT66 NUMBER

Budget amounts
AMOUNT67 NUMBER

Budget amounts
AMOUNT68 NUMBER

Budget amounts
AMOUNT69 NUMBER

Budget amounts
AMOUNT70 NUMBER

Budget amounts
AMOUNT71 NUMBER

Budget amounts
AMOUNT72 NUMBER

Budget amounts
AMOUNT73 NUMBER

Budget amounts
AMOUNT74 NUMBER

Budget amounts
AMOUNT75 NUMBER

Budget amounts
AMOUNT76 NUMBER

Budget amounts
AMOUNT77 NUMBER

Budget amounts
AMOUNT78 NUMBER

Budget amounts
AMOUNT79 NUMBER

Budget amounts
AMOUNT80 NUMBER

Budget amounts
AMOUNT81 NUMBER

Budget amounts
AMOUNT82 NUMBER

Budget amounts
AMOUNT83 NUMBER

Budget amounts
AMOUNT84 NUMBER

Budget amounts
AMOUNT85 NUMBER

Budget amounts
AMOUNT86 NUMBER

Budget amounts
AMOUNT87 NUMBER

Budget amounts
AMOUNT88 NUMBER

Budget amounts
AMOUNT89 NUMBER

Budget amounts
AMOUNT90 NUMBER

Budget amounts
AMOUNT91 NUMBER

Budget amounts
AMOUNT92 NUMBER

Budget amounts
AMOUNT93 NUMBER

Budget amounts
AMOUNT94 NUMBER

Budget amounts
AMOUNT95 NUMBER

Budget amounts
AMOUNT96 NUMBER

Budget amounts
AMOUNT97 NUMBER

Budget amounts
AMOUNT98 NUMBER

Budget amounts
AMOUNT99 NUMBER

Budget amounts
AMOUNT100 NUMBER

Budget amounts
AMOUNT101 NUMBER

Budget amounts
AMOUNT102 NUMBER

Budget amounts
AMOUNT103 NUMBER

Budget amounts
AMOUNT104 NUMBER

Budget amounts
AMOUNT105 NUMBER

Budget amounts
AMOUNT106 NUMBER

Budget amounts
AMOUNT107 NUMBER

Budget amounts
AMOUNT108 NUMBER

Budget amounts
AMOUNT109 NUMBER

Budget amounts
AMOUNT110 NUMBER

Budget amounts
AMOUNT111 NUMBER

Budget amounts
AMOUNT112 NUMBER

Budget amounts
AMOUNT113 NUMBER

Budget amounts
AMOUNT114 NUMBER

Budget amounts
AMOUNT115 NUMBER

Budget amounts
AMOUNT116 NUMBER

Budget amounts
AMOUNT117 NUMBER

Budget amounts
AMOUNT118 NUMBER

Budget amounts
AMOUNT119 NUMBER

Budget amounts
AMOUNT120 NUMBER

Budget amounts
AMOUNT121 NUMBER

Budget amounts
AMOUNT122 NUMBER

Budget amounts
AMOUNT123 NUMBER

Budget amounts
AMOUNT124 NUMBER

Budget amounts
AMOUNT125 NUMBER

Budget amounts
AMOUNT126 NUMBER

Budget amounts
AMOUNT127 NUMBER

Budget amounts
AMOUNT128 NUMBER

Budget amounts
AMOUNT129 NUMBER

Budget amounts
AMOUNT130 NUMBER

Budget amounts
AMOUNT131 NUMBER

Budget amounts
AMOUNT132 NUMBER

Budget amounts
AMOUNT133 NUMBER

Budget amounts
AMOUNT134 NUMBER

Budget amounts
AMOUNT135 NUMBER

Budget amounts
AMOUNT136 NUMBER

Budget amounts
AMOUNT137 NUMBER

Budget amounts
AMOUNT138 NUMBER

Budget amounts
AMOUNT139 NUMBER

Budget amounts
AMOUNT140 NUMBER

Budget amounts
AMOUNT141 NUMBER

Budget amounts
AMOUNT142 NUMBER

Budget amounts
AMOUNT143 NUMBER

Budget amounts
AMOUNT144 NUMBER

Budget amounts
AMOUNT145 NUMBER

Budget amounts
AMOUNT146 NUMBER

Budget amounts
AMOUNT147 NUMBER

Budget amounts
AMOUNT148 NUMBER

Budget amounts
AMOUNT149 NUMBER

Budget amounts
AMOUNT150 NUMBER

Budget amounts
AMOUNT151 NUMBER

Budget amounts
AMOUNT152 NUMBER

Budget amounts
AMOUNT153 NUMBER

Budget amounts
AMOUNT154 NUMBER

Budget amounts
AMOUNT155 NUMBER

Budget amounts
AMOUNT156 NUMBER

Budget amounts
AMOUNT157 NUMBER

Budget amounts
AMOUNT158 NUMBER

Budget amounts
AMOUNT159 NUMBER

Budget amounts
AMOUNT160 NUMBER

Budget amounts
AMOUNT161 NUMBER

Budget amounts
AMOUNT162 NUMBER

Budget amounts
AMOUNT163 NUMBER

Budget amounts
AMOUNT164 NUMBER

Budget amounts
AMOUNT165 NUMBER

Budget amounts
AMOUNT166 NUMBER

Budget amounts
AMOUNT167 NUMBER

Budget amounts
AMOUNT168 NUMBER

Budget amounts
AMOUNT169 NUMBER

Budget amounts
AMOUNT170 NUMBER

Budget amounts
AMOUNT171 NUMBER

Budget amounts
AMOUNT172 NUMBER

Budget amounts
AMOUNT173 NUMBER

Budget amounts
AMOUNT174 NUMBER

Budget amounts
AMOUNT175 NUMBER

Budget amounts
AMOUNT176 NUMBER

Budget amounts
AMOUNT177 NUMBER

Budget amounts
AMOUNT178 NUMBER

Budget amounts
AMOUNT179 NUMBER

Budget amounts
AMOUNT180 NUMBER

Budget amounts
AMOUNT181 NUMBER

Budget amounts
AMOUNT182 NUMBER

Budget amounts
AMOUNT183 NUMBER

Budget amounts
AMOUNT184 NUMBER

Budget amounts
AMOUNT185 NUMBER

Budget amounts
AMOUNT186 NUMBER

Budget amounts
AMOUNT187 NUMBER

Budget amounts
AMOUNT188 NUMBER

Budget amounts
AMOUNT189 NUMBER

Budget amounts
AMOUNT190 NUMBER

Budget amounts
AMOUNT191 NUMBER

Budget amounts
AMOUNT192 NUMBER

Budget amounts
AMOUNT193 NUMBER

Budget amounts
AMOUNT194 NUMBER

Budget amounts
AMOUNT195 NUMBER

Budget amounts
AMOUNT196 NUMBER

Budget amounts
AMOUNT197 NUMBER

Budget amounts
AMOUNT198 NUMBER

Budget amounts
AMOUNT199 NUMBER

Budget amounts
AMOUNT200 NUMBER

Budget amounts
AMOUNT201 NUMBER

Budget amounts
AMOUNT202 NUMBER

Budget amounts
AMOUNT203 NUMBER

Budget amounts
AMOUNT204 NUMBER

Budget amounts
AMOUNT205 NUMBER

Budget amounts
AMOUNT206 NUMBER

Budget amounts
AMOUNT207 NUMBER

Budget amounts
AMOUNT208 NUMBER

Budget amounts
AMOUNT209 NUMBER

Budget amounts
AMOUNT210 NUMBER

Budget amounts
AMOUNT211 NUMBER

Budget amounts
AMOUNT212 NUMBER

Budget amounts
AMOUNT213 NUMBER

Budget amounts
AMOUNT214 NUMBER

Budget amounts
AMOUNT215 NUMBER

Budget amounts
AMOUNT216 NUMBER

Budget amounts
AMOUNT217 NUMBER

Budget amounts
AMOUNT218 NUMBER

Budget amounts
AMOUNT219 NUMBER

Budget amounts
AMOUNT220 NUMBER

Budget amounts
LAST_UPDATE_DATE DATE

Standard Who column
LAST_UPDATED_BY NUMBER

Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
CREATED_BY NUMBER

Standard Who column
CREATED_DATE DATE

Standard Who column
Query Text

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


SELECT EXPORT_ID
,      EXPORT_WORKSHEET_TYPE
,      CODE_COMBINATION_ID
,      CONCATENATED_ACCOUNT
,      ACCOUNT_TYPE
,      ACCOUNT_DESCRIPTION
,      BUDGET_GROUP_ID
,      CURRENCY_CODE
,      TEMPLATE_ID
,      SERVICE_PACKAGE_ID
,      SERVICE_PACKAGE_NAME
,      POSITION_LINE_ID
,      POSITION_ID
,      POSITION_SEGMENTS
,      POSITION_NAME
,      EMPLOYEE_ID
,      EMPLOYEE_NUMBER
,      EMPLOYEE_NAME
,      JOB_NAME
,      PAY_ELEMENT_SET_ID
,      PAY_ELEMENT_ID
,      PAY_ELEMENT_NAME
,      SALARY_ACCOUNT_LINE
,      FOLLOW_SALARY
,      POSITION_ACCOUNT_FLAG
,      MODIFIED_FLAG
,      PERCENT_OF_SALARY_FLAG
,      VALUE_TYPE
,      AMOUNT1
,      AMOUNT2
,      AMOUNT3
,      AMOUNT4
,      AMOUNT5
,      AMOUNT6
,      AMOUNT7
,      AMOUNT8
,      AMOUNT9
,      AMOUNT10
,      AMOUNT11
,      AMOUNT12
,      AMOUNT13
,      AMOUNT14
,      AMOUNT15
,      AMOUNT16
,      AMOUNT17
,      AMOUNT18
,      AMOUNT19
,      AMOUNT20
,      AMOUNT21
,      AMOUNT22
,      AMOUNT23
,      AMOUNT24
,      AMOUNT25
,      AMOUNT26
,      AMOUNT27
,      AMOUNT28
,      AMOUNT29
,      AMOUNT30
,      AMOUNT31
,      AMOUNT32
,      AMOUNT33
,      AMOUNT34
,      AMOUNT35
,      AMOUNT36
,      AMOUNT37
,      AMOUNT38
,      AMOUNT39
,      AMOUNT40
,      AMOUNT41
,      AMOUNT42
,      AMOUNT43
,      AMOUNT44
,      AMOUNT45
,      AMOUNT46
,      AMOUNT47
,      AMOUNT48
,      AMOUNT49
,      AMOUNT50
,      AMOUNT51
,      AMOUNT52
,      AMOUNT53
,      AMOUNT54
,      AMOUNT55
,      AMOUNT56
,      AMOUNT57
,      AMOUNT58
,      AMOUNT59
,      AMOUNT60
,      AMOUNT61
,      AMOUNT62
,      AMOUNT63
,      AMOUNT64
,      AMOUNT65
,      AMOUNT66
,      AMOUNT67
,      AMOUNT68
,      AMOUNT69
,      AMOUNT70
,      AMOUNT71
,      AMOUNT72
,      AMOUNT73
,      AMOUNT74
,      AMOUNT75
,      AMOUNT76
,      AMOUNT77
,      AMOUNT78
,      AMOUNT79
,      AMOUNT80
,      AMOUNT81
,      AMOUNT82
,      AMOUNT83
,      AMOUNT84
,      AMOUNT85
,      AMOUNT86
,      AMOUNT87
,      AMOUNT88
,      AMOUNT89
,      AMOUNT90
,      AMOUNT91
,      AMOUNT92
,      AMOUNT93
,      AMOUNT94
,      AMOUNT95
,      AMOUNT96
,      AMOUNT97
,      AMOUNT98
,      AMOUNT99
,      AMOUNT100
,      AMOUNT101
,      AMOUNT102
,      AMOUNT103
,      AMOUNT104
,      AMOUNT105
,      AMOUNT106
,      AMOUNT107
,      AMOUNT108
,      AMOUNT109
,      AMOUNT110
,      AMOUNT111
,      AMOUNT112
,      AMOUNT113
,      AMOUNT114
,      AMOUNT115
,      AMOUNT116
,      AMOUNT117
,      AMOUNT118
,      AMOUNT119
,      AMOUNT120
,      AMOUNT121
,      AMOUNT122
,      AMOUNT123
,      AMOUNT124
,      AMOUNT125
,      AMOUNT126
,      AMOUNT127
,      AMOUNT128
,      AMOUNT129
,      AMOUNT130
,      AMOUNT131
,      AMOUNT132
,      AMOUNT133
,      AMOUNT134
,      AMOUNT135
,      AMOUNT136
,      AMOUNT137
,      AMOUNT138
,      AMOUNT139
,      AMOUNT140
,      AMOUNT141
,      AMOUNT142
,      AMOUNT143
,      AMOUNT144
,      AMOUNT145
,      AMOUNT146
,      AMOUNT147
,      AMOUNT148
,      AMOUNT149
,      AMOUNT150
,      AMOUNT151
,      AMOUNT152
,      AMOUNT153
,      AMOUNT154
,      AMOUNT155
,      AMOUNT156
,      AMOUNT157
,      AMOUNT158
,      AMOUNT159
,      AMOUNT160
,      AMOUNT161
,      AMOUNT162
,      AMOUNT163
,      AMOUNT164
,      AMOUNT165
,      AMOUNT166
,      AMOUNT167
,      AMOUNT168
,      AMOUNT169
,      AMOUNT170
,      AMOUNT171
,      AMOUNT172
,      AMOUNT173
,      AMOUNT174
,      AMOUNT175
,      AMOUNT176
,      AMOUNT177
,      AMOUNT178
,      AMOUNT179
,      AMOUNT180
,      AMOUNT181
,      AMOUNT182
,      AMOUNT183
,      AMOUNT184
,      AMOUNT185
,      AMOUNT186
,      AMOUNT187
,      AMOUNT188
,      AMOUNT189
,      AMOUNT190
,      AMOUNT191
,      AMOUNT192
,      AMOUNT193
,      AMOUNT194
,      AMOUNT195
,      AMOUNT196
,      AMOUNT197
,      AMOUNT198
,      AMOUNT199
,      AMOUNT200
,      AMOUNT201
,      AMOUNT202
,      AMOUNT203
,      AMOUNT204
,      AMOUNT205
,      AMOUNT206
,      AMOUNT207
,      AMOUNT208
,      AMOUNT209
,      AMOUNT210
,      AMOUNT211
,      AMOUNT212
,      AMOUNT213
,      AMOUNT214
,      AMOUNT215
,      AMOUNT216
,      AMOUNT217
,      AMOUNT218
,      AMOUNT219
,      AMOUNT220
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATED_DATE
FROM PSB.PSB_WS_LINE_BALANCES_I;

Dependencies

[top of page]

PSB.PSB_WS_LINE_BALANCES_I does not reference any database object

PSB.PSB_WS_LINE_BALANCES_I is referenced by following:

SchemaAPPS
SynonymPSB_WS_LINE_BALANCES_I