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_VWP_COST_PVT dependencies on AHL_WORKORDERS

Line 90: FROM ahl_workorders

86: -- Get master workorder details
87: CURSOR c_master_wo_cur (C_VISIT_ID IN NUMBER)
88: IS
89: SELECT workorder_id,wip_entity_id, visit_id
90: FROM ahl_workorders
91: WHERE visit_id = C_VISIT_ID AND VISIT_TASK_ID IS NULL
92: AND master_workorder_flag = 'Y'
93: AND STATUS_CODE NOT IN ('22','7');
94:

Line 115: FROM ahl_workorders

111: -- Get child workorder details
112: CURSOR c_child_wo_cur (C_VISIT_TASK_ID IN NUMBER)
113: IS
114: SELECT workorder_id,wip_entity_id,visit_task_id
115: FROM ahl_workorders
116: WHERE visit_task_id = C_VISIT_TASK_ID
117: -- AND STATUS_CODE NOT IN ('22','7');
118: AND STATUS_CODE <>'22'
119: ORDER BY LAST_UPDATE_DATE DESC;

Line 359: FROM AHL_WORKORDERS

355: -- Get the Visit Workorder
356: CURSOR c_get_visit_wo( c_visit_id NUMBER)
357: IS
358: SELECT wip_entity_id
359: FROM AHL_WORKORDERS
360: WHERE visit_id = c_visit_id
361: AND visit_task_id IS NULL
362: AND STATUS_CODE NOT IN ('22','7')
363: AND master_workorder_flag = 'Y';

Line 377: AND not exists (select 1 from ahl_workorders awo1

373: level
374: FROM WIP_SCHED_RELATIONSHIPS
375: WHERE parent_object_type_id = 1
376: AND child_object_type_id = 1
377: AND not exists (select 1 from ahl_workorders awo1
378: where awo1.wip_entity_id = parent_object_id
379: and ( awo1.status_code ='22'
380: OR (awo1.status_code ='7'
381: AND awo1.LAST_UPDATE_DATE <> (select MAX(LAST_UPDATE_DATE)

Line 382: from ahl_workorders awo2

378: where awo1.wip_entity_id = parent_object_id
379: and ( awo1.status_code ='22'
380: OR (awo1.status_code ='7'
381: AND awo1.LAST_UPDATE_DATE <> (select MAX(LAST_UPDATE_DATE)
382: from ahl_workorders awo2
383: where visit_task_id = awo1.visit_task_id)))
384: )
385: AND not exists (select 1 from ahl_workorders awo1
386: where awo1.wip_entity_id = child_object_id

Line 385: AND not exists (select 1 from ahl_workorders awo1

381: AND awo1.LAST_UPDATE_DATE <> (select MAX(LAST_UPDATE_DATE)
382: from ahl_workorders awo2
383: where visit_task_id = awo1.visit_task_id)))
384: )
385: AND not exists (select 1 from ahl_workorders awo1
386: where awo1.wip_entity_id = child_object_id
387: and ( awo1.status_code ='22'
388: OR (awo1.status_code ='7'
389: AND awo1.LAST_UPDATE_DATE <> (select MAX(LAST_UPDATE_DATE)

Line 390: from ahl_workorders awo2

386: where awo1.wip_entity_id = child_object_id
387: and ( awo1.status_code ='22'
388: OR (awo1.status_code ='7'
389: AND awo1.LAST_UPDATE_DATE <> (select MAX(LAST_UPDATE_DATE)
390: from ahl_workorders awo2
391: where visit_task_id = awo1.visit_task_id)))
392: )
393: START WITH parent_object_id = c_wip_entity_id
394: AND relationship_type = 1

Line 668: FROM AHL_WORKORDERS AWO

664: -- Define local cursors
665: -- To find out WIP_Entity_Id for the visit
666: CURSOR c_job(x_id IN NUMBER) IS
667: SELECT AWO.WIP_ENTITY_ID
668: FROM AHL_WORKORDERS AWO
669: WHERE AWO.VISIT_ID = x_id
670: AND VISIT_TASK_ID IS NULL
671: AND AWO.STATUS_CODE NOT IN ('22','7')
672: AND AWO.MASTER_WORKORDER_FLAG = 'Y';

Line 682: FROM AHL_VISIT_TASKS_B AVTB, AHL_WORKORDERS AWV

678: -- To find out to find out all task's Workorder_Id within visit except those,
679: -- which have task_type_code = 'Summary' and MR_id is Null i.e manually created Summary task
680: CURSOR c_WO_tasks (x_id IN NUMBER) IS
681: SELECT AVTB.VISIT_TASK_ID, AWV.WORKORDER_ID
682: FROM AHL_VISIT_TASKS_B AVTB, AHL_WORKORDERS AWV
683: WHERE AVTB.VISIT_TASK_ID = AWV.VISIT_TASK_ID
684: AND AVTB.VISIT_ID = x_id
685: AND NVL(AVTB.status_code, 'Y') <> NVL ('DELETED', 'X')
686: -- AND AWV.STATUS_CODE NOT IN ('22','7')

Line 864: FROM AHL_WORKORDERS AWO

860:
861: -- To find out WIP_Entity_Id for the MR task
862: CURSOR c_job(x_id IN NUMBER) IS
863: SELECT AWO.WIP_ENTITY_ID
864: FROM AHL_WORKORDERS AWO
865: WHERE AWO.VISIT_TASK_ID = x_id
866: -- AND AWO.STATUS_CODE NOT IN ('22','7')
867: AND AWO.STATUS_CODE <>'22'
868: AND AWO.MASTER_WORKORDER_FLAG = 'Y'

Line 890: FROM AHL_WORKORDERS AWV

886:
887: -- To find out to find out task's Workorder_Id
888: CURSOR c_WO_tasks (x_id IN NUMBER) IS
889: SELECT AWV.WORKORDER_ID
890: FROM AHL_WORKORDERS AWV
891: WHERE AWV.VISIT_TASK_ID = x_id
892: -- AND AWO.STATUS_CODE NOT IN ('22','7')
893: AND AWV.STATUS_CODE <>'22'
894: ORDER BY LAST_UPDATE_DATE DESC;

Line 1077: FROM AHL_WORKORDERS AWV

1073:
1074: -- To find out to find out task's Workorder_Id
1075: CURSOR c_WO_tasks (x_id IN NUMBER) IS
1076: SELECT AWV.WORKORDER_ID, AWV.wip_entity_id
1077: FROM AHL_WORKORDERS AWV
1078: WHERE AWV.VISIT_TASK_ID = x_id
1079: -- AND AWV.STATUS_CODE NOT IN ('22','7')
1080: AND AWV.STATUS_CODE <>'22'
1081: ORDER BY LAST_UPDATE_DATE DESC;

Line 1306: FROM AHL_WORKORDERS AWO

1302:
1303: -- To find out WIP_Entity_Id for the task
1304: CURSOR c_job(x_id IN NUMBER) IS
1305: SELECT AWO.WIP_ENTITY_ID, AWO.WORKORDER_ID
1306: FROM AHL_WORKORDERS AWO
1307: WHERE AWO.VISIT_TASK_ID = x_id
1308: -- AND AWO.STATUS_CODE NOT IN ('22','7')
1309: AND AWO.STATUS_CODE <>'22'
1310: AND AWO.MASTER_WORKORDER_FLAG = 'N'

Line 1510: SELECT WORKORDER_ID FROM AHL_WORKORDERS

1506:
1507: -- To find if job exists for the visit at shop floor
1508: -- in 'Draft' status
1509: CURSOR c_job_visit(x_id IN NUMBER) IS
1510: SELECT WORKORDER_ID FROM AHL_WORKORDERS
1511: WHERE VISIT_ID = x_id
1512: AND VISIT_TASK_ID IS NULL
1513: AND STATUS_CODE NOT IN ('22','7')
1514: AND MASTER_WORKORDER_FLAG = 'Y';

Line 2047: FROM ahl_workorders

2043:
2044: -- To find out all wip enities for the current visit
2045: CURSOR c_wip_jobs (x_id IN NUMBER) IS
2046: SELECT wip_entity_id
2047: FROM ahl_workorders
2048: WHERE visit_id = x_id AND STATUS_CODE NOT IN ('22','12');
2049:
2050: -- yazhou 27-Jun-2006 ends
2051: