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.AD_ZD_ADOP dependencies on AD_RELEASES

Line 393: ad_releases ar

389: fnd_nodes fn,
390: FND_OAM_CONTEXT_FILES focf,
391: fnd_product_groups fpg,
392: ad_appl_tops aat,
393: ad_releases ar
394: WHERE focf.NAME not in ('TEMPLATE','METADATA','config.txt') and focf.CTX_TYPE='A' and
395: (focf.status is null or upper(focf.status) in ('S','F')) and
396: EXTRACTVALUE(XMLType(focf.TEXT),'//file_edition_type') = 'run' and
397: focf.node_name=fn.host and

Line 714: AD_RELEASES rel

710: where (snapshot_id, file_id, nvl(containing_file_id, -2)) in
711: (select ou.snapshot_id, ou.file_id, nvl(ou.containing_file_id, -2)
712: from AD_SNAPSHOT_FILES OU, AD_SNAPSHOTS OUASN,
713: AD_APPL_TOPS ouaat, FND_PRODUCT_GROUPS oufpg,
714: AD_RELEASES rel
715: where OU.SNAPSHOT_ID=OUASN.SNAPSHOT_ID
716: and OUASN.SNAPSHOT_TYPE='P'
717: and ouasn.snapshot_name='CURRENT_VIEW'
718: and ouasn.appl_top_id=ouaat.appl_top_id

Line 746: AD_RELEASES rel

742: where (snapshot_id, file_id, nvl(containing_file_id, -2)) in
743: (select ou.snapshot_id, ou.file_id, nvl(ou.containing_file_id, -2)
744: from AD_SNAPSHOT_FILES OU, AD_SNAPSHOTS OUASN,
745: AD_APPL_TOPS ouaat, FND_PRODUCT_GROUPS oufpg,
746: AD_RELEASES rel
747: where OU.SNAPSHOT_ID=OUASN.SNAPSHOT_ID
748: and OUASN.SNAPSHOT_TYPE='Q'
749: and ouasn.snapshot_name='GLOBAL_VIEW'
750: and ouasn.appl_top_id=ouaat.appl_top_id

Line 779: AD_RELEASES rel

775: where (SNAPSHOT_ID, BUGFIX_ID) in
776: (select OU.SNAPSHOT_ID, OU.BUGFIX_ID
777: from AD_SNAPSHOT_BUGFIXES OU, AD_SNAPSHOTS OUASN,
778: AD_APPL_TOPS ouaat, FND_PRODUCT_GROUPS oufpg,
779: AD_RELEASES rel
780: where OU.SNAPSHOT_ID=OUASN.SNAPSHOT_ID
781: and OUASN.SNAPSHOT_TYPE='P'
782: and ouasn.snapshot_name='CURRENT_VIEW'
783: and ouasn.appl_top_id=ouaat.appl_top_id

Line 810: AD_RELEASES rel

806: where (SNAPSHOT_ID, BUGFIX_ID) in
807: (select OU.SNAPSHOT_ID, OU.BUGFIX_ID
808: from AD_SNAPSHOT_BUGFIXES OU, AD_SNAPSHOTS OUASN,
809: AD_APPL_TOPS ouaat, FND_PRODUCT_GROUPS oufpg,
810: AD_RELEASES rel
811: where OU.SNAPSHOT_ID=OUASN.SNAPSHOT_ID
812: and OUASN.SNAPSHOT_TYPE='Q'
813: and ouasn.snapshot_name='GLOBAL_VIEW'
814: and ouasn.appl_top_id=ouaat.appl_top_id

Line 843: AD_RELEASES rel

839: ASF2.FILE_VERSION_ID
840: from AD_SNAPSHOTS ASN1, AD_SNAPSHOT_FILES ASF1,
841: AD_SNAPSHOTS ASN2, AD_SNAPSHOT_FILES ASF2,
842: AD_APPL_TOPS AAT, FND_PRODUCT_GROUPS FPG,
843: AD_RELEASES rel
844: where ASN1.SNAPSHOT_ID=ASF1.SNAPSHOT_ID
845: and ASN2.SNAPSHOT_ID=ASF2.SNAPSHOT_ID
846: and ASN1.SNAPSHOT_TYPE='P'
847: and ASN2.SNAPSHOT_TYPE='C'

Line 874: AD_RELEASES rel

870: ASF2.FILE_VERSION_ID
871: from AD_SNAPSHOTS ASN1, AD_SNAPSHOT_FILES ASF1,
872: AD_SNAPSHOTS ASN2, AD_SNAPSHOT_FILES ASF2,
873: AD_APPL_TOPS AAT, FND_PRODUCT_GROUPS FPG,
874: AD_RELEASES rel
875: where ASN1.SNAPSHOT_ID=ASF1.SNAPSHOT_ID
876: and ASN2.SNAPSHOT_ID=ASF2.SNAPSHOT_ID
877: and ASN1.SNAPSHOT_TYPE='Q'
878: and ASN2.SNAPSHOT_TYPE='G'

Line 933: from ad_snapshot_files ouasf, ad_snapshots ouasn, AD_APPL_TOPS ouaat, FND_PRODUCT_GROUPS oufpg, AD_RELEASES rel, ad_snapshots ouasnpat

929: ouasf.CREATED_BY, ouasf.APPL_TOP_ID, ouasf.INCONSISTENT_FLAG,
930: ouasf.SERVER_TYPE_ADMIN_FLAG, ouasf.SERVER_TYPE_FORMS_FLAG, ouasf.SERVER_TYPE_NODE_FLAG,
931: ouasf.SERVER_TYPE_WEB_FLAG, ouasf.DEST_FILE_ID, ouasf.FILE_TYPE_FLAG,
932: ouasf.IREP_GATHERED_FLAG, ouasf.LAST_PATCHED_DATE
933: from ad_snapshot_files ouasf, ad_snapshots ouasn, AD_APPL_TOPS ouaat, FND_PRODUCT_GROUPS oufpg, AD_RELEASES rel, ad_snapshots ouasnpat
934: where ouasf.SNAPSHOT_ID=OUASN.SNAPSHOT_ID
935: and ouasn.appl_top_id=ouasnpat.appl_top_id
936: and ouasn.release_id=ouasnpat.release_id
937: and ouasnpat.snapshot_type='P'

Line 978: from ad_snapshot_files ouasf, ad_snapshots ouasn, AD_APPL_TOPS ouaat, FND_PRODUCT_GROUPS oufpg, AD_RELEASES rel, ad_snapshots ouasnpat

974: ouasf.CREATED_BY, ouasf.APPL_TOP_ID, ouasf.INCONSISTENT_FLAG,
975: ouasf.SERVER_TYPE_ADMIN_FLAG, ouasf.SERVER_TYPE_FORMS_FLAG, ouasf.SERVER_TYPE_NODE_FLAG,
976: ouasf.SERVER_TYPE_WEB_FLAG, ouasf.DEST_FILE_ID, ouasf.FILE_TYPE_FLAG,
977: ouasf.IREP_GATHERED_FLAG, ouasf.LAST_PATCHED_DATE
978: from ad_snapshot_files ouasf, ad_snapshots ouasn, AD_APPL_TOPS ouaat, FND_PRODUCT_GROUPS oufpg, AD_RELEASES rel, ad_snapshots ouasnpat
979: where ouasf.SNAPSHOT_ID=OUASN.SNAPSHOT_ID
980: and ouasn.appl_top_id=ouasnpat.appl_top_id
981: and ouasn.release_id=ouasnpat.release_id
982: and ouasnpat.snapshot_type='Q'

Line 1164: AD_RELEASES AR,

1160: ASN.SNAPSHOT_TYPE,
1161: AR.RELEASE_ID
1162: FROM AD_APPL_TOPS AAT,
1163: AD_SNAPSHOTS ASN,
1164: AD_RELEASES AR,
1165: FND_PRODUCT_GROUPS FPG,
1166: FND_NODES FN
1167: WHERE AAT.APPL_TOP_TYPE='R'
1168: and aat.active_flag='Y'

Line 1186: AD_RELEASES AR,

1182: ASN.SNAPSHOT_TYPE,
1183: AR.RELEASE_ID
1184: FROM AD_APPL_TOPS AAT,
1185: AD_SNAPSHOTS ASN,
1186: AD_RELEASES AR,
1187: FND_PRODUCT_GROUPS FPG
1188: WHERE AAT.APPL_TOP_TYPE='G'
1189: and aat.active_flag='Y'
1190: and aat.name='GLOBAL'

Line 1218: AD_RELEASES AR,

1214: where snapshot_id in (
1215: select ASN.SNAPSHOT_ID
1216: FROM AD_APPL_TOPS AAT,
1217: AD_SNAPSHOTS ASN,
1218: AD_RELEASES AR,
1219: FND_PRODUCT_GROUPS FPG,
1220: FND_NODES FN
1221: WHERE AAT.APPL_TOP_TYPE='R'
1222: and aat.active_flag='Y'

Line 1236: AD_RELEASES AR,

1232: union
1233: select ASN.SNAPSHOT_ID
1234: FROM AD_APPL_TOPS AAT,
1235: AD_SNAPSHOTS ASN,
1236: AD_RELEASES AR,
1237: FND_PRODUCT_GROUPS FPG
1238: WHERE AAT.APPL_TOP_TYPE='G'
1239: and aat.active_flag='Y'
1240: AND AAT.APPL_TOP_ID=ASN.APPL_TOP_ID

Line 1304: ad_releases ar, fnd_nodes fn

1300: l_appl_top_id number;
1301: cursor nodes is
1302: select distinct fn.host host
1303: from fnd_product_groups fpg, ad_appl_tops aat,
1304: ad_releases ar, fnd_nodes fn
1305: where aat.appl_top_type='R'
1306: and aat.applications_system_name=fpg.applications_system_name
1307: and aat.active_flag='Y'
1308: and fpg.release_name=ar.major_version||'.'||ar.minor_version||'.'||ar.tape_version

Line 1333: ad_releases ar

1329: into l_appl_top_id
1330: FROM FND_OAM_CONTEXT_FILES focf,
1331: fnd_product_groups fpg,
1332: ad_appl_tops aat,
1333: ad_releases ar
1334: WHERE focf.NAME not in ('TEMPLATE','METADATA','config.txt')
1335: and focf.CTX_TYPE='A'
1336: and (focf.status is null or upper(focf.status) in ('S','F'))
1337: and EXTRACTVALUE(XMLType(focf.TEXT),'//file_edition_type') = 'run'