APPS.AHL_PRD_MTLTXN_PVT dependencies on MTL_UNITS_OF_MEASURE

Line 189: FROM MTL_UNITS_OF_MEASURE

185: AND ((END_DATE_ACTIVE IS NULL) OR (END_DATE_ACTIVE >= SYSDATE));
186: -- Cursor for Selecting UOM from UOM description.
187: CURSOR Uom_Cur(p_Uom_Desc varchar2) IS
188: SELECT UOM_CODE
189: FROM MTL_UNITS_OF_MEASURE
190: WHERE UNIT_OF_MEASURE = p_Uom_Desc;
191: -- Cursor for Wip job id.
192: CURSOR WIP_JOB_ID_CUR(p_wo_id NUMBER) IS
193: SELECT A.WIP_ENTITY_ID, C.ORGANIZATION_ID

Line 5040: MTL_UNITS_OF_MEASURE_VL UOM,

5036: WIP_DISCRETE_JOBS WDJ,
5037: (SELECT ORGANIZATION_ID, NAME FROM HR_ALL_ORGANIZATION_UNITS_TL WHERE LANGUAGE = USERENV('LANG')) ORG,
5038: BOM_DEPARTMENTS B,
5039: AHL_WORKORDER_OPERATIONS O,
5040: MTL_UNITS_OF_MEASURE_VL UOM,
5041: WIP_PARAMETERS WIP,
5042: MTL_ITEM_LOCATIONS_KFV L
5043: WHERE
5044: D.WORKORDER_ID = W.WORKORDER_ID AND

Line 5142: unit_of_measure MTL_UNITS_OF_MEASURE_VL.UNIT_OF_MEASURE%TYPE,

5138: condition_code MTL_MATERIAL_STATUSES_TL.STATUS_CODE%TYPE,
5139: condition_id AHL_PRD_DISPOSITIONS_B.CONDITION_ID%TYPE,
5140: serial_number CSI_ITEM_INSTANCES.SERIAL_NUMBER%TYPE,
5141: uom AHL_PRD_DISPOSITIONS_B.UOM%TYPE,
5142: unit_of_measure MTL_UNITS_OF_MEASURE_VL.UNIT_OF_MEASURE%TYPE,
5143: job_status_meaning FND_LOOKUP_VALUES.MEANING%TYPE,
5144: lot_number CSI_ITEM_INSTANCES.LOT_NUMBER%TYPE,
5145: item_revision CSI_ITEM_INSTANCES.INVENTORY_REVISION%TYPE,
5146: collection_id AHL_PRD_DISPOSITIONS_B.COLLECTION_ID%TYPE,

Line 5277: MTL_UNITS_OF_MEASURE_VL UOM,

5273: FROM
5274: AHL_MTL_RET_DISPOSITIONS_V D,
5275: AHL_VISITS_B V,
5276: AHL_WORKORDER_OPERATIONS O,
5277: MTL_UNITS_OF_MEASURE_VL UOM,
5278: (SELECT LOOKUP_CODE, MEANING FROM FND_LOOKUP_VALUES WHERE LOOKUP_TYPE = ''AHL_JOB_STATUS'' AND LANGUAGE= USERENV(''LANG'')) WO_STS,
5279: WIP_PARAMETERS WP,
5280: MTL_ITEM_LOCATIONS_KFV L,
5281: AHL_WORKORDERS W ';

Line 6034: MTL_UNITS_OF_MEASURE_VL UOM,

6030: AHL_VISIT_TASKS_B VST_TASK,
6031: AHL_VISITS_B VST,
6032: AHL_WORKORDER_OPERATIONS WO_OP,
6033: MTL_SYSTEM_ITEMS_KFV MTL,
6034: MTL_UNITS_OF_MEASURE_VL UOM,
6035: -- modified to retrieve segment19 and 20 from base table to fix bug# 6611033.
6036: --MTL_ITEM_LOCATIONS_KFV MTL_LOC,
6037: MTL_ITEM_LOCATIONS MTL_LOC,
6038: WIP_PARAMETERS WP,

Line 6113: MTL_UNITS_OF_MEASURE_VL UOM,

6109:
6110: FROM
6111: AHL_WORKORDER_MTL_TXNS A,
6112: MTL_SYSTEM_ITEMS_KFV B,
6113: MTL_UNITS_OF_MEASURE_VL UOM,
6114: -- modified to retrieve segment19 and 20 from base table to fix bug# 6611033.
6115: --MTL_ITEM_LOCATIONS_KFV D,
6116: MTL_ITEM_LOCATIONS D,
6117: AHL_WORKORDERS E,

Line 6596: MTL_UNITS_OF_MEASURE_VL UOM,

6592: CSI_ITEM_INSTANCES CSI,
6593: MTL_SYSTEM_ITEMS_KFV I,
6594: AHL_SEARCH_WORKORDERS_v W,
6595: WIP_PARAMETERS P,
6596: MTL_UNITS_OF_MEASURE_VL UOM,
6597: MTL_ITEM_LOCATIONS D,
6598: MTL_PARAMETERS MP
6599: WHERE
6600: csi.inventory_item_id = I.inventory_item_id

Line 6703: unit_of_measure MTL_UNITS_OF_MEASURE_VL.UNIT_OF_MEASURE%TYPE,

6699: instance_id CSI_ITEM_INSTANCES.INSTANCE_ID%TYPE,
6700: wip_entity_id AHL_WORKORDERS.WIP_ENTITY_ID%TYPE,
6701: quantity CSI_ITEM_INSTANCES.QUANTITY%TYPE,
6702: uom CSI_ITEM_INSTANCES.UNIT_OF_MEASURE%TYPE,
6703: unit_of_measure MTL_UNITS_OF_MEASURE_VL.UNIT_OF_MEASURE%TYPE,
6704: default_pull_supply_subinv WIP_PARAMETERS.DEFAULT_PULL_SUPPLY_SUBINV%TYPE,
6705: default_pull_supply_locator_id WIP_PARAMETERS.DEFAULT_PULL_SUPPLY_LOCATOR_ID%TYPE,
6706: locator VARCHAR2(500),
6707:

Line 6757: MTL_UNITS_OF_MEASURE_VL UOM,

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,
6758: WIP_PARAMETERS P,
6759: MTL_ITEM_LOCATIONS D ';
6760:
6761: