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

Line 91: -- inventory item id is from the Ahl Schedule Materials table

87: l_create_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
88: l_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
89:
90: -- To fetch the instance details when you have the inventory item id, serial number and the organization id
91: -- inventory item id is from the Ahl Schedule Materials table
92: -- organization id from the Ahl Schedule Materials table
93: CURSOR get_instance_dtls_csr (c_inventory_itme_id IN NUMBER,
94: c_serial_number IN VARCHAR2,
95: c_organization_id IN NUMBER)

Line 92: -- organization id from the Ahl Schedule Materials table

88: l_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
89:
90: -- To fetch the instance details when you have the inventory item id, serial number and the organization id
91: -- inventory item id is from the Ahl Schedule Materials table
92: -- organization id from the Ahl Schedule Materials table
93: CURSOR get_instance_dtls_csr (c_inventory_itme_id IN NUMBER,
94: c_serial_number IN VARCHAR2,
95: c_organization_id IN NUMBER)
96: IS

Line 121: FROM mtl_reservations mrsv,ahl_schedule_materials asmt

117: /**
118: CURSOR get_reservation_csr (c_scheduled_material_id IN NUMBER, c_subinventory_code IN VARCHAR2)
119: IS
120: SELECT mrsv.reservation_id, mrsv.primary_reservation_quantity
121: FROM mtl_reservations mrsv,ahl_schedule_materials asmt
122: WHERE mrsv.demand_source_line_detail = c_scheduled_material_id
123: AND external_source_code = 'AHL'
124: AND subinventory_code = c_subinventory_code
125: AND mrsv.demand_source_line_detail = asmt.scheduled_material_id

Line 536: FROM ahl_schedule_materials asmt

532: -- Declare cursors
533: CURSOR get_mtl_req_dtls_csr (c_scheduled_material_id IN NUMBER)
534: IS
535: SELECT asmt.requested_date
536: FROM ahl_schedule_materials asmt
537: WHERE asmt.scheduled_material_id = c_scheduled_material_id;
538:
539: CURSOR get_reservation_csr (c_scheduled_material_id IN NUMBER)
540: IS

Line 542: FROM mtl_reservations mrsv,ahl_schedule_materials asmt

538:
539: CURSOR get_reservation_csr (c_scheduled_material_id IN NUMBER)
540: IS
541: SELECT reservation_id
542: FROM mtl_reservations mrsv,ahl_schedule_materials asmt
543: WHERE mrsv.demand_source_line_detail = c_scheduled_material_id
544: AND mrsv.demand_source_line_detail = asmt.scheduled_material_id
545: AND mrsv.organization_id = asmt.organization_id
546: AND mrsv.requirement_date = asmt.requested_date

Line 865: FROM ahl_schedule_materials asmt

861: -- Declare cursors
862: /*CURSOR get_mtl_req_dtls_csr (c_scheduled_material_id IN NUMBER)
863: IS
864: SELECT 1
865: FROM ahl_schedule_materials asmt
866: WHERE asmt.scheduled_material_id = c_scheduled_material_id;
867: */
868:
869: -- AnRaj: Added a join with ahl_schedule_materials and further where conditions to remove the FTS

Line 869: -- AnRaj: Added a join with ahl_schedule_materials and further where conditions to remove the FTS

865: FROM ahl_schedule_materials asmt
866: WHERE asmt.scheduled_material_id = c_scheduled_material_id;
867: */
868:
869: -- AnRaj: Added a join with ahl_schedule_materials and further where conditions to remove the FTS
870: -- on mtl_reservations
871: CURSOR get_reservation_csr (c_scheduled_material_id IN NUMBER, c_subinventory_code IN VARCHAR2)
872: IS
873: SELECT reservation_id

Line 874: FROM mtl_reservations mrsv,ahl_schedule_materials asmt

870: -- on mtl_reservations
871: CURSOR get_reservation_csr (c_scheduled_material_id IN NUMBER, c_subinventory_code IN VARCHAR2)
872: IS
873: SELECT reservation_id
874: FROM mtl_reservations mrsv,ahl_schedule_materials asmt
875: WHERE mrsv.demand_source_line_detail = c_scheduled_material_id
876: AND mrsv.external_source_code = 'AHL'
877: AND (c_subinventory_code IS NULL OR mrsv.subinventory_code = c_subinventory_code)
878: AND mrsv.demand_source_line_detail = asmt.scheduled_material_id

Line 938: FROM ahl_schedule_materials

934: -- validate whehther the scheduled material id is valid
935: BEGIN
936: SELECT 1
937: INTO l_temp
938: FROM ahl_schedule_materials
939: WHERE scheduled_material_id = p_scheduled_material_id;
940: EXCEPTION
941: WHEN NO_DATA_FOUND THEN
942: FND_MESSAGE.Set_Name('AHL','AHL_RSV_INVLD_MAT_REQ');

Line 1225: FROM ahl_schedule_materials asmt,

1221: asmt.uom,
1222: asmt.requested_quantity,
1223: asmt.inventory_item_id,
1224: asmt.object_version_number
1225: FROM ahl_schedule_materials asmt,
1226: ahl_visit_tasks_b avtl
1227: WHERE asmt.status = 'ACTIVE'
1228: AND asmt.requested_quantity <>0
1229: AND asmt.scheduled_material_id = c_scheduled_material_id

Line 1250: FROM mtl_reservations mrsv,ahl_schedule_materials asmt

1246: /**
1247: CURSOR get_reservation_csr (c_scheduled_material_id IN NUMBER, c_SUBINVENTORY_CODE IN VARCHAR2)
1248: IS
1249: SELECT reservation_id, primary_reservation_quantity
1250: FROM mtl_reservations mrsv,ahl_schedule_materials asmt
1251: WHERE mrsv.demand_source_line_detail = c_scheduled_material_id
1252: AND mrsv.external_source_code = 'AHL'
1253: AND mrsv.SUBINVENTORY_CODE = c_SUBINVENTORY_CODE
1254: AND mrsv.demand_source_line_detail = asmt.scheduled_material_id

Line 1596: FROM ahl_schedule_materials mat,

1592: -- Declare Cursors and local record types
1593: CURSOR get_mtl_req_dtls_csr (c_visit_id IN NUMBER)
1594: IS
1595: SELECT mat.visit_task_id, mat.scheduled_material_id, mat.workorder_operation_id, mat.operation_sequence
1596: FROM ahl_schedule_materials mat,
1597: ahl_visit_tasks_b vt
1598: WHERE mat.status = 'ACTIVE'
1599: AND mat.requested_quantity <>0
1600: AND vt.status_code = 'PLANNING'

Line 1605: -- AnRaj: Added a join with ahl_schedule_materials and further where conditions to remove the FTS

1601: AND vt.visit_task_id = mat.visit_task_id
1602: AND vt.visit_id = c_visit_ID;
1603: l_get_mtl_req_dtls_rec get_mtl_req_dtls_csr%ROWTYPE;
1604:
1605: -- AnRaj: Added a join with ahl_schedule_materials and further where conditions to remove the FTS
1606: CURSOR get_reservation_csr (c_scheduled_material_id IN NUMBER)
1607: IS
1608: SELECT reservation_id
1609: FROM mtl_reservations mrsv,ahl_schedule_materials asmt

Line 1609: FROM mtl_reservations mrsv,ahl_schedule_materials asmt

1605: -- AnRaj: Added a join with ahl_schedule_materials and further where conditions to remove the FTS
1606: CURSOR get_reservation_csr (c_scheduled_material_id IN NUMBER)
1607: IS
1608: SELECT reservation_id
1609: FROM mtl_reservations mrsv,ahl_schedule_materials asmt
1610: WHERE demand_source_line_detail = c_scheduled_material_id
1611: AND external_source_code = 'AHL'
1612: AND mrsv.demand_source_line_detail = asmt.scheduled_material_id
1613: AND mrsv.organization_id = asmt.organization_id

Line 1876: FROM ahl_schedule_materials asmt,

1872: -- Get the all the reservation related information using the schedule material id
1873: CURSOR get_upd_rsv_csr (c_visit_id IN NUMBER)
1874: IS
1875: SELECT mrsv.reservation_id, mrsv.demand_source_header_id, mrsv.demand_source_line_id, mrsv.inventory_item_id,mrsv.organization_id
1876: FROM ahl_schedule_materials asmt,
1877: ahl_visit_tasks_b vt,
1878: mtl_reservations mrsv
1879: WHERE vt.status_code = 'PLANNING'
1880: AND vt.visit_task_id = asmt.visit_task_id

Line 1893: FROM ahl_schedule_materials

1889: -- get the material requiremnt id and the date
1890: CURSOR get_mtl_req_id_csr (c_visit_task_id IN NUMBER, c_rt_oper_material_id IN NUMBER, c_inventory_item_id IN NUMBER)
1891: IS
1892: SELECT scheduled_material_id, requested_date
1893: FROM ahl_schedule_materials
1894: WHERE visit_task_id = c_visit_task_id
1895: AND rt_oper_material_id = c_rt_oper_material_id
1896: AND inventory_item_id = c_inventory_item_id
1897: AND status = 'ACTIVE';

Line 1982: 'No record found in ahl schedule materials for get_mtl_req_id_csr'

1978: fnd_log.string
1979: (
1980: fnd_log.level_error,
1981: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
1982: 'No record found in ahl schedule materials for get_mtl_req_id_csr'
1983: );
1984: END IF;
1985: CLOSE get_upd_rsv_csr;
1986: CLOSE get_mtl_req_id_csr;

Line 2165: FROM ahl_schedule_materials asmt,

2161: --
2162: CURSOR get_del_rsv_csr (c_visit_id IN NUMBER)
2163: IS
2164: SELECT mrsv.reservation_id
2165: FROM ahl_schedule_materials asmt,
2166: ahl_visit_tasks_b avt,
2167: mtl_reservations mrsv
2168: WHERE avt.status_code in ( 'PLANNING','DELETED')
2169: AND avt.visit_task_id = asmt.visit_task_id

Line 2282: FROM ahl_schedule_materials mat,

2278: mat.requested_date, mat.uom, mat.inventory_item_id,
2279: mat. workorder_operation_id, vt.status_code task_status_code,
2280: vt.visit_task_number, v.visit_number, mat.operation_sequence,
2281: mat.visit_task_id, mat.rt_oper_material_id
2282: FROM ahl_schedule_materials mat,
2283: ahl_visits_b v,
2284: ahl_visit_tasks_b vt
2285: WHERE vt.visit_task_id = mat.visit_task_id
2286: AND vt.visit_id = v.visit_id

Line 2688: FROM mtl_reservations mrsv, ahl_schedule_materials asmt, mtl_serial_numbers msn

2684: l_debug_module CONSTANT VARCHAR2(100) := 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name;
2685:
2686: CURSOR get_reservation_csr IS
2687: SELECT mrsv.reservation_id, mrsv.primary_reservation_quantity
2688: FROM mtl_reservations mrsv, ahl_schedule_materials asmt, mtl_serial_numbers msn
2689: WHERE mrsv.demand_source_line_detail = p_scheduled_material_id
2690: AND mrsv.external_source_code = 'AHL'
2691: AND msn.serial_number = p_serial_number
2692: AND mrsv.organization_id = msn.current_organization_id