[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PQP_CONFIGURATION_VALUES_DFV |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| Subobject Name: | |
| Status: | VALID |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ROW_ID | ROWID | (10) | ||
| CONTEXT_VALUE | VARCHAR2 | (30) | ||
| OWNERSHIP | VARCHAR2 | (150) | ||
| USAGE_TYPE | VARCHAR2 | (150) | ||
| VEHICLE_TYPE | VARCHAR2 | (150) | ||
| FUEL_TYPE | VARCHAR2 | (150) | ||
| RATES_TABLE | VARCHAR2 | (150) | ||
| CLAIM_ELEMENT | VARCHAR2 | (150) | ||
| UOM | VARCHAR2 | (150) | ||
| EVENT_DATES_SOURCE | VARCHAR2 | (150) | ||
| EVENT_DATES___EVENT_GROUP | VARCHAR2 | (150) | ||
| EVENTS_DATES___CUSTOM_FUNCTION | VARCHAR2 | (150) | ||
| BUDGET_VALUE_FORMULA | VARCHAR2 | (150) | ||
| COVERAGE | VARCHAR2 | (150) | ||
| IS_ENABLED | VARCHAR2 | (150) | ||
| ELEMENT_NAME_FAST_FORMULA_NAME | VARCHAR2 | (150) | ||
| ABSENCE_BALANCE_PRECISION | NUMBER | |||
| OPEN_ENDED_NO_PAY_DAYS | NUMBER | |||
| DEDUCT_OSP_ABSENCE_TAKEN_FOR | VARCHAR2 | (150) | ||
| LOG_DURATION_SUMMARY | VARCHAR2 | (150) | ||
| OFFICE_ADDRESS | VARCHAR2 | (150) | ||
| HOME_ADDRESS | VARCHAR2 | (150) | ||
| BANK_ACCOUNT_DETIALS | VARCHAR2 | (150) | ||
| BONUS_BALANCE_TYPE_NAME | VARCHAR2 | (150) | ||
| ENABLE_TRACE_DEBUG | VARCHAR2 | (150) | ||
| ROLLING_PERIOD_DURATION | NUMBER | |||
| ASSIGNMENT_FLEXFIELD_CONTEXT | VARCHAR2 | (150) | ||
| ASSIGNMENT_FLEXFIELD_COLUMN | VARCHAR2 | (150) | ||
| ASSIGNMENT_FLEXFIELD_COLUMN2 | VARCHAR2 | (150) | ||
| ASSIGNMENT_CATEGORY | VARCHAR2 | (150) | ||
| PENSERVER_EMPLOYMENT_TYPE | VARCHAR2 | (150) | ||
| MARITAL_STATUS_CODE | VARCHAR2 | (150) | ||
| PENSERVER_MARITAL_STATUS | VARCHAR2 | (150) | ||
| PAYROLL_CODE | VARCHAR2 | (150) | ||
| CUTOVER_DATE | DATE | |||
| NUVOS_START_DATE | DATE | |||
| MAINTAIN_SERVICE_PERIOD_NUMBER | VARCHAR2 | (150) | ||
| INTERFACE_NAME | VARCHAR2 | (150) | ||
| RATE_TYPE | VARCHAR2 | (150) | ||
| USER_RATE_FUNCTION | VARCHAR2 | (150) | ||
| NOTIONAL_PAY_FTE_CONFIGURATION | VARCHAR2 | (150) | ||
| EVENT_DESCRIPTION | VARCHAR2 | (150) | ||
| EVENT_SOURCE | VARCHAR2 | (150) | ||
| DUMMY_ABS | VARCHAR2 | (150) | ||
| DUMMY_ASG | VARCHAR2 | (150) | ||
| ABSENCE_TYPE | VARCHAR2 | (150) | ||
| ASSIGNMENT_STATUS | VARCHAR2 | (150) | ||
| EMPLOYMENT_TYPE | VARCHAR2 | (150) | ||
| PENSION_SCHEME | VARCHAR2 | (150) | ||
| START_REASON | VARCHAR2 | (150) | ||
| SCHEME_CATEGORY | VARCHAR2 | (150) | ||
| SCHEME_STATUS | VARCHAR2 | (150) | ||
| LEAVING_REASON | VARCHAR2 | (150) | ||
| PENSERVER_LEAVING_REASON_CODE | VARCHAR2 | (150) | ||
| ADJUSTED_HOURS_SOURCE | VARCHAR2 | (150) | ||
| BALANCE_TYPE | VARCHAR2 | (150) | ||
| SOURCE | VARCHAR2 | (150) | ||
| ASSIGNMENT_CONTEXT | VARCHAR2 | (150) | ||
| ASSIGNMENT_COLUMN | VARCHAR2 | (150) | ||
| PEOPLE_GROUP_COLUMN | VARCHAR2 | (150) | ||
| PENSERVER_PENSION_SCHEME | VARCHAR2 | (150) | ||
| TEMPLATE_PENSION_SCHEME | VARCHAR2 | (150) | ||
| PARTNERSHIP_SCHEME | VARCHAR2 | (150) | ||
| ADDRESS_LINE_1 | VARCHAR2 | (150) | ||
| ADDRESS_LINE_2 | VARCHAR2 | (150) | ||
| ADDRESS_LINE_3 | VARCHAR2 | (150) | ||
| ADDRESS_LINE_4 | VARCHAR2 | (150) | ||
| CITY | VARCHAR2 | (150) | ||
| STATE | VARCHAR2 | (150) | ||
| PROVINCE | VARCHAR2 | (150) | ||
| COUNTY | VARCHAR2 | (150) | ||
| POSTAL_CODE | VARCHAR2 | (150) | ||
| COUNTRY | VARCHAR2 | (150) | ||
| REGION_1 | VARCHAR2 | (150) | ||
| REGION_2 | VARCHAR2 | (150) | ||
| REGION_3 | VARCHAR2 | (150) | ||
| TOWN_CITY | VARCHAR2 | (150) | ||
| TELEPHONE_NUMBER_1 | VARCHAR2 | (150) | ||
| TELEPHONE_NUMBER_2 | VARCHAR2 | (150) | ||
| TELEPHONE_NUMBER_3 | VARCHAR2 | (150) | ||
| ADD_INFORMATION_13 | VARCHAR2 | (150) | ||
| ADD_INFORMATION_14 | VARCHAR2 | (150) | ||
| ADD_INFORMATION_15 | VARCHAR2 | (150) | ||
| ADD_INFORMATION_16 | VARCHAR2 | (150) | ||
| ADD_INFORMATION_17 | VARCHAR2 | (150) | ||
| ADD_INFORMATION_18 | VARCHAR2 | (150) | ||
| ADD_INFORMATION_19 | VARCHAR2 | (150) | ||
| ADD_INFORMATION_20 | VARCHAR2 | (150) | ||
| TOWN_OR_CITY | VARCHAR2 | (150) | ||
| CALCULATION_METHOD | VARCHAR2 | (150) | ||
| MAX_COMPANY_VEHICLES_ALLOWED | VARCHAR2 | (150) | ||
| MAX_PRIVATE_VEHICLES_ALLOWED | VARCHAR2 | (150) | ||
| SHARE_COMPANY_VEHICLE | VARCHAR2 | (150) | ||
| SHARE_PRIVATE_VEHICLE | VARCHAR2 | (150) | ||
| PREVIOUS_TAX_YEAR_CLAIM_VAILD | VARCHAR2 | (150) | ||
| ALLOW_CO_AND_PVT_VEHICLE_CLAIM | VARCHAR2 | (150) | ||
| SEARCH_CRITERIA_FOR_RATES | VARCHAR2 | (150) | ||
| VALIDATE_PRIVATE_VEHICLES | VARCHAR2 | (150) | ||
| CLAIMS_CORRECTION_ALLOWED | VARCHAR2 | (150) | ||
| FULL_DATE_TRACK_OPTION | VARCHAR2 | (150) | ||
| DISTANCE_UOM | VARCHAR2 | (150) | ||
| USE_SLIDING_RATES | VARCHAR2 | (150) | ||
| COMBINE_TAXABLE_AND_NONTAXABLE | VARCHAR2 | (150) | ||
| USE_PURPOSE_TABLE_PROFESSIONAL | VARCHAR2 | (150) | ||
| USE_PURPOSE_TABLE_SELFSERVICE | VARCHAR2 | (150) | ||
| USE_DFF_COLUMNS_FOR_ACTUALS | VARCHAR2 | (150) | ||
| OVERRIDING_ELEMENT_SET | VARCHAR2 | (150) | ||
| DEFER_AUTO_POPULATION | VARCHAR2 | (150) | ||
| GL_CODE_COMBINATION | VARCHAR2 | (150) | ||
| PROJECT | VARCHAR2 | (150) | ||
| TASK | VARCHAR2 | (150) | ||
| AWARD | VARCHAR2 | (150) | ||
| EXPENDITURE_ORGANIZATION | VARCHAR2 | (150) | ||
| EXPENDITURE_TYPE | VARCHAR2 | (150) | ||
| GLOBAL_ELEMENT_LABOR_SCHEDULE | VARCHAR2 | (150) | ||
| ASG_ELEMENT_LABOR_SCHEDULE | VARCHAR2 | (150) | ||
| ASG_ELMGRP_LABOR_SCHEDULE | VARCHAR2 | (150) | ||
| ASG_LABOR_SCHEDULE | VARCHAR2 | (150) | ||
| ORG_DEFAULT_LABOR_SCHEDULE | VARCHAR2 | (150) | ||
| DEFAULT_ACCOUNT | VARCHAR2 | (150) | ||
| SUSPENSE_ACCOUNT | VARCHAR2 | (150) | ||
| DISTRIBUTION_ADJUSTMENT | VARCHAR2 | (150) | ||
| PRE_GENERATED_LINES | VARCHAR2 | (150) | ||
| EXCESS_SALARY_ACCOUNT | VARCHAR2 | (150) | ||
| ENABLE_SALARY_CAP | VARCHAR2 | (150) | ||
| ENABLE_WORK_SCHEDULES | VARCHAR2 | (150) | ||
| USE_DFF_COLUMNS_FOR_ENCUM | VARCHAR2 | (150) | ||
| ORGANIZATION | VARCHAR2 | (150) | ||
| PROJECT_ID | VARCHAR2 | (150) | ||
| TASK_ID | VARCHAR2 | (150) | ||
| AWARD_ID | VARCHAR2 | (150) | ||
| EXPENDITURE_ORGANIZATION_ID | VARCHAR2 | (150) | ||
| IMPORT_COSTED_HOURS | VARCHAR2 | (150) | ||
| ENCUMBER_HOURS | VARCHAR2 | (150) | ||
| SPONSOR_CODE | VARCHAR2 | (150) | ||
| SPONSOR_NAME | VARCHAR2 | (150) | ||
| SHOW_100__DISTRIBUTIONS | VARCHAR2 | (150) | ||
| IGNORE_DATE_EARNED | VARCHAR2 | (150) | ||
| USE_GL_SEGMENTS_TO_STORE_PTAOE | VARCHAR2 | (150) | ||
| CONCATENATED_SEGMENTS | VARCHAR2 | (3050) |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, CONTEXT_VALUE
, OWNERSHIP
, USAGE_TYPE
, VEHICLE_TYPE
, FUEL_TYPE
, RATES_TABLE
, CLAIM_ELEMENT
, UOM
, EVENT_DATES_SOURCE
, EVENT_DATES___EVENT_GROUP
, EVENTS_DATES___CUSTOM_FUNCTION
, BUDGET_VALUE_FORMULA
, COVERAGE
, IS_ENABLED
, ELEMENT_NAME_FAST_FORMULA_NAME
, ABSENCE_BALANCE_PRECISION
, OPEN_ENDED_NO_PAY_DAYS
, DEDUCT_OSP_ABSENCE_TAKEN_FOR
, LOG_DURATION_SUMMARY
, OFFICE_ADDRESS
, HOME_ADDRESS
, BANK_ACCOUNT_DETIALS
, BONUS_BALANCE_TYPE_NAME
, ENABLE_TRACE_DEBUG
, ROLLING_PERIOD_DURATION
, ASSIGNMENT_FLEXFIELD_CONTEXT
, ASSIGNMENT_FLEXFIELD_COLUMN
, ASSIGNMENT_FLEXFIELD_COLUMN2
, ASSIGNMENT_CATEGORY
, PENSERVER_EMPLOYMENT_TYPE
, MARITAL_STATUS_CODE
, PENSERVER_MARITAL_STATUS
, PAYROLL_CODE
, CUTOVER_DATE
, NUVOS_START_DATE
, MAINTAIN_SERVICE_PERIOD_NUMBER
, INTERFACE_NAME
, RATE_TYPE
, USER_RATE_FUNCTION
, NOTIONAL_PAY_FTE_CONFIGURATION
, EVENT_DESCRIPTION
, EVENT_SOURCE
, DUMMY_ABS
, DUMMY_ASG
, ABSENCE_TYPE
, ASSIGNMENT_STATUS
, EMPLOYMENT_TYPE
, PENSION_SCHEME
, START_REASON
, SCHEME_CATEGORY
, SCHEME_STATUS
, LEAVING_REASON
, PENSERVER_LEAVING_REASON_CODE
, ADJUSTED_HOURS_SOURCE
, BALANCE_TYPE
, SOURCE
, ASSIGNMENT_CONTEXT
, ASSIGNMENT_COLUMN
, PEOPLE_GROUP_COLUMN
, PENSERVER_PENSION_SCHEME
, TEMPLATE_PENSION_SCHEME
, PARTNERSHIP_SCHEME
, ADDRESS_LINE_1
, ADDRESS_LINE_2
, ADDRESS_LINE_3
, ADDRESS_LINE_4
, CITY
, STATE
, PROVINCE
, COUNTY
, POSTAL_CODE
, COUNTRY
, REGION_1
, REGION_2
, REGION_3
, TOWN_CITY
, TELEPHONE_NUMBER_1
, TELEPHONE_NUMBER_2
, TELEPHONE_NUMBER_3
, ADD_INFORMATION_13
, ADD_INFORMATION_14
, ADD_INFORMATION_15
, ADD_INFORMATION_16
, ADD_INFORMATION_17
, ADD_INFORMATION_18
, ADD_INFORMATION_19
, ADD_INFORMATION_20
, TOWN_OR_CITY
, CALCULATION_METHOD
, MAX_COMPANY_VEHICLES_ALLOWED
, MAX_PRIVATE_VEHICLES_ALLOWED
, SHARE_COMPANY_VEHICLE
, SHARE_PRIVATE_VEHICLE
, PREVIOUS_TAX_YEAR_CLAIM_VAILD
, ALLOW_CO_AND_PVT_VEHICLE_CLAIM
, SEARCH_CRITERIA_FOR_RATES
, VALIDATE_PRIVATE_VEHICLES
, CLAIMS_CORRECTION_ALLOWED
, FULL_DATE_TRACK_OPTION
, DISTANCE_UOM
, USE_SLIDING_RATES
, COMBINE_TAXABLE_AND_NONTAXABLE
, USE_PURPOSE_TABLE_PROFESSIONAL
, USE_PURPOSE_TABLE_SELFSERVICE
, USE_DFF_COLUMNS_FOR_ACTUALS
, OVERRIDING_ELEMENT_SET
, DEFER_AUTO_POPULATION
, GL_CODE_COMBINATION
, PROJECT
, TASK
, AWARD
, EXPENDITURE_ORGANIZATION
, EXPENDITURE_TYPE
, GLOBAL_ELEMENT_LABOR_SCHEDULE
, ASG_ELEMENT_LABOR_SCHEDULE
, ASG_ELMGRP_LABOR_SCHEDULE
, ASG_LABOR_SCHEDULE
, ORG_DEFAULT_LABOR_SCHEDULE
, DEFAULT_ACCOUNT
, SUSPENSE_ACCOUNT
, DISTRIBUTION_ADJUSTMENT
, PRE_GENERATED_LINES
, EXCESS_SALARY_ACCOUNT
, ENABLE_SALARY_CAP
, ENABLE_WORK_SCHEDULES
, USE_DFF_COLUMNS_FOR_ENCUM
, ORGANIZATION
, PROJECT_ID
, TASK_ID
, AWARD_ID
, EXPENDITURE_ORGANIZATION_ID
, IMPORT_COSTED_HOURS
, ENCUMBER_HOURS
, SPONSOR_CODE
, SPONSOR_NAME
, SHOW_100__DISTRIBUTIONS
, IGNORE_DATE_EARNED
, USE_GL_SEGMENTS_TO_STORE_PTAOE
, CONCATENATED_SEGMENTS
FROM APPS.PQP_CONFIGURATION_VALUES_DFV;
APPS
FND_NUMBER
- show dependent code
PQP_CONFIGURATION_VALUES
PUBLIC
PQP_CONFIGURATION_VALUES_DFV
|
|
|
|