APPS.AD_ZD_ADOP dependencies on FND_NODES

Line 389: fnd_nodes fn,

385: fn.host node_name ,
386: aat.appl_top_id appl_top_id ,
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

Line 1166: FND_NODES FN

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
1170: and ASN.SNAPSHOT_TYPE in ('C', 'P')

Line 1220: FND_NODES FN

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
1224: and ASN.SNAPSHOT_TYPE in ('C', 'P')

Line 1304: ad_releases ar, fnd_nodes fn

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'
1308: and fpg.release_name=ar.major_version||'.'||ar.minor_version||'.'||ar.tape_version