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

Line 123: FROM AHL_WORKORDERS WO, AHL_WORKORDER_OPERATIONS_V OP

119: OP.actual_start_date,
120: OP.actual_end_date,
121: OP.status_code,
122: OP.status
123: FROM AHL_WORKORDERS WO, AHL_WORKORDER_OPERATIONS_V OP
124: WHERE WO.workorder_id = OP.workorder_id
125: AND OP.workorder_operation_id = p_workorder_operation_id;
126:
127: BEGIN

Line 155: FROM AHL_WORKORDERS WO, AHL_WORKORDER_OPERATIONS_V OP

151: x_operation_rec.actual_start_date,
152: x_operation_rec.actual_end_date,
153: x_operation_rec.status_code,
154: x_operation_rec.status
155: FROM AHL_WORKORDERS WO, AHL_WORKORDER_OPERATIONS_V OP
156: WHERE WO.workorder_id = OP.workorder_id
157: AND OP.workorder_operation_id = p_workorder_operation_id;*/
158: -- fix for bug number 7295717 (Sunil)
159: OPEN get_op_details(p_workorder_operation_id);

Line 260: FROM AHL_WORKORDERS WO, FND_LOOKUP_VALUES_VL MLU,WIP_DISCRETE_JOBS WDJ,

256: WDJ.COMPLETION_SUBINVENTORY,
257: WDJ.COMPLETION_LOCATOR_ID,
258: WO.visit_id,
259: WO.visit_task_id
260: FROM AHL_WORKORDERS WO, FND_LOOKUP_VALUES_VL MLU,WIP_DISCRETE_JOBS WDJ,
261: (SELECT ORGANIZATION_ID FROM INV_ORGANIZATION_INFO_V WHERE
262: NVL (operating_unit, mo_global.get_current_org_id()) = mo_global.get_current_org_id()) ORG
263: WHERE WDJ.WIP_ENTITY_ID=WO.WIP_ENTITY_ID
264: AND MLU.LOOKUP_TYPE(+)='AHL_JOB_STATUS' AND WO.STATUS_CODE=MLU.LOOKUP_CODE(+)

Line 303: AHL_WORKORDERS WO

299: MR.auto_signoff_flag
300: FROM
301: AHL_MR_HEADERS_APP_V MR,
302: AHL_VISIT_TASKS_B VT,
303: AHL_WORKORDERS WO
304: WHERE MR.MR_HEADER_ID = VT.MR_ID AND
305: WO.VISIT_TASK_ID = VT.visit_task_id AND
306: WO.workorder_id = c_workorder_id;*/
307:

Line 315: --AHL_WORKORDERS WO

311: MR.auto_signoff_flag
312: FROM
313: AHL_MR_HEADERS_APP_V MR,
314: AHL_VISIT_TASKS_B VT
315: --AHL_WORKORDERS WO
316: WHERE MR.MR_HEADER_ID = VT.MR_ID AND
317: VT.visit_task_id = c_visit_task_id;
318:
319: BEGIN

Line 970: UPDATE AHL_WORKORDERS

966: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
967: RETURN FND_API.G_RET_STS_ERROR;
968: END IF;
969: --sukhwsin::VEE Code Changes - end
970: UPDATE AHL_WORKORDERS
971: SET status_code = p_status_code,
972: object_version_number = object_version_number + 1,
973: last_update_date = SYSDATE,
974: last_updated_by = FND_GLOBAL.user_id,

Line 1571: FROM AHL_WORKORDERS WO,

1567: CURSOR get_completion_dependencies( c_child_wip_entity_id NUMBER )
1568: IS
1569: SELECT WO.workorder_name,
1570: WO.status_code
1571: FROM AHL_WORKORDERS WO,
1572: WIP_SCHED_RELATIONSHIPS WOR
1573: WHERE WO.wip_entity_id = WOR.parent_object_id
1574: AND WO.master_workorder_flag = 'N'
1575: AND WO.status_code <> G_JOB_STATUS_DELETED

Line 2107: ahl_workorders awo

2103: IS
2104: SELECT
2105: awo.actual_end_date
2106: FROM
2107: ahl_workorders awo
2108: WHERE
2109: awo.wip_entity_id = p_wip_entity_id;
2110:
2111: l_wo_actual_date DATE;

Line 3191: FROM AHL_WORKORDERS WO,

3187: SELECT WO.workorder_id workorder_id,
3188: WO.object_version_number object_version_number,
3189: WO.wip_entity_id wip_entity_id,
3190: WO.status_code status_code
3191: FROM AHL_WORKORDERS WO,
3192: WIP_SCHED_RELATIONSHIPS WOR
3193: WHERE WO.wip_entity_id = WOR.parent_object_id
3194: AND WO.master_workorder_flag = 'Y'
3195: AND WO.status_code <> G_JOB_STATUS_DELETED

Line 3204: FROM AHL_WORKORDERS WO,

3200:
3201: CURSOR get_child_wo_status( c_master_wip_entity_id NUMBER )
3202: IS
3203: SELECT DISTINCT WO.status_code status_code
3204: FROM AHL_WORKORDERS WO,
3205: WIP_SCHED_RELATIONSHIPS WOR
3206: WHERE WO.wip_entity_id = WOR.child_object_id
3207: AND WO.status_code <> G_JOB_STATUS_DELETED
3208: AND WOR.parent_object_type_id = 1

Line 3253: FROM AHL_WORKORDERS

3249: IS
3250: SELECT Actual_start_date,
3251: Actual_end_date,
3252: Workorder_name
3253: FROM AHL_WORKORDERS
3254: WHERE workorder_id = x_wo_id;
3255:
3256: -- R12: Login/logout feature.
3257: -- here we pick up all employees logged in at all levels.

Line 3271: l_wo_name ahl_workorders.workorder_name%TYPE;

3267: l_actual_end_date DATE;
3268: l_actual_start_date DATE;
3269: l_def_actual_end_date DATE;
3270: l_def_actual_start_date DATE;
3271: l_wo_name ahl_workorders.workorder_name%TYPE;
3272:
3273: l_employee_id NUMBER;
3274: l_operation_seq_num NUMBER;
3275: l_resource_seq_num NUMBER;

Line 3381: UPDATE AHL_WORKORDERS

3377:
3378: /*
3379: -- update the actual dates in the table
3380: IF l_actual_start_date IS NULL THEN
3381: UPDATE AHL_WORKORDERS
3382: SET ACTUAL_START_DATE = l_def_actual_start_date,
3383: LAST_UPDATE_DATE = SYSDATE,
3384: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
3385: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

Line 3396: UPDATE AHL_WORKORDERS

3392: END IF;-- IF l_actual_start_date IS NULL THEN
3393:
3394: -- update the actual dates in the table
3395: IF l_actual_end_date IS NULL THEN
3396: UPDATE AHL_WORKORDERS
3397: SET ACTUAL_END_DATE = l_def_actual_end_date,
3398: LAST_UPDATE_DATE = SYSDATE,
3399: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
3400: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

Line 4523: FROM AHL_WORKORDERS WO,

4519: G_JOB_STATUS_COMPLETE_NC, G_JOB_STATUS_COMPLETE,
4520: G_JOB_STATUS_PARTS_HOLD, G_JOB_STATUS_ON_HOLD,
4521: G_JOB_STATUS_DEFERRAL_PENDING,G_JOB_STATUS_ON_HOLD,
4522: WO.status_code ) status_code
4523: FROM AHL_WORKORDERS WO,
4524: AHL_VISIT_TASKS_B VT
4525: WHERE WO.visit_task_id = VT.visit_task_id
4526: AND WO.status_code <> G_JOB_STATUS_DELETED
4527: AND WO.master_workorder_flag = 'N'

Line 4545: FROM AHL_WORKORDERS CWO, ahl_visit_tasks_b vst, wip_discrete_jobs WIPJ

4541: G_JOB_STATUS_COMPLETE_NC, G_JOB_STATUS_COMPLETE,
4542: G_JOB_STATUS_PARTS_HOLD, G_JOB_STATUS_ON_HOLD,
4543: G_JOB_STATUS_DEFERRAL_PENDING,G_JOB_STATUS_ON_HOLD,
4544: CWO.status_code ) status_code
4545: FROM AHL_WORKORDERS CWO, ahl_visit_tasks_b vst, wip_discrete_jobs WIPJ
4546: where CWO.visit_task_id = vst.visit_task_id
4547: AND vst.unit_effectivity_id = c_unit_effectivity_id
4548: AND CWO.master_workorder_flag = 'N'
4549: AND CWO.wip_entity_id in (SELECT REL.child_object_id

Line 4554: FROM AHL_WORKORDERS PWO,

4550: from WIP_SCHED_RELATIONSHIPS REL
4551: START WITH REL.parent_object_id IN
4552: (
4553: SELECT PWO.wip_entity_id
4554: FROM AHL_WORKORDERS PWO,
4555: AHL_VISIT_TASKS_B VT,
4556: AHL_VISITS_B VS
4557: WHERE PWO.master_workorder_flag = 'Y'
4558: AND PWO.visit_task_id = VT.visit_task_id

Line 4588: FROM AHL_WORKORDERS CWO, ahl_visit_tasks_b vst, wip_discrete_jobs WIPJ

4584: G_JOB_STATUS_COMPLETE_NC, G_JOB_STATUS_COMPLETE,
4585: G_JOB_STATUS_PARTS_HOLD, G_JOB_STATUS_ON_HOLD,
4586: G_JOB_STATUS_DEFERRAL_PENDING,G_JOB_STATUS_ON_HOLD,
4587: CWO.status_code ) status_code
4588: FROM AHL_WORKORDERS CWO, ahl_visit_tasks_b vst, wip_discrete_jobs WIPJ
4589: where CWO.visit_task_id = vst.visit_task_id
4590: AND vst.unit_effectivity_id = c_unit_effectivity_id
4591: AND vst.task_type_code = 'UNASSOCIATED'
4592: AND WIPJ.wip_entity_id = CWO.wip_entity_id; */

Line 4610: FROM AHL_WORKORDERS CWO, ahl_visit_tasks_b vst, wip_discrete_jobs WIPJ

4606: G_JOB_STATUS_COMPLETE_NC, G_JOB_STATUS_COMPLETE,
4607: G_JOB_STATUS_PARTS_HOLD, G_JOB_STATUS_ON_HOLD,
4608: G_JOB_STATUS_DEFERRAL_PENDING,G_JOB_STATUS_ON_HOLD,
4609: CWO.status_code ) status_code
4610: FROM AHL_WORKORDERS CWO, ahl_visit_tasks_b vst, wip_discrete_jobs WIPJ
4611: where CWO.visit_task_id = vst.visit_task_id
4612: --AND vst.unit_effectivity_id = c_unit_effectivity_id
4613: AND CWO.master_workorder_flag = 'N'
4614: AND CWO.wip_entity_id in (SELECT REL.child_object_id

Line 4619: FROM AHL_WORKORDERS PWO,

4615: from WIP_SCHED_RELATIONSHIPS REL
4616: START WITH REL.parent_object_id IN
4617: (
4618: SELECT PWO.wip_entity_id
4619: FROM AHL_WORKORDERS PWO,
4620: AHL_VISIT_TASKS_B VT,
4621: AHL_VISITS_B VS
4622: WHERE PWO.master_workorder_flag = 'Y'
4623: AND PWO.visit_task_id = VT.visit_task_id

Line 4641: FROM AHL_WORKORDERS CWO, ahl_visit_tasks_b vst

4637: --to check released/unpleased/qa-pending
4638: CURSOR get_mr_status_csr(c_unit_effectivity_id NUMBER,p_status_code VARCHAR2) IS
4639: SELECT
4640: CWO.status_code
4641: FROM AHL_WORKORDERS CWO, ahl_visit_tasks_b vst
4642: where CWO.visit_task_id = vst.visit_task_id
4643: AND CWO.master_workorder_flag = 'N'
4644: AND CWO.status_code IN (p_status_code)
4645: AND vst.unit_effectivity_id IN (select related_ue_id

Line 4659: FROM AHL_WORKORDERS CWO, ahl_visit_tasks_b vst

4655:
4656: CURSOR is_mr_on_hold_csr(c_unit_effectivity_id NUMBER) IS
4657: SELECT
4658: CWO.status_code
4659: FROM AHL_WORKORDERS CWO, ahl_visit_tasks_b vst
4660: where CWO.visit_task_id = vst.visit_task_id
4661: AND CWO.master_workorder_flag = 'N'
4662: AND CWO.status_code IN (G_JOB_STATUS_PARTS_HOLD, G_JOB_STATUS_ON_HOLD,
4663: G_JOB_STATUS_DEFERRAL_PENDING)

Line 4678: FROM AHL_WORKORDERS CWO, ahl_visit_tasks_b vst, wip_discrete_jobs wipj

4674:
4675: CURSOR is_mr_complete_csr(c_unit_effectivity_id NUMBER) IS
4676: SELECT
4677: CWO.status_code
4678: FROM AHL_WORKORDERS CWO, ahl_visit_tasks_b vst, wip_discrete_jobs wipj
4679: where CWO.visit_task_id = vst.visit_task_id
4680: AND WIPJ.wip_entity_id = CWO.wip_entity_id
4681: AND CWO.master_workorder_flag = 'N'
4682: AND CWO.status_code IN (G_JOB_STATUS_CLOSED, G_JOB_STATUS_COMPLETE_NC, G_JOB_STATUS_COMPLETE)

Line 4698: FROM AHL_WORKORDERS CWO, ahl_visit_tasks_b vst, wip_discrete_jobs wipj

4694:
4695: CURSOR is_mr_cancelled_csr(c_unit_effectivity_id NUMBER) IS
4696: SELECT
4697: CWO.status_code
4698: FROM AHL_WORKORDERS CWO, ahl_visit_tasks_b vst, wip_discrete_jobs wipj
4699: where CWO.visit_task_id = vst.visit_task_id
4700: AND WIPJ.wip_entity_id = CWO.wip_entity_id
4701: --AND vst.unit_effectivity_id = c_unit_effectivity_id
4702: AND CWO.master_workorder_flag = 'N'

Line 5085: FROM AHL_WORKORDERS

5081: CURSOR get_Wo_details(c_visit_id NUMBER)
5082: IS
5083: SELECT workorder_id,
5084: workorder_name
5085: FROM AHL_WORKORDERS
5086: WHERE visit_id = c_visit_id
5087: AND MASTER_WORKORDER_FLAG = 'N';
5088:
5089: CURSOR get_ue_title(p_workorder_id NUMBER)

Line 5094: ahl_workorders WO,

5090: IS
5091: SELECT
5092: UE.title
5093: FROM
5094: ahl_workorders WO,
5095: ahl_visit_tasks_b VTSK,
5096: ahl_unit_effectivities_v UE
5097: WHERE
5098: WO.workorder_id = p_workorder_id

Line 5257: FROM AHL_WORKORDERS CWO,

5253: CWO.actual_start_date actual_start_date,
5254: CWO.actual_end_date actual_end_date,
5255: CWO.status_code status_code,
5256: CWO.master_workorder_flag master_workorder_flag
5257: FROM AHL_WORKORDERS CWO,
5258: WIP_SCHED_RELATIONSHIPS REL
5259: WHERE CWO.wip_entity_id = REL.child_object_id
5260: AND CWO.status_code <> G_JOB_STATUS_DELETED
5261: AND REL.parent_object_type_id = 1

Line 5403: UPDATE AHL_WORKORDERS

5399: --pekambar added for ER 9274897 and 9504544 -- End
5400:
5401: BEGIN
5402:
5403: UPDATE AHL_WORKORDERS
5404: SET object_version_number = object_version_number + 1,
5405: actual_start_date = l_workorder_tbl(l_ctr).actual_start_date,
5406: actual_end_date = l_workorder_tbl(l_ctr).actual_end_date
5407: WHERE workorder_id = wo_csr.workorder_id

Line 5504: UPDATE AHL_WORKORDERS

5500: l_max := p_actual_end_date;
5501: END IF;*/
5502: /*End ER # 4757222*/
5503:
5504: UPDATE AHL_WORKORDERS
5505: SET object_version_number = object_version_number + 1,
5506: actual_start_date = l_min,
5507: actual_end_date = l_max
5508: WHERE wip_entity_id = p_wip_entity_id;

Line 5535: FROM AHL_WORKORDERS WO,

5531: G_JOB_STATUS_CANCELLED, G_JOB_STATUS_COMPLETE,
5532: G_JOB_STATUS_DELETED, G_JOB_STATUS_COMPLETE,
5533: WO.status_code ) parent_status_code,
5534: WOR.child_object_id child_we_id
5535: FROM AHL_WORKORDERS WO,
5536: WIP_SCHED_RELATIONSHIPS WOR
5537: WHERE WO.wip_entity_id = WOR.parent_object_id
5538: AND WOR.top_level_object_id = c_wip_entity_id
5539: AND WOR.relationship_type = 2

Line 5829: FROM AHL_WORKORDERS

5825: IS
5826: SELECT Actual_start_date,
5827: Actual_end_date,
5828: Workorder_name
5829: FROM AHL_WORKORDERS
5830: WHERE workorder_id = x_wo_id;
5831:
5832: -- To get the Unit Effectivity Details and it's master workorder details
5833: /*CURSOR get_ue_details( c_unit_effectivity_id NUMBER ) IS

Line 5857: AHL_WORKORDERS WO,

5853: WO.plan_id wo_plan_id,
5854: WO.collection_id wo_collection_id,
5855: WO.master_workorder_flag
5856: FROM WIP_DISCRETE_JOBS WIP,
5857: AHL_WORKORDERS WO,
5858: AHL_WORKORDERS VWO,
5859: AHL_VISIT_TASKS_B VT,
5860: AHL_UE_DEFERRAL_DETAILS_V UE
5861: WHERE WIP.wip_entity_id = WO.wip_entity_id

Line 5858: AHL_WORKORDERS VWO,

5854: WO.collection_id wo_collection_id,
5855: WO.master_workorder_flag
5856: FROM WIP_DISCRETE_JOBS WIP,
5857: AHL_WORKORDERS WO,
5858: AHL_WORKORDERS VWO,
5859: AHL_VISIT_TASKS_B VT,
5860: AHL_UE_DEFERRAL_DETAILS_V UE
5861: WHERE WIP.wip_entity_id = WO.wip_entity_id
5862: AND WO.visit_task_id = VT.visit_task_id

Line 5897: AHL_WORKORDERS WO,

5893: WO.collection_id wo_collection_id,
5894: WO.master_workorder_flag,
5895: WIP.ORGANIZATION_ID org_id
5896: FROM WIP_DISCRETE_JOBS WIP,
5897: AHL_WORKORDERS WO,
5898: AHL_WORKORDERS VWO,
5899: AHL_VISIT_TASKS_B VT,
5900: AHL_UNIT_EFFECTIVITIES_APP_V UE
5901: WHERE WIP.wip_entity_id = WO.wip_entity_id

Line 5898: AHL_WORKORDERS VWO,

5894: WO.master_workorder_flag,
5895: WIP.ORGANIZATION_ID org_id
5896: FROM WIP_DISCRETE_JOBS WIP,
5897: AHL_WORKORDERS WO,
5898: AHL_WORKORDERS VWO,
5899: AHL_VISIT_TASKS_B VT,
5900: AHL_UNIT_EFFECTIVITIES_APP_V UE
5901: WHERE WIP.wip_entity_id = WO.wip_entity_id
5902: AND WO.visit_task_id = VT.visit_task_id

Line 5981: AHL_WORKORDERS CWO,

5977: CWO.master_workorder_flag master_workorder_flag,
5978: CWO.plan_id plan_id,
5979: CWO.collection_id collection_id
5980: FROM WIP_DISCRETE_JOBS WIP,
5981: AHL_WORKORDERS CWO,
5982: WIP_SCHED_RELATIONSHIPS REL
5983: WHERE WIP.wip_entity_id = CWO.wip_entity_id
5984: AND CWO.wip_entity_id = REL.child_object_id
5985: AND CWO.status_code <> G_JOB_STATUS_DELETED

Line 6010: AHL_WORKORDERS CWO

6006: WOP.plan_id plan_id,
6007: WOP.collection_id collection_id
6008: FROM AHL_WORKORDER_OPERATIONS WOP,
6009: WIP_OPERATIONS WIP,
6010: AHL_WORKORDERS CWO
6011: WHERE WOP.operation_sequence_num = WIP.operation_seq_num
6012: AND WOP.workorder_id = CWO.workorder_id
6013: AND WIP.wip_entity_id = CWO.wip_entity_id
6014: --AND CWO.status_code <> G_JOB_STATUS_DELETED

Line 6027: AHL_WORKORDERS CWO,

6023: )
6024: AND WIP.WIP_ENTITY_ID IN (
6025: SELECT CWO.wip_entity_id
6026: FROM WIP_DISCRETE_JOBS WIP,
6027: AHL_WORKORDERS CWO,
6028: WIP_SCHED_RELATIONSHIPS REL
6029: WHERE WIP.wip_entity_id = CWO.wip_entity_id
6030: AND CWO.wip_entity_id = REL.child_object_id
6031: AND CWO.status_code <> G_JOB_STATUS_DELETED

Line 6059: AHL_WORKORDERS CWO

6055: WOP.plan_id plan_id,
6056: WOP.collection_id collection_id
6057: FROM AHL_WORKORDER_OPERATIONS WOP,
6058: WIP_OPERATIONS WIP,
6059: AHL_WORKORDERS CWO
6060: WHERE WOP.operation_sequence_num = WIP.operation_seq_num
6061: AND WOP.workorder_id = CWO.workorder_id
6062: AND WIP.wip_entity_id = CWO.wip_entity_id
6063: AND WIP.WIP_ENTITY_ID = c_wip_entity_id

Line 6097: AHL_WORKORDERS CWO,

6093: WOR.usage_rate_or_amount usage_rate_or_amount
6094: FROM BOM_RESOURCES BOM,
6095: WIP_OPERATION_RESOURCES WOR,
6096: AHL_WORKORDER_OPERATIONS WOP,
6097: AHL_WORKORDERS CWO,
6098: WIP_SCHED_RELATIONSHIPS REL
6099: WHERE BOM.resource_type IN ( 1 , 2 )
6100: AND BOM.resource_id = WOR.resource_id
6101: AND WOR.operation_seq_num = WOP.operation_sequence_num

Line 6142: AHL_WORKORDERS CWO

6138: WOR.usage_rate_or_amount usage_rate_or_amount
6139: FROM BOM_RESOURCES BOM,
6140: WIP_OPERATION_RESOURCES WOR,
6141: AHL_WORKORDER_OPERATIONS WOP,
6142: AHL_WORKORDERS CWO
6143: WHERE BOM.resource_type IN ( 1 , 2 )
6144: AND BOM.resource_id = WOR.resource_id
6145: AND WOR.operation_seq_num = WOP.operation_sequence_num
6146: AND WOR.wip_entity_id = CWO.wip_entity_id

Line 7698: UPDATE AHL_WORKORDERS

7694: END IF;
7695:
7696: -- update the actual dates in the table
7697: IF l_wo_actual_start_date IS NULL THEN
7698: UPDATE AHL_WORKORDERS
7699: SET OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
7700: ACTUAL_START_DATE = l_def_actual_start_date,
7701: LAST_UPDATE_DATE = SYSDATE,
7702: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

Line 7717: UPDATE AHL_WORKORDERS

7713: END IF;-- IF l_actual_start_date IS NULL THEN
7714:
7715: -- update the actual dates in the table
7716: IF l_wo_actual_end_date IS NULL THEN
7717: UPDATE AHL_WORKORDERS
7718: SET OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
7719: ACTUAL_END_DATE = l_def_actual_end_date,
7720: LAST_UPDATE_DATE = SYSDATE,
7721: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

Line 7735: UPDATE AHL_WORKORDERS

7731: l_workorder_tbl(i).object_version_number := l_workorder_tbl(i).object_version_number + 1;
7732: END IF; -- IF l_actual_end_date IS NULL THEN
7733: /*ELSE
7734:
7735: UPDATE AHL_WORKORDERS
7736: SET object_version_number = object_version_number + 1,
7737: actual_start_date = l_workorder_tbl(i).actual_start_date,
7738: actual_end_date = l_workorder_tbl(i).actual_end_date,
7739: LAST_UPDATE_DATE = SYSDATE,

Line 8134: FROM AHL_WORKORDERS

8130: IS
8131: SELECT Actual_start_date,
8132: Actual_end_date,
8133: Workorder_name
8134: FROM AHL_WORKORDERS
8135: WHERE workorder_id = x_wo_id;
8136:
8137: -- To get the Visit and it's master workorder details
8138: CURSOR get_visit_details( c_visit_id NUMBER ) IS

Line 8157: AHL_WORKORDERS WO,

8153: WO.status_code wo_status_code,
8154: WO.plan_id wo_plan_id,
8155: WO.collection_id wo_collection_id
8156: FROM WIP_DISCRETE_JOBS WIP,
8157: AHL_WORKORDERS WO,
8158: AHL_VISITS_B VST
8159: WHERE WIP.wip_entity_id = WO.wip_entity_id
8160: AND WO.visit_task_id IS NULL
8161: AND WO.master_workorder_flag = 'Y'

Line 8197: ahl_workorders awo

8193: UE.qa_plan_id qa_plan_id,
8194: UE.qa_collection_id qa_collection_id
8195: FROM AHL_UE_DEFERRAL_DETAILS_V UE,
8196: AHL_VISIT_TASKS_B VT,
8197: ahl_workorders awo
8198: WHERE UE.unit_effectivity_id = VT.unit_effectivity_id
8199: AND ( (VT.task_type_code = 'SUMMARY')
8200: OR (TASK_TYPE_CODE = 'UNASSOCIATED' ) )
8201: AND vt.visit_task_id = awo.visit_task_id

Line 8206: ahl_workorders awo1

8202: and awo.wip_entity_id in ( SELECT
8203: wsch.child_object_id
8204: FROM
8205: wip_sched_relationships wsch,
8206: ahl_workorders awo1
8207: WHERE
8208: wsch.parent_object_id = awo1.wip_entity_id
8209: and awo1.visit_task_id is null
8210: and awo1.master_workorder_flag = 'Y'

Line 8227: ahl_workorders awo

8223: -1 qa_plan_id,
8224: UE.qa_collection_id qa_collection_id
8225: FROM AHL_UNIT_EFFECTIVITIES_B UE,
8226: AHL_VISIT_TASKS_B VT,
8227: ahl_workorders awo
8228: WHERE UE.unit_effectivity_id = VT.unit_effectivity_id
8229: AND ( (VT.task_type_code = 'SUMMARY')
8230: OR (TASK_TYPE_CODE = 'UNASSOCIATED' ) )
8231: AND vt.visit_task_id = awo.visit_task_id

Line 8236: ahl_workorders awo1

8232: and awo.wip_entity_id in ( SELECT
8233: wsch.child_object_id
8234: FROM
8235: wip_sched_relationships wsch,
8236: ahl_workorders awo1
8237: WHERE
8238: wsch.parent_object_id = awo1.wip_entity_id
8239: and awo1.visit_task_id is null
8240: and awo1.master_workorder_flag = 'Y'

Line 8319: AHL_WORKORDERS WO, AHL_VISIT_TASKS_B TSK

8315: WO.plan_id plan_id,
8316: WO.collection_id collection_id,
8317: TSK.task_type_code
8318: FROM WIP_DISCRETE_JOBS WIP,
8319: AHL_WORKORDERS WO, AHL_VISIT_TASKS_B TSK
8320: WHERE WIP.wip_entity_id = WO.wip_entity_id
8321: AND WO.visit_task_id = TSK.visit_task_id
8322: AND WO.status_code <> G_JOB_STATUS_DELETED
8323: AND WO.visit_task_id IS NOT NULL

Line 8346: AHL_WORKORDERS WO,

8342: TSK.task_type_code
8343:
8344: FROM AHL_WORKORDER_OPERATIONS WOP,
8345: WIP_OPERATIONS WIP,
8346: AHL_WORKORDERS WO,
8347: AHL_VISIT_TASKS_B TSK
8348:
8349: WHERE WOP.operation_sequence_num = WIP.operation_seq_num
8350: AND WOP.workorder_id = WO.workorder_id

Line 8382: AHL_WORKORDERS WO

8378: WOR.usage_rate_or_amount usage_rate_or_amount
8379: FROM BOM_RESOURCES BOM,
8380: WIP_OPERATION_RESOURCES WOR,
8381: AHL_WORKORDER_OPERATIONS WOP,
8382: AHL_WORKORDERS WO
8383: WHERE BOM.resource_type IN ( 1 , 2 )
8384: AND BOM.resource_id = WOR.resource_id
8385: AND WOR.operation_seq_num = WOP.operation_sequence_num
8386: AND WOR.wip_entity_id = WO.wip_entity_id

Line 8438: FROM AHL_WORKORDERS WO,

8434: -- MANESING, 14-May-2012, added following cursor
8435: -- Cursor to find default Stage work order id for the given visit
8436: CURSOR get_default_stage_wo_csr (c_visit_id NUMBER) IS
8437: SELECT WO.workorder_id
8438: FROM AHL_WORKORDERS WO,
8439: AHL_VISIT_TASKS_B TSK
8440: WHERE WO.visit_id = c_visit_id
8441: AND TSK.visit_task_id = WO.visit_task_id
8442: AND TSK.task_type_code = 'STAGE'

Line 9791: UPDATE AHL_WORKORDERS

9787: );
9788:
9789: -- update the actual dates in the table
9790: IF l_workorder_tbl(i).actual_start_date IS NULL THEN
9791: UPDATE AHL_WORKORDERS
9792: SET OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
9793: ACTUAL_START_DATE = l_def_actual_start_date,
9794: LAST_UPDATE_DATE = SYSDATE,
9795: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

Line 9810: UPDATE AHL_WORKORDERS

9806: END IF;-- IF l_actual_start_date IS NULL THEN
9807:
9808: -- update the actual dates in the table
9809: IF l_workorder_tbl(i).actual_end_date IS NULL THEN
9810: UPDATE AHL_WORKORDERS
9811: SET OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
9812: ACTUAL_END_DATE = l_def_actual_end_date,
9813: LAST_UPDATE_DATE = SYSDATE,
9814: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

Line 9832: UPDATE AHL_WORKORDERS

9828: /*End ER # 4757222*/
9829: /*Start ER # 4757222
9830: -- Ignore Master Workorders since they are post processed seperately
9831: IF ( l_workorder_tbl(i).master_workorder_flag = 'N' ) THEN
9832: UPDATE AHL_WORKORDERS
9833: SET object_version_number = object_version_number + 1,
9834: actual_start_date = l_workorder_tbl(i).actual_start_date,
9835: actual_end_date = l_workorder_tbl(i).actual_end_date
9836: WHERE workorder_id = l_workorder_tbl(i).workorder_id

Line 10361: FROM AHL_WORKORDERS WO,

10357: --UE.qa_plan_id ue_qa_plan_id,
10358: --UE.qa_collection_id ue_qa_collection_id,
10359: WO.workorder_id workorder_id,
10360: WO.wip_entity_id wip_entity_id
10361: FROM AHL_WORKORDERS WO,
10362: AHL_VISIT_TASKS_B VT,
10363: --AHL_UE_DEFERRAL_DETAILS_V UE
10364: AHL_UNIT_EFFECTIVITIES_B UE
10365: WHERE WO.visit_task_id = VT.visit_task_id

Line 10396: AHL_WORKORDERS CWO,

10392: -- To get the Child Workorder Details for a UE
10393: CURSOR get_ue_workorders( c_wip_entity_id NUMBER ) IS
10394: SELECT CWO.workorder_id workorder_id
10395: FROM WIP_DISCRETE_JOBS WIP,
10396: AHL_WORKORDERS CWO,
10397: WIP_SCHED_RELATIONSHIPS REL
10398: WHERE WIP.wip_entity_id = CWO.wip_entity_id
10399: AND CWO.wip_entity_id = REL.child_object_id
10400: AND CWO.status_code NOT IN (G_JOB_STATUS_DELETED, G_JOB_STATUS_COMPLETE, G_JOB_STATUS_COMPLETE_NC, G_JOB_STATUS_CANCELLED, G_JOB_STATUS_CLOSED)

Line 10415: AHL_WORKORDERS CWO

10411: SELECT WOP.workorder_id workorder_id,
10412: WIP.operation_seq_num operation_seq_num
10413: FROM AHL_WORKORDER_OPERATIONS WOP,
10414: WIP_OPERATIONS WIP,
10415: AHL_WORKORDERS CWO
10416: WHERE WOP.operation_sequence_num = WIP.operation_seq_num
10417: AND WOP.workorder_id = CWO.workorder_id
10418: AND WIP.wip_entity_id = CWO.wip_entity_id
10419: AND WIP.WIP_ENTITY_ID IN (

Line 10422: AHL_WORKORDERS CWO,

10418: AND WIP.wip_entity_id = CWO.wip_entity_id
10419: AND WIP.WIP_ENTITY_ID IN (
10420: SELECT CWO.wip_entity_id
10421: FROM WIP_DISCRETE_JOBS WIP,
10422: AHL_WORKORDERS CWO,
10423: WIP_SCHED_RELATIONSHIPS REL
10424: WHERE WIP.wip_entity_id = CWO.wip_entity_id
10425: AND CWO.wip_entity_id = REL.child_object_id
10426: AND CWO.status_code <> G_JOB_STATUS_DELETED

Line 10702: FROM AHL_WORKORDERS

10698: -- cursor to retrieve the wip_entity_id
10699: CURSOR c_get_wo_details(x_workorder_id NUMBER)
10700: IS
10701: SELECT WIP_ENTITY_ID
10702: FROM AHL_WORKORDERS
10703: WHERE WORKORDER_ID = x_workorder_id;
10704:
10705: -- cursor to retrieve minimum and maximum resource transactions dates for this
10706: -- operation for resource transactions of type 'Person'

Line 10939: FROM AHL_WORKORDERS

10935:
10936: CURSOR c_get_mwo_flag(x_workorder_id NUMBER)
10937: IS
10938: SELECT MASTER_WORKORDER_FLAG
10939: FROM AHL_WORKORDERS
10940: WHERE WORKORDER_ID = x_workorder_id;
10941:
10942: BEGIN
10943:

Line 11029: FROM AHL_WORKORDERS

11025: -- cursor to retrieve the visit master workorder
11026: CURSOR get_visit_master_wo(c_visit_id NUMBER )
11027: IS
11028: SELECT workorder_id, object_version_number, wip_entity_id
11029: FROM AHL_WORKORDERS
11030: WHERE visit_id = c_visit_id
11031: AND master_workorder_flag = 'Y'
11032: --AND status_code NOT IN ('7', '22', '4', '12', '5')
11033: AND VISIT_TASK_ID IS NULL;

Line 11040: FROM AHL_WORKORDERS WO,

11036: IS
11037: SELECT WO.workorder_id,
11038: WO.object_version_number, VTS.task_type_code,
11039: WO.wip_entity_id
11040: FROM AHL_WORKORDERS WO,
11041: AHL_VISIT_TASKS_B VTS
11042: WHERE WO.visit_task_id = VTS.visit_task_id
11043: AND VTS.unit_effectivity_id = c_ue_id
11044: --AND WO.status_code NOT IN ('7', '22', '4', '12', '5')

Line 11050: FROM AHL_WORKORDERS

11046:
11047: CURSOR get_wo_ovn(c_workorder_id NUMBER)
11048: IS
11049: SELECT object_version_number, wip_entity_id
11050: FROM AHL_WORKORDERS
11051: WHERE workorder_id = c_workorder_id;
11052: --AND status_code NOT IN ('7', '22', '4', '12', '5');
11053:
11054: -- Fix for FP bug# 5138909 (issue#2).

Line 11062: FROM AHL_WORKORDERS AWO, WIP_DISCRETE_JOBS WDJ

11058: -- cursor to check if all workorders in a visit are cancelled.
11059: CURSOR chk_cmplt_wo_exists(c_wip_entity_id NUMBER )
11060: IS
11061: SELECT 'x'
11062: FROM AHL_WORKORDERS AWO, WIP_DISCRETE_JOBS WDJ
11063: WHERE awo.wip_entity_id = wdj.wip_entity_id
11064: AND wdj.date_completed IS NOT NULL
11065: --AND master_workorder_flag = 'N'
11066: --AND status_code NOT IN ('7', '22', '12')

Line 11269: AHL_WORKORDERS AWO,

11265: AWO.attribute13,
11266: AWO.attribute14,
11267: AWO.attribute15
11268: FROM
11269: AHL_WORKORDERS AWO,
11270: WIP_DISCRETE_JOBS WIPJ,
11271: WIP_ENTITIES WIPE
11272: WHERE
11273: AWO.status_code in (4,5,7)

Line 11285: AHL_WORKORDERS AWO

11281: SELECT
11282: 'x'
11283: FROM
11284: CSI_ITEM_INSTANCES CII,
11285: AHL_WORKORDERS AWO
11286: WHERE
11287: CII.WIP_JOB_ID = AWO.WIP_ENTITY_ID
11288: AND AWO.workorder_id = p_workorder_id
11289: AND ACTIVE_START_DATE <= SYSDATE

Line 11560: AHL_WORKORDERS

11556:
11557: FORALL l_count IN l_workorder_id_tbl.FIRST .. l_workorder_id_tbl.LAST
11558: SAVE EXCEPTIONS
11559: UPDATE
11560: AHL_WORKORDERS
11561: SET
11562: status_code = 12,
11563: last_update_date = sysdate,
11564: last_updated_by = fnd_global.user_id,

Line 11784: SELECT wo.actual_end_date FROM ahl_workorders WO

11780: l_organization_id NUMBER;
11781: l_visit_task_id NUMBER;
11782:
11783: CURSOR act_end_dt_csr(p_visit_task_id IN NUMBER) IS
11784: SELECT wo.actual_end_date FROM ahl_workorders WO
11785: WHERE WO.visit_task_id = p_visit_task_id
11786: AND master_workorder_flag = 'Y';
11787:
11788: CURSOR get_qa_plan_id_csr1(p_collection_id IN NUMBER)IS

Line 12079: FROM AHL_WORKORDERS CWO,

12075: CWO.actual_start_date actual_start_date,
12076: CWO.actual_end_date actual_end_date,
12077: CWO.status_code status_code,
12078: CWO.master_workorder_flag master_workorder_flag
12079: FROM AHL_WORKORDERS CWO,
12080: WIP_SCHED_RELATIONSHIPS REL
12081: WHERE CWO.wip_entity_id = REL.child_object_id
12082: AND CWO.status_code <> G_JOB_STATUS_DELETED
12083: AND REL.parent_object_type_id = 1

Line 12096: AHL_WORKORDERS WO

12092: CURSOR get_wip_entity_id( c_unit_effectivity_id NUMBER ) IS
12093: SELECT WO.wip_entity_id,WO.workorder_id
12094: FROM AHL_VISIT_TASKS_B VT,
12095: AHL_UNIT_EFFECTIVITIES_APP_V UE,
12096: AHL_WORKORDERS WO
12097: WHERE WO.visit_task_id = VT.visit_task_id
12098: AND VT.unit_effectivity_id = UE.unit_effectivity_id
12099: AND WO.visit_id = VT.visit_id
12100: AND WO.master_workorder_flag = 'Y'

Line 12109: AHL_WORKORDERS WO

12105: SELECT UE.unit_effectivity_id,
12106: UE.OBJECT_VERSION_NUMBER
12107: FROM AHL_VISIT_TASKS_B VT,
12108: AHL_UNIT_EFFECTIVITIES_APP_V UE,
12109: AHL_WORKORDERS WO
12110: WHERE WO.visit_task_id = VT.visit_task_id
12111: AND VT.unit_effectivity_id = UE.unit_effectivity_id
12112: AND WO.visit_id = VT.visit_id
12113: AND WO.master_workorder_flag = 'Y'

Line 12263: UPDATE AHL_WORKORDERS

12259: || ' p_signoff_mr_rec.actual_end_date - '
12260: || to_char( p_signoff_mr_rec.actual_end_date, 'DD-MON-YYYY HH24:MI' ) );
12261: END IF;
12262:
12263: UPDATE AHL_WORKORDERS
12264: SET object_version_number = object_version_number + 1,
12265: actual_start_date = l_workorder_tbl(l_ctr).actual_start_date,
12266: actual_end_date = l_workorder_tbl(l_ctr).actual_end_date
12267: WHERE workorder_id = wo_csr.workorder_id

Line 12373: UPDATE AHL_WORKORDERS

12369: l_max := p_signoff_mr_rec.actual_end_date ;
12370: END IF;
12371: END IF;
12372:
12373: UPDATE AHL_WORKORDERS
12374: SET object_version_number = object_version_number + 1,
12375: actual_start_date = l_min,
12376: actual_end_date = l_max
12377: WHERE wip_entity_id = l_wip_entity_id;

Line 12620: AHL_UNIT_EFFECTIVITIES_B UE, AHL_VISIT_TASKS_B VT, ahl_workorders awo

12616: CURSOR c_get_unit_name_visit( c_visit_id NUMBER ) IS
12617: SELECT
12618: distinct ahl_util_uc_pkg.get_unit_name(UE.csi_item_instance_id) unit_name
12619: FROM
12620: AHL_UNIT_EFFECTIVITIES_B UE, AHL_VISIT_TASKS_B VT, ahl_workorders awo
12621: WHERE
12622: UE.unit_effectivity_id = VT.unit_effectivity_id
12623: AND ( (VT.task_type_code = 'SUMMARY') OR (TASK_TYPE_CODE = 'UNASSOCIATED' ) )
12624: AND vt.visit_task_id = awo.visit_task_id

Line 12628: ahl_workorders awo1

12624: AND vt.visit_task_id = awo.visit_task_id
12625: AND awo.wip_entity_id in ( SELECT wsch.child_object_id
12626: FROM
12627: wip_sched_relationships wsch,
12628: ahl_workorders awo1
12629: WHERE
12630: wsch.parent_object_id = awo1.wip_entity_id
12631: and awo1.visit_task_id is null
12632: and awo1.master_workorder_flag = 'Y'