[Home] [Help]
1288: wo.workorder_id
1289: from
1290: ahl_workorders wo,
1291: wip_discrete_jobs wipd,
1292: ahl_visits_b vst,
1293: ahl_visit_tasks_b vtsk
1294: where
1295: wo.visit_id = vst.visit_id and
1296: wo.wip_entity_id = wipd.wip_entity_id and
2008: ||'T'
2009: ||TO_CHAR(WIP.DATE_RELEASED, 'hh24:mi:ss') ) DATE_RELEASED
2010: FROM AHL_WORKORDERS WO ,
2011: WIP_DISCRETE_JOBS WIP ,
2012: AHL_VISITS_B VST ,
2013: HR_ALL_ORGANIZATION_UNITS HROU
2014: WHERE WO.WIP_ENTITY_ID = WIP.WIP_ENTITY_ID
2015: AND VST.ORGANIZATION_ID = HROU.ORGANIZATION_ID
2016: AND WO.VISIT_ID = VST.VISIT_ID
2430:
2431: CURSOR get_visit_no(c_visit_id IN NUMBER)
2432: IS
2433: SELECT visit_number
2434: FROM ahl_visits_b
2435: WHERE visit_id = c_visit_id;
2436:
2437: CURSOR get_wo_no(c_wo_id IN NUMBER)
2438: IS
2964: || INV_ProjectLocator_PUB.get_project_number(MSI.segment19)
2965: || fnd_flex_ext.get_delimiter(''INV'', ''MTLL'', 101)
2966: || INV_ProjectLocator_PUB.get_task_number(MSI.segment20)) "Locator",
2967: (Select INCIDENT_NUMBER from CS_INCIDENTS_ALL_B where INCIDENT_ID = AVB.SERVICE_REQUEST_ID) "NonRoutineTitle"
2968: FROM AHL_VISITS_B AVB,
2969: MTL_SYSTEM_ITEMS_B_KFV MTSB,
2970: CSI_ITEM_INSTANCES CSIS,
2971: FND_LOOKUP_VALUES_VL FLVT,
2972: HR_ALL_ORGANIZATION_UNITS HROU,
3667: AND visit_id = p_object_id;
3668:
3669: SELECT UC.UNIT_CONFIG_HEADER_ID, UC.NAME, VST.item_instance_id
3670: INTO l_uc_id, l_unit_name, l_count_instance_id
3671: FROM AHL_VISITS_B VST, AHL_UNIT_CONFIG_HEADERS UC
3672: WHERE UC.CSI_ITEM_INSTANCE_ID(+) = VST.ITEM_INSTANCE_ID
3673: AND VST.VISIT_ID = p_object_id;
3674:
3675: EXCEPTION
8117:
8118: CURSOR get_visit_no(c_visit_id IN NUMBER)
8119: IS
8120: SELECT visit_number
8121: FROM ahl_visits_b
8122: WHERE visit_id = c_visit_id;
8123:
8124: CURSOR get_wo_no(c_wo_id IN NUMBER)
8125: IS