[Home] [Help] [Dependency Information]
Object Name: | PAY_IN_TAX_DECLARATIONS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PAY.PAY_IN_TAX_DECLARATIONS_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PERSON_ID | NUMBER | (10) | Yes | |
FULL_NAME | VARCHAR2 | (240) | ||
EMPLOYEE_NUMBER | VARCHAR2 | (30) | ||
ASSIGNMENT_ID | NUMBER | (10) | Yes | |
ASSIGNMENT_NUMBER | VARCHAR2 | (30) | ||
EFFECTIVE_DATE | DATE | |||
DEPARTMENT | VARCHAR2 | (240) | Yes | |
LAST_UPDATED_DATE | DATE | |||
ORGANIZATION_ID | NUMBER | (15) | Yes | |
BUSINESS_GROUP_ID | NUMBER | (15) | Yes | |
START_DATE | DATE | Yes | ||
GRADE_ID | NUMBER | (15) | ||
JOB_ID | NUMBER | (15) | ||
POSITION_ID | NUMBER | (15) | ||
TAX_AREA_NUMBER | VARCHAR2 | (150) | ||
APPROVAL_STATUS | VARCHAR2 | (150) | ||
TAX_YEAR | VARCHAR2 | (150) | ||
APRIL | NUMBER | |||
MAY | NUMBER | |||
JUNE | NUMBER | |||
JULY | NUMBER | |||
AUGUST | NUMBER | |||
SEPTEMBER | NUMBER | |||
OCTOBER | NUMBER | |||
NOVEMBER | NUMBER | |||
DECEMBER | NUMBER | |||
JANUARY | NUMBER | |||
FEBRUARY | NUMBER | |||
MARCH | NUMBER | |||
CCE_EE_ID1 | VARCHAR2 | (4000) | ||
COMPONENT1 | VARCHAR2 | (4000) | ||
INVESTMENT_AMOUNT1 | VARCHAR2 | (4000) | ||
CCE_EE_ID2 | VARCHAR2 | (4000) | ||
COMPONENT2 | VARCHAR2 | (4000) | ||
INVESTMENT_AMOUNT2 | VARCHAR2 | (4000) | ||
CCE_EE_ID3 | VARCHAR2 | (4000) | ||
COMPONENT3 | VARCHAR2 | (4000) | ||
INVESTMENT_AMOUNT3 | VARCHAR2 | (4000) | ||
CCE_EE_ID4 | VARCHAR2 | (4000) | ||
COMPONENT4 | VARCHAR2 | (4000) | ||
INVESTMENT_AMOUNT4 | VARCHAR2 | (4000) | ||
CCE_EE_ID5 | VARCHAR2 | (4000) | ||
COMPONENT5 | VARCHAR2 | (4000) | ||
INVESTMENT_AMOUNT5 | VARCHAR2 | (4000) | ||
CCE_EE_ID6 | VARCHAR2 | (4000) | ||
COMPONENT6 | VARCHAR2 | (4000) | ||
INVESTMENT_AMOUNT6 | VARCHAR2 | (4000) | ||
CCE_EE_ID7 | VARCHAR2 | (4000) | ||
COMPONENT7 | VARCHAR2 | (4000) | ||
INVESTMENT_AMOUNT7 | VARCHAR2 | (4000) | ||
CCE_EE_ID8 | VARCHAR2 | (4000) | ||
COMPONENT8 | VARCHAR2 | (4000) | ||
INVESTMENT_AMOUNT8 | VARCHAR2 | (4000) | ||
CCE_EE_ID9 | VARCHAR2 | (4000) | ||
COMPONENT9 | VARCHAR2 | (4000) | ||
INVESTMENT_AMOUNT9 | VARCHAR2 | (4000) | ||
CCE_EE_ID10 | VARCHAR2 | (4000) | ||
COMPONENT10 | VARCHAR2 | (4000) | ||
INVESTMENT_AMOUNT10 | VARCHAR2 | (4000) | ||
CCE_EE_ID11 | VARCHAR2 | (4000) | ||
COMPONENT11 | VARCHAR2 | (4000) | ||
INVESTMENT_AMOUNT11 | VARCHAR2 | (4000) | ||
CCE_EE_ID12 | VARCHAR2 | (4000) | ||
COMPONENT12 | VARCHAR2 | (4000) | ||
INVESTMENT_AMOUNT12 | VARCHAR2 | (4000) | ||
CCE_EE_ID13 | VARCHAR2 | (4000) | ||
COMPONENT13 | VARCHAR2 | (4000) | ||
INVESTMENT_AMOUNT13 | VARCHAR2 | (4000) | ||
CCE_EE_ID14 | VARCHAR2 | (4000) | ||
COMPONENT14 | VARCHAR2 | (4000) | ||
INVESTMENT_AMOUNT14 | VARCHAR2 | (4000) | ||
CCE_EE_ID15 | VARCHAR2 | (4000) | ||
COMPONENT15 | VARCHAR2 | (4000) | ||
INVESTMENT_AMOUNT15 | VARCHAR2 | (4000) | ||
CCE_EE_ID16 | VARCHAR2 | (4000) | ||
COMPONENT16 | VARCHAR2 | (4000) | ||
INVESTMENT_AMOUNT16 | VARCHAR2 | (4000) | ||
CCE_EE_ID17 | VARCHAR2 | (4000) | ||
COMPONENT17 | VARCHAR2 | (4000) | ||
INVESTMENT_AMOUNT17 | VARCHAR2 | (4000) | ||
CCE_EE_ID18 | VARCHAR2 | (4000) | ||
COMPONENT18 | VARCHAR2 | (4000) | ||
INVESTMENT_AMOUNT18 | VARCHAR2 | (4000) | ||
CCE_EE_ID19 | VARCHAR2 | (4000) | ||
COMPONENT19 | VARCHAR2 | (4000) | ||
INVESTMENT_AMOUNT19 | VARCHAR2 | (4000) | ||
CCE_EE_ID20 | VARCHAR2 | (4000) | ||
COMPONENT20 | VARCHAR2 | (4000) | ||
INVESTMENT_AMOUNT20 | VARCHAR2 | (4000) | ||
CCE_EE_ID21 | VARCHAR2 | (4000) | ||
COMPONENT21 | VARCHAR2 | (4000) | ||
INVESTMENT_AMOUNT21 | VARCHAR2 | (4000) | ||
HIGHER_EDUCATION_LOAN | NUMBER | |||
DONATION_FOR_RESEARCH | NUMBER | |||
CLAIM_EXEMPTION_SEC_80GG | VARCHAR2 | (4000) | ||
PREMIUM_AMOUNT | NUMBER | |||
PREMIUM_COVERS_SC | VARCHAR2 | (4000) | ||
PARENT_PREMIUM | NUMBER | |||
PARENT_SC | VARCHAR2 | (4000) | ||
TREATMENT_AMOUNT | NUMBER | |||
TREATMENT_COVERS_SC | VARCHAR2 | (4000) | ||
INCOME_FROM_HOUSE_PROPERTY | NUMBER | |||
PROFIT_AND_GAIN | NUMBER | |||
LONG_TERM_CAPITAL_GAIN | NUMBER | |||
SHORT_TERM_CAPITAL_GAIN | NUMBER | |||
INCOME_FROM_OTHER_SOURCES | NUMBER | |||
TDS_PAID | NUMBER | |||
DISEASE_ENTRY_ID1 | VARCHAR2 | (4000) | ||
DISABILITY_TYPE1 | VARCHAR2 | (4000) | ||
DISABILITY_PERCENTAGE1 | VARCHAR2 | (4000) | ||
TREATMENT_AMOUNT1 | VARCHAR2 | (4000) | ||
DISEASE_ENTRY_ID2 | VARCHAR2 | (4000) | ||
DISABILITY_TYPE2 | VARCHAR2 | (4000) | ||
DISABILITY_PERCENTAGE2 | VARCHAR2 | (4000) | ||
TREATMENT_AMOUNT2 | VARCHAR2 | (4000) | ||
DONATION_ENTRY_ID1 | VARCHAR2 | (4000) | ||
DONATION_TYPE1 | VARCHAR2 | (4000) | ||
DONATION_AMOUNT1 | VARCHAR2 | (4000) | ||
DONATION_ENTRY_ID2 | VARCHAR2 | (4000) | ||
DONATION_TYPE2 | VARCHAR2 | (4000) | ||
DONATION_AMOUNT2 | VARCHAR2 | (4000) | ||
LIC_ENTRY_ID1 | VARCHAR2 | (4000) | ||
PREMIUM_PAID1 | VARCHAR2 | (4000) | ||
SUM_ASSURED1 | VARCHAR2 | (4000) | ||
LIC_ENTRY_ID2 | VARCHAR2 | (4000) | ||
PREMIUM_PAID2 | VARCHAR2 | (4000) | ||
SUM_ASSURED2 | VARCHAR2 | (4000) | ||
LIC_ENTRY_ID3 | VARCHAR2 | (4000) | ||
PREMIUM_PAID3 | VARCHAR2 | (4000) | ||
SUM_ASSURED3 | VARCHAR2 | (4000) | ||
LIC_ENTRY_ID4 | VARCHAR2 | (4000) | ||
PREMIUM_PAID4 | VARCHAR2 | (4000) | ||
SUM_ASSURED4 | VARCHAR2 | (4000) | ||
LIC_ENTRY_ID5 | VARCHAR2 | (4000) | ||
PREMIUM_PAID5 | VARCHAR2 | (4000) | ||
SUM_ASSURED5 | VARCHAR2 | (4000) | ||
COMMENT_TEXT | VARCHAR2 | (150) |
Cut, paste (and edit) the following text to query this object:
SELECT PERSON_ID
, FULL_NAME
, EMPLOYEE_NUMBER
, ASSIGNMENT_ID
, ASSIGNMENT_NUMBER
, EFFECTIVE_DATE
, DEPARTMENT
, LAST_UPDATED_DATE
, ORGANIZATION_ID
, BUSINESS_GROUP_ID
, START_DATE
, GRADE_ID
, JOB_ID
, POSITION_ID
, TAX_AREA_NUMBER
, APPROVAL_STATUS
, TAX_YEAR
, APRIL
, MAY
, JUNE
, JULY
, AUGUST
, SEPTEMBER
, OCTOBER
, NOVEMBER
, DECEMBER
, JANUARY
, FEBRUARY
, MARCH
, CCE_EE_ID1
, COMPONENT1
, INVESTMENT_AMOUNT1
, CCE_EE_ID2
, COMPONENT2
, INVESTMENT_AMOUNT2
, CCE_EE_ID3
, COMPONENT3
, INVESTMENT_AMOUNT3
, CCE_EE_ID4
, COMPONENT4
, INVESTMENT_AMOUNT4
, CCE_EE_ID5
, COMPONENT5
, INVESTMENT_AMOUNT5
, CCE_EE_ID6
, COMPONENT6
, INVESTMENT_AMOUNT6
, CCE_EE_ID7
, COMPONENT7
, INVESTMENT_AMOUNT7
, CCE_EE_ID8
, COMPONENT8
, INVESTMENT_AMOUNT8
, CCE_EE_ID9
, COMPONENT9
, INVESTMENT_AMOUNT9
, CCE_EE_ID10
, COMPONENT10
, INVESTMENT_AMOUNT10
, CCE_EE_ID11
, COMPONENT11
, INVESTMENT_AMOUNT11
, CCE_EE_ID12
, COMPONENT12
, INVESTMENT_AMOUNT12
, CCE_EE_ID13
, COMPONENT13
, INVESTMENT_AMOUNT13
, CCE_EE_ID14
, COMPONENT14
, INVESTMENT_AMOUNT14
, CCE_EE_ID15
, COMPONENT15
, INVESTMENT_AMOUNT15
, CCE_EE_ID16
, COMPONENT16
, INVESTMENT_AMOUNT16
, CCE_EE_ID17
, COMPONENT17
, INVESTMENT_AMOUNT17
, CCE_EE_ID18
, COMPONENT18
, INVESTMENT_AMOUNT18
, CCE_EE_ID19
, COMPONENT19
, INVESTMENT_AMOUNT19
, CCE_EE_ID20
, COMPONENT20
, INVESTMENT_AMOUNT20
, CCE_EE_ID21
, COMPONENT21
, INVESTMENT_AMOUNT21
, HIGHER_EDUCATION_LOAN
, DONATION_FOR_RESEARCH
, CLAIM_EXEMPTION_SEC_80GG
, PREMIUM_AMOUNT
, PREMIUM_COVERS_SC
, PARENT_PREMIUM
, PARENT_SC
, TREATMENT_AMOUNT
, TREATMENT_COVERS_SC
, INCOME_FROM_HOUSE_PROPERTY
, PROFIT_AND_GAIN
, LONG_TERM_CAPITAL_GAIN
, SHORT_TERM_CAPITAL_GAIN
, INCOME_FROM_OTHER_SOURCES
, TDS_PAID
, DISEASE_ENTRY_ID1
, DISABILITY_TYPE1
, DISABILITY_PERCENTAGE1
, TREATMENT_AMOUNT1
, DISEASE_ENTRY_ID2
, DISABILITY_TYPE2
, DISABILITY_PERCENTAGE2
, TREATMENT_AMOUNT2
, DONATION_ENTRY_ID1
, DONATION_TYPE1
, DONATION_AMOUNT1
, DONATION_ENTRY_ID2
, DONATION_TYPE2
, DONATION_AMOUNT2
, LIC_ENTRY_ID1
, PREMIUM_PAID1
, SUM_ASSURED1
, LIC_ENTRY_ID2
, PREMIUM_PAID2
, SUM_ASSURED2
, LIC_ENTRY_ID3
, PREMIUM_PAID3
, SUM_ASSURED3
, LIC_ENTRY_ID4
, PREMIUM_PAID4
, SUM_ASSURED4
, LIC_ENTRY_ID5
, PREMIUM_PAID5
, SUM_ASSURED5
, COMMENT_TEXT
FROM APPS.PAY_IN_TAX_DECLARATIONS_V;
|
|
|