[Home] [Help]
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'
4800: l_type_lookup_code PO_HEADERS_ALL.type_lookup_code%TYPE;
4801: l_orig_ip_category_id PO_LINES_ALL.ip_category_id%TYPE;
4802: l_orig_item_description PO_ATTRIBUTE_VALUES_TLP.description%TYPE;
4803: l_orig_long_description PO_ATTRIBUTE_VALUES_TLP.long_description%TYPE;
4804: l_long_description MTL_SYSTEM_ITEMS_TL.long_description%TYPE;
4805: l_lead_time MTL_SYSTEM_ITEMS_B.full_lead_time%TYPE;
4806: l_orig_lead_time PO_ATTRIBUTE_VALUES.lead_time%TYPE;
4807: l_inventory_item_id PO_ATTRIBUTE_VALUES_TLP.inventory_item_id%TYPE;
4808: BEGIN
4968: -- if it does not match with master items long_description .
4969: -- SQL Join:
4970: SELECT long_description
4971: INTO l_long_description
4972: FROM mtl_system_items_tl
4973: WHERE inventory_item_id = l_inventory_item_id
4974: AND organization_id = p_org_id
4975: AND language = p_language;
4976:
6737: -- Get LONG_DESCRIPTION
6738: BEGIN
6739: SELECT long_description
6740: INTO p_long_description
6741: FROM mtl_system_items_tl
6742: WHERE inventory_item_id = p_inventory_item_id
6743: AND organization_id = l_master_organization_id
6744: AND language = p_lang;
6745:
6750: -- If not found, get it for the base lang
6751: WHEN NO_DATA_FOUND THEN
6752: SELECT long_description
6753: INTO p_long_description
6754: FROM mtl_system_items_tl
6755: WHERE inventory_item_id = p_inventory_item_id
6756: AND organization_id = l_master_organization_id
6757: AND language = g_base_language;
6758: IF PO_LOG.d_stmt THEN