[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | JTF_RS_RESOURCE_EXTN_AUD# |
|---|---|
| Object Type: | VIEW |
| Owner: | JTF |
| Subobject Name: | |
| Status: | VALID |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| RESOURCE_AUDIT_ID | NUMBER | Yes | ||
| RESOURCE_ID | NUMBER | Yes | ||
| NEW_CATEGORY | VARCHAR2 | (30) | ||
| OLD_CATEGORY | VARCHAR2 | (30) | ||
| NEW_RESOURCE_NUMBER | VARCHAR2 | (30) | ||
| OLD_RESOURCE_NUMBER | VARCHAR2 | (30) | ||
| NEW_SOURCE_ID | NUMBER | |||
| OLD_SOURCE_ID | NUMBER | |||
| NEW_MANAGING_EMPLOYEE_ID | NUMBER | |||
| OLD_MANAGING_EMPLOYEE_ID | NUMBER | |||
| NEW_TIME_ZONE | NUMBER | |||
| OLD_TIME_ZONE | NUMBER | |||
| NEW_COST_PER_HR | NUMBER | |||
| OLD_COST_PER_HR | NUMBER | |||
| NEW_PRIMARY_LANGUAGE | VARCHAR2 | (30) | ||
| OLD_PRIMARY_LANGUAGE | VARCHAR2 | (30) | ||
| NEW_SECONDARY_LANGUAGE | VARCHAR2 | (30) | ||
| OLD_SECONDARY_LANGUAGE | VARCHAR2 | (30) | ||
| NEW_IES_AGENT_LOGIN | VARCHAR2 | (240) | ||
| OLD_IES_AGENT_LOGIN | VARCHAR2 | (240) | ||
| NEW_SERVER_GROUP_ID | NUMBER | |||
| OLD_SERVER_GROUP_ID | NUMBER | |||
| NEW_ASSIGNED_TO_GROUP_ID | NUMBER | |||
| OLD_ASSIGNED_TO_GROUP_ID | NUMBER | |||
| NEW_COST_CENTER | VARCHAR2 | (30) | ||
| OLD_COST_CENTER | VARCHAR2 | (30) | ||
| NEW_CHARGE_TO_COST_CENTER | VARCHAR2 | (30) | ||
| OLD_CHARGE_TO_COST_CENTER | VARCHAR2 | (30) | ||
| NEW_COMPENSATION_CURRENCY_CODE | VARCHAR2 | (15) | ||
| OLD_COMPENSATION_CURRENCY_CODE | VARCHAR2 | (15) | ||
| NEW_COMMISSIONABLE_FLAG | VARCHAR2 | (1) | ||
| OLD_COMMISSIONABLE_FLAG | VARCHAR2 | (1) | ||
| NEW_HOLD_REASON_CODE | VARCHAR2 | (30) | ||
| OLD_HOLD_REASON_CODE | VARCHAR2 | (30) | ||
| NEW_HOLD_PAYMENT | VARCHAR2 | (1) | ||
| OLD_HOLD_PAYMENT | VARCHAR2 | (1) | ||
| NEW_COMP_SERVICE_TEAM_ID | NUMBER | |||
| OLD_COMP_SERVICE_TEAM_ID | NUMBER | |||
| NEW_TRANSACTION_NUMBER | NUMBER | |||
| OLD_TRANSACTION_NUMBER | NUMBER | |||
| NEW_OBJECT_VERSION_NUMBER | NUMBER | |||
| OLD_OBJECT_VERSION_NUMBER | NUMBER | |||
| CREATED_BY | NUMBER | Yes | ||
| CREATION_DATE | DATE | Yes | ||
| LAST_UPDATED_BY | NUMBER | Yes | ||
| LAST_UPDATE_DATE | DATE | Yes | ||
| LAST_UPDATE_LOGIN | NUMBER | |||
| NEW_ADDRESS_ID | NUMBER | |||
| OLD_ADDRESS_ID | NUMBER | |||
| NEW_CONTACT_ID | NUMBER | |||
| OLD_CONTACT_ID | NUMBER | |||
| OLD_START_DATE_ACTIVE | DATE | |||
| NEW_START_DATE_ACTIVE | DATE | |||
| OLD_END_DATE_ACTIVE | DATE | |||
| NEW_END_DATE_ACTIVE | DATE | |||
| NEW_USER_ID | NUMBER | |||
| OLD_USER_ID | NUMBER | |||
| NEW_SUPPORT_SITE_ID | NUMBER | |||
| OLD_SUPPORT_SITE_ID | NUMBER | |||
| OLD_LOCATION | SDO_GEOMETRY | (64) | ||
| NEW_LOCATION | SDO_GEOMETRY | (64) | ||
| SECURITY_GROUP_ID | NUMBER | |||
| NEW_RESOURCE_NAME | VARCHAR2 | (360) | ||
| OLD_RESOURCE_NAME | VARCHAR2 | (360) | ||
| NEW_SOURCE_NAME | VARCHAR2 | (360) | ||
| OLD_SOURCE_NAME | VARCHAR2 | (360) | ||
| NEW_SOURCE_NUMBER | VARCHAR2 | (30) | ||
| OLD_SOURCE_NUMBER | VARCHAR2 | (30) | ||
| NEW_SOURCE_JOB_TITLE | VARCHAR2 | (240) | ||
| OLD_SOURCE_JOB_TITLE | VARCHAR2 | (240) | ||
| NEW_SOURCE_EMAIL | VARCHAR2 | (2000) | ||
| OLD_SOURCE_EMAIL | VARCHAR2 | (2000) | ||
| NEW_SOURCE_PHONE | VARCHAR2 | (2000) | ||
| OLD_SOURCE_PHONE | VARCHAR2 | (240) | ||
| NEW_SOURCE_ORG_ID | NUMBER | |||
| OLD_SOURCE_ORG_ID | NUMBER | |||
| NEW_SOURCE_ORG_NAME | VARCHAR2 | (360) | ||
| OLD_SOURCE_ORG_NAME | VARCHAR2 | (360) | ||
| NEW_SOURCE_ADDRESS1 | VARCHAR2 | (240) | ||
| OLD_SOURCE_ADDRESS1 | VARCHAR2 | (240) | ||
| NEW_SOURCE_ADDRESS2 | VARCHAR2 | (240) | ||
| OLD_SOURCE_ADDRESS2 | VARCHAR2 | (240) | ||
| NEW_SOURCE_ADDRESS3 | VARCHAR2 | (240) | ||
| OLD_SOURCE_ADDRESS3 | VARCHAR2 | (240) | ||
| NEW_SOURCE_ADDRESS4 | VARCHAR2 | (240) | ||
| OLD_SOURCE_ADDRESS4 | VARCHAR2 | (240) | ||
| NEW_SOURCE_CITY | VARCHAR2 | (60) | ||
| OLD_SOURCE_CITY | VARCHAR2 | (60) | ||
| NEW_SOURCE_POSTAL_CODE | VARCHAR2 | (60) | ||
| OLD_SOURCE_POSTAL_CODE | VARCHAR2 | (60) | ||
| NEW_SOURCE_STATE | VARCHAR2 | (150) | ||
| OLD_SOURCE_STATE | VARCHAR2 | (150) | ||
| NEW_SOURCE_PROVINCE | VARCHAR2 | (150) | ||
| OLD_SOURCE_PROVINCE | VARCHAR2 | (150) | ||
| NEW_SOURCE_COUNTY | VARCHAR2 | (150) | ||
| OLD_SOURCE_COUNTY | VARCHAR2 | (150) | ||
| NEW_SOURCE_COUNTRY | VARCHAR2 | (60) | ||
| OLD_SOURCE_COUNTRY | VARCHAR2 | (60) | ||
| NEW_SOURCE_MGR_ID | NUMBER | |||
| OLD_SOURCE_MGR_ID | NUMBER | |||
| NEW_SOURCE_MGR_NAME | VARCHAR2 | (360) | ||
| OLD_SOURCE_MGR_NAME | VARCHAR2 | (360) | ||
| NEW_SOURCE_BUSINESS_GRP_ID | NUMBER | |||
| OLD_SOURCE_BUSINESS_GRP_ID | NUMBER | |||
| NEW_SOURCE_BUSINESS_GRP_NAME | VARCHAR2 | (360) | ||
| OLD_SOURCE_BUSINESS_GRP_NAME | VARCHAR2 | (360) | ||
| NEW_SOURCE_FIRST_NAME | VARCHAR2 | (360) | ||
| OLD_SOURCE_FIRST_NAME | VARCHAR2 | (360) | ||
| NEW_SOURCE_MIDDLE_NAME | VARCHAR2 | (360) | ||
| OLD_SOURCE_MIDDLE_NAME | VARCHAR2 | (360) | ||
| NEW_SOURCE_LAST_NAME | VARCHAR2 | (360) | ||
| OLD_SOURCE_LAST_NAME | VARCHAR2 | (360) | ||
| NEW_SOURCE_CATEGORY | VARCHAR2 | (360) | ||
| OLD_SOURCE_CATEGORY | VARCHAR2 | (360) | ||
| NEW_SOURCE_STATUS | VARCHAR2 | (360) | ||
| OLD_SOURCE_STATUS | VARCHAR2 | (360) | ||
| OLD_SOURCE_OFFICE | VARCHAR2 | (45) | ||
| NEW_SOURCE_OFFICE | VARCHAR2 | (45) | ||
| OLD_SOURCE_LOCATION | VARCHAR2 | (45) | ||
| NEW_SOURCE_LOCATION | VARCHAR2 | (45) | ||
| OLD_SOURCE_MAILSTOP | VARCHAR2 | (45) | ||
| NEW_SOURCE_MAILSTOP | VARCHAR2 | (45) | ||
| OLD_USER_NAME | VARCHAR2 | (100) | ||
| NEW_USER_NAME | VARCHAR2 | (100) | ||
| OLD_SOURCE_MOBILE_PHONE | VARCHAR2 | (60) | ||
| NEW_SOURCE_MOBILE_PHONE | VARCHAR2 | (60) | ||
| OLD_SOURCE_PAGER | VARCHAR2 | (60) | ||
| NEW_SOURCE_PAGER | VARCHAR2 | (60) | ||
| OLD_PARTY_ID | NUMBER | |||
| NEW_PARTY_ID | NUMBER | |||
| OLD_SOURCE_JOB_ID | NUMBER | |||
| NEW_SOURCE_JOB_ID | NUMBER | |||
| OLD_FS_SETUP_COMPLETE | VARCHAR2 | (1) | ||
| NEW_FS_SETUP_COMPLETE | VARCHAR2 | (1) |
Cut, paste (and edit) the following text to query this object:
SELECT RESOURCE_AUDIT_ID
, RESOURCE_ID
, NEW_CATEGORY
, OLD_CATEGORY
, NEW_RESOURCE_NUMBER
, OLD_RESOURCE_NUMBER
, NEW_SOURCE_ID
, OLD_SOURCE_ID
, NEW_MANAGING_EMPLOYEE_ID
, OLD_MANAGING_EMPLOYEE_ID
, NEW_TIME_ZONE
, OLD_TIME_ZONE
, NEW_COST_PER_HR
, OLD_COST_PER_HR
, NEW_PRIMARY_LANGUAGE
, OLD_PRIMARY_LANGUAGE
, NEW_SECONDARY_LANGUAGE
, OLD_SECONDARY_LANGUAGE
, NEW_IES_AGENT_LOGIN
, OLD_IES_AGENT_LOGIN
, NEW_SERVER_GROUP_ID
, OLD_SERVER_GROUP_ID
, NEW_ASSIGNED_TO_GROUP_ID
, OLD_ASSIGNED_TO_GROUP_ID
, NEW_COST_CENTER
, OLD_COST_CENTER
, NEW_CHARGE_TO_COST_CENTER
, OLD_CHARGE_TO_COST_CENTER
, NEW_COMPENSATION_CURRENCY_CODE
, OLD_COMPENSATION_CURRENCY_CODE
, NEW_COMMISSIONABLE_FLAG
, OLD_COMMISSIONABLE_FLAG
, NEW_HOLD_REASON_CODE
, OLD_HOLD_REASON_CODE
, NEW_HOLD_PAYMENT
, OLD_HOLD_PAYMENT
, NEW_COMP_SERVICE_TEAM_ID
, OLD_COMP_SERVICE_TEAM_ID
, NEW_TRANSACTION_NUMBER
, OLD_TRANSACTION_NUMBER
, NEW_OBJECT_VERSION_NUMBER
, OLD_OBJECT_VERSION_NUMBER
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, NEW_ADDRESS_ID
, OLD_ADDRESS_ID
, NEW_CONTACT_ID
, OLD_CONTACT_ID
, OLD_START_DATE_ACTIVE
, NEW_START_DATE_ACTIVE
, OLD_END_DATE_ACTIVE
, NEW_END_DATE_ACTIVE
, NEW_USER_ID
, OLD_USER_ID
, NEW_SUPPORT_SITE_ID
, OLD_SUPPORT_SITE_ID
, OLD_LOCATION
, NEW_LOCATION
, SECURITY_GROUP_ID
, NEW_RESOURCE_NAME
, OLD_RESOURCE_NAME
, NEW_SOURCE_NAME
, OLD_SOURCE_NAME
, NEW_SOURCE_NUMBER
, OLD_SOURCE_NUMBER
, NEW_SOURCE_JOB_TITLE
, OLD_SOURCE_JOB_TITLE
, NEW_SOURCE_EMAIL
, OLD_SOURCE_EMAIL
, NEW_SOURCE_PHONE
, OLD_SOURCE_PHONE
, NEW_SOURCE_ORG_ID
, OLD_SOURCE_ORG_ID
, NEW_SOURCE_ORG_NAME
, OLD_SOURCE_ORG_NAME
, NEW_SOURCE_ADDRESS1
, OLD_SOURCE_ADDRESS1
, NEW_SOURCE_ADDRESS2
, OLD_SOURCE_ADDRESS2
, NEW_SOURCE_ADDRESS3
, OLD_SOURCE_ADDRESS3
, NEW_SOURCE_ADDRESS4
, OLD_SOURCE_ADDRESS4
, NEW_SOURCE_CITY
, OLD_SOURCE_CITY
, NEW_SOURCE_POSTAL_CODE
, OLD_SOURCE_POSTAL_CODE
, NEW_SOURCE_STATE
, OLD_SOURCE_STATE
, NEW_SOURCE_PROVINCE
, OLD_SOURCE_PROVINCE
, NEW_SOURCE_COUNTY
, OLD_SOURCE_COUNTY
, NEW_SOURCE_COUNTRY
, OLD_SOURCE_COUNTRY
, NEW_SOURCE_MGR_ID
, OLD_SOURCE_MGR_ID
, NEW_SOURCE_MGR_NAME
, OLD_SOURCE_MGR_NAME
, NEW_SOURCE_BUSINESS_GRP_ID
, OLD_SOURCE_BUSINESS_GRP_ID
, NEW_SOURCE_BUSINESS_GRP_NAME
, OLD_SOURCE_BUSINESS_GRP_NAME
, NEW_SOURCE_FIRST_NAME
, OLD_SOURCE_FIRST_NAME
, NEW_SOURCE_MIDDLE_NAME
, OLD_SOURCE_MIDDLE_NAME
, NEW_SOURCE_LAST_NAME
, OLD_SOURCE_LAST_NAME
, NEW_SOURCE_CATEGORY
, OLD_SOURCE_CATEGORY
, NEW_SOURCE_STATUS
, OLD_SOURCE_STATUS
, OLD_SOURCE_OFFICE
, NEW_SOURCE_OFFICE
, OLD_SOURCE_LOCATION
, NEW_SOURCE_LOCATION
, OLD_SOURCE_MAILSTOP
, NEW_SOURCE_MAILSTOP
, OLD_USER_NAME
, NEW_USER_NAME
, OLD_SOURCE_MOBILE_PHONE
, NEW_SOURCE_MOBILE_PHONE
, OLD_SOURCE_PAGER
, NEW_SOURCE_PAGER
, OLD_PARTY_ID
, NEW_PARTY_ID
, OLD_SOURCE_JOB_ID
, NEW_SOURCE_JOB_ID
, OLD_FS_SETUP_COMPLETE
, NEW_FS_SETUP_COMPLETE
FROM JTF.JTF_RS_RESOURCE_EXTN_AUD#;
JTF
JTF_RS_RESOURCE_EXTN_AUD
MDSYS
SDO_GEOMETRY
SYS
STANDARD
- show dependent code
APPS
JTF_RS_RESOURCE_EXTN_AUD
|
|
|
|