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.OKE_DELIVERABLE_PVT dependencies on OKE_K_DELIVERABLES_TLH

Line 5297: delete from OKE_K_DELIVERABLES_TLH T

5293:
5294: --
5295: -- History table
5296: --
5297: delete from OKE_K_DELIVERABLES_TLH T
5298: where not exists
5299: (select NULL
5300: from OKE_K_DELIVERABLES_BH B
5301: where B.DELIVERABLE_ID = T.DELIVERABLE_ID

Line 5305: update OKE_K_DELIVERABLES_TLH T set (

5301: where B.DELIVERABLE_ID = T.DELIVERABLE_ID
5302: and T.MAJOR_VERSION = B.MAJOR_VERSION
5303: );
5304:
5305: update OKE_K_DELIVERABLES_TLH T set (
5306: DESCRIPTION,
5307: COMMENTS
5308: ) = (select
5309: B.DESCRIPTION,

Line 5311: from OKE_K_DELIVERABLES_TLH B

5307: COMMENTS
5308: ) = (select
5309: B.DESCRIPTION,
5310: B.COMMENTS
5311: from OKE_K_DELIVERABLES_TLH B
5312: where B.DELIVERABLE_ID = T.DELIVERABLE_ID
5313: and B.LANGUAGE = T.SOURCE_LANG
5314: and T.MAJOR_VERSION = B.MAJOR_VERSION)
5315: where (

Line 5323: from OKE_K_DELIVERABLES_TLH SUBB, OKE_K_DELIVERABLES_TLH SUBT

5319: ) in (select
5320: SUBT.DELIVERABLE_ID,
5321: SUBT.MAJOR_VERSION,
5322: SUBT.LANGUAGE
5323: from OKE_K_DELIVERABLES_TLH SUBB, OKE_K_DELIVERABLES_TLH SUBT
5324: where SUBB.DELIVERABLE_ID = SUBT.DELIVERABLE_ID
5325: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
5326: and SUBB.MAJOR_VERSION = SUBT.MAJOR_VERSION
5327: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 5335: insert into OKE_K_DELIVERABLES_TLH (

5331: or (SUBB.COMMENTS is null and SUBT.COMMENTS is not null)
5332: or (SUBB.COMMENTS is not null and SUBT.COMMENTS is null)
5333: ));
5334:
5335: insert into OKE_K_DELIVERABLES_TLH (
5336: DELIVERABLE_ID,
5337: MAJOR_VERSION,
5338: CREATION_DATE,
5339: CREATED_BY,

Line 5365: from OKE_K_DELIVERABLES_TLH B, FND_LANGUAGES L

5361: B.DESCRIPTION,
5362: B.COMMENTS,
5363: L.LANGUAGE_CODE,
5364: B.SOURCE_LANG
5365: from OKE_K_DELIVERABLES_TLH B, FND_LANGUAGES L
5366: where L.INSTALLED_FLAG in ('I', 'B')
5367: and B.LANGUAGE = userenv('LANG')
5368: and not exists
5369: (select NULL

Line 5370: from OKE_K_DELIVERABLES_TLH T

5366: where L.INSTALLED_FLAG in ('I', 'B')
5367: and B.LANGUAGE = userenv('LANG')
5368: and not exists
5369: (select NULL
5370: from OKE_K_DELIVERABLES_TLH T
5371: where T.DELIVERABLE_ID = B.DELIVERABLE_ID
5372: and T.LANGUAGE = L.LANGUAGE_CODE
5373: and T.MAJOR_VERSION = B.MAJOR_VERSION);
5374: