Product: | PSB - Public Sector Budgeting |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PSB_SET_RELATIONS_V |
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