DBA Data[Home] [Help]

APPS.AHL_PP_MATERIALS_PVT dependencies on AHL_VISITS_B

Line 385: FROM ahl_visits_b

381: CURSOR get_org_details_cur(c_visit_id IN NUMBER)
382: IS
383: SELECT organization_id,department_id,
384: project_id
385: FROM ahl_visits_b
386: WHERE visit_id = c_visit_id;
387: --
388: l_visit_id NUMBER;
389: l_department_id NUMBER;

Line 4279: FROM ahl_schedule_materials asm, ahl_workorders wo, ahl_visits_b vst

4275: AND mrv.organization_id = asmt.organization_id
4276: AND mrv.demand_source_line_detail = c_schedule_material_id) reserved_quantity,
4277: wo.workorder_id,
4278: vst.organization_id
4279: FROM ahl_schedule_materials asm, ahl_workorders wo, ahl_visits_b vst
4280: WHERE asm.visit_task_id = wo.visit_task_id
4281: AND vst.visit_id = asm.visit_id
4282: AND scheduled_material_id = c_schedule_material_id;
4283:

Line 5659: ahl_visits_b b

5655: SELECT a.visit_id,
5656: visit_task_id,
5657: organization_id
5658: FROM ahl_workorders A,
5659: ahl_visits_b b
5660: WHERE workorder_id = c_workorder_id
5661: AND a.visit_id = b.visit_id;
5662: CURSOR Material_Detail_Cur (c_operation_id IN NUMBER,
5663: c_operation_sequence IN NUMBER)