VIEW: APPS.PSB_SET_RELATIONS_V

Source

View Text - Preformatted

SELECT relations.ROWID, relations.SET_RELATION_ID, relations.ACCOUNT_POSITION_SET_ID, relations.ALLOCATION_RULE_ID, relations.BUDGET_GROUP_ID, relations.BUDGET_WORKFLOW_RULE_ID, relations.CONSTRAINT_ID, relations.DEFAULT_RULE_ID, relations.PARAMETER_ID, relations.POSITION_SET_GROUP_ID, relations.GL_BUDGET_ID, relations.EFFECTIVE_START_DATE, relations.EFFECTIVE_END_DATE, relations.LAST_UPDATE_DATE, relations.LAST_UPDATED_BY, relations.LAST_UPDATE_LOGIN, relations.CREATED_BY, relations.CREATION_DATE, sets.ROWID, 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.use_in_budget_group_flag, relations.rule_id, relations.apply_balance_flag FROM psb_set_relations relations, psb_account_position_sets sets WHERE relations.account_position_set_id = sets.account_position_set_id

View Text - HTML Formatted

SELECT RELATIONS.ROWID
, RELATIONS.SET_RELATION_ID
, RELATIONS.ACCOUNT_POSITION_SET_ID
, RELATIONS.ALLOCATION_RULE_ID
, RELATIONS.BUDGET_GROUP_ID
, RELATIONS.BUDGET_WORKFLOW_RULE_ID
, RELATIONS.CONSTRAINT_ID
, RELATIONS.DEFAULT_RULE_ID
, RELATIONS.PARAMETER_ID
, RELATIONS.POSITION_SET_GROUP_ID
, RELATIONS.GL_BUDGET_ID
, RELATIONS.EFFECTIVE_START_DATE
, RELATIONS.EFFECTIVE_END_DATE
, RELATIONS.LAST_UPDATE_DATE
, RELATIONS.LAST_UPDATED_BY
, RELATIONS.LAST_UPDATE_LOGIN
, RELATIONS.CREATED_BY
, RELATIONS.CREATION_DATE
, SETS.ROWID
, 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.USE_IN_BUDGET_GROUP_FLAG
, RELATIONS.RULE_ID
, RELATIONS.APPLY_BALANCE_FLAG
FROM PSB_SET_RELATIONS RELATIONS
, PSB_ACCOUNT_POSITION_SETS SETS
WHERE RELATIONS.ACCOUNT_POSITION_SET_ID = SETS.ACCOUNT_POSITION_SET_ID