eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_PRD_MRSHL_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 139: from ahl_search_workorders_v AWOS, ahl_schedule_materials ASML, WIP_REQUIREMENT_OPERATIONS WIRO, mtl_system_items_kfv MSIK

135: WHERE MRV.INVENTORY_ITEM_ID =WIRO.INVENTORY_ITEM_ID
136: AND MRV. EXTERNAL_SOURCE_CODE = 'AHL'
137: AND MRV.DEMAND_SOURCE_HEADER_ID = WIRO.WIP_ENTITY_ID
138: AND MRV.DEMAND_SOURCE_LINE_ID =WIRO.OPERATION_SEQ_NUM) RESERVED_QUANTITY
139: from ahl_search_workorders_v AWOS, ahl_schedule_materials ASML, WIP_REQUIREMENT_OPERATIONS WIRO, mtl_system_items_kfv MSIK
140: WHERE AWOS.visit_task_id = ASML.visit_task_id
141: and ASML.inventory_item_id = MSIK.inventory_item_id
142: and ASML.organization_id = MSIK.organization_id
143: AND AWOS.WIP_ENTITY_ID = WIRO.WIP_ENTITY_ID

Line 208: from ahl_search_workorders_v AWOS, ahl_schedule_materials ASML, WIP_REQUIREMENT_OPERATIONS WIRO, mtl_system_items_kfv MSIK

204: WHERE MRV.INVENTORY_ITEM_ID =WIRO.INVENTORY_ITEM_ID
205: AND MRV. EXTERNAL_SOURCE_CODE = 'AHL'
206: AND MRV.DEMAND_SOURCE_HEADER_ID = WIRO.WIP_ENTITY_ID
207: AND MRV.DEMAND_SOURCE_LINE_ID =WIRO.OPERATION_SEQ_NUM) RESERVED_QUANTITY
208: from ahl_search_workorders_v AWOS, ahl_schedule_materials ASML, WIP_REQUIREMENT_OPERATIONS WIRO, mtl_system_items_kfv MSIK
209: WHERE AWOS.visit_task_id = ASML.visit_task_id
210: and ASML.inventory_item_id = MSIK.inventory_item_id
211: and ASML.organization_id = MSIK.organization_id
212: AND AWOS.WIP_ENTITY_ID = WIRO.WIP_ENTITY_ID

Line 248: mtl_system_items_kfv mkfv,

244: fnd_flex_ext.get_delimiter('INV', 'MTLL', 101) || INV_ProjectLocator_PUB.get_project_number(msi.segment19) ||
245: fnd_flex_ext.get_delimiter('INV', 'MTLL', 101) || INV_ProjectLocator_PUB.get_task_number(msi.segment20))
246: locator_segments
247: from mtl_serial_numbers msn,
248: mtl_system_items_kfv mkfv,
249: mtl_item_locations_kfv mil,
250: mtl_item_locations msi
251: WHERE msi.inventory_item_id = mkfv.inventory_item_id
252: and msi.organization_id=mkfv.organization_id

Line 575: WIP_REQUIREMENT_OPERATIONS WIRO, mtl_system_items_kfv MSIK

571: AND MRV. EXTERNAL_SOURCE_CODE = 'AHL'
572: AND MRV.DEMAND_SOURCE_HEADER_ID = WIRO.WIP_ENTITY_ID
573: AND MRV.DEMAND_SOURCE_LINE_ID =WIRO.OPERATION_SEQ_NUM) RESERVED_QUANTITY
574: from ahl_search_workorders_v AWOS, ahl_schedule_materials ASML,
575: WIP_REQUIREMENT_OPERATIONS WIRO, mtl_system_items_kfv MSIK
576: WHERE AWOS.visit_task_id = ASML.visit_task_id
577: AND ASML.inventory_item_id = MSIK.inventory_item_id
578: AND ASML.organization_id = MSIK.organization_id
579: AND AWOS.WIP_ENTITY_ID = WIRO.WIP_ENTITY_ID

Line 640: from ahl_search_workorders_v AWOS, ahl_schedule_materials ASML, WIP_REQUIREMENT_OPERATIONS WIRO, mtl_system_items_kfv MSIK

636: WHERE MRV.INVENTORY_ITEM_ID =WIRO.INVENTORY_ITEM_ID
637: AND MRV. EXTERNAL_SOURCE_CODE = 'AHL'
638: AND MRV.DEMAND_SOURCE_HEADER_ID = WIRO.WIP_ENTITY_ID
639: AND MRV.DEMAND_SOURCE_LINE_ID =WIRO.OPERATION_SEQ_NUM) RESERVED_QUANTITY
640: from ahl_search_workorders_v AWOS, ahl_schedule_materials ASML, WIP_REQUIREMENT_OPERATIONS WIRO, mtl_system_items_kfv MSIK
641: WHERE AWOS.visit_task_id = ASML.visit_task_id
642: and ASML.inventory_item_id = MSIK.inventory_item_id
643: and ASML.organization_id = MSIK.organization_id
644: AND AWOS.WIP_ENTITY_ID = WIRO.WIP_ENTITY_ID

Line 672: mtl_system_items_kfv mkfv,

668: p_subinventory_code VARCHAR2,
669: p_locator_id NUMBER) IS
670: select msn.serial_number , msn.lot_number ,msn.revision
671: from mtl_serial_numbers msn,
672: mtl_system_items_kfv mkfv,
673: mtl_item_locations_kfv mil
674: where msn.inventory_item_id = mkfv.inventory_item_id
675: and msn.current_organization_id=mkfv.organization_id
676: and msn.current_locator_id = mil.INVENTORY_locatION_ID (+)

Line 1051: from ahl_workorders AWOS, ahl_schedule_materials ASML, WIP_REQUIREMENT_OPERATIONS WIRO, mtl_system_items_kfv MSIK

1047: ) RETURN NUMBER IS
1048:
1049: CURSOR get_inst_required_qty(p_visit_id NUMBER,p_item_instance_id NUMBER) IS
1050: SELECT SUM(WIRO.REQUIRED_QUANTITY)
1051: from ahl_workorders AWOS, ahl_schedule_materials ASML, WIP_REQUIREMENT_OPERATIONS WIRO, mtl_system_items_kfv MSIK
1052: WHERE AWOS.visit_task_id = ASML.visit_task_id
1053: and ASML.inventory_item_id = MSIK.inventory_item_id
1054: and ASML.organization_id = MSIK.organization_id
1055: AND AWOS.WIP_ENTITY_ID = WIRO.WIP_ENTITY_ID

Line 1067: from ahl_workorders AWOS, ahl_schedule_materials ASML, WIP_REQUIREMENT_OPERATIONS WIRO, mtl_system_items_kfv MSIK

1063: AND VTS.instance_id = p_item_instance_id);
1064:
1065: CURSOR get_cumm_inst_required_qty(p_visit_id NUMBER,p_item_instance_id NUMBER)IS
1066: SELECT SUM(WIRO.REQUIRED_QUANTITY)
1067: from ahl_workorders AWOS, ahl_schedule_materials ASML, WIP_REQUIREMENT_OPERATIONS WIRO, mtl_system_items_kfv MSIK
1068: WHERE AWOS.visit_task_id = ASML.visit_task_id
1069: and ASML.inventory_item_id = MSIK.inventory_item_id
1070: and ASML.organization_id = MSIK.organization_id
1071: AND AWOS.WIP_ENTITY_ID = WIRO.WIP_ENTITY_ID

Line 1099: from ahl_workorders AWOS, ahl_schedule_materials ASML, WIP_REQUIREMENT_OPERATIONS WIRO, mtl_system_items_kfv MSIK

1095: ));
1096:
1097: CURSOR get_visit_required_qty(p_visit_id NUMBER) IS
1098: SELECT SUM(WIRO.REQUIRED_QUANTITY)
1099: from ahl_workorders AWOS, ahl_schedule_materials ASML, WIP_REQUIREMENT_OPERATIONS WIRO, mtl_system_items_kfv MSIK
1100: WHERE AWOS.visit_task_id = ASML.visit_task_id
1101: and ASML.inventory_item_id = MSIK.inventory_item_id
1102: and ASML.organization_id = MSIK.organization_id
1103: AND AWOS.WIP_ENTITY_ID = WIRO.WIP_ENTITY_ID

Line 1114: from ahl_workorders AWOS, ahl_schedule_materials ASML, WIP_REQUIREMENT_OPERATIONS WIRO, mtl_system_items_kfv MSIK

1110: AND WO.visit_task_id = VTS.visit_task_id);
1111:
1112: CURSOR get_inst_issued_qty(p_visit_id NUMBER,p_item_instance_id NUMBER) IS
1113: SELECT SUM( nvl(ahl_pp_materials_pvt.get_issued_qty(msik.organization_id, asml.inventory_item_id, asml.workorder_operation_id), 0)) issued_qty
1114: from ahl_workorders AWOS, ahl_schedule_materials ASML, WIP_REQUIREMENT_OPERATIONS WIRO, mtl_system_items_kfv MSIK
1115: WHERE AWOS.visit_task_id = ASML.visit_task_id
1116: and ASML.inventory_item_id = MSIK.inventory_item_id
1117: and ASML.organization_id = MSIK.organization_id
1118: AND AWOS.WIP_ENTITY_ID = WIRO.WIP_ENTITY_ID

Line 1130: from ahl_workorders AWOS, ahl_schedule_materials ASML, WIP_REQUIREMENT_OPERATIONS WIRO, mtl_system_items_kfv MSIK

1126: AND VTS.instance_id = p_item_instance_id);
1127:
1128: CURSOR get_cumm_inst_issued_qty(p_visit_id NUMBER,p_item_instance_id NUMBER)IS
1129: SELECT SUM( nvl(ahl_pp_materials_pvt.get_issued_qty(msik.organization_id, asml.inventory_item_id, asml.workorder_operation_id), 0)) issued_qty
1130: from ahl_workorders AWOS, ahl_schedule_materials ASML, WIP_REQUIREMENT_OPERATIONS WIRO, mtl_system_items_kfv MSIK
1131: WHERE AWOS.visit_task_id = ASML.visit_task_id
1132: and ASML.inventory_item_id = MSIK.inventory_item_id
1133: and ASML.organization_id = MSIK.organization_id
1134: AND AWOS.WIP_ENTITY_ID = WIRO.WIP_ENTITY_ID

Line 1162: from ahl_workorders AWOS, ahl_schedule_materials ASML, WIP_REQUIREMENT_OPERATIONS WIRO, mtl_system_items_kfv MSIK

1158: ));
1159:
1160: CURSOR get_visit_issued_qty(p_visit_id NUMBER) IS
1161: SELECT SUM( nvl(ahl_pp_materials_pvt.get_issued_qty(msik.organization_id, asml.inventory_item_id, asml.workorder_operation_id), 0)) issued_qty
1162: from ahl_workorders AWOS, ahl_schedule_materials ASML, WIP_REQUIREMENT_OPERATIONS WIRO, mtl_system_items_kfv MSIK
1163: WHERE AWOS.visit_task_id = ASML.visit_task_id
1164: and ASML.inventory_item_id = MSIK.inventory_item_id
1165: and ASML.organization_id = MSIK.organization_id
1166: AND AWOS.WIP_ENTITY_ID = WIRO.WIP_ENTITY_ID

Line 1185: from ahl_workorders AWOS, ahl_schedule_materials ASML, WIP_REQUIREMENT_OPERATIONS WIRO, mtl_system_items_kfv MSIK

1181: ASML.organization_id,
1182: ASML.inventory_item_id,
1183: p_subinventory_code,
1184: p_locator_id)) available_quantity
1185: from ahl_workorders AWOS, ahl_schedule_materials ASML, WIP_REQUIREMENT_OPERATIONS WIRO, mtl_system_items_kfv MSIK
1186: WHERE AWOS.visit_task_id = ASML.visit_task_id
1187: and ASML.inventory_item_id = MSIK.inventory_item_id
1188: and ASML.organization_id = MSIK.organization_id
1189: AND AWOS.WIP_ENTITY_ID = WIRO.WIP_ENTITY_ID

Line 1210: from ahl_workorders AWOS, ahl_schedule_materials ASML, WIP_REQUIREMENT_OPERATIONS WIRO, mtl_system_items_kfv MSIK

1206: ASML.organization_id,
1207: ASML.inventory_item_id,
1208: p_subinventory_code,
1209: p_locator_id)) available_quantity
1210: from ahl_workorders AWOS, ahl_schedule_materials ASML, WIP_REQUIREMENT_OPERATIONS WIRO, mtl_system_items_kfv MSIK
1211: WHERE AWOS.visit_task_id = ASML.visit_task_id
1212: and ASML.inventory_item_id = MSIK.inventory_item_id
1213: and ASML.organization_id = MSIK.organization_id
1214: AND AWOS.WIP_ENTITY_ID = WIRO.WIP_ENTITY_ID

Line 1251: from ahl_workorders AWOS, ahl_schedule_materials ASML, WIP_REQUIREMENT_OPERATIONS WIRO, mtl_system_items_kfv MSIK

1247: ASML.organization_id,
1248: ASML.inventory_item_id,
1249: p_subinventory_code,
1250: p_locator_id)) available_quantity
1251: from ahl_workorders AWOS, ahl_schedule_materials ASML, WIP_REQUIREMENT_OPERATIONS WIRO, mtl_system_items_kfv MSIK
1252: WHERE AWOS.visit_task_id = ASML.visit_task_id
1253: and ASML.inventory_item_id = MSIK.inventory_item_id
1254: and ASML.organization_id = MSIK.organization_id
1255: AND AWOS.WIP_ENTITY_ID = WIRO.WIP_ENTITY_ID

Line 1623: FROM mtl_system_items_kfv M, csi_item_instances C

1619:
1620: CURSOR get_part_info(c_instance_id NUMBER) IS
1621: SELECT M.inventory_item_id,M.concatenated_segments,C.serial_number,
1622: C.QUANTITY
1623: FROM mtl_system_items_kfv M, csi_item_instances C
1624: WHERE C.instance_id = c_instance_id
1625: AND C.inventory_item_id = M.inventory_item_id
1626: AND C.inv_master_organization_id = M.organization_id;
1627:

Line 1925: FROM mtl_system_items_kfv M, csi_item_instances C

1921:
1922: CURSOR get_part_info(c_instance_id NUMBER) IS
1923: SELECT M.inventory_item_id,M.concatenated_segments,C.serial_number,
1924: DECODE(M.serial_number_control_code,'1','N','Y') is_serial_cntld,C.quantity
1925: FROM mtl_system_items_kfv M, csi_item_instances C
1926: WHERE C.instance_id = c_instance_id
1927: AND C.inventory_item_id = M.inventory_item_id
1928: AND C.inv_master_organization_id = M.organization_id;
1929: