[Home] [Help] [Dependency Information]
Object Name: | PAY_JP_PRE_TAX_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PAY.PAY_JP_PRE_TAX_V |
Subobject Name: | |
Status: | VALID |
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.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ||
BUSINESS_GROUP_ID | NUMBER | (15) | Yes | |
PAYROLL_ID | NUMBER | (9) | ||
CONSOLIDATION_SET_ID | NUMBER | (9) | ||
CONSOLIDATION_SET_NAME | VARCHAR2 | (60) | ||
ELEMENT_SET_ID | NUMBER | (9) | ||
ACTION_TYPE | VARCHAR2 | (30) | Yes | |
D_ACTION_TYPE | VARCHAR2 | (80) | ||
EFFECTIVE_DATE | DATE | Yes | ||
DATE_EARNED | DATE | |||
TIME_PERIOD_ID | NUMBER | (15) | ||
PRE_TAX_ID | NUMBER | (15) | ||
ACTION_ID | NUMBER | |||
ASSIGNMENT_ACTION_ID | NUMBER | (15) | Yes | |
ASSIGNMENT_ID | NUMBER | (10) | ||
PERSON_ID | NUMBER | (10) | Yes | |
ACTION_STATUS | VARCHAR2 | (1) | ||
D_ACTION_STATUS | VARCHAR2 | (80) | ||
EMPLOYEE_NUMBER | VARCHAR2 | (30) | ||
FULL_NAME | VARCHAR2 | (240) | ||
GLOBAL_NAME | VARCHAR2 | (240) | ||
LOCAL_NAME | VARCHAR2 | (240) | ||
SALARY_CATEGORY | VARCHAR2 | (240) | ||
D_SALARY_CATEGORY | VARCHAR2 | (80) | ||
TAXABLE_SAL_AMT | NUMBER | |||
TAXABLE_MAT_AMT | NUMBER | |||
HI_ORGANIZATION_ID | NUMBER | |||
D_HI_ORGANIZATION_ID | VARCHAR2 | (240) | ||
HI_PREM_EE | NUMBER | |||
HI_PREM_ER | NUMBER | |||
CI_PREM_EE | NUMBER | |||
CI_PREM_ER | NUMBER | |||
WP_ORGANIZATION_ID | NUMBER | |||
D_WP_ORGANIZATION_ID | VARCHAR2 | (240) | ||
WP_PREM_EE | NUMBER | |||
WP_PREM_ER | NUMBER | |||
WPF_ORGANIZATION_ID | NUMBER | |||
D_WPF_ORGANIZATION_ID | VARCHAR2 | (240) | ||
WPF_PREM_EE | NUMBER | |||
WPF_PREM_ER | NUMBER | |||
UI_ORGANIZATION_ID | NUMBER | |||
D_UI_ORGANIZATION_ID | VARCHAR2 | (240) | ||
UI_CATEGORY | VARCHAR2 | (240) | ||
D_UI_CATEGORY | VARCHAR2 | (80) | ||
UI_PREM_EE | NUMBER | |||
UI_SAL_AMT | NUMBER | |||
WAI_ORGANIZATION_ID | NUMBER | |||
D_WAI_ORGANIZATION_ID | VARCHAR2 | (240) | ||
WAI_CATEGORY | VARCHAR2 | (240) | ||
D_WAI_CATEGORY | VARCHAR2 | (80) | ||
WAI_SAL_AMT | NUMBER | |||
ITAX_ORGANIZATION_ID | NUMBER | |||
D_ITAX_ORGANIZATION_ID | VARCHAR2 | (240) | ||
ITAX_CATEGORY | VARCHAR2 | (240) | ||
D_ITAX_CATEGORY | VARCHAR2 | (4000) | ||
ITAX_YEA_CATEGORY | VARCHAR2 | (240) | ||
D_ITAX_YEA_CATEGORY | VARCHAR2 | (80) | ||
ITAX | NUMBER | |||
ITAX_ADJUSTMENT | NUMBER | |||
LTAX_DISTRICT_CODE | VARCHAR2 | (240) | ||
LTAX_SWOT_NO | VARCHAR2 | (15) | ||
LTAX | NUMBER | |||
LTAX_LUMPSUM | NUMBER | |||
SP_LTAX_DISTRICT_CODE | VARCHAR2 | (240) | ||
SP_LTAX_SWOT_NO | VARCHAR2 | (15) | ||
SP_LTAX | NUMBER | |||
SP_LTAX_INCOME | NUMBER | |||
SP_LTAX_SHI | NUMBER | |||
SP_LTAX_TO | NUMBER | |||
MUTUAL_AID | NUMBER | |||
DISASTER_TAX_REDUCTION | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, BUSINESS_GROUP_ID
, PAYROLL_ID
, CONSOLIDATION_SET_ID
, CONSOLIDATION_SET_NAME
, ELEMENT_SET_ID
, ACTION_TYPE
, D_ACTION_TYPE
, EFFECTIVE_DATE
, DATE_EARNED
, TIME_PERIOD_ID
, PRE_TAX_ID
, ACTION_ID
, ASSIGNMENT_ACTION_ID
, ASSIGNMENT_ID
, PERSON_ID
, ACTION_STATUS
, D_ACTION_STATUS
, EMPLOYEE_NUMBER
, FULL_NAME
, GLOBAL_NAME
, LOCAL_NAME
, SALARY_CATEGORY
, D_SALARY_CATEGORY
, TAXABLE_SAL_AMT
, TAXABLE_MAT_AMT
, HI_ORGANIZATION_ID
, D_HI_ORGANIZATION_ID
, HI_PREM_EE
, HI_PREM_ER
, CI_PREM_EE
, CI_PREM_ER
, WP_ORGANIZATION_ID
, D_WP_ORGANIZATION_ID
, WP_PREM_EE
, WP_PREM_ER
, WPF_ORGANIZATION_ID
, D_WPF_ORGANIZATION_ID
, WPF_PREM_EE
, WPF_PREM_ER
, UI_ORGANIZATION_ID
, D_UI_ORGANIZATION_ID
, UI_CATEGORY
, D_UI_CATEGORY
, UI_PREM_EE
, UI_SAL_AMT
, WAI_ORGANIZATION_ID
, D_WAI_ORGANIZATION_ID
, WAI_CATEGORY
, D_WAI_CATEGORY
, WAI_SAL_AMT
, ITAX_ORGANIZATION_ID
, D_ITAX_ORGANIZATION_ID
, ITAX_CATEGORY
, D_ITAX_CATEGORY
, ITAX_YEA_CATEGORY
, D_ITAX_YEA_CATEGORY
, ITAX
, ITAX_ADJUSTMENT
, LTAX_DISTRICT_CODE
, LTAX_SWOT_NO
, LTAX
, LTAX_LUMPSUM
, SP_LTAX_DISTRICT_CODE
, SP_LTAX_SWOT_NO
, SP_LTAX
, SP_LTAX_INCOME
, SP_LTAX_SHI
, SP_LTAX_TO
, MUTUAL_AID
, DISASTER_TAX_REDUCTION
FROM APPS.PAY_JP_PRE_TAX_V;
APPS.PAY_JP_PRE_TAX_V is not referenced by any database object
|
|
|