APPS.PO_ATTRIBUTE_VALUES_PVT dependencies on MTL_SYSTEM_ITEMS_TL

Line 2724: FROM MTL_SYSTEM_ITEMS_TL MTL,

2720: TLP.attribute_values_tlp_id,
2721: MTL.description,
2722: MTL.language,
2723: MTL.long_description -- Bug7039409: Get long_description also
2724: FROM MTL_SYSTEM_ITEMS_TL MTL,
2725: FINANCIALS_SYSTEM_PARAMS_ALL FSP,
2726: PO_ATTRIBUTE_VALUES_TLP TLP
2727: WHERE TLP.inventory_item_id IS NOT NULL
2728: AND TLP.inventory_item_id <> g_ATTR_VALUES_NULL_ID -- '-2'

Line 6603: FROM mtl_system_items_tl

6599: -- Get LONG_DESCRIPTION
6600: BEGIN
6601: SELECT long_description
6602: INTO p_long_description
6603: FROM mtl_system_items_tl
6604: WHERE inventory_item_id = p_inventory_item_id
6605: AND organization_id = l_master_organization_id
6606: AND language = p_lang;
6607:

Line 6616: FROM mtl_system_items_tl

6612: -- If not found, get it for the base lang
6613: WHEN NO_DATA_FOUND THEN
6614: SELECT long_description
6615: INTO p_long_description
6616: FROM mtl_system_items_tl
6617: WHERE inventory_item_id = p_inventory_item_id
6618: AND organization_id = l_master_organization_id
6619: AND language = g_base_language;
6620: IF PO_LOG.d_stmt THEN