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.PSA_BC_ALLOC_V

Object Details

Object Name:	PSA_BC_ALLOC_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

This view stores the source distribution and allocation information. This information is used to link related transactions together

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Row identifier
LEDGER_ID	NUMBER	(15)		Accounting books defining column
EVENT_ID	NUMBER	(15)		Business event identifier
ENTITY_ID	NUMBER	(15)		Entity identifier
AE_HEADER_ID	NUMBER	(15)	Yes	XLA journal entry header defining column
AE_LINE_NUM	NUMBER	(15)		XLA journal entry line defining column
ENTITY_CODE	VARCHAR2	(30)	Yes	Entity code
SOURCE_ID_INT_1	NUMBER	(15)		Source identifier (number)
SOURCE_ID_INT_2	NUMBER	(15)		Source identifier (number)
SOURCE_ID_INT_3	NUMBER	(15)		Source identifier (number)
SOURCE_ID_INT_4	NUMBER	(15)		Source identifier (number)
SOURCE_ID_CHAR_1	VARCHAR2	(30)		Source identifier (char)
SOURCE_ID_CHAR_2	VARCHAR2	(30)		Source identifier (char)
SOURCE_ID_CHAR_3	VARCHAR2	(30)		Source identifier (char)
SOURCE_ID_CHAR_4	VARCHAR2	(30)		Source identifier (char)
APPLICATION_ID	NUMBER	(15)	Yes	Application identifier
SOURCE_DISTRIBUTION_ID_NUM_1	NUMBER			Source distribution identifier (number)
SOURCE_DISTRIBUTION_ID_NUM_2	NUMBER			Source distribution identifier (number)
SOURCE_DISTRIBUTION_ID_NUM_3	NUMBER			Source distribution identifier (number)
SOURCE_DISTRIBUTION_ID_NUM_4	NUMBER			Source distribution identifier (number)
SOURCE_DISTRIBUTION_ID_NUM_5	NUMBER			Source distribution identifier (number)
SOURCE_DISTRIBUTION_ID_CHAR_1	VARCHAR2	(240)		Source distribution identifier (char)
SOURCE_DISTRIBUTION_ID_CHAR_2	VARCHAR2	(240)		Source distribution identifier (char)
SOURCE_DISTRIBUTION_ID_CHAR_3	VARCHAR2	(240)		Source distribution identifier (char)
SOURCE_DISTRIBUTION_ID_CHAR_4	VARCHAR2	(240)		Source distribution identifier (char)
SOURCE_DISTRIBUTION_ID_CHAR_5	VARCHAR2	(240)		Source distribution identifier (char)
SOURCE_DISTRIBUTION_TYPE	VARCHAR2	(30)		Source distribution type
ALLOC_TO_ENTITY_CODE	VARCHAR2	(30)		Allocation to entity code
ALLOC_TO_SOURCE_ID_NUM_1	NUMBER	(15)		Allocation to source identifier (number)
ALLOC_TO_SOURCE_ID_NUM_2	NUMBER	(15)		Allocation to source identifier (number)
ALLOC_TO_SOURCE_ID_NUM_3	NUMBER	(15)		Allocation to source identifier (number)
ALLOC_TO_SOURCE_ID_NUM_4	NUMBER	(15)		Allocation to source identifier (number)
ALLOC_TO_SOURCE_ID_CHAR_1	VARCHAR2	(30)		Allocation to source identifier (char)
ALLOC_TO_SOURCE_ID_CHAR_2	VARCHAR2	(30)		Allocation to source identifier (char)
ALLOC_TO_SOURCE_ID_CHAR_3	VARCHAR2	(30)		Allocation to source identifier (char)
ALLOC_TO_SOURCE_ID_CHAR_4	VARCHAR2	(30)		Allocation to source identifier (char)
ALLOC_TO_APPLICATION_ID	NUMBER	(15)		Allocation to application identifier
ALLOC_TO_DISTRIBUTION_TYPE	VARCHAR2	(30)		Allocation to distribution type
ALLOC_TO_DIST_ID_NUM_1	NUMBER	(15)		Allocation to distribution identifier (number)
ALLOC_TO_DIST_ID_NUM_2	NUMBER	(15)		Allocation to distribution identifier (number)
ALLOC_TO_DIST_ID_NUM_3	NUMBER	(15)		Allocation to distribution identifier (number)
ALLOC_TO_DIST_ID_NUM_4	NUMBER	(15)		Allocation to distribution identifier (number)
ALLOC_TO_DIST_ID_NUM_5	NUMBER	(15)		Allocation to distribution identifier (number)
ALLOC_TO_DIST_ID_CHAR_1	VARCHAR2	(30)		Allocation to distribution identifier (char)
ALLOC_TO_DIST_ID_CHAR_2	VARCHAR2	(30)		Allocation to distribution identifier (char)
ALLOC_TO_DIST_ID_CHAR_3	VARCHAR2	(30)		Allocation to distribution identifier (char)
ALLOC_TO_DIST_ID_CHAR_4	VARCHAR2	(30)		Allocation to distribution identifier (char)
ALLOC_TO_DIST_ID_CHAR_5	VARCHAR2	(30)		Allocation to distribution identifier (char)

Query Text

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


SELECT ROW_ID
,      LEDGER_ID
,      EVENT_ID
,      ENTITY_ID
,      AE_HEADER_ID
,      AE_LINE_NUM
,      ENTITY_CODE
,      SOURCE_ID_INT_1
,      SOURCE_ID_INT_2
,      SOURCE_ID_INT_3
,      SOURCE_ID_INT_4
,      SOURCE_ID_CHAR_1
,      SOURCE_ID_CHAR_2
,      SOURCE_ID_CHAR_3
,      SOURCE_ID_CHAR_4
,      APPLICATION_ID
,      SOURCE_DISTRIBUTION_ID_NUM_1
,      SOURCE_DISTRIBUTION_ID_NUM_2
,      SOURCE_DISTRIBUTION_ID_NUM_3
,      SOURCE_DISTRIBUTION_ID_NUM_4
,      SOURCE_DISTRIBUTION_ID_NUM_5
,      SOURCE_DISTRIBUTION_ID_CHAR_1
,      SOURCE_DISTRIBUTION_ID_CHAR_2
,      SOURCE_DISTRIBUTION_ID_CHAR_3
,      SOURCE_DISTRIBUTION_ID_CHAR_4
,      SOURCE_DISTRIBUTION_ID_CHAR_5
,      SOURCE_DISTRIBUTION_TYPE
,      ALLOC_TO_ENTITY_CODE
,      ALLOC_TO_SOURCE_ID_NUM_1
,      ALLOC_TO_SOURCE_ID_NUM_2
,      ALLOC_TO_SOURCE_ID_NUM_3
,      ALLOC_TO_SOURCE_ID_NUM_4
,      ALLOC_TO_SOURCE_ID_CHAR_1
,      ALLOC_TO_SOURCE_ID_CHAR_2
,      ALLOC_TO_SOURCE_ID_CHAR_3
,      ALLOC_TO_SOURCE_ID_CHAR_4
,      ALLOC_TO_APPLICATION_ID
,      ALLOC_TO_DISTRIBUTION_TYPE
,      ALLOC_TO_DIST_ID_NUM_1
,      ALLOC_TO_DIST_ID_NUM_2
,      ALLOC_TO_DIST_ID_NUM_3
,      ALLOC_TO_DIST_ID_NUM_4
,      ALLOC_TO_DIST_ID_NUM_5
,      ALLOC_TO_DIST_ID_CHAR_1
,      ALLOC_TO_DIST_ID_CHAR_2
,      ALLOC_TO_DIST_ID_CHAR_3
,      ALLOC_TO_DIST_ID_CHAR_4
,      ALLOC_TO_DIST_ID_CHAR_5
FROM APPS.PSA_BC_ALLOC_V;

Dependencies

[top of page]

APPS.PSA_BC_ALLOC_V references the following:

APPS: XLA_AE_LINES_GT; XLA_EVENTS_GT

APPS.PSA_BC_ALLOC_V is referenced by following:

APPS: PSA_FUNDS_CHECKER_PKG - show dependent code