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.IBC_CITEM_WORKFLOW_PVT dependencies on IBC_CITEM_VERSIONS_B

Line 227: FROM ibc_citem_versions_b

223: f_citem_version_id IN NUMBER
224: ) RETURN NUMBER IS
225: CURSOR c_item IS
226: SELECT content_item_id
227: FROM ibc_citem_versions_b
228: WHERE citem_version_id = f_citem_version_id;
229: temp NUMBER;
230: BEGIN
231: open c_item;

Line 341: FROM ibc_citem_versions_b civer,

337: SELECT owner_resource_id,
338: owner_resource_type,
339: civer.version_number,
340: citem.created_by
341: FROM ibc_citem_versions_b civer,
342: ibc_content_items citem
343: WHERE civer.citem_version_id = p_citem_ver_id
344: AND civer.content_item_id = citem.content_item_id;
345:

Line 366: FROM ibc_citem_versions_b a,

362: CURSOR c_component_not_status (p_citem_ver_id IN NUMBER,
363: p_status IN VARCHAR2)
364: IS
365: SELECT 'X'
366: FROM ibc_citem_versions_b a,
367: ibc_compound_relations b,
368: ibc_content_items c
369: WHERE a.citem_version_id = b.citem_version_id
370: AND b.content_item_id = c.content_item_id

Line 1051: FROM ibc_citem_versions_b civ,

1047: ci.base_language,
1048: ci.translation_required_flag,
1049: ci.directory_node_id,
1050: civ.version_number
1051: FROM ibc_citem_versions_b civ,
1052: ibc_content_items ci
1053: WHERE ci.content_item_id = civ.content_item_id
1054: AND civ.citem_version_id = p_citem_version_id;
1055: CURSOR c_citem_name(p_citem_ver_id NUMBER, p_language VARCHAR2) IS

Line 1886: FROM ibc_citem_versions_b CIVER

1882: SELECT CITEM.owner_resource_id
1883: ,CITEM.owner_resource_type
1884: ,CIVER.version_number
1885: ,CITEM.created_by
1886: FROM ibc_citem_versions_b CIVER
1887: ,ibc_content_items CITEM
1888: WHERE CIVER.citem_version_id = p_citem_ver_id
1889: AND CIVER.content_item_id = CITEM.content_item_id;
1890:

Line 1911: FROM ibc_citem_versions_b a

1907: CURSOR c_component_not_status (p_citem_ver_id IN NUMBER,
1908: p_status IN VARCHAR2)
1909: IS
1910: SELECT 'X'
1911: FROM ibc_citem_versions_b a
1912: ,ibc_compound_relations b
1913: ,ibc_content_items c
1914: WHERE a.citem_version_id = b.citem_version_id
1915: AND b.content_item_id = c.content_item_id

Line 2648: ibc_citem_versions_b civb,

2644: IS
2645: select IAS.ITEM_KEY
2646: from WF_LOOKUPS L_AT, WF_LOOKUPS L_AS, WF_ACTIVITIES_VL A, WF_PROCESS_ACTIVITIES PA,
2647: WF_ITEM_TYPES_VL IT, WF_ITEMS I, WF_ITEM_ACTIVITY_STATUSES IAS,
2648: ibc_citem_versions_b civb,
2649: ibc_content_items citem
2650: WHERE IAS.ITEM_TYPE = I.ITEM_TYPE
2651: and IAS.ITEM_KEY = I.ITEM_KEY
2652: and I.BEGIN_DATE between A.BEGIN_DATE and nvl(A.END_DATE, I.BEGIN_DATE)

Line 2672: ibc_citem_versions_b civb,

2668: MINUS
2669: select IAS.ITEM_KEY
2670: from WF_LOOKUPS L_AT, WF_LOOKUPS L_AS, WF_ACTIVITIES_VL A, WF_PROCESS_ACTIVITIES PA,
2671: WF_ITEM_TYPES_VL IT, WF_ITEMS I, WF_ITEM_ACTIVITY_STATUSES IAS, WF_USER_ROLES U,
2672: ibc_citem_versions_b civb,
2673: ibc_content_items citem
2674: WHERE IAS.ITEM_TYPE = I.ITEM_TYPE
2675: and IAS.ITEM_KEY = I.ITEM_KEY
2676: and I.BEGIN_DATE between A.BEGIN_DATE and nvl(A.END_DATE, I.BEGIN_DATE)