APPS.AHL_PRD_PRINT_PVT dependencies on FND_LOOKUP_VALUES_VL

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 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 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 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 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