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 118: FROM ahl_workorders

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

Line 362: FROM AHL_WORKORDERS

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

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

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

Line 385: from ahl_workorders awo2

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

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

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

Line 393: from ahl_workorders awo2

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

Line 671: FROM AHL_WORKORDERS AWO

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

Line 685: FROM AHL_VISIT_TASKS_B AVTB, AHL_WORKORDERS AWV

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

Line 867: FROM AHL_WORKORDERS AWO

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

Line 893: FROM AHL_WORKORDERS AWV

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

Line 1080: FROM AHL_WORKORDERS AWV

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

Line 1309: FROM AHL_WORKORDERS AWO

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

Line 1513: SELECT WORKORDER_ID FROM AHL_WORKORDERS

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

Line 2050: FROM ahl_workorders

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