[Home] [Help]
165:
166: -- Query for Selcting Problem_Code
167: CURSOR Fnd_Lookups_Cur(p_Lookup_Meaning varchar2) IS
168: SELECT LOOKUP_CODE
169: FROM FND_LOOKUP_VALUES_VL
170: WHERE MEANING = p_Lookup_Meaning
171: AND LOOKUP_TYPE = C_REQUEST_PROBLEM_CODE
172: AND ENABLED_FLAG = 'Y'
173: AND ((START_DATE_ACTIVE IS NULL) OR (START_DATE_ACTIVE <= SYSDATE))
245: AHL_SEARCH_WORKORDERS_V A
246: --AHL_VISITS_B V,
247: --AHL_VISIT_TASKS_B VT,
248: --INV_ORGANIZATION_NAME_V ORG,
249: --FND_LOOKUP_VALUES WO_STS
250: WHERE
251: A.JOB_NUMBER = C_WORKORDER_NAME
252: AND A.JOB_STATUS_CODE NOT IN ('17', '22');
253: --AND A.MASTER_WORKORDER_FLAG = 'N'
1791: * R12 Drop 4 - SQL ID: 14399922
1792: * Bug #4918991
1793: */
1794: SELECT 1
1795: FROM FND_LOOKUP_VALUES FL
1796: WHERE
1797: FL.LOOKUP_TYPE = 'REQUEST_PROBLEM_CODE' AND
1798: FL.LOOKUP_CODE = p_problem_code AND
1799: FL.ENABLED_FLAG = 'Y' AND
1894: -- Added for FP bug# 5903318.
1895: -- validate create_wo_option.
1896: CURSOR create_wo_cur(p_lookup_code IN VARCHAR2, p_lookup_type IN VARCHAR2) IS
1897: SELECT meaning
1898: FROM FND_LOOKUP_VALUES_VL
1899: WHERE lookup_type = p_lookup_type
1900: AND lookup_code = p_lookup_code
1901: AND ENABLED_FLAG = 'Y'
1902: AND ((START_DATE_ACTIVE IS NULL) OR (START_DATE_ACTIVE <= SYSDATE))
1918: l_junk VARCHAR2(1);
1919: l_disposition_id NUMBER;
1920:
1921: -- Added for FP bug# 5903318.
1922: l_fnd_meaning fnd_lookup_values_vl.meaning%TYPE;
1923:
1924: -- Added for ER# 5854712.
1925: l_inv_locator_id NUMBER;
1926: l_project_id NUMBER;
4309: (select inv_locator_id from ahl_visits_b where visit_id = w.visit_id) inv_locator_id
4310: FROM
4311: AHL_MTL_RET_DISPOSITIONS_V D,
4312: AHL_WORKORDERS W,
4313: (SELECT LOOKUP_CODE, MEANING FROM FND_LOOKUP_VALUES WHERE LOOKUP_TYPE = 'AHL_JOB_STATUS' AND LANGUAGE= USERENV('LANG')) WO_STS,
4314: AHL_VISITS_B V,
4315: AHL_VISIT_TASKS_B VT,
4316: CS_INCIDENTS_ALL_B C,
4317: WIP_DISCRETE_JOBS WDJ,
4670: (select inv_locator_id from ahl_visits_b where visit_id = vst.visit_id) inv_locator_id
4671: FROM
4672: AHL_WORKORDER_MTL_TXNS TXNS,
4673: AHL_WORKORDERS WO,
4674: (SELECT LOOKUP_CODE, MEANING FROM FND_LOOKUP_VALUES WHERE LOOKUP_TYPE = 'AHL_JOB_STATUS' AND LANGUAGE= USERENV('LANG')) WO_STS,
4675: AHL_VISIT_TASKS_B VST_TASK,
4676: AHL_VISITS_B VST,
4677: AHL_WORKORDER_OPERATIONS WO_OP,
4678: MTL_SYSTEM_ITEMS_KFV MTL,
4755: -- modified to retrieve segment19 and 20 from base table to fix bug# 6611033.
4756: --MTL_ITEM_LOCATIONS_KFV D,
4757: MTL_ITEM_LOCATIONS D,
4758: AHL_WORKORDERS E,
4759: (SELECT LOOKUP_CODE, MEANING FROM FND_LOOKUP_VALUES WHERE LOOKUP_TYPE = 'AHL_JOB_STATUS' AND LANGUAGE= USERENV('LANG')) WO_STS,
4760: AHL_VISITS_B V,
4761: AHL_VISIT_TASKS_B VT,
4762: AHL_WORKORDER_OPERATIONS F,
4763: WIP_PARAMETERS W