DBA Data[Home] [Help]

APPS.AHL_LTP_MTL_REQ_PVT dependencies on AHL_SCHEDULE_MATERIALS

Line 2526: -- Cursor to get the details from ahl_schedule_materials table

2522: x_msg_count OUT NOCOPY NUMBER,
2523: x_msg_data OUT NOCOPY VARCHAR2
2524: ) IS
2525:
2526: -- Cursor to get the details from ahl_schedule_materials table
2527: CURSOR get_asm_req_details_csr(c_asm_id IN NUMBER) IS
2528: SELECT asm.mc_header_id,
2529: asm.position_key,
2530: asm.inventory_item_id,

Line 2537: FROM ahl_schedule_materials asm,

2533: asm.item_group_id,
2534: asm.organization_id,
2535: asm.relationship_id,
2536: vt.instance_id
2537: FROM ahl_schedule_materials asm,
2538: ahl_visit_tasks_b vt
2539: WHERE asm.scheduled_material_id = c_asm_id
2540: AND vt.visit_task_id = asm.visit_task_id;
2541: