DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.HRDPV_CREATE_VEHICLE

Object Details
Object Name: HRDPV_CREATE_VEHICLE
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
BATCH_ID NUMBER (15) Yes
BATCH_LINE_ID NUMBER (15) Yes
API_MODULE_ID NUMBER (15) Yes
LINE_STATUS VARCHAR2 (1) Yes
USER_SEQUENCE NUMBER (15)
LINK_VALUE NUMBER (15)
BUSINESS_GROUP_NAME VARCHAR2 (240)
P_EFFECTIVE_DATE VARCHAR2 (2000)
P_REGISTRATION_NUMBER VARCHAR2 (2000)
P_VEHICLE_TYPE VARCHAR2 (2000)
P_VEHICLE_ID_NUMBER VARCHAR2 (2000)
P_MAKE VARCHAR2 (2000)
P_ENGINE_CAPACITY_IN_CC VARCHAR2 (2000)
P_FUEL_TYPE VARCHAR2 (2000)
P_CURRENCY_CODE VARCHAR2 (2000)
P_VEHICLE_STATUS VARCHAR2 (2000)
P_VEHICLE_INACTIVITY_REASON VARCHAR2 (2000)
P_MODEL VARCHAR2 (2000)
P_INITIAL_REGISTRATION VARCHAR2 (2000)
P_LAST_REGISTRATION_RENEW_DATE VARCHAR2 (2000)
P_LIST_PRICE VARCHAR2 (2000)
P_ACCESSORY_VALUE_AT_STARTDATE VARCHAR2 (2000)
P_ACCESSORY_VALUE_ADDED_LATER VARCHAR2 (2000)
P_MARKET_VALUE_CLASSIC_CAR VARCHAR2 (2000)
P_FISCAL_RATINGS VARCHAR2 (2000)
P_FISCAL_RATINGS_UOM VARCHAR2 (2000)
P_VEHICLE_PROVIDER VARCHAR2 (2000)
P_VEHICLE_OWNERSHIP VARCHAR2 (2000)
P_SHARED_VEHICLE VARCHAR2 (2000)
P_ASSET_NUMBER VARCHAR2 (2000)
P_LEASE_CONTRACT_NUMBER VARCHAR2 (2000)
P_LEASE_CONTRACT_EXPIRY_DATE VARCHAR2 (2000)
P_TAXATION_METHOD VARCHAR2 (2000)
P_FLEET_INFO VARCHAR2 (2000)
P_FLEET_TRANSFER_DATE VARCHAR2 (2000)
P_COLOR VARCHAR2 (2000)
P_SEATING_CAPACITY VARCHAR2 (2000)
P_WEIGHT VARCHAR2 (2000)
P_WEIGHT_UOM VARCHAR2 (2000)
P_MODEL_YEAR VARCHAR2 (2000)
P_INSURANCE_NUMBER VARCHAR2 (2000)
P_INSURANCE_EXPIRY_DATE VARCHAR2 (2000)
P_COMMENTS VARCHAR2 (2000)
P_VRE_ATTRIBUTE_CATEGORY VARCHAR2 (2000)
P_VRE_ATTRIBUTE1 VARCHAR2 (2000)
P_VRE_ATTRIBUTE2 VARCHAR2 (2000)
P_VRE_ATTRIBUTE3 VARCHAR2 (2000)
P_VRE_ATTRIBUTE4 VARCHAR2 (2000)
P_VRE_ATTRIBUTE5 VARCHAR2 (2000)
P_VRE_ATTRIBUTE6 VARCHAR2 (2000)
P_VRE_ATTRIBUTE7 VARCHAR2 (2000)
P_VRE_ATTRIBUTE8 VARCHAR2 (2000)
P_VRE_ATTRIBUTE9 VARCHAR2 (2000)
P_VRE_ATTRIBUTE10 VARCHAR2 (2000)
P_VRE_ATTRIBUTE11 VARCHAR2 (2000)
P_VRE_ATTRIBUTE12 VARCHAR2 (2000)
P_VRE_ATTRIBUTE13 VARCHAR2 (2000)
P_VRE_ATTRIBUTE14 VARCHAR2 (2000)
P_VRE_ATTRIBUTE15 VARCHAR2 (2000)
P_VRE_ATTRIBUTE16 VARCHAR2 (2000)
P_VRE_ATTRIBUTE17 VARCHAR2 (2000)
P_VRE_ATTRIBUTE18 VARCHAR2 (2000)
P_VRE_ATTRIBUTE19 VARCHAR2 (2000)
P_VRE_ATTRIBUTE20 VARCHAR2 (2000)
P_VRE_INFORMATION_CATEGORY VARCHAR2 (2000)
P_VRE_INFORMATION1 VARCHAR2 (2000)
P_VRE_INFORMATION2 VARCHAR2 (2000)
P_VRE_INFORMATION3 VARCHAR2 (2000)
P_VRE_INFORMATION4 VARCHAR2 (2000)
P_VRE_INFORMATION5 VARCHAR2 (2000)
P_VRE_INFORMATION6 VARCHAR2 (2000)
P_VRE_INFORMATION7 VARCHAR2 (2000)
P_VRE_INFORMATION8 VARCHAR2 (2000)
P_VRE_INFORMATION9 VARCHAR2 (2000)
P_VRE_INFORMATION10 VARCHAR2 (2000)
P_VRE_INFORMATION11 VARCHAR2 (2000)
P_VRE_INFORMATION12 VARCHAR2 (2000)
P_VRE_INFORMATION13 VARCHAR2 (2000)
P_VRE_INFORMATION14 VARCHAR2 (2000)
P_VRE_INFORMATION15 VARCHAR2 (2000)
P_VRE_INFORMATION16 VARCHAR2 (2000)
P_VRE_INFORMATION17 VARCHAR2 (2000)
P_VRE_INFORMATION18 VARCHAR2 (2000)
P_VRE_INFORMATION19 VARCHAR2 (2000)
P_VRE_INFORMATION20 VARCHAR2 (2000)
P_VEHICLE_REPOSITORY_ID VARCHAR2 (2000)
P_OBJECT_VERSION_NUMBER VARCHAR2 (2000)
P_EFFECTIVE_START_DATE VARCHAR2 (2000)
P_EFFECTIVE_END_DATE VARCHAR2 (2000)
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT BATCH_ID
,      BATCH_LINE_ID
,      API_MODULE_ID
,      LINE_STATUS
,      USER_SEQUENCE
,      LINK_VALUE
,      BUSINESS_GROUP_NAME
,      P_EFFECTIVE_DATE
,      P_REGISTRATION_NUMBER
,      P_VEHICLE_TYPE
,      P_VEHICLE_ID_NUMBER
,      P_MAKE
,      P_ENGINE_CAPACITY_IN_CC
,      P_FUEL_TYPE
,      P_CURRENCY_CODE
,      P_VEHICLE_STATUS
,      P_VEHICLE_INACTIVITY_REASON
,      P_MODEL
,      P_INITIAL_REGISTRATION
,      P_LAST_REGISTRATION_RENEW_DATE
,      P_LIST_PRICE
,      P_ACCESSORY_VALUE_AT_STARTDATE
,      P_ACCESSORY_VALUE_ADDED_LATER
,      P_MARKET_VALUE_CLASSIC_CAR
,      P_FISCAL_RATINGS
,      P_FISCAL_RATINGS_UOM
,      P_VEHICLE_PROVIDER
,      P_VEHICLE_OWNERSHIP
,      P_SHARED_VEHICLE
,      P_ASSET_NUMBER
,      P_LEASE_CONTRACT_NUMBER
,      P_LEASE_CONTRACT_EXPIRY_DATE
,      P_TAXATION_METHOD
,      P_FLEET_INFO
,      P_FLEET_TRANSFER_DATE
,      P_COLOR
,      P_SEATING_CAPACITY
,      P_WEIGHT
,      P_WEIGHT_UOM
,      P_MODEL_YEAR
,      P_INSURANCE_NUMBER
,      P_INSURANCE_EXPIRY_DATE
,      P_COMMENTS
,      P_VRE_ATTRIBUTE_CATEGORY
,      P_VRE_ATTRIBUTE1
,      P_VRE_ATTRIBUTE2
,      P_VRE_ATTRIBUTE3
,      P_VRE_ATTRIBUTE4
,      P_VRE_ATTRIBUTE5
,      P_VRE_ATTRIBUTE6
,      P_VRE_ATTRIBUTE7
,      P_VRE_ATTRIBUTE8
,      P_VRE_ATTRIBUTE9
,      P_VRE_ATTRIBUTE10
,      P_VRE_ATTRIBUTE11
,      P_VRE_ATTRIBUTE12
,      P_VRE_ATTRIBUTE13
,      P_VRE_ATTRIBUTE14
,      P_VRE_ATTRIBUTE15
,      P_VRE_ATTRIBUTE16
,      P_VRE_ATTRIBUTE17
,      P_VRE_ATTRIBUTE18
,      P_VRE_ATTRIBUTE19
,      P_VRE_ATTRIBUTE20
,      P_VRE_INFORMATION_CATEGORY
,      P_VRE_INFORMATION1
,      P_VRE_INFORMATION2
,      P_VRE_INFORMATION3
,      P_VRE_INFORMATION4
,      P_VRE_INFORMATION5
,      P_VRE_INFORMATION6
,      P_VRE_INFORMATION7
,      P_VRE_INFORMATION8
,      P_VRE_INFORMATION9
,      P_VRE_INFORMATION10
,      P_VRE_INFORMATION11
,      P_VRE_INFORMATION12
,      P_VRE_INFORMATION13
,      P_VRE_INFORMATION14
,      P_VRE_INFORMATION15
,      P_VRE_INFORMATION16
,      P_VRE_INFORMATION17
,      P_VRE_INFORMATION18
,      P_VRE_INFORMATION19
,      P_VRE_INFORMATION20
,      P_VEHICLE_REPOSITORY_ID
,      P_OBJECT_VERSION_NUMBER
,      P_EFFECTIVE_START_DATE
,      P_EFFECTIVE_END_DATE
FROM APPS.HRDPV_CREATE_VEHICLE;

Dependencies

[top of page]

APPS.HRDPV_CREATE_VEHICLE references the following:

SchemaAPPS
SynonymHR_PUMP_BATCH_LINES

APPS.HRDPV_CREATE_VEHICLE is not referenced by any database object