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.PN_TENANCIES_PKG dependencies on PN_REC_EXPCL_DTL_ALL

Line 1316: FROM pn_rec_expcl_dtl_all mst,

1312: pn_rec_arcl_dtlln_all dtl
1313: WHERE mst.area_class_dtl_id = dtl.area_class_dtl_id
1314: AND dtl.cust_space_assign_id = spc.cust_space_assign_id) OR
1315: EXISTS (SELECT NULL
1316: FROM pn_rec_expcl_dtl_all mst,
1317: pn_rec_expcl_dtlln_all dtl
1318: WHERE mst.expense_class_dtl_id = dtl.expense_class_dtl_id
1319: AND dtl.cust_space_assign_id = spc.cust_space_assign_id))
1320: );

Line 1337: FROM pn_rec_expcl_dtl_all mst,

1333: WHERE mst.area_class_dtl_id = dtl.area_class_dtl_id
1334: AND mst.status = 'LOCKED'
1335: AND dtl.cust_space_assign_id = spc.cust_space_assign_id) OR
1336: EXISTS (SELECT NULL
1337: FROM pn_rec_expcl_dtl_all mst,
1338: pn_rec_expcl_dtlln_all dtl
1339: WHERE mst.expense_class_dtl_id = dtl.expense_class_dtl_id
1340: AND mst.status = 'LOCKED'
1341: AND dtl.cust_space_assign_id = spc.cust_space_assign_id))