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_RECOVERY_EXTRACT_PKG dependencies on PN_REC_ARCL_DTL_ALL

Line 1015: pn_rec_arcl_dtl_all hdr,

1011: hdr.area_class_dtl_id,
1012: hdr.status,
1013: setup.area_class_name
1014: FROM pn_rec_arcl_dtlln_all dtl,
1015: pn_rec_arcl_dtl_all hdr,
1016: pn_rec_arcl_all setup
1017: WHERE dtl.area_class_dtl_id (+) = hdr.area_class_dtl_id
1018: AND hdr.area_class_id = p_area_class_id
1019: AND TRUNC(hdr.as_of_date) = TRUNC(fnd_date.canonical_to_date(p_as_of_date))

Line 1026: FROM pn_rec_arcl_dtl_all

1022: AND setup.area_class_id = hdr.area_class_id;
1023:
1024: CURSOR get_prior_cls_dtl_id IS
1025: SELECT area_class_dtl_id
1026: FROM pn_rec_arcl_dtl_all
1027: WHERE from_date < fnd_date.canonical_to_date(p_to_date)
1028: AND to_date <= fnd_date.canonical_to_date(p_to_date)
1029: AND as_of_date < fnd_date.canonical_to_date(p_as_of_date)
1030: AND area_class_id = p_area_class_id