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 97: FROM AHL_WORKORDERS WO, AHL_WORKORDER_OPERATIONS_V OP

93: OP.actual_start_date,
94: OP.actual_end_date,
95: OP.status_code,
96: OP.status
97: FROM AHL_WORKORDERS WO, AHL_WORKORDER_OPERATIONS_V OP
98: WHERE WO.workorder_id = OP.workorder_id
99: AND OP.workorder_operation_id = p_workorder_operation_id;
100:
101: BEGIN

Line 129: FROM AHL_WORKORDERS WO, AHL_WORKORDER_OPERATIONS_V OP

125: x_operation_rec.actual_start_date,
126: x_operation_rec.actual_end_date,
127: x_operation_rec.status_code,
128: x_operation_rec.status
129: FROM AHL_WORKORDERS WO, AHL_WORKORDER_OPERATIONS_V OP
130: WHERE WO.workorder_id = OP.workorder_id
131: AND OP.workorder_operation_id = p_workorder_operation_id;*/
132: -- fix for bug number 7295717 (Sunil)
133: OPEN get_op_details(p_workorder_operation_id);

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

230: WDJ.COMPLETION_SUBINVENTORY,
231: WDJ.COMPLETION_LOCATOR_ID,
232: WO.visit_id,
233: WO.visit_task_id
234: FROM AHL_WORKORDERS WO, FND_LOOKUP_VALUES_VL MLU,WIP_DISCRETE_JOBS WDJ,
235: (SELECT ORGANIZATION_ID FROM INV_ORGANIZATION_INFO_V WHERE
236: NVL (operating_unit, mo_global.get_current_org_id()) = mo_global.get_current_org_id()) ORG
237: WHERE WDJ.WIP_ENTITY_ID=WO.WIP_ENTITY_ID
238: AND MLU.LOOKUP_TYPE(+)='AHL_JOB_STATUS' AND WO.STATUS_CODE=MLU.LOOKUP_CODE(+)

Line 277: AHL_WORKORDERS WO

273: MR.auto_signoff_flag
274: FROM
275: AHL_MR_HEADERS_APP_V MR,
276: AHL_VISIT_TASKS_B VT,
277: AHL_WORKORDERS WO
278: WHERE MR.MR_HEADER_ID = VT.MR_ID AND
279: WO.VISIT_TASK_ID = VT.visit_task_id AND
280: WO.workorder_id = c_workorder_id;*/
281:

Line 289: --AHL_WORKORDERS WO

285: MR.auto_signoff_flag
286: FROM
287: AHL_MR_HEADERS_APP_V MR,
288: AHL_VISIT_TASKS_B VT
289: --AHL_WORKORDERS WO
290: WHERE MR.MR_HEADER_ID = VT.MR_ID AND
291: VT.visit_task_id = c_visit_task_id;
292:
293: BEGIN

Line 931: UPDATE AHL_WORKORDERS

927: l_transaction_type_code NUMBER := 1;
928: l_return_status VARCHAR2(1);
929: BEGIN
930:
931: UPDATE AHL_WORKORDERS
932: SET status_code = p_status_code,
933: object_version_number = object_version_number + 1,
934: last_update_date = SYSDATE,
935: last_updated_by = FND_GLOBAL.user_id,

Line 1510: FROM AHL_WORKORDERS WO,

1506: CURSOR get_completion_dependencies( c_child_wip_entity_id NUMBER )
1507: IS
1508: SELECT WO.workorder_name,
1509: WO.status_code
1510: FROM AHL_WORKORDERS WO,
1511: WIP_SCHED_RELATIONSHIPS WOR
1512: WHERE WO.wip_entity_id = WOR.parent_object_id
1513: AND WO.master_workorder_flag = 'N'
1514: AND WO.status_code <> G_JOB_STATUS_DELETED

Line 2029: ahl_workorders awo

2025: IS
2026: SELECT
2027: awo.actual_end_date
2028: FROM
2029: ahl_workorders awo
2030: WHERE
2031: awo.wip_entity_id = p_wip_entity_id;
2032:
2033: l_wo_actual_date DATE;

Line 3078: FROM AHL_WORKORDERS WO,

3074: SELECT WO.workorder_id workorder_id,
3075: WO.object_version_number object_version_number,
3076: WO.wip_entity_id wip_entity_id,
3077: WO.status_code status_code
3078: FROM AHL_WORKORDERS WO,
3079: WIP_SCHED_RELATIONSHIPS WOR
3080: WHERE WO.wip_entity_id = WOR.parent_object_id
3081: AND WO.master_workorder_flag = 'Y'
3082: AND WO.status_code <> G_JOB_STATUS_DELETED

Line 3091: FROM AHL_WORKORDERS WO,

3087:
3088: CURSOR get_child_wo_status( c_master_wip_entity_id NUMBER )
3089: IS
3090: SELECT DISTINCT WO.status_code status_code
3091: FROM AHL_WORKORDERS WO,
3092: WIP_SCHED_RELATIONSHIPS WOR
3093: WHERE WO.wip_entity_id = WOR.child_object_id
3094: AND WO.status_code <> G_JOB_STATUS_DELETED
3095: AND WOR.parent_object_type_id = 1

Line 3140: FROM AHL_WORKORDERS

3136: IS
3137: SELECT Actual_start_date,
3138: Actual_end_date,
3139: Workorder_name
3140: FROM AHL_WORKORDERS
3141: WHERE workorder_id = x_wo_id;
3142:
3143: -- R12: Login/logout feature.
3144: -- here we pick up all employees logged in at all levels.

Line 3158: l_wo_name ahl_workorders.workorder_name%TYPE;

3154: l_actual_end_date DATE;
3155: l_actual_start_date DATE;
3156: l_def_actual_end_date DATE;
3157: l_def_actual_start_date DATE;
3158: l_wo_name ahl_workorders.workorder_name%TYPE;
3159:
3160: l_employee_id NUMBER;
3161: l_operation_seq_num NUMBER;
3162: l_resource_seq_num NUMBER;

Line 3268: UPDATE AHL_WORKORDERS

3264:
3265: /*
3266: -- update the actual dates in the table
3267: IF l_actual_start_date IS NULL THEN
3268: UPDATE AHL_WORKORDERS
3269: SET ACTUAL_START_DATE = l_def_actual_start_date,
3270: LAST_UPDATE_DATE = SYSDATE,
3271: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
3272: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

Line 3283: UPDATE AHL_WORKORDERS

3279: END IF;-- IF l_actual_start_date IS NULL THEN
3280:
3281: -- update the actual dates in the table
3282: IF l_actual_end_date IS NULL THEN
3283: UPDATE AHL_WORKORDERS
3284: SET ACTUAL_END_DATE = l_def_actual_end_date,
3285: LAST_UPDATE_DATE = SYSDATE,
3286: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
3287: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

Line 4407: FROM AHL_WORKORDERS WO,

4403: G_JOB_STATUS_COMPLETE_NC, G_JOB_STATUS_COMPLETE,
4404: G_JOB_STATUS_PARTS_HOLD, G_JOB_STATUS_ON_HOLD,
4405: G_JOB_STATUS_DEFERRAL_PENDING,G_JOB_STATUS_ON_HOLD,
4406: WO.status_code ) status_code
4407: FROM AHL_WORKORDERS WO,
4408: AHL_VISIT_TASKS_B VT
4409: WHERE WO.visit_task_id = VT.visit_task_id
4410: AND WO.status_code <> G_JOB_STATUS_DELETED
4411: AND WO.master_workorder_flag = 'N'

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

4425: G_JOB_STATUS_COMPLETE_NC, G_JOB_STATUS_COMPLETE,
4426: G_JOB_STATUS_PARTS_HOLD, G_JOB_STATUS_ON_HOLD,
4427: G_JOB_STATUS_DEFERRAL_PENDING,G_JOB_STATUS_ON_HOLD,
4428: CWO.status_code ) status_code
4429: FROM AHL_WORKORDERS CWO, ahl_visit_tasks_b vst, wip_discrete_jobs WIPJ
4430: where CWO.visit_task_id = vst.visit_task_id
4431: AND vst.unit_effectivity_id = c_unit_effectivity_id
4432: AND CWO.master_workorder_flag = 'N'
4433: AND CWO.wip_entity_id in (SELECT REL.child_object_id

Line 4438: FROM AHL_WORKORDERS PWO,

4434: from WIP_SCHED_RELATIONSHIPS REL
4435: START WITH REL.parent_object_id IN
4436: (
4437: SELECT PWO.wip_entity_id
4438: FROM AHL_WORKORDERS PWO,
4439: AHL_VISIT_TASKS_B VT,
4440: AHL_VISITS_B VS
4441: WHERE PWO.master_workorder_flag = 'Y'
4442: AND PWO.visit_task_id = VT.visit_task_id

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

4468: G_JOB_STATUS_COMPLETE_NC, G_JOB_STATUS_COMPLETE,
4469: G_JOB_STATUS_PARTS_HOLD, G_JOB_STATUS_ON_HOLD,
4470: G_JOB_STATUS_DEFERRAL_PENDING,G_JOB_STATUS_ON_HOLD,
4471: CWO.status_code ) status_code
4472: FROM AHL_WORKORDERS CWO, ahl_visit_tasks_b vst, wip_discrete_jobs WIPJ
4473: where CWO.visit_task_id = vst.visit_task_id
4474: AND vst.unit_effectivity_id = c_unit_effectivity_id
4475: AND vst.task_type_code = 'UNASSOCIATED'
4476: AND WIPJ.wip_entity_id = CWO.wip_entity_id; */

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

4490: G_JOB_STATUS_COMPLETE_NC, G_JOB_STATUS_COMPLETE,
4491: G_JOB_STATUS_PARTS_HOLD, G_JOB_STATUS_ON_HOLD,
4492: G_JOB_STATUS_DEFERRAL_PENDING,G_JOB_STATUS_ON_HOLD,
4493: CWO.status_code ) status_code
4494: FROM AHL_WORKORDERS CWO, ahl_visit_tasks_b vst, wip_discrete_jobs WIPJ
4495: where CWO.visit_task_id = vst.visit_task_id
4496: --AND vst.unit_effectivity_id = c_unit_effectivity_id
4497: AND CWO.master_workorder_flag = 'N'
4498: AND CWO.wip_entity_id in (SELECT REL.child_object_id

Line 4503: FROM AHL_WORKORDERS PWO,

4499: from WIP_SCHED_RELATIONSHIPS REL
4500: START WITH REL.parent_object_id IN
4501: (
4502: SELECT PWO.wip_entity_id
4503: FROM AHL_WORKORDERS PWO,
4504: AHL_VISIT_TASKS_B VT,
4505: AHL_VISITS_B VS
4506: WHERE PWO.master_workorder_flag = 'Y'
4507: AND PWO.visit_task_id = VT.visit_task_id

Line 4525: FROM AHL_WORKORDERS CWO, ahl_visit_tasks_b vst

4521: --to check released/unpleased/qa-pending
4522: CURSOR get_mr_status_csr(c_unit_effectivity_id NUMBER,p_status_code VARCHAR2) IS
4523: SELECT
4524: CWO.status_code
4525: FROM AHL_WORKORDERS CWO, ahl_visit_tasks_b vst
4526: where CWO.visit_task_id = vst.visit_task_id
4527: AND CWO.master_workorder_flag = 'N'
4528: AND CWO.status_code IN (p_status_code)
4529: AND vst.unit_effectivity_id IN (select related_ue_id

Line 4543: FROM AHL_WORKORDERS CWO, ahl_visit_tasks_b vst

4539:
4540: CURSOR is_mr_on_hold_csr(c_unit_effectivity_id NUMBER) IS
4541: SELECT
4542: CWO.status_code
4543: FROM AHL_WORKORDERS CWO, ahl_visit_tasks_b vst
4544: where CWO.visit_task_id = vst.visit_task_id
4545: AND CWO.master_workorder_flag = 'N'
4546: AND CWO.status_code IN (G_JOB_STATUS_PARTS_HOLD, G_JOB_STATUS_ON_HOLD,
4547: G_JOB_STATUS_DEFERRAL_PENDING)

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

4558:
4559: CURSOR is_mr_complete_csr(c_unit_effectivity_id NUMBER) IS
4560: SELECT
4561: CWO.status_code
4562: FROM AHL_WORKORDERS CWO, ahl_visit_tasks_b vst, wip_discrete_jobs wipj
4563: where CWO.visit_task_id = vst.visit_task_id
4564: AND WIPJ.wip_entity_id = CWO.wip_entity_id
4565: AND CWO.master_workorder_flag = 'N'
4566: AND CWO.status_code IN (G_JOB_STATUS_CLOSED, G_JOB_STATUS_COMPLETE_NC, G_JOB_STATUS_COMPLETE)

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

4578:
4579: CURSOR is_mr_cancelled_csr(c_unit_effectivity_id NUMBER) IS
4580: SELECT
4581: CWO.status_code
4582: FROM AHL_WORKORDERS CWO, ahl_visit_tasks_b vst, wip_discrete_jobs wipj
4583: where CWO.visit_task_id = vst.visit_task_id
4584: AND WIPJ.wip_entity_id = CWO.wip_entity_id
4585: --AND vst.unit_effectivity_id = c_unit_effectivity_id
4586: AND CWO.master_workorder_flag = 'N'

Line 4911: FROM AHL_WORKORDERS

4907: CURSOR get_Wo_details(c_visit_id NUMBER)
4908: IS
4909: SELECT workorder_id,
4910: workorder_name
4911: FROM AHL_WORKORDERS
4912: WHERE visit_id = c_visit_id
4913: AND MASTER_WORKORDER_FLAG = 'N';
4914:
4915: CURSOR get_ue_title(p_workorder_id NUMBER)

Line 4920: ahl_workorders WO,

4916: IS
4917: SELECT
4918: UE.title
4919: FROM
4920: ahl_workorders WO,
4921: ahl_visit_tasks_b VTSK,
4922: ahl_unit_effectivities_v UE
4923: WHERE
4924: WO.workorder_id = p_workorder_id

Line 5058: FROM AHL_WORKORDERS CWO,

5054: CWO.actual_start_date actual_start_date,
5055: CWO.actual_end_date actual_end_date,
5056: CWO.status_code status_code,
5057: CWO.master_workorder_flag master_workorder_flag
5058: FROM AHL_WORKORDERS CWO,
5059: WIP_SCHED_RELATIONSHIPS REL
5060: WHERE CWO.wip_entity_id = REL.child_object_id
5061: AND CWO.status_code <> G_JOB_STATUS_DELETED
5062: AND REL.parent_object_type_id = 1

Line 5172: UPDATE AHL_WORKORDERS

5168:
5169:
5170: BEGIN
5171:
5172: UPDATE AHL_WORKORDERS
5173: SET object_version_number = object_version_number + 1,
5174: actual_start_date = l_workorder_tbl(l_ctr).actual_start_date,
5175: actual_end_date = l_workorder_tbl(l_ctr).actual_end_date
5176: WHERE workorder_id = wo_csr.workorder_id

Line 5234: UPDATE AHL_WORKORDERS

5230: l_max := p_actual_end_date;
5231: END IF;*/
5232: /*End ER # 4757222*/
5233:
5234: UPDATE AHL_WORKORDERS
5235: SET object_version_number = object_version_number + 1,
5236: actual_start_date = l_min,
5237: actual_end_date = l_max
5238: WHERE wip_entity_id = p_wip_entity_id;

Line 5265: FROM AHL_WORKORDERS WO,

5261: G_JOB_STATUS_CANCELLED, G_JOB_STATUS_COMPLETE,
5262: G_JOB_STATUS_DELETED, G_JOB_STATUS_COMPLETE,
5263: WO.status_code ) parent_status_code,
5264: WOR.child_object_id child_we_id
5265: FROM AHL_WORKORDERS WO,
5266: WIP_SCHED_RELATIONSHIPS WOR
5267: WHERE WO.wip_entity_id = WOR.parent_object_id
5268: AND WOR.top_level_object_id = c_wip_entity_id
5269: AND WOR.relationship_type = 2

Line 5547: FROM AHL_WORKORDERS

5543: IS
5544: SELECT Actual_start_date,
5545: Actual_end_date,
5546: Workorder_name
5547: FROM AHL_WORKORDERS
5548: WHERE workorder_id = x_wo_id;
5549:
5550: -- To get the Unit Effectivity Details and it's master workorder details
5551: /*CURSOR get_ue_details( c_unit_effectivity_id NUMBER ) IS

Line 5575: AHL_WORKORDERS WO,

5571: WO.plan_id wo_plan_id,
5572: WO.collection_id wo_collection_id,
5573: WO.master_workorder_flag
5574: FROM WIP_DISCRETE_JOBS WIP,
5575: AHL_WORKORDERS WO,
5576: AHL_WORKORDERS VWO,
5577: AHL_VISIT_TASKS_B VT,
5578: AHL_UE_DEFERRAL_DETAILS_V UE
5579: WHERE WIP.wip_entity_id = WO.wip_entity_id

Line 5576: AHL_WORKORDERS VWO,

5572: WO.collection_id wo_collection_id,
5573: WO.master_workorder_flag
5574: FROM WIP_DISCRETE_JOBS WIP,
5575: AHL_WORKORDERS WO,
5576: AHL_WORKORDERS VWO,
5577: AHL_VISIT_TASKS_B VT,
5578: AHL_UE_DEFERRAL_DETAILS_V UE
5579: WHERE WIP.wip_entity_id = WO.wip_entity_id
5580: AND WO.visit_task_id = VT.visit_task_id

Line 5615: AHL_WORKORDERS WO,

5611: WO.collection_id wo_collection_id,
5612: WO.master_workorder_flag,
5613: WIP.ORGANIZATION_ID org_id
5614: FROM WIP_DISCRETE_JOBS WIP,
5615: AHL_WORKORDERS WO,
5616: AHL_WORKORDERS VWO,
5617: AHL_VISIT_TASKS_B VT,
5618: AHL_UNIT_EFFECTIVITIES_APP_V UE
5619: WHERE WIP.wip_entity_id = WO.wip_entity_id

Line 5616: AHL_WORKORDERS VWO,

5612: WO.master_workorder_flag,
5613: WIP.ORGANIZATION_ID org_id
5614: FROM WIP_DISCRETE_JOBS WIP,
5615: AHL_WORKORDERS WO,
5616: AHL_WORKORDERS VWO,
5617: AHL_VISIT_TASKS_B VT,
5618: AHL_UNIT_EFFECTIVITIES_APP_V UE
5619: WHERE WIP.wip_entity_id = WO.wip_entity_id
5620: AND WO.visit_task_id = VT.visit_task_id

Line 5699: AHL_WORKORDERS CWO,

5695: CWO.master_workorder_flag master_workorder_flag,
5696: CWO.plan_id plan_id,
5697: CWO.collection_id collection_id
5698: FROM WIP_DISCRETE_JOBS WIP,
5699: AHL_WORKORDERS CWO,
5700: WIP_SCHED_RELATIONSHIPS REL
5701: WHERE WIP.wip_entity_id = CWO.wip_entity_id
5702: AND CWO.wip_entity_id = REL.child_object_id
5703: AND CWO.status_code <> G_JOB_STATUS_DELETED

Line 5728: AHL_WORKORDERS CWO

5724: WOP.plan_id plan_id,
5725: WOP.collection_id collection_id
5726: FROM AHL_WORKORDER_OPERATIONS WOP,
5727: WIP_OPERATIONS WIP,
5728: AHL_WORKORDERS CWO
5729: WHERE WOP.operation_sequence_num = WIP.operation_seq_num
5730: AND WOP.workorder_id = CWO.workorder_id
5731: AND WIP.wip_entity_id = CWO.wip_entity_id
5732: --AND CWO.status_code <> G_JOB_STATUS_DELETED

Line 5745: AHL_WORKORDERS CWO,

5741: )
5742: AND WIP.WIP_ENTITY_ID IN (
5743: SELECT CWO.wip_entity_id
5744: FROM WIP_DISCRETE_JOBS WIP,
5745: AHL_WORKORDERS CWO,
5746: WIP_SCHED_RELATIONSHIPS REL
5747: WHERE WIP.wip_entity_id = CWO.wip_entity_id
5748: AND CWO.wip_entity_id = REL.child_object_id
5749: AND CWO.status_code <> G_JOB_STATUS_DELETED

Line 5777: AHL_WORKORDERS CWO

5773: WOP.plan_id plan_id,
5774: WOP.collection_id collection_id
5775: FROM AHL_WORKORDER_OPERATIONS WOP,
5776: WIP_OPERATIONS WIP,
5777: AHL_WORKORDERS CWO
5778: WHERE WOP.operation_sequence_num = WIP.operation_seq_num
5779: AND WOP.workorder_id = CWO.workorder_id
5780: AND WIP.wip_entity_id = CWO.wip_entity_id
5781: AND WIP.WIP_ENTITY_ID = c_wip_entity_id

Line 5815: AHL_WORKORDERS CWO,

5811: WOR.usage_rate_or_amount usage_rate_or_amount
5812: FROM BOM_RESOURCES BOM,
5813: WIP_OPERATION_RESOURCES WOR,
5814: AHL_WORKORDER_OPERATIONS WOP,
5815: AHL_WORKORDERS CWO,
5816: WIP_SCHED_RELATIONSHIPS REL
5817: WHERE BOM.resource_type IN ( 1 , 2 )
5818: AND BOM.resource_id = WOR.resource_id
5819: AND WOR.operation_seq_num = WOP.operation_sequence_num

Line 5860: AHL_WORKORDERS CWO

5856: WOR.usage_rate_or_amount usage_rate_or_amount
5857: FROM BOM_RESOURCES BOM,
5858: WIP_OPERATION_RESOURCES WOR,
5859: AHL_WORKORDER_OPERATIONS WOP,
5860: AHL_WORKORDERS CWO
5861: WHERE BOM.resource_type IN ( 1 , 2 )
5862: AND BOM.resource_id = WOR.resource_id
5863: AND WOR.operation_seq_num = WOP.operation_sequence_num
5864: AND WOR.wip_entity_id = CWO.wip_entity_id

Line 7313: UPDATE AHL_WORKORDERS

7309: END IF;
7310:
7311: -- update the actual dates in the table
7312: IF l_wo_actual_start_date IS NULL THEN
7313: UPDATE AHL_WORKORDERS
7314: SET OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
7315: ACTUAL_START_DATE = l_def_actual_start_date,
7316: LAST_UPDATE_DATE = SYSDATE,
7317: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

Line 7332: UPDATE AHL_WORKORDERS

7328: END IF;-- IF l_actual_start_date IS NULL THEN
7329:
7330: -- update the actual dates in the table
7331: IF l_wo_actual_end_date IS NULL THEN
7332: UPDATE AHL_WORKORDERS
7333: SET OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
7334: ACTUAL_END_DATE = l_def_actual_end_date,
7335: LAST_UPDATE_DATE = SYSDATE,
7336: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

Line 7350: UPDATE AHL_WORKORDERS

7346: l_workorder_tbl(i).object_version_number := l_workorder_tbl(i).object_version_number + 1;
7347: END IF; -- IF l_actual_end_date IS NULL THEN
7348: /*ELSE
7349:
7350: UPDATE AHL_WORKORDERS
7351: SET object_version_number = object_version_number + 1,
7352: actual_start_date = l_workorder_tbl(i).actual_start_date,
7353: actual_end_date = l_workorder_tbl(i).actual_end_date,
7354: LAST_UPDATE_DATE = SYSDATE,

Line 7728: FROM AHL_WORKORDERS

7724: IS
7725: SELECT Actual_start_date,
7726: Actual_end_date,
7727: Workorder_name
7728: FROM AHL_WORKORDERS
7729: WHERE workorder_id = x_wo_id;
7730:
7731: -- To get the Visit and it's master workorder details
7732: CURSOR get_visit_details( c_visit_id NUMBER ) IS

Line 7751: AHL_WORKORDERS WO,

7747: WO.status_code wo_status_code,
7748: WO.plan_id wo_plan_id,
7749: WO.collection_id wo_collection_id
7750: FROM WIP_DISCRETE_JOBS WIP,
7751: AHL_WORKORDERS WO,
7752: AHL_VISITS_B VST
7753: WHERE WIP.wip_entity_id = WO.wip_entity_id
7754: AND WO.visit_task_id IS NULL
7755: AND WO.master_workorder_flag = 'Y'

Line 7791: ahl_workorders awo

7787: UE.qa_plan_id qa_plan_id,
7788: UE.qa_collection_id qa_collection_id
7789: FROM AHL_UE_DEFERRAL_DETAILS_V UE,
7790: AHL_VISIT_TASKS_B VT,
7791: ahl_workorders awo
7792: WHERE UE.unit_effectivity_id = VT.unit_effectivity_id
7793: AND ( (VT.task_type_code = 'SUMMARY')
7794: OR (TASK_TYPE_CODE = 'UNASSOCIATED' ) )
7795: AND vt.visit_task_id = awo.visit_task_id

Line 7800: ahl_workorders awo1

7796: and awo.wip_entity_id in ( SELECT
7797: wsch.child_object_id
7798: FROM
7799: wip_sched_relationships wsch,
7800: ahl_workorders awo1
7801: WHERE
7802: wsch.parent_object_id = awo1.wip_entity_id
7803: and awo1.visit_task_id is null
7804: and awo1.master_workorder_flag = 'Y'

Line 7821: ahl_workorders awo

7817: -1 qa_plan_id,
7818: UE.qa_collection_id qa_collection_id
7819: FROM AHL_UNIT_EFFECTIVITIES_B UE,
7820: AHL_VISIT_TASKS_B VT,
7821: ahl_workorders awo
7822: WHERE UE.unit_effectivity_id = VT.unit_effectivity_id
7823: AND ( (VT.task_type_code = 'SUMMARY')
7824: OR (TASK_TYPE_CODE = 'UNASSOCIATED' ) )
7825: AND vt.visit_task_id = awo.visit_task_id

Line 7830: ahl_workorders awo1

7826: and awo.wip_entity_id in ( SELECT
7827: wsch.child_object_id
7828: FROM
7829: wip_sched_relationships wsch,
7830: ahl_workorders awo1
7831: WHERE
7832: wsch.parent_object_id = awo1.wip_entity_id
7833: and awo1.visit_task_id is null
7834: and awo1.master_workorder_flag = 'Y'

Line 7911: AHL_WORKORDERS WO

7907: WO.master_workorder_flag master_workorder_flag,
7908: WO.plan_id plan_id,
7909: WO.collection_id collection_id
7910: FROM WIP_DISCRETE_JOBS WIP,
7911: AHL_WORKORDERS WO
7912: WHERE WIP.wip_entity_id = WO.wip_entity_id
7913: AND WO.status_code <> G_JOB_STATUS_DELETED
7914: AND WO.visit_task_id IS NOT NULL
7915: AND WO.visit_id = c_visit_id

Line 7934: AHL_WORKORDERS WO

7930: WOP.plan_id plan_id,
7931: WOP.collection_id collection_id
7932: FROM AHL_WORKORDER_OPERATIONS WOP,
7933: WIP_OPERATIONS WIP,
7934: AHL_WORKORDERS WO
7935: WHERE WOP.operation_sequence_num = WIP.operation_seq_num
7936: AND WOP.workorder_id = WO.workorder_id
7937: AND WIP.wip_entity_id = WO.wip_entity_id
7938: AND WO.status_code NOT IN

Line 7967: AHL_WORKORDERS WO

7963: WOR.usage_rate_or_amount usage_rate_or_amount
7964: FROM BOM_RESOURCES BOM,
7965: WIP_OPERATION_RESOURCES WOR,
7966: AHL_WORKORDER_OPERATIONS WOP,
7967: AHL_WORKORDERS WO
7968: WHERE BOM.resource_type IN ( 1 , 2 )
7969: AND BOM.resource_id = WOR.resource_id
7970: AND WOR.operation_seq_num = WOP.operation_sequence_num
7971: AND WOR.wip_entity_id = WO.wip_entity_id

Line 9117: UPDATE AHL_WORKORDERS

9113: );
9114:
9115: -- update the actual dates in the table
9116: IF l_workorder_tbl(i).actual_start_date IS NULL THEN
9117: UPDATE AHL_WORKORDERS
9118: SET OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
9119: ACTUAL_START_DATE = l_def_actual_start_date,
9120: LAST_UPDATE_DATE = SYSDATE,
9121: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

Line 9136: UPDATE AHL_WORKORDERS

9132: END IF;-- IF l_actual_start_date IS NULL THEN
9133:
9134: -- update the actual dates in the table
9135: IF l_workorder_tbl(i).actual_end_date IS NULL THEN
9136: UPDATE AHL_WORKORDERS
9137: SET OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
9138: ACTUAL_END_DATE = l_def_actual_end_date,
9139: LAST_UPDATE_DATE = SYSDATE,
9140: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

Line 9158: UPDATE AHL_WORKORDERS

9154: /*End ER # 4757222*/
9155: /*Start ER # 4757222
9156: -- Ignore Master Workorders since they are post processed seperately
9157: IF ( l_workorder_tbl(i).master_workorder_flag = 'N' ) THEN
9158: UPDATE AHL_WORKORDERS
9159: SET object_version_number = object_version_number + 1,
9160: actual_start_date = l_workorder_tbl(i).actual_start_date,
9161: actual_end_date = l_workorder_tbl(i).actual_end_date
9162: WHERE workorder_id = l_workorder_tbl(i).workorder_id

Line 9576: FROM AHL_WORKORDERS WO,

9572: --UE.qa_plan_id ue_qa_plan_id,
9573: --UE.qa_collection_id ue_qa_collection_id,
9574: WO.workorder_id workorder_id,
9575: WO.wip_entity_id wip_entity_id
9576: FROM AHL_WORKORDERS WO,
9577: AHL_VISIT_TASKS_B VT,
9578: --AHL_UE_DEFERRAL_DETAILS_V UE
9579: AHL_UNIT_EFFECTIVITIES_B UE
9580: WHERE WO.visit_task_id = VT.visit_task_id

Line 9611: AHL_WORKORDERS CWO,

9607: -- To get the Child Workorder Details for a UE
9608: CURSOR get_ue_workorders( c_wip_entity_id NUMBER ) IS
9609: SELECT CWO.workorder_id workorder_id
9610: FROM WIP_DISCRETE_JOBS WIP,
9611: AHL_WORKORDERS CWO,
9612: WIP_SCHED_RELATIONSHIPS REL
9613: WHERE WIP.wip_entity_id = CWO.wip_entity_id
9614: AND CWO.wip_entity_id = REL.child_object_id
9615: 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 9630: AHL_WORKORDERS CWO

9626: SELECT WOP.workorder_id workorder_id,
9627: WIP.operation_seq_num operation_seq_num
9628: FROM AHL_WORKORDER_OPERATIONS WOP,
9629: WIP_OPERATIONS WIP,
9630: AHL_WORKORDERS CWO
9631: WHERE WOP.operation_sequence_num = WIP.operation_seq_num
9632: AND WOP.workorder_id = CWO.workorder_id
9633: AND WIP.wip_entity_id = CWO.wip_entity_id
9634: AND WIP.WIP_ENTITY_ID IN (

Line 9637: AHL_WORKORDERS CWO,

9633: AND WIP.wip_entity_id = CWO.wip_entity_id
9634: AND WIP.WIP_ENTITY_ID IN (
9635: SELECT CWO.wip_entity_id
9636: FROM WIP_DISCRETE_JOBS WIP,
9637: AHL_WORKORDERS CWO,
9638: WIP_SCHED_RELATIONSHIPS REL
9639: WHERE WIP.wip_entity_id = CWO.wip_entity_id
9640: AND CWO.wip_entity_id = REL.child_object_id
9641: AND CWO.status_code <> G_JOB_STATUS_DELETED

Line 9917: FROM AHL_WORKORDERS

9913: -- cursor to retrieve the wip_entity_id
9914: CURSOR c_get_wo_details(x_workorder_id NUMBER)
9915: IS
9916: SELECT WIP_ENTITY_ID
9917: FROM AHL_WORKORDERS
9918: WHERE WORKORDER_ID = x_workorder_id;
9919:
9920: -- cursor to retrieve minimum and maximum resource transactions dates for this
9921: -- operation for resource transactions of type 'Person'

Line 10136: FROM AHL_WORKORDERS

10132:
10133: CURSOR c_get_mwo_flag(x_workorder_id NUMBER)
10134: IS
10135: SELECT MASTER_WORKORDER_FLAG
10136: FROM AHL_WORKORDERS
10137: WHERE WORKORDER_ID = x_workorder_id;
10138:
10139: BEGIN
10140:

Line 10202: FROM AHL_WORKORDERS

10198: -- cursor to retrieve the visit master workorder
10199: CURSOR get_visit_master_wo(c_visit_id NUMBER )
10200: IS
10201: SELECT workorder_id, object_version_number, wip_entity_id
10202: FROM AHL_WORKORDERS
10203: WHERE visit_id = c_visit_id
10204: AND master_workorder_flag = 'Y'
10205: --AND status_code NOT IN ('7', '22', '4', '12', '5')
10206: AND VISIT_TASK_ID IS NULL;

Line 10213: FROM AHL_WORKORDERS WO,

10209: IS
10210: SELECT WO.workorder_id,
10211: WO.object_version_number, VTS.task_type_code,
10212: WO.wip_entity_id
10213: FROM AHL_WORKORDERS WO,
10214: AHL_VISIT_TASKS_B VTS
10215: WHERE WO.visit_task_id = VTS.visit_task_id
10216: AND VTS.unit_effectivity_id = c_ue_id
10217: --AND WO.status_code NOT IN ('7', '22', '4', '12', '5')

Line 10223: FROM AHL_WORKORDERS

10219:
10220: CURSOR get_wo_ovn(c_workorder_id NUMBER)
10221: IS
10222: SELECT object_version_number, wip_entity_id
10223: FROM AHL_WORKORDERS
10224: WHERE workorder_id = c_workorder_id;
10225: --AND status_code NOT IN ('7', '22', '4', '12', '5');
10226:
10227: -- Fix for FP bug# 5138909 (issue#2).

Line 10235: FROM AHL_WORKORDERS AWO, WIP_DISCRETE_JOBS WDJ

10231: -- cursor to check if all workorders in a visit are cancelled.
10232: CURSOR chk_cmplt_wo_exists(c_wip_entity_id NUMBER )
10233: IS
10234: SELECT 'x'
10235: FROM AHL_WORKORDERS AWO, WIP_DISCRETE_JOBS WDJ
10236: WHERE awo.wip_entity_id = wdj.wip_entity_id
10237: AND wdj.date_completed IS NOT NULL
10238: --AND master_workorder_flag = 'N'
10239: --AND status_code NOT IN ('7', '22', '12')

Line 10442: AHL_WORKORDERS AWO,

10438: AWO.attribute13,
10439: AWO.attribute14,
10440: AWO.attribute15
10441: FROM
10442: AHL_WORKORDERS AWO,
10443: WIP_DISCRETE_JOBS WIPJ,
10444: WIP_ENTITIES WIPE
10445: WHERE
10446: AWO.status_code in (4,5,7)

Line 10458: AHL_WORKORDERS AWO

10454: SELECT
10455: 'x'
10456: FROM
10457: CSI_ITEM_INSTANCES CII,
10458: AHL_WORKORDERS AWO
10459: WHERE
10460: CII.WIP_JOB_ID = AWO.WIP_ENTITY_ID
10461: AND AWO.workorder_id = p_workorder_id
10462: AND ACTIVE_START_DATE <= SYSDATE

Line 10705: AHL_WORKORDERS

10701:
10702: FORALL l_count IN l_workorder_id_tbl.FIRST .. l_workorder_id_tbl.LAST
10703: SAVE EXCEPTIONS
10704: UPDATE
10705: AHL_WORKORDERS
10706: SET
10707: status_code = 12,
10708: last_update_date = sysdate,
10709: last_updated_by = fnd_global.user_id,

Line 10929: SELECT wo.actual_end_date FROM ahl_workorders WO

10925: l_organization_id NUMBER;
10926: l_visit_task_id NUMBER;
10927:
10928: CURSOR act_end_dt_csr(p_visit_task_id IN NUMBER) IS
10929: SELECT wo.actual_end_date FROM ahl_workorders WO
10930: WHERE WO.visit_task_id = p_visit_task_id
10931: AND master_workorder_flag = 'Y';
10932:
10933: CURSOR get_qa_plan_id_csr1(p_collection_id IN NUMBER)IS