APPS.AD_ZD_ADOP dependencies on AD_SNAPSHOT_BUGFIXES

Line 772: -- Cleaning ad_snapshot_bugfixes

768: and NVL(OU.CONTAINING_FILE_ID, -2)=NVL(ASF.CONTAINING_FILE_ID, -2)
769: and OUASN.APPL_TOP_ID=ASN.APPL_TOP_ID)
770: );
771:
772: -- Cleaning ad_snapshot_bugfixes
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

Line 774: delete AD_SNAPSHOT_BUGFIXES

770: );
771:
772: -- Cleaning ad_snapshot_bugfixes
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,

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 805: delete AD_SNAPSHOT_BUGFIXES

801: and OU.BUGFIX_ID=ASF.BUGFIX_ID
802: and OUASN.APPL_TOP_ID=ASN.APPL_TOP_ID)
803: );
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,

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