VIEW: APPS.PSB_ACCOUNT_POSITION_SETS_V

Source

View Text - Preformatted

SELECT SETS.ROWID, SETS.ACCOUNT_POSITION_SET_ID, SETS.NAME, SETS.SET_OF_BOOKS_ID, SETS.DATA_EXTRACT_ID, SETS.GLOBAL_OR_LOCAL_TYPE, SETS.ACCOUNT_OR_POSITION_TYPE, SETS.ATTRIBUTE_SELECTION_TYPE, SETS.BUSINESS_GROUP_ID, SETS.BUDGET_GROUP_ID, SETS.MAINTAIN_STATUS, SETS.LAST_MAINTAINED_DATE, SETS.MAX_CODE_COMBINATION_ID, SETS.USE_IN_BUDGET_GROUP_FLAG, SETS.LAST_UPDATE_DATE, SETS.LAST_UPDATED_BY, SETS.LAST_UPDATE_LOGIN, SETS.CREATED_BY, SETS.CREATION_DATE, SOBS.name, EXTRACTS.data_extract_name, BG.SHORT_NAME, FL.meaning FROM psb_account_position_sets sets, gl_sets_of_books sobs, psb_data_extracts extracts, psb_budget_groups BG, fnd_lookups fl WHERE sets.set_of_books_id = sobs.set_of_books_id(+) AND sets.data_extract_id = extracts.data_extract_id(+) AND sets.budget_group_id = bg.budget_group_id (+) AND fl.lookup_type = 'PSB_ACCOUNT_OR_POSITION_TYPE' AND fl.lookup_code = sets.account_or_position_type

View Text - HTML Formatted

SELECT SETS.ROWID
, SETS.ACCOUNT_POSITION_SET_ID
, SETS.NAME
, SETS.SET_OF_BOOKS_ID
, SETS.DATA_EXTRACT_ID
, SETS.GLOBAL_OR_LOCAL_TYPE
, SETS.ACCOUNT_OR_POSITION_TYPE
, SETS.ATTRIBUTE_SELECTION_TYPE
, SETS.BUSINESS_GROUP_ID
, SETS.BUDGET_GROUP_ID
, SETS.MAINTAIN_STATUS
, SETS.LAST_MAINTAINED_DATE
, SETS.MAX_CODE_COMBINATION_ID
, SETS.USE_IN_BUDGET_GROUP_FLAG
, SETS.LAST_UPDATE_DATE
, SETS.LAST_UPDATED_BY
, SETS.LAST_UPDATE_LOGIN
, SETS.CREATED_BY
, SETS.CREATION_DATE
, SOBS.NAME
, EXTRACTS.DATA_EXTRACT_NAME
, BG.SHORT_NAME
, FL.MEANING
FROM PSB_ACCOUNT_POSITION_SETS SETS
, GL_SETS_OF_BOOKS SOBS
, PSB_DATA_EXTRACTS EXTRACTS
, PSB_BUDGET_GROUPS BG
, FND_LOOKUPS FL
WHERE SETS.SET_OF_BOOKS_ID = SOBS.SET_OF_BOOKS_ID(+)
AND SETS.DATA_EXTRACT_ID = EXTRACTS.DATA_EXTRACT_ID(+)
AND SETS.BUDGET_GROUP_ID = BG.BUDGET_GROUP_ID (+)
AND FL.LOOKUP_TYPE = 'PSB_ACCOUNT_OR_POSITION_TYPE'
AND FL.LOOKUP_CODE = SETS.ACCOUNT_OR_POSITION_TYPE