eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.PSB_ACCOUNT_POSITION_SETS_V

Object Details

Object Name:	PSB_ACCOUNT_POSITION_SETS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PSB.PSB_ACCOUNT_POSITION_SETS_V
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)
ACCOUNT_POSITION_SET_ID	NUMBER	(15)	Yes
NAME	VARCHAR2	(100)	Yes
SET_OF_BOOKS_ID	NUMBER	(15)
DATA_EXTRACT_ID	NUMBER	(15)
GLOBAL_OR_LOCAL_TYPE	VARCHAR2	(1)
ACCOUNT_OR_POSITION_TYPE	VARCHAR2	(1)	Yes
ATTRIBUTE_SELECTION_TYPE	VARCHAR2	(1)
BUSINESS_GROUP_ID	NUMBER	(15)
BUDGET_GROUP_ID	NUMBER	(20)		Budget Group to which account or position set belongs.Gets populated only for those account or position sets created for budget revision.
MAINTAIN_STATUS	VARCHAR2	(1)
LAST_MAINTAINED_DATE	DATE
MAX_CODE_COMBINATION_ID	NUMBER	(15)
USE_IN_BUDGET_GROUP_FLAG	VARCHAR2	(1)
LAST_UPDATE_DATE	DATE
LAST_UPDATED_BY	NUMBER	(15)
LAST_UPDATE_LOGIN	NUMBER	(15)
CREATED_BY	NUMBER	(15)
CREATION_DATE	DATE
SET_OF_BOOKS_NAME	VARCHAR2	(30)
DATA_EXTRACT_NAME	VARCHAR2	(30)
BUDGET_GROUP_SHORT_NAME	VARCHAR2	(20)		Budget Group Short Name , to which the revision account orposition sets belong to.
ACCOUNT_OR_POSITION_MEANING	VARCHAR2	(80)	Yes

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ROW_ID
,      ACCOUNT_POSITION_SET_ID
,      NAME
,      SET_OF_BOOKS_ID
,      DATA_EXTRACT_ID
,      GLOBAL_OR_LOCAL_TYPE
,      ACCOUNT_OR_POSITION_TYPE
,      ATTRIBUTE_SELECTION_TYPE
,      BUSINESS_GROUP_ID
,      BUDGET_GROUP_ID
,      MAINTAIN_STATUS
,      LAST_MAINTAINED_DATE
,      MAX_CODE_COMBINATION_ID
,      USE_IN_BUDGET_GROUP_FLAG
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      SET_OF_BOOKS_NAME
,      DATA_EXTRACT_NAME
,      BUDGET_GROUP_SHORT_NAME
,      ACCOUNT_OR_POSITION_MEANING
FROM APPS.PSB_ACCOUNT_POSITION_SETS_V;

Dependencies

[top of page]

APPS.PSB_ACCOUNT_POSITION_SETS_V references the following:

APPS: FND_GLOBAL - show dependent code; FND_LOOKUPS; GL_SETS_OF_BOOKS; PSB_ACCOUNT_POSITION_SETS; PSB_BUDGET_GROUPS; PSB_DATA_EXTRACTS

APPS.PSB_ACCOUNT_POSITION_SETS_V is not referenced by any database object