APPS.EGO_ITEM_TEXT_UTIL dependencies on MTL_MFG_PART_NUMBERS

Line 347: , MTL_MFG_PART_NUMBERS mmpn

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;
351:

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 1063: FROM MTL_MFG_PART_NUMBERS

1059: , last_update_login = DECODE(p_last_update_login, FND_API.G_MISS_NUM, last_update_login, p_last_update_login)
1060: WHERE
1061: id_type = l_id_type
1062: AND (item_id,org_id) IN ( SELECT INVENTORY_ITEM_ID, ORGANIZATION_ID
1063: FROM MTL_MFG_PART_NUMBERS
1064: WHERE MANUFACTURER_ID = p_manufacturer_id );
1065: END IF;
1066:
1067:

Line 1070: -- Table MTL_MFG_PART_NUMBERS events

1066:
1067:
1068:
1069: -------------------------------------
1070: -- Table MTL_MFG_PART_NUMBERS events
1071: -------------------------------------
1072:
1073: ELSIF ( p_table_name = 'MTL_MFG_PART_NUMBERS' ) THEN
1074:

Line 1073: ELSIF ( p_table_name = 'MTL_MFG_PART_NUMBERS' ) THEN

1069: -------------------------------------
1070: -- Table MTL_MFG_PART_NUMBERS events
1071: -------------------------------------
1072:
1073: ELSIF ( p_table_name = 'MTL_MFG_PART_NUMBERS' ) THEN
1074:
1075: IF ( p_event = 'UPDATE' OR p_event= 'INSERT' ) THEN
1076:
1077: