VIEW: APPS.HRDPV_CREATE_VEHICLE

Source

View Text - Preformatted

select batch_id            batch_id
,      batch_line_id       batch_line_id
,      api_module_id       api_module_id
,      line_status         line_status
,      user_sequence       user_sequence
,      link_value          link_value
,      business_group_name business_group_name,
       pval001 P_EFFECTIVE_DATE,
       pval002 P_REGISTRATION_NUMBER,
       pval003 P_VEHICLE_TYPE,
       pval004 P_VEHICLE_ID_NUMBER,
       pval005 P_MAKE,
       pval006 P_ENGINE_CAPACITY_IN_CC,
       pval007 P_FUEL_TYPE,
       pval008 P_CURRENCY_CODE,
       pval009 P_VEHICLE_STATUS,
       pval010 P_VEHICLE_INACTIVITY_REASON,
       pval011 P_MODEL,
       pval012 P_INITIAL_REGISTRATION,
       pval013 P_LAST_REGISTRATION_RENEW_DATE,
       pval014 P_LIST_PRICE,
       pval015 P_ACCESSORY_VALUE_AT_STARTDATE,
       pval016 P_ACCESSORY_VALUE_ADDED_LATER,
       pval017 P_MARKET_VALUE_CLASSIC_CAR,
       pval018 P_FISCAL_RATINGS,
       pval019 P_FISCAL_RATINGS_UOM,
       pval020 P_VEHICLE_PROVIDER,
       pval021 P_VEHICLE_OWNERSHIP,
       pval022 P_SHARED_VEHICLE,
       pval023 P_ASSET_NUMBER,
       pval024 P_LEASE_CONTRACT_NUMBER,
       pval025 P_LEASE_CONTRACT_EXPIRY_DATE,
       pval026 P_TAXATION_METHOD,
       pval027 P_FLEET_INFO,
       pval028 P_FLEET_TRANSFER_DATE,
       pval029 P_COLOR,
       pval030 P_SEATING_CAPACITY,
       pval031 P_WEIGHT,
       pval032 P_WEIGHT_UOM,
       pval033 P_MODEL_YEAR,
       pval034 P_INSURANCE_NUMBER,
       pval035 P_INSURANCE_EXPIRY_DATE,
       pval036 P_COMMENTS,
       pval037 P_VRE_ATTRIBUTE_CATEGORY,
       pval038 P_VRE_ATTRIBUTE1,
       pval039 P_VRE_ATTRIBUTE2,
       pval040 P_VRE_ATTRIBUTE3,
       pval041 P_VRE_ATTRIBUTE4,
       pval042 P_VRE_ATTRIBUTE5,
       pval043 P_VRE_ATTRIBUTE6,
       pval044 P_VRE_ATTRIBUTE7,
       pval045 P_VRE_ATTRIBUTE8,
       pval046 P_VRE_ATTRIBUTE9,
       pval047 P_VRE_ATTRIBUTE10,
       pval048 P_VRE_ATTRIBUTE11,
       pval049 P_VRE_ATTRIBUTE12,
       pval050 P_VRE_ATTRIBUTE13,
       pval051 P_VRE_ATTRIBUTE14,
       pval052 P_VRE_ATTRIBUTE15,
       pval053 P_VRE_ATTRIBUTE16,
       pval054 P_VRE_ATTRIBUTE17,
       pval055 P_VRE_ATTRIBUTE18,
       pval056 P_VRE_ATTRIBUTE19,
       pval057 P_VRE_ATTRIBUTE20,
       pval058 P_VRE_INFORMATION_CATEGORY,
       pval059 P_VRE_INFORMATION1,
       pval060 P_VRE_INFORMATION2,
       pval061 P_VRE_INFORMATION3,
       pval062 P_VRE_INFORMATION4,
       pval063 P_VRE_INFORMATION5,
       pval064 P_VRE_INFORMATION6,
       pval065 P_VRE_INFORMATION7,
       pval066 P_VRE_INFORMATION8,
       pval067 P_VRE_INFORMATION9,
       pval068 P_VRE_INFORMATION10,
       pval069 P_VRE_INFORMATION11,
       pval070 P_VRE_INFORMATION12,
       pval071 P_VRE_INFORMATION13,
       pval072 P_VRE_INFORMATION14,
       pval073 P_VRE_INFORMATION15,
       pval074 P_VRE_INFORMATION16,
       pval075 P_VRE_INFORMATION17,
       pval076 P_VRE_INFORMATION18,
       pval077 P_VRE_INFORMATION19,
       pval078 P_VRE_INFORMATION20,
       pval079 P_VEHICLE_REPOSITORY_ID,
       pval080 P_OBJECT_VERSION_NUMBER,
       pval081 P_EFFECTIVE_START_DATE,
       pval082 P_EFFECTIVE_END_DATE
from hr_pump_batch_lines
where api_module_id = 2893
with check option 

View Text - HTML Formatted

SELECT BATCH_ID BATCH_ID
, BATCH_LINE_ID BATCH_LINE_ID
, API_MODULE_ID API_MODULE_ID
, LINE_STATUS LINE_STATUS
, USER_SEQUENCE USER_SEQUENCE
, LINK_VALUE LINK_VALUE
, BUSINESS_GROUP_NAME BUSINESS_GROUP_NAME
, PVAL001 P_EFFECTIVE_DATE
, PVAL002 P_REGISTRATION_NUMBER
, PVAL003 P_VEHICLE_TYPE
, PVAL004 P_VEHICLE_ID_NUMBER
, PVAL005 P_MAKE
, PVAL006 P_ENGINE_CAPACITY_IN_CC
, PVAL007 P_FUEL_TYPE
, PVAL008 P_CURRENCY_CODE
, PVAL009 P_VEHICLE_STATUS
, PVAL010 P_VEHICLE_INACTIVITY_REASON
, PVAL011 P_MODEL
, PVAL012 P_INITIAL_REGISTRATION
, PVAL013 P_LAST_REGISTRATION_RENEW_DATE
, PVAL014 P_LIST_PRICE
, PVAL015 P_ACCESSORY_VALUE_AT_STARTDATE
, PVAL016 P_ACCESSORY_VALUE_ADDED_LATER
, PVAL017 P_MARKET_VALUE_CLASSIC_CAR
, PVAL018 P_FISCAL_RATINGS
, PVAL019 P_FISCAL_RATINGS_UOM
, PVAL020 P_VEHICLE_PROVIDER
, PVAL021 P_VEHICLE_OWNERSHIP
, PVAL022 P_SHARED_VEHICLE
, PVAL023 P_ASSET_NUMBER
, PVAL024 P_LEASE_CONTRACT_NUMBER
, PVAL025 P_LEASE_CONTRACT_EXPIRY_DATE
, PVAL026 P_TAXATION_METHOD
, PVAL027 P_FLEET_INFO
, PVAL028 P_FLEET_TRANSFER_DATE
, PVAL029 P_COLOR
, PVAL030 P_SEATING_CAPACITY
, PVAL031 P_WEIGHT
, PVAL032 P_WEIGHT_UOM
, PVAL033 P_MODEL_YEAR
, PVAL034 P_INSURANCE_NUMBER
, PVAL035 P_INSURANCE_EXPIRY_DATE
, PVAL036 P_COMMENTS
, PVAL037 P_VRE_ATTRIBUTE_CATEGORY
, PVAL038 P_VRE_ATTRIBUTE1
, PVAL039 P_VRE_ATTRIBUTE2
, PVAL040 P_VRE_ATTRIBUTE3
, PVAL041 P_VRE_ATTRIBUTE4
, PVAL042 P_VRE_ATTRIBUTE5
, PVAL043 P_VRE_ATTRIBUTE6
, PVAL044 P_VRE_ATTRIBUTE7
, PVAL045 P_VRE_ATTRIBUTE8
, PVAL046 P_VRE_ATTRIBUTE9
, PVAL047 P_VRE_ATTRIBUTE10
, PVAL048 P_VRE_ATTRIBUTE11
, PVAL049 P_VRE_ATTRIBUTE12
, PVAL050 P_VRE_ATTRIBUTE13
, PVAL051 P_VRE_ATTRIBUTE14
, PVAL052 P_VRE_ATTRIBUTE15
, PVAL053 P_VRE_ATTRIBUTE16
, PVAL054 P_VRE_ATTRIBUTE17
, PVAL055 P_VRE_ATTRIBUTE18
, PVAL056 P_VRE_ATTRIBUTE19
, PVAL057 P_VRE_ATTRIBUTE20
, PVAL058 P_VRE_INFORMATION_CATEGORY
, PVAL059 P_VRE_INFORMATION1
, PVAL060 P_VRE_INFORMATION2
, PVAL061 P_VRE_INFORMATION3
, PVAL062 P_VRE_INFORMATION4
, PVAL063 P_VRE_INFORMATION5
, PVAL064 P_VRE_INFORMATION6
, PVAL065 P_VRE_INFORMATION7
, PVAL066 P_VRE_INFORMATION8
, PVAL067 P_VRE_INFORMATION9
, PVAL068 P_VRE_INFORMATION10
, PVAL069 P_VRE_INFORMATION11
, PVAL070 P_VRE_INFORMATION12
, PVAL071 P_VRE_INFORMATION13
, PVAL072 P_VRE_INFORMATION14
, PVAL073 P_VRE_INFORMATION15
, PVAL074 P_VRE_INFORMATION16
, PVAL075 P_VRE_INFORMATION17
, PVAL076 P_VRE_INFORMATION18
, PVAL077 P_VRE_INFORMATION19
, PVAL078 P_VRE_INFORMATION20
, PVAL079 P_VEHICLE_REPOSITORY_ID
, PVAL080 P_OBJECT_VERSION_NUMBER
, PVAL081 P_EFFECTIVE_START_DATE
, PVAL082 P_EFFECTIVE_END_DATE FROM HR_PUMP_BATCH_LINES WHERE API_MODULE_ID = 2893 WITH CHECK OPTION