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

Line 868: CURSOR c_check_relation (cp_item_id ibc_citem_versions_b.content_item_id%TYPE,

864: FROM igs_pe_person_base_v
865: WHERe person_id = p_person_id;
866:
867: --Cursor to get the citem_version_id
868: CURSOR c_check_relation (cp_item_id ibc_citem_versions_b.content_item_id%TYPE,
869: cp_version_id ibc_citem_versions_b.version_number%TYPE) IS
870: SELECT 'Y'
871: FROM ibc_compound_relations
872: WHERE CITEM_VERSION_ID = (SELECT CITEM_VERSION_ID FROM ibc_citem_versions_b

Line 869: cp_version_id ibc_citem_versions_b.version_number%TYPE) IS

865: WHERe person_id = p_person_id;
866:
867: --Cursor to get the citem_version_id
868: CURSOR c_check_relation (cp_item_id ibc_citem_versions_b.content_item_id%TYPE,
869: cp_version_id ibc_citem_versions_b.version_number%TYPE) IS
870: SELECT 'Y'
871: FROM ibc_compound_relations
872: WHERE CITEM_VERSION_ID = (SELECT CITEM_VERSION_ID FROM ibc_citem_versions_b
873: WHERE CONTENT_ITEM_ID = cp_item_id AND

Line 872: WHERE CITEM_VERSION_ID = (SELECT CITEM_VERSION_ID FROM ibc_citem_versions_b

868: CURSOR c_check_relation (cp_item_id ibc_citem_versions_b.content_item_id%TYPE,
869: cp_version_id ibc_citem_versions_b.version_number%TYPE) IS
870: SELECT 'Y'
871: FROM ibc_compound_relations
872: WHERE CITEM_VERSION_ID = (SELECT CITEM_VERSION_ID FROM ibc_citem_versions_b
873: WHERE CONTENT_ITEM_ID = cp_item_id AND
874: VERSION_NUMBER = cp_version_id)
875: AND ATTRIBUTE_TYPE_CODE = 'QUERY'; -- ssawhney modified after OCM migration.
876: