APPS.AHL_AMP_WORKBENCH_PVT dependencies on AHL_UNIT_CONFIG_HEADERS

Line 1026: FROM AHL_UNIT_CONFIG_HEADERS UCH,

1022: CURSOR c_unit_for_flt (c_fleet_id IN NUMBER, c_unit_name IN VARCHAR2, c_mc_name IN VARCHAR2, c_start_date IN DATE, c_end_date IN DATE)
1023: IS
1024: SELECT DISTINCT UCH.NAME UNIT_NAME,
1025: UCH.UNIT_CONFIG_HEADER_ID UNIT_ID
1026: FROM AHL_UNIT_CONFIG_HEADERS UCH,
1027: AHL_FLEET_HEADERS_B FHB,
1028: AHL_FLEET_UNIT_ASSOCS FUA,
1029: AHL_MC_HEADERS_B MC
1030: WHERE FUA.UNIT_CONFIG_HEADER_ID = UCH.UNIT_CONFIG_HEADER_ID

Line 1290: AHL_UNIT_CONFIG_HEADERS UCH

1286: AVL.CLOSE_DATE_TIME,
1287: UCH.UNIT_CONFIG_HEADER_ID,
1288: TRUNC((AVL.CLOSE_DATE_TIME - AVL.START_DATE_TIME)*24) visit_duration
1289: FROM ahl_visits_vl AVL,
1290: AHL_UNIT_CONFIG_HEADERS UCH
1291: WHERE AVL.status_code IN ('PLANNING','RELEASED','PARTIALLY RELEASED')
1292: AND AVL.template_flag = 'N'
1293: AND UCH.csi_item_instance_id = AVL.Item_Instance_id
1294: ) AVT

Line 1306: FROM AHL_UNIT_CONFIG_HEADERS UCH,

1302:
1303: CURSOR c_flt_unit_ass_day ( c_fleet_id IN NUMBER, c_unit_id IN NUMBER, c_loop_date IN DATE)
1304: IS
1305: SELECT 'X'
1306: FROM AHL_UNIT_CONFIG_HEADERS UCH,
1307: AHL_FLEET_HEADERS_B FHB,
1308: AHL_FLEET_UNIT_ASSOCS FUA
1309: WHERE fua.unit_config_header_id = uch.unit_config_header_id
1310: AND FUA.FLEET_HEADER_ID = FHB.FLEET_HEADER_ID

Line 1707: FROM AHL_UNIT_CONFIG_HEADERS UCH,

1703: CURSOR c_fleet_name_for_unit (c_instance_id IN NUMBER, c_start_date IN DATE, c_end_date IN DATE)
1704: IS
1705: SELECT DISTINCT FHB.NAME FLEET_NAME,
1706: FUA.association_start
1707: FROM AHL_UNIT_CONFIG_HEADERS UCH,
1708: AHL_FLEET_HEADERS_B FHB,
1709: AHL_FLEET_UNIT_ASSOCS FUA,
1710: AHL_MC_HEADERS_B MC
1711: WHERE FUA.UNIT_CONFIG_HEADER_ID = UCH.UNIT_CONFIG_HEADER_ID

Line 1765: FROM AHL_UNIT_CONFIG_HEADERS UCH,

1761: IS
1762: SELECT DISTINCT FHB.NAME FLEET_NAME,
1763: FUA.association_start,
1764: FHB.FLEET_HEADER_ID
1765: FROM AHL_UNIT_CONFIG_HEADERS UCH,
1766: AHL_FLEET_HEADERS_B FHB,
1767: AHL_FLEET_UNIT_ASSOCS FUA,
1768: AHL_MC_HEADERS_B MC
1769: WHERE FUA.UNIT_CONFIG_HEADER_ID = UCH.UNIT_CONFIG_HEADER_ID