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_SPACE_ASSIGN_PVT dependencies on AHL_SPACE_ASSIGNMENTS_S

Line 197: from ahl_space_assignments SPASSIGN,

193: -- cursor to find spaces whose dates not fall between visit start date and end dates.
194: cursor c_validate_space_dates (vst_id IN NUMBER)
195: IS
196: select SPA.SPACE_NAME SPACE_NAME,VST.start_date_time, start_from, VST.close_date_time, end_to
197: from ahl_space_assignments SPASSIGN,
198: AHL_VISITS_VL VST,ahl_spaces_vl SPA
199: WHERE
200: VST.VISIT_ID = SPASSIGN.VISIT_ID
201: AND SPA.SPACE_ID = SPASSIGN.SPACE_ID

Line 1109: SELECT AHL_SPACE_ASSIGNMENTS_S.NEXTVAL

1105: l_space_assign_rec Space_Assignment_Rec;
1106: --
1107: CURSOR c_seq
1108: IS
1109: SELECT AHL_SPACE_ASSIGNMENTS_S.NEXTVAL
1110: FROM dual;
1111: --
1112: CURSOR c_id_exists (x_id IN NUMBER) IS
1113: SELECT 1

Line 1865: FROM ahl_space_assignments sa,

1861: sp.organization_id sporg_id,
1862: sp.bom_department_id spdept_id,
1863: sa.start_from space_start_date,
1864: sa.end_to space_end_date
1865: FROM ahl_space_assignments sa,
1866: ahl_visits_vl vt,
1867: ahl_spaces_b sp
1868: WHERE sa.visit_id = vt.visit_id
1869: AND sp.space_id = sa.space_id