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_VISIT_TASKS_B

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 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 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 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 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 948: ahl_visit_tasks_b VTS

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
952: AND WO.visit_task_id = VTS.visit_task_id

Line 959: ahl_visit_tasks_b VTS

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
963: AND WO.visit_task_id = VTS.visit_task_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 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 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 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 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 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 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 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 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;