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_SNAPSHOT_FILES

Line 707: -- Cleaning ad_snapshot_files

703:
704: PROCEDURE SYNC_SNAPSHOTS(p_appl_top_id in number default null)
705: is
706: begin
707: -- Cleaning ad_snapshot_files
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)

Line 709: delete AD_SNAPSHOT_FILES

705: is
706: begin
707: -- Cleaning ad_snapshot_files
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,

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 741: delete AD_SNAPSHOT_FILES

737: and NVL(OU.CONTAINING_FILE_ID, -2)=NVL(ASF.CONTAINING_FILE_ID, -2)
738: and OUASN.APPL_TOP_ID=ASN.APPL_TOP_ID)
739: );
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,

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 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 899: update AD_SNAPSHOT_FILES

895:
896: begin
897: for cr in crs
898: loop
899: update AD_SNAPSHOT_FILES
900: set FILE_VERSION_ID=cr.FILE_VERSION_ID
901: where SNAPSHOT_ID=cr.SNAPSHOT_ID
902: and file_id=cr.file_id
903: and nvl(containing_file_id, -2)=nvl(cr.containing_file_id, -2);

Line 908: update AD_SNAPSHOT_FILES

904: end loop;
905:
906: for globalr in grs
907: loop
908: update AD_SNAPSHOT_FILES
909: set FILE_VERSION_ID=globalr.FILE_VERSION_ID
910: where SNAPSHOT_ID=globalr.SNAPSHOT_ID
911: and file_id=globalr.file_id
912: and nvl(containing_file_id, -2)=nvl(globalr.containing_file_id, -2);

Line 917: insert into ad_snapshot_files(SNAPSHOT_FILE_ID, SNAPSHOT_ID, FILE_ID,

913: end loop;
914: end;
915:
916: -- Insert the missing records;
917: insert into ad_snapshot_files(SNAPSHOT_FILE_ID, SNAPSHOT_ID, FILE_ID,
918: CONTAINING_FILE_ID, FILE_SIZE, CHECKSUM,
919: FILE_VERSION_ID, UPDATE_SOURCE_ID, UPDATE_TYPE,
920: CREATION_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY,
921: CREATED_BY, APPL_TOP_ID, INCONSISTENT_FLAG,

Line 925: select AD_SNAPSHOT_FILES_S.NEXTVAL, ouasnpat.SNAPSHOT_ID, ouasf.FILE_ID,

921: CREATED_BY, APPL_TOP_ID, INCONSISTENT_FLAG,
922: SERVER_TYPE_ADMIN_FLAG, SERVER_TYPE_FORMS_FLAG, SERVER_TYPE_NODE_FLAG,
923: SERVER_TYPE_WEB_FLAG, DEST_FILE_ID, FILE_TYPE_FLAG,
924: IREP_GATHERED_FLAG, LAST_PATCHED_DATE)
925: select AD_SNAPSHOT_FILES_S.NEXTVAL, ouasnpat.SNAPSHOT_ID, ouasf.FILE_ID,
926: ouasf.CONTAINING_FILE_ID, ouasf.FILE_SIZE, ouasf.CHECKSUM,
927: ouasf.FILE_VERSION_ID, ouasf.UPDATE_SOURCE_ID, ouasf.UPDATE_TYPE,
928: ouasf.CREATION_DATE, ouasf.LAST_UPDATE_DATE, ouasf.LAST_UPDATED_BY,
929: ouasf.CREATED_BY, ouasf.APPL_TOP_ID, ouasf.INCONSISTENT_FLAG,

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 962: insert into ad_snapshot_files(SNAPSHOT_FILE_ID, SNAPSHOT_ID, FILE_ID,

958: and ASN.APPL_TOP_ID=OUASN.APPL_TOP_ID
959: and OUASF.FILE_ID=ASF.FILE_ID
960: and NVL(OUASF.CONTAINING_FILE_ID, -2)=NVL(ASF.CONTAINING_FILE_ID, -2));
961:
962: insert into ad_snapshot_files(SNAPSHOT_FILE_ID, SNAPSHOT_ID, FILE_ID,
963: CONTAINING_FILE_ID, FILE_SIZE, CHECKSUM,
964: FILE_VERSION_ID, UPDATE_SOURCE_ID, UPDATE_TYPE,
965: CREATION_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY,
966: CREATED_BY, APPL_TOP_ID, INCONSISTENT_FLAG,

Line 970: select AD_SNAPSHOT_FILES_S.NEXTVAL, ouasnpat.SNAPSHOT_ID, ouasf.FILE_ID,

966: CREATED_BY, APPL_TOP_ID, INCONSISTENT_FLAG,
967: SERVER_TYPE_ADMIN_FLAG, SERVER_TYPE_FORMS_FLAG, SERVER_TYPE_NODE_FLAG,
968: SERVER_TYPE_WEB_FLAG, DEST_FILE_ID, FILE_TYPE_FLAG,
969: IREP_GATHERED_FLAG, LAST_PATCHED_DATE)
970: select AD_SNAPSHOT_FILES_S.NEXTVAL, ouasnpat.SNAPSHOT_ID, ouasf.FILE_ID,
971: ouasf.CONTAINING_FILE_ID, ouasf.FILE_SIZE, ouasf.CHECKSUM,
972: ouasf.FILE_VERSION_ID, ouasf.UPDATE_SOURCE_ID, ouasf.UPDATE_TYPE,
973: ouasf.CREATION_DATE, ouasf.LAST_UPDATE_DATE, ouasf.LAST_UPDATED_BY,
974: ouasf.CREATED_BY, ouasf.APPL_TOP_ID, ouasf.INCONSISTENT_FLAG,

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