VIEW: APPS.GHG_ORG_ACCOUNT_MAPPINGS_V

Source

View Text - Preformatted

SELECT xnfam.rowid row_id, xnfam.ACCOUNT_MAPPING_ID, xnfam.GHG_ORGANIZATION_ID, xnfam.segment1_low, xnfam.segment1_high, xnfam.segment2_low, xnfam.segment2_high, xnfam.segment3_low, xnfam.segment3_high, xnfam.segment4_low, xnfam.segment4_high, xnfam.segment5_low, xnfam.segment5_high, xnfam.segment6_low, xnfam.segment6_high, xnfam.segment7_low, xnfam.segment7_high, xnfam.segment8_low, xnfam.segment8_high, xnfam.segment9_low, xnfam.segment9_high, xnfam.segment10_low, xnfam.segment10_high, xnfam.segment11_low, xnfam.segment11_high, xnfam.segment12_low, xnfam.segment12_high, xnfam.segment13_low, xnfam.segment13_high, xnfam.segment14_low, xnfam.segment14_high, xnfam.segment15_low, xnfam.segment15_high, xnfam.segment16_low, xnfam.segment16_high, xnfam.segment17_low, xnfam.segment17_high, xnfam.segment18_low, xnfam.segment18_high, xnfam.segment19_low, xnfam.segment19_high, xnfam.segment20_low, xnfam.segment20_high, xnfam.segment21_low, xnfam.segment21_high, xnfam.segment22_low, xnfam.segment22_high, xnfam.segment23_low, xnfam.segment23_high, xnfam.segment24_low, xnfam.segment24_high, xnfam.segment25_low, xnfam.segment25_high, xnfam.segment26_low, xnfam.segment26_high, xnfam.segment27_low, xnfam.segment27_high, xnfam.segment28_low, xnfam.segment28_high, xnfam.segment29_low, xnfam.segment29_high, xnfam.segment30_low, xnfam.segment30_high, xnfam.chart_of_accounts_id, xnfam.org_id, xnfam.set_of_books_id, xnfam.start_date, xnfam.end_date, xnfam.created_by, xnfam.creation_date, xnfam.last_updated_by, xnfam.last_update_date, xnfam.last_update_login FROM GHG_ORG_ACCOUNT_MAPPINGS xnfam WHERE EXISTS (SELECT 1 FROM GHG_ORGANIZATIONS_V v WHERE v.GHG_ORGANIZATION_ID = xnfam.GHG_ORGANIZATION_ID AND v.allow_transactions = 'Y' )

View Text - HTML Formatted

SELECT XNFAM.ROWID ROW_ID
, XNFAM.ACCOUNT_MAPPING_ID
, XNFAM.GHG_ORGANIZATION_ID
, XNFAM.SEGMENT1_LOW
, XNFAM.SEGMENT1_HIGH
, XNFAM.SEGMENT2_LOW
, XNFAM.SEGMENT2_HIGH
, XNFAM.SEGMENT3_LOW
, XNFAM.SEGMENT3_HIGH
, XNFAM.SEGMENT4_LOW
, XNFAM.SEGMENT4_HIGH
, XNFAM.SEGMENT5_LOW
, XNFAM.SEGMENT5_HIGH
, XNFAM.SEGMENT6_LOW
, XNFAM.SEGMENT6_HIGH
, XNFAM.SEGMENT7_LOW
, XNFAM.SEGMENT7_HIGH
, XNFAM.SEGMENT8_LOW
, XNFAM.SEGMENT8_HIGH
, XNFAM.SEGMENT9_LOW
, XNFAM.SEGMENT9_HIGH
, XNFAM.SEGMENT10_LOW
, XNFAM.SEGMENT10_HIGH
, XNFAM.SEGMENT11_LOW
, XNFAM.SEGMENT11_HIGH
, XNFAM.SEGMENT12_LOW
, XNFAM.SEGMENT12_HIGH
, XNFAM.SEGMENT13_LOW
, XNFAM.SEGMENT13_HIGH
, XNFAM.SEGMENT14_LOW
, XNFAM.SEGMENT14_HIGH
, XNFAM.SEGMENT15_LOW
, XNFAM.SEGMENT15_HIGH
, XNFAM.SEGMENT16_LOW
, XNFAM.SEGMENT16_HIGH
, XNFAM.SEGMENT17_LOW
, XNFAM.SEGMENT17_HIGH
, XNFAM.SEGMENT18_LOW
, XNFAM.SEGMENT18_HIGH
, XNFAM.SEGMENT19_LOW
, XNFAM.SEGMENT19_HIGH
, XNFAM.SEGMENT20_LOW
, XNFAM.SEGMENT20_HIGH
, XNFAM.SEGMENT21_LOW
, XNFAM.SEGMENT21_HIGH
, XNFAM.SEGMENT22_LOW
, XNFAM.SEGMENT22_HIGH
, XNFAM.SEGMENT23_LOW
, XNFAM.SEGMENT23_HIGH
, XNFAM.SEGMENT24_LOW
, XNFAM.SEGMENT24_HIGH
, XNFAM.SEGMENT25_LOW
, XNFAM.SEGMENT25_HIGH
, XNFAM.SEGMENT26_LOW
, XNFAM.SEGMENT26_HIGH
, XNFAM.SEGMENT27_LOW
, XNFAM.SEGMENT27_HIGH
, XNFAM.SEGMENT28_LOW
, XNFAM.SEGMENT28_HIGH
, XNFAM.SEGMENT29_LOW
, XNFAM.SEGMENT29_HIGH
, XNFAM.SEGMENT30_LOW
, XNFAM.SEGMENT30_HIGH
, XNFAM.CHART_OF_ACCOUNTS_ID
, XNFAM.ORG_ID
, XNFAM.SET_OF_BOOKS_ID
, XNFAM.START_DATE
, XNFAM.END_DATE
, XNFAM.CREATED_BY
, XNFAM.CREATION_DATE
, XNFAM.LAST_UPDATED_BY
, XNFAM.LAST_UPDATE_DATE
, XNFAM.LAST_UPDATE_LOGIN
FROM GHG_ORG_ACCOUNT_MAPPINGS XNFAM
WHERE EXISTS (SELECT 1
FROM GHG_ORGANIZATIONS_V V
WHERE V.GHG_ORGANIZATION_ID = XNFAM.GHG_ORGANIZATION_ID
AND V.ALLOW_TRANSACTIONS = 'Y' )