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_PP_MATERIALS_PVT dependencies on AHL_SCHEDULE_MATERIALS

Line 424: INSERT INTO AHL_SCHEDULE_MATERIALS (

420: X_LAST_UPDATED_BY IN NUMBER,
421: X_LAST_UPDATE_LOGIN IN NUMBER
422: ) IS
423: BEGIN
424: INSERT INTO AHL_SCHEDULE_MATERIALS (
425: SCHEDULED_MATERIAL_ID,
426: OBJECT_VERSION_NUMBER,
427: LAST_UPDATE_DATE,
428: LAST_UPDATED_BY,

Line 575: UPDATE AHL_SCHEDULE_MATERIALS SET

571: X_LAST_UPDATED_BY IN NUMBER,
572: X_LAST_UPDATE_LOGIN IN NUMBER
573: ) IS
574: BEGIN
575: UPDATE AHL_SCHEDULE_MATERIALS SET
576: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER + 1,
577: INVENTORY_ITEM_ID = X_INVENTORY_ITEM_ID,
578: SCHEDULE_DESIGNATOR = X_SCHEDULE_DESIGNATOR,
579: VISIT_ID = X_VISIT_ID,

Line 631: DELETE FROM AHL_SCHEDULE_MATERIALS

627: PROCEDURE DELETE_ROW (
628: X_SCHEDULED_MATERIAL_ID IN NUMBER
629: ) IS
630: BEGIN
631: DELETE FROM AHL_SCHEDULE_MATERIALS
632: WHERE SCHEDULED_MATERIAL_ID = X_SCHEDULED_MATERIAL_ID;
633: END DELETE_ROW;
634: --
635: -- Start of Comments --

Line 686: FROM AHL_SCHEDULE_MATERIALS

682: c_org_id IN NUMBER,
683: c_sequence_id IN NUMBER)
684: IS
685: SELECT 1
686: FROM AHL_SCHEDULE_MATERIALS
687: WHERE inventory_item_id = c_item_id
688: AND workorder_operation_id = c_operation_id
689: AND organization_id = c_org_id
690: AND operation_sequence = c_sequence_id

Line 718: FROM ahl_schedule_materials

714: CURSOR Get_rt_mat_cur (c_visit_task_id IN NUMBER,
715: c_rt_oper_mat_id IN NUMBER)
716: IS
717: SELECT *
718: FROM ahl_schedule_materials
719: WHERE rt_oper_material_id = c_rt_oper_mat_id
720: AND visit_task_id = c_visit_task_id
721: AND requested_quantity <> 0
722: AND status IN ('ACTIVE','IN-SERVICE');

Line 1604: SELECT ahl_schedule_materials_s.NEXTVAL

1600: l_Req_Material_Tbl(i).attribute15 := p_x_req_material_tbl(i).attribute15;
1601: END IF;
1602: --
1603: -- Get Sequence Number for schedule material ID
1604: SELECT ahl_schedule_materials_s.NEXTVAL
1605: INTO l_schedule_material_id FROM DUAL;
1606: --
1607: --
1608: IF G_DEBUG='Y' THEN

Line 1642: -- UPDATE ahl schedule materials table with operation id, operation sequence

1638: IF ( l_material_rec.scheduled_material_id IS NOT NULL
1639: --Adithya added for FP Bug# 6366740
1640: AND p_x_req_material_tbl(i).workorder_operation_id = l_material_rec.workorder_operation_id )
1641: THEN
1642: -- UPDATE ahl schedule materials table with operation id, operation sequence
1643: UPDATE ahl_schedule_materials
1644: SET workorder_operation_id = p_x_req_material_tbl(i).workorder_operation_id,
1645: operation_code = p_x_req_material_tbl(i).operation_code,
1646: operation_sequence = p_x_req_material_tbl(i).operation_sequence,

Line 1643: UPDATE ahl_schedule_materials

1639: --Adithya added for FP Bug# 6366740
1640: AND p_x_req_material_tbl(i).workorder_operation_id = l_material_rec.workorder_operation_id )
1641: THEN
1642: -- UPDATE ahl schedule materials table with operation id, operation sequence
1643: UPDATE ahl_schedule_materials
1644: SET workorder_operation_id = p_x_req_material_tbl(i).workorder_operation_id,
1645: operation_code = p_x_req_material_tbl(i).operation_code,
1646: operation_sequence = p_x_req_material_tbl(i).operation_sequence,
1647: object_version_number =l_material_rec.object_version_number +1

Line 2080: FROM AHL_SCHEDULE_MATERIALS A,

2076: A.attribute14,
2077: A.attribute15,
2078: A.completed_quantity,
2079: A.requested_date old_requested_date -- added to fix bug# 5182334.
2080: FROM AHL_SCHEDULE_MATERIALS A,
2081: AHL_JOB_OPER_MATERIALS_V B, WIP_OPERATIONS WO
2082: WHERE A.SCHEDULED_MATERIAL_ID = B.SCHEDULED_MATERIAL_ID
2083: AND B.WIP_ENTITY_ID = WO.WIP_ENTITY_ID
2084: AND B.OPERATION_SEQUENCE = WO.OPERATION_SEQ_NUM

Line 2725: UPDATE AHL_SCHEDULE_MATERIALS

2721: l_req_material_rec.attribute15 := NULL;
2722: END IF;
2723: --
2724: --Update schedule material table
2725: UPDATE AHL_SCHEDULE_MATERIALS
2726: SET inventory_item_id = l_req_material_rec.inventory_item_id,
2727: -- AnRaj: truncating Requested Date for Material Requirement based on discussions with PM
2728: requested_date = trunc(l_req_material_rec.requested_date),
2729: requested_quantity = l_req_material_rec.requested_quantity,

Line 2941: FROM AHL_SCHEDULE_MATERIALS A,

2937: B.rt_oper_material_id,
2938: B.department_id,
2939: B.workorder_name,
2940: B.wip_entity_id
2941: FROM AHL_SCHEDULE_MATERIALS A,
2942: AHL_JOB_OPER_MATERIALS_V B
2943: WHERE A.SCHEDULED_MATERIAL_ID = B.SCHEDULED_MATERIAL_ID
2944: AND A.SCHEDULED_MATERIAL_ID = c_schedule_material_id;
2945: */

Line 2970: AHL_SCHEDULE_MATERIALS ASML,

2966: AWOS.workorder_name,
2967: AWOS.wip_entity_id
2968: FROM
2969: AHL_WORKORDERS AWOS,
2970: AHL_SCHEDULE_MATERIALS ASML,
2971: wip_requirement_operations wipr,
2972: MTL_SYSTEM_ITEMS_VL MSIV,
2973: AHL_VISITS_VL AVST,
2974: AHL_WORKORDER_OPERATIONS AWOP,

Line 3128: FROM ahl_schedule_materials

3124: p_x_req_material_tbl(i).object_version_number <> FND_API.G_MISS_NUM) THEN
3125: --
3126: SELECT object_version_number,requested_quantity INTO l_object_version_number,
3127: p_x_req_material_tbl(i).requested_quantity
3128: FROM ahl_schedule_materials
3129: WHERE scheduled_material_id = p_x_req_material_tbl(i).schedule_material_id
3130: FOR UPDATE OF STATUS NOWAIT;
3131: --
3132: IF p_x_req_material_tbl(i).object_version_number <> l_object_version_number THEN

Line 3259: UPDATE AHL_SCHEDULE_MATERIALS

3255: LOOP
3256: -- If schedule date is not null then update to zero because collection has been done
3257: IF p_x_req_material_tbl(i).schedule_material_id IS NOT NULL THEN
3258: -- Update schedule materials table requested quantity to zero
3259: UPDATE AHL_SCHEDULE_MATERIALS
3260: SET requested_quantity = 0,
3261: status = 'DELETED',
3262: object_version_number = p_x_req_material_tbl(i).object_version_number + 1
3263: WHERE SCHEDULED_MATERIAL_ID = p_x_req_material_tbl(i).schedule_material_id;

Line 3613: FROM ahl_schedule_materials

3609: CURSOR Check_material_cur (c_schedule_material_id IN NUMBER)
3610: IS
3611: SELECT scheduled_material_id,
3612: rt_oper_material_id
3613: FROM ahl_schedule_materials
3614: WHERE scheduled_material_id = c_schedule_material_id;
3615: --
3616: CURSOR Get_item_cur(c_segments IN VARCHAR2)
3617: IS

Line 3660: FROM ahl_schedule_materials

3656: CURSOR Check_material_cur (c_schedule_material_id IN NUMBER)
3657: IS
3658: SELECT scheduled_material_id,
3659: rt_oper_material_id,requested_quantity
3660: FROM ahl_schedule_materials
3661: WHERE scheduled_material_id = c_schedule_material_id;
3662: --
3663: CURSOR Get_item_cur(c_segments IN VARCHAR2)
3664: IS

Line 4081: FROM AHL_SCHEDULE_MATERIALS ASM,

4077: ASM.relationship_id,
4078: ASM.mr_route_id,
4079: ASM.material_request_type,
4080: ASM.status
4081: FROM AHL_SCHEDULE_MATERIALS ASM,
4082: AHL_RT_OPER_MATERIALS ARM
4083: WHERE ASM.rt_oper_material_id = ARM.RT_OPER_MATERIAL_ID
4084: AND ASM.visit_task_id = C_VISIT_TASK_ID
4085: AND ASM.requested_quantity > 0

Line 4102: FROM AHL_SCHEDULE_MATERIALS

4098: CURSOR Material_Detail_Cur (c_operation_id IN NUMBER,
4099: c_operation_sequence IN NUMBER)
4100: IS
4101: SELECT Scheduled_material_id
4102: FROM AHL_SCHEDULE_MATERIALS
4103: WHERE WORKORDER_OPERATION_ID = c_operation_id
4104: AND OPERATION_SEQUENCE = c_operation_sequence;
4105:
4106: l_api_name CONSTANT VARCHAR2(30) := 'PROCESS_WO_OP_MATERIALS';

Line 4236: UPDATE ahl_schedule_materials

4232: --l_req_material_tbl(l_idx).mrp_net_flag := 1;
4233: l_req_material_tbl(l_idx).mrp_net_flag := 2;
4234:
4235: -- Update with workorder operation details
4236: UPDATE ahl_schedule_materials
4237: SET workorder_operation_id = l_prd_wooperation_tbl(i).workorder_operation_id,
4238: operation_sequence = l_prd_wooperation_tbl(i).operation_sequence_num,
4239: -- AnRaj: truncating Requested Date for Material Requirement based on discussions with PM
4240: requested_date = trunc(l_prd_wooperation_tbl(i).scheduled_start_date),

Line 4304: UPDATE ahl_schedule_materials

4300: l_req_material_tbl(l_idx).attribute13 := dff_default_values.attribute13;
4301: l_req_material_tbl(l_idx).attribute14 := dff_default_values.attribute14;
4302: l_req_material_tbl(l_idx).attribute15 := dff_default_values.attribute15;
4303: --Update with operation details
4304: UPDATE ahl_schedule_materials
4305: SET workorder_operation_id = l_prd_wooperation_tbl(i).workorder_operation_id,
4306: object_version_number = object_version_number + 1,
4307: -- AnRaj: truncating Requested Date for Material Requirement based on discussions with PM
4308: requested_date = trunc(l_prd_wooperation_tbl(i).scheduled_start_date),

Line 4397: UPDATE ahl_schedule_materials

4393: FETCH Material_Detail_Cur INTO l_scheduled_material_id;
4394: EXIT WHEN Material_Detail_Cur%NOTFOUND;
4395: IF l_scheduled_material_id IS NOT NULL THEN
4396: --
4397: UPDATE ahl_schedule_materials
4398: -- AnRaj: truncating Requested Date for Material Requirement based on discussions with PM
4399: SET requested_date = trunc(l_prd_wooperation_tbl(i).actual_start_date),
4400: object_version_number = object_version_number + 1,
4401: last_update_date = sysdate,