eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_PRD_PRINT_PVT dependencies on FND_LOOKUP_VALUES

Line 2024: FND_LOOKUP_VALUES_VL FND1

2020: SELECT UC.NAME UC_NAME ,
2021: FND1.MEANING MODEL_MEANING
2022: FROM AHL_UNIT_CONFIG_HEADERS UC ,
2023: AHL_MC_HEADERS_B MC ,
2024: FND_LOOKUP_VALUES_VL FND1
2025: WHERE UC.MASTER_CONFIG_ID = MC.MC_HEADER_ID
2026: AND FND1.LOOKUP_CODE(+) = MC.MODEL_CODE
2027: AND FND1.LOOKUP_TYPE(+) = 'AHL_ENIGMA_MODEL_CODE'
2028: AND UC.UNIT_CONFIG_HEADER_ID = c_uc_id;

Line 2130: FROM FND_LOOKUP_VALUES

2126: --AHL_VISIT_TASKS_VL VTS ,
2127: AHL_WORKORDERS W ,
2128: (SELECT LOOKUP_CODE ,
2129: MEANING
2130: FROM FND_LOOKUP_VALUES
2131: WHERE LOOKUP_TYPE = 'AHL_ENIGMA_MODEL_CODE'
2132: AND LANGUAGE = USERENV('LANG')
2133: )
2134: MODELTYPE

Line 2160: (SELECT f.meaning from fnd_lookup_values_vl f

2156: ||TO_CHAR(WRO.date_required, 'hh24:mi:ss') ) required_date,
2157: WRO.QUANTITY_ISSUED ISSUED_QTY ,
2158: MSI.PRIMARY_UNIT_OF_MEASURE UOM ,
2159: ASM.SCHEDULED_MATERIAL_ID,
2160: (SELECT f.meaning from fnd_lookup_values_vl f
2161: WHERE f.lookup_type = 'ITEM_TYPE' and f.lookup_code = msi.item_type) item_type
2162: FROM --AHL_JOB_OPER_MATERIALS_V JM,
2163: WIP_REQUIREMENT_OPERATIONS WRO, AHL_SCHEDULE_MATERIALS ASM,
2164: AHL_ITEM_GROUPS_B IG, AHL_WORKORDERS WO, MTL_SYSTEM_ITEMS_KFV MSI

Line 2278: FROM FND_LOOKUP_VALUES

2274: FROM AHL_ROUTES_B R ,
2275: AHL_ROUTES_TL T ,
2276: (SELECT LOOKUP_CODE ,
2277: MEANING
2278: FROM FND_LOOKUP_VALUES
2279: WHERE LOOKUP_TYPE = 'AHL_RM_JOB_CARD_LYT'
2280: AND LANGUAGE = USERENV('LANG')
2281: )
2282: JOBCARDLYT ,

Line 2285: FROM FND_LOOKUP_VALUES

2281: )
2282: JOBCARDLYT ,
2283: (SELECT LOOKUP_CODE,
2284: MEANING
2285: FROM FND_LOOKUP_VALUES
2286: WHERE LOOKUP_TYPE = 'AHL_SUB_ZONE'
2287: AND LANGUAGE = USERENV('LANG')
2288: )
2289: SUBZONE ,

Line 2292: FROM FND_LOOKUP_VALUES

2288: )
2289: SUBZONE ,
2290: (SELECT LOOKUP_CODE,
2291: MEANING
2292: FROM FND_LOOKUP_VALUES
2293: WHERE LOOKUP_TYPE = 'AHL_PROCESS_CODE'
2294: AND LANGUAGE = USERENV('LANG')
2295: )
2296: PROCESS ,

Line 2299: FROM FND_LOOKUP_VALUES

2295: )
2296: PROCESS ,
2297: (SELECT LOOKUP_CODE,
2298: MEANING
2299: FROM FND_LOOKUP_VALUES
2300: WHERE LOOKUP_TYPE = 'AHL_ZONE'
2301: AND LANGUAGE = USERENV('LANG')
2302: )
2303: ZONE ,

Line 2306: FROM FND_LOOKUP_VALUES

2302: )
2303: ZONE ,
2304: (SELECT LOOKUP_CODE,
2305: MEANING
2306: FROM FND_LOOKUP_VALUES
2307: WHERE LOOKUP_TYPE = 'AHL_ROUTE_TYPE'
2308: AND LANGUAGE = USERENV('LANG')
2309: )
2310: RTTYPE

Line 2382: fnd_lookup_values F1 ,

2378: MRB.last_update_date
2379: FROM ahl_mr_headers_b MRB ,
2380: ahl_unit_effectivities_b B,
2381: ahl_mr_intervals_v I ,
2382: fnd_lookup_values F1 ,
2383: csi_counter_template_vl C ,
2384: ahl_mr_headers_tl MRT ,
2385: (SELECT LOOKUP_CODE,
2386: MEANING

Line 2387: FROM FND_LOOKUP_VALUES

2383: csi_counter_template_vl C ,
2384: ahl_mr_headers_tl MRT ,
2385: (SELECT LOOKUP_CODE,
2386: MEANING
2387: FROM FND_LOOKUP_VALUES
2388: WHERE LOOKUP_TYPE = 'AHL_FMP_MR_PROGRAM_SUBTYPE'
2389: AND LANGUAGE = USERENV('LANG')
2390: ) SUBTYPE
2391: WHERE B.mr_header_id = MRB.mr_header_id

Line 2520: FROM FND_LOOKUP_VALUES

2516: AND cs.incident_id = UE.Cs_Incident_id) title,
2517: UE.FLIGHT_NUMBER,
2518: CS_TYPE.NAME,
2519: (SELECT MEANING
2520: FROM FND_LOOKUP_VALUES
2521: WHERE LOOKUP_TYPE = 'AHL_LOG_SERIES_CODE'
2522: AND LOOKUP_CODE =UE.LOG_SERIES_CODE
2523: AND LANGUAGE = USERENV('LANG')
2524: ) UE_LOG_SERIES,

Line 2529: FROM FND_LOOKUP_VALUES

2525: UE.LOG_SERIES_NUMBER LOG_NUMBER,
2526: MTL.CONCATENATED_SEGMENTS UE_ITEM_NUMBER,
2527: CSI.SERIAL_NUMBER UE_SERIAL_NUMBER ,
2528: (SELECT MEANING
2529: FROM FND_LOOKUP_VALUES
2530: WHERE LOOKUP_TYPE = 'AHL_UNIT_EFFECTIVITY_STATUS'
2531: AND LOOKUP_CODE = UE.STATUS_CODE
2532: AND LANGUAGE = USERENV('LANG')
2533: ) UE_STATUS,

Line 2562: FROM FND_LOOKUP_VALUES

2558: CS.RESOLUTION_CODE,
2559: UE_ATA_LKUP.MEANING UE_ATA_MEANING ,
2560: UE_ATA_LKUP.DESCRIPTION UE_ATA_DESC,
2561: (SELECT MEANING
2562: FROM FND_LOOKUP_VALUES
2563: WHERE LOOKUP_TYPE = 'AHL_MEL_CDL_TYPE'
2564: AND LOOKUP_CODE =UE.MEL_CDL_TYPE_CODE
2565: AND LANGUAGE = USERENV('LANG')
2566: ) UE_MEL_CDL_TYPE,

Line 2607: FROM FND_LOOKUP_VALUES

2603: ) SR_CONT ,
2604: (SELECT LOOKUP_CODE,
2605: MEANING ,
2606: DESCRIPTION
2607: FROM FND_LOOKUP_VALUES
2608: WHERE LOOKUP_TYPE = 'AHL_ATA_CODE'
2609: AND LANGUAGE = USERENV('LANG')
2610: ) UE_ATA_LKUP,
2611: (SELECT UDF.UNIT_EFFECTIVITY_ID ,

Line 2971: FND_LOOKUP_VALUES_VL FLVT,

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,
2973: BOM_DEPARTMENTS BDPT,
2974: mtl_item_locations_kfv MTLI,
2975: mtl_item_locations MSI

Line 7898: FROM FND_LOOKUP_VALUES

7894: --AHL_VISIT_TASKS_VL VTS ,
7895: AHL_WORKORDERS W ,
7896: (SELECT LOOKUP_CODE ,
7897: MEANING
7898: FROM FND_LOOKUP_VALUES
7899: WHERE LOOKUP_TYPE = 'AHL_ENIGMA_MODEL_CODE'
7900: AND LANGUAGE = USERENV('LANG')
7901: )
7902: MODELTYPE,

Line 7944: (SELECT f.meaning from fnd_lookup_values_vl f

7940: ||TO_CHAR(WRO.date_required, 'hh24:mi:ss') ) required_date,
7941: WRO.QUANTITY_ISSUED ISSUED_QTY ,
7942: MSI.PRIMARY_UNIT_OF_MEASURE UOM ,
7943: ASM.SCHEDULED_MATERIAL_ID,
7944: (SELECT f.meaning from fnd_lookup_values_vl f
7945: WHERE f.lookup_type = 'ITEM_TYPE' and f.lookup_code = msi.item_type) item_type
7946: FROM --AHL_JOB_OPER_MATERIALS_V JM,
7947: WIP_REQUIREMENT_OPERATIONS WRO, AHL_SCHEDULE_MATERIALS ASM,
7948: AHL_ITEM_GROUPS_B IG, AHL_WORKORDERS WO, MTL_SYSTEM_ITEMS_KFV MSI,AHL_WORKORDER_OPERATIONS AWOP

Line 8028: FROM FND_LOOKUP_VALUES

8024: FROM AHL_ROUTES_B R ,
8025: AHL_ROUTES_TL T ,
8026: (SELECT LOOKUP_CODE ,
8027: MEANING
8028: FROM FND_LOOKUP_VALUES
8029: WHERE LOOKUP_TYPE = 'AHL_RM_JOB_CARD_LYT'
8030: AND LANGUAGE = USERENV('LANG')
8031: )
8032: JOBCARDLYT ,

Line 8035: FROM FND_LOOKUP_VALUES

8031: )
8032: JOBCARDLYT ,
8033: (SELECT LOOKUP_CODE,
8034: MEANING
8035: FROM FND_LOOKUP_VALUES
8036: WHERE LOOKUP_TYPE = 'AHL_SUB_ZONE'
8037: AND LANGUAGE = USERENV('LANG')
8038: )
8039: SUBZONE ,

Line 8042: FROM FND_LOOKUP_VALUES

8038: )
8039: SUBZONE ,
8040: (SELECT LOOKUP_CODE,
8041: MEANING
8042: FROM FND_LOOKUP_VALUES
8043: WHERE LOOKUP_TYPE = 'AHL_PROCESS_CODE'
8044: AND LANGUAGE = USERENV('LANG')
8045: )
8046: PROCESS ,

Line 8049: FROM FND_LOOKUP_VALUES

8045: )
8046: PROCESS ,
8047: (SELECT LOOKUP_CODE,
8048: MEANING
8049: FROM FND_LOOKUP_VALUES
8050: WHERE LOOKUP_TYPE = 'AHL_ZONE'
8051: AND LANGUAGE = USERENV('LANG')
8052: )
8053: ZONE ,

Line 8056: FROM FND_LOOKUP_VALUES

8052: )
8053: ZONE ,
8054: (SELECT LOOKUP_CODE,
8055: MEANING
8056: FROM FND_LOOKUP_VALUES
8057: WHERE LOOKUP_TYPE = 'AHL_ROUTE_TYPE'
8058: AND LANGUAGE = USERENV('LANG')
8059: )
8060: RTTYPE

Line 8556: FND_LOOKUP_VALUES_VL FLV

8552: BEGIN
8553: SELECT FLV.meaning
8554: INTO l_position_meaning
8555: FROM ahl_mc_relationships MC,
8556: FND_LOOKUP_VALUES_VL FLV
8557: WHERE FLV.LOOKUP_CODE = MC.POSITION_REF_CODE
8558: AND FLV.LOOKUP_TYPE = 'AHL_POSITION_REFERENCE'
8559: AND FLV.ENABLED_FLAG = 'Y'
8560: AND FLV.END_DATE_ACTIVE >= sysdate