APPS.AHL_PRD_NONROUTINE_PUB dependencies on CS_INCIDENTS_ALL_B

Line 634: FROM cs_incidents_all_b CS,

630: INTO x_create_nr_output_rec.problem_code,
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

Line 652: FROM cs_incidents_all_b CS,CS_INCIDENT_STATUSES_B sts

648:
649: BEGIN
650: SELECT sts.status_code,sts.name
651: INTO x_create_nr_output_rec.service_request_status_code,x_create_nr_output_rec.service_request_status
652: FROM cs_incidents_all_b CS,CS_INCIDENT_STATUSES_B sts
653: WHERE cs.incident_id = p_nr_task_rec.INCIDENT_ID
654: AND sts.INCIDENT_STATUS_ID = cs.incident_Status_id;
655: EXCEPTION
656: WHEN OTHERS THEN

Line 663: FROM cs_incidents_all_b CS,cs_incident_types_vl

659:
660: BEGIN
661: SELECT name,incident_subtype
662: INTO x_create_nr_output_rec.SERVICE_REQUEST_TYPE,x_create_nr_output_rec.SERVICE_REQUEST_TYPE_CODE
663: FROM cs_incidents_all_b CS,cs_incident_types_vl
664: WHERE cs.incident_id = p_nr_task_rec.INCIDENT_ID
665: AND cs.incident_type_id = cs_incident_types_vl.incident_type_id;
666: EXCEPTION
667: WHEN OTHERS THEN

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

670:
671: BEGIN
672: SELECT mtl.concatenated_segments,csi.serial_number
673: INTO x_create_nr_output_rec.item_number,x_create_nr_output_rec.serial_number
674: FROm csi_item_instances csi, mtl_system_items_kfv mtl,cs_incidents_all_b cs
675: WHERE csi.instance_id = cs.customer_product_id
676: and csi.inventory_item_id = mtl.inventory_item_id
677: and mtl.organization_id = csi.inv_master_organization_id
678: AND cs.incident_id = p_nr_task_rec.incident_id;

Line 687: FROM cs_incidents_all_b cs

683:
684: BEGIN
685: SELECT ahl_util_uc_pkg.get_unit_name(cs.customer_product_id)
686: INTO x_create_nr_output_rec.unit_name
687: FROM cs_incidents_all_b cs
688: WHERE cs.incident_id = p_nr_task_rec.incident_id;
689: EXCEPTION
690: WHEN OTHERS THEN
691: NULL;

Line 807: FROM cs_incidents_all_b CS,

803: INTO x_create_nr_output_rec.problem_code,
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