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_CONTENT_ITEMS

Line 24: ibc_content_items

20: CURSOR c_ctype IS
21: SELECT
22: content_type_code
23: FROM
24: ibc_content_items
25: WHERE
26: content_item_id = f_content_item_id;
27:
28: temp IBC_CONTENT_TYPES_B.content_type_code%TYPE;

Line 319: FROM ibc_content_items citem,

315: l_directory_object_type NUMBER := IBC_DATA_SECURITY_PVT.get_object_id('IBC_DIRECTORY_NODE');
316:
317: CURSOR c_directory(p_content_item_id NUMBER) IS
318: SELECT citem.directory_node_id, dirnode.directory_path
319: FROM ibc_content_items citem,
320: ibc_directory_nodes_b dirnode
321: WHERE citem.content_item_id = p_content_item_id
322: AND citem.directory_node_id = dirnode.directory_node_id;
323:

Line 342: ibc_content_items citem

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:
346: CURSOR c_citem_name(p_citem_ver_id NUMBER) IS

Line 368: ibc_content_items c

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
371: AND a.citem_version_id = p_citem_ver_id
372: AND c.content_item_status <> p_status;

Line 1052: ibc_content_items ci

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
1056: SELECT content_item_name

Line 1063: FROM ibc_content_items citem,

1059: AND language = p_language;
1060:
1061: CURSOR c_directory(p_content_item_id NUMBER) IS
1062: SELECT citem.directory_node_id, dirnode.directory_path
1063: FROM ibc_content_items citem,
1064: ibc_directory_nodes_b dirnode
1065: WHERE citem.content_item_id = p_content_item_id
1066: AND citem.directory_node_id = dirnode.directory_node_id;
1067: --l_directory_node_id NUMBER;

Line 1863: FROM ibc_content_items citem,

1859: l_directory_object_type NUMBER := IBC_DATA_SECURITY_PVT.get_object_id('IBC_DIRECTORY_NODE');
1860:
1861: CURSOR c_directory(p_content_item_id NUMBER) IS
1862: SELECT citem.directory_node_id, dirnode.directory_path
1863: FROM ibc_content_items citem,
1864: ibc_directory_nodes_b dirnode
1865: WHERE citem.content_item_id = p_content_item_id
1866: AND citem.directory_node_id = dirnode.directory_node_id;
1867:

Line 1887: ,ibc_content_items CITEM

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:
1891: CURSOR c_citem_name(p_citem_ver_id NUMBER) IS

Line 1913: ,ibc_content_items c

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
1916: AND a.citem_version_id = p_citem_ver_id
1917: AND c.content_item_status <> p_status;

Line 2649: ibc_content_items citem

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)
2653: and I.ITEM_TYPE = IT.NAME

Line 2673: ibc_content_items citem

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)
2677: and I.ITEM_TYPE = IT.NAME

Line 2778: FROM ibc_content_items citem,

2774: WHERE civ.content_item_id = p_content_item_id;
2775:
2776: CURSOR c_citem_location(p_content_item_id NUMBER) IS
2777: SELECT dirnode.directory_path
2778: FROM ibc_content_items citem,
2779: ibc_directory_nodes_b dirnode
2780: WHERE citem.content_item_id = p_content_item_id
2781: AND citem.directory_node_id = dirnode.directory_node_id;
2782:

Line 3001: FROM ibc_content_items citem,

2997: WHERE civ.content_item_id = p_content_item_id;
2998:
2999: CURSOR c_citem_location(p_content_item_id NUMBER) IS
3000: SELECT dirnode.directory_path, dirnode.directory_node_id
3001: FROM ibc_content_items citem,
3002: ibc_directory_nodes_b dirnode
3003: WHERE citem.content_item_id = p_content_item_id
3004: AND citem.directory_node_id = dirnode.directory_node_id;
3005: