APPS.EGO_ITEM_PUB dependencies on MTL_ITEM_TEMPLATES

Line 2696: FROM mtl_item_templates mit

2692: ,x_msg_count OUT NOCOPY NUMBER) IS
2693:
2694: CURSOR c_get_context_org (cp_template_id IN NUMBER) IS
2695: SELECT context_organization_id
2696: FROM mtl_item_templates mit
2697: WHERE mit.template_id = cp_template_id;
2698:
2699: CURSOR c_get_template_attributes (cp_template_id IN NUMBER) IS
2700: SELECT attribute_name, attribute_value

Line 2771: FROM MTL_ITEM_TEMPLATES MIT

2767: GLOBAL_ATTRIBUTE17,
2768: GLOBAL_ATTRIBUTE18,
2769: GLOBAL_ATTRIBUTE19,
2770: GLOBAL_ATTRIBUTE20
2771: FROM MTL_ITEM_TEMPLATES MIT
2772: WHERE MIT.template_id = cp_template_id;
2773:
2774: l_org_id mtl_item_templates.context_organization_id%TYPE;
2775:

Line 2774: l_org_id mtl_item_templates.context_organization_id%TYPE;

2770: GLOBAL_ATTRIBUTE20
2771: FROM MTL_ITEM_TEMPLATES MIT
2772: WHERE MIT.template_id = cp_template_id;
2773:
2774: l_org_id mtl_item_templates.context_organization_id%TYPE;
2775:
2776: BEGIN
2777:
2778: l_org_id := NULL;