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_ALLOCATIONS_F

Line 491: ,pqp_vehicle_allocations_f pva

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
495: AND pva.business_group_id=pvr.business_group_id

Line 510: ,pqp_vehicle_allocations_f pva

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
514: AND pva.business_group_id=pvr.business_group_id

Line 574: AND ft.table_name='PQP_VEHICLE_ALLOCATIONS_F'

570: IS
571: SELECT 'X'
572: FROM fnd_tables ft
573: WHERE ft.application_id=8303
574: AND ft.table_name='PQP_VEHICLE_ALLOCATIONS_F'
575: AND rownum=1;
576:
577: CURSOR c_get_attr_val(p_veh_reg VARCHAR2, p_assignment_id NUMBER, p_business_group_id NUMBER, l_car_type VARCHAR2, l_temp_effective_date DATE) IS
578:

Line 586: ,pqp_vehicle_allocations_f pva

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
590: AND pva.business_group_id=p_business_group_id

Line 606: ,pqp_vehicle_allocations_f pva

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
610: AND pva.business_group_id=p_business_group_id

Line 764: ,pqp_vehicle_allocations_f pva

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||
768: ' AND pva.business_group_id='||p_business_group_id||

Line 784: ,pqp_vehicle_allocations_f pva

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||
788: ' AND pva.business_group_id='||p_business_group_id||