DBA Data[Home] [Help]

APPS.PON_VALIDATE_ITEM_PRICES_INT dependencies on MTL_SYSTEM_ITEMS_TL

Line 2243: mtl_system_items_tl msitl,

2239: decode(p1.item_description, 'ITEM_NONE_ENTERED', msitl.description, p1.item_description),
2240: msi.allow_item_desc_update_flag,
2241: decode(p1.unit_of_measure, 'UOM_NONE_ENTERED', uom.unit_of_measure_tl, p1.unit_of_measure)
2242: from mtl_system_items_kfv msi,
2243: mtl_system_items_tl msitl,
2244: mtl_units_of_measure_tl uom
2245: where msi.concatenated_segments = p1.item_number and
2246: msi.organization_id = l_inventory_org_id and
2247: nvl(msi.outside_operation_flag, 'N') = nvl(p1.outside_operation_flag, 'N') and

Line 2305: mtl_system_items_tl msitl

2301: item_number is not null and
2302: allow_item_desc_update_flag = 'N' and
2303: item_description <> (select msitl.description
2304: from mtl_system_items_kfv msi,
2305: mtl_system_items_tl msitl
2306: where msi.inventory_item_id = p1.item_id and
2307: msi.organization_id = l_inventory_org_id and
2308: msi.inventory_item_id = msitl.inventory_item_id and
2309: msi.organization_id = msitl.organization_id and