VIEW: APPS.PSB_ACCT_POSITION_SET_LINES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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