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 AHL_WORKORDERS

Line 97: SELECT VTS.instance_id FROM ahl_workorders WO,ahl_visit_tasks_b VTS WHERE

93: j NUMBER;
94:
95: CURSOR get_root_items_instance_csr(p_visit_id NUMBER,
96: p_item_instance_id NUMBER) IS
97: SELECT VTS.instance_id FROM ahl_workorders WO,ahl_visit_tasks_b VTS WHERE
98: WO.visit_id = p_visit_id
99: AND WO.visit_id = VTS.visit_id
100: AND WO.visit_task_id = VTS.visit_task_id
101: AND VTS.instance_id = p_item_instance_id

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 159: AND AWOS.workorder_id IN (SELECT workorder_id FROM ahl_workorders WO,ahl_visit_tasks_b VTS WHERE

155: AND AWOS.WIP_ENTITY_ID = WIRO.WIP_ENTITY_ID
156: AND ASML.OPERATION_SEQUENCE = WIRO.OPERATION_SEQ_NUM
157: AND ASML.INVENTORY_ITEM_ID = WIRO.INVENTORY_ITEM_ID
158: AND ASML.ORGANIZATION_ID = WIRO.ORGANIZATION_ID and asml.status = 'ACTIVE'
159: AND AWOS.workorder_id IN (SELECT workorder_id FROM ahl_workorders WO,ahl_visit_tasks_b VTS WHERE
160: WO.visit_id = p_visit_id
161: AND WO.visit_id = VTS.visit_id
162: AND WO.visit_task_id = VTS.visit_task_id
163: AND VTS.instance_id IN(

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 239: AND AWOS.workorder_id IN (SELECT workorder_id FROM ahl_workorders WO,ahl_visit_tasks_b VTS WHERE

235: AND AWOS.WIP_ENTITY_ID = WIRO.WIP_ENTITY_ID
236: AND ASML.OPERATION_SEQUENCE = WIRO.OPERATION_SEQ_NUM
237: AND ASML.INVENTORY_ITEM_ID = WIRO.INVENTORY_ITEM_ID
238: AND ASML.ORGANIZATION_ID = WIRO.ORGANIZATION_ID and asml.status = 'ACTIVE'
239: AND AWOS.workorder_id IN (SELECT workorder_id FROM ahl_workorders WO,ahl_visit_tasks_b VTS WHERE
240: WO.visit_id = p_visit_id
241: AND WO.visit_id = VTS.visit_id
242: AND WO.visit_task_id = VTS.visit_task_id
243: ))REQ WHERE

Line 526: SELECT VTS.instance_id FROM ahl_workorders WO,ahl_visit_tasks_b VTS WHERE

522: j NUMBER;
523:
524: CURSOR get_root_items_instance_csr(p_visit_id NUMBER,
525: p_item_instance_id NUMBER) IS
526: SELECT VTS.instance_id FROM ahl_workorders WO,ahl_visit_tasks_b VTS WHERE
527: WO.visit_id = p_visit_id
528: AND WO.visit_id = VTS.visit_id
529: AND WO.visit_task_id = VTS.visit_task_id
530: AND VTS.instance_id = p_item_instance_id

Line 578: from ahl_workorders AWOS, ahl_schedule_materials ASML,

574: WHERE MRV.INVENTORY_ITEM_ID =WIRO.INVENTORY_ITEM_ID
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

Line 588: AND AWOS.workorder_id IN (SELECT workorder_id FROM ahl_workorders WO,ahl_visit_tasks_b VTS WHERE

584: AND ASML.OPERATION_SEQUENCE = WIRO.OPERATION_SEQ_NUM
585: AND ASML.INVENTORY_ITEM_ID = WIRO.INVENTORY_ITEM_ID
586: AND ASML.ORGANIZATION_ID = WIRO.ORGANIZATION_ID
587: AND asml.status = 'ACTIVE'
588: AND AWOS.workorder_id IN (SELECT workorder_id FROM ahl_workorders WO,ahl_visit_tasks_b VTS WHERE
589: WO.visit_id = p_visit_id
590: AND WO.visit_id = VTS.visit_id
591: AND WO.visit_task_id = VTS.visit_task_id
592: AND VTS.instance_id IN(

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 663: AND AWOS.workorder_id IN (SELECT workorder_id FROM ahl_workorders WO,ahl_visit_tasks_b VTS WHERE

659: AND AWOS.WIP_ENTITY_ID = WIRO.WIP_ENTITY_ID
660: AND ASML.OPERATION_SEQUENCE = WIRO.OPERATION_SEQ_NUM
661: AND ASML.INVENTORY_ITEM_ID = WIRO.INVENTORY_ITEM_ID
662: AND ASML.ORGANIZATION_ID = WIRO.ORGANIZATION_ID and asml.status = 'ACTIVE'
663: AND AWOS.workorder_id IN (SELECT workorder_id FROM ahl_workorders WO,ahl_visit_tasks_b VTS WHERE
664: WO.visit_id = p_visit_id
665: AND WO.visit_id = VTS.visit_id
666: AND WO.visit_task_id = VTS.visit_task_id
667: ))REQ WHERE

Line 911: FROM AHL_WORKORDERS WO,ahl_visit_tasks_b VTS

907: ) RETURN NUMBER IS
908:
909: CURSOR comp_inst_wo_count_csr(p_visit_id NUMBER,p_item_instance_id NUMBER) IS
910: SELECT COUNT(*)
911: FROM AHL_WORKORDERS WO,ahl_visit_tasks_b VTS
912: WHERE WO.visit_id = p_visit_id
913: AND WO.STATUS_CODE IN('4','5','7','12')
914: AND WO.visit_id = VTS.visit_id
915: AND WO.visit_task_id = VTS.visit_task_id

Line 920: FROM AHL_WORKORDERS WO,ahl_visit_tasks_b VTS

916: AND VTS.instance_id = p_item_instance_id;
917:
918: CURSOR comp_cumm_inst_wo_count_csr(p_visit_id NUMBER,p_item_instance_id NUMBER) IS
919: SELECT COUNT(*)
920: FROM AHL_WORKORDERS WO,ahl_visit_tasks_b VTS
921: WHERE WO.visit_id = p_visit_id
922: AND WO.STATUS_CODE IN('4','5','7','12')
923: AND WO.visit_id = VTS.visit_id
924: AND WO.visit_task_id = VTS.visit_task_id

Line 947: FROM AHL_WORKORDERS WO,

943:
944: CURSOR total_inst_wo_count_csr(p_visit_id NUMBER,p_item_instance_id NUMBER)
945: IS
946: SELECT COUNT(*)
947: FROM AHL_WORKORDERS WO,
948: ahl_visit_tasks_b VTS
949: WHERE WO.visit_id = p_visit_id
950: AND WO.STATUS_CODE NOT IN ('22','17')
951: AND WO.visit_id = VTS.visit_id

Line 958: FROM AHL_WORKORDERS WO,

954:
955: CURSOR total_cumm_inst_wo_count_csr(p_visit_id NUMBER,p_item_instance_id NUMBER)
956: IS
957: SELECT COUNT(*)
958: FROM AHL_WORKORDERS WO,
959: ahl_visit_tasks_b VTS
960: WHERE WO.visit_id = p_visit_id
961: AND WO.STATUS_CODE NOT IN ('22','17')
962: AND WO.visit_id = VTS.visit_id

Line 986: FROM AHL_WORKORDERS

982: );
983:
984: CURSOR comp_visit_wo_count_csr(p_visit_id NUMBER) IS
985: SELECT COUNT(*)
986: FROM AHL_WORKORDERS
987: WHERE visit_id = p_visit_id
988: AND STATUS_CODE IN('4','5','7','12');
989:
990:

Line 993: FROM AHL_WORKORDERS

989:
990:
991: CURSOR total_visit_wo_count_csr(p_visit_id NUMBER) IS
992: SELECT COUNT(*)
993: FROM AHL_WORKORDERS
994: WHERE visit_id = p_visit_id
995: AND STATUS_CODE NOT IN ('22','17');
996:
997: l_quantity NUMBER;

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 1062: AND AWOS.workorder_id IN (SELECT workorder_id FROM ahl_workorders WO,ahl_visit_tasks_b VTS WHERE

1058: AND AWOS.WIP_ENTITY_ID = WIRO.WIP_ENTITY_ID
1059: AND ASML.OPERATION_SEQUENCE = WIRO.OPERATION_SEQ_NUM
1060: AND ASML.INVENTORY_ITEM_ID = WIRO.INVENTORY_ITEM_ID
1061: AND ASML.ORGANIZATION_ID = WIRO.ORGANIZATION_ID and asml.status = 'ACTIVE'
1062: AND AWOS.workorder_id IN (SELECT workorder_id FROM ahl_workorders WO,ahl_visit_tasks_b VTS WHERE
1063: WO.visit_id = p_visit_id
1064: AND WO.visit_id = VTS.visit_id
1065: AND WO.visit_task_id = VTS.visit_task_id
1066: AND VTS.instance_id = p_item_instance_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 1078: AND AWOS.workorder_id IN (SELECT workorder_id FROM ahl_workorders WO,ahl_visit_tasks_b VTS WHERE

1074: AND AWOS.WIP_ENTITY_ID = WIRO.WIP_ENTITY_ID
1075: AND ASML.OPERATION_SEQUENCE = WIRO.OPERATION_SEQ_NUM
1076: AND ASML.INVENTORY_ITEM_ID = WIRO.INVENTORY_ITEM_ID
1077: AND ASML.ORGANIZATION_ID = WIRO.ORGANIZATION_ID and asml.status = 'ACTIVE'
1078: AND AWOS.workorder_id IN (SELECT workorder_id FROM ahl_workorders WO,ahl_visit_tasks_b VTS WHERE
1079: WO.visit_id = p_visit_id
1080: AND WO.visit_id = VTS.visit_id
1081: AND WO.visit_task_id = VTS.visit_task_id
1082: AND VTS.instance_id IN(

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 1110: AND AWOS.workorder_id IN (SELECT workorder_id FROM ahl_workorders WO,ahl_visit_tasks_b VTS WHERE

1106: AND AWOS.WIP_ENTITY_ID = WIRO.WIP_ENTITY_ID
1107: AND ASML.OPERATION_SEQUENCE = WIRO.OPERATION_SEQ_NUM
1108: AND ASML.INVENTORY_ITEM_ID = WIRO.INVENTORY_ITEM_ID
1109: AND ASML.ORGANIZATION_ID = WIRO.ORGANIZATION_ID and asml.status = 'ACTIVE'
1110: AND AWOS.workorder_id IN (SELECT workorder_id FROM ahl_workorders WO,ahl_visit_tasks_b VTS WHERE
1111: WO.visit_id = p_visit_id
1112: AND WO.visit_id = VTS.visit_id
1113: AND WO.visit_task_id = VTS.visit_task_id);
1114:

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 1125: AND AWOS.workorder_id IN (SELECT workorder_id FROM ahl_workorders WO,ahl_visit_tasks_b VTS WHERE

1121: AND AWOS.WIP_ENTITY_ID = WIRO.WIP_ENTITY_ID
1122: AND ASML.OPERATION_SEQUENCE = WIRO.OPERATION_SEQ_NUM
1123: AND ASML.INVENTORY_ITEM_ID = WIRO.INVENTORY_ITEM_ID
1124: AND ASML.ORGANIZATION_ID = WIRO.ORGANIZATION_ID and asml.status = 'ACTIVE'
1125: AND AWOS.workorder_id IN (SELECT workorder_id FROM ahl_workorders WO,ahl_visit_tasks_b VTS WHERE
1126: WO.visit_id = p_visit_id
1127: AND WO.visit_id = VTS.visit_id
1128: AND WO.visit_task_id = VTS.visit_task_id
1129: AND VTS.instance_id = p_item_instance_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 1141: AND AWOS.workorder_id IN (SELECT workorder_id FROM ahl_workorders WO,ahl_visit_tasks_b VTS WHERE

1137: AND AWOS.WIP_ENTITY_ID = WIRO.WIP_ENTITY_ID
1138: AND ASML.OPERATION_SEQUENCE = WIRO.OPERATION_SEQ_NUM
1139: AND ASML.INVENTORY_ITEM_ID = WIRO.INVENTORY_ITEM_ID
1140: AND ASML.ORGANIZATION_ID = WIRO.ORGANIZATION_ID and asml.status = 'ACTIVE'
1141: AND AWOS.workorder_id IN (SELECT workorder_id FROM ahl_workorders WO,ahl_visit_tasks_b VTS WHERE
1142: WO.visit_id = p_visit_id
1143: AND WO.visit_id = VTS.visit_id
1144: AND WO.visit_task_id = VTS.visit_task_id
1145: AND VTS.instance_id IN(

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 1173: AND AWOS.workorder_id IN (SELECT workorder_id FROM ahl_workorders WO,ahl_visit_tasks_b VTS WHERE

1169: AND AWOS.WIP_ENTITY_ID = WIRO.WIP_ENTITY_ID
1170: AND ASML.OPERATION_SEQUENCE = WIRO.OPERATION_SEQ_NUM
1171: AND ASML.INVENTORY_ITEM_ID = WIRO.INVENTORY_ITEM_ID
1172: AND ASML.ORGANIZATION_ID = WIRO.ORGANIZATION_ID and asml.status = 'ACTIVE'
1173: AND AWOS.workorder_id IN (SELECT workorder_id FROM ahl_workorders WO,ahl_visit_tasks_b VTS WHERE
1174: WO.visit_id = p_visit_id
1175: AND WO.visit_id = VTS.visit_id
1176: AND WO.visit_task_id = VTS.visit_task_id);
1177:

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 1196: AND AWOS.workorder_id IN (SELECT workorder_id FROM ahl_workorders WO,ahl_visit_tasks_b VTS WHERE

1192: AND AWOS.WIP_ENTITY_ID = WIRO.WIP_ENTITY_ID
1193: AND ASML.OPERATION_SEQUENCE = WIRO.OPERATION_SEQ_NUM
1194: AND ASML.INVENTORY_ITEM_ID = WIRO.INVENTORY_ITEM_ID
1195: AND ASML.ORGANIZATION_ID = WIRO.ORGANIZATION_ID and asml.status = 'ACTIVE'
1196: AND AWOS.workorder_id IN (SELECT workorder_id FROM ahl_workorders WO,ahl_visit_tasks_b VTS WHERE
1197: WO.visit_id = p_visit_id
1198: AND WO.visit_id = VTS.visit_id
1199: AND WO.visit_task_id = VTS.visit_task_id
1200: AND VTS.instance_id = p_item_instance_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 1221: AND AWOS.workorder_id IN (SELECT workorder_id FROM ahl_workorders WO,ahl_visit_tasks_b VTS WHERE

1217: AND AWOS.WIP_ENTITY_ID = WIRO.WIP_ENTITY_ID
1218: AND ASML.OPERATION_SEQUENCE = WIRO.OPERATION_SEQ_NUM
1219: AND ASML.INVENTORY_ITEM_ID = WIRO.INVENTORY_ITEM_ID
1220: AND ASML.ORGANIZATION_ID = WIRO.ORGANIZATION_ID and asml.status = 'ACTIVE'
1221: AND AWOS.workorder_id IN (SELECT workorder_id FROM ahl_workorders WO,ahl_visit_tasks_b VTS WHERE
1222: WO.visit_id = p_visit_id
1223: AND WO.visit_id = VTS.visit_id
1224: AND WO.visit_task_id = VTS.visit_task_id
1225: AND VTS.instance_id IN(

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 1262: AND AWOS.workorder_id IN (SELECT workorder_id FROM ahl_workorders WO,ahl_visit_tasks_b VTS WHERE

1258: AND AWOS.WIP_ENTITY_ID = WIRO.WIP_ENTITY_ID
1259: AND ASML.OPERATION_SEQUENCE = WIRO.OPERATION_SEQ_NUM
1260: AND ASML.INVENTORY_ITEM_ID = WIRO.INVENTORY_ITEM_ID
1261: AND ASML.ORGANIZATION_ID = WIRO.ORGANIZATION_ID and asml.status = 'ACTIVE'
1262: AND AWOS.workorder_id IN (SELECT workorder_id FROM ahl_workorders WO,ahl_visit_tasks_b VTS WHERE
1263: WO.visit_id = p_visit_id
1264: AND WO.visit_id = VTS.visit_id
1265: AND WO.visit_task_id = VTS.visit_task_id)
1266: GROUP BY asml.inventory_item_id,ASML.organization_id,AWOS.WIP_ENTITY_ID,ASML.OPERATION_SEQUENCE;

Line 1417: FROM AHL_WORKORDERS WO,WIP_DISCRETE_JOBS WDJ

1413: ) RETURN NUMBER IS
1414:
1415: CURSOR completed_time_csr(p_visit_id NUMBER) IS
1416: SELECT nvl(SUM(WDJ.SCHEDULED_COMPLETION_DATE - WDJ.SCHEDULED_START_DATE),0)
1417: FROM AHL_WORKORDERS WO,WIP_DISCRETE_JOBS WDJ
1418: WHERE WO.visit_id = p_visit_id
1419: AND WO.wip_entity_id = WDJ.wip_entity_id
1420: AND WO.STATUS_CODE IN('4','5','7','12')
1421: GROUP BY WO.visit_id;

Line 1425: FROM AHL_WORKORDERS

1421: GROUP BY WO.visit_id;
1422:
1423: CURSOR completed_wo_count_csr(p_visit_id NUMBER) IS
1424: SELECT count(*)
1425: FROM AHL_WORKORDERS
1426: WHERE visit_id = p_visit_id
1427: AND STATUS_CODE IN('4','5','7','12')
1428: GROUP BY visit_id;
1429:

Line 1432: FROM AHL_WORKORDERS WO,WIP_DISCRETE_JOBS WDJ

1428: GROUP BY visit_id;
1429:
1430: CURSOR total_time_csr(p_visit_id NUMBER) IS
1431: SELECT nvl(SUM(WDJ.SCHEDULED_COMPLETION_DATE - WDJ.SCHEDULED_START_DATE),0)
1432: FROM AHL_WORKORDERS WO,WIP_DISCRETE_JOBS WDJ
1433: WHERE WO.visit_id = p_visit_id
1434: AND WO.wip_entity_id = WDJ.wip_entity_id
1435: AND wo.STATUS_CODE NOT IN ('22','17')
1436: GROUP BY WO.visit_id;

Line 1440: FROM AHL_WORKORDERS

1436: GROUP BY WO.visit_id;
1437:
1438: CURSOR total_wo_count_csr(p_visit_id NUMBER) IS
1439: SELECT count(*)
1440: FROM AHL_WORKORDERS
1441: WHERE visit_id = p_visit_id
1442: AND STATUS_CODE NOT IN ('22','17')
1443: GROUP BY visit_id;
1444: