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_DISPOSITION_PVT dependencies on AHL_PRD_DISPOSITIONS_B

Line 539: SELECT ahl_prd_dispositions_b_s.NEXTVAL

535: --dbms_output.put_line('Before calling table handler API');
536: --Insert the record into the disposition entity table
537: IF (l_route_mtl_req_tbl.EXISTS(i)) THEN
538: BEGIN
539: SELECT ahl_prd_dispositions_b_s.NEXTVAL
540: INTO l_disposition_id
541: FROM dual;
542: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
543: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 627: SELECT AHL_PRD_DISPOSITIONS_B_H_S.NEXTVAL

623: X_LAST_UPDATED_BY => FND_GLOBAL.user_id,
624: X_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id);
625:
626: --Insert the same record into the Disposition History table as well
627: SELECT AHL_PRD_DISPOSITIONS_B_H_S.NEXTVAL
628: INTO l_disposition_h_id
629: FROM dual;
630: AHL_PRD_DISPOSITIONS_B_H_PKG.INSERT_ROW(
631: X_ROWID => l_dummy_rowid,

Line 630: AHL_PRD_DISPOSITIONS_B_H_PKG.INSERT_ROW(

626: --Insert the same record into the Disposition History table as well
627: SELECT AHL_PRD_DISPOSITIONS_B_H_S.NEXTVAL
628: INTO l_disposition_h_id
629: FROM dual;
630: AHL_PRD_DISPOSITIONS_B_H_PKG.INSERT_ROW(
631: X_ROWID => l_dummy_rowid,
632: X_DISPOSITION_H_ID => l_disposition_h_id,
633: X_DISPOSITION_ID => l_disposition_id,
634: X_OBJECT_VERSION_NUMBER => 1.0,

Line 1106: Select AHL_PRD_DISPOSITIONS_B_S.NEXTVAL into p_x_disposition_rec.disposition_id from dual;

1102:
1103: p_x_disposition_Rec.status_code := l_calculated_status;
1104:
1105: --prepare for insert
1106: Select AHL_PRD_DISPOSITIONS_B_S.NEXTVAL into p_x_disposition_rec.disposition_id from dual;
1107: --setting object version number for create
1108: p_x_disposition_rec.object_version_number := 1;
1109: --setting up user/create/update information
1110: p_x_disposition_rec.created_by := fnd_global.user_id;

Line 1215: UPDATE AHL_PRD_DISPOSITIONS_B SET primary_service_request_id = p_x_disposition_rec.primary_service_request_id,

1211: p_x_disposition_rec.primary_service_request_id := l_primary_service_request_id;
1212: p_x_disposition_rec.non_routine_workorder_id := l_non_routine_workorder_id;
1213:
1214: --update the just modified field without changing object version number.
1215: UPDATE AHL_PRD_DISPOSITIONS_B SET primary_service_request_id = p_x_disposition_rec.primary_service_request_id,
1216: non_routine_workorder_id = p_x_disposition_rec.non_routine_workorder_id,
1217: status_code = p_x_disposition_rec.status_code
1218: WHERE disposition_id = p_x_disposition_rec.disposition_id;
1219: END IF;

Line 1221: Select AHL_PRD_DISPOSITIONS_B_H_S.NEXTVAL into l_disposition_h_id from dual;

1217: status_code = p_x_disposition_rec.status_code
1218: WHERE disposition_id = p_x_disposition_rec.disposition_id;
1219: END IF;
1220:
1221: Select AHL_PRD_DISPOSITIONS_B_H_S.NEXTVAL into l_disposition_h_id from dual;
1222: AHL_PRD_DISPOSITIONS_B_H_PKG.INSERT_ROW(
1223: x_rowid => l_dummy_char,
1224: x_disposition_h_id => l_disposition_h_id,
1225: x_disposition_id => p_x_disposition_rec.disposition_id,

Line 1222: AHL_PRD_DISPOSITIONS_B_H_PKG.INSERT_ROW(

1218: WHERE disposition_id = p_x_disposition_rec.disposition_id;
1219: END IF;
1220:
1221: Select AHL_PRD_DISPOSITIONS_B_H_S.NEXTVAL into l_disposition_h_id from dual;
1222: AHL_PRD_DISPOSITIONS_B_H_PKG.INSERT_ROW(
1223: x_rowid => l_dummy_char,
1224: x_disposition_h_id => l_disposition_h_id,
1225: x_disposition_id => p_x_disposition_rec.disposition_id,
1226: x_object_version_number => p_x_disposition_rec.object_version_number,

Line 1315: UPDATE AHL_PRD_DISPOSITIONS_B

1311: -- SATHAPLI::FP OGMA Issue# 105 - Non-Serialized Item Maintenance, 12-Dec-2007
1312: -- If the part is removed in 'Inspection' condition, then move the disposition to Complete status.
1313: IF (p_x_disposition_rec.condition_id = NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_INSPECTION'), -1) AND
1314: p_x_disposition_rec.part_change_id IS NOT NULL) THEN
1315: UPDATE AHL_PRD_DISPOSITIONS_B
1316: SET status_code = 'COMPLETE'
1317: WHERE disposition_id = p_x_disposition_rec.disposition_id;
1318: END IF;
1319:

Line 2071: Select AHL_PRD_DISPOSITIONS_B_H_S.NEXTVAL into l_disposition_h_id from dual;

2067: --dbms_output.put_line(SubStr('Update_disp: l_disposition_rec.creation_date ' || l_disposition_rec.creation_date, 1, 255));
2068: --dbms_output.put_line(SubStr('Update_disp: l_disposition_rec.created_by ' || l_disposition_rec.created_by, 1, 255));
2069:
2070:
2071: Select AHL_PRD_DISPOSITIONS_B_H_S.NEXTVAL into l_disposition_h_id from dual;
2072: --dbms_output.put_line(SubStr('Update_disp:Before insert into history table', 1, 255));
2073:
2074: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2075: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Before insert into history table');

Line 2077: AHL_PRD_DISPOSITIONS_B_H_PKG.INSERT_ROW(

2073:
2074: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2075: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Before insert into history table');
2076: END IF;
2077: AHL_PRD_DISPOSITIONS_B_H_PKG.INSERT_ROW(
2078: x_rowid => l_dummy_char,
2079: x_disposition_h_id => l_disposition_h_id,
2080: x_disposition_id => p_x_disposition_rec.disposition_id,
2081: x_object_version_number => p_x_disposition_rec.object_version_number,

Line 2819: (SELECT pos2.path_pos_common_id FROM ahl_prd_dispositions_b dis, ahl_mc_path_positions pos2

2815: CURSOR exist_position_csr(p_path_position_id IN NUMBER, p_workorder_id IN NUMBER) IS
2816: SELECT 'X' FROM ahl_mc_path_positions pos
2817: WHERE pos.path_position_id = p_path_position_id
2818: AND EXISTS
2819: (SELECT pos2.path_pos_common_id FROM ahl_prd_dispositions_b dis, ahl_mc_path_positions pos2
2820: WHERE dis.path_position_id IS NOT NULL
2821: AND dis.path_position_id = pos2.path_position_id
2822: AND dis.workorder_id = p_workorder_id
2823: AND nvl(dis.status_code, 'dummy') NOT IN ('COMPLETE', 'TERMINATED')

Line 3872: SELECT 'x' from ahl_prd_dispositions_b WHERE

3868: and csi.location_type_code NOT IN ('PO','IN-TRANSIT','PROJECT','INVENTORY')
3869: and trunc(sysdate) between trunc(nvl(csi.active_start_date, sysdate)) and trunc(nvl(csi.active_end_date, sysdate));
3870:
3871: CURSOR instance_in_disp_csr(p_instance_id IN NUMBER, p_workorder_id IN NUMBER) IS
3872: SELECT 'x' from ahl_prd_dispositions_b WHERE
3873: workorder_id = p_workorder_id
3874: and instance_id = p_instance_id
3875: and nvl(status_code, ' ') NOT IN ('COMPLETE', 'TERMINATED');
3876:

Line 4174: FROM AHL_PRD_DISPOSITIONS_B disp,

4170: pc.return_mtl_txn_id mtl_txn_id,
4171: pc.installed_part_change_id install_pc_id,
4172: pc.part_change_type,
4173: AHL_PRD_DISP_MTL_TXN_PVT.calculate_txned_qty(disp.disposition_id) mtl_txn_qty
4174: FROM AHL_PRD_DISPOSITIONS_B disp,
4175: AHL_PART_CHANGES_V pc
4176: WHERE disp.disposition_id = p_disposition_id
4177: AND disp.part_change_id = pc.part_change_id (+);
4178:

Line 4441: from AHL_PRD_DISPOSITIONS_B B,

4437: B.secondary_disposition_code,
4438: FND2.MEANING SECONDARY_TYPE,
4439: B.part_change_id,
4440: decode(B.instance_id, null, decode(B.path_position_id, null, 'N', 'Y'), 'Y') TRACKABLE_FLAG
4441: from AHL_PRD_DISPOSITIONS_B B,
4442: FND_LOOKUPS FND1,
4443: FND_LOOKUPS FND2,
4444: MTL_MATERIAL_STATUSES_VL COND
4445: where FND1.LOOKUP_TYPE (+) = 'AHL_IMMED_DISP_TYPE'