APPS.AHL_PRD_MTLTXN_PVT dependencies on FND_LOOKUP_VALUES_VL

Line 180: FROM FND_LOOKUP_VALUES_VL

176:
177: -- Query for Selcting Problem_Code
178: CURSOR Fnd_Lookups_Cur(p_Lookup_Meaning varchar2) IS
179: SELECT LOOKUP_CODE
180: FROM FND_LOOKUP_VALUES_VL
181: WHERE MEANING = p_Lookup_Meaning
182: AND LOOKUP_TYPE = C_REQUEST_PROBLEM_CODE
183: AND ENABLED_FLAG = 'Y'
184: AND ((START_DATE_ACTIVE IS NULL) OR (START_DATE_ACTIVE <= SYSDATE))

Line 2187: FROM FND_LOOKUP_VALUES_VL

2183: -- Added for FP bug# 5903318.
2184: -- validate create_wo_option.
2185: CURSOR create_wo_cur(p_lookup_code IN VARCHAR2, p_lookup_type IN VARCHAR2) IS
2186: SELECT meaning
2187: FROM FND_LOOKUP_VALUES_VL
2188: WHERE lookup_type = p_lookup_type
2189: AND lookup_code = p_lookup_code
2190: AND ENABLED_FLAG = 'Y'
2191: AND ((START_DATE_ACTIVE IS NULL) OR (START_DATE_ACTIVE <= SYSDATE))

Line 2221: l_fnd_meaning fnd_lookup_values_vl.meaning%TYPE;

2217: l_junk VARCHAR2(1);
2218: l_disposition_id NUMBER;
2219:
2220: -- Added for FP bug# 5903318.
2221: l_fnd_meaning fnd_lookup_values_vl.meaning%TYPE;
2222:
2223: -- Added for ER# 5854712.
2224: l_inv_locator_id NUMBER;
2225: l_project_id NUMBER;

Line 6690: job_status_meaning FND_LOOKUP_VALUES_VL.MEANING%TYPE,

6686:
6687: TYPE l_mtl_txn_rec_type IS RECORD (
6688: workorder_id AHL_WORKORDERS.WORKORDER_ID%TYPE,
6689: job_number AHL_WORKORDERS.WORKORDER_NAME%TYPE,
6690: job_status_meaning FND_LOOKUP_VALUES_VL.MEANING%TYPE,
6691: description MTL_SYSTEM_ITEMS_KFV.DESCRIPTION%TYPE,
6692: organization_id AHL_VISITS_B.ORGANIZATION_ID%TYPE,
6693: inventory_item_id CSI_ITEM_INSTANCES.INVENTORY_ITEM_ID%TYPE,
6694: concatenated_segments MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE,

Line 6753: FND_LOOKUP_VALUES_VL MLU,

6749:
6750: V.INV_LOCATOR_ID,
6751: (select msn.current_status from mtl_serial_numbers msn where msn.inventory_item_id = C.INVENTORY_ITEM_ID and msn.serial_number = C.serial_number) serial_num_status
6752: FROM AHL_WORKORDERS W,
6753: FND_LOOKUP_VALUES_VL MLU,
6754: MTL_SYSTEM_ITEMS_KFV I,
6755: AHL_VISITS_B V,
6756: CSI_ITEM_INSTANCES C,
6757: MTL_UNITS_OF_MEASURE_VL UOM,