eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQP_CAR_MILEAGE_FUNCTIONS dependencies on PQP_VEHICLE_REPOSITORY_F

Line 490: FROM pqp_vehicle_repository_f pvr

486: ,pvr.engine_capacity_in_cc
487: ,pvr.fuel_type
488: ,pva.default_vehicle
489: ,pvr.vehicle_type
490: FROM pqp_vehicle_repository_f pvr
491: ,pqp_vehicle_allocations_f pva
492: WHERE pvr.vehicle_repository_id=pva.vehicle_repository_id
493: AND pva.assignment_id=p_assignment_id
494: AND pva.business_group_id=p_business_group_id

Line 509: FROM pqp_vehicle_repository_f pvr

505: ,pvr.engine_capacity_in_cc
506: ,pvr.fuel_type
507: ,pva.default_vehicle
508: ,pvr.vehicle_type
509: FROM pqp_vehicle_repository_f pvr
510: ,pqp_vehicle_allocations_f pva
511: WHERE pvr.vehicle_repository_id=pva.vehicle_repository_id
512: AND pva.assignment_id=p_assignment_id
513: AND pva.business_group_id=p_business_group_id

Line 585: FROM pqp_vehicle_repository_f pvr

581: ,pvr.engine_capacity_in_cc
582: ,pvr.fuel_type
583: ,pva.default_vehicle
584: ,pvr.vehicle_type
585: FROM pqp_vehicle_repository_f pvr
586: ,pqp_vehicle_allocations_f pva
587: WHERE pvr.vehicle_repository_id=pva.vehicle_repository_id
588: AND pvr.registration_number=decode(p_veh_reg,'NE',pvr.registration_number,p_veh_reg)
589: AND pva.assignment_id=p_assignment_id

Line 605: FROM pqp_vehicle_repository_f pvr

601: ,pvr.engine_capacity_in_cc
602: ,pvr.fuel_type
603: ,pva.default_vehicle
604: ,pvr.vehicle_type
605: FROM pqp_vehicle_repository_f pvr
606: ,pqp_vehicle_allocations_f pva
607: WHERE pvr.vehicle_repository_id=pva.vehicle_repository_id
608: AND pvr.registration_number=decode(p_veh_reg,'NE',pvr.registration_number,p_veh_reg)
609: AND pva.assignment_id=p_assignment_id

Line 763: FROM pqp_vehicle_repository_f pvr

759: ,pvr.engine_capacity_in_cc
760: ,pvr.fuel_type
761: ,pva.default_vehicle
762: ,pvr.vehicle_type
763: FROM pqp_vehicle_repository_f pvr
764: ,pqp_vehicle_allocations_f pva
765: WHERE pvr.vehicle_repository_id=pva.vehicle_repository_id
766: AND pvr.registration_number='''||p_veh_reg||'''
767: AND pva.assignment_id='||p_assignment_id||

Line 783: FROM pqp_vehicle_repository_f pvr

779: ,pvr.engine_capacity_in_cc
780: ,pvr.fuel_type
781: ,pva.default_vehicle
782: ,pvr.vehicle_type
783: FROM pqp_vehicle_repository_f pvr
784: ,pqp_vehicle_allocations_f pva
785: WHERE pvr.vehicle_repository_id=pva.vehicle_repository_id
786: AND pvr.registration_number='''||p_veh_reg||'''
787: AND pva.assignment_id='||p_assignment_id||