APPS.EGO_ITEM_TEXT_UTIL dependencies on MTL_MANUFACTURERS

Line 346: FROM MTL_MANUFACTURERS mm

342: , mm.manufacturer_name
343: BULK COLLECT INTO
344: l_mpn_table
345: , l_mfg_table
346: FROM MTL_MANUFACTURERS mm
347: , MTL_MFG_PART_NUMBERS mmpn
348: WHERE mm.manufacturer_id = mmpn.manufacturer_id
349: AND mmpn.inventory_item_id = l_item_id
350: AND mmpn.organization_id = l_org_id;

Line 928: ELSIF( p_table_name IN ('MTL_MANUFACTURERS', 'MTL_MFG_PART_NUMBERS') ) THEN

924: ELSIF ( p_table_name = 'MTL_CUSTOMER_ITEMS' ) THEN
925: l_id_type := g_Customer_Type;
926: ELSIF ( p_table_name = 'MTL_CROSS_REFERENCES' ) THEN
927: l_id_type := p_id_type;
928: ELSIF( p_table_name IN ('MTL_MANUFACTURERS', 'MTL_MFG_PART_NUMBERS') ) THEN
929: l_id_type := g_Internal_Type;
930: END IF;--( p_scope = 'ROW' )
931:
932: ------------------------------------

Line 1049: -- Table MTL_MANUFACTURERS events

1045: END IF; -- p_event
1046:
1047:
1048: -------------------------------------
1049: -- Table MTL_MANUFACTURERS events
1050: -------------------------------------
1051:
1052: ELSIF ( p_table_name = 'MTL_MANUFACTURERS' ) THEN
1053: IF (p_manufacturer_id IS NOT NULL) THEN

Line 1052: ELSIF ( p_table_name = 'MTL_MANUFACTURERS' ) THEN

1048: -------------------------------------
1049: -- Table MTL_MANUFACTURERS events
1050: -------------------------------------
1051:
1052: ELSIF ( p_table_name = 'MTL_MANUFACTURERS' ) THEN
1053: IF (p_manufacturer_id IS NOT NULL) THEN
1054:
1055: UPDATE EGO_ITEM_TEXT_TL
1056: SET text = l_text_upd