VIEW: APPS.GL_SUMMARY_TEMPLATES_V

Source

View Text - Preformatted

SELECT st.ROWID row_id, st.template_name template_name, lgr.NAME ledger_name, st.start_actuals_period_name start_actuals_period_name, st.description description, st.account_category_code account_category_code, st.template_id template_id, st.ledger_id ledger_id, st.status status, st.last_update_date last_update_date, st.last_updated_by last_updated_by, st.concatenated_description concatenated_description, st.max_code_combination_id max_code_combination_id, st.created_by created_by, st.creation_date creation_date, st.last_update_login last_update_login, st.segment1_type segment1_type, st.segment2_type segment2_type, st.segment3_type segment3_type, st.segment4_type segment4_type, st.segment5_type segment5_type, st.segment6_type segment6_type, st.segment7_type segment7_type, st.segment8_type segment8_type, st.segment9_type segment9_type, st.segment10_type segment10_type, st.segment11_type segment11_type, st.segment12_type segment12_type, st.segment13_type segment13_type, st.segment14_type segment14_type, st.segment15_type segment15_type, st.segment16_type segment16_type, st.segment17_type segment17_type, st.segment18_type segment18_type, st.segment19_type segment19_type, st.segment20_type segment20_type, st.segment21_type segment21_type, st.segment22_type segment22_type, st.segment23_type segment23_type, st.segment24_type segment24_type, st.segment25_type segment25_type, st.segment26_type segment26_type, st.segment27_type segment27_type, st.segment28_type segment28_type, st.segment29_type segment29_type, st.segment30_type segment30_type, st.attribute1 attribute1, st.attribute2 attribute2, st.attribute3 attribute3, st.attribute4 attribute4, st.attribute5 attribute5, st.attribute6 attribute6, st.attribute7 attribute7, st.attribute8 attribute8, st.CONTEXT CONTEXT FROM gl_summary_templates st, gl_ledgers lgr WHERE st.ledger_id = lgr.ledger_id

View Text - HTML Formatted

SELECT ST.ROWID ROW_ID
, ST.TEMPLATE_NAME TEMPLATE_NAME
, LGR.NAME LEDGER_NAME
, ST.START_ACTUALS_PERIOD_NAME START_ACTUALS_PERIOD_NAME
, ST.DESCRIPTION DESCRIPTION
, ST.ACCOUNT_CATEGORY_CODE ACCOUNT_CATEGORY_CODE
, ST.TEMPLATE_ID TEMPLATE_ID
, ST.LEDGER_ID LEDGER_ID
, ST.STATUS STATUS
, ST.LAST_UPDATE_DATE LAST_UPDATE_DATE
, ST.LAST_UPDATED_BY LAST_UPDATED_BY
, ST.CONCATENATED_DESCRIPTION CONCATENATED_DESCRIPTION
, ST.MAX_CODE_COMBINATION_ID MAX_CODE_COMBINATION_ID
, ST.CREATED_BY CREATED_BY
, ST.CREATION_DATE CREATION_DATE
, ST.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, ST.SEGMENT1_TYPE SEGMENT1_TYPE
, ST.SEGMENT2_TYPE SEGMENT2_TYPE
, ST.SEGMENT3_TYPE SEGMENT3_TYPE
, ST.SEGMENT4_TYPE SEGMENT4_TYPE
, ST.SEGMENT5_TYPE SEGMENT5_TYPE
, ST.SEGMENT6_TYPE SEGMENT6_TYPE
, ST.SEGMENT7_TYPE SEGMENT7_TYPE
, ST.SEGMENT8_TYPE SEGMENT8_TYPE
, ST.SEGMENT9_TYPE SEGMENT9_TYPE
, ST.SEGMENT10_TYPE SEGMENT10_TYPE
, ST.SEGMENT11_TYPE SEGMENT11_TYPE
, ST.SEGMENT12_TYPE SEGMENT12_TYPE
, ST.SEGMENT13_TYPE SEGMENT13_TYPE
, ST.SEGMENT14_TYPE SEGMENT14_TYPE
, ST.SEGMENT15_TYPE SEGMENT15_TYPE
, ST.SEGMENT16_TYPE SEGMENT16_TYPE
, ST.SEGMENT17_TYPE SEGMENT17_TYPE
, ST.SEGMENT18_TYPE SEGMENT18_TYPE
, ST.SEGMENT19_TYPE SEGMENT19_TYPE
, ST.SEGMENT20_TYPE SEGMENT20_TYPE
, ST.SEGMENT21_TYPE SEGMENT21_TYPE
, ST.SEGMENT22_TYPE SEGMENT22_TYPE
, ST.SEGMENT23_TYPE SEGMENT23_TYPE
, ST.SEGMENT24_TYPE SEGMENT24_TYPE
, ST.SEGMENT25_TYPE SEGMENT25_TYPE
, ST.SEGMENT26_TYPE SEGMENT26_TYPE
, ST.SEGMENT27_TYPE SEGMENT27_TYPE
, ST.SEGMENT28_TYPE SEGMENT28_TYPE
, ST.SEGMENT29_TYPE SEGMENT29_TYPE
, ST.SEGMENT30_TYPE SEGMENT30_TYPE
, ST.ATTRIBUTE1 ATTRIBUTE1
, ST.ATTRIBUTE2 ATTRIBUTE2
, ST.ATTRIBUTE3 ATTRIBUTE3
, ST.ATTRIBUTE4 ATTRIBUTE4
, ST.ATTRIBUTE5 ATTRIBUTE5
, ST.ATTRIBUTE6 ATTRIBUTE6
, ST.ATTRIBUTE7 ATTRIBUTE7
, ST.ATTRIBUTE8 ATTRIBUTE8
, ST.CONTEXT CONTEXT
FROM GL_SUMMARY_TEMPLATES ST
, GL_LEDGERS LGR
WHERE ST.LEDGER_ID = LGR.LEDGER_ID