DBA Data[Home] [Help]

APPS.FND_CONC_CLONE dependencies on FND_CONFLICTS_DOMAIN

Line 161: -- Delete from FND_CONFLICTS_DOMAIN table

157:
158: -- Delete from FND_NODES table
159: Delete from fnd_nodes;
160:
161: -- Delete from FND_CONFLICTS_DOMAIN table
162: --
163: -- NOTE: DELETION from FND_CONFLICTS_DOMAIN uses
164: -- column DYNAMIC which was introduced in a patch.
165: -- This column exists from 11.5.9 onwards.

Line 163: -- NOTE: DELETION from FND_CONFLICTS_DOMAIN uses

159: Delete from fnd_nodes;
160:
161: -- Delete from FND_CONFLICTS_DOMAIN table
162: --
163: -- NOTE: DELETION from FND_CONFLICTS_DOMAIN uses
164: -- column DYNAMIC which was introduced in a patch.
165: -- This column exists from 11.5.9 onwards.
166: execute immediate 'delete from fnd_conflicts_domain fcd ' ||
167: ' where dynamic = ''Y''' ||

Line 166: execute immediate 'delete from fnd_conflicts_domain fcd ' ||

162: --
163: -- NOTE: DELETION from FND_CONFLICTS_DOMAIN uses
164: -- column DYNAMIC which was introduced in a patch.
165: -- This column exists from 11.5.9 onwards.
166: execute immediate 'delete from fnd_conflicts_domain fcd ' ||
167: ' where dynamic = ''Y''' ||
168: ' and not exists (select ''X''' ||
169: ' from fnd_concurrent_requests fcr ' ||
170: ' where fcr.cd_id = fcd.cd_id ' ||

Line 410: -- Delete from FND_CONFLICTS_DOMAIN table

406:
407: -- Delete from FND_NODES table
408: Delete from fnd_nodes;
409:
410: -- Delete from FND_CONFLICTS_DOMAIN table
411: Delete from fnd_conflicts_domain fcd
412: where dynamic = 'Y'
413: and not exists (select 'X'
414: from fnd_concurrent_requests fcr

Line 411: Delete from fnd_conflicts_domain fcd

407: -- Delete from FND_NODES table
408: Delete from fnd_nodes;
409:
410: -- Delete from FND_CONFLICTS_DOMAIN table
411: Delete from fnd_conflicts_domain fcd
412: where dynamic = 'Y'
413: and not exists (select 'X'
414: from fnd_concurrent_requests fcr
415: where fcr.cd_id = fcd.cd_id