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

Line 670: FROM AHL_WORKORDERS

666: -- bug 4143943
667: CURSOR get_wo_status(c_workorder_id NUMBER)
668: IS
669: SELECT STATUS_CODE
670: FROM AHL_WORKORDERS
671: WHERE workorder_id = c_workorder_id;
672:
673: -- Balaji added for Release NR error
674: CURSOR get_wo_sch_sec(c_wip_entity_id IN NUMBER)

Line 691: AHL_WORKORDERS

687: SELECT
688: TO_CHAR(actual_start_date, 'ss') actual_start_sec,
689: TO_CHAR(actual_end_date, 'ss') actual_end_sec
690: FROM
691: AHL_WORKORDERS
692: WHERE
693: WORKORDER_ID = c_workorder_id;
694:
695: -- FP bug# 7631453

Line 915: FROM AHL_WORKORDERS AWOS,

911: AWOS.ACTUAL_END_DATE,
912: WIP.SCHEDULED_START_DATE,
913: WIP.SCHEDULED_COMPLETION_DATE,
914: WIP.OWNING_DEPARTMENT
915: FROM AHL_WORKORDERS AWOS,
916: WIP_DISCRETE_JOBS WIP
917: WHERE AWOS.WIP_ENTITY_ID = WIP.WIP_ENTITY_ID
918: AND AWOS.workorder_id = c_workorder_id;
919:

Line 1030: AHL_WORKORDERS WO

1026: IS
1027: SELECT WDJ.scheduled_start_date,
1028: WDJ.scheduled_completion_date
1029: FROM WIP_DISCRETE_JOBS WDJ,
1030: AHL_WORKORDERS WO
1031: WHERE WDJ.wip_entity_id = WO.wip_entity_id
1032: AND WO.visit_task_id IS NULL
1033: AND WO.master_workorder_flag = 'Y'
1034: AND WO.visit_id = c_visit_id;

Line 1041: FROM AHL_WORKORDERS AWOS,

1037: CURSOR get_wo_status(c_workorder_id VARCHAR2)
1038: IS
1039: SELECT AWOS.status_code,
1040: FNDL.meaning
1041: FROM AHL_WORKORDERS AWOS,
1042: FND_LOOKUP_VALUES_VL FNDL
1043: WHERE AWOS.WORKORDER_ID = c_workorder_id
1044: AND FNDL.lookup_type = 'AHL_JOB_STATUS'
1045: AND FNDL.lookup_code(+) = AWOS.status_code;

Line 1402: FROM AHL_WORKORDERS

1398: p_prd_workorder_rec.Visit_task_id<>FND_API.G_MISS_NUM ) THEN
1399:
1400: SELECT COUNT(*)
1401: INTO l_dummy_ctr
1402: FROM AHL_WORKORDERS
1403: WHERE visit_task_id=NVL(p_prd_workorder_rec.visit_task_id,0)
1404: AND LTRIM(RTRIM(status_code)) NOT IN ( G_JOB_STATUS_CANCELLED, G_JOB_STATUS_DELETED );
1405:
1406: IF l_dummy_ctr >0 THEN

Line 1756: ahl_workorders awo

1752: SELECT
1753: nvl(vtsk.quantity, 1)
1754: FROM
1755: ahl_visit_tasks_b vtsk,
1756: ahl_workorders awo
1757: WHERE
1758: vtsk.visit_task_id = awo.visit_task_id AND
1759: awo.workorder_id = p_workorder_id;
1760:

Line 1939: ahl_workorders awo

1935: SELECT
1936: nvl(vtsk.quantity, 1)
1937: FROM
1938: ahl_visit_tasks_b vtsk,
1939: ahl_workorders awo
1940: WHERE
1941: vtsk.visit_task_id = awo.visit_task_id AND
1942: awo.workorder_id = p_workorder_id;
1943:

Line 2547: SELECT AHL_WORKORDERS_S.NEXTVAL

2543: l_sr_summary VARCHAR2(240);
2544: l_sr_type VARCHAR2(30);
2545: BEGIN
2546:
2547: SELECT AHL_WORKORDERS_S.NEXTVAL
2548: INTO p_x_prd_workorder_rec.WORKORDER_ID
2549: FROM DUAL;
2550:
2551: IF p_x_prd_workorder_rec.MASTER_WORKORDER_FLAG = 'Y' AND p_x_prd_workorder_rec.VISIT_TASK_ID IS NULL THEN

Line 2940: AHL_DEBUG_PUB.debug( l_api_name || ' - Before Insert into AHL_WORKORDERS' );

2936: p_x_prd_workorder_rec =>p_x_prd_workorder_rec
2937: );
2938:
2939: IF ( G_DEBUG = 'Y' ) THEN
2940: AHL_DEBUG_PUB.debug( l_api_name || ' - Before Insert into AHL_WORKORDERS' );
2941: END IF;
2942:
2943: -- Begin OGMA Issue # 105 - Balaji
2944: -- update VWP planned task quantity current instance quantity

Line 2970: INSERT INTO AHL_WORKORDERS

2966: END IF;
2967: END IF;
2968: -- End OGMA Issue # 105 - Balaji
2969:
2970: INSERT INTO AHL_WORKORDERS
2971: (
2972: WORKORDER_ID,
2973: OBJECT_VERSION_NUMBER,
2974: LAST_UPDATE_DATE,

Line 3257: AHL_DEBUG_PUB.debug( l_api_name || ' - Before Update AHL_WORKORDERS with wip_entity_id' );

3253: RAISE FND_API.G_EXC_ERROR;
3254: ELSE
3255:
3256: IF ( G_DEBUG = 'Y' ) THEN
3257: AHL_DEBUG_PUB.debug( l_api_name || ' - Before Update AHL_WORKORDERS with wip_entity_id' );
3258: END IF;
3259:
3260: UPDATE AHL_WORKORDERS
3261: SET wip_entity_id = p_x_prd_workorder_rec.wip_entity_id

Line 3260: UPDATE AHL_WORKORDERS

3256: IF ( G_DEBUG = 'Y' ) THEN
3257: AHL_DEBUG_PUB.debug( l_api_name || ' - Before Update AHL_WORKORDERS with wip_entity_id' );
3258: END IF;
3259:
3260: UPDATE AHL_WORKORDERS
3261: SET wip_entity_id = p_x_prd_workorder_rec.wip_entity_id
3262: WHERE workorder_id = p_x_prd_workorder_rec.workorder_id;
3263: END IF;
3264:

Line 3369: FROM AHL_WORKORDERS WO,

3365: WIPJ.scheduled_start_date,
3366: WIPJ.scheduled_completion_date scheduled_end_date,
3367: WO.actual_start_date,
3368: WO.actual_end_date
3369: FROM AHL_WORKORDERS WO,
3370: WIP_SCHED_RELATIONSHIPS WOR,
3371: WIP_DISCRETE_JOBS wipj
3372: WHERE
3373: WIPJ.wip_entity_id = WO.wip_entity_id

Line 3391: AHL_WORKORDERS WO

3387: WO.actual_start_date actual_start_date,
3388: WO.actual_end_date actual_end_date,
3389: WO.status_code status_code
3390: FROM WIP_DISCRETE_JOBS WDJ,
3391: AHL_WORKORDERS WO
3392: WHERE WDJ.wip_entity_id = WO.wip_entity_id
3393: AND WO.status_code <> G_JOB_STATUS_DELETED
3394: AND WO.wip_entity_id in
3395: (

Line 3412: FROM AHL_WORKORDERS AWOS,

3408: IS
3409: SELECT AWOS.status_code,
3410: AWOS.workorder_name,
3411: FNDL.meaning
3412: FROM AHL_WORKORDERS AWOS,
3413: FND_LOOKUP_VALUES_VL FNDL
3414: WHERE AWOS.WORKORDER_ID = c_workorder_id
3415: AND FNDL.lookup_type = 'AHL_JOB_STATUS'
3416: AND FNDL.lookup_code(+) = AWOS.status_code;

Line 3438: FROM CSI_ITEM_INSTANCES CII, AHL_WORKORDERS AWO

3434:
3435: -- Fix for bug# 5347560.
3436: CURSOR chk_inst_in_job (p_workorder_id IN NUMBER) IS
3437: SELECT 'x'
3438: FROM CSI_ITEM_INSTANCES CII, AHL_WORKORDERS AWO
3439: WHERE CII.WIP_JOB_ID = AWO.WIP_ENTITY_ID
3440: AND AWO.workorder_id = p_workorder_id
3441: AND ACTIVE_START_DATE <= SYSDATE
3442: AND ((ACTIVE_END_DATE IS NULL) OR (ACTIVE_END_DATE >= SYSDATE))

Line 3455: AHL_WORKORDERS

3451: IS
3452: SELECT
3453: visit_task_id
3454: FROM
3455: AHL_WORKORDERS
3456: WHERE
3457: workorder_id = p_wo_id;
3458:
3459: l_scheduled_start_date DATE;

Line 3469: l_workorder_name ahl_workorders.workorder_name%TYPE;

3465:
3466: l_employee_id NUMBER;
3467: l_operation_seq_num NUMBER;
3468: l_resource_seq_num NUMBER;
3469: l_workorder_name ahl_workorders.workorder_name%TYPE;
3470:
3471: -- Begin OGMA Issue # 105 - Balaji
3472: -- cursor for checking if given task is planned task created form forecasted UE.
3473: CURSOR c_can_update_quantity(p_task_id NUMBER)

Line 3518: ahl_workorders

3514: IS
3515: SELECT
3516: status_code
3517: FROM
3518: ahl_workorders
3519: WHERE
3520: workorder_id = p_workorder_id;
3521:
3522: l_curr_wo_status VARCHAR2(30);

Line 3739: AHL_DEBUG_PUB.debug( l_api_name || ' - Before Updating AHL_WORKORDERS' );

3735: p_x_prd_workorder_rec.HOLD_REASON_CODE := NULL;
3736: END IF;
3737:
3738: IF ( G_DEBUG = 'Y' ) THEN
3739: AHL_DEBUG_PUB.debug( l_api_name || ' - Before Updating AHL_WORKORDERS' );
3740: END IF;
3741:
3742: -- Begin OGMA Issue # 105 - Balaji
3743: -- update VWP planned task quantity current instance quantity

Line 3774: UPDATE AHL_WORKORDERS SET

3770: END IF;
3771: END IF;
3772: -- End OGMA Issue # 105 - Balaji
3773:
3774: UPDATE AHL_WORKORDERS SET
3775: OBJECT_VERSION_NUMBER =p_x_prd_workorder_rec.OBJECT_VERSION_NUMBER + 1,
3776: LAST_UPDATE_DATE =NVL(p_x_prd_workorder_rec.LAST_UPDATE_DATE,SYSDATE),
3777: LAST_UPDATED_BY =NVL(p_x_prd_workorder_rec.LAST_UPDATED_BY,FND_GLOBAL.user_id),
3778: LAST_UPDATE_LOGIN =NVL(p_x_prd_workorder_rec.LAST_UPDATE_LOGIN,FND_GLOBAL.user_id),

Line 4847: AHL_DEBUG_PUB.debug( l_api_name || 'Updating AHL_WORKORDERS with wip_entity_id for Workorder ' || i );

4843: FOR i IN p_x_prd_workorder_tbl.FIRST..p_x_prd_workorder_tbl.LAST LOOP
4844:
4845: IF ( p_x_prd_workorder_tbl(i).dml_operation = 'C' ) THEN
4846: IF ( G_DEBUG = 'Y' ) THEN
4847: AHL_DEBUG_PUB.debug( l_api_name || 'Updating AHL_WORKORDERS with wip_entity_id for Workorder ' || i );
4848: END IF;
4849:
4850: UPDATE AHL_WORKORDERS
4851: SET wip_entity_id = l_eam_wo_tbl(i).wip_entity_id,

Line 4850: UPDATE AHL_WORKORDERS

4846: IF ( G_DEBUG = 'Y' ) THEN
4847: AHL_DEBUG_PUB.debug( l_api_name || 'Updating AHL_WORKORDERS with wip_entity_id for Workorder ' || i );
4848: END IF;
4849:
4850: UPDATE AHL_WORKORDERS
4851: SET wip_entity_id = l_eam_wo_tbl(i).wip_entity_id,
4852: object_version_number = p_x_prd_workorder_tbl(i).object_version_number + 1,
4853: last_update_date = SYSDATE,
4854: last_updated_by = Fnd_Global.USER_ID,

Line 4882: AHL_DEBUG_PUB.debug( l_api_name || 'Updating AHL_WORKORDERS with status code for Workorder ' || i );

4878: END IF;
4879:
4880: ELSIF ( p_x_prd_workorder_tbl(i).dml_operation = 'U' ) THEN
4881: IF ( G_DEBUG = 'Y' ) THEN
4882: AHL_DEBUG_PUB.debug( l_api_name || 'Updating AHL_WORKORDERS with status code for Workorder ' || i );
4883: END IF;
4884: --
4885: UPDATE AHL_WORKORDERS
4886: SET status_code = l_eam_wo_tbl(i).status_type,

Line 4885: UPDATE AHL_WORKORDERS

4881: IF ( G_DEBUG = 'Y' ) THEN
4882: AHL_DEBUG_PUB.debug( l_api_name || 'Updating AHL_WORKORDERS with status code for Workorder ' || i );
4883: END IF;
4884: --
4885: UPDATE AHL_WORKORDERS
4886: SET status_code = l_eam_wo_tbl(i).status_type,
4887: object_version_number = p_x_prd_workorder_tbl(i).object_version_number + 1,
4888: last_update_date = SYSDATE,
4889: last_updated_by = Fnd_Global.USER_ID,

Line 4993: FROM AHL_WORKORDERS

4989: object_version_number,
4990: status_code,
4991: wip_entity_id,
4992: workorder_name
4993: FROM AHL_WORKORDERS
4994: WHERE visit_id = c_visit_id
4995: AND status_code <> G_JOB_STATUS_DELETED
4996: AND visit_task_id IS NULL;
4997: -- To get a workorder from the wp_entity_id

Line 5006: FROM AHL_WORKORDERS WO

5002: WO.wip_entity_id wip_entity_id,
5003: WO.status_code status_code,
5004: WO.master_workorder_flag,
5005: WO.workorder_name
5006: FROM AHL_WORKORDERS WO
5007: WHERE wip_entity_id = c_wip_entity_id
5008: AND STATUS_CODE <> G_JOB_STATUS_DELETED;
5009:
5010: -- To get the Child Workorders

Line 5045: FROM AHL_WORKORDERS WO,

5041: WO.status_code status_code,
5042: WO.wip_entity_id wip_entity_id,
5043: WO.workorder_name workorder_name,
5044: WO.master_workorder_flag master_workorder_flag
5045: FROM AHL_WORKORDERS WO,
5046: AHL_VISIT_TASKS_B VT
5047: WHERE WO.status_code <> G_JOB_STATUS_DELETED
5048: AND WO.visit_task_id = VT.visit_task_id
5049: AND VT.task_type_code IN ( 'SUMMARY', 'UNASSOCIATED' )

Line 5059: FROM AHL_WORKORDERS

5055: object_version_number,
5056: status_code,
5057: wip_entity_id,
5058: workorder_name
5059: FROM AHL_WORKORDERS
5060: WHERE workorder_id =p_workorder_id;
5061:
5062: BEGIN
5063: SAVEPOINT release_visit_jobs_PVT;

Line 5514: FROM AHL_WORKORDERS

5510:
5511: CURSOR get_visit_child_wos( c_visit_id NUMBER ) IS
5512: SELECT workorder_name,
5513: wip_entity_id
5514: FROM AHL_WORKORDERS
5515: WHERE visit_id = c_visit_id
5516: AND status_code NOT IN ( G_JOB_STATUS_COMPLETE,
5517: G_JOB_STATUS_COMPLETE_NC,
5518: G_JOB_STATUS_CANCELLED,

Line 5524: FROM AHL_WORKORDERS WO,

5520: G_JOB_STATUS_DELETED );
5521:
5522: CURSOR get_visit_dependencies( c_visit_id NUMBER, c_wip_entity_id NUMBER ) IS
5523: SELECT WO.workorder_name workorder_name
5524: FROM AHL_WORKORDERS WO,
5525: WIP_SCHED_RELATIONSHIPS REL
5526: WHERE WO.wip_entity_id = REL.parent_object_id
5527: AND WO.visit_id <> c_visit_id
5528: AND WO.status_code NOT IN ( G_JOB_STATUS_COMPLETE,

Line 5541: FROM AHL_WORKORDERS WO,

5537:
5538: CURSOR get_ue_mwo( c_unit_effectivity_id NUMBER ) IS
5539: SELECT WO.workorder_name workorder_name,
5540: WO.wip_entity_id wip_entity_id
5541: FROM AHL_WORKORDERS WO,
5542: AHL_VISIT_TASKS_B VT
5543: WHERE WO.visit_task_id = VT.visit_task_id
5544: AND WO.status_code NOT IN ( G_JOB_STATUS_COMPLETE,
5545: G_JOB_STATUS_COMPLETE_NC,

Line 5556: FROM AHL_WORKORDERS WO

5552: -- Fix for connect by issue
5553: CURSOR get_child_wos( c_wip_entity_id NUMBER ) IS
5554: SELECT WO.wip_entity_id wip_entity_id,
5555: WO.workorder_name workorder_name
5556: FROM AHL_WORKORDERS WO
5557: WHERE WO.status_code NOT IN ( G_JOB_STATUS_COMPLETE,
5558: G_JOB_STATUS_COMPLETE_NC,
5559: G_JOB_STATUS_CANCELLED,
5560: G_JOB_STATUS_CLOSED,

Line 5584: FROM AHL_WORKORDERS WO,

5580:
5581: CURSOR get_wo_dependencies( c_wip_entity_id NUMBER ) IS
5582: SELECT WO.workorder_name workorder_name,
5583: WO.wip_entity_id wip_entity_id
5584: FROM AHL_WORKORDERS WO,
5585: WIP_SCHED_RELATIONSHIPS REL
5586: WHERE WO.wip_entity_id = REL.parent_object_id
5587: AND WO.status_code NOT IN ( G_JOB_STATUS_COMPLETE,
5588: G_JOB_STATUS_COMPLETE_NC,

Line 5600: FROM AHL_WORKORDERS

5596:
5597: CURSOR get_wo( c_workorder_id NUMBER ) IS
5598: SELECT workorder_name,
5599: wip_entity_id
5600: FROM AHL_WORKORDERS
5601: WHERE workorder_id =p_workorder_id
5602: AND status_code NOT IN ( G_JOB_STATUS_COMPLETE,
5603: G_JOB_STATUS_COMPLETE_NC,
5604: G_JOB_STATUS_CANCELLED,

Line 5832: FROM AHL_WORKORDERS WO,

5828:
5829: -- Get Child WOs which are not cancelled
5830: CURSOR get_child_wos( c_wip_entity_id NUMBER ) IS
5831: SELECT WO.workorder_id workorder_id
5832: FROM AHL_WORKORDERS WO,
5833: WIP_SCHED_RELATIONSHIPS REL
5834: WHERE WO.status_code NOT IN ( G_JOB_STATUS_CANCELLED,
5835: G_JOB_STATUS_DELETED )
5836: AND WO.wip_entity_id = REL.child_object_id

Line 5946: FROM AHL_WORKORDERS

5942: object_version_number,
5943: status_code,
5944: wip_entity_id,
5945: workorder_name
5946: FROM AHL_WORKORDERS
5947: WHERE visit_id = c_visit_id
5948: AND status_code NOT IN (G_JOB_STATUS_DELETED,G_JOB_STATUS_CANCELLED)
5949: AND visit_task_id IS NULL;
5950:

Line 5959: FROM AHL_WORKORDERS WO,

5955: WO.status_code status_code,
5956: WO.wip_entity_id wip_entity_id,
5957: WO.workorder_name workorder_name,
5958: WO.master_workorder_flag master_workorder_flag
5959: FROM AHL_WORKORDERS WO,
5960: AHL_VISIT_TASKS_B VT
5961: WHERE WO.status_code <> G_JOB_STATUS_DELETED
5962: AND WO.visit_task_id = VT.visit_task_id
5963: AND VT.task_type_code IN ( 'SUMMARY', 'UNASSOCIATED' )

Line 5970: FROM AHL_WORKORDERS WO,

5966: -- bug 4094884
5967: -- To get the UE Workorder
5968: CURSOR get_ue_wo( c_unit_effectivity_id NUMBER ) IS
5969: SELECT WO.wip_entity_id wip_entity_id
5970: FROM AHL_WORKORDERS WO,
5971: AHL_VISIT_TASKS_B VT
5972: WHERE WO.status_code <> G_JOB_STATUS_DELETED
5973: AND WO.visit_task_id = VT.visit_task_id
5974: AND VT.task_type_code NOT IN ('SUMMARY')

Line 5985: FROM AHL_WORKORDERS

5981: object_version_number,
5982: status_code,
5983: wip_entity_id,
5984: workorder_name
5985: FROM AHL_WORKORDERS
5986: WHERE workorder_id =p_workorder_id;
5987:
5988: -- To get the Child Workorders of a Master Workorder
5989: -- Fix for connect by issue

Line 5999: FROM AHL_WORKORDERS WO

5995: WO.status_code status_code,
5996: WO.wip_entity_id wip_entity_id,
5997: WO.master_workorder_flag,
5998: WO.workorder_name
5999: FROM AHL_WORKORDERS WO
6000: WHERE WO.wip_entity_id = c_wip_entity_id;
6001: /* bug 5104519 - end */
6002: -- To get the Child Workorders of a Master Workorder
6003: CURSOR get_child_wos( c_wip_entity_id NUMBER ) IS

Line 6068: AHL_WORKORDERS WO

6064: SELECT UE.unit_effectivity_id unit_effectivity_id,
6065: UE.object_version_number object_version_number
6066: FROM AHL_UNIT_EFFECTIVITIES_B UE,
6067: AHL_VISIT_TASKS_B VT,
6068: AHL_WORKORDERS WO
6069: WHERE UE.unit_effectivity_id = VT.unit_effectivity_id
6070: AND UE.manually_planned_flag = 'Y'
6071: -- Check added by balaji by balaji for bug # 4095002
6072: -- As per the update in the bug, for Manually planned UEs of type SR

Line 6103: FROM AHL_WORKORDERS

6099: -- that are not master workorders
6100: CURSOR get_visit_wos(c_visit_id NUMBER)
6101: IS
6102: SELECT wip_entity_id
6103: FROM AHL_WORKORDERS
6104: WHERE visit_id = c_visit_id
6105: AND master_workorder_flag <> 'Y';
6106:
6107: -- to see if a workorder is a top level workorder

Line 6126: FROM --AHL_WORKORDERS WO,

6122: IS
6123: SELECT REL.sched_relationship_id,
6124: REL.parent_object_id,
6125: REL.child_object_id
6126: FROM --AHL_WORKORDERS WO,
6127: WIP_SCHED_RELATIONSHIPS REL
6128: WHERE --WO.wip_entity_id = REL.child_object_id
6129: REL.parent_object_type_id = 1
6130: AND REL.child_object_type_id = 1

Line 6194: FROM AHL_WORKORDERS AWO, WIP_DISCRETE_JOBS WDJ

6190: -- cursor to check if all workorders in a visit are cancelled.
6191: CURSOR chk_cmplt_wo_exists(c_wip_entity_id NUMBER )
6192: IS
6193: SELECT 'x'
6194: FROM AHL_WORKORDERS AWO, WIP_DISCRETE_JOBS WDJ
6195: WHERE awo.wip_entity_id = wdj.wip_entity_id
6196: AND wdj.date_completed IS NOT NULL
6197: --AND master_workorder_flag = 'N'
6198: --AND status_code NOT IN ('7', '22', '12')

Line 7466: FROM AHL_WORKORDERS AWO,

7462: WIP.WIP_ENTITY_ID,
7463: AWO.STATUS_CODE,
7464: WIP.SCHEDULED_START_DATE,
7465: WIP.SCHEDULED_COMPLETION_DATE
7466: FROM AHL_WORKORDERS AWO,
7467: WIP_DISCRETE_JOBS WIP
7468: WHERE AWO.VISIT_ID=c_visit_id
7469: AND AWO.VISIT_TASK_ID IS NULL
7470: AND AWO.MASTER_WORKORDER_FLAG = 'Y'