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.CS_KNOWLEDGE_AUDIT_PVT dependencies on MTL_ITEM_CATEGORIES

Line 2983: 'FROM mtl_system_items_vl it, mtl_item_categories ic '||

2979:
2980: BEGIN
2981: l_query :=
2982: 'SELECT it.inventory_item_id '||
2983: 'FROM mtl_system_items_vl it, mtl_item_categories ic '||
2984: 'where it.inventory_item_id = ic.inventory_item_id '||
2985: 'and it.organization_id = ic.organization_id '||
2986: 'and it.organization_id = :l_org_id '||
2987: 'and ic.category_set_id = :l_prof_val '||

Line 3023: FROM mtl_system_items_vl it, mtl_item_categories ic

3019: x_number OUT NOCOPY NUMBER
3020: ) RETURN NUMBER IS
3021: CURSOR cur_segments(cp_org_id NUMBER, cp_prof_val VARCHAR2, cp_segments VARCHAR2) IS
3022: SELECT it.inventory_item_id
3023: FROM mtl_system_items_vl it, mtl_item_categories ic
3024: where it.inventory_item_id = ic.inventory_item_id
3025: and it.organization_id = ic.organization_id
3026: and it.organization_id = cp_org_id
3027: and ic.category_set_id = cp_prof_val

Line 3065: 'FROM mtl_system_items_vl it, mtl_item_categories ic '||

3061: BEGIN
3062:
3063: l_query :=
3064: 'SELECT it.inventory_item_id '||
3065: 'FROM mtl_system_items_vl it, mtl_item_categories ic '||
3066: 'where it.inventory_item_id = ic.inventory_item_id '||
3067: 'and it.organization_id = ic.organization_id '||
3068: 'and it.organization_id = :l_org_id '||
3069: 'and ic.category_set_id = :l_prof_val '||

Line 3105: FROM mtl_system_items_vl it, mtl_item_categories ic

3101: x_number OUT NOCOPY NUMBER
3102: ) RETURN NUMBER IS
3103: CURSOR cur_segments(cp_org_id NUMBER, cp_prof_val VARCHAR2, cp_segments VARCHAR2) IS
3104: SELECT it.inventory_item_id
3105: FROM mtl_system_items_vl it, mtl_item_categories ic
3106: where it.inventory_item_id = ic.inventory_item_id
3107: and it.organization_id = ic.organization_id
3108: and it.organization_id = cp_org_id
3109: and ic.category_set_id = cp_prof_val

Line 3973: FROM mtl_system_items_vl it, mtl_item_categories ic, cs_kb_set_products a

3969:
3970: -- Fetch info for all products the solution links to
3971: CURSOR get_product_info(c_set_id IN NUMBER) IS
3972: SELECT it.description,it.concatenated_segments
3973: FROM mtl_system_items_vl it, mtl_item_categories ic, cs_kb_set_products a
3974: where it.inventory_item_id = ic.inventory_item_id
3975: and it.organization_id = ic.organization_id
3976: and it.organization_id = cs_std.get_item_valdn_orgzn_id
3977: and ic.category_set_id = fnd_profile.value('CS_KB_PRODUCT_CATEGORY_SET')

Line 3984: FROM mtl_system_items_vl it, mtl_item_categories ic, cs_kb_set_platforms a

3980:
3981: -- Fetch info for all platforms the solution links to
3982: CURSOR get_platform_info(c_set_id IN NUMBER) IS
3983: SELECT it.description,it.concatenated_segments
3984: FROM mtl_system_items_vl it, mtl_item_categories ic, cs_kb_set_platforms a
3985: where it.inventory_item_id = ic.inventory_item_id
3986: and it.organization_id = ic.organization_id
3987: and it.organization_id = cs_std.get_item_valdn_orgzn_id
3988: and ic.category_set_id = fnd_profile.value('CS_SR_PLATFORM_CATEGORY_SET')