APPS.AHL_PRD_NONROUTINE_PUB dependencies on CS_INCIDENTS_ALL_B

Line 619: FROM cs_incidents_all_b CS,

615: INTO x_create_nr_output_rec.problem_code,
616: x_create_nr_output_rec.problem_code_meaning,
617: x_create_nr_output_rec.resolution_code,
618: x_create_nr_output_rec.resolution_code_meaning
619: FROM cs_incidents_all_b CS,
620: FND_LOOKUP_VALUES FLVT,
621: FND_LOOKUP_VALUES FLVT1
622: WHERE FLVT.LOOKUP_TYPE(+) = 'REQUEST_PROBLEM_CODE'
623: AND FLVT.LOOKUP_CODE(+) = CS.PROBLEM_CODE

Line 637: FROM cs_incidents_all_b CS,CS_INCIDENT_STATUSES_B sts

633:
634: BEGIN
635: SELECT sts.status_code,sts.name
636: INTO x_create_nr_output_rec.service_request_status_code,x_create_nr_output_rec.service_request_status
637: FROM cs_incidents_all_b CS,CS_INCIDENT_STATUSES_B sts
638: WHERE cs.incident_id = p_nr_task_rec.INCIDENT_ID
639: AND sts.INCIDENT_STATUS_ID = cs.incident_Status_id;
640: EXCEPTION
641: WHEN OTHERS THEN

Line 648: FROM cs_incidents_all_b CS,cs_incident_types_vl cit

644:
645: BEGIN
646: SELECT cit.name,cit.incident_subtype
647: INTO x_create_nr_output_rec.SERVICE_REQUEST_TYPE,x_create_nr_output_rec.SERVICE_REQUEST_TYPE_CODE
648: FROM cs_incidents_all_b CS,cs_incident_types_vl cit
649: WHERE cs.incident_id = p_nr_task_rec.INCIDENT_ID
650: AND cs.incident_type_id = cit.incident_type_id;
651: EXCEPTION
652: WHEN OTHERS THEN

Line 659: FROm csi_item_instances csi, mtl_system_items_kfv mtl,cs_incidents_all_b cs

655:
656: BEGIN
657: SELECT mtl.concatenated_segments,csi.serial_number
658: INTO x_create_nr_output_rec.item_number,x_create_nr_output_rec.serial_number
659: FROm csi_item_instances csi, mtl_system_items_kfv mtl,cs_incidents_all_b cs
660: WHERE csi.instance_id = cs.customer_product_id
661: and csi.inventory_item_id = mtl.inventory_item_id
662: and mtl.organization_id = csi.inv_master_organization_id
663: AND cs.incident_id = p_nr_task_rec.incident_id;

Line 672: FROM cs_incidents_all_b cs

668:
669: BEGIN
670: SELECT ahl_util_uc_pkg.get_unit_name(cs.customer_product_id)
671: INTO x_create_nr_output_rec.unit_name
672: FROM cs_incidents_all_b cs
673: WHERE cs.incident_id = p_nr_task_rec.incident_id;
674: EXCEPTION
675: WHEN OTHERS THEN
676: NULL;

Line 804: FROM cs_incidents_all_b CS,

800: INTO x_create_nr_output_rec.problem_code,
801: x_create_nr_output_rec.problem_code_meaning,
802: x_create_nr_output_rec.resolution_code,
803: x_create_nr_output_rec.resolution_code_meaning
804: FROM cs_incidents_all_b CS,
805: FND_LOOKUP_VALUES FLVT,
806: FND_LOOKUP_VALUES FLVT1
807: WHERE FLVT.LOOKUP_TYPE(+) = 'REQUEST_PROBLEM_CODE'
808: AND FLVT.LOOKUP_CODE(+) = CS.PROBLEM_CODE