[Home] [Help]
387: EXTRACTVALUE(XMLType(TEXT),'//shared_file_system') is_shared
388: FROM
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
709: delete AD_SNAPSHOT_FILES
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'
741: delete AD_SNAPSHOT_FILES
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'
774: delete AD_SNAPSHOT_BUGFIXES
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'
805: delete AD_SNAPSHOT_BUGFIXES
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'
838: ASF2.CONTAINING_FILE_ID,
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'
869: ASF2.CONTAINING_FILE_ID,
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'
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'
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'
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'
1169: AND AAT.APPL_TOP_ID=ASN.APPL_TOP_ID
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'
1191: AND AAT.APPL_TOP_ID=ASN.APPL_TOP_ID
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'
1223: AND AAT.APPL_TOP_ID=ASN.APPL_TOP_ID
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
1241: and ASN.SNAPSHOT_TYPE in ('G', 'Q')
1299: l_clone_exists number;
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'
1327: loop
1328: SELECT aat.appl_top_id
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'