APPS.AHL_PRD_MTLTXN_PVT dependencies on MTL_ITEM_LOCATIONS_KFV

Line 131: FROM MTL_ITEM_LOCATIONS_KFV

127:
128: -- Query for validating location segments and selecting location_id
129: /*CURSOR Location_Cur(p_org_id number, p_location_name varchar2) IS
130: SELECT INVENTORY_LOCATION_ID
131: FROM MTL_ITEM_LOCATIONS_KFV
132: WHERE ORGANIZATION_ID = p_org_Id
133: AND CONCATENATED_SEGMENTS = p_location_name
134: AND ((START_DATE_ACTIVE IS NULL) OR (START_DATE_ACTIVE <= SYSDATE))
135: AND ((END_DATE_ACTIVE IS NULL) OR (END_DATE_ACTIVE >= SYSDATE));*/

Line 140: FROM MTL_ITEM_LOCATIONS_KFV MIL_kfv, MTL_ITEM_LOCATIONS MIL

136: -- fix for bug number 5903275
137: -- modified to retrieve segment19 and 20 from base table to fix bug# 6611033.
138: CURSOR Location_Cur(p_org_id number, p_location_name varchar2) IS
139: SELECT MIL.INVENTORY_LOCATION_ID, MIL_kfv.CONCATENATED_SEGMENTS
140: FROM MTL_ITEM_LOCATIONS_KFV MIL_kfv, MTL_ITEM_LOCATIONS MIL
141: WHERE MIL_kfv.INVENTORY_LOCATION_ID = MIL.INVENTORY_LOCATION_ID
142: AND MIL.ORGANIZATION_ID = p_org_Id
143: AND upper(decode(MIL.segment19, null, MIL_kfv.concatenated_segments,
144: INV_PROJECT.GET_LOCSEGS(MIL_kfv.concatenated_segments) || fnd_flex_ext.get_delimiter('INV', 'MTLL', 101)

Line 4323: MTL_ITEM_LOCATIONS_KFV L

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
4326: W.MASTER_WORKORDER_FLAG = 'N' AND
4327: W.STATUS_CODE NOT IN ('17', '22', '5','7','12') AND

Line 4681: --MTL_ITEM_LOCATIONS_KFV MTL_LOC,

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,
4684: PER_ALL_PEOPLE_F PER
4685: WHERE

Line 4756: --MTL_ITEM_LOCATIONS_KFV D,

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