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

Line 79: FROM ahl_schedule_materials asm,

75: asm.uom,
76: asm.requested_date,
77: asm.status,
78: mtl.concatenated_segments
79: FROM ahl_schedule_materials asm,
80: mtl_system_items_kfv mtl
81: WHERE asm.visit_id = c_visit_id
82: AND mtl.inventory_item_id = asm.inventory_item_id
83: AND mtl.organization_id = asm.organization_id;

Line 168: UPDATE ahl_schedule_materials

164: l_unsched_mtl_tbl(l_unsched_mtl_index).requested_date := l_sch_mtls_Rec.requested_date;
165: l_unsched_mtl_index := l_unsched_mtl_index + 1;
166: END IF;
167: -- End addition by surrkuma on 14-JUL-2010 for bug 9901811
168: UPDATE ahl_schedule_materials
169: SET requested_quantity = 0,
170: status = 'DELETED',
171: object_version_number = l_sch_mtls_Rec.object_version_number + 1,
172: last_update_date = SYSDATE,

Line 258: -- Creates record in ahl_schedule_materials

254: -- PROCEDURE
255: -- Insert_Planned_Matrls
256: --
257: -- PURPOSE
258: -- Creates record in ahl_schedule_materials
259: --
260: -- PARAMETERS
261: --
262: -- NOTES

Line 300: FROM AHL_SCHEDULE_MATERIALS

296: -- yazhou 03-JUL-2006 starts
297: -- bug fix#5303378
298:
299: SELECT scheduled_material_id
300: FROM AHL_SCHEDULE_MATERIALS
301: WHERE visit_id = c_visit_id
302: AND visit_task_id = c_visit_task_id
303: -- AND requested_quantity <> 0
304: AND NVL(status,'') = 'ACTIVE'

Line 406: l_mat_status AHL_SCHEDULE_MATERIALS.STATUS%TYPE; --Added by sowsubra for Issue 105

402: l_task_type_code VARCHAR2(30);
403: l_material_request_type VARCHAR2(30);
404: l_Prior_Item_Rec Get_Prior_Item_Cur%ROWTYPE;
405: l_isInservice AHL_RT_OPER_MATERIALS.IN_SERVICE%TYPE; --Added by sowsubra for Issue 105
406: l_mat_status AHL_SCHEDULE_MATERIALS.STATUS%TYPE; --Added by sowsubra for Issue 105
407: -- SKPATHAK :: Bug 8604722 :: 04-MAR-2010
408: l_default_dff_values dff_default_values_type;
409:
410: L_DEBUG_KEY CONSTANT VARCHAR2(100) := 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name;

Line 434: SELECT ahl_schedule_materials_s.nextval INTO l_schedule_material_id FROM DUAL;

430: 'Request for Create Planned Material for Visit Id: ' || p_visit_id);
431: END IF;
432:
433: --Get the sequence number
434: SELECT ahl_schedule_materials_s.nextval INTO l_schedule_material_id FROM DUAL;
435: --Check for record exists
436: -- Surrkuma on 28-Jul-2011 for handling control position based material requirements
437: OPEN check_matrl_cur(p_visit_id,p_visit_task_id,p_rt_oper_material_id,p_position_key);
438: FETCH check_matrl_cur INTO l_dummy;

Line 581: INSERT INTO AHL_SCHEDULE_MATERIALS

577: -- SURRKUMA :: Service Bulletin :: 07-Jun-2011
578: -- Added MC_ID and POSITION_KEY to the INSERT command
579: -- Insert the record into schedule materials
580: IF (l_dummy IS NULL AND l_inventory_org_item_id IS NOT NULL )THEN
581: INSERT INTO AHL_SCHEDULE_MATERIALS
582: (SCHEDULED_MATERIAL_ID,
583: OBJECT_VERSION_NUMBER,
584: LAST_UPDATE_DATE,
585: LAST_UPDATED_BY,

Line 777: FROM ahl_schedule_materials

773: organization_id,
774: completed_quantity,
775: requested_date,
776: visit_id
777: FROM ahl_schedule_materials
778: WHERE scheduled_material_id = c_sched_mat_id;
779:
780: CURSOR Get_Inv_Item_cur (c_item_desc IN VARCHAR2,
781: c_org_id IN NUMBER)

Line 860: 'Schedule Material id not found in ahl_schedule_materials table'

856: fnd_log.string
857: (
858: l_log_error,
859: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
860: 'Schedule Material id not found in ahl_schedule_materials table'
861: );
862: END IF;
863: CLOSE Get_Planned_Items_cur;
864: RAISE FND_API.G_EXC_ERROR;

Line 914: -- AnRaj: Changed the WHERE and FROM clause adding join with ahl_schedule_materials, for Performance improvement

910: END IF;
911:
912: -- AnRaj: Moved this code down, after the id in l_planned_materials_tbl has been populated
913: -- Serial Number Reservation Enhancement Changes Start.
914: -- AnRaj: Changed the WHERE and FROM clause adding join with ahl_schedule_materials, for Performance improvement
915: IF l_planned_materials_tbl(i).inventory_item_id <> l_Planned_Items_rec.inventory_item_id
916: THEN
917: SELECT SUM(MR.PRIMARY_RESERVATION_QUANTITY)
918: INTO l_rsvd_quantity

Line 920: ahl_schedule_materials SM

916: THEN
917: SELECT SUM(MR.PRIMARY_RESERVATION_QUANTITY)
918: INTO l_rsvd_quantity
919: FROM mtl_reservations MR,
920: ahl_schedule_materials SM
921: WHERE MR.DEMAND_SOURCE_LINE_DETAIL = l_planned_materials_tbl(i).schedule_material_id
922: AND MR.external_source_code = 'AHL'
923: AND MR.demand_source_line_detail = SM.scheduled_material_id
924: AND MR.organization_id = SM.organization_id

Line 956: -- AnRaj: Changed the WHERE and FROM clause adding join with ahl_schedule_materials, for Performance improvement

952: RAISE FND_API.G_EXC_ERROR;
953: END IF;
954:
955: -- Serial Number Reservation Enhancement Changes Starts.
956: -- AnRaj: Changed the WHERE and FROM clause adding join with ahl_schedule_materials, for Performance improvement
957: IF NVL(l_planned_materials_tbl(i).quantity,-9) <> NVL(l_Planned_Items_rec.requested_quantity,-99)
958: THEN
959: SELECT SUM(MR.PRIMARY_RESERVATION_QUANTITY)
960: INTO l_rsvd_quantity

Line 962: ahl_schedule_materials SM

958: THEN
959: SELECT SUM(MR.PRIMARY_RESERVATION_QUANTITY)
960: INTO l_rsvd_quantity
961: FROM mtl_reservations MR,
962: ahl_schedule_materials SM
963: WHERE MR.DEMAND_SOURCE_LINE_DETAIL = l_planned_materials_tbl(i).schedule_material_id
964: AND MR.external_source_code = 'AHL'
965: AND MR.demand_source_line_detail = SM.scheduled_material_id
966: AND MR.organization_id = SM.organization_id

Line 1049: UPDATE ahl_schedule_materials

1045: LOOP
1046: --
1047: IF l_planned_materials_tbl(i).schedule_material_id IS NOT NULL THEN
1048: --
1049: UPDATE ahl_schedule_materials
1050: SET inventory_item_id = l_planned_materials_tbl(i).inventory_item_id,
1051: requested_quantity = l_planned_materials_tbl(i).quantity,
1052: -- AnRaj: truncating Requested Date for Material Requirement based on discussions with PM
1053: requested_date = trunc(l_planned_materials_tbl(i).requested_date),

Line 1560: ahl_schedule_materials asm,

1556: asm.uom,
1557: asm.requested_date,
1558: mtl.concatenated_segments
1559: FROM ahl_visit_tasks_b tsk,
1560: ahl_schedule_materials asm,
1561: mtl_system_items_kfv mtl
1562: WHERE asm.visit_id = C_VISIT_ID
1563: AND asm.visit_task_id = tsk.visit_task_id
1564: AND tsk.status_code ='DELETED'

Line 1583: FROM ahl_schedule_materials asm,

1579: asm.uom,
1580: asm.requested_date,
1581: asm.scheduled_date,
1582: mtl.concatenated_segments
1583: FROM ahl_schedule_materials asm,
1584: mtl_system_items_kfv mtl
1585: WHERE asm.visit_task_id = c_visit_task_id
1586: AND asm.rt_oper_material_id = c_rt_oper_material_id
1587: AND NVL(asm.STATUS, 'X') = 'ACTIVE'

Line 1635: ahl_schedule_materials asm,

1631: CURSOR Item_exists_in_wip_cur(c_scheduled_material_id IN NUMBER)
1632: IS
1633: SELECT 1
1634: FROM wip_requirement_operations wip,
1635: ahl_schedule_materials asm,
1636: ahl_workorders wo
1637: WHERE wo.visit_task_id = asm.visit_task_id
1638: AND wo.wip_entity_id = wip.wip_entity_id
1639: AND asm.operation_sequence = wip.operation_seq_num

Line 1717: UPDATE ahl_schedule_materials

1713: fnd_log.string(fnd_log.level_statement, L_DEBUG_KEY,
1714: 'Updating the status to DELETED for Material Requirement Id ' || l_Deleted_Items_Rec.scheduled_material_id);
1715: END IF;
1716:
1717: UPDATE ahl_schedule_materials
1718: SET requested_quantity =0,
1719: status = 'DELETED',
1720: object_version_number = l_Deleted_Items_Rec.object_version_number + 1
1721: WHERE scheduled_material_id = l_Deleted_Items_Rec.scheduled_material_id ;

Line 1862: UPDATE ahl_schedule_materials

1858: OPEN Item_exists_in_org_Cur(c_item_id => l_route_mtl_req_tbl(j).inventory_item_id, c_org_id => l_visit_org_id);
1859: FETCH Item_exists_in_org_Cur INTO i_x;
1860: IF (Item_exists_in_org_Cur%NOTFOUND) THEN
1861: -- Item is not applicable in the New Org: Flag the ASM record as DELETED
1862: UPDATE ahl_schedule_materials
1863: SET STATUS = 'DELETED',
1864: object_version_number = l_Planned_Items_Rec.object_version_number + 1,
1865: last_update_date = sysdate,
1866: last_updated_by = Fnd_Global.USER_ID,

Line 1884: UPDATE ahl_schedule_materials

1880: l_req_mtl_index := l_req_mtl_index + 1;
1881: ELSE
1882: -- No WIP requirement exists for the record.
1883: -- Update the ASM record with the changed attributes
1884: UPDATE ahl_schedule_materials
1885: SET inventory_item_id = l_route_mtl_req_tbl(j).inventory_item_id,
1886: organization_id = l_visit_org_id,
1887: requested_date = trunc(l_Visit_Task_Route_Tbl(i).task_start_date),
1888: object_version_number = l_Planned_Items_Rec.object_version_number + 1,

Line 1901: 'Updated ahl_schedule_materials for scheduled_material_id = ' || l_Planned_Items_Rec.scheduled_material_id);

1897: CLOSE Item_exists_in_org_Cur;
1898: -- End changes by surrkuma on 15-JUL-2010 for Bug 9901811
1899: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1900: fnd_log.string(fnd_log.level_statement, L_DEBUG_KEY,
1901: 'Updated ahl_schedule_materials for scheduled_material_id = ' || l_Planned_Items_Rec.scheduled_material_id);
1902: END IF;
1903: -- No need to automatically Reschedule or Unschedule for ATP
1904: ELSE
1905: -- No significant changes: No need to update

Line 2129: FROM AHL_SCHEDULE_MATERIALS ASMT,

2125: ASMT.visit_task_id,
2126: ASMT.scheduled_material_id schedule_material_id,
2127: decode(sign( trunc(ASMT.scheduled_date) - trunc(requested_date)), 1, ASMT.scheduled_date, null) SCHEDULED_DATE,
2128: ASMT.SCHEDULED_QUANTITY
2129: FROM AHL_SCHEDULE_MATERIALS ASMT,
2130: AHL_VISIT_TASKS_B VTSK
2131: WHERE ASMT.STATUS <> 'DELETED'
2132: AND EXISTS ( Select 1
2133: from AHL_RT_OPER_MATERIALS RTOM

Line 2672: ahl_schedule_materials asm

2668: asm.uom,
2669: asm.requested_date,
2670: asm.scheduled_date asm_scheduled_date
2671: FROM ahl_visit_task_matrl_v vtm,
2672: ahl_schedule_materials asm
2673: WHERE vtm.visit_task_id = c_visit_task_id
2674: AND asm.scheduled_material_id = vtm.schedule_material_id;
2675:
2676: --Retrieve visit level planned materials

Line 2694: ahl_schedule_materials asm

2690: asm.uom,
2691: asm.requested_date,
2692: asm.scheduled_date asm_scheduled_date
2693: FROM ahl_visit_task_matrl_v vtm,
2694: ahl_schedule_materials asm
2695: WHERE vtm.visit_id = c_visit_id
2696: AND asm.scheduled_material_id = vtm.schedule_material_id;
2697:
2698: --Standard local variables

Line 2781: UPDATE ahl_schedule_materials

2777: l_unsched_mtl_tbl(l_unsched_mtl_index).requested_date := l_visit_task_mtrls_rec.requested_date;
2778: l_unsched_mtl_index := l_unsched_mtl_index + 1;
2779: -- End addition by surrkuma on 15-JUL-2010 for bug 9901811
2780:
2781: UPDATE ahl_schedule_materials
2782: SET requested_quantity = 0,
2783: status = 'DELETED',
2784: object_version_number = l_visit_task_mtrls_rec.object_version_number + 1
2785: WHERE scheduled_material_id = l_visit_task_mtrls_rec.schedule_material_id;

Line 2823: UPDATE ahl_schedule_materials

2819: l_unsched_mtl_tbl(l_unsched_mtl_index).requested_date := l_visit_mtrls_rec.requested_date;
2820: l_unsched_mtl_index := l_unsched_mtl_index + 1;
2821: -- End addition by surrkuma on 15-JUL-2010 for bug 9901811
2822:
2823: UPDATE ahl_schedule_materials
2824: SET requested_quantity = 0,
2825: status = 'DELETED',
2826: object_version_number = l_visit_mtrls_rec.object_version_number + 1
2827: WHERE scheduled_material_id = l_visit_mtrls_rec.schedule_material_id;

Line 2965: FROM ahl_schedule_materials

2961: SELECT visit_id,
2962: visit_task_id,
2963: scheduled_material_id,
2964: object_version_number
2965: FROM ahl_schedule_materials
2966: WHERE visit_id = c_visit_id
2967: AND status = 'ACTIVE';
2968:
2969: --Standard local variables

Line 3012: UPDATE ahl_schedule_materials

3008: LOOP
3009: FETCH visit_mtrls_cur INTO l_visit_mtrls_rec;
3010: EXIT WHEN visit_mtrls_cur%NOTFOUND;
3011: IF l_visit_mtrls_rec.scheduled_material_id IS NOT NULL THEN
3012: UPDATE ahl_schedule_materials
3013: SET STATUS = 'HISTORY',
3014: OBJECT_VERSION_NUMBER = l_visit_mtrls_rec.object_version_number
3015: WHERE scheduled_material_id = l_visit_mtrls_rec.scheduled_material_id;
3016: END IF;

Line 3103: FROM ahl_schedule_materials mat,

3099: IS
3100: -- AnRaj: Changed the WHERE clause , for Performance improvement
3101: CURSOR get_del_mtl_req_csr(c_visit_id IN NUMBER) IS
3102: SELECT mat.scheduled_material_id
3103: FROM ahl_schedule_materials mat,
3104: ahl_visit_tasks_b vt
3105: WHERE vt.visit_id = c_visit_id
3106: AND vt.status_code = 'DELETED'
3107: AND vt.visit_task_id = mat.visit_task_id

Line 3337: UPDATE ahl_Schedule_materials

3333: RAISE Fnd_Api.G_EXC_ERROR;
3334: END IF;
3335:
3336: --Update the status of the record to 'HISTORY'
3337: UPDATE ahl_Schedule_materials
3338: SET STATUS = 'HISTORY',
3339: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
3340: LAST_UPDATE_DATE = sysdate,
3341: LAST_UPDATED_BY = Fnd_Global.USER_ID,

Line 3555: FROM ahl_schedule_materials

3551:
3552: Cursor get_scheduled_mat_detls (c_task_id IN NUMBER, c_item_id IN NUMBER)
3553: IS
3554: SELECT scheduled_material_id, requested_quantity, scheduled_quantity, uom
3555: FROM ahl_schedule_materials
3556: WHERE visit_task_id = c_task_id
3557: AND inventory_item_id = c_item_id
3558: AND status <> 'DELETED';
3559:

Line 3564: FROM ahl_schedule_materials

3560:
3561: Cursor get_scheduled_mat_id (c_task_id IN NUMBER, c_item_id IN NUMBER)
3562: IS
3563: SELECT scheduled_material_id
3564: FROM ahl_schedule_materials
3565: WHERE visit_task_id = c_task_id
3566: AND inventory_item_id = c_item_id
3567: AND status <> 'DELETED';
3568: l_scheduled_material_id NUMBER;

Line 3750: UPDATE ahl_schedule_materials

3746: l_req_material_tbl(i-k).WORKORDER_OPERATION_ID := l_workorder_operation_id;
3747: END IF;
3748: ELSE --get_workorder_detls%FOUND
3749: -- IF the corresponding WO does not exists, update only the ASM table
3750: UPDATE ahl_schedule_materials
3751: SET requested_quantity = requested_quantity + l_prim_quantity,
3752: scheduled_quantity = scheduled_quantity + l_prim_quantity,
3753: object_version_number = object_version_number + 1,
3754: last_update_date = SYSDATE,

Line 4028: FROM ahl_schedule_materials

4024:
4025: Cursor get_scheduled_mat_detls (c_task_id IN NUMBER, c_item_id IN NUMBER)
4026: IS
4027: SELECT scheduled_material_id, requested_quantity, scheduled_quantity, uom
4028: FROM ahl_schedule_materials
4029: WHERE visit_task_id = c_task_id
4030: AND inventory_item_id = c_item_id
4031: AND status <> 'DELETED';
4032: l_scheduled_material_id NUMBER;

Line 4210: UPDATE ahl_schedule_materials

4206: l_req_material_tbl(i-k).WORKORDER_OPERATION_ID := l_workorder_operation_id;
4207: END IF;
4208: ELSE
4209: -- IF the corresponding WO does not exists, update only the ASM table
4210: UPDATE ahl_schedule_materials
4211: SET requested_quantity = l_prim_req_quantity,
4212: scheduled_quantity = l_prim_sch_quantity,
4213: object_version_number = object_version_number + 1,
4214: last_update_date = SYSDATE,

Line 4378: FROM ahl_schedule_materials

4374: -- Cursor to get the materials associated to the default stage task
4375: Cursor get_scheduled_mat_detls (c_task_id IN NUMBER)
4376: IS
4377: SELECT scheduled_material_id, uom,inventory_item_id
4378: FROM ahl_schedule_materials
4379: WHERE visit_task_id = c_task_id
4380: AND status <> 'DELETED';
4381:
4382: -- Cursor to workorder details of the default stage task