eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: PSB_ACCT_POSITION_SET_LINES_V

Product:	PSB - Public Sector Budgeting (Obsolete)
Description:
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT LINES.ROWID
, LINES.LINE_SEQUENCE_ID
, LINES.ACCOUNT_POSITION_SET_ID
, LINES.DESCRIPTION
, LINES.BUSINESS_GROUP_ID
, LINES.ATTRIBUTE_ID
, LINES.INCLUDE_OR_EXCLUDE_TYPE
, LINES.SEGMENT1_LOW
, LINES.SEGMENT2_LOW
, LINES.SEGMENT3_LOW
, LINES.SEGMENT4_LOW
, LINES.SEGMENT5_LOW
, LINES.SEGMENT6_LOW
, LINES.SEGMENT7_LOW
, LINES.SEGMENT8_LOW
, LINES.SEGMENT9_LOW
, LINES.SEGMENT10_LOW
, LINES.SEGMENT11_LOW
, LINES.SEGMENT12_LOW
, LINES.SEGMENT13_LOW
, LINES.SEGMENT14_LOW
, LINES.SEGMENT15_LOW
, LINES.SEGMENT16_LOW
, LINES.SEGMENT17_LOW
, LINES.SEGMENT18_LOW
, LINES.SEGMENT19_LOW
, LINES.SEGMENT20_LOW
, LINES.SEGMENT21_LOW
, LINES.SEGMENT22_LOW
, LINES.SEGMENT23_LOW
, LINES.SEGMENT24_LOW
, LINES.SEGMENT25_LOW
, LINES.SEGMENT26_LOW
, LINES.SEGMENT27_LOW
, LINES.SEGMENT28_LOW
, LINES.SEGMENT29_LOW
, LINES.SEGMENT30_LOW
, LINES.SEGMENT1_HIGH
, LINES.SEGMENT2_HIGH
, LINES.SEGMENT3_HIGH
, LINES.SEGMENT4_HIGH
, LINES.SEGMENT5_HIGH
, LINES.SEGMENT6_HIGH
, LINES.SEGMENT7_HIGH
, LINES.SEGMENT8_HIGH
, LINES.SEGMENT9_HIGH
, LINES.SEGMENT10_HIGH
, LINES.SEGMENT11_HIGH
, LINES.SEGMENT12_HIGH
, LINES.SEGMENT13_HIGH
, LINES.SEGMENT14_HIGH
, LINES.SEGMENT15_HIGH
, LINES.SEGMENT16_HIGH
, LINES.SEGMENT17_HIGH
, LINES.SEGMENT18_HIGH
, LINES.SEGMENT19_HIGH
, LINES.SEGMENT20_HIGH
, LINES.SEGMENT21_HIGH
, LINES.SEGMENT22_HIGH
, LINES.SEGMENT23_HIGH
, LINES.SEGMENT24_HIGH
, LINES.SEGMENT25_HIGH
, LINES.SEGMENT26_HIGH
, LINES.SEGMENT27_HIGH
, LINES.SEGMENT28_HIGH
, LINES.SEGMENT29_HIGH
, LINES.SEGMENT30_HIGH
, LINES.CONTEXT
, LINES.ATTRIBUTE1
, LINES.ATTRIBUTE2
, LINES.ATTRIBUTE3
, LINES.ATTRIBUTE4
, LINES.ATTRIBUTE5
, LINES.ATTRIBUTE6
, LINES.ATTRIBUTE7
, LINES.ATTRIBUTE8
, LINES.ATTRIBUTE9
, LINES.ATTRIBUTE10
, LINES.LAST_UPDATE_DATE
, LINES.LAST_UPDATED_BY
, LINES.LAST_UPDATE_LOGIN
, LINES.CREATED_BY
, LINES.CREATION_DATE
, NULL
, NULL
, FL.MEANING
FROM PSB_ACCOUNT_POSITION_SET_LINES LINES
, PSB_ACCOUNT_POSITION_SETS SETS
, FND_LOOKUPS FL
WHERE SETS.ACCOUNT_POSITION_SET_ID = LINES.ACCOUNT_POSITION_SET_ID
AND SETS.ACCOUNT_OR_POSITION_TYPE = 'A'
AND FL.LOOKUP_TYPE = 'PSB_INCLUDE_OR_EXCLUDE_TYPE'
AND FL.LOOKUP_CODE = LINES.INCLUDE_OR_EXCLUDE_TYPE UNION SELECT LINES.ROWID
, LINES.LINE_SEQUENCE_ID
, LINES.ACCOUNT_POSITION_SET_ID
, LINES.DESCRIPTION
, LINES.BUSINESS_GROUP_ID
, LINES.ATTRIBUTE_ID
, LINES.INCLUDE_OR_EXCLUDE_TYPE
, LINES.SEGMENT1_LOW
, LINES.SEGMENT2_LOW
, LINES.SEGMENT3_LOW
, LINES.SEGMENT4_LOW
, LINES.SEGMENT5_LOW
, LINES.SEGMENT6_LOW
, LINES.SEGMENT7_LOW
, LINES.SEGMENT8_LOW
, LINES.SEGMENT9_LOW
, LINES.SEGMENT10_LOW
, LINES.SEGMENT11_LOW
, LINES.SEGMENT12_LOW
, LINES.SEGMENT13_LOW
, LINES.SEGMENT14_LOW
, LINES.SEGMENT15_LOW
, LINES.SEGMENT16_LOW
, LINES.SEGMENT17_LOW
, LINES.SEGMENT18_LOW
, LINES.SEGMENT19_LOW
, LINES.SEGMENT20_LOW
, LINES.SEGMENT21_LOW
, LINES.SEGMENT22_LOW
, LINES.SEGMENT23_LOW
, LINES.SEGMENT24_LOW
, LINES.SEGMENT25_LOW
, LINES.SEGMENT26_LOW
, LINES.SEGMENT27_LOW
, LINES.SEGMENT28_LOW
, LINES.SEGMENT29_LOW
, LINES.SEGMENT30_LOW
, LINES.SEGMENT1_HIGH
, LINES.SEGMENT2_HIGH
, LINES.SEGMENT3_HIGH
, LINES.SEGMENT4_HIGH
, LINES.SEGMENT5_HIGH
, LINES.SEGMENT6_HIGH
, LINES.SEGMENT7_HIGH
, LINES.SEGMENT8_HIGH
, LINES.SEGMENT9_HIGH
, LINES.SEGMENT10_HIGH
, LINES.SEGMENT11_HIGH
, LINES.SEGMENT12_HIGH
, LINES.SEGMENT13_HIGH
, LINES.SEGMENT14_HIGH
, LINES.SEGMENT15_HIGH
, LINES.SEGMENT16_HIGH
, LINES.SEGMENT17_HIGH
, LINES.SEGMENT18_HIGH
, LINES.SEGMENT19_HIGH
, LINES.SEGMENT20_HIGH
, LINES.SEGMENT21_HIGH
, LINES.SEGMENT22_HIGH
, LINES.SEGMENT23_HIGH
, LINES.SEGMENT24_HIGH
, LINES.SEGMENT25_HIGH
, LINES.SEGMENT26_HIGH
, LINES.SEGMENT27_HIGH
, LINES.SEGMENT28_HIGH
, LINES.SEGMENT29_HIGH
, LINES.SEGMENT30_HIGH
, LINES.CONTEXT
, LINES.ATTRIBUTE1
, LINES.ATTRIBUTE2
, LINES.ATTRIBUTE3
, LINES.ATTRIBUTE4
, LINES.ATTRIBUTE5
, LINES.ATTRIBUTE6
, LINES.ATTRIBUTE7
, LINES.ATTRIBUTE8
, LINES.ATTRIBUTE9
, LINES.ATTRIBUTE10
, LINES.LAST_UPDATE_DATE
, LINES.LAST_UPDATED_BY
, LINES.LAST_UPDATE_LOGIN
, LINES.CREATED_BY
, LINES.CREATION_DATE
, ATTRIBS.NAME
, ATTRIBS.VALUE_TABLE_FLAG
, NULL
FROM PSB_ACCOUNT_POSITION_SET_LINES LINES
, PSB_ACCOUNT_POSITION_SETS SETS
, PSB_ATTRIBUTES ATTRIBS
WHERE SETS.ACCOUNT_POSITION_SET_ID = LINES.ACCOUNT_POSITION_SET_ID
AND SETS.ACCOUNT_OR_POSITION_TYPE = 'P'
AND LINES.ATTRIBUTE_ID = ATTRIBS.ATTRIBUTE_ID

Columns

Name
ROW_ID
LINE_SEQUENCE_ID
ACCOUNT_POSITION_SET_ID
DESCRIPTION
BUSINESS_GROUP_ID
ATTRIBUTE_ID
INCLUDE_OR_EXCLUDE_TYPE
SEGMENT1_LOW
SEGMENT2_LOW
SEGMENT3_LOW
SEGMENT4_LOW
SEGMENT5_LOW
SEGMENT6_LOW
SEGMENT7_LOW
SEGMENT8_LOW
SEGMENT9_LOW
SEGMENT10_LOW
SEGMENT11_LOW
SEGMENT12_LOW
SEGMENT13_LOW
SEGMENT14_LOW
SEGMENT15_LOW
SEGMENT16_LOW
SEGMENT17_LOW
SEGMENT18_LOW
SEGMENT19_LOW
SEGMENT20_LOW
SEGMENT21_LOW
SEGMENT22_LOW
SEGMENT23_LOW
SEGMENT24_LOW
SEGMENT25_LOW
SEGMENT26_LOW
SEGMENT27_LOW
SEGMENT28_LOW
SEGMENT29_LOW
SEGMENT30_LOW
SEGMENT1_HIGH
SEGMENT2_HIGH
SEGMENT3_HIGH
SEGMENT4_HIGH
SEGMENT5_HIGH
SEGMENT6_HIGH
SEGMENT7_HIGH
SEGMENT8_HIGH
SEGMENT9_HIGH
SEGMENT10_HIGH
SEGMENT11_HIGH
SEGMENT12_HIGH
SEGMENT13_HIGH
SEGMENT14_HIGH
SEGMENT15_HIGH
SEGMENT16_HIGH
SEGMENT17_HIGH
SEGMENT18_HIGH
SEGMENT19_HIGH
SEGMENT20_HIGH
SEGMENT21_HIGH
SEGMENT22_HIGH
SEGMENT23_HIGH
SEGMENT24_HIGH
SEGMENT25_HIGH
SEGMENT26_HIGH
SEGMENT27_HIGH
SEGMENT28_HIGH
SEGMENT29_HIGH
SEGMENT30_HIGH
CONTEXT
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE
ATTRIBUTE_NAME
ATTRIBUTE_VALUE_TABLE_FLAG
INCLUDE_OR_EXCLUDE_MEANING