APPS.EGO_ITEM_PUB dependencies on MTL_ITEM_TEMPLATES

Line 2545: FROM mtl_item_templates mit

2541: ,x_msg_count OUT NOCOPY NUMBER) IS
2542:
2543: CURSOR c_get_context_org (cp_template_id IN NUMBER) IS
2544: SELECT context_organization_id
2545: FROM mtl_item_templates mit
2546: WHERE mit.template_id = cp_template_id;
2547:
2548: CURSOR c_get_template_attributes (cp_template_id IN NUMBER) IS
2549: SELECT attribute_name, attribute_value

Line 2620: FROM MTL_ITEM_TEMPLATES MIT

2616: GLOBAL_ATTRIBUTE17,
2617: GLOBAL_ATTRIBUTE18,
2618: GLOBAL_ATTRIBUTE19,
2619: GLOBAL_ATTRIBUTE20
2620: FROM MTL_ITEM_TEMPLATES MIT
2621: WHERE MIT.template_id = cp_template_id;
2622:
2623: l_org_id mtl_item_templates.context_organization_id%TYPE;
2624:

Line 2623: l_org_id mtl_item_templates.context_organization_id%TYPE;

2619: GLOBAL_ATTRIBUTE20
2620: FROM MTL_ITEM_TEMPLATES MIT
2621: WHERE MIT.template_id = cp_template_id;
2622:
2623: l_org_id mtl_item_templates.context_organization_id%TYPE;
2624:
2625: BEGIN
2626:
2627: l_org_id := NULL;