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_REPORT_V

Object Details

Object Name:	PSA_BC_REPORT_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 is used by the Budgetary Control Results report and works as a source of budgetary control data for the report. This view is later joined to other transaction tables to form the report output.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Row identifier
APPLICATION_ID	NUMBER	(15)		Application identifier
APPLICATION_SHORT_NAME	VARCHAR2	(50)	Yes	Application short name
APPLICATION_NAME	VARCHAR2	(240)	Yes	Application name
LEDGER_ID	NUMBER	(15)		Accounting books defining column
EVENT_ID	NUMBER	(15)		Event identifier
SOURCE_DISTRIBUTION_TYPE	VARCHAR2	(30)		Source distribution type
SOURCE_DISTRIBUTION_ID_NUM_1	NUMBER	(38)		Source distribution identifier (number)
SOURCE_DISTRIBUTION_ID_NUM_2	NUMBER	(38)		Source distribution identifier (number)
SOURCE_DISTRIBUTION_ID_NUM_3	NUMBER	(38)		Source distribution identifier (number)
SOURCE_DISTRIBUTION_ID_NUM_4	NUMBER	(38)		Source distribution identifier (number)
SOURCE_DISTRIBUTION_ID_NUM_5	NUMBER	(38)		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)
PACKET_ID	NUMBER	(15)		Budgetary control packet defining column
JE_SOURCE_NAME	VARCHAR2	(25)		Journal entry source name
JE_CATEGORY_NAME	VARCHAR2	(25)		Journal entry category name
CODE_COMBINATION_ID	NUMBER	(15)		Code combination identifier
ACTUAL_FLAG	VARCHAR2	(1)		Actual flag
PERIOD_NAME	VARCHAR2	(15)		Period name
CURRENCY_CODE	VARCHAR2	(15)		Currency code
STATUS_CODE	VARCHAR2	(1)		Status code
BUDGET_TYPE	VARCHAR2	(15)		Budget type
BUDGET_VERSION_ID	NUMBER	(15)		Budget version identifier
ENCUMBRANCE_TYPE_ID	NUMBER	(15)		Encumbrance type identifier
TEMPLATE_ID	NUMBER	(15)		Template identifier
ENTERED_DR	NUMBER			Journal entry line debit amount in entered currency
ENTERED_CR	NUMBER			Journal entry line credit amount in entered currency
ACCOUNTED_DR	VARCHAR2	(40)		Journal entry line debit amount in base currency
ACCOUNTED_CR	VARCHAR2	(40)		Journal entry line credit amount in base currency
USSGL_TRANSACTION_CODE	VARCHAR2	(30)		Government USSGL Transaction code
ACCOUNT_SEGMENT_VALUE	VARCHAR2	(25)		Account segment value
AUTOMATIC_ENCUMBRANCE_FLAG	VARCHAR2	(1)		Automatic encumbrance flag
FUNDING_BUDGET_VERSION_ID	NUMBER	(15)		Funding budget version identifier
FUNDS_CHECK_LEVEL_CODE	VARCHAR2	(1)		Funds check level code
AMOUNT_TYPE	VARCHAR2	(4)		Amount type
BOUNDARY_CODE	VARCHAR2	(1)		Boundary code
TOLERANCE_PERCENTAGE	NUMBER			Percentage of funding budget that can be exceeded
TOLERANCE_AMOUNT	NUMBER			Amount of funding budget that can be exceeded
OVERRIDE_AMOUNT	NUMBER			Maximum transaction amount that can be used to override a funds check failure
DR_CR_CODE	VARCHAR2	(1)		Debit or credit transaction
ACCOUNT_TYPE	VARCHAR2	(1)		Key flexfield combination type (Asset, liability, ..., Budgetary Dr/Cr)
ACCOUNT_CATEGORY_CODE	VARCHAR2	(1)		Key flexfield category (Proprietary or budgetary)
EFFECT_ON_FUNDS_CODE	VARCHAR2	(1)		Effect of transaction on funds available, increasing or decreasing
RESULT_CODE	VARCHAR2	(3)		Result of funds check/reservation
BUDGET_POSTED_BALANCE	VARCHAR2	(40)		Posted balance used in funds available calculation
ACTUAL_POSTED_BALANCE	VARCHAR2	(40)		Posted balance used in funds available calculation
COMM_ENC_POSTED_BAL	NUMBER			Posted balance used in funds available calculation
OBLI_ENC_POSTED_BAL	NUMBER			Posted balance used in funds available calculation
ENC_POSTED_BALANCE	VARCHAR2	(40)		Posted balance used in funds available calculation
BUDGET_APPROVED_BALANCE	VARCHAR2	(40)		Balance approved, but not posted
ACTUAL_APPROVED_BALANCE	VARCHAR2	(40)		Balance approved, but not posted
COMM_ENC_APPROVED_BAL	NUMBER			Balance approved, but not posted
OBLI_ENC_APPROVED_BAL	NUMBER			Balance approved, but not posted
ENC_APPROVED_BALANCE	VARCHAR2	(40)		Balance approved, but not posted
BUDGET_PENDING_BALANCE	VARCHAR2	(40)		Balance pending funds check
ACTUAL_PENDING_BALANCE	VARCHAR2	(40)		Balance pending funds check
COMM_ENC_PENDING_BAL	NUMBER			Balance pending funds check
OBLI_ENC_PENDING_BAL	NUMBER			Balance pending funds check
ENC_PENDING_BALANCE	VARCHAR2	(40)		Balance pending funds check
BUDGET_TOTAL_BALANCE	VARCHAR2	(40)		Balance pending funds check
COMM_ENC_TOTAL_BAL	NUMBER			Commitment encumbrance total balance
OBLI_ENC_TOTAL_BAL	NUMBER			Obligation encumbrance total balance
ENC_TOTAL_BALANCE	VARCHAR2	(40)		Encumbrance total balance
ACTUAL_TOTAL_BALANCE	VARCHAR2	(40)		Actual total balance
AVAIL_POSTED_BALANCE	VARCHAR2	(40)		Available posted balance
AVAIL_APPROVED_BALANCE	VARCHAR2	(40)		Available approved balance
AVAIL_PENDING_BALANCE	VARCHAR2	(40)		Available pending balance
AVAIL_TOTAL_BALANCE	VARCHAR2	(40)		Available total balance
REFERENCE1	VARCHAR2	(100)		Journal entry line reference
REFERENCE2	VARCHAR2	(100)		Journal entry line reference
REFERENCE3	VARCHAR2	(100)		Journal entry line reference
REFERENCE4	VARCHAR2	(100)		Journal entry line reference
REFERENCE5	VARCHAR2	(100)		Journal entry line reference
REFERENCE13	VARCHAR2	(100)		Journal entry line reference
REFERENCE14	VARCHAR2	(100)		Journal entry line reference
REFERENCE15	VARCHAR2	(100)		Journal entry line reference
JE_BATCH_NAME	VARCHAR2	(100)		Journal entry batch name
JE_BATCH_ID	NUMBER	(15)		Journal entry batch identifier
JE_HEADER_ID	NUMBER	(15)		Journal entry header identifier
JE_LINE_NUM	NUMBER	(15)		Journal entry line number
JE_LINE_DESCRIPTION	VARCHAR2	(240)		Journal entry line description
USER_JE_CATEGORY_NAME	VARCHAR2	(25)	Yes	Journal entry category name
USER_JE_SOURCE_NAME	VARCHAR2	(25)	Yes	Journal entry source name
TRANSACTION_AMOUNT	NUMBER			Transaction amount
CURRENT_FUNDS_AVAILABLE	VARCHAR2	(40)		Current Funds Available
ACTUAL_FLAG_MEANING	VARCHAR2	(0)		Meaning of actual flag
ENCUMBRANCE_TYPE	VARCHAR2	(30)		Encumbrance type
STATUS_CODE_MEANING	VARCHAR2	(0)		Meaning of status code
RESULT_CODE_MEANING	VARCHAR2	(0)		Meaning of result code
FUNDING_BUDGET_NAME	VARCHAR2	(15)		Funding budget name
AMOUNT_TYPE_MEANING	VARCHAR2	(0)		Amount type meaning
BOUNDARY_MEANING	VARCHAR2	(0)		Boundary meaning
TEMPLATE	VARCHAR2	(240)		Sumarry template
LEVEL_MEANING	VARCHAR2	(0)		Budget level meaning
ACCOUNT_TYPE_MEANING	VARCHAR2	(0)		Account type meaning
EFFECT_ON_FUNDS_MEANING	VARCHAR2	(0)		Effect on funds (Decreasing or Increasing)
BATCH_NAME	VARCHAR2	(100)		Batch name
HEADER_NAME	VARCHAR2	(100)		Header name
AE_HEADER_ID	NUMBER	(15)		XLA journal entry header defining column
AE_LINE_NUM	NUMBER	(15)		XLA journal entry line defining column
PERIOD_NUM	NUMBER	(15)		Period number
PERIOD_YEAR	NUMBER	(15)		Period year
QUARTER_NUM	NUMBER	(15)		Period number
EFFECTIVE_STATUS	VARCHAR2	(1)		Effective status

Query Text

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


SELECT ROW_ID
,      APPLICATION_ID
,      APPLICATION_SHORT_NAME
,      APPLICATION_NAME
,      LEDGER_ID
,      EVENT_ID
,      SOURCE_DISTRIBUTION_TYPE
,      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
,      PACKET_ID
,      JE_SOURCE_NAME
,      JE_CATEGORY_NAME
,      CODE_COMBINATION_ID
,      ACTUAL_FLAG
,      PERIOD_NAME
,      CURRENCY_CODE
,      STATUS_CODE
,      BUDGET_TYPE
,      BUDGET_VERSION_ID
,      ENCUMBRANCE_TYPE_ID
,      TEMPLATE_ID
,      ENTERED_DR
,      ENTERED_CR
,      ACCOUNTED_DR
,      ACCOUNTED_CR
,      USSGL_TRANSACTION_CODE
,      ACCOUNT_SEGMENT_VALUE
,      AUTOMATIC_ENCUMBRANCE_FLAG
,      FUNDING_BUDGET_VERSION_ID
,      FUNDS_CHECK_LEVEL_CODE
,      AMOUNT_TYPE
,      BOUNDARY_CODE
,      TOLERANCE_PERCENTAGE
,      TOLERANCE_AMOUNT
,      OVERRIDE_AMOUNT
,      DR_CR_CODE
,      ACCOUNT_TYPE
,      ACCOUNT_CATEGORY_CODE
,      EFFECT_ON_FUNDS_CODE
,      RESULT_CODE
,      BUDGET_POSTED_BALANCE
,      ACTUAL_POSTED_BALANCE
,      COMM_ENC_POSTED_BAL
,      OBLI_ENC_POSTED_BAL
,      ENC_POSTED_BALANCE
,      BUDGET_APPROVED_BALANCE
,      ACTUAL_APPROVED_BALANCE
,      COMM_ENC_APPROVED_BAL
,      OBLI_ENC_APPROVED_BAL
,      ENC_APPROVED_BALANCE
,      BUDGET_PENDING_BALANCE
,      ACTUAL_PENDING_BALANCE
,      COMM_ENC_PENDING_BAL
,      OBLI_ENC_PENDING_BAL
,      ENC_PENDING_BALANCE
,      BUDGET_TOTAL_BALANCE
,      COMM_ENC_TOTAL_BAL
,      OBLI_ENC_TOTAL_BAL
,      ENC_TOTAL_BALANCE
,      ACTUAL_TOTAL_BALANCE
,      AVAIL_POSTED_BALANCE
,      AVAIL_APPROVED_BALANCE
,      AVAIL_PENDING_BALANCE
,      AVAIL_TOTAL_BALANCE
,      REFERENCE1
,      REFERENCE2
,      REFERENCE3
,      REFERENCE4
,      REFERENCE5
,      REFERENCE13
,      REFERENCE14
,      REFERENCE15
,      JE_BATCH_NAME
,      JE_BATCH_ID
,      JE_HEADER_ID
,      JE_LINE_NUM
,      JE_LINE_DESCRIPTION
,      USER_JE_CATEGORY_NAME
,      USER_JE_SOURCE_NAME
,      TRANSACTION_AMOUNT
,      CURRENT_FUNDS_AVAILABLE
,      ACTUAL_FLAG_MEANING
,      ENCUMBRANCE_TYPE
,      STATUS_CODE_MEANING
,      RESULT_CODE_MEANING
,      FUNDING_BUDGET_NAME
,      AMOUNT_TYPE_MEANING
,      BOUNDARY_MEANING
,      TEMPLATE
,      LEVEL_MEANING
,      ACCOUNT_TYPE_MEANING
,      EFFECT_ON_FUNDS_MEANING
,      BATCH_NAME
,      HEADER_NAME
,      AE_HEADER_ID
,      AE_LINE_NUM
,      PERIOD_NUM
,      PERIOD_YEAR
,      QUARTER_NUM
,      EFFECTIVE_STATUS
FROM APPS.PSA_BC_REPORT_V;

Dependencies

[top of page]

APPS.PSA_BC_REPORT_V references the following:

APPS: GL_BC_PACKETS; GL_BC_PACKETS_HISTS; GL_BUDGET_VERSIONS; GL_ENCUMBRANCE_TYPES; GL_JE_BATCHES; GL_JE_CATEGORIES; GL_JE_HEADERS; GL_JE_SOURCES; GL_SUMMARY_TEMPLATES; PSA_BC_APPLICATION_V; PSA_BC_REPORT_EVENTS_GT

APPS.PSA_BC_REPORT_V is referenced by following:

APPS: PSA_BC_XML_REPORT_PUB - show dependent code