[Home] [Help]
174: AND ((END_DATE_ACTIVE IS NULL) OR (END_DATE_ACTIVE >= SYSDATE));
175: -- Cursor for Selecting UOM from UOM description.
176: CURSOR Uom_Cur(p_Uom_Desc varchar2) IS
177: SELECT UOM_CODE
178: FROM MTL_UNITS_OF_MEASURE
179: WHERE UNIT_OF_MEASURE = p_Uom_Desc;
180: -- Cursor for Wip job id.
181: CURSOR WIP_JOB_ID_CUR(p_wo_id NUMBER) IS
182: SELECT A.WIP_ENTITY_ID, C.ORGANIZATION_ID
4317: WIP_DISCRETE_JOBS WDJ,
4318: (SELECT ORGANIZATION_ID, NAME FROM HR_ALL_ORGANIZATION_UNITS_TL WHERE LANGUAGE = USERENV('LANG')) ORG,
4319: BOM_DEPARTMENTS B,
4320: AHL_WORKORDER_OPERATIONS O,
4321: MTL_UNITS_OF_MEASURE_VL UOM,
4322: WIP_PARAMETERS WIP,
4323: MTL_ITEM_LOCATIONS_KFV L
4324: WHERE
4325: D.WORKORDER_ID = W.WORKORDER_ID AND
4675: AHL_VISIT_TASKS_B VST_TASK,
4676: AHL_VISITS_B VST,
4677: AHL_WORKORDER_OPERATIONS WO_OP,
4678: MTL_SYSTEM_ITEMS_KFV MTL,
4679: MTL_UNITS_OF_MEASURE_VL UOM,
4680: -- modified to retrieve segment19 and 20 from base table to fix bug# 6611033.
4681: --MTL_ITEM_LOCATIONS_KFV MTL_LOC,
4682: MTL_ITEM_LOCATIONS MTL_LOC,
4683: WIP_PARAMETERS WIP,
4750: (select inv_locator_id from ahl_visits_b where visit_id = E.visit_id) inv_locator_id
4751: FROM
4752: AHL_WORKORDER_MTL_TXNS A,
4753: MTL_SYSTEM_ITEMS_KFV B,
4754: MTL_UNITS_OF_MEASURE_VL UOM,
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,
5081: CSI_ITEM_INSTANCES CSI,
5082: MTL_SYSTEM_ITEMS_KFV I,
5083: AHL_SEARCH_WORKORDERS_v W,
5084: WIP_PARAMETERS P,
5085: MTL_UNITS_OF_MEASURE_VL UOM,
5086: MTL_ITEM_LOCATIONS D,
5087: MTL_PARAMETERS MP
5088: WHERE
5089: csi.inventory_item_id = I.inventory_item_id