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

602:
603: CURSOR get_ahl_txn_rec( c_workorder_id NUMBER )
604: IS
605: SELECT MAX ( TXN.creation_date )
606: FROM AHL_WORKORDER_MTL_TXNS TXN, AHL_WORKORDER_OPERATIONS OP
607: WHERE TXN.workorder_operation_id = OP.workorder_operation_id
608: AND OP.workorder_id = c_workorder_id;
609: BEGIN
610:

Line 1358: UPDATE AHL_WORKORDER_OPERATIONS

1354: IS
1355: l_return_status VARCHAR2(1);
1356: BEGIN
1357:
1358: UPDATE AHL_WORKORDER_OPERATIONS
1359: SET status_code = G_OP_STATUS_COMPLETE,
1360: object_version_number = object_version_number + 1,
1361: last_update_date = SYSDATE,
1362: last_updated_by = FND_GLOBAL.user_id,

Line 1401: FROM AHL_WORKORDER_OPERATIONS_V

1397: actual_start_date,
1398: actual_end_date,
1399: status_code,
1400: status
1401: FROM AHL_WORKORDER_OPERATIONS_V
1402: WHERE workorder_id = c_workorder_id;
1403:
1404: BEGIN
1405:

Line 2729: FROM AHL_WORKORDER_OPERATIONS

2725: SELECT workorder_id,
2726: Operation_sequence_num,
2727: Actual_start_date,
2728: Actual_end_date
2729: FROM AHL_WORKORDER_OPERATIONS
2730: WHERE workorder_operation_id = x_wo_op_id;
2731:
2732: -- R12
2733: -- Tech UIs

Line 2808: UPDATE AHL_WORKORDER_OPERATIONS

2804: END IF;
2805:
2806: -- update the actual dates in the table
2807: IF l_actual_start_date IS NULL THEN
2808: UPDATE AHL_WORKORDER_OPERATIONS
2809: SET ACTUAL_START_DATE = l_operation_tbl(1).actual_start_date,
2810: LAST_UPDATE_DATE = SYSDATE,
2811: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
2812: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

Line 2821: UPDATE AHL_WORKORDER_OPERATIONS

2817: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2818: END IF;
2819: END IF; -- IF l_actual_start_date IS NULL THEN
2820: IF l_actual_end_date IS NULL THEN
2821: UPDATE AHL_WORKORDER_OPERATIONS
2822: SET ACTUAL_END_DATE = l_operation_tbl(1).actual_end_date,
2823: LAST_UPDATE_DATE = SYSDATE,
2824: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
2825: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

Line 5726: FROM AHL_WORKORDER_OPERATIONS WOP,

5722: WOP.actual_end_date actual_end_date,
5723: WOP.status_code status_code,
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

Line 5775: FROM AHL_WORKORDER_OPERATIONS WOP,

5771: WOP.actual_end_date actual_end_date,
5772: WOP.status_code status_code,
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

Line 5814: AHL_WORKORDER_OPERATIONS WOP,

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

Line 5859: AHL_WORKORDER_OPERATIONS WOP,

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

Line 7193: UPDATE AHL_WORKORDER_OPERATIONS

7189: THEN
7190:
7191: IF ( l_operation_tbl.COUNT > 0 ) THEN
7192: FOR i IN l_operation_tbl.FIRST..l_operation_tbl.LAST LOOP
7193: UPDATE AHL_WORKORDER_OPERATIONS
7194: SET object_version_number = object_version_number + 1,
7195: actual_start_date = l_operation_tbl(i).actual_start_date,
7196: actual_end_date = l_operation_tbl(i).actual_end_date,
7197: LAST_UPDATE_DATE = SYSDATE,

Line 7932: FROM AHL_WORKORDER_OPERATIONS WOP,

7928: WOP.actual_end_date actual_end_date,
7929: WOP.status_code status_code,
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

Line 7966: AHL_WORKORDER_OPERATIONS WOP,

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

Line 9042: UPDATE AHL_WORKORDER_OPERATIONS

9038: --AND p_close_visit_rec.default_actual_dates_flag = 'N'
9039:
9040: IF ( l_operation_tbl.COUNT > 0 ) THEN
9041: FOR i IN l_operation_tbl.FIRST..l_operation_tbl.LAST LOOP
9042: UPDATE AHL_WORKORDER_OPERATIONS
9043: SET object_version_number = object_version_number + 1,
9044: actual_start_date = l_operation_tbl(i).actual_start_date,
9045: actual_end_date = l_operation_tbl(i).actual_end_date,
9046: LAST_UPDATE_DATE = SYSDATE,

Line 9560: AHL_WORKORDER_OPERATIONS

9556: IS
9557: SELECT
9558: workorder_operation_id
9559: FROM
9560: AHL_WORKORDER_OPERATIONS
9561: WHERE
9562: workorder_id = p_workorder_id AND
9563: operation_sequence_num = p_op_seq_no;
9564:

Line 9628: FROM AHL_WORKORDER_OPERATIONS WOP,

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

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

9895: L_max_pending_txn_date DATE;
9896: l_start_date DATE;
9897: l_end_date DATE;
9898:
9899: -- cursor to retrieve the relevant operation details from AHL_WORKORDER_OPERATIONS table
9900: CURSOR c_get_op_details(x_workorder_id NUMBER,
9901: x_operation_seq_num NUMBER)
9902: IS
9903: SELECT WORKORDER_OPERATION_ID,

Line 9909: FROM AHL_WORKORDER_OPERATIONS_V

9905: SCHEDULED_START_DATE,
9906: SCHEDULED_END_DATE,
9907: ACTUAL_START_DATE,
9908: ACTUAL_END_DATE
9909: FROM AHL_WORKORDER_OPERATIONS_V
9910: WHERE WORKORDER_ID = x_workorder_id
9911: AND OPERATION_SEQUENCE_NUM = x_operation_seq_num;
9912:
9913: -- cursor to retrieve the wip_entity_id

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

10055: p_x_operation_tbl IN OUT NOCOPY AHL_COMPLETIONS_PVT.operation_tbl_type
10056: )
10057: IS
10058:
10059: -- cursor to retrieve the relevant operation details from AHL_WORKORDER_OPERATIONS table
10060: CURSOR c_get_op_details(x_workorder_id NUMBER,
10061: x_operation_seq_num NUMBER)
10062: IS
10063: SELECT ACTUAL_START_DATE,

Line 10066: FROM AHL_WORKORDER_OPERATIONS

10062: IS
10063: SELECT ACTUAL_START_DATE,
10064: ACTUAL_END_DATE,
10065: WORKORDER_OPERATION_ID
10066: FROM AHL_WORKORDER_OPERATIONS
10067: WHERE WORKORDER_ID = x_workorder_id
10068: AND OPERATION_SEQUENCE_NUM = x_operation_seq_num;
10069:
10070: BEGIN

Line 10130: FROM AHL_WORKORDER_OPERATIONS

10126: CURSOR c_get_wo_actual_dates(x_workorder_id NUMBER)
10127: IS
10128: SELECT MIN(ACTUAL_START_DATE),
10129: MAX(ACTUAL_END_DATE)
10130: FROM AHL_WORKORDER_OPERATIONS
10131: WHERE WORKORDER_ID = x_workorder_id;
10132:
10133: CURSOR c_get_mwo_flag(x_workorder_id NUMBER)
10134: IS

Line 11015: SELECT 'x' from ahl_workorder_operations

11011:
11012:
11013: CURSOR all_operations_comp_csr(p_workorder_id IN NUMBER, p_status_code IN
11014: VARCHAR2) IS
11015: SELECT 'x' from ahl_workorder_operations
11016: WHERE status_code = p_status_code
11017: AND workorder_id = p_workorder_id
11018: AND rownum < 2;
11019: l_junk VARCHAR2(1);