APPS.IBC_UTILITIES_PVT dependencies on IBC_CITEM_VERSIONS_B

Line 66: FROM ibc_citem_versions_b civb

62: CURSOR c_name(p_content_item_id NUMBER) IS
63: SELECT content_item_name
64: FROM ibc_citem_versions_tl
65: WHERE citem_version_id = (SELECT citem_version_id
66: FROM ibc_citem_versions_b civb
67: WHERE content_item_id = p_content_item_id
68: AND version_number = (SELECT MAX(version_number)
69: FROM ibc_citem_versions_b civb2
70: WHERE civb2.content_item_id = civb.content_item_id)

Line 69: FROM ibc_citem_versions_b civb2

65: WHERE citem_version_id = (SELECT citem_version_id
66: FROM ibc_citem_versions_b civb
67: WHERE content_item_id = p_content_item_id
68: AND version_number = (SELECT MAX(version_number)
69: FROM ibc_citem_versions_b civb2
70: WHERE civb2.content_item_id = civb.content_item_id)
71: )
72: AND language = USERENV('lang');
73: l_citem_name IBC_CITEM_VERSIONS_TL.content_item_name%TYPE;

Line 675: FROM IBC_CITEM_VERSIONS_B

671: ORDER BY r.SORT_ORDER;
672:
673: CURSOR Get_Cpnt_Latest_Version IS
674: SELECT CITEM_VERSION_ID
675: FROM IBC_CITEM_VERSIONS_B
676: WHERE CONTENT_ITEM_ID = l_component_item_id
677: AND VERSION_NUMBER = (SELECT MAX(VERSION_NUMBER)
678: FROM IBC_CITEM_VERSIONS_B
679: WHERE CONTENT_ITEM_ID = l_component_item_id);

Line 678: FROM IBC_CITEM_VERSIONS_B

674: SELECT CITEM_VERSION_ID
675: FROM IBC_CITEM_VERSIONS_B
676: WHERE CONTENT_ITEM_ID = l_component_item_id
677: AND VERSION_NUMBER = (SELECT MAX(VERSION_NUMBER)
678: FROM IBC_CITEM_VERSIONS_B
679: WHERE CONTENT_ITEM_ID = l_component_item_id);
680: BEGIN
681: -- Loop through each component item
682: FOR compound_item_rec IN Get_Compound_Item_Ref LOOP

Line 1442: FROM ibc_citem_versions_b civb,

1438: WHERE directory_node_id = p_dir_node_id;
1439:
1440: CURSOR c_chk_name IS
1441: SELECT 'CITEM', civb.content_item_id
1442: FROM ibc_citem_versions_b civb,
1443: ibc_citem_versions_tl civtl
1444: WHERE civb.citem_version_id = civtl.citem_version_id
1445: AND language = NVL(p_language, USERENV('lang'))
1446: AND civb.content_item_id <> NVL(p_chk_content_item_id, -1)