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_TASKS_PVT dependencies on AHL_VISIT_TASKS_B

Line 253: nvl(VST.INVENTORY_ITEM_ID, (select inventory_item_id from ahl_visit_tasks_b where visit_id = vst.visit_id and rownum = 1) ),

249: WIP.SCHEDULED_COMPLETION_DATE SCHEDULED_END_DATE,
250: WO.ACTUAL_START_DATE ACTUAL_START_DATE,
251: WO.ACTUAL_END_DATE ACTUAL_END_DATE,
252: NVL2( WO.VISIT_TASK_ID,
253: nvl(VST.INVENTORY_ITEM_ID, (select inventory_item_id from ahl_visit_tasks_b where visit_id = vst.visit_id and rownum = 1) ),
254: VST.INVENTORY_ITEM_ID) INVENTORY_ITEM_ID,
255: NVL2( WO.VISIT_TASK_ID,
256: nvl (VST.ITEM_INSTANCE_ID, (select instance_id from ahl_visit_tasks_b where visit_id = vst.visit_id and rownum = 1) ),
257: VST.ITEM_INSTANCE_ID) ITEM_INSTANCE_ID,

Line 256: nvl (VST.ITEM_INSTANCE_ID, (select instance_id from ahl_visit_tasks_b where visit_id = vst.visit_id and rownum = 1) ),

252: NVL2( WO.VISIT_TASK_ID,
253: nvl(VST.INVENTORY_ITEM_ID, (select inventory_item_id from ahl_visit_tasks_b where visit_id = vst.visit_id and rownum = 1) ),
254: VST.INVENTORY_ITEM_ID) INVENTORY_ITEM_ID,
255: NVL2( WO.VISIT_TASK_ID,
256: nvl (VST.ITEM_INSTANCE_ID, (select instance_id from ahl_visit_tasks_b where visit_id = vst.visit_id and rownum = 1) ),
257: VST.ITEM_INSTANCE_ID) ITEM_INSTANCE_ID,
258: WO.MASTER_WORKORDER_FLAG MASTER_WORKORDER_FLAG,
259: VST.PROJECT_ID PROJECT_ID,
260: NVL2( WO.VISIT_TASK_ID,VTS.PROJECT_TASK_ID,TO_NUMBER(NULL)) PROJECT_TASK_ID,

Line 264: AHL_VISIT_TASKS_B VTS,

260: NVL2( WO.VISIT_TASK_ID,VTS.PROJECT_TASK_ID,TO_NUMBER(NULL)) PROJECT_TASK_ID,
261: NVL2( WO.VISIT_TASK_ID,VTS.SERVICE_REQUEST_ID,TO_NUMBER(NULL)) INCIDENT_ID
262: FROM AHL_WORKORDERS WO,
263: AHL_VISITS_B VST,
264: AHL_VISIT_TASKS_B VTS,
265: WIP_DISCRETE_JOBS WIP
266: WHERE WIP.WIP_ENTITY_ID=WO.WIP_ENTITY_ID
267: AND WO.VISIT_ID = VST.VISIT_ID
268: AND WO.VISIT_ID = VTS.VISIT_ID(+)

Line 464: FROM ahl_visit_tasks_b

460: */
461:
462: CURSOR c_task_type (x_T_id IN NUMBER) IS
463: SELECT TASK_TYPE_CODE,MR_ID
464: FROM ahl_visit_tasks_b
465: WHERE VISIT_TASK_ID = x_T_id;
466: c_task_type_rec c_task_type%ROWTYPE;
467:
468: CURSOR c_non_summary_task_details(x_T_id IN NUMBER) IS

Line 516: AHL_VISIT_TASKS_B ATSK,

512: ATSK.MR_ID MR_ID,
513: ATSK.UNIT_EFFECTIVITY_ID UNIT_EFFECTIVITY_ID,
514: AMRH.DESCRIPTION MR_DESCRIPTION
515: FROM AHL_VISITS_B AVTS,
516: AHL_VISIT_TASKS_B ATSK,
517: AHL_VISIT_TASKS_TL ATSKL,
518: AHL_VISIT_TASKS_VL ORIGTSK,
519: AHL_MR_ROUTES AMRR,
520: AHL_MR_HEADERS_VL AMRH,

Line 615: AHL_VISIT_TASKS_B ATSK,

611: ATSK.MR_ID MR_ID,
612: ATSK.UNIT_EFFECTIVITY_ID UNIT_EFFECTIVITY_ID,
613: AMRH.DESCRIPTION MR_DESCRIPTION
614: FROM AHL_VISITS_B AVTS,
615: AHL_VISIT_TASKS_B ATSK,
616: AHL_VISIT_TASKS_TL ATSKL,
617: AHL_VISIT_TASKS_VL ORIGTSK,
618: AHL_MR_HEADERS_VL AMRH,
619: AHL_UNIT_EFFECTIVITIES_B AUEF,

Line 801: SELECT Visit_Task_Number FROM Ahl_Visit_Tasks_B

797: c_unitofmeasure_rec c_unitofmeasure%ROWTYPE;
798:
799: -- To find task number for cost_parent_id and originating task id
800: CURSOR c_number(x_id IN NUMBER) IS
801: SELECT Visit_Task_Number FROM Ahl_Visit_Tasks_B
802: WHERE Visit_Task_Id = x_id;
803:
804: -- To find project task nubmer for project's task
805: CURSOR c_proj_task (x_id IN NUMBER) IS

Line 2136: FROM ahl_visit_tasks_b

2132: -- bug fix #4181411
2133: -- yazhou 17-Feb-2005
2134: CURSOR get_task_inst_dtls(c_visit_id IN NUMBER) IS
2135: SELECT inventory_item_id,item_organization_id
2136: FROM ahl_visit_tasks_b
2137: WHERE visit_id = c_visit_id
2138: AND nvl(status_code,'x') <> 'DELETED'
2139: AND ROWNUM = 1;
2140:

Line 3195: UPDATE AHL_VISIT_TASKS_B

3191: FETCH c_all_task INTO l_all_task_rec;
3192: EXIT WHEN c_all_task%NOTFOUND;
3193: -- Tasks found for visit
3194: -- To set prices to NULL in case if the visit's department is changed
3195: UPDATE AHL_VISIT_TASKS_B
3196: SET ACTUAL_PRICE = NULL, ESTIMATED_PRICE = NULL,
3197: OBJECT_VERSION_NUMBER = l_all_task_rec.object_version_number + 1
3198: WHERE VISIT_TASK_ID = l_all_task_rec.visit_task_id;
3199: END LOOP;

Line 4930: FROM ahl_visit_tasks_b

4926:
4927: CURSOR c_visit_task_exists(p_visit_id IN NUMBER)
4928: IS
4929: SELECT 'x'
4930: FROM ahl_visit_tasks_b
4931: WHERE visit_id = p_visit_id
4932: AND STATUS_CODE = 'PLANNING';
4933:
4934: -- yazhou end

Line 5403: SELECT COUNT(*) FROM Ahl_Task_Links L ,Ahl_Visit_Tasks_B T

5399: c_primary_rec c_primary%ROWTYPE;
5400:
5401: -- To find any task links for a deleted task
5402: CURSOR c_links (x_id IN NUMBER) IS
5403: SELECT COUNT(*) FROM Ahl_Task_Links L ,Ahl_Visit_Tasks_B T
5404: WHERE (T.VISIT_TASK_ID = L.VISIT_TASK_ID OR T.VISIT_TASK_ID = L.PARENT_TASK_ID)
5405: AND T.VISIT_TASK_ID = x_id;
5406:
5407: -- To find if WIP job is created for the Visit

Line 5584: UPDATE AHL_VISIT_TASKS_B SET PRIMARY_VISIT_TASK_ID = NULL,

5580: LOOP
5581: FETCH c_primary INTO c_primary_rec;
5582: EXIT WHEN c_primary%NOTFOUND;
5583: IF c_primary_rec.visit_task_id IS NOT NULL THEN
5584: UPDATE AHL_VISIT_TASKS_B SET PRIMARY_VISIT_TASK_ID = NULL,
5585: OBJECT_VERSION_NUMBER = c_primary_rec.object_version_number + 1
5586: WHERE --VISIT_ID = l_visit_id AND
5587: VISIT_TASK_ID = c_primary_rec.visit_task_id;
5588: IF (l_log_statement >= l_log_current_level) THEN

Line 5591: 'Updated AHL_VISIT_TASKS_B for Visit Task Id = ' || c_primary_rec.visit_task_id);

5587: VISIT_TASK_ID = c_primary_rec.visit_task_id;
5588: IF (l_log_statement >= l_log_current_level) THEN
5589: fnd_log.string(l_log_statement,
5590: L_DEBUG_KEY,
5591: 'Updated AHL_VISIT_TASKS_B for Visit Task Id = ' || c_primary_rec.visit_task_id);
5592: END IF;
5593: END IF;
5594: END LOOP;
5595: CLOSE c_primary;

Line 5662: -- Delete task base (AHL_VISIT_TASKS_B) table data

5658: END IF;
5659: RAISE Fnd_Api.g_exc_error;
5660: END IF;
5661:
5662: -- Delete task base (AHL_VISIT_TASKS_B) table data
5663: DELETE FROM Ahl_Visit_Tasks_B
5664: WHERE Visit_Task_ID = l_task_id;
5665:
5666: IF (SQL%NOTFOUND) THEN

Line 5663: DELETE FROM Ahl_Visit_Tasks_B

5659: RAISE Fnd_Api.g_exc_error;
5660: END IF;
5661:
5662: -- Delete task base (AHL_VISIT_TASKS_B) table data
5663: DELETE FROM Ahl_Visit_Tasks_B
5664: WHERE Visit_Task_ID = l_task_id;
5665:
5666: IF (SQL%NOTFOUND) THEN
5667: Fnd_Message.set_name ('AHL', 'AHL_API_RECORD_NOT_FOUND');

Line 5673: UPDATE AHL_VISIT_TASKS_B

5669: RAISE Fnd_Api.g_exc_error;
5670: END IF;
5671:
5672: ELSE
5673: UPDATE AHL_VISIT_TASKS_B
5674: SET STATUS_CODE='DELETED',UNIT_EFFECTIVITY_ID=NULL,
5675: OBJECT_VERSION_NUMBER=OBJECT_VERSION_NUMBER+1
5676: WHERE VISIT_TASK_ID=l_task_id;
5677:

Line 5802: SELECT COUNT(*) FROM Ahl_Task_Links L ,Ahl_Visit_Tasks_B T

5798: c_primary_rec c_primary%ROWTYPE;
5799:
5800: -- To find any task links for a deleted task
5801: CURSOR c_links (x_id IN NUMBER) IS
5802: SELECT COUNT(*) FROM Ahl_Task_Links L ,Ahl_Visit_Tasks_B T
5803: WHERE (T.VISIT_TASK_ID = L.VISIT_TASK_ID
5804: OR T.VISIT_TASK_ID = L.PARENT_TASK_ID)
5805: AND T.VISIT_TASK_ID = x_id;
5806:

Line 5817: FROM ahl_visit_tasks_b

5813:
5814: CURSOR c_SR_tasks(c_visit_id NUMBER, c_sr_id NUMBER)
5815: IS
5816: SELECT visit_task_id
5817: FROM ahl_visit_tasks_b
5818: WHERE visit_id = c_visit_id
5819: START WITH originating_task_id IS NULL
5820: AND SERVICE_REQUEST_ID = c_sr_id
5821: CONNECT BY PRIOR visit_task_id = originating_task_id

Line 6009: UPDATE AHL_VISIT_TASKS_B

6005: FETCH c_primary INTO c_primary_rec;
6006: EXIT WHEN c_primary%NOTFOUND;
6007: IF c_primary_rec.visit_task_id IS NOT NULL
6008: THEN
6009: UPDATE AHL_VISIT_TASKS_B
6010: SET PRIMARY_VISIT_TASK_ID = NULL,
6011: OBJECT_VERSION_NUMBER = c_primary_rec.object_version_number + 1
6012: WHERE --VISIT_ID = l_visit_id AND
6013: VISIT_TASK_ID = c_primary_rec.visit_task_id;

Line 6074: UPDATE AHL_VISIT_TASKS_B

6070: END IF;
6071:
6072: --IF NVL(l_workorder_present,'X') ='Y' THEN
6073: IF c_task_rec.service_request_id IS NOT NULL THEN
6074: UPDATE AHL_VISIT_TASKS_B
6075: SET STATUS_CODE='DELETED',UNIT_EFFECTIVITY_ID=NULL,
6076: OBJECT_VERSION_NUMBER=OBJECT_VERSION_NUMBER+1
6077: WHERE VISIT_TASK_ID=l_task_id;
6078: ELSE

Line 6092: -- Delete task base (AHL_VISIT_TASKS_B) table data

6088: CLOSE c_SR_tasks;
6089: RAISE Fnd_Api.g_exc_error;
6090: END IF;
6091:
6092: -- Delete task base (AHL_VISIT_TASKS_B) table data
6093:
6094: IF (l_log_statement >= l_log_current_level) THEN
6095: fnd_log.string(l_log_statement,
6096: L_DEBUG_KEY,

Line 6100: DELETE FROM Ahl_Visit_Tasks_B

6096: L_DEBUG_KEY,
6097: ':Delete from base task table');
6098: END IF;
6099:
6100: DELETE FROM Ahl_Visit_Tasks_B
6101: WHERE Visit_Task_ID = l_task_id;
6102:
6103: IF (SQL%NOTFOUND) THEN
6104: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error)

Line 6247: SELECT COUNT(*) FROM Ahl_Task_Links L ,Ahl_Visit_Tasks_B T

6243: c_primary_rec c_primary%ROWTYPE;
6244:
6245: -- To find any task links for a deleted task
6246: CURSOR c_links (x_id IN NUMBER) IS
6247: SELECT COUNT(*) FROM Ahl_Task_Links L ,Ahl_Visit_Tasks_B T
6248: WHERE (T.VISIT_TASK_ID = L.VISIT_TASK_ID
6249: OR T.VISIT_TASK_ID = L.PARENT_TASK_ID)
6250: AND T.VISIT_TASK_ID = x_id;
6251:

Line 6265: FROM ahl_visit_tasks_b

6261:
6262: --Dup-MR ER#6338208 - sowsubra
6263: CURSOR c_all_tasks(c_visit_id NUMBER, c_task_id NUMBER) IS
6264: SELECT visit_task_id
6265: FROM ahl_visit_tasks_b
6266: WHERE visit_id = c_visit_id
6267: AND STATUS_CODE <> 'DELETED'
6268: START WITH visit_task_id = c_task_id
6269: CONNECT BY PRIOR visit_task_id = originating_task_id

Line 6277: SELECT 'X' from ahl_visit_tasks_b where unit_effectivity_id = c_ue_id and

6273:
6274: --Added by mpothuku on 02/03/05
6275: --To check if the unplanned tasks UE is associated with any other visits other than itself before its deletion.
6276: CURSOR check_unplanned_ue_assoc(c_ue_id IN NUMBER) IS
6277: SELECT 'X' from ahl_visit_tasks_b where unit_effectivity_id = c_ue_id and
6278: status_code <> 'DELETED';
6279: BEGIN
6280: IF (l_log_procedure >= l_log_current_level) THEN
6281: fnd_log.string(l_log_procedure,

Line 6522: UPDATE AHL_VISIT_TASKS_B

6518: FETCH c_primary INTO c_primary_rec;
6519: EXIT WHEN c_primary%NOTFOUND;
6520: IF c_primary_rec.visit_task_id IS NOT NULL
6521: THEN
6522: UPDATE AHL_VISIT_TASKS_B
6523: SET PRIMARY_VISIT_TASK_ID = NULL,
6524: OBJECT_VERSION_NUMBER = c_primary_rec.object_version_number + 1
6525: WHERE --VISIT_ID = l_visit_id
6526: VISIT_TASK_ID = c_primary_rec.visit_task_id;

Line 6594: UPDATE AHL_VISIT_TASKS_B

6590: l_task_type := l_task_rec.TASK_TYPE_CODE;
6591: l_unit_effectivity_id := l_task_rec.UNIT_EFFECTIVITY_ID;
6592: END IF;
6593: END IF;
6594: UPDATE AHL_VISIT_TASKS_B
6595: SET STATUS_CODE='DELETED',UNIT_EFFECTIVITY_ID=NULL,
6596: OBJECT_VERSION_NUMBER=OBJECT_VERSION_NUMBER+1
6597: WHERE VISIT_TASK_ID=l_task_id;
6598: ELSE

Line 6616: -- Delete task base (AHL_VISIT_TASKS_B) table data

6612: CLOSE c_all_tasks;
6613: RAISE Fnd_Api.g_exc_error;
6614: END IF;
6615:
6616: -- Delete task base (AHL_VISIT_TASKS_B) table data
6617: IF (l_log_statement >= l_log_current_level)THEN
6618: fnd_log.string(l_log_statement,
6619: L_DEBUG_KEY,
6620: ':Delete from base task table');

Line 6623: DELETE FROM Ahl_Visit_Tasks_B

6619: L_DEBUG_KEY,
6620: ':Delete from base task table');
6621: END IF;
6622:
6623: DELETE FROM Ahl_Visit_Tasks_B
6624: WHERE Visit_Task_ID = l_task_id;
6625:
6626: IF (SQL%NOTFOUND) THEN
6627: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error)

Line 6764: UPDATE AHL_VISIT_TASKS_B

6760: LOOP
6761: FETCH c_primary INTO c_primary_rec;
6762: EXIT WHEN c_primary%NOTFOUND;
6763: IF c_primary_rec.visit_task_id IS NOT NULL THEN
6764: UPDATE AHL_VISIT_TASKS_B
6765: SET PRIMARY_VISIT_TASK_ID = NULL,
6766: OBJECT_VERSION_NUMBER = c_primary_rec.object_version_number + 1
6767: WHERE --VISIT_ID = l_visit_id AND
6768: VISIT_TASK_ID = c_primary_rec.visit_task_id;

Line 6812: UPDATE AHL_VISIT_TASKS_B

6808: RAISE Fnd_Api.G_EXC_ERROR;
6809: END IF;
6810:
6811: -- Update Task status to 'DELETED'
6812: UPDATE AHL_VISIT_TASKS_B
6813: SET STATUS_CODE='DELETED',UNIT_EFFECTIVITY_ID=NULL,
6814: OBJECT_VERSION_NUMBER=OBJECT_VERSION_NUMBER+1
6815: WHERE VISIT_TASK_ID=l_task_id;
6816: ELSE

Line 6827: -- Delete task base (AHL_VISIT_TASKS_B) table data

6823: Fnd_Msg_Pub.ADD;
6824: RAISE Fnd_Api.g_exc_error;
6825: END IF;
6826:
6827: -- Delete task base (AHL_VISIT_TASKS_B) table data
6828: IF (l_log_statement >= l_log_current_level) THEN
6829: fnd_log.string(l_log_statement,
6830: L_DEBUG_KEY,
6831: ':Delete from base task table');

Line 6834: DELETE FROM Ahl_Visit_Tasks_B

6830: L_DEBUG_KEY,
6831: ':Delete from base task table');
6832: END IF;
6833:
6834: DELETE FROM Ahl_Visit_Tasks_B
6835: WHERE Visit_Task_ID = l_task_id;
6836:
6837: IF (SQL%NOTFOUND) THEN
6838: Fnd_Message.set_name ('AHL', 'AHL_API_RECORD_NOT_FOUND');

Line 6941: FROM AHL_VISIT_TASKS_B

6937: -- To find task type code, start, end time of a task
6938: --POST 11.5.10 cxcheng change --------------
6939: CURSOR get_task_times_csr (p_task_id IN NUMBER) IS
6940: SELECT task_type_code, start_date_time, end_date_time
6941: FROM AHL_VISIT_TASKS_B
6942: WHERE VISIT_TASK_ID = p_task_id;
6943:
6944: BEGIN
6945: --------------------- initialize -----------------------