DBA Data[Home] [Help]

APPS.EGO_ITEM_TEXT_UTIL dependencies on MTL_SYSTEM_ITEMS_TL

Line 274: , mtl_system_items_tl msitl

270: --, l_item_segments
271: , l_text
272: FROM
273: ego_item_text_tl eitl
274: , mtl_system_items_tl msitl
275: WHERE
276: eitl.rowid = p_rowid
277: AND msitl.inventory_item_id = eitl.item_id
278: AND msitl.organization_id = eitl.org_id

Line 320: , mtl_system_items_tl msitl

316: , l_item_catalog_group_id
317: , l_language
318: FROM
319: ego_item_text_tl eitl
320: , mtl_system_items_tl msitl
321: WHERE
322: eitl.rowid = p_rowid
323: AND msitl.inventory_item_id = eitl.item_id
324: AND msitl.organization_id = eitl.org_id

Line 458: mtl_system_items_tl msitl

454: msitl.description, msitl.long_description
455: INTO
456: v_description, v_long_description
457: FROM
458: mtl_system_items_tl msitl
459: WHERE
460: msitl.inventory_item_id = l_item_id
461: AND msitl.organization_id = l_org_id
462: AND msitl.language = l_language;

Line 920: IF ( p_table_name IN ('MTL_SYSTEM_ITEMS_B', 'MTL_SYSTEM_ITEMS_TL',

916: --DBMS_OUTPUT.put_line('==> p_table_name = '|| p_table_name || ' p_event = ' || p_event || ' p_scope = ' || p_scope);
917:
918: IF ( p_scope = 'ROW' ) THEN
919:
920: IF ( p_table_name IN ('MTL_SYSTEM_ITEMS_B', 'MTL_SYSTEM_ITEMS_TL',
921: 'EGO_MTL_SY_ITEMS_EXT_B', 'EGO_MTL_SY_ITEMS_EXT_TL',
922: 'MTL_ITEM_CATALOG_GROUPS_B') ) THEN
923: l_id_type := g_Internal_Type;
924: ELSIF ( p_table_name = 'MTL_CUSTOMER_ITEMS' ) THEN

Line 959: -- Table MTL_SYSTEM_ITEMS_TL events

955:
956: END IF; -- p_event
957:
958: -------------------------------------
959: -- Table MTL_SYSTEM_ITEMS_TL events
960: -------------------------------------
961:
962: ELSIF ( p_table_name = 'MTL_SYSTEM_ITEMS_TL' ) THEN
963:

Line 962: ELSIF ( p_table_name = 'MTL_SYSTEM_ITEMS_TL' ) THEN

958: -------------------------------------
959: -- Table MTL_SYSTEM_ITEMS_TL events
960: -------------------------------------
961:
962: ELSIF ( p_table_name = 'MTL_SYSTEM_ITEMS_TL' ) THEN
963:
964: --------------------------------------------------------------------
965: -- When invoked from the trigger, "mutating table" is not an issue
966: -- here because there is no select from mtl_system_items_tl.

Line 966: -- here because there is no select from mtl_system_items_tl.

962: ELSIF ( p_table_name = 'MTL_SYSTEM_ITEMS_TL' ) THEN
963:
964: --------------------------------------------------------------------
965: -- When invoked from the trigger, "mutating table" is not an issue
966: -- here because there is no select from mtl_system_items_tl.
967: --------------------------------------------------------------------
968:
969: IF ( p_event = 'INSERT' ) THEN
970: