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.

[Home] [Help]

APPS.AD_ZD_ADOP dependencies on AD_SNAPSHOTS

Line 712: from AD_SNAPSHOT_FILES OU, AD_SNAPSHOTS OUASN,

708: -- Deleting new records inserted by patch
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'

Line 731: from AD_SNAPSHOT_FILES ASF, AD_SNAPSHOTS ASN

727: rel.minor_version||'.'||
728: rel.tape_version
729: and not exists (
730: select 'x'
731: from AD_SNAPSHOT_FILES ASF, AD_SNAPSHOTS ASN
732: where ASF.SNAPSHOT_ID=ASN.SNAPSHOT_ID
733: and ASN.SNAPSHOT_TYPE='C'
734: and ASN.SNAPSHOT_NAME=OUASN.SNAPSHOT_NAME
735: and ASN.APPL_TOP_ID=OUASN.APPL_TOP_ID

Line 744: from AD_SNAPSHOT_FILES OU, AD_SNAPSHOTS OUASN,

740:
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'

Line 762: from AD_SNAPSHOT_FILES ASF, AD_SNAPSHOTS ASN

758: rel.minor_version||'.'||
759: rel.tape_version
760: and not exists (
761: select 'x'
762: from AD_SNAPSHOT_FILES ASF, AD_SNAPSHOTS ASN
763: where ASF.SNAPSHOT_ID=ASN.SNAPSHOT_ID
764: and ASN.SNAPSHOT_TYPE='G'
765: and ASN.SNAPSHOT_NAME=OUASN.SNAPSHOT_NAME
766: and ASN.APPL_TOP_ID=OUASN.APPL_TOP_ID

Line 777: from AD_SNAPSHOT_BUGFIXES OU, AD_SNAPSHOTS OUASN,

773: -- Deleting new records inserted by patch
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'

Line 796: from AD_SNAPSHOT_BUGFIXES ASF, AD_SNAPSHOTS ASN

792: rel.minor_version||'.'||
793: rel.tape_version
794: and not exists (
795: select 'x'
796: from AD_SNAPSHOT_BUGFIXES ASF, AD_SNAPSHOTS ASN
797: where ASF.SNAPSHOT_ID=ASN.SNAPSHOT_ID
798: and ASN.SNAPSHOT_TYPE='C'
799: and ASN.SNAPSHOT_NAME=OUASN.SNAPSHOT_NAME
800: and ASN.APPL_TOP_ID=OUASN.APPL_TOP_ID

Line 808: from AD_SNAPSHOT_BUGFIXES OU, AD_SNAPSHOTS OUASN,

804:
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'

Line 825: from AD_SNAPSHOT_BUGFIXES ASF, AD_SNAPSHOTS ASN

821: rel.minor_version||'.'||
822: rel.tape_version
823: and not exists (
824: select 'x'
825: from AD_SNAPSHOT_BUGFIXES ASF, AD_SNAPSHOTS ASN
826: where ASF.SNAPSHOT_ID=ASN.SNAPSHOT_ID
827: and ASN.SNAPSHOT_TYPE='G'
828: and ASN.SNAPSHOT_NAME=OUASN.SNAPSHOT_NAME
829: and ASN.APPL_TOP_ID=OUASN.APPL_TOP_ID

Line 840: from AD_SNAPSHOTS ASN1, AD_SNAPSHOT_FILES ASF1,

836: select ASF1.SNAPSHOT_ID,
837: ASF2.FILE_ID,
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

Line 841: AD_SNAPSHOTS ASN2, AD_SNAPSHOT_FILES ASF2,

837: ASF2.FILE_ID,
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

Line 871: from AD_SNAPSHOTS ASN1, AD_SNAPSHOT_FILES ASF1,

867: select ASF1.SNAPSHOT_ID,
868: ASF2.FILE_ID,
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

Line 872: AD_SNAPSHOTS ASN2, AD_SNAPSHOT_FILES ASF2,

868: ASF2.FILE_ID,
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

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 954: from AD_SNAPSHOT_FILES ASF, AD_SNAPSHOTS ASN

950: rel.minor_version||'.'||
951: rel.tape_version
952: and not exists (
953: select 'x'
954: from AD_SNAPSHOT_FILES ASF, AD_SNAPSHOTS ASN
955: where ASF.SNAPSHOT_ID=ASN.SNAPSHOT_ID
956: and ASN.SNAPSHOT_TYPE='P'
957: and ASN.SNAPSHOT_NAME=OUASN.SNAPSHOT_NAME
958: and ASN.APPL_TOP_ID=OUASN.APPL_TOP_ID

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 998: from AD_SNAPSHOT_FILES ASF, AD_SNAPSHOTS ASN

994: rel.minor_version||'.'||
995: rel.tape_version
996: and not exists (
997: select 'x'
998: from AD_SNAPSHOT_FILES ASF, AD_SNAPSHOTS ASN
999: where ASF.SNAPSHOT_ID=ASN.SNAPSHOT_ID
1000: and ASN.SNAPSHOT_TYPE='Q'
1001: and ASN.SNAPSHOT_NAME=OUASN.SNAPSHOT_NAME
1002: and ASN.APPL_TOP_ID=OUASN.APPL_TOP_ID

Line 1163: AD_SNAPSHOTS ASN,

1159: ASN.SNAPSHOT_NAME,
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'

Line 1185: AD_SNAPSHOTS ASN,

1181: ASN.SNAPSHOT_NAME,
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'

Line 1202: update ad_snapshots

1198: begin
1199: -- Update release_id if necessary
1200: for snp in snps
1201: loop
1202: update ad_snapshots
1203: set release_id=snp.release_id
1204: where appl_top_id=snp.appl_top_id
1205: and snapshot_type=decode(snp.snapshot_type, 'P', 'C', 'Q', 'G')
1206: and snapshot_name=snp.snapshot_name

Line 1211: update ad_snapshots

1207: and release_id<>snp.release_id;
1208: end loop;
1209:
1210: -- Flip snapshots
1211: update ad_snapshots
1212: set snapshot_type=DECODE(snapshot_type, 'C', 'P', 'P', 'C',
1213: 'G', 'Q', 'Q', 'G')
1214: where snapshot_id in (
1215: select ASN.SNAPSHOT_ID

Line 1217: AD_SNAPSHOTS ASN,

1213: 'G', 'Q', 'Q', 'G')
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'

Line 1235: AD_SNAPSHOTS ASN,

1231: and fn.node_name is not null
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'