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 2993: 'FROM mtl_system_items_vl it, mtl_item_categories ic '||

2989:
2990: BEGIN
2991: l_query :=
2992: 'SELECT it.inventory_item_id '||
2993: 'FROM mtl_system_items_vl it, mtl_item_categories ic '||
2994: 'where it.inventory_item_id = ic.inventory_item_id '||
2995: 'and it.organization_id = ic.organization_id '||
2996: 'and it.organization_id = :l_org_id '||
2997: 'and ic.category_set_id = :l_prof_val '||

Line 3033: FROM mtl_system_items_vl it, mtl_item_categories ic

3029: x_number OUT NOCOPY NUMBER
3030: ) RETURN NUMBER IS
3031: CURSOR cur_segments(cp_org_id NUMBER, cp_prof_val VARCHAR2, cp_segments VARCHAR2) IS
3032: SELECT it.inventory_item_id
3033: FROM mtl_system_items_vl it, mtl_item_categories ic
3034: where it.inventory_item_id = ic.inventory_item_id
3035: and it.organization_id = ic.organization_id
3036: and it.organization_id = cp_org_id
3037: and ic.category_set_id = cp_prof_val

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

3071: BEGIN
3072:
3073: l_query :=
3074: 'SELECT it.inventory_item_id '||
3075: 'FROM mtl_system_items_vl it, mtl_item_categories ic '||
3076: 'where it.inventory_item_id = ic.inventory_item_id '||
3077: 'and it.organization_id = ic.organization_id '||
3078: 'and it.organization_id = :l_org_id '||
3079: 'and ic.category_set_id = :l_prof_val '||

Line 3115: FROM mtl_system_items_vl it, mtl_item_categories ic

3111: x_number OUT NOCOPY NUMBER
3112: ) RETURN NUMBER IS
3113: CURSOR cur_segments(cp_org_id NUMBER, cp_prof_val VARCHAR2, cp_segments VARCHAR2) IS
3114: SELECT it.inventory_item_id
3115: FROM mtl_system_items_vl it, mtl_item_categories ic
3116: where it.inventory_item_id = ic.inventory_item_id
3117: and it.organization_id = ic.organization_id
3118: and it.organization_id = cp_org_id
3119: and ic.category_set_id = cp_prof_val

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

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

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

3990:
3991: -- Fetch info for all platforms the solution links to
3992: CURSOR get_platform_info(c_set_id IN NUMBER) IS
3993: SELECT it.description,it.concatenated_segments
3994: FROM mtl_system_items_vl it, mtl_item_categories ic, cs_kb_set_platforms a
3995: where it.inventory_item_id = ic.inventory_item_id
3996: and it.organization_id = ic.organization_id
3997: and it.organization_id = cs_std.get_item_valdn_orgzn_id
3998: and ic.category_set_id = fnd_profile.value('CS_SR_PLATFORM_CATEGORY_SET')