[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PAY_HK_IR56_ARCHIVES_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  PAY.PAY_HK_IR56_ARCHIVES_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 |
|---|---|---|---|---|
| ASSIGNMENT_ACTION_ROWID | ROWID | (10) | ||
| ASSIGNMENT_ACTION_ID | NUMBER | (15) | Yes | |
| ASSIGNMENT_ID | NUMBER | (10) | ||
| ARCHIVE_ACTION_ID | NUMBER | (9) | Yes | |
| X_HK_REPORTING_YEAR | VARCHAR2 | (4000) | ||
| X_HK_ISSUE_DATE | VARCHAR2 | (4000) | ||
| X_HK_SHEET_NO | VARCHAR2 | (4000) | ||
| X_HK_EMPLOYEE_TFN | VARCHAR2 | (4000) | ||
| X_HK_EMPLOYER_TFN | VARCHAR2 | (4000) | ||
| X_HK_EMPLOYER_NAME | VARCHAR2 | (4000) | ||
| X_HK_LAST_NAME | VARCHAR2 | (4000) | ||
| X_HK_OTHER_NAMES | VARCHAR2 | (4000) | ||
| X_HK_CHINESE_FULL_NAME | VARCHAR2 | (4000) | ||
| X_HK_HKID | VARCHAR2 | (4000) | ||
| X_HK_PASSPORT_INFO | VARCHAR2 | (4000) | ||
| X_HK_SEX | VARCHAR2 | (4000) | ||
| X_HK_MARITAL_STATUS | VARCHAR2 | (4000) | ||
| X_HK_SPOUSE_NAME | VARCHAR2 | (4000) | ||
| X_HK_SPOUSE_HKID | VARCHAR2 | (4000) | ||
| X_HK_SPOUSE_PASSPORT_INFO | VARCHAR2 | (4000) | ||
| X_HK_RESIDENTIAL_ADDRESS_1 | VARCHAR2 | (4000) | ||
| X_HK_RESIDENTIAL_ADDRESS_2 | VARCHAR2 | (4000) | ||
| X_HK_RES_COUNTRY | VARCHAR2 | (4000) | ||
| X_HK_RESIDENTIAL_AREA_CODE | VARCHAR2 | (4000) | ||
| X_HK_CORRESPONDENCE_ADDRESS_1 | VARCHAR2 | (4000) | ||
| X_HK_CORRESPONDENCE_ADDRESS_2 | VARCHAR2 | (4000) | ||
| X_HK_CAPACITY_EMPLOYED | VARCHAR2 | (4000) | ||
| X_HK_PRINCIPAL_EMPLOYER_NAME | VARCHAR2 | (4000) | ||
| X_HK_EMPLOYMENT_START_DATE | VARCHAR2 | (4000) | ||
| X_HK_EMPLOYMENT_END_DATE | VARCHAR2 | (4000) | ||
| X_HK_IR56_A_DESCRIPTION | VARCHAR2 | (4000) | ||
| X_HK_IR56_A_PERIOD | VARCHAR2 | (4000) | ||
| X_HK_IR56_A_ASG_LE_YTD | VARCHAR2 | (4000) | ||
| X_HK_IR56_B_DESCRIPTION | VARCHAR2 | (4000) | ||
| X_HK_IR56_B_PERIOD | VARCHAR2 | (4000) | ||
| X_HK_IR56_B_ASG_LE_YTD | VARCHAR2 | (4000) | ||
| X_HK_IR56_C_DESCRIPTION | VARCHAR2 | (4000) | ||
| X_HK_IR56_C_PERIOD | VARCHAR2 | (4000) | ||
| X_HK_IR56_C_ASG_LE_YTD | VARCHAR2 | (4000) | ||
| X_HK_IR56_D_DESCRIPTION | VARCHAR2 | (4000) | ||
| X_HK_IR56_D_PERIOD | VARCHAR2 | (4000) | ||
| X_HK_IR56_D_ASG_LE_YTD | VARCHAR2 | (4000) | ||
| X_HK_IR56_E_DESCRIPTION | VARCHAR2 | (4000) | ||
| X_HK_IR56_E_PERIOD | VARCHAR2 | (4000) | ||
| X_HK_IR56_E_ASG_LE_YTD | VARCHAR2 | (4000) | ||
| X_HK_IR56_F_DESCRIPTION | VARCHAR2 | (4000) | ||
| X_HK_IR56_F_PERIOD | VARCHAR2 | (4000) | ||
| X_HK_IR56_F_ASG_LE_YTD | VARCHAR2 | (4000) | ||
| X_HK_IR56_G_DESCRIPTION | VARCHAR2 | (4000) | ||
| X_HK_IR56_G_PERIOD | VARCHAR2 | (4000) | ||
| X_HK_IR56_G_ASG_LE_YTD | VARCHAR2 | (4000) | ||
| X_HK_IR56_H_DESCRIPTION | VARCHAR2 | (4000) | ||
| X_HK_IR56_H_PERIOD | VARCHAR2 | (4000) | ||
| X_HK_IR56_H_ASG_LE_YTD | VARCHAR2 | (4000) | ||
| X_HK_IR56_I_DESCRIPTION | VARCHAR2 | (4000) | ||
| X_HK_IR56_I_PERIOD | VARCHAR2 | (4000) | ||
| X_HK_IR56_I_ASG_LE_YTD | VARCHAR2 | (4000) | ||
| X_HK_IR56_J_DESCRIPTION | VARCHAR2 | (4000) | ||
| X_HK_IR56_J_PERIOD | VARCHAR2 | (4000) | ||
| X_HK_IR56_J_ASG_LE_YTD | VARCHAR2 | (4000) | ||
| X_HK_IR56_K1_DESCRIPTION | VARCHAR2 | (4000) | ||
| X_HK_IR56_K1_PERIOD | VARCHAR2 | (4000) | ||
| X_HK_IR56_K1_ASG_LE_YTD | VARCHAR2 | (4000) | ||
| X_HK_IR56_K2_DESCRIPTION | VARCHAR2 | (4000) | ||
| X_HK_IR56_K2_PERIOD | VARCHAR2 | (4000) | ||
| X_HK_IR56_K2_ASG_LE_YTD | VARCHAR2 | (4000) | ||
| X_HK_IR56_K3_DESCRIPTION | VARCHAR2 | (4000) | ||
| X_HK_IR56_K3_PERIOD | VARCHAR2 | (4000) | ||
| X_HK_IR56_K3_ASG_LE_YTD | VARCHAR2 | (4000) | ||
| X_HK_IR56_L_DESCRIPTION | VARCHAR2 | (4000) | ||
| X_HK_IR56_L_PERIOD | VARCHAR2 | (4000) | ||
| X_HK_IR56_L_ASG_LE_YTD | VARCHAR2 | (4000) | ||
| X_HK_QUARTERS_PROVIDED | VARCHAR2 | (4000) | ||
| X_HK_QUARTERS_1_ADDRESS | VARCHAR2 | (4000) | ||
| X_HK_QUARTERS_1_NATURE | VARCHAR2 | (4000) | ||
| X_HK_QUARTERS_1_PERIOD | VARCHAR2 | (4000) | ||
| X_HK_Q_1_ER_TO_LL_LE_YTD | VARCHAR2 | (4000) | ||
| X_HK_Q_1_EE_TO_LL_LE_YTD | VARCHAR2 | (4000) | ||
| X_HK_Q_1_REFUND_TO_EE_LE_YTD | VARCHAR2 | (4000) | ||
| X_HK_Q_1_EE_TO_ER_LE_YTD | VARCHAR2 | (4000) | ||
| X_HK_QUARTERS_2_ADDRESS | VARCHAR2 | (4000) | ||
| X_HK_QUARTERS_2_NATURE | VARCHAR2 | (4000) | ||
| X_HK_QUARTERS_2_PERIOD | VARCHAR2 | (4000) | ||
| X_HK_Q_2_ER_TO_LL_LE_YTD | VARCHAR2 | (4000) | ||
| X_HK_Q_2_EE_TO_LL_LE_YTD | VARCHAR2 | (4000) | ||
| X_HK_Q_2_REFUND_TO_EE_LE_YTD | VARCHAR2 | (4000) | ||
| X_HK_Q_2_EE_TO_ER_LE_YTD | VARCHAR2 | (4000) | ||
| X_HK_OVERSEAS_CONCERN | VARCHAR2 | (4000) | ||
| X_HK_OVERSEAS_NAME | VARCHAR2 | (4000) | ||
| X_HK_OVERSEAS_ADDRESS | VARCHAR2 | (4000) | ||
| X_HK_OVERSEAS_AMOUNT | VARCHAR2 | (4000) | ||
| X_HK_REMARKS | VARCHAR2 | (4000) | ||
| X_HK_DESIGNATION | VARCHAR2 | (4000) | ||
| X_HK_CONTACT | VARCHAR2 | (4000) | ||
| X_HK_ARCHIVE_MESSAGE | VARCHAR2 | (4000) | ||
| X_LAST_RUN_DATE | VARCHAR2 | (4000) | ||
| X_LAST_RUN_TYPE | VARCHAR2 | (4000) |
Cut, paste (and edit) the following text to query this object:
SELECT ASSIGNMENT_ACTION_ROWID
, ASSIGNMENT_ACTION_ID
, ASSIGNMENT_ID
, ARCHIVE_ACTION_ID
, X_HK_REPORTING_YEAR
, X_HK_ISSUE_DATE
, X_HK_SHEET_NO
, X_HK_EMPLOYEE_TFN
, X_HK_EMPLOYER_TFN
, X_HK_EMPLOYER_NAME
, X_HK_LAST_NAME
, X_HK_OTHER_NAMES
, X_HK_CHINESE_FULL_NAME
, X_HK_HKID
, X_HK_PASSPORT_INFO
, X_HK_SEX
, X_HK_MARITAL_STATUS
, X_HK_SPOUSE_NAME
, X_HK_SPOUSE_HKID
, X_HK_SPOUSE_PASSPORT_INFO
, X_HK_RESIDENTIAL_ADDRESS_1
, X_HK_RESIDENTIAL_ADDRESS_2
, X_HK_RES_COUNTRY
, X_HK_RESIDENTIAL_AREA_CODE
, X_HK_CORRESPONDENCE_ADDRESS_1
, X_HK_CORRESPONDENCE_ADDRESS_2
, X_HK_CAPACITY_EMPLOYED
, X_HK_PRINCIPAL_EMPLOYER_NAME
, X_HK_EMPLOYMENT_START_DATE
, X_HK_EMPLOYMENT_END_DATE
, X_HK_IR56_A_DESCRIPTION
, X_HK_IR56_A_PERIOD
, X_HK_IR56_A_ASG_LE_YTD
, X_HK_IR56_B_DESCRIPTION
, X_HK_IR56_B_PERIOD
, X_HK_IR56_B_ASG_LE_YTD
, X_HK_IR56_C_DESCRIPTION
, X_HK_IR56_C_PERIOD
, X_HK_IR56_C_ASG_LE_YTD
, X_HK_IR56_D_DESCRIPTION
, X_HK_IR56_D_PERIOD
, X_HK_IR56_D_ASG_LE_YTD
, X_HK_IR56_E_DESCRIPTION
, X_HK_IR56_E_PERIOD
, X_HK_IR56_E_ASG_LE_YTD
, X_HK_IR56_F_DESCRIPTION
, X_HK_IR56_F_PERIOD
, X_HK_IR56_F_ASG_LE_YTD
, X_HK_IR56_G_DESCRIPTION
, X_HK_IR56_G_PERIOD
, X_HK_IR56_G_ASG_LE_YTD
, X_HK_IR56_H_DESCRIPTION
, X_HK_IR56_H_PERIOD
, X_HK_IR56_H_ASG_LE_YTD
, X_HK_IR56_I_DESCRIPTION
, X_HK_IR56_I_PERIOD
, X_HK_IR56_I_ASG_LE_YTD
, X_HK_IR56_J_DESCRIPTION
, X_HK_IR56_J_PERIOD
, X_HK_IR56_J_ASG_LE_YTD
, X_HK_IR56_K1_DESCRIPTION
, X_HK_IR56_K1_PERIOD
, X_HK_IR56_K1_ASG_LE_YTD
, X_HK_IR56_K2_DESCRIPTION
, X_HK_IR56_K2_PERIOD
, X_HK_IR56_K2_ASG_LE_YTD
, X_HK_IR56_K3_DESCRIPTION
, X_HK_IR56_K3_PERIOD
, X_HK_IR56_K3_ASG_LE_YTD
, X_HK_IR56_L_DESCRIPTION
, X_HK_IR56_L_PERIOD
, X_HK_IR56_L_ASG_LE_YTD
, X_HK_QUARTERS_PROVIDED
, X_HK_QUARTERS_1_ADDRESS
, X_HK_QUARTERS_1_NATURE
, X_HK_QUARTERS_1_PERIOD
, X_HK_Q_1_ER_TO_LL_LE_YTD
, X_HK_Q_1_EE_TO_LL_LE_YTD
, X_HK_Q_1_REFUND_TO_EE_LE_YTD
, X_HK_Q_1_EE_TO_ER_LE_YTD
, X_HK_QUARTERS_2_ADDRESS
, X_HK_QUARTERS_2_NATURE
, X_HK_QUARTERS_2_PERIOD
, X_HK_Q_2_ER_TO_LL_LE_YTD
, X_HK_Q_2_EE_TO_LL_LE_YTD
, X_HK_Q_2_REFUND_TO_EE_LE_YTD
, X_HK_Q_2_EE_TO_ER_LE_YTD
, X_HK_OVERSEAS_CONCERN
, X_HK_OVERSEAS_NAME
, X_HK_OVERSEAS_ADDRESS
, X_HK_OVERSEAS_AMOUNT
, X_HK_REMARKS
, X_HK_DESIGNATION
, X_HK_CONTACT
, X_HK_ARCHIVE_MESSAGE
, X_LAST_RUN_DATE
, X_LAST_RUN_TYPE
FROM APPS.PAY_HK_IR56_ARCHIVES_V;
APPS
PAY_ASSIGNMENT_ACTIONS
PAY_CORE_UTILS
- show dependent code
PAY_HK_IR56_REPORT
- show dependent code
PAY_PAYROLL_ACTIONS
APPS.PAY_HK_IR56_ARCHIVES_V is not referenced by any database object
|
|
|
|