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 151: from ahl_workorders AWOS, ahl_schedule_materials ASML, WIP_REQUIREMENT_OPERATIONS WIRO, mtl_system_items_kfv MSIK

147: WHERE MRV.INVENTORY_ITEM_ID =WIRO.INVENTORY_ITEM_ID
148: AND MRV. EXTERNAL_SOURCE_CODE = 'AHL'
149: AND MRV.DEMAND_SOURCE_HEADER_ID = WIRO.WIP_ENTITY_ID
150: AND MRV.DEMAND_SOURCE_LINE_ID =WIRO.OPERATION_SEQ_NUM) RESERVED_QUANTITY
151: from ahl_workorders AWOS, ahl_schedule_materials ASML, WIP_REQUIREMENT_OPERATIONS WIRO, mtl_system_items_kfv MSIK
152: WHERE AWOS.visit_task_id = ASML.visit_task_id
153: and ASML.inventory_item_id = MSIK.inventory_item_id
154: and ASML.organization_id = MSIK.organization_id
155: AND AWOS.WIP_ENTITY_ID = WIRO.WIP_ENTITY_ID

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

227: WHERE MRV.INVENTORY_ITEM_ID =WIRO.INVENTORY_ITEM_ID
228: AND MRV. EXTERNAL_SOURCE_CODE = 'AHL'
229: AND MRV.DEMAND_SOURCE_HEADER_ID = WIRO.WIP_ENTITY_ID
230: AND MRV.DEMAND_SOURCE_LINE_ID =WIRO.OPERATION_SEQ_NUM) RESERVED_QUANTITY
231: from ahl_workorders AWOS, ahl_schedule_materials ASML, WIP_REQUIREMENT_OPERATIONS WIRO, mtl_system_items_kfv MSIK
232: WHERE AWOS.visit_task_id = ASML.visit_task_id
233: and ASML.inventory_item_id = MSIK.inventory_item_id
234: and ASML.organization_id = MSIK.organization_id
235: AND AWOS.WIP_ENTITY_ID = WIRO.WIP_ENTITY_ID

Line 287: mtl_system_items_kfv mkfv,

283: fnd_flex_ext.get_delimiter('INV', 'MTLL', 101) || INV_ProjectLocator_PUB.get_project_number(msi.segment19) ||
284: fnd_flex_ext.get_delimiter('INV', 'MTLL', 101) || INV_ProjectLocator_PUB.get_task_number(msi.segment20))
285: locator_segments
286: from mtl_serial_numbers msn,
287: mtl_system_items_kfv mkfv,
288: mtl_item_locations_kfv mil,
289: mtl_item_locations msi
290: WHERE msi.inventory_item_id = mkfv.inventory_item_id
291: and msi.organization_id=mkfv.organization_id

Line 579: WIP_REQUIREMENT_OPERATIONS WIRO, mtl_system_items_kfv MSIK

575: AND MRV. EXTERNAL_SOURCE_CODE = 'AHL'
576: AND MRV.DEMAND_SOURCE_HEADER_ID = WIRO.WIP_ENTITY_ID
577: AND MRV.DEMAND_SOURCE_LINE_ID =WIRO.OPERATION_SEQ_NUM) RESERVED_QUANTITY
578: from ahl_workorders AWOS, ahl_schedule_materials ASML,
579: WIP_REQUIREMENT_OPERATIONS WIRO, mtl_system_items_kfv MSIK
580: WHERE AWOS.visit_task_id = ASML.visit_task_id
581: AND ASML.inventory_item_id = MSIK.inventory_item_id
582: AND ASML.organization_id = MSIK.organization_id
583: AND AWOS.WIP_ENTITY_ID = WIRO.WIP_ENTITY_ID

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

651: WHERE MRV.INVENTORY_ITEM_ID =WIRO.INVENTORY_ITEM_ID
652: AND MRV. EXTERNAL_SOURCE_CODE = 'AHL'
653: AND MRV.DEMAND_SOURCE_HEADER_ID = WIRO.WIP_ENTITY_ID
654: AND MRV.DEMAND_SOURCE_LINE_ID =WIRO.OPERATION_SEQ_NUM) RESERVED_QUANTITY
655: from ahl_workorders AWOS, ahl_schedule_materials ASML, WIP_REQUIREMENT_OPERATIONS WIRO, mtl_system_items_kfv MSIK
656: WHERE AWOS.visit_task_id = ASML.visit_task_id
657: and ASML.inventory_item_id = MSIK.inventory_item_id
658: and ASML.organization_id = MSIK.organization_id
659: AND AWOS.WIP_ENTITY_ID = WIRO.WIP_ENTITY_ID

Line 702: mtl_system_items_kfv mkfv,

698: p_subinventory_code VARCHAR2,
699: p_locator_id NUMBER) IS
700: select msn.serial_number , msn.lot_number ,msn.revision
701: from mtl_serial_numbers msn,
702: mtl_system_items_kfv mkfv,
703: mtl_item_locations_kfv mil
704: where msn.inventory_item_id = mkfv.inventory_item_id
705: and msn.current_organization_id=mkfv.organization_id
706: and msn.current_locator_id = mil.INVENTORY_locatION_ID (+)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1665: FROM mtl_system_items_kfv M, csi_item_instances C

1661:
1662: CURSOR get_part_info(c_instance_id NUMBER) IS
1663: SELECT M.inventory_item_id,M.concatenated_segments,C.serial_number,
1664: C.QUANTITY
1665: FROM mtl_system_items_kfv M, csi_item_instances C
1666: WHERE C.instance_id = c_instance_id
1667: AND C.inventory_item_id = M.inventory_item_id
1668: AND C.inv_master_organization_id = M.organization_id;
1669:

Line 1957: FROM mtl_system_items_kfv M, csi_item_instances C

1953:
1954: CURSOR get_part_info(c_instance_id NUMBER) IS
1955: SELECT M.inventory_item_id,M.concatenated_segments,C.serial_number,
1956: DECODE(M.serial_number_control_code,'1','N','Y') is_serial_cntld,C.quantity
1957: FROM mtl_system_items_kfv M, csi_item_instances C
1958: WHERE C.instance_id = c_instance_id
1959: AND C.inventory_item_id = M.inventory_item_id
1960: AND C.inv_master_organization_id = M.organization_id;
1961: