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_WORKORDER_OPERATIONS

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 632: FROM AHL_WORKORDER_MTL_TXNS TXN, AHL_WORKORDER_OPERATIONS OP

628:
629: CURSOR get_ahl_txn_rec( c_workorder_id NUMBER )
630: IS
631: SELECT MAX ( TXN.creation_date )
632: FROM AHL_WORKORDER_MTL_TXNS TXN, AHL_WORKORDER_OPERATIONS OP
633: WHERE TXN.workorder_operation_id = OP.workorder_operation_id
634: AND OP.workorder_id = c_workorder_id;
635: BEGIN
636:

Line 1419: UPDATE AHL_WORKORDER_OPERATIONS

1415: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1416: RETURN FND_API.G_RET_STS_ERROR;
1417: END IF;
1418: --sukhwsin::VEE Code Changes - end
1419: UPDATE AHL_WORKORDER_OPERATIONS
1420: SET status_code = G_OP_STATUS_COMPLETE,
1421: object_version_number = object_version_number + 1,
1422: last_update_date = SYSDATE,
1423: last_updated_by = FND_GLOBAL.user_id,

Line 1462: FROM AHL_WORKORDER_OPERATIONS_V

1458: actual_start_date,
1459: actual_end_date,
1460: status_code,
1461: status
1462: FROM AHL_WORKORDER_OPERATIONS_V
1463: WHERE workorder_id = c_workorder_id;
1464:
1465: BEGIN
1466:

Line 2842: FROM AHL_WORKORDER_OPERATIONS

2838: SELECT workorder_id,
2839: Operation_sequence_num,
2840: Actual_start_date,
2841: Actual_end_date
2842: FROM AHL_WORKORDER_OPERATIONS
2843: WHERE workorder_operation_id = x_wo_op_id;
2844:
2845: -- R12
2846: -- Tech UIs

Line 2921: UPDATE AHL_WORKORDER_OPERATIONS

2917: END IF;
2918:
2919: -- update the actual dates in the table
2920: IF l_actual_start_date IS NULL THEN
2921: UPDATE AHL_WORKORDER_OPERATIONS
2922: SET ACTUAL_START_DATE = l_operation_tbl(1).actual_start_date,
2923: LAST_UPDATE_DATE = SYSDATE,
2924: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
2925: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

Line 2934: UPDATE AHL_WORKORDER_OPERATIONS

2930: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2931: END IF;
2932: END IF; -- IF l_actual_start_date IS NULL THEN
2933: IF l_actual_end_date IS NULL THEN
2934: UPDATE AHL_WORKORDER_OPERATIONS
2935: SET ACTUAL_END_DATE = l_operation_tbl(1).actual_end_date,
2936: LAST_UPDATE_DATE = SYSDATE,
2937: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
2938: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

Line 6008: FROM AHL_WORKORDER_OPERATIONS WOP,

6004: WOP.actual_end_date actual_end_date,
6005: WOP.status_code status_code,
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

Line 6057: FROM AHL_WORKORDER_OPERATIONS WOP,

6053: WOP.actual_end_date actual_end_date,
6054: WOP.status_code status_code,
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

Line 6096: AHL_WORKORDER_OPERATIONS WOP,

6092: WOR.uom_code uom_code,
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

Line 6141: AHL_WORKORDER_OPERATIONS WOP,

6137: WOR.uom_code uom_code,
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

Line 7578: UPDATE AHL_WORKORDER_OPERATIONS

7574: THEN
7575:
7576: IF ( l_operation_tbl.COUNT > 0 ) THEN
7577: FOR i IN l_operation_tbl.FIRST..l_operation_tbl.LAST LOOP
7578: UPDATE AHL_WORKORDER_OPERATIONS
7579: SET object_version_number = object_version_number + 1,
7580: actual_start_date = l_operation_tbl(i).actual_start_date,
7581: actual_end_date = l_operation_tbl(i).actual_end_date,
7582: LAST_UPDATE_DATE = SYSDATE,

Line 8344: FROM AHL_WORKORDER_OPERATIONS WOP,

8340: WOP.plan_id plan_id,
8341: WOP.collection_id collection_id,
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:

Line 8381: AHL_WORKORDER_OPERATIONS WOP,

8377: WOR.uom_code uom_code,
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

Line 9711: UPDATE AHL_WORKORDER_OPERATIONS

9707: --AND p_close_visit_rec.default_actual_dates_flag = 'N'
9708:
9709: IF ( l_operation_tbl.COUNT > 0 ) THEN
9710: FOR i IN l_operation_tbl.FIRST..l_operation_tbl.LAST LOOP
9711: UPDATE AHL_WORKORDER_OPERATIONS
9712: SET object_version_number = object_version_number + 1,
9713: actual_start_date = l_operation_tbl(i).actual_start_date,
9714: actual_end_date = l_operation_tbl(i).actual_end_date,
9715: LAST_UPDATE_DATE = SYSDATE,

Line 10345: AHL_WORKORDER_OPERATIONS

10341: IS
10342: SELECT
10343: workorder_operation_id
10344: FROM
10345: AHL_WORKORDER_OPERATIONS
10346: WHERE
10347: workorder_id = p_workorder_id AND
10348: operation_sequence_num = p_op_seq_no;
10349:

Line 10413: FROM AHL_WORKORDER_OPERATIONS WOP,

10409: -- To get all the UE Operations
10410: CURSOR get_ue_operations( c_wip_entity_id NUMBER ) IS
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

Line 10684: -- cursor to retrieve the relevant operation details from AHL_WORKORDER_OPERATIONS table

10680: L_max_pending_txn_date DATE;
10681: l_start_date DATE;
10682: l_end_date DATE;
10683:
10684: -- cursor to retrieve the relevant operation details from AHL_WORKORDER_OPERATIONS table
10685: CURSOR c_get_op_details(x_workorder_id NUMBER,
10686: x_operation_seq_num NUMBER)
10687: IS
10688: SELECT WORKORDER_OPERATION_ID,

Line 10694: FROM AHL_WORKORDER_OPERATIONS_V

10690: SCHEDULED_START_DATE,
10691: SCHEDULED_END_DATE,
10692: ACTUAL_START_DATE,
10693: ACTUAL_END_DATE
10694: FROM AHL_WORKORDER_OPERATIONS_V
10695: WHERE WORKORDER_ID = x_workorder_id
10696: AND OPERATION_SEQUENCE_NUM = x_operation_seq_num;
10697:
10698: -- cursor to retrieve the wip_entity_id

Line 10862: -- cursor to retrieve the relevant operation details from AHL_WORKORDER_OPERATIONS table

10858: p_x_operation_tbl IN OUT NOCOPY AHL_COMPLETIONS_PVT.operation_tbl_type
10859: )
10860: IS
10861:
10862: -- cursor to retrieve the relevant operation details from AHL_WORKORDER_OPERATIONS table
10863: CURSOR c_get_op_details(x_workorder_id NUMBER,
10864: x_operation_seq_num NUMBER)
10865: IS
10866: SELECT ACTUAL_START_DATE,

Line 10869: FROM AHL_WORKORDER_OPERATIONS

10865: IS
10866: SELECT ACTUAL_START_DATE,
10867: ACTUAL_END_DATE,
10868: WORKORDER_OPERATION_ID
10869: FROM AHL_WORKORDER_OPERATIONS
10870: WHERE WORKORDER_ID = x_workorder_id
10871: AND OPERATION_SEQUENCE_NUM = x_operation_seq_num;
10872:
10873: BEGIN

Line 10933: FROM AHL_WORKORDER_OPERATIONS

10929: CURSOR c_get_wo_actual_dates(x_workorder_id NUMBER)
10930: IS
10931: SELECT MIN(ACTUAL_START_DATE),
10932: MAX(ACTUAL_END_DATE)
10933: FROM AHL_WORKORDER_OPERATIONS
10934: WHERE WORKORDER_ID = x_workorder_id;
10935:
10936: CURSOR c_get_mwo_flag(x_workorder_id NUMBER)
10937: IS

Line 11870: SELECT 'x' from ahl_workorder_operations

11866:
11867:
11868: CURSOR all_operations_comp_csr(p_workorder_id IN NUMBER, p_status_code IN
11869: VARCHAR2) IS
11870: SELECT 'x' from ahl_workorder_operations
11871: WHERE status_code = p_status_code
11872: AND workorder_id = p_workorder_id
11873: AND rownum < 2;
11874: l_junk VARCHAR2(1);