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

VIEW: APPS.PAY_JP_BAL_MATRIX_BY_ACT_V

Object Details
Object Name: PAY_JP_BAL_MATRIX_BY_ACT_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPAY.PAY_JP_BAL_MATRIX_BY_ACT_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
ASSIGNMENT_ACTION_ID NUMBER (15) Yes
BALANCE_TYPE_ID NUMBER (9) Yes
BALANCE_NAME VARCHAR2 (80) Yes
BALANCE_UOM VARCHAR2 (30) Yes
D_BALANCE_UOM VARCHAR2 (80)
CURRENCY_CODE VARCHAR2 (15)
ASG_RUN_BAL NUMBER

ASG_PROC_PTD_BAL NUMBER

ASG_MTD_JP_BAL NUMBER

ASG_YTD_JP_BAL NUMBER

ASG_FYTD_JP_BAL NUMBER

ASG_AUG2JUL_JP_BAL NUMBER

ASG_ITD_BAL NUMBER

ASG_JUL2JUN_JP_BAL NUMBER

ASG_FYTD2_JP_BAL NUMBER

ASG_APR2MAR_JP_BAL NUMBER

Query Text

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


SELECT ASSIGNMENT_ACTION_ID
,      BALANCE_TYPE_ID
,      BALANCE_NAME
,      BALANCE_UOM
,      D_BALANCE_UOM
,      CURRENCY_CODE
,      ASG_RUN_BAL
,      ASG_PROC_PTD_BAL
,      ASG_MTD_JP_BAL
,      ASG_YTD_JP_BAL
,      ASG_FYTD_JP_BAL
,      ASG_AUG2JUL_JP_BAL
,      ASG_ITD_BAL
,      ASG_JUL2JUN_JP_BAL
,      ASG_FYTD2_JP_BAL
,      ASG_APR2MAR_JP_BAL
FROM APPS.PAY_JP_BAL_MATRIX_BY_ACT_V;

Dependencies

[top of page]

APPS.PAY_JP_BAL_MATRIX_BY_ACT_V references the following:

SchemaAPPS
PL/SQL PackageHR_GENERAL - show dependent code
SynonymPAY_ASSIGNMENT_ACTIONS
SynonymPAY_BALANCE_FEEDS_F
SynonymPAY_BALANCE_TYPES
SynonymPAY_BALANCE_TYPES_TL
PL/SQL PackagePAY_JP_BALANCE_VIEW_PKG - show dependent code
SynonymPAY_PAYROLL_ACTIONS
SynonymPAY_RUN_RESULTS
SynonymPAY_RUN_RESULT_VALUES

APPS.PAY_JP_BAL_MATRIX_BY_ACT_V is not referenced by any database object