APPS.AD_ZD_ADOP dependencies on FND_OAM_CONTEXT_FILES

Line 390: FND_OAM_CONTEXT_FILES focf,

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
394: WHERE focf.NAME not in ('TEMPLATE','METADATA','config.txt') and focf.CTX_TYPE='A' and

Line 1330: FROM FND_OAM_CONTEXT_FILES focf,

1326: for node in nodes
1327: loop
1328: SELECT aat.appl_top_id
1329: into l_appl_top_id
1330: FROM FND_OAM_CONTEXT_FILES focf,
1331: fnd_product_groups fpg,
1332: ad_appl_tops aat,
1333: ad_releases ar
1334: WHERE focf.NAME not in ('TEMPLATE','METADATA','config.txt')

Line 1406: from FND_OAM_CONTEXT_FILES

1402: where $i/text() eq "enabled"
1403: return fn:concat($i/@oa_var,",") '
1404: PASSING XMLType(TEXT) RETURNING CONTENT
1405: )).getStringVal() services, node_name node
1406: from FND_OAM_CONTEXT_FILES
1407: where NAME not in ('TEMPLATE','METADATA','config.txt') and
1408: CTX_TYPE='A' and (status is null or upper(status) in ('S','F'))
1409: and EXTRACTVALUE(XMLType(TEXT),'//file_edition_type') = 'patch';
1410:

Line 1420: from FND_OAM_CONTEXT_FILES

1416: where $i/text() eq "enabled"
1417: return fn:concat($i/@oa_var,",") '
1418: PASSING XMLType(TEXT) RETURNING CONTENT
1419: )).getStringVal() group_services, node_name node
1420: from FND_OAM_CONTEXT_FILES
1421: where NAME not in ('TEMPLATE','METADATA','config.txt') and
1422: CTX_TYPE='A' and (status is null or upper(status) in ('S','F'))
1423: and EXTRACTVALUE(XMLType(TEXT),'//file_edition_type')= 'patch';
1424: