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_SNAPSHOT_FILES_S

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 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,