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 96: SELECT VTS.instance_id FROM ahl_workorders WO,ahl_visit_tasks_b VTS WHERE

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

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

143: AND AWOS.WIP_ENTITY_ID = WIRO.WIP_ENTITY_ID
144: AND ASML.OPERATION_SEQUENCE = WIRO.OPERATION_SEQ_NUM
145: AND ASML.INVENTORY_ITEM_ID = WIRO.INVENTORY_ITEM_ID
146: AND ASML.ORGANIZATION_ID = WIRO.ORGANIZATION_ID and asml.status = 'ACTIVE'
147: AND AWOS.workorder_id IN (SELECT workorder_id FROM ahl_workorders WO,ahl_visit_tasks_b VTS WHERE
148: WO.visit_id = p_visit_id
149: AND WO.visit_id = VTS.visit_id
150: AND WO.visit_task_id = VTS.visit_task_id
151: AND VTS.instance_id IN(

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

212: AND AWOS.WIP_ENTITY_ID = WIRO.WIP_ENTITY_ID
213: AND ASML.OPERATION_SEQUENCE = WIRO.OPERATION_SEQ_NUM
214: AND ASML.INVENTORY_ITEM_ID = WIRO.INVENTORY_ITEM_ID
215: AND ASML.ORGANIZATION_ID = WIRO.ORGANIZATION_ID and asml.status = 'ACTIVE'
216: AND AWOS.workorder_id IN (SELECT workorder_id FROM ahl_workorders WO,ahl_visit_tasks_b VTS WHERE
217: WO.visit_id = p_visit_id
218: AND WO.visit_id = VTS.visit_id
219: AND WO.visit_task_id = VTS.visit_task_id
220: ))REQ WHERE

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

529: j NUMBER;
530:
531: CURSOR get_root_items_instance_csr(p_visit_id NUMBER,
532: p_item_instance_id NUMBER) IS
533: SELECT VTS.instance_id FROM ahl_workorders WO,ahl_visit_tasks_b VTS WHERE
534: WO.visit_id = p_visit_id
535: AND WO.visit_id = VTS.visit_id
536: AND WO.visit_task_id = VTS.visit_task_id
537: AND VTS.instance_id = p_item_instance_id

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

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

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

644: AND AWOS.WIP_ENTITY_ID = WIRO.WIP_ENTITY_ID
645: AND ASML.OPERATION_SEQUENCE = WIRO.OPERATION_SEQ_NUM
646: AND ASML.INVENTORY_ITEM_ID = WIRO.INVENTORY_ITEM_ID
647: AND ASML.ORGANIZATION_ID = WIRO.ORGANIZATION_ID and asml.status = 'ACTIVE'
648: AND AWOS.workorder_id IN (SELECT workorder_id FROM ahl_workorders WO,ahl_visit_tasks_b VTS WHERE
649: WO.visit_id = p_visit_id
650: AND WO.visit_id = VTS.visit_id
651: AND WO.visit_task_id = VTS.visit_task_id
652: ))REQ WHERE

Line 908: AND workorder_id IN (SELECT workorder_id FROM ahl_workorders WO,ahl_visit_tasks_b VTS WHERE

904: SELECT COUNT(*)
905: FROM AHL_SEARCH_WORKORDERS_V
906: WHERE visit_id = p_visit_id
907: AND JOB_STATUS_CODE IN('4','5','7','12')
908: AND workorder_id IN (SELECT workorder_id FROM ahl_workorders WO,ahl_visit_tasks_b VTS WHERE
909: WO.visit_id = p_visit_id
910: AND WO.visit_id = VTS.visit_id
911: AND WO.visit_task_id = VTS.visit_task_id
912: AND VTS.instance_id = p_item_instance_id);

Line 919: AND workorder_id IN (SELECT workorder_id FROM ahl_workorders WO,ahl_visit_tasks_b VTS WHERE

915: SELECT COUNT(*)
916: FROM AHL_SEARCH_WORKORDERS_V
917: WHERE visit_id = p_visit_id
918: AND JOB_STATUS_CODE IN('4','5','7','12')
919: AND workorder_id IN (SELECT workorder_id FROM ahl_workorders WO,ahl_visit_tasks_b VTS WHERE
920: WO.visit_id = p_visit_id
921: AND WO.visit_id = VTS.visit_id
922: AND WO.visit_task_id = VTS.visit_task_id
923: AND VTS.instance_id IN(

Line 947: AND workorder_id IN (SELECT workorder_id FROM ahl_workorders WO,ahl_visit_tasks_b VTS WHERE

943: SELECT COUNT(*)
944: FROM AHL_SEARCH_WORKORDERS_V
945: WHERE visit_id = p_visit_id
946: AND JOB_STATUS_CODE <> '22'
947: AND workorder_id IN (SELECT workorder_id FROM ahl_workorders WO,ahl_visit_tasks_b VTS WHERE
948: WO.visit_id = p_visit_id
949: AND WO.visit_id = VTS.visit_id
950: AND WO.visit_task_id = VTS.visit_task_id
951: AND VTS.instance_id = p_item_instance_id);

Line 958: AND workorder_id IN (SELECT workorder_id FROM ahl_workorders WO,ahl_visit_tasks_b VTS WHERE

954: SELECT COUNT(*)
955: FROM AHL_SEARCH_WORKORDERS_V
956: WHERE visit_id = p_visit_id
957: AND JOB_STATUS_CODE <> '22'
958: AND workorder_id IN (SELECT workorder_id FROM ahl_workorders WO,ahl_visit_tasks_b VTS WHERE
959: WO.visit_id = p_visit_id
960: AND WO.visit_id = VTS.visit_id
961: AND WO.visit_task_id = VTS.visit_task_id
962: AND VTS.instance_id IN(

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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