APPS.AHL_PRD_NONROUTINE_PUB dependencies on FND_LOOKUP_VALUES

Line 635: FND_LOOKUP_VALUES FLVT,

631: x_create_nr_output_rec.problem_code_meaning,
632: x_create_nr_output_rec.resolution_code,
633: x_create_nr_output_rec.resolution_code_meaning
634: FROM cs_incidents_all_b CS,
635: FND_LOOKUP_VALUES FLVT,
636: FND_LOOKUP_VALUES FLVT1
637: WHERE FLVT.LOOKUP_TYPE(+) = 'REQUEST_PROBLEM_CODE'
638: AND FLVT.LOOKUP_CODE(+) = CS.PROBLEM_CODE
639: AND FLVT1.LOOKUP_TYPE(+) = 'REQUEST_RESOLUTION_CODE'

Line 636: FND_LOOKUP_VALUES FLVT1

632: x_create_nr_output_rec.resolution_code,
633: x_create_nr_output_rec.resolution_code_meaning
634: FROM cs_incidents_all_b CS,
635: FND_LOOKUP_VALUES FLVT,
636: FND_LOOKUP_VALUES FLVT1
637: WHERE FLVT.LOOKUP_TYPE(+) = 'REQUEST_PROBLEM_CODE'
638: AND FLVT.LOOKUP_CODE(+) = CS.PROBLEM_CODE
639: AND FLVT1.LOOKUP_TYPE(+) = 'REQUEST_RESOLUTION_CODE'
640: AND FLVT1.LOOKUP_CODE(+) = CS.RESOLUTION_CODE

Line 808: FND_LOOKUP_VALUES FLVT,

804: x_create_nr_output_rec.problem_code_meaning,
805: x_create_nr_output_rec.resolution_code,
806: x_create_nr_output_rec.resolution_code_meaning
807: FROM cs_incidents_all_b CS,
808: FND_LOOKUP_VALUES FLVT,
809: FND_LOOKUP_VALUES FLVT1
810: WHERE FLVT.LOOKUP_TYPE(+) = 'REQUEST_PROBLEM_CODE'
811: AND FLVT.LOOKUP_CODE(+) = CS.PROBLEM_CODE
812: AND FLVT1.LOOKUP_TYPE(+) = 'REQUEST_RESOLUTION_CODE'

Line 809: FND_LOOKUP_VALUES FLVT1

805: x_create_nr_output_rec.resolution_code,
806: x_create_nr_output_rec.resolution_code_meaning
807: FROM cs_incidents_all_b CS,
808: FND_LOOKUP_VALUES FLVT,
809: FND_LOOKUP_VALUES FLVT1
810: WHERE FLVT.LOOKUP_TYPE(+) = 'REQUEST_PROBLEM_CODE'
811: AND FLVT.LOOKUP_CODE(+) = CS.PROBLEM_CODE
812: AND FLVT1.LOOKUP_TYPE(+) = 'REQUEST_RESOLUTION_CODE'
813: AND FLVT1.LOOKUP_CODE(+) = CS.RESOLUTION_CODE