APPS.AHL_PRD_MTLTXN_PVT dependencies on MTL_ITEM_LOCATIONS

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 1733: FROM AHL_WORKORDERS A, AHL_VISIT_TASKS_B B, AHL_VISITS_B C, MTL_ITEM_LOCATIONS LOC

1729: -- Added project and locator for ER# 5854712.
1730: CURSOR AHL_WIPJOB_CUR (p_org_id NUMBER, p_wo_id NUMBER, p_wipjob IN NUMBER) IS
1731: SELECT A.STATUS_CODE, C.Visit_id, C.Inv_Locator_Id, C.project_id, B.project_task_id,
1732: LOC.subinventory_code
1733: FROM AHL_WORKORDERS A, AHL_VISIT_TASKS_B B, AHL_VISITS_B C, MTL_ITEM_LOCATIONS LOC
1734: WHERE A.WIP_ENTITY_ID = p_wipjob
1735: AND A.WORKORDER_ID = p_wo_id
1736: AND B.VISIT_TASK_ID = A.VISIT_TASK_ID
1737: AND C.VISIT_ID = B.VISIT_ID

Line 1763: FROM MTL_ITEM_LOCATIONS

1759:
1760: -- Locator query
1761: CURSOR AHL_LOCATOR_CUR (p_org_id NUMBER, p_locator_id NUMBER, p_subinv VARCHAR2) IS
1762: SELECT 1
1763: FROM MTL_ITEM_LOCATIONS
1764: WHERE ORGANIZATION_ID = p_org_id
1765: AND INVENTORY_LOCATION_ID = p_locator_id
1766: ;--AND SUBINVENTORY_CODE = p_subinv;
1767:

Line 1928: l_subinventory_code mtl_item_locations.subinventory_code%TYPE;

1924: -- Added for ER# 5854712.
1925: l_inv_locator_id NUMBER;
1926: l_project_id NUMBER;
1927: l_project_task_id NUMBER;
1928: l_subinventory_code mtl_item_locations.subinventory_code%TYPE;
1929: l_project_locator_id NUMBER;
1930:
1931:
1932: BEGIN

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 4682: MTL_ITEM_LOCATIONS MTL_LOC,

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
4686: TXNS.TRANSACTION_TYPE_ID = 35 AND

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,

Line 4757: MTL_ITEM_LOCATIONS D,

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,
4761: AHL_VISIT_TASKS_B VT,

Line 5086: MTL_ITEM_LOCATIONS D,

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
5090: AND W.organization_id = MP.organization_id